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

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