Re: Priority table or Cache table
Tom Lane <tgl@sss.pgh.pa.us>
From: Tom Lane <tgl@sss.pgh.pa.us>
To: Haribabu Kommi <kommi.haribabu@gmail.com>
Cc: "pgsql-hackers@postgresql.org" <pgsql-hackers@postgresql.org>
Date: 2014-02-20T00:38:20Z
Lists: pgsql-hackers
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? I am really dubious that letting DBAs manage buffers is going to be an improvement over automatic management. regards, tom lane