Question about shared_buffer cache behavior

Поиск
Список
Период
Сортировка
От Paul Jones
Тема Question about shared_buffer cache behavior
Дата
Msg-id 20160318202422.GA6069@cmicdo.com
обсуждение исходный текст
Ответы Re: Question about shared_buffer cache behavior  (Andreas Kretschmer <andreas@a-kretschmer.de>)
Re: Question about shared_buffer cache behavior  (Rakesh Kumar <rakeshkumar464a3@gmail.com>)
Список pgsql-general
In Postgres 9.5.1 with a shared_buffer cache of 7Gb, a SELECT from
a single table that uses an index appears to read the table into the
shared_buffer cache.  Then, as many times as the exact same SELECT is
repeated in the same session, it runs blazingly fast and doesn't even
touch the disk.  All good.

Now, in the *same* session, if a different SELECT from the *same* table,
using the *same* index is run, it appears to read the entire table from
disk again.

Why is this?  Is there something about the query that qualifies the
contents of the share_buffer cache?  Would this act differently for
different kinds of indexes?

PJ


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

Предыдущее
От: avi Singh
Дата:
Сообщение: grant select on pg_stat_activity
Следующее
От: Andreas Kretschmer
Дата:
Сообщение: Re: Question about shared_buffer cache behavior