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: (view raw, whole thread or download thread mbox)
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


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-2017 The PostgreSQL Global Development Group