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

Re: Indices pinned in pageable RAM?

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Marty Scholes <marty(at)outputservices(dot)com>
Cc: pgsql-hackers(at)postgresql(dot)org
Subject: Re: Indices pinned in pageable RAM?
Date: 2004-06-03 05:03:42
Message-ID: 17182.1086239022@sss.pgh.pa.us (view raw or flat)
Thread:
Lists: pgsql-hackers
Marty Scholes <marty(at)outputservices(dot)com> writes:
> Has anyone seriously looked at how it would impact things to give the 
> DBA the option of storing certain indices in RAM instead of on disk?

I'd classify it as an utter waste of time.  If the index is being hit
heavily, it will stay cached in RAM anyway.  If it isn't, locking it in
RAM would be a pessimization not an optimization, because the space
would be better used for something else.

			regards, tom lane

In response to

pgsql-hackers by date

Next:From: Andreas PflugDate: 2004-06-03 08:10:10
Subject: Re: Compiling libpq with VisualC
Previous:From: Tom LaneDate: 2004-06-03 04:18:24
Subject: Re: [pgsql-hackers-win32] select like...not using index

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