Postgres Pro
Downloads
Home   >   mailing lists

Re: ugly query slower in 7.3, even slower after vacuum full analyze - Mailing list pgsql-performance

From Tom Lane
Subject Re: ugly query slower in 7.3, even slower after vacuum full analyze
Date
Msg-id 19626.1053619357@sss.pgh.pa.us
Whole thread Raw
In response to ugly query slower in 7.3, even slower after vacuum full analyze  ("SZŰCS Gábor" <surrano@mailbox.hu>)
List pgsql-performance
Tree view 
"=?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

pgsql-performance by date:

Previous
From: "SZŰCS Gábor"
Date:
Subject: ugly query slower in 7.3, even slower after vacuum full analyze
Next
From: Josh Berkus
Date:
Subject: Re: ugly query slower in 7.3, even slower after vacuum full analyze