Re: Improve lseek scalability v3 - Mailing list pgsql-hackers

From Stephen Frost
Subject Re: Improve lseek scalability v3
Date
Msg-id 20110919123100.GJ12765@tamriel.snowman.net
Whole thread Raw
In response to Re: Improve lseek scalability v3  (Benjamin LaHaise <bcrl@kvack.org>)
Responses Re: Improve lseek scalability v3
Re: Improve lseek scalability v3
List pgsql-hackers
* 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

pgsql-hackers by date:

Previous
From: Thom Brown
Date:
Subject: Re: CUDA Sorting
Next
From: Robert Haas
Date:
Subject: Re: Improve lseek scalability v3