Date: Thu, 10 Apr 2008 13:08:54 -0400
From: Bill Moran <wmoran@collaborativefusion.com>
To: John Beaver <john.e.beaver@gmail.com>
Cc: Gaetano Mendola <mendola@gmail.com>,
	Pgsql-Performance <pgsql-performance@postgresql.org>
Subject: Re: large tables and simple "= constant" queries using
 indexes
Message-Id: <20080410130854.f3a3f110.wmoran@collaborativefusion.com>
In-Reply-To: <47FE4259.7030704@gmail.com>
References: <47FD2DF3.80500@gmail.com> <47FD3350.4060504@tweakers.net>
	<47FD4212.8040404@gmail.com> <47FDBE23.8020402@tweakers.net>
	<op.t9dy1aqwcigqcu@apollo13.peufeu.com>
	<Pine.LNX.4.64.0804101042050.20402@aragorn.flymine.org>
	<47FE27EB.8050804@gmail.com> <47FE3DC7.4010700@gmail.com>
	<47FE4259.7030704@gmail.com>
Organization: Collaborative Fusion
Mime-Version: 1.0
Content-Type: text/plain; charset=US-ASCII
Content-Transfer-Encoding: 7bit

In response to John Beaver <john.e.beaver@gmail.com>:

> Thanks Eric and Gaestano - interesting, and both examples of my naivite. :)
> 
> I tried running large select(*) queries on other tables followed by another try at the offending query, and it was still fast. Just to be absolutely sure this is a scalable solution, I'll try restarting my computer in a few hours to see if it affects anything cache-wise.

I say this over and over again ... because I think it's really cool and
useful.

If you install the pg_buffercache addon, you can actually look into
PostgreSQL's internals and see what tables are in the buffer in real
time.  If you're having trouble, it can (potentially) be a helpful
tool.

-- 
Bill Moran
Collaborative Fusion Inc.
http://people.collaborativefusion.com/~wmoran/

wmoran@collaborativefusion.com
Phone: 412-422-3463x4023