From: Craig Ringer <ringerc@ringerc.id.au>
To: Colin Taylor <colin.taylor@gmail.com>
Cc: pgsql-performance@postgresql.org
Subject: Re: A Tale of 2 algorithms
Date: Tue, 02 Oct 2012 12:54:38 +0800
Message-ID: <506A738E.8090504@ringerc.id.au> (raw)
In-Reply-To: <CAN6Zwvv_h_C7rDwRAQL_Ufb3xrF261bV0XSeyFB3oZJDsUDLTw@mail.gmail.com>
References: <CAN6Zwvv_h_C7rDwRAQL_Ufb3xrF261bV0XSeyFB3oZJDsUDLTw@mail.gmail.com>
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
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-performance@postgresql.org
Cc: ringerc@ringerc.id.au, colin.taylor@gmail.com
Subject: Re: A Tale of 2 algorithms
In-Reply-To: <506A738E.8090504@ringerc.id.au>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox