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

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

From: Steve <cheetah(at)tanabi(dot)org>
To: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
Cc: pgsql-patches(at)postgreSQL(dot)org, Alvaro Herrera <alvherre(at)commandprompt(dot)com>
Subject: Re: [HACKERS] choose_bitmap_and again (was Re: [PERFORM] Strangely Variable Query Performance)
Date: 2007-04-14 22:55:45
Message-ID: Pine.GSO.4.64.0704141830490.17955@kittyhawk.tanabi.org (view raw or flat)
Thread:
Lists: pgsql-hackerspgsql-patchespgsql-performance
> Steve, can you try this out on your queries and see if it makes better
> or worse decisions?  It seems to fix your initial complaint but I do
> not have a large stock of test cases to try.
>

 	Wow, this is a remarkable difference.  Queries that were taking 
minutes to complete are coming up in seconds.  Good work, I think this'll 
solve my customer's needs for their demo on the 19th :)

Thank you so much!


Steve


In response to

Responses

pgsql-performance by date

Next:From: Tom LaneDate: 2007-04-15 05:11:02
Subject: Re: [HACKERS] choose_bitmap_and again (was Re: [PERFORM] Strangely Variable Query Performance)
Previous:From: Tom LaneDate: 2007-04-14 22:02:53
Subject: Re: [HACKERS] choose_bitmap_and again (was Re: [PERFORM] Strangely Variable Query Performance)

pgsql-hackers by date

Next:From: Greg StarkDate: 2007-04-14 23:56:01
Subject: Re: Makefile patch to make gcov work on Postgres contrib modules
Previous:From: Zoltan BoszormenyiDate: 2007-04-14 22:49:02
Subject: Re: IDENTITY/GENERATED v36 Re: Final version of IDENTITY/GENERATED patch

pgsql-patches by date

Next:From: Tom LaneDate: 2007-04-15 05:11:02
Subject: Re: [HACKERS] choose_bitmap_and again (was Re: [PERFORM] Strangely Variable Query Performance)
Previous:From: Zoltan BoszormenyiDate: 2007-04-14 22:49:02
Subject: Re: IDENTITY/GENERATED v36 Re: Final version of IDENTITY/GENERATED patch

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