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

Re: why is bitmap index chosen for this query?

From: Stephen Byers <stephenabyers(at)yahoo(dot)com>
To: "Steinar H(dot) Gunderson" <sgunderson(at)bigfoot(dot)com>, pgsql-performance(at)postgresql(dot)org
Subject: Re: why is bitmap index chosen for this query?
Date: 2006-05-18 20:26:26
Message-ID: 20060518202626.50897.qmail@web30713.mail.mud.yahoo.com (view raw or flat)
Thread:
Lists: pgsql-performance
You may be comparing the values to Tom's suggestion to bump up work_mem.  Take a look at the original posting (Total runtime: 777208.041 ms for the bitmap scan)
   
  -Steve
  
"Steinar H. Gunderson" <sgunderson(at)bigfoot(dot)com> wrote:
  On Thu, May 18, 2006 at 12:53:16PM -0700, Stephen Byers wrote:
> Yes, here are the runtimes for the repeated query.
> Total runtime: 748716.750 ms
> Total runtime: 749170.934 ms
> Total runtime: 744113.594 ms
> Total runtime: 746314.251 ms
> Total runtime: 742083.732 ms

With which options enabled? This isn't even close to any of the three times
you already posted.

/* Steinar */
-- 
Homepage: http://www.sesse.net/

---------------------------(end of broadcast)---------------------------
TIP 1: if posting/reading through Usenet, please send an appropriate
subscribe-nomail command to majordomo(at)postgresql(dot)org so that your
message can get through to the mailing list cleanly


		
---------------------------------
Yahoo! Messenger with Voice. Make PC-to-Phone Calls to the US (and 30+ countries) for 2ยข/min or less.

In response to

pgsql-performance by date

Next:From: Olivier AndreottiDate: 2006-05-19 10:24:35
Subject: Re: Benchmarck PostgreSQL 8.1.4 MySQL 5.0.20 and Oracle 10g2
Previous:From: Steinar H. GundersonDate: 2006-05-18 20:16:14
Subject: Re: why is bitmap index chosen for this query?

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