Re: Vacuum problems

From: Grzegorz Jaśkiewicz <gryzman(at)gmail(dot)com>
To: "Scot Kreienkamp" <SKreien(at)la-z-boy(dot)com>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: Vacuum problems
Date: 2009-01-06 16:05:35
Message-ID: 2f4958ff0901060805o147e0c7bqcc1c5e48168815d0@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

you don't have to reindex too often - it locks exclusively whole
table, just like vacuum full. Just do it every few months, depending
on db growth.

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Tom Lane 2009-01-06 16:13:53 Re: remove log header
Previous Message Emanuel Calvo Franco 2009-01-06 16:03:44 Re: H2 database