From: Joel Fradkin <jfradkin@wazagua.com>
To: 'Richard Huxton' <dev@archonet.com>
Cc: 'PostgreSQL Perform' <pgsql-performance@postgresql.org>
Subject: Re: speed of querry?
Date: Wed, 13 Apr 2005 14:29:51 -0400
Message-ID: <000001c54056$c8499dc0$797ba8c0@jfradkin> (raw)
In-Reply-To: <425D573B.3080208@archonet.com>
are you sure the query was identical in each case.
I just ran a second time same results ensuring that the query is the same.
Not sure why it is doing a column10 thing. Any ideas what to look for?
Both data bases are a restore from the same backup file.
One is running redhat the other XP, I believe both are the same version of
postgres except for the different platform (8.0.1 I am pretty sure).
I just spent the morning with Dell hoping for some explanation from them.
They said I had to have the database on the same type of OS and hardware for
them to think the issue was hardware. They are escalating to the software
group.
I did a default Redhat install so it very well may be an issue with my lack
of knowledge on Linux.
He did mention by default the Perc4 do cache, so I may need to visit the
data center to set the percs to not cache.
--
Richard Huxton
Archonet Ltd
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-performance@postgresql.org
Cc: jfradkin@wazagua.com, dev@archonet.com
Subject: Re: speed of querry?
In-Reply-To: <000001c54056$c8499dc0$797ba8c0@jfradkin>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox