> >Can you find any cases where it makes a worse choice than before?
> >Another thing to pay attention to is whether the planning time gets
> >noticeably worse. If we can't find any cases where it loses badly
> >on those measures, I'll feel comfortable in applying it...
> Okay, here's the vedict; all the "extremely slow" queries (i.e.
> queries that took more than 30 seconds and upwards of several minutes to
> complete) are now running in the realm of reason. In fact, most queries
> that took between 1 and 4 minutes are now down to taking about 9 seconds
> which is obviously a tremendous improvement.
> A few of the queries that were taking 9 seconds or less are
> "slightly slower" -- meaning a second or two slower. However most of them
> are running at the same speed they were before, or better.
> So I'd say as far as I can tell with my application and my
> dataset, this change is solid and an obvious improvement.
Maybe it would be interesting to see in detail those cases that got a
bit slower, to further tweak the heuristic if necessary. Is the extra
time, time spent in planning or in execution?
Alvaro Herrera http://www.CommandPrompt.com/
PostgreSQL Replication, Consulting, Custom Development, 24x7 support
In response to
pgsql-performance by date
|Next:||From: cluster||Date: 2007-04-16 23:12:28|
|Subject: Re: FK triggers misused?|
|Previous:||From: Steve||Date: 2007-04-16 22:13:54|
|Subject: Re: [HACKERS] choose_bitmap_and again (was Re: [PERFORM] Strangely
Variable Query Performance) |
pgsql-hackers by date
|Next:||From: Tom Lane||Date: 2007-04-16 23:03:10|
|Subject: Re: Hacking on PostgreSQL via GIT |
|Previous:||From: Josh Berkus||Date: 2007-04-16 23:00:14|
|Subject: Re: [RFC] PostgreSQL Access Control Extension (PGACE)|
pgsql-patches by date
|Next:||From: Andrew Dunstan||Date: 2007-04-17 02:11:08|
|Subject: Re: [HACKERS] Re: IDENTITY/GENERATED v36 Re: Final version
of IDENTITY/GENERATED patch|
|Previous:||From: Tom Lane||Date: 2007-04-16 22:56:58|
|Subject: Re: scrollable cursor support without MOVE statement |