Postgres Pro
Downloads
Home   >   mailing lists

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

From Heikki Linnakangas
Subject Re: Performance query about large tables, lots of concurrent access
Date
Msg-id 46781915.4010201@enterprisedb.com
Whole thread Raw
In response to Re: Performance query about large tables, lots of concurrent access  (Francisco Reyes <lists@stringsutils.com>)
List pgsql-performance
Tree view 
Francisco Reyes wrote:

> 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

22h nightly? Wow, you have long nights ;-).

On a serious note, the index vacuum improvements in 8.2 might help you
to cut that down. You seem to be happy with your setup, but I thought
I'd mention it..

--
   Heikki Linnakangas
   EnterpriseDB   http://www.enterprisedb.com

pgsql-performance by date:

Previous
From: "Campbell, Lance"
Date:
Subject: Re: PostgreSQL Configuration Tool for Dummies
Next
From: "D'Arcy J.M. Cain"
Date:
Subject: Re: PostgreSQL Configuration Tool for Dummies