Search Postgresql Archives

Re: Explain's estimation differs from real count enormously

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

To: "Sergey Konoplev" <gray.ru@xxxxxxxxx>
Subject: Re: Explain's estimation differs from real count enormously
From: "Grzegorz Jaśkiewicz" <gryzman@xxxxxxxxx>
Date: Thu, 23 Oct 2008 12:58:19 +0100
Cc: "pgsql-general@xxxxxxxxxxxxxx >> PG-General Mailing List" <pgsql-general@xxxxxxxxxxxxxx>
In-reply-to: <c3a7de1f0810230411r61268d71m94b90a67cfbe87e8@xxxxxxxxxxxxxx>

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

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

Follow-Ups:
- Re: Explain's estimation differs from real count enormously
  - From: Sergey Konoplev

References:
- Explain's estimation differs from real count enormously
  - From: Sergey Konoplev

Prev by Date: Re: max time in a table query takes ages
Next by Date: Re: Explain's estimation differs from real count enormously
Previous by thread: Explain's estimation differs from real count enormously
Next by thread: Re: Explain's estimation differs from real count enormously
Index(es):
- Date
- Thread

[Index of Archives] [Postgresql Jobs] [Postgresql Admin] [Postgresql Performance] [Linux Clusters] [PHP Home] [PHP on Windows] [Kernel Newbies] [PHP Classes] [PHP Books] [PHP Databases] [Postgresql & PHP] [Yosemite]

Powered by Linux