Postgres Pro
Downloads
Home   >   mailing lists

Re: Index usage for BYTEA column in OR/IN clause - Mailing list pgsql-general

From Tom Lane
Subject Re: Index usage for BYTEA column in OR/IN clause
Date
Msg-id 18666.1080508413@sss.pgh.pa.us
Whole thread Raw
In response to Re: Index usage for BYTEA column in OR/IN clause  (David Garamond <lists@zara.6.isreserved.com>)
Responses Re: Index usage for BYTEA column in OR/IN clause
List pgsql-general
Tree view 
David Garamond <lists@zara.6.isreserved.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

pgsql-general by date:

Previous
From: Sean Chittenden
Date:
Subject: Re: Resolution for "ERROR: cannot handle whole-row reference" ?
Next
From: "Carl E. McMillin"
Date:
Subject: Hacking postgres backend process