From: Carlos Moreno <moreno_pg@mochima.com>
Cc: pgsql-performance@postgresql.org
Subject: Re: Seqscan/Indexscan still a known issue?
Date: Sat, 27 Jan 2007 16:14:44 -0500
Message-ID: <45BBC0C4.9020204@mochima.com> (raw)
In-Reply-To: <6888.1169918891@sss.pgh.pa.us>
References: <45BAB682.6060709@mochima.com>
<45BB214E.3090907@fuzzy.cz>
<45BB873C.4000304@mochima.com>
<6888.1169918891@sss.pgh.pa.us>
Tom Lane wrote:
> One reason you might consider updating is that newer versions check the
>
>physical table size instead of unconditionally believing
>pg_class.relpages/reltuples. Thus, they're much less likely to get
>fooled when a table has grown substantially since it was last vacuumed
>or analyzed.
>
>
Sounds good. Obviously, there seem to be plenty of reasons to
upgrade, as pointed out in several of the previous replies; I
would not rank this one as one of the top reasons to upgrade,
since every time I've encountered this issue (planner selecting
seq. scan when I'm convinced it should choose an index scan), I
can always get away with forcing it to use an index scan, even
if it feels like the wrong solution.
But still, I guess what you point out comes as part of an array
of improvements that will contribute to much better performance
anyway!
I'm sure I've said it countless times, but it feels again like
the right time to say it: thank you so much for all the help
and all the effort the PG team has put in making this such a
great product --- improvement after improvement!
Thanks,
Carlos
--
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: moreno_pg@mochima.com
Subject: Re: Seqscan/Indexscan still a known issue?
In-Reply-To: <45BBC0C4.9020204@mochima.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