<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 3.2//EN">
<HTML>
<HEAD>
<META HTTP-EQUIV="Content-Type" CONTENT="text/html; charset=iso-8859-1">
<META NAME="Generator" CONTENT="MS Exchange Server version 6.5.7653.38">
<TITLE>RE: [BUGS] BUG #4567: Clustering on GIST INDEX clobbers records in table intermittently </TITLE>
</HEAD>
<BODY>
<!-- Converted from text/plain format -->
<P><FONT SIZE=2>"Regina Obe" <robe.dnd@cityofboston.gov> writes:<BR>
> Description: Clustering on GIST INDEX clobbers records in table<BR>
> intermittently<BR>
<BR>
> This doesn't always happen to me but does intermittently, and for others it<BR>
> happens all the time.<BR>
<BR>
> I wonder whether this is fixed by this recent patch:<BR>
> <A HREF="http://archives.postgresql.org/pgsql-committers/2008-12/msg00053.php">http://archives.postgresql.org/pgsql-committers/2008-12/msg00053.php</A><BR>
<BR>
> The pre-patch behavior would've depended on the value of a<BR>
> never-initialized struct field, so the erratic behavior is explained<BR>
> by varying contents of memory. I'm unable to make it happen in an<BR>
> assert-enabled build, but that's probably because the initial contents<BR>
> of a palloc'd chunk are never zeroes in such a build.<BR>
<BR>
> regards, tom lane<BR>
<BR>
Tom,<BR>
<BR>
Thanks for the quick response on this. <BR>
<BR>
Paul,<BR>
You think by chance you can test out the patch since you can make this bug happen consistently on your build.<BR>
<BR>
Thanks,<BR>
Regina<BR>
<BR>
<BR>
<BR>
</FONT>
</P>
</BODY>
</HTML>
<HTML><BODY><P><hr size=1></P>
<P><STRONG>
The substance of this message, including any attachments, may be confidential, legally privileged and/or exempt from disclosure pursuant to Massachusetts law. It is intended solely for the addressee. If you received this in error, please contact the sender and delete the material from any computer.
</STRONG></P></BODY></HTML>
<P><hr size=1></P>
<P><STRONG><font size="2" color="339900"> Help make the earth a greener place. If at all possible resist printing this email and join us in saving paper. </p> <p> </font></STRONG></P>