Re: Improve lseek scalability v3

* Benjamin LaHaise (bcrl@kvack.org) wrote:
> For such tables, can't Postgres track the size of the file internally?  I'm 
> assuming it's keeping file descriptors open on the tables it manages, in 
> which case when it writes to a file to extend it, the internally stored size 
> could be updated.  Not making a syscall at all would scale far better than 
> even a modified lseek() will perform.

We'd have to have it in shared memory and have a lock around it, it
wouldn't be cheap at all.
Thanks,		Stephen