Search Postgresql Archives

Re: BitmapScan mishaps

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

To: Listmail <lists@xxxxxxxxxx>
Subject: Re: BitmapScan mishaps
From: Tom Lane <tgl@xxxxxxxxxxxxx>
Date: Tue, 03 Apr 2007 13:23:31 -0400
Cc: pgsql-general@xxxxxxxxxxxxxx
Comments: In-reply-to Listmail <lists@xxxxxxxxxx> message dated "Tue, 03 Apr 2007 17:01:56 +0200"
In-reply-to: <op.tp7qpie5zcizji@apollo13>
References: <euikod$1ssc$1@xxxxxxxxxxxx> <20070402174324.GP30858@xxxxxxxxxx> <eurlpt$2uhq$1@xxxxxxxxxxxx> <4611A450.2070900@xxxxxxxxxxxxx> <4612012D.1020307@xxxxxxxxxxxx> <21832.1175587217@xxxxxxxxxxxxx> <op.tp7qpie5zcizji@apollo13>

Listmail <lists@xxxxxxxxxx> writes:
> 	It bitmapscans about half the table...

Which PG version is this exactly?  We've fooled with the
choose_bitmap_and heuristics quite a bit ...

			regards, tom lane

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

Follow-Ups:
- Re: BitmapScan mishaps
  - From: Listmail

References:
- Using C# to create stored procedures
  - From: Andrus
- Re: Using C# to create stored procedures
  - From: David Fetter
- Re: Using C# to create stored procedures
  - From: Andrus
- Re: Using C# to create stored procedures
  - From: Guy Rouillier
- Re: Using C# to create stored procedures
  - From: Magnus Hagander
- Re: Using C# to create stored procedures
  - From: Tom Lane
- BitmapScan mishaps
  - From: Listmail

Prev by Date: COPY FROM - how to identify results?
Next by Date: Re: UPDATE on two large datasets is very slow
Previous by thread: BitmapScan mishaps
Next by thread: Re: BitmapScan mishaps
Index(es):
- Date
- Thread

[Index of Archives] [Postgresql Jobs] [Postgresql Admin] [Postgresql Performance] [Linux Clusters] [PHP Home] [PHP on Windows] [Kernel Newbies] [PHP Classes] [PHP Books] [PHP Databases] [Postgresql & PHP] [Yosemite]

Powered by Linux