Skip site navigation (1) Skip section navigation (2)

Re: [HACKERS] choose_bitmap_and again (was Re: [PERFORM] Strangely Variable Query Performance)

From: Alvaro Herrera <alvherre(at)commandprompt(dot)com>
To: Steve <cheetah(at)tanabi(dot)org>
Cc: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>, pgsql-patches(at)postgreSQL(dot)org
Subject: Re: [HACKERS] choose_bitmap_and again (was Re: [PERFORM] Strangely Variable Query Performance)
Date: 2007-04-16 23:01:04
Message-ID: 20070416230104.GY5658@alvh.no-ip.org (view raw or flat)
Thread:
Lists: pgsql-hackerspgsql-patchespgsql-performance
Steve wrote:

> >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

Responses

pgsql-performance by date

Next:From: clusterDate: 2007-04-16 23:12:28
Subject: Re: FK triggers misused?
Previous:From: SteveDate: 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 LaneDate: 2007-04-16 23:03:10
Subject: Re: Hacking on PostgreSQL via GIT
Previous:From: Josh BerkusDate: 2007-04-16 23:00:14
Subject: Re: [RFC] PostgreSQL Access Control Extension (PGACE)

pgsql-patches by date

Next:From: Andrew DunstanDate: 2007-04-17 02:11:08
Subject: Re: [HACKERS] Re: IDENTITY/GENERATED v36 Re: Final version of IDENTITY/GENERATED patch
Previous:From: Tom LaneDate: 2007-04-16 22:56:58
Subject: Re: scrollable cursor support without MOVE statement

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group