Postgres Pro
Downloads
Home   >   mailing lists

Re: A Tale of 2 algorithms - Mailing list pgsql-performance

From Colin Taylor
Subject Re: A Tale of 2 algorithms
Date
Msg-id CAN6Zwvv0_Yerh7YNSHu+UmfyrOwzMGULDctkQBvqp6otgJA3Ew@mail.gmail.com
Whole thread Raw
In response to Re: A Tale of 2 algorithms  (Craig Ringer <ringerc@ringerc.id.au>)
List pgsql-performance
Tree view


On Tue, Oct 2, 2012 at 5:54 PM, Craig Ringer <ringerc@ringerc.id.au> wrote:
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

The table and its indexes, I have them in separate tablespaces so its quite apparent.

pgsql-performance by date:

Previous
From: Jeff Janes
Date:
Subject: Re: how to avoid deadlock on masive update with multiples delete
Next
From: Igor Neyman
Date:
Subject: Re: how to avoid deadlock on masive update with multiples delete