On Thu, Sep 01, 2005 at 02:04:54PM -0400, Merlin Moncure wrote: > > Any help most gratefully received (even if it's to say that I should > be > > posting to a different mailing list!). > > this is correct list. did you run vacuum/analyze, etc? > Please post vacuum analyze times.
2005-09-01 19:47:08 LOG: statement: vacuum full analyze address; 2005-09-01 19:48:44 LOG: duration: 96182.777 ms 2005-09-01 19:50:20 LOG: statement: vacuum analyze address; 2005-09-01 19:51:48 LOG: duration: 87675.268 ms I run them regularly, pretty much after every bulk import. Matthew ---------------------------(end of broadcast)--------------------------- TIP 2: Don't 'kill -9' the postmaster
