Re: Performance query about large tables, lots of concurrent access

From: Francisco Reyes <lists(at)stringsutils(dot)com>
To: Gregory Stark <stark(at)enterprisedb(dot)com>
Cc: Karl Wright <kwright(at)metacarta(dot)com>, pgsql-performance(at)postgresql(dot)org
Subject: Re: Performance query about large tables, lots of concurrent access
Date: 2007-06-19 15:40:44
Message-ID: cone.1182267644.183472.90929.5001@35st.simplicato.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-performance

Gregory Stark writes:

> VACUUM doesn't require shutting down the system, it doesn't lock any tables or
> otherwise prevent other jobs from making progress. It does add extra i/o but

In addition to what Gregory pointed out, you may want to also consider using
Autovacuum. That may also help.

In response to

Browse pgsql-performance by date

  From Date Subject
Next Message Francisco Reyes 2007-06-19 15:45:49 Re: Performance query about large tables, lots of concurrent access
Previous Message Francisco Reyes 2007-06-19 15:37:07 Re: Hardware suggestions