Re: Database-wide vacuum can take a long time, duringwhich tables are not being analyzed

From: "Steven Flatt" <steven(dot)flatt(at)gmail(dot)com>
To: "Simon Riggs" <simon(at)2ndquadrant(dot)com>
Cc: pgsql-performance(at)postgresql(dot)org
Subject: Re: Database-wide vacuum can take a long time, duringwhich tables are not being analyzed
Date: 2006-11-02 15:15:30
Message-ID: 357fa7590611020715k66ba3ba0r28c5f4511589909d@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-performance

Sorry, I think there's a misunderstanding here. Our system is not doing
near that number of transactions per second. I meant that the duration of a
single DB-wide vacuum takes on the order of a couple of weeks. The time
between DB-wide vacuums is a little over a year, I believe.

> Every couple of weeks implies a transaction rate of ~~500tps, so I'd be
> interested to hear more about your system.
>
> --
> Simon Riggs
> EnterpriseDB http://www.enterprisedb.com
>
>
>

In response to

Responses

Browse pgsql-performance by date

  From Date Subject
Next Message Scott Marlowe 2006-11-02 15:20:36 Re: Setting "nice" values
Previous Message Madison Kelly 2006-11-02 15:14:49 Setting "nice" values