Postgres Pro
Downloads
Home   >   mailing lists

Re: max time in a table query takes ages - Mailing list pgsql-general

From Alan Hodgson
Subject Re: max time in a table query takes ages
Date
Msg-id 200810241336.27027@hal.medialogik.com
Whole thread Raw
In response to Re: max time in a table query takes ages  ("Grzegorz Jaśkiewicz" <gryzman@gmail.com>)
List pgsql-general
Tree view 
On Friday 24 October 2008, "Grzegorz Jaśkiewicz" <gryzman@gmail.com> wrote:
> with two sata discs in software raid 1 on linux. And it seems to spend
> loads of time (40-60% sometimes) on waits.  I guess this is due to lack of
> >aio support in postgresql,

No, it's due to the fact that hard disks are slow; much, much slower than
CPU or memory.

--
Alan

pgsql-general by date:

Previous
From: Tomasz Myrta
Date:
Subject: Re: How to get user list and privileges?
Next
From: David Fetter
Date:
Subject: Re: Storing questionnaire data