Skip site navigation (1) Skip section navigation (2)

Re: Weird 8.2.4 performance

From: "Steinar H(dot) Gunderson" <sgunderson(at)bigfoot(dot)com>
To: pgsql-performance(at)postgresql(dot)org
Cc: Kurt Overberg <kurt(at)hotdogrecords(dot)com>
Subject: Re: Weird 8.2.4 performance
Date: 2007-06-07 09:43:04
Message-ID: 20070607094304.GA22543@uio.no (view raw or flat)
Thread:
Lists: pgsql-performance
On Thu, Jun 07, 2007 at 11:35:27AM +0200, Steinar H. Gunderson wrote:
> How big did you say these tables were?

Sorry, you already said that -- 650k rows for one of them. 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.

/* Steinar */
-- 
Homepage: http://www.sesse.net/

In response to

Responses

pgsql-performance by date

Next:From: Mark KirkwoodDate: 2007-06-07 11:12:52
Subject: Re: Weird 8.2.4 performance
Previous:From: Steinar H. GundersonDate: 2007-06-07 09:35:27
Subject: Re: Weird 8.2.4 performance

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group