bob_lunney@xxxxxxxxx writes: > Why would changing the column order on a unique index cause data loading or index servicing to slow down? Page splits in the b-tree, maybe? Yeah, perhaps. Tell us about the data distributions in the columns? Is there any ordering to the keys that're being inserted? It's not in the least surprising that different column orders might be better or worse suited for particular queries. I'm mildly interested in the question of why the bulk load speed is different, though. regards, tom lane -- Sent via pgsql-performance mailing list (pgsql-performance@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-performance
