Re: Stopgap solution for table-size-estimate updatingproblem - Mailing list pgsql-hackers

From Zeugswetter Andreas DAZ SD
Subject Re: Stopgap solution for table-size-estimate updatingproblem
Date
Msg-id 46C15C39FEB2C44BA555E356FBCD6FA40184D251@m0114.s-mxs.net
Whole thread Raw
List pgsql-hackers
>> I think I recall that lseek may have a negative effect on some OS's
>> readahead calculations (probably only systems that cannot handle an
>> lseek to the next page eighter) ? Do you think we should cache the
>> last value to avoid the syscall ?
>
> We really can't, since the point of doing it is to find out whether any
> other backends have extended the file since we last looked.  Also, IIRC

Well yes. The value would need to be kept ajour by the backends that
extend, with an interlocked increment. We would thus need to keep the
count in shmem.

Andreas


pgsql-hackers by date:

Previous
From: Thomas Hallgren
Date:
Subject: Re: Error handling in plperl and pltcl
Next
From: Kris Jurka
Date:
Subject: Re: multiline CSV fields