pg.ddx.io  pgsql-performance@postgresql.org mailing list archive  
help / color / mirror / Atom feed
From: Steve <cheetah@tanabi.org>
To: Tom Lane <tgl@sss.pgh.pa.us>
Cc: pgsql-patches@postgreSQL.org, Alvaro Herrera <alvherre@commandprompt.com>
Subject: Re: [HACKERS] choose_bitmap_and again (was Re: [PERFORM] Strangely Variable Query Performance)
Date: Sun, 15 Apr 2007 04:13:53 -0400 (EDT)
Message-ID: <Pine.GSO.4.64.0704150407380.17955@kittyhawk.tanabi.org> (raw)
In-Reply-To: <26103.1176613862@sss.pgh.pa.us>
References: <Pine.GSO.4.64.0704121855300.17955@kittyhawk.tanabi.org>
	<10117.1176420763@sss.pgh.pa.us>
	<Pine.GSO.4.64.0704121928440.17955@kittyhawk.tanabi.org>
	<10355.1176422445@sss.pgh.pa.us>
	<Pine.GSO.4.64.0704122001160.17955@kittyhawk.tanabi.org>
	<10503.1176423606@sss.pgh.pa.us>
	<Pine.GSO.4.64.0704122025450.17955@kittyhawk.tanabi.org>
	<12360.1176436194@sss.pgh.pa.us>
	<Pine.GSO.4.64.0704122354430.17955@kit!tyhawk.tanabi.org>
	<26399.1176504501@sss.pgh.pa.us>
	<20070413232409.GI27255@alvh.no-ip.org>
	<7772.1176574886@sss.pgh.pa.us>
	<23414.1176588173@sss.pgh.pa.us>
	<Pine.GSO.4.64.0704141830490.17955@kittyhawk.tanabi.org>
	<26103.1176613862@sss.pgh.pa.us>

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

 	I'll see what I can find -- I'll let you know on Monday if I can 
find any queries that perform worse.  My tests so far have shown 
equivalent or better performance so far but I've only done sort of a 
survey so far ... I've got plenty of special cases to test that should 
put this through the paces.


Steve



view thread (10+ messages)  latest in thread

Message-ID: <Pine.GSO.4.64.0704150407380.17955@kittyhawk.tanabi.org>
Permalink:  ../Pine.GSO.4.64.0704150407380.17955@kittyhawk.tanabi.org/
Also on:    postgresql.org/message-id/Pine.GSO.4.64.0704150407380.17955@kittyhawk.tanabi.org

 · 

reply

Reply instructions:

You may reply publicly to this message via plain-text email
using any one of the following methods:

* Reply to all the recipients from your mail client; the link fills in
  the headers below: reply via email
  Some clients, webmail especially, drop In-Reply-To and References from
  a link, and the reply then starts a new thread: use the mbox below.

  To: pgsql-performance@postgresql.org
  Cc: cheetah@tanabi.org, tgl@sss.pgh.pa.us, alvherre@commandprompt.com
  Subject: Re: [HACKERS] choose_bitmap_and again (was Re: [PERFORM] Strangely Variable Query Performance)
  In-Reply-To: <Pine.GSO.4.64.0704150407380.17955@kittyhawk.tanabi.org>
  References: <Pine.GSO.4.64.0704121855300.17955@kittyhawk.tanabi.org> <10117.1176420763@sss.pgh.pa.us> <Pine.GSO.4.64.0704121928440.17955@kittyhawk.tanabi.org> <10355.1176422445@sss.pgh.pa.us> <Pine.GSO.4.64.0704122001160.17955@kittyhawk.tanabi.org> <10503.1176423606@sss.pgh.pa.us> <Pine.GSO.4.64.0704122025450.17955@kittyhawk.tanabi.org> <12360.1176436194@sss.pgh.pa.us> <Pine.GSO.4.64.0704122354430.17955@kit!tyhawk.tanabi.org> <26399.1176504501@sss.pgh.pa.us> <20070413232409.GI27255@alvh.no-ip.org> <7772.1176574886@sss.pgh.pa.us> <23414.1176588173@sss.pgh.pa.us> <Pine.GSO.4.64.0704141830490.17955@kittyhawk.tanabi.org> <26103.1176613862@sss.pgh.pa.us> <Pine.GSO.4.64.0704150407380.17955@kittyhawk.tanabi.org>

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox