Postgres Pro
Downloads
Home   >   mailing lists

Re: Explain's estimation differs from real count enormously - Mailing list pgsql-general

From Sergey Konoplev
Subject Re: Explain's estimation differs from real count enormously
Date
Msg-id c3a7de1f0810230502l1d603f36o38a5e569cf31dd2f@mail.gmail.com
Whole thread Raw
In response to Re: Explain's estimation differs from real count enormously  ("Grzegorz Jaśkiewicz" <gryzman@gmail.com>)
List pgsql-general
Tree view 
> 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/

pgsql-general by date:

Previous
From: "Grzegorz Jaśkiewicz"
Date:
Subject: Re: Explain's estimation differs from real count enormously
Next
From: Mikkel Høgh
Date:
Subject: Re: Database design for separate tsearch table