Re: extrem bad performance - Mailing list pgsql-performance

From Rod Taylor
Subject Re: extrem bad performance
Date
Msg-id 1090031495.81714.11.camel@jester
Whole thread Raw
In response to extrem bad performance  (Stefan <bekraenzter@yahoo.com>)
Responses Re: extrem bad performance
List pgsql-performance
> The database grows very slowly. The main load comes from SELECT's and
> not from INSERT's or UPDATE's, but the performance gets slower day by day...
>
> I have no idea where to search for the speed break!

Lets start with an example. Please send us an EXPLAIN ANALYZE of a
couple of the poorly performing queries.



pgsql-performance by date:

Previous
From: Litao Wu
Date:
Subject: same plan, different time
Next
From: "Fred Moyer"
Date:
Subject: Re: hardware raid suggestions