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
Views: Raw Message | Whole Thread | Download mbox | Resend email
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

Browse pgsql-general by date

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