Re: Index usage

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Pedro Alves <pmalves(at)think(dot)pt>
Cc: Dennis Björklund <db(at)zigo(dot)dhs(dot)org>, PostGreSQL <pgsql-general(at)postgresql(dot)org>
Subject: Re: Index usage
Date: 2003-08-26 14:25:11
Message-ID: 11919.1061907911@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Pedro Alves <pmalves(at)think(dot)pt> writes:
> It's the same even with statistics=1000.

Uh, you did actually ANALYZE the table after each change, right?
Doesn't the EXPLAIN output change at all?

regards, tom lane

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Bruce Momjian 2003-08-26 14:33:44 Re: Call for presentations Linux Solutions 2004
Previous Message Pedro Alves 2003-08-26 14:24:02 Re: Index usage