From: SZŰCS Gábor <surrano@mailbox.hu>
To: pgsql-performance@postgresql.org
Subject: Re: ugly query slower in 7.3, even slower after vacuum full analyze
Date: Thu, 22 May 2003 18:32:48 +0200
Message-ID: <012e01c3207f$c80b3920$0403a8c0@fejleszt4> (raw)
References: <008101c3206e$0dc8a310$0403a8c0@fejleszt4>
<19626.1053619357@sss.pgh.pa.us>
Dear Tom, (or anyone who followed the belowmentioned thread)
I read that thread (more-or-less), but couldn't have noticed the same
symptoms in my analyze output. So, to summarize my reading on this (please
confirm or fix):
* The symptom is the differing width in 7.2 and 7.3
* This causes more hdd work, that takes lots of time (indeed, the hdd was
going crazy)
* The query is probably good as it is; it's 7.3 that's slow (but more
reliable than 7.2) and 7.4 will most likely fix the problem.
If all these are correct, that's enough info to me. Hopefully it'll move
from a Cel333 (the developers' server) to an IBM 2x2.4 Xeon with 5-HDD SCSI
Raid (the business server).
G.
------------------------------- cut here -------------------------------
----- Original Message -----
From: "Tom Lane" <tgl@sss.pgh.pa.us>
Sent: Thursday, May 22, 2003 6:02 PM
Subject: Re: [PERFORM] ugly query slower in 7.3, even slower after vacuum
full analyze
> "=?iso-8859-2?B?U1rbQ1MgR+Fib3I=?=" <surrano@mailbox.hu> writes:
> > This is a rather nasty query, built up from several parameters, and it
> > proved to be 7--15 times slower in 7.3 than in 7.2.
>
> I think you are running into the same subselect-in-targetlist
> shortcoming as Eugene Fokin did:
> http://archives.postgresql.org/pgsql-performance/2003-05/msg00204.php
>
> regards, tom lane
>
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 from your mail client; the link fills in
the headers below: reply via email
Some clients, webmail especially, drop In-Reply-To and References from
a link, and the reply then starts a new thread: use the mbox below.
To: pgsql-performance@postgresql.org
Cc: surrano@mailbox.hu
Subject: Re: ugly query slower in 7.3, even slower after vacuum full analyze
In-Reply-To: <012e01c3207f$c80b3920$0403a8c0@fejleszt4>
References: <008101c3206e$0dc8a310$0403a8c0@fejleszt4> <19626.1053619357@sss.pgh.pa.us> <012e01c3207f$c80b3920$0403a8c0@fejleszt4>
* 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