| From: | Greg Smith <greg(at)2ndquadrant(dot)com> |
|---|---|
| To: | Vick Khera <vivek(at)khera(dot)org> |
| Cc: | Marcin Krol <mrkafk(at)gmail(dot)com>, pgsql-general(at)postgresql(dot)org |
| Subject: | Re: CLUSTER cannot complete |
| Date: | 2010-02-16 00:38:49 |
| Message-ID: | 4B79E919.7060605@2ndquadrant.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
Vick Khera wrote:
> On Mon, Feb 15, 2010 at 9:54 AM, Marcin Krol <mrkafk(at)gmail(dot)com> wrote:
>
>> I didn't add or delete many rows from that table. Quite a lot of UPDATEs are
>> running daily, though.
>>
>
> Every update is equal to insert + delete, except in certain
> circumstances in 8.3 and above.
>
Well, it's still an insert + delete of the actual data row itself even
in 8.3, the later versions just optimize how that impacts the index
related changes there better.
--
Greg Smith 2ndQuadrant US Baltimore, MD
PostgreSQL Training, Services and Support
greg(at)2ndQuadrant(dot)com www.2ndQuadrant.us
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Tom Lane | 2010-02-16 04:39:21 | Re: Hosting Account with PostgreSQL and PHP? |
| Previous Message | Peter Geoghegan | 2010-02-16 00:04:22 | Having a plpgsql function return multiple rows that indicate its progress in a cursor like fashion |