From: Shaun Thomas <sthomas@leapfrogonline.com>
To: Jim C. Nasby <jnasby@pervasive.com>
Cc: pgsql-performance@postgresql.org
Cc: Tom Lane <tgl@sss.pgh.pa.us>
Subject: Re: Confirmation of bad query plan generated by 7.4
Date: Tue, 13 Jun 2006 16:35:41 -0500
Message-ID: <448EE95D.8F27.00A9.0@leapfrogonline.com> (raw)
In-Reply-To: <20060613211347.GB34196@pervasive.com>
References: <9119.1150222168@sss.pgh.pa.us>
<448EDFC4.8F27.00A9.0@leapfrogonline.com>
<20060613211347.GB34196@pervasive.com>
>>> On 6/13/2006 at 4:13 PM, "Jim C. Nasby" <jnasby@pervasive.com>
wrote:
> Is there some compelling reason to stick with 7.4? In my experience
> you'll see around double (+100%) the performance going to 8.1...
Not really. We *really* want to upgrade, but we're in the middle of
buying the new machine right now. There's also the issue of migrating
37GB of data which I don't look forward to, considering we'll need to
set up a slony replication for the entire thing to avoid the hours
of downtime necessary for a full dump/restore.
> What's your stats target set to for that table?
Not sure what you mean by that. It's just that this table has 27M
rows
extending over 4 years, and I'm not quite sure how to hint to that.
An index scan for a few days would be a tiny fraction of the entire
table, so PG being insistent on the sequence scans was confusing the
hell
out of me.
--
Shaun Thomas
Database Administrator
Leapfrog Online
807 Greenwood Street
Evanston, IL 60201
Tel. 847-440-8253
Fax. 847-570-5750
www.leapfrogonline.com
Confidentiality Note:
The document(s) accompanying this e-mail transmission, if any, and the
e-mail transmittal message contain information from Leapfrog Online
Customer Acquisition, LLC is confidential or privileged. The information
is intended to be for the use of the individual(s) or entity(ies) named
on this e-mail transmission message. If you are not the intended
recipient, be aware that any disclosure, copying, distribution or use of
the contents of this e-mail is prohibited. If you have received this
e-mail in error, please immediately delete this e-mail and notify us by
telephone of the error
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: sthomas@leapfrogonline.com, jnasby@pervasive.com, tgl@sss.pgh.pa.us
Subject: Re: Confirmation of bad query plan generated by 7.4
In-Reply-To: <448EE95D.8F27.00A9.0@leapfrogonline.com>
* 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