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).