Thanks All for the response, finally we figure it out. The slow is due to
high number of dead rows on main table, repack these tables wipe out the
issue.
On Mar 6, 2015 9:31 PM, "Merlin Moncure" wrote:
> On Wed, Mar 4, 2015 at 1:31 PM, Soni M wrote:
> > Hello All,
> >
> > Master db size 1.5 TB
>
On Wed, Mar 4, 2015 at 1:31 PM, Soni M wrote:
> Hello All,
>
> Master db size 1.5 TB
> All postgres 9.1.13 installed from RHEL package.
> It has streaming replica and slony replica to another servers.
>
> Server performance is slower than usual, before that, there's a big query
> got cancelled and
On 3/4/15 1:31 PM, Soni M wrote:
Hello All,
Master db size 1.5 TB
All postgres 9.1.13 installed from RHEL package.
It has streaming replica and slony replica to another servers.
Server performance is slower than usual, before that, there's a big
query got cancelled and then performance get slow
