On 12/12/05, Tom Lane <[EMAIL PROTECTED]> wrote:
Mike C <[EMAIL PROTECTED]> 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 via email to