Re: Explain's estimation differs from real count enormously

From: Grzegorz Jaśkiewicz <gryzman(at)gmail(dot)com>
To: "Sergey Konoplev" <gray(dot)ru(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 11:58:19
Message-ID: 2f4958ff0810230458w17cd9c4dleffbec8cc84ffe29@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 ?

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Sergey Konoplev 2008-10-23 12:02:21 Re: Explain's estimation differs from real count enormously
Previous Message Grzegorz Jaśkiewicz 2008-10-23 11:48:29 Re: max time in a table query takes ages