Re: Help tuning postgres - Mailing list pgsql-performance

From Emil Briggs
Subject Re: Help tuning postgres
Date
Msg-id 200510121133.56955.emil@baymountain.com
Whole thread Raw
In response to Re: Help tuning postgres  (Csaba Nagy <nagy@ecircle-ag.com>)
Responses Re: Help tuning postgres
List pgsql-performance
> [snip]
>
> > Have you tried reindexing your active tables?
>
> 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 sounds like
something is bloating rapidly on your system and the indexes is one possible
place that could be happening.

pgsql-performance by date:

Previous
From: Csaba Nagy
Date:
Subject: Re: Help tuning postgres
Next
From: "Merlin Moncure"
Date:
Subject: Re: Help tuning postgres