From: Aaron Bono <postgresql@aranya.com>
To: Andrew Sullivan <ajs@crankycanuck.ca>
Cc: pgsql-sql@postgresql.org
Subject: Re: Sequence vs. Index Scan
Date: Sat, 5 May 2007 17:00:53 -0500
Message-ID: <bf05e51c0705051500p3e3de711na0d76ae1ad463775@mail.gmail.com> (raw)
In-Reply-To: <20070505213009.GA22573@phlogiston.dyndns.org>
References: <bf05e51c0705051405p29ee139fn30c9979f3772a1d4@mail.gmail.com>
<20070505213009.GA22573@phlogiston.dyndns.org>
On 5/5/07, Andrew Sullivan <ajs@crankycanuck.ca> wrote:
>
> On Sat, May 05, 2007 at 04:05:52PM -0500, Aaron Bono wrote:
> > I have two schemas, both with the exact same DDL. One performs great
> and
>
> Do they have the same data?
They have different data. The fast one has about 150 rows and the slow one
has about 40 rows. The field in question here, the branch_id, is a
BIGSERIAL in both.
> I have
> > checked and there IS an index, specifically a primary key index, on the
> > branch_id in both schemas so I cannot figure out why the optimizer is
> > looking at these differently. In fact, the table the branch_id comes
> from
> > has the exact same indices and foreign keys on both schemas.
>
> Different data? Different statistics? Different numbers of
> (possibly dead) rows?
We don't allow deletes and updates are fairly infrequent. I also did a
vacuum analyze to no effect.
What can I do to get more statistics that would help?
Thanks for the help,
Aaron
--
==================================================================
Aaron Bono
Aranya Software Technologies, Inc.
http://www.aranya.comhttp://codeelixir.com
==================================================================
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-sql@postgresql.org
Cc: postgresql@aranya.com, ajs@crankycanuck.ca
Subject: Re: Sequence vs. Index Scan
In-Reply-To: <bf05e51c0705051500p3e3de711na0d76ae1ad463775@mail.gmail.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