From: Tom Lane <tgl@sss.pgh.pa.us>
To: Mike C <smith.not.western@gmail.com>
Cc: pgsql-performance@postgresql.org
Subject: Re: Table Partitions / Partial Indexes
Date: Sun, 11 Dec 2005 21:39:08 -0500
Message-ID: <20805.1134355148@sss.pgh.pa.us> (raw)
In-Reply-To: <bd0eabd0512111807q6b54115q2477c7c2a37f1c1a@mail.gmail.com>
References: <bd0eabd0512111807q6b54115q2477c7c2a37f1c1a@mail.gmail.com>
Mike C <smith.not.western@gmail.com> writes:
> CLUSTER on PC_TRAFFIC_IDX3 gives me significantly improved performance:
How can you tell? Neither of these are EXPLAIN ANALYZE output.
regards, tom lane
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: tgl@sss.pgh.pa.us, smith.not.western@gmail.com
Subject: Re: Table Partitions / Partial Indexes
In-Reply-To: <20805.1134355148@sss.pgh.pa.us>
* 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