Re: odd variances in count(*) times

Поиск
Список
Период
Сортировка
От Merlin Moncure
Тема Re: odd variances in count(*) times
Дата
Msg-id b42b73150610092330m22dc6a6x7fefcb65bbbdfc51@mail.gmail.com
обсуждение исходный текст
Ответ на Re: odd variances in count(*) times  ("Jim C. Nasby" <jim@nasby.net>)
Список pgsql-performance
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

В списке pgsql-performance по дате отправления:

Предыдущее
От: "Joshua D. Drake"
Дата:
Сообщение: Re: Simple join optimized badly?
Следующее
От: "Ravindran G - TLS, Chennai."
Дата:
Сообщение: Postgre 8.0 Installation - Issues