Re: max time in a table query takes ages

From: Alan Hodgson <ahodgson(at)simkin(dot)ca>
To: pgsql-general(at)postgresql(dot)org
Subject: Re: max time in a table query takes ages
Date: 2008-10-24 20:36:26
Message-ID: 200810241336.27027@hal.medialogik.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

On Friday 24 October 2008, "Grzegorz Jaśkiewicz" <gryzman(at)gmail(dot)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

In response to

Browse pgsql-general by date

  From Date Subject
Next Message David Fetter 2008-10-24 21:02:47 Re: Storing questionnaire data
Previous Message Tomasz Myrta 2008-10-24 20:11:33 Re: How to get user list and privileges?