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

Re: reindexdb hangs

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Alvaro Herrera <alvherre(at)commandprompt(dot)com>
Cc: dx k9 <bitsandbytes88(at)hotmail(dot)com>, pgsql-admin(at)postgresql(dot)org, pgsql-hackers(at)postgresql(dot)org
Subject: Re: reindexdb hangs
Date: 2007-09-11 00:20:12
Message-ID: 1367.1189470012@sss.pgh.pa.us (view raw or flat)
Thread:
Lists: pgsql-adminpgsql-hackers
Alvaro Herrera <alvherre(at)commandprompt(dot)com> writes:
> I am unsure if I should backpatch to 8.1: the code in cluster.c has
> changed, and while it is relatively easy to modify the patch, this is a
> rare bug and nobody has reported it in CLUSTER (not many people clusters
> temp tables, it seems).  Should I patch only REINDEX?  How far back?

I'd say go as far back as you can conveniently modify the patch for.
This is a potential data-loss bug (even if only for temporary data)
so we ought to take it seriously.

			regards, tom lane

In response to

Responses

pgsql-hackers by date

Next:From: Tom LaneDate: 2007-09-11 01:04:45
Subject: "txn" in pg_stat_activity
Previous:From: Alvaro HerreraDate: 2007-09-10 22:44:45
Subject: Re: A Silly Idea for Vertically-Oriented Databases

pgsql-admin by date

Next:From: Tom LaneDate: 2007-09-11 01:54:05
Subject: Re: Close open transactions soon to avoid wraparound problems
Previous:From: Alvaro HerreraDate: 2007-09-10 22:07:00
Subject: Re: reindexdb hangs

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