Skip site navigation (1) Skip section navigation (2)

Re: count on transaction ID

From: "Kevin Grittner" <Kevin(dot)Grittner(at)wicourts(dot)gov>
To: "ddgs" <gsmaths(at)gmail(dot)com>,<pgsql-performance(at)postgresql(dot)org>
Subject: Re: count on transaction ID
Date: 2012-03-12 16:56:54
Message-ID: 4F5DE486020000250004615D@gw.wicourts.gov (view raw or flat)
Thread:
Lists: pgsql-performance
ddgs <gsmaths(at)gmail(dot)com> wrote:
 
> Is it a good starting point to the basic reason of doing vacuum?
> from the manual,
> "PostgreSQL's VACUUM command must be run on a regular basis for
> several reasons:
> To recover disk space occupied by updated or deleted rows.
> To update data statistics used by the PostgreSQL query planner.
> To protect against loss of very old data due to transaction ID
> wraparound.
> "
 
The entire page from which that quote is pulled makes a good
starting point.  Turning off autovacuum or making it less aggressive
without really understanding everything on that page will generally
result in problems which take far longer to solve than any marginal
savings obtained by making the change.
 
-Kevin

In response to

pgsql-performance by date

Next:From: RaghavendraDate: 2012-03-13 00:55:11
Subject: Re: Tuning wizard
Previous:From: Scott MarloweDate: 2012-03-12 16:43:32
Subject: Re: Advice on Controller card for SAS disks

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group