Re: Explain's estimation differs from real count enormously

From: "Sergey Konoplev" <gray(dot)ru(at)gmail(dot)com>
To: Grzegorz Jaśkiewicz <gryzman(at)gmail(dot)com>
Cc: "pgsql-general(at)postgresql(dot)org >> PG-General Mailing List" <pgsql-general(at)postgresql(dot)org>
Subject: Re: Explain's estimation differs from real count enormously
Date: 2008-10-23 12:02:21
Message-ID: c3a7de1f0810230502l1d603f36o38a5e569cf31dd2f@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

> run vacuum analyze <table>; before running that query, is it still off after
> that ?
>

I forgot to mention that ANALYZE, VACUUM ANALYZE even w/ FULL and
REINDEX doesn't help.

--
Regards,
Sergey Konoplev
--
PostgreSQL articles in english & russian
http://gray-hemp.blogspot.com/search/label/postgresql/

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Mikkel Hgh 2008-10-23 12:20:49 Re: Database design for separate tsearch table
Previous Message Grzegorz Jaśkiewicz 2008-10-23 11:58:19 Re: Explain's estimation differs from real count enormously