From: | Neil Conway <nconway(at)klamath(dot)dyndns(dot)org> |
---|---|
To: | pgsql-general(at)postgresql(dot)org |
Subject: | Re: explain -> how to optimize? |
Date: | 2001-03-07 23:39:30 |
Message-ID: | 20010307183930.C1854@klamath.dyndns.org |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
On Wed, Mar 07, 2001 at 11:24:34AM -0600, will trillich wrote:
> here's an EXPLAIN on a VIEW which links a few tables:
Can you give us the definition of the VIEW?
Also, what kinds of data are you dealing with? Stuff like the
# of rows. Are the planner estimate's below reasonable?
[...]
> okay, there's a ton of sorts and so forth in there that don't
> seem to be needed; plus i'm sure i've got indexes on the
> linked-to tables, so why the SEQ scans, i dunno.
It's using SEQ scans because it thinks they're faster than index scans --
in this case, is the planner incorrect?
HTH,
Neil
--
Neil Conway <neilconway(at)home(dot)com>
Get my GnuPG key from: http://klamath.dyndns.org/mykey.asc
Encrypted mail welcomed
In the beginning the Universe was created. This has made a lot of
people very angry and been widely regarded as a bad move.
-- Douglas Adams
From | Date | Subject | |
---|---|---|---|
Next Message | Stephan Szabo | 2001-03-07 23:54:02 | Re: inheritance and primary/foreign keys |
Previous Message | Daniel J. Kressin | 2001-03-07 23:32:06 | inheritance and primary/foreign keys |