Re: ugly query slower in 7.3, even slower after vacuum full analyze

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: SZŰCS Gábor <surrano(at)mailbox(dot)hu>
Cc: pgsql-performance(at)postgresql(dot)org, TIR(at)yahoogroups(dot)com
Subject: Re: ugly query slower in 7.3, even slower after vacuum full analyze
Date: 2003-05-22 16:02:37
Message-ID: 19626.1053619357@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-performance

"=?iso-8859-2?B?U1rbQ1MgR+Fib3I=?=" <surrano(at)mailbox(dot)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

In response to

Responses

Browse pgsql-performance by date

  From Date Subject
Next Message Josh Berkus 2003-05-22 16:31:06 Re: ugly query slower in 7.3, even slower after vacuum full analyze
Previous Message SZŰCS Gábor 2003-05-22 14:25:54 ugly query slower in 7.3, even slower after vacuum full analyze