Re: start time very high

From: Josh Berkus <josh(at)agliodbs(dot)com>
To: Jean-Max Reymond <jmreymond(at)gmail(dot)com>
Cc: pgsql-performance(at)postgresql(dot)org
Subject: Re: start time very high
Date: 2005-06-30 19:01:27
Message-ID: 200506301201.27519.josh@agliodbs.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-performance

Jean-Max,

> I have two computers, one laptop (1.5 GHz, 512 Mb RAM, 1 disk 4200)
> and one big Sun (8Gb RAM, 2 disks SCSI).

Did you run each query several times? It looks like the index is cached
on one server and not on the other.

--
--Josh

Josh Berkus
Aglio Database Solutions
San Francisco

In response to

Browse pgsql-performance by date

  From Date Subject
Next Message Tom Lane 2005-06-30 21:01:28 Re: start time very high
Previous Message Jean-Max Reymond 2005-06-30 16:23:22 Re: start time very high