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
Views: Raw Message | Whole Thread | Download mbox | Resend email
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

Browse pgsql-performance by date

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