Re: Index usage problem on 8.3.3

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Jeff Frost <jeff(at)frostconsultingllc(dot)com>
Cc: pgsql-performance(at)postgresql(dot)org
Subject: Re: Index usage problem on 8.3.3
Date: 2008-10-31 00:31:56
Message-ID: 13272.1225413116@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-performance

Jeff Frost <jeff(at)frostconsultingllc(dot)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

In response to

Responses

Browse pgsql-performance by date

  From Date Subject
Next Message Jeff Frost 2008-10-31 00:52:17 Re: Index usage problem on 8.3.3
Previous Message Jeff Frost 2008-10-31 00:18:06 Index usage problem on 8.3.3