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

From: Heikki Linnakangas <heikki(at)enterprisedb(dot)com>
To: Francisco Reyes <lists(at)stringsutils(dot)com>
Cc: pgsql-performance(at)postgresql(dot)org
Subject: Re: Performance query about large tables, lots of concurrent access
Date: 2007-06-19 17:57:41
Message-ID: 46781915.4010201@enterprisedb.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-performance

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

In response to

Responses

Browse pgsql-performance by date

  From Date Subject
Next Message Campbell, Lance 2007-06-19 18:09:25 Re: PostgreSQL Configuration Tool for Dummies
Previous Message Campbell, Lance 2007-06-19 17:53:41 Re: PostgreSQL Configuration Tool for Dummies