Skip site navigation (1) Skip section navigation (2)

Re: extrem bad performance

From: Rod Taylor <pg(at)rbt(dot)ca>
To: Stefan <bekraenzter(at)yahoo(dot)com>
Cc: Postgresql Performance <pgsql-performance(at)postgresql(dot)org>
Subject: Re: extrem bad performance
Date: 2004-07-17 02:31:36
Message-ID: 1090031495.81714.11.camel@jester (view raw, whole thread or download thread mbox)
Lists: 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.

In response to


pgsql-performance by date

Next:From: Fred MoyerDate: 2004-07-17 03:20:40
Subject: Re: hardware raid suggestions
Previous:From: Litao WuDate: 2004-07-16 21:36:30
Subject: same plan, different time

Privacy Policy | About PostgreSQL
Copyright © 1996-2017 The PostgreSQL Global Development Group