Re: explain ?

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Patrick Welche <prlw1(at)newn(dot)cam(dot)ac(dot)uk>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: explain ?
Date: 2003-04-18 14:20:33
Message-ID: 3742.1050675633@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Patrick Welche <prlw1(at)newn(dot)cam(dot)ac(dot)uk> writes:
> I created an index on firsttimei, vacuum full analysed, and explain showed me
> *exactly* the same thing(!) The difference being that the query is now
> lightning fast :-)

Perhaps the vacuum got rid of a whole bunch of dead rows?

regards, tom lane

In response to

  • explain ? at 2003-04-18 13:19:05 from Patrick Welche

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Ken Williams 2003-04-18 14:22:12 Weird "template1" errors on CREATE DATABASE
Previous Message Tom Lane 2003-04-18 14:11:14 Re: Problem with the use of Array and Loop