pg.ddx.io  pgsql-performance@postgresql.org mailing list archive  
help / color / mirror / Atom feed
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




view thread (22+ messages)  latest in thread

Message-ID: <000001c54056$c8499dc0$797ba8c0@jfradkin>
Permalink:  ../000001c54056$c8499dc0$797ba8c0@jfradkin/
Also on:    postgresql.org/message-id/000001c54056$c8499dc0$797ba8c0@jfradkin

 · 

reply

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