From: Brad Nicholson <bnichols@ca.afilias.info>
To: raghavendra t <raagavendra.rao@gmail.com>
Cc: Pierre C <lists@peufeu.com>
Cc: Kevin Grittner <Kevin.Grittner@wicourts.gov>
Cc: greg@2ndquadrant.com
Cc: hannu@2ndquadrant.com
Cc: sclark@netwolves.com
Cc: craig@postnewspapers.com.au
Cc: jorge_montero@homedecorators.com
Cc: pgsql-performance@postgresql.org
Subject: Re: How to fast the REINDEX
Date: Thu, 01 Apr 2010 09:52:55 -0400
Message-ID: <1270129975.5155.317.camel@bnicholson-desktop> (raw)
In-Reply-To: <z2lbc7de5a31004010647g7175cd63of16e77bc7b6b1ad0@mail.gmail.com>
References: <p2ubc7de5a31003311351p83987eedpbb86727ab9fa9ca3@mail.gmail.com>
<4BB3722F02000025000302BF@gw.wicourts.gov>
<j2tbc7de5a31003311433h5c4ce21ej79aa67067e98a4bf@mail.gmail.com>
<j2w3073cc9b1003311525if0fccf56y3a485b26eccc82f7@mail.gmail.com>
<4BB40EE8.2080005@postnewspapers.com.au>
<4BB47F15.4000307@netwolves.com>
<op.vahgtfv7eorkce@immo.peufeu.com>
<z2lbc7de5a31004010647g7175cd63of16e77bc7b6b1ad0@mail.gmail.com>
On Thu, 2010-04-01 at 19:17 +0530, raghavendra t wrote:
>
> Hi All,
>
> System Config
> ---------------------
> CPU - Intel® Xenon® CPU
> CPU Speed - 3.16 GHz
> Server Model - Sun Fire X4150
> RAM-Size - 16GB
>
> Steve:
> So am I to understand I don't need to do daily reindexing as a
> maintenance measure with 8.3.7 on FreeBSD.
>
> My question is something like Steve's, why we should not do reindexing
> as our maintenance task. I was doing reindex only to get
> a best fit and not fall short of 90% hole, bcoz my table has lot of
> updates and deletes. We also has the weekly maintance of VACUUM, but
> still reindex takes lot of time.
This is your problem. You should enable autovaccuum, let the vacuums
happen more frequently, and this problem will go away. You will still
have to fix the underlying bloat a last time though.
--
Brad Nicholson 416-673-4106
Database Administrator, Afilias Canada Corp.
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-performance@postgresql.org
Cc: bnichols@ca.afilias.info, raagavendra.rao@gmail.com, lists@peufeu.com, Kevin.Grittner@wicourts.gov, greg@2ndquadrant.com, hannu@2ndquadrant.com, sclark@netwolves.com, craig@postnewspapers.com.au, jorge_montero@homedecorators.com
Subject: Re: How to fast the REINDEX
In-Reply-To: <1270129975.5155.317.camel@bnicholson-desktop>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox