On Tue, 2005-08-02 at 16:06, Dr NoName wrote: > The solution to my problem was to increase statistics > value and do another analyze. You can also change > default_statistics_target parameter in > postgresql.conf. Don't know if that's related to the > problem you're seeing, but it's worth a try. Cool postgresql trick: alter database test set default_statistics_target=200; You can change the default for a databases's new tables too. ---------------------------(end of broadcast)--------------------------- TIP 2: Don't 'kill -9' the postmaster
