On Aug 9, 10:47 pm, t...@xxxxxxxxxxxxx (Tom Lane) wrote: > Do you have comparable work_mem settings on both machines? Another > thing to look at, if any of the sort key columns are textual, is whether > the lc_collate settings are the same. work_mem is commented out in both postgresql.conf files: desktop: #work_mem = 1MB production: #work_mem = 1024 So I guess they use the defaults? Ahh, but lc_collate is different (assuming I'm finding it right). On my machine it's set to "C", and on the production server it's set to "en_US.UTF-8". I'm going to have to do some research to figure out what that does. ---------------------------(end of broadcast)--------------------------- TIP 2: Don't 'kill -9' the postmaster
