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

Re: BUG #5439: Table crash after CLUSTER command

From: Stefan Kirchev <stefan(dot)kirchev(at)gmail(dot)com>
To: Kevin Grittner <Kevin(dot)Grittner(at)wicourts(dot)gov>
Cc: pgsql-bugs(at)postgresql(dot)org
Subject: Re: BUG #5439: Table crash after CLUSTER command
Date: 2010-05-04 12:30:49
Message-ID: k2h41dff85c1005040530y20457eecyb9fdf1859bac8ef0@mail.gmail.com (view raw or flat)
Thread:
Lists: pgsql-bugs
Thank you for the replay.
I will follow your advice. First will upgrade to 8.4 (or at least to the
latest 8.3 release), than will try to reproduce the error.
For now I will stick to using VACUUM FULL and REINDEX.
Thanks again.
Best Regards
Stefan Kirchev

On Mon, Apr 26, 2010 at 5:06 PM, Kevin Grittner <Kevin(dot)Grittner(at)wicourts(dot)gov
> wrote:

> "Stefan Kirchev" <stefan(dot)kirchev(at)gmail(dot)com> wrote:
>
> > PostgreSQL version: 8.3.3
>
> > Description:        Table crash after CLUSTER command
>
> > I order to keep good performance on tables CLUSTER is done
> > regularly on each table every Sunday. Almost every time we loose a
> > table which must be recreated afterward. The error yield is:
> > pnp=# select * from  alcatel_bss_kpi_tmp.cs_hourly_kpi limit 1;
> > ERROR:  could not open relation 1663/16404/2426042: No such file
> > or directory
>
> My first recommendation would be to apply the fixes for the bugs
> found during the last two years by upgrading your executable to
> 8.3.10.  This does not require a dump and load, but if you have any
> GiST indexes, or if you have hash indexes on intervals, you will
> need to rebuild those indexes.  To get more details, see:
>
> http://www.postgresql.org/docs/8.3/static/release
>
> FWIW, we CLUSTER a few very small, very frequently updated tables
> daily in about 100 databases to ensure that we recover from bloat
> from the occasional long-running transaction, and we've *never*
> seen this.
>
> If you actually need to cluster *every* table *every* week, you
> should review your vacuum policy.
>
> -Kevin
>

In response to

pgsql-bugs by date

Next:From: Craig RingerDate: 2010-05-04 13:32:51
Subject: Re: BUG #5447: VPATH install postgres.bki
Previous:From: Craig RingerDate: 2010-05-04 12:24:18
Subject: Re: BUG #5447: VPATH install postgres.bki

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