On 12/12/05, Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> wrote:
>
> Mike C <smith(dot)not(dot)western(at)gmail(dot)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