Postgres Pro
Downloads
Home   >   mailing lists

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

From Josh Berkus
Subject Re: ugly query slower in 7.3, even slower after vacuum full analyze
Date
Msg-id 200305220931.06110.josh@agliodbs.com
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 
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

pgsql-performance by date:

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