| From: | "Merlin Moncure" <mmoncure(at)gmail(dot)com> |
|---|---|
| To: | "Jim C(dot) Nasby" <jim(at)nasby(dot)net> |
| Cc: | "Pg Performance list" <pgsql-performance(at)postgresql(dot)org> |
| Subject: | Re: odd variances in count(*) times |
| Date: | 2006-10-10 06:30:07 |
| Message-ID: | b42b73150610092330m22dc6a6x7fefcb65bbbdfc51@mail.gmail.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-performance |
On 10/10/06, Jim C. Nasby <jim(at)nasby(dot)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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Ravindran G - TLS, Chennai. | 2006-10-10 10:47:06 | Postgre 8.0 Installation - Issues |
| Previous Message | Joshua D. Drake | 2006-10-10 03:22:39 | Re: Simple join optimized badly? |