Re: Bug: Buffer cache is not scan resistant

Поиск
Список
Период
Сортировка
От Jeff Davis
Тема Re: Bug: Buffer cache is not scan resistant
Дата
Msg-id 1173204582.13722.418.camel@dogma.v10.wvs
обсуждение исходный текст
Ответ на Re: Bug: Buffer cache is not scan resistant  (Tom Lane <tgl@sss.pgh.pa.us>)
Список pgsql-hackers
On Tue, 2007-03-06 at 12:59 -0500, Tom Lane wrote:
> Jeff Davis <pgsql@j-davis.com> writes:
> > If I were to implement this idea, I think Heikki's bitmap of pages
> > already read is the way to go.
> 
> I think that's a good way to guarantee that you'll not finish in time
> for 8.3.  Heikki's idea is just at the handwaving stage at this point,
> and I'm not even convinced that it will offer any win.  (Pages in
> cache will be picked up by a seqscan already.)
> 

I agree that it's a good idea stick with the current implementation
which is, as far as I can see, meeting all of my performance goals.

Regards,Jeff Davis





В списке pgsql-hackers по дате отправления:

Предыдущее
От: Gregory Stark
Дата:
Сообщение: Re: Plan invalidation vs. unnamed prepared statements
Следующее
От: Tom Lane
Дата:
Сообщение: Re: Plan invalidation vs. unnamed prepared statements