Steinar H. Gunderson wrote:
On Thu, Jun 07, 2007 at 11:35:27AM +0200, Steinar H. Gunderson wrote:
If that table
doesn't fit in the cache on your Mac, you pretty much lose. From the EXPLAIN
output, it looks like it fits very nicely in cache on your server. Thus, I
don't think the difference is between 8.0 and 8.2, but rather your production
server and your test machine.
That's a good point, however its not immediately obvious that the
production server is *not* running MacOSX Tiger (or has any more
memory)... Kurt can you post the relevant specs for the the 8.0 and 8.2
boxes?
Cheers
Mark
---------------------------(end of broadcast)---------------------------
TIP 7: You can help support the PostgreSQL project by donating at
http://www.postgresql.org/about/donate
