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

From Steven Flatt
Subject Re: Database-wide vacuum can take a long time, duringwhich tables are not being analyzed
Date
Msg-id 357fa7590611020715k66ba3ba0r28c5f4511589909d@mail.gmail.com
Whole thread Raw
In response to Re: Database-wide vacuum can take a long time, duringwhich tables are not being analyzed  ("Simon Riggs" <simon@2ndquadrant.com>)
Responses Re: Database-wide vacuum can take a long time, duringwhich tables are not being analyzed  (Alvaro Herrera <alvherre@commandprompt.com>)
List 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



pgsql-performance by date:

Previous
From: Madison Kelly
Date:
Subject: Setting "nice" values
Next
From: Scott Marlowe
Date:
Subject: Re: Setting "nice" values