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

[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

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

2010-04-26 Thread Kevin Grittner
Stefan Kirchev stefan.kirc...@gmail.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

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

2010-04-26 Thread Tom Lane
Stefan Kirchev stefan.kirc...@gmail.com 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