From: | Neil Conway <neilc(at)samurai(dot)com> |
---|---|
To: | Richard Huxton <dev(at)archonet(dot)com> |
Cc: | Siva Kumar <tech(at)leatherlink(dot)net>, pgsql-general(at)postgresql(dot)org |
Subject: | Re: Query optimization |
Date: | 2002-10-04 12:10:37 |
Message-ID: | 87adlube0y.fsf@mailbox.samurai.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
Richard Huxton <dev(at)archonet(dot)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(at)samurai(dot)com> || PGP Key ID: DB3C29FC
From | Date | Subject | |
---|---|---|---|
Next Message | Siva Kumar | 2002-10-04 12:26:35 | Re: Query optimization |
Previous Message | Darrell Skogman | 2002-10-04 11:54:19 | Performing INSERT from a Trigger fired function |