Re: [HACKERS] Improve lseek scalability v3

From: Stephen Frost
Date: Mon Sep 19 2011 - 08:40:45 EST


* Benjamin LaHaise (bcrl@xxxxxxxxx) 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

Attachment: signature.asc
Description: Digital signature