Re: Help tuning postgres - Mailing list pgsql-performance

From Tom Lane
Subject Re: Help tuning postgres
Date
Msg-id 2741.1129137684@sss.pgh.pa.us
Whole thread Raw
In response to Re: Help tuning postgres  (Emil Briggs <emil@baymountain.com>)
Responses Re: Help tuning postgres  (Steve Poe <spoe@sfnet.cc>)
List pgsql-performance
Emil Briggs <emil@baymountain.com> writes:
>> Not yet, the db is in production use and I have to plan for a down-time
>> for that... or is it not impacting the activity on the table ?

> It will cause some performance hit while you are doing it.

It'll also lock out writes on the table until the index is rebuilt,
so he does need to schedule downtime.

            regards, tom lane

pgsql-performance by date:

Previous
From: Csaba Nagy
Date:
Subject: Re: Help tuning postgres
Next
From: Steve Poe
Date:
Subject: Re: Help tuning postgres