Re: Simple select, but takes long time

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: andrew(at)pillette(dot)com
Cc: "James DeMichele" <James(dot)DeMichele(at)redfin(dot)com>, pgsql-performance(at)postgresql(dot)org
Subject: Re: Simple select, but takes long time
Date: 2008-01-12 05:44:14
Message-ID: 1636.1200116654@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-performance

andrew(at)pillette(dot)com writes:
> MySQL is using some sort of auto-clustering ISAM on the other box mayhaps?

I think they probably count the index entries without ever visiting the
table proper. Works great for mainly-static data ...

regards, tom lane

In response to

Browse pgsql-performance by date

  From Date Subject
Next Message D'Arcy J.M. Cain 2008-01-12 06:00:48 Re: Best way to index IP data?
Previous Message andrew 2008-01-12 05:37:29 Re: Simple select, but takes long time