Re: PostgreSQL clustering VS MySQL clustering - Mailing list pgsql-performance

From Tom Lane
Subject Re: PostgreSQL clustering VS MySQL clustering
Date
Msg-id 3582.1106667713@sss.pgh.pa.us
Whole thread Raw
In response to Re: PostgreSQL clustering VS MySQL clustering  (Hannu Krosing <hannu@tm.ee>)
Responses Re: PostgreSQL clustering VS MySQL clustering  (Hannu Krosing <hannu@tm.ee>)
List pgsql-performance
Hannu Krosing <hannu@tm.ee> writes:
> Why is removing index entries essential ?

Because once you re-use the tuple slot, any leftover index entries would
be pointing to the wrong rows.

            regards, tom lane

pgsql-performance by date:

Previous
From: Don Drake
Date:
Subject: Postgres stopped running (shmget failed)
Next
From: Tom Lane
Date:
Subject: Re: Postgres stopped running (shmget failed)