Re: Priority table or Cache table

Поиск
Список
Период
Сортировка
От Haribabu Kommi
Тема Re: Priority table or Cache table
Дата
Msg-id CAJrrPGejxVZ5-tavN95PWeQx+WPSf733wdVXSbs7w2JsGyuYLQ@mail.gmail.com
обсуждение исходный текст
Ответ на Re: Priority table or Cache table  (Tom Lane <tgl@sss.pgh.pa.us>)
Ответы Re: Priority table or Cache table  (Amit Kapila <amit.kapila16@gmail.com>)
Список pgsql-hackers
Дерево обсуждения
On Thu, Feb 20, 2014 at 11:38 AM, Tom Lane <tgl@sss.pgh.pa.us> wrote:
Haribabu Kommi <kommi.haribabu@gmail.com> writes:
> I want to propose a new feature called "priority table" or "cache table".
> This is same as regular table except the pages of these tables are having
> high priority than normal tables. These tables are very useful, where a
> faster query processing on some particular tables is expected.

Why exactly does the existing LRU behavior of shared buffers not do
what you need?

Lets assume a database having 3 tables, which are accessed regularly. The user is expecting a faster query results on one table.
Because of LRU behavior which is not happening some times. So if we just separate those table pages into an another buffer
pool then all the pages of that table resides in memory and gets faster query processing.
 
Regards,
Hari Babu
Fujitsu Australia

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

Предыдущее
От: Michael Paquier
Дата:
Сообщение: Re: Re: [COMMITTERS] pgsql: Add a GUC to report whether data page checksums are enabled.
Следующее
От: Michael Paquier
Дата:
Сообщение: Re: should we add a XLogRecPtr/LSN SQL type?