From: Merlin Moncure <mmoncure@gmail.com>
To: Jim C. Nasby <jim@nasby.net>
Cc: Pg Performance list <pgsql-performance@postgresql.org>
Subject: Re: odd variances in count(*) times
Date: Tue, 10 Oct 2006 12:00:07 +0530
Message-ID: <b42b73150610092330m22dc6a6x7fefcb65bbbdfc51@mail.gmail.com> (raw)
In-Reply-To: <20061009212355.GM72517@nasby.net>
References: <b42b73150610091117n29e8d9d5yed07abe8a228593e@mail.gmail.com>
<20061009183026.GT24675@kenobi.snowman.net>
<b42b73150610091141n487ba223pfa56a639105f0e9f@mail.gmail.com>
<20061009212355.GM72517@nasby.net>
On 10/10/06, Jim C. Nasby <jim@nasby.net> wrote:
> > >Try w/o the explain analyze. It adds quite a bit of overhead and that
> > >might be inconsistant between the systems (mainly it may have to do with
> > >the gettimeofday() calls being implemented differently between Windows
> > >and Linux..).
> >
> > that was it. amd system now drop to .3 seconds, windows .6. (doing
> > time foo > psql -c bar > file). thanks...
>
> You can also turn timing on in psql.
>
> And FWIW, RAID5 generally isn't a good idea for databases.
thats just our development box here at the office. production system
runs on something much more extravagent :).
melrin
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: mmoncure@gmail.com, jim@nasby.net
Subject: Re: odd variances in count(*) times
In-Reply-To: <b42b73150610092330m22dc6a6x7fefcb65bbbdfc51@mail.gmail.com>
* 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