Re: max time in a table query takes ages

From: Grzegorz Jaśkiewicz <gryzman(at)gmail(dot)com>
To: "Postgres General List" <pgsql-general(at)postgresql(dot)org>
Subject: Re: max time in a table query takes ages
Date: 2008-10-24 19:08:38
Message-ID: 2f4958ff0810241208n5049d60oe2625ea2e9bb6c03@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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).

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message cyw 2008-10-24 19:23:41 JDBC - Call stored function that returns user defined type
Previous Message mike stanton 2008-10-24 19:03:02 Order by with spaces and other characters