I did the re-analyze serveral times, using the command: ANALYZE tablename;
Is there any other command as well or another way to do that? On Mon, Feb 1, 2010 at 12:04 PM, Scott Marlowe <scott.marl...@gmail.com> wrote: > On Sun, Jan 31, 2010 at 6:02 PM, Dave Clements <dclement...@gmail.com> wrote: >> Hi, following the output from explain analyze. > > Without doing any heavy analysis, it looks like your row estimates are > way off. Have you cranked up stats target and re-analyzed yet? > -- Sent via pgsql-sql mailing list (pgsql-sql@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-sql