Re: large tables and simple "= constant" queries using indexes

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
stillfast. Just to be absolutely sure this is a scalable solution, I'll try restarting my computer in a few hours to
seeif 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