Skip site navigation (1) Skip section navigation (2)

Re: PostgreSQL clustering VS MySQL clustering

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Hannu Krosing <hannu(at)tm(dot)ee>
Cc: Simon Riggs <simon(at)2ndquadrant(dot)com>,Tatsuo Ishii <t-ishii(at)sra(dot)co(dot)jp>, marty(at)outputservices(dot)com,herve(at)elma(dot)fr, pgsql-performance(at)postgresql(dot)org
Subject: Re: PostgreSQL clustering VS MySQL clustering
Date: 2005-01-25 15:41:53
Message-ID: 3582.1106667713@sss.pgh.pa.us (view raw or flat)
Thread:
Lists: pgsql-performance
Hannu Krosing <hannu(at)tm(dot)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

In response to

Responses

pgsql-performance by date

Next:From: Tom LaneDate: 2005-01-25 16:18:05
Subject: Re: Postgres stopped running (shmget failed)
Previous:From: Don DrakeDate: 2005-01-25 15:10:50
Subject: Postgres stopped running (shmget failed)

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group