Re: planner, newly added records and most common values

From: Andrew Sullivan <ajs(at)crankycanuck(dot)ca>
To: pgsql-general(at)postgresql(dot)org
Subject: Re: planner, newly added records and most common values
Date: 2012-01-20 02:40:19
Message-ID: 20120120024019.GA4365@crankycanuck.ca
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

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 the most 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(at)crankycanuck(dot)ca

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Mark van Leeuwen 2012-01-20 05:05:04 Exclusive row locks not release
Previous Message Jeff Amiel 2012-01-20 01:36:26 planner, newly added records and most common values