Re: Query performance issue with 8.0.0beta1

From: andrew(at)pillette(dot)com
To: "Stefano Bonnin" <stefano(dot)bonnin(at)comai(dot)to>
Cc: <pgsql-performance(at)postgresql(dot)org>
Subject: Re: Query performance issue with 8.0.0beta1
Date: 2004-08-27 16:52:15
Message-ID: 200408271652.i7RGqFV31987@pillette.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-performance

Is it possible (to mix two threads) that you had CLUSTERed the table on the old database in a way that retrieved the records in this query faster?

Browse pgsql-performance by date

  From Date Subject
Next Message Jack Kerkhof 2004-08-27 17:12:13 Why does a simple query not use an obvious index?
Previous Message Adi Alurkar 2004-08-27 16:51:00 Re: Equivalent praxis to CLUSTERED INDEX?