Re: [BUGS] BUG #5439: Table crash after CLUSTER command

2010-05-04 Thread Stefan Kirchev
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 Grit

Re: [BUGS] BUG #5439: Table crash after CLUSTER command

2010-04-26 Thread Tom Lane
"Stefan Kirchev" writes: > Bug reference: 5439 > Logged by: Stefan Kirchev > Email address: stefan.kirc...@gmail.com > PostgreSQL version: 8.3.3 > Operating system: Linux > Description:Table crash after CLUSTER command > Details: > Hello, > I order to keep good perfo

Re: [BUGS] BUG #5439: Table crash after CLUSTER command

2010-04-26 Thread Kevin Grittner
"Stefan Kirchev" 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 y

[BUGS] BUG #5439: Table crash after CLUSTER command

2010-04-26 Thread Stefan Kirchev
The following bug has been logged online: Bug reference: 5439 Logged by: Stefan Kirchev Email address: stefan.kirc...@gmail.com PostgreSQL version: 8.3.3 Operating system: Linux Description:Table crash after CLUSTER command Details: Hello, I order to keep good perfo