Re: Stopgap solution for table-size-estimate updatingproblem

Поиск
Список
Период
Сортировка
От Zeugswetter Andreas DAZ SD
Тема Re: Stopgap solution for table-size-estimate updatingproblem
Дата
Msg-id 46C15C39FEB2C44BA555E356FBCD6FA40184D251@m0114.s-mxs.net
обсуждение исходный текст
Список 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 по дате отправления:

Предыдущее
От: Thomas Hallgren
Дата:
Сообщение: Re: Error handling in plperl and pltcl
Следующее
От: Kris Jurka
Дата:
Сообщение: Re: multiline CSV fields