From: Rafael Martinez <r.m.guerrero@usit.uio.no>
To: Jim C. Nasby <jnasby@pervasive.com>
Cc: Dave Dutcher <dave@tridecap.com>
Cc: pgsql-performance@postgresql.org
Subject: Re: Help with optimizing a sql statement
Date: Thu, 09 Feb 2006 23:44:42 +0100
Message-ID: <1139525082.19758.6.camel@linux.site> (raw)
In-Reply-To: <20060209194603.GX57845@pervasive.com>
References: <20060209193345.GV57845@pervasive.com>
<001f01c62db1$3a380910$8300a8c0@tridecap.com>
<20060209194603.GX57845@pervasive.com>
On Thu, 2006-02-09 at 13:46 -0600, Jim C. Nasby wrote:
> I looked at the estimates for the table access methods and they all
> looked ok, so I think the statistics are pretty up-to-date; there just
> aren't enough of them for the planner to do a good job.
>
VACUUM ANALYZE runs 4 times every hour, so yes, statistics are
up-to-date. I will increase default_statistics_target tomorrow at work
and see what happens.
Thanks for your help.
--
Rafael Martinez, <r.m.guerrero@usit.uio.no>
Center for Information Technology Services
University of Oslo, Norway
PGP Public Key: http://folk.uio.no/rafael/
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-performance@postgresql.org
Cc: r.m.guerrero@usit.uio.no, jnasby@pervasive.com, dave@tridecap.com
Subject: Re: Help with optimizing a sql statement
In-Reply-To: <1139525082.19758.6.camel@linux.site>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox