From: Neil Conway <neilc@samurai.com>
To: Richard Huxton <dev@archonet.com>
Cc: Siva Kumar <tech@leatherlink.net>
Cc: pgsql-general@postgresql.org
Subject: Re: Query optimization
Date: 04 Oct 2002 08:10:37 -0400
Message-ID: <87adlube0y.fsf@mailbox.samurai.com> (raw)
In-Reply-To: <200210041114.17241.dev@archonet.com>
References: <200210041347.55055.tech@leatherlink.net>
<200210041114.17241.dev@archonet.com>
Richard Huxton <dev@archonet.com> writes:
> First stage though, run an EXPLAIN and if you need help understanding it post
> the output back to the list.
Yep, that's a good idea. Another thing to try is to disable GEQO (SET
geqo = off;) and see what difference that makes to the performance of
the optimizer and the quality of the chosen plan (12 relations is
close to the cross-over point for the useability of the genetic
optimizer, IME).
Also, your comment regarding slow access over the Internet is not a
problem with PostgreSQL -- if it really *is* 2x or so slower when done
remotely, talk to your network admin.
Cheers,
Neil
--
Neil Conway <neilc@samurai.com> || PGP Key ID: DB3C29FC
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-general@postgresql.org
Cc: neilc@samurai.com, dev@archonet.com, tech@leatherlink.net
Subject: Re: Query optimization
In-Reply-To: <87adlube0y.fsf@mailbox.samurai.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