Postgres Pro
Downloads
Home   >   mailing lists

Re: Simple select, but takes long time - Mailing list pgsql-performance

From Tom Lane
Subject Re: Simple select, but takes long time
Date
Msg-id 1636.1200116654@sss.pgh.pa.us
Whole thread Raw
In response to Re: Simple select, but takes long time  (andrew@pillette.com)
List pgsql-performance
Tree view 
andrew@pillette.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

pgsql-performance by date:

Previous
From: andrew@pillette.com
Date:
Subject: Re: Simple select, but takes long time
Next
From: "D'Arcy J.M. Cain"
Date:
Subject: Re: Best way to index IP data?