Postgres Pro
Downloads
Home   >   mailing lists

Re: planner, newly added records and most common values - Mailing list pgsql-general

From Andrew Sullivan
Subject Re: planner, newly added records and most common values
Date
Msg-id 20120120024019.GA4365@crankycanuck.ca
Whole thread Raw
In response to planner, newly added records and most common values  (Jeff Amiel <becauseimjeff@yahoo.com>)
List pgsql-general
Tree view 
On Thu, Jan 19, 2012 at 05:36:26PM -0800, Jeff Amiel wrote:

> I COULD do an analyze after loading the file...but there is no guarantee that the file I just loaded will end up in
themost common value list....and I end up with bad plan. 
>

Sounds like you need to SET STATISTICS higher for that column and do
the analyse.  Have you tried that?

A

--
Andrew Sullivan
ajs@crankycanuck.ca

pgsql-general by date:

Previous
From: Jeff Amiel
Date:
Subject: planner, newly added records and most common values
Next
From: Mark van Leeuwen
Date:
Subject: Exclusive row locks not release