> I believe the biggest problem is disc io. Reports for very recent data
> are quite fast, these are used very often and therefor already in the
> cache. But reports can contain (and regulary do) very old data. In that
> case the whole system slows down. To me this sounds like the recent data
> is flushed out of the cache and now all data for all queries has to be
> fetched from disc.
How large is the database on disk?
> My machine has 2GB memory, please find postgresql.conf below.
Aglio Database Solutions
In response to
pgsql-performance by date
|Next:||From: Ron||Date: 2005-08-17 18:00:14|
|Subject: Re: Need for speed|
|Previous:||From: Chris Hoover||Date: 2005-08-17 17:17:33|
|Subject: Re: Tuning Effective Cache Question|