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

From Grzegorz Jaśkiewicz
Subject Re: max time in a table query takes ages
Date
Msg-id 2f4958ff0810241208n5049d60oe2625ea2e9bb6c03@mail.gmail.com
Whole thread Raw
In response to Re: max time in a table query takes ages  (Scott Ribe <scott_ribe@killerbytes.com>)
Responses Re: max time in a table query takes ages  (Alan Hodgson <ahodgson@simkin.ca>)
List pgsql-general
that index did the job, also reindexing, and getting rid of two other not quite often used indices helped a lot. 
Now, this whole machine is fairly simple two way p4, 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, but still its times better from what it used to be on 8.1 (the machine is running 8.3).

pgsql-general by date:

Previous
From: Jack Orenstein
Date:
Subject: Re: Postgres optimizer choosing wrong index
Next
From: "mike stanton"
Date:
Subject: Order by with spaces and other characters