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

From: Josh Berkus <josh(at)agliodbs(dot)com>
To: " SZŰCS =?iso-8859-2?q?=20G=E1bor?=" <surrano(at)mailbox(dot)hu>, <pgsql-performance(at)postgresql(dot)org>
Cc: <TIR(at)yahoogroups(dot)com>
Subject: Re: ugly query slower in 7.3, even slower after vacuum full analyze
Date: 2003-05-22 16:31:06
Message-ID: 200305220931.06110.josh@agliodbs.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-performance

Szucs,

> 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. This particular query
> takes more than 3.5 minutes (4 after vacuum full analyze! (henceforth VFA))
> that is unacceptable in an interactive client application.

Please read the list archives for the last 3-4 days. Another user reported a
"slow query" problem with 7.3.2; please see if it sounds like yours.

--
Josh Berkus
Aglio Database Solutions
San Francisco

In response to

Browse pgsql-performance by date

  From Date Subject
Next Message SZŰCS Gábor 2003-05-22 16:32:48 Re: ugly query slower in 7.3, even slower after vacuum full analyze
Previous Message Tom Lane 2003-05-22 16:02:37 Re: ugly query slower in 7.3, even slower after vacuum full analyze