Search Postgresql Archives

Re: BitmapScan mishaps

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

To: "Tom Lane" <tgl@xxxxxxxxxxxxx>
Subject: Re: BitmapScan mishaps
From: Listmail <lists@xxxxxxxxxx>
Date: Tue, 03 Apr 2007 19:31:22 +0200
Cc: pgsql-general@xxxxxxxxxxxxxx
In-reply-to: <10003.1175621011@xxxxxxxxxxxxx>
References: <euikod$1ssc$1@xxxxxxxxxxxx> <20070402174324.GP30858@xxxxxxxxxx> <eurlpt$2uhq$1@xxxxxxxxxxxx> <4611A450.2070900@xxxxxxxxxxxxx> <4612012D.1020307@xxxxxxxxxxxx> <21832.1175587217@xxxxxxxxxxxxx> <op.tp7qpie5zcizji@apollo13> <10003.1175621011@xxxxxxxxxxxxx>
User-agent: Opera Mail/9.10 (Linux)

On Tue, 03 Apr 2007 19:23:31 +0200, Tom Lane <tgl@xxxxxxxxxxxxx> wrote:

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


	Version is 8.2.3.

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

Follow-Ups:
- Re: BitmapScan mishaps
  - From: Tom Lane

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
- Re: BitmapScan mishaps
  - From: Tom Lane

Prev by Date: Re: UPDATE on two large datasets is very slow
Next by Date: Re: UPDATE on two large datasets is very slow
Previous by thread: Re: 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