From: Mike C <smith.not.western@gmail.com>
To: pgsql-performance@postgresql.org
Subject: Re: Table Partitions / Partial Indexes
Date: Mon, 12 Dec 2005 15:49:10 +1300
Message-ID: <bd0eabd0512111849q4b967bf0scb14d1b47993a370@mail.gmail.com> (raw)
In-Reply-To: <20805.1134355148@sss.pgh.pa.us>
References: <bd0eabd0512111807q6b54115q2477c7c2a37f1c1a@mail.gmail.com>
<20805.1134355148@sss.pgh.pa.us>
On 12/12/05, Tom Lane <tgl@sss.pgh.pa.us> wrote:
>
> 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
Sorry that's a result of my bad record keeping. I've been keeping records of
the explain but not the analyze. IIRC the times dropped from ~25 seconds
down to ~8 seconds (using analyze).
Regards,
Mike
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: smith.not.western@gmail.com
Subject: Re: Table Partitions / Partial Indexes
In-Reply-To: <bd0eabd0512111849q4b967bf0scb14d1b47993a370@mail.gmail.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