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

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

I see, I never knew about having to VACUUM/ANALYZE first. Thanks.

--
dave


pgsql-general by date:

Previous
From: Mike Nolan
Date:
Subject: Re: PG vs MySQL
Next
From: Mike Nolan
Date:
Subject: Re: PG vs MySQL