Skip site navigation (1) Skip section navigation (2)

Re: Whether the function exists a in pgsql table or not?

From: Greg Smith <greg(at)2ndQuadrant(dot)com>
To: pgsql-general(at)postgresql(dot)org
Subject: Re: Whether the function exists a in pgsql table or not?
Date: 2011-08-29 03:00:35
Message-ID: (view raw or whole thread)
Lists: pgsql-general
On 08/27/2011 01:21 PM, shuaixf wrote:
> In Oracle, when the table has few records, used frequently, it would use
> "storage(buffer_pool keep)" to keep the data in cache instead of LRU
> algorithm.
> if the function exists in a pgsql table or not?

There aren't any controls to pin a table into memory in PostgreSQL.  The 
way the database uses both its dedicated buffer cache as well as the OS 
one, it's hard to even define such a UI that would make sense--the 
database doesn't have any control or interaction with the OS cache.

The mechanism for deciding what stays in the PostgreSQL cache is a bit 
more complicated than an LRU, while the one in the OS probably is a 
LRU.  If the table is used frequently, it's very likely to stay in one 
of the two caches anyway.

Greg Smith   2ndQuadrant US    greg(at)2ndQuadrant(dot)com   Baltimore, MD
PostgreSQL Training, Services, and 24x7 Support  www.2ndQuadrant.

In response to


pgsql-general by date

Next:From: Adarsh SharmaDate: 2011-08-29 04:33:27
Subject: Get data back after drop Command
Previous:From: Lonni J FriedmanDate: 2011-08-29 01:57:57
Subject: Re: pg_restore with -j fails (works without -j option)

Privacy Policy | About PostgreSQL
Copyright © 1996-2015 The PostgreSQL Global Development Group