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

Re: Need for speed

From: Josh Berkus <josh(at)agliodbs(dot)com>
To: pgsql-performance(at)postgresql(dot)org
Cc: Ulrich Wisser <ulrich(dot)wisser(at)relevanttraffic(dot)se>
Subject: Re: Need for speed
Date: 2005-08-17 17:28:04
Message-ID: 200508171028.05028.josh@agliodbs.com (view raw or flat)
Thread:
Lists: pgsql-performance
Ulrich,

> 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.

hmmmm ...
effective_cache_size?
random_page_cost?
cpu_tuple_cost?
etc.

-- 
Josh Berkus
Aglio Database Solutions
San Francisco

In response to

pgsql-performance by date

Next:From: RonDate: 2005-08-17 18:00:14
Subject: Re: Need for speed
Previous:From: Chris HooverDate: 2005-08-17 17:17:33
Subject: Re: Tuning Effective Cache Question

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