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

Re: Index usage for BYTEA column in OR/IN clause

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: David Garamond <lists(at)zara(dot)6(dot)isreserved(dot)com>
Cc: Bruno Wolff III <bruno(at)wolff(dot)to>,pgsql-general <pgsql-general(at)postgresql(dot)org>
Subject: Re: Index usage for BYTEA column in OR/IN clause
Date: 2004-03-28 21:13:33
Message-ID: 18666.1080508413@sss.pgh.pa.us (view raw or flat)
Thread:
Lists: pgsql-general
David Garamond <lists(at)zara(dot)6(dot)isreserved(dot)com> writes:
> 1. script to create the test table (a 1mil-record table; each record 
> contains 1-40 random bytes):

This script is lacking a VACUUM or ANALYZE command, so the planner
doesn't know how large the table is.  Note the ridiculously small
cost estimates in EXPLAIN ...

			regards, tom lane

In response to

Responses

pgsql-general by date

Next:From: Carl E. McMillinDate: 2004-03-28 21:36:15
Subject: Hacking postgres backend process
Previous:From: Sean ChittendenDate: 2004-03-28 19:59:25
Subject: Re: Resolution for "ERROR: cannot handle whole-row reference" ?

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