Postgres Pro
Downloads
Home   >   mailing lists

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.1182267949.154012.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>)
Responses Re: Performance query about large tables, lots of concurrent access  (Heikki Linnakangas <heikki@enterprisedb.com>)
Re: Performance query about large tables, lots of concurrent access  (Karl Wright <kwright@metacarta.com>)
List pgsql-performance
Tree view 
Alvaro Herrera writes:

> How large is the database?  I must admit I have never seen a database
> that took 4 days to vacuum.  This could mean that your database is
> humongous, or that the vacuum strategy is wrong for some reason.

Specially with 16GB of RAM.

I have a setup with several databases (the largest of which is 1TB database)
and I do a nightly vacuum analyze for ALL databases. It takes about 22
hours. And this is with constant updates to the large 1TB database. This is
with Postgresql 8.1.3

pgsql-performance by date:

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