From: Bill Moran <wmoran@collaborativefusion.com>
To: John Beaver <john.e.beaver@gmail.com>
Cc: Gaetano Mendola <mendola@gmail.com>
Cc: Pgsql-Performance <pgsql-performance@postgresql.org>
Subject: Re: large tables and simple "= constant" queries using indexes
Date: Thu, 10 Apr 2008 13:08:54 -0400
Message-ID: <20080410130854.f3a3f110.wmoran@collaborativefusion.com> (raw)
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>
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
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-performance@postgresql.org
Cc: wmoran@collaborativefusion.com, john.e.beaver@gmail.com, mendola@gmail.com
Subject: Re: large tables and simple "= constant" queries using indexes
In-Reply-To: <20080410130854.f3a3f110.wmoran@collaborativefusion.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox