Re: Performance query about large tables, lots of concurrent access - Mailing list pgsql-performance

From Francisco Reyes
Subject Re: Performance query about large tables, lots of concurrent access
Date
Msg-id cone.1182267644.183472.90929.5001@35st.simplicato.com
Whole thread Raw
In response to Performance query about large tables, lots of concurrent access  (Karl Wright <kwright@metacarta.com>)
List 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.

pgsql-performance by date:

Previous
From: Francisco Reyes
Date:
Subject: Re: Hardware suggestions
Next
From: Francisco Reyes
Date:
Subject: Re: Performance query about large tables, lots of concurrent access