Skip site navigation (1)
Skip section navigation (2)
Peripheral Links
Header And Logo
|
Site Navigation
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: Sat, 12 Jan 2008 00:44:14 -0500
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
- References:
- Re: Simple select, but takes long time
- From: andrew
- Re: Simple select, but takes long time
- Prev by Date: Re: Simple select, but takes long time
- Next by Date: Re: Best way to index IP data?
- Previous by thread: Re: Simple select, but takes long time
- Next by thread: Inheritance, unique keys and performance
- Indexes: