Skip site navigation (1) Skip section navigation (2)

Re: A Tale of 2 algorithms

From: Craig Ringer <ringerc(at)ringerc(dot)id(dot)au>
To: Colin Taylor <colin(dot)taylor(at)gmail(dot)com>
Cc: pgsql-performance(at)postgresql(dot)org
Subject: Re: A Tale of 2 algorithms
Date: 2012-10-02 04:54:38
Message-ID: 506A738E.8090504@ringerc.id.au (view raw or flat)
Thread:
Lists: pgsql-performance
On 10/02/2012 05:24 AM, Colin Taylor wrote:
> My thoughts are: surely 0-row updates dont cause this or have impact on
> the vacuum. I'm still doing the same updates after all why have things
> degenerated so badly?

What exactly is bloating? Have you checked? Is it the table its self? 
One of its indexes? Something else?

--
Craig Ringer


In response to

Responses

pgsql-performance by date

Next:From: Heikki LinnakangasDate: 2012-10-02 08:11:40
Subject: Re: deadlock_timeout affect on performance
Previous:From: Greg WilliamsonDate: 2012-10-02 00:35:58
Subject: Re: Inserts in 'big' table slowing down the database

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group