Postgres Pro
Downloads
Home   >   mailing lists

Re: Index usage problem on 8.3.3 - Mailing list pgsql-performance

From Tom Lane
Subject Re: Index usage problem on 8.3.3
Date
Msg-id 13272.1225413116@sss.pgh.pa.us
Whole thread Raw
In response to Index usage problem on 8.3.3  (Jeff Frost <jeff@frostconsultingllc.com>)
Responses Re: Index usage problem on 8.3.3  (Jeff Frost <jeff@frostconsultingllc.com>)
List pgsql-performance
Tree view 
Jeff Frost <jeff@frostconsultingllc.com> writes:
> I've run across a strange problem with PG 8.3.3 not using indexes on a
> particular table after building the table during a transaction.

This may be a HOT side-effect ... is pg_index.indcheckxmin set for
the index?

            regards, tom lane

pgsql-performance by date:

Previous
From: Jeff Frost
Date:
Subject: Index usage problem on 8.3.3
Next
From: Jeff Frost
Date:
Subject: Re: Index usage problem on 8.3.3