Postgres Pro
Downloads
Home   >   mailing lists

Re: Deadlock of REINDEX and SELECT queries in PostgresSQL 7.4 - Mailing list pgsql-general

From John R Pierce
Subject Re: Deadlock of REINDEX and SELECT queries in PostgresSQL 7.4
Date
Msg-id 4E855952.4070502@hogranch.com
Whole thread Raw
In response to Deadlock of REINDEX and SELECT queries in PostgresSQL 7.4  ("Tendulker, Shivanand G Prabhu (SSTL)" <shivanand.tendulker@hp.com>)
List pgsql-general
Tree view 
On 09/29/11 8:49 AM, Tendulker, Shivanand G Prabhu (SSTL) wrote:
>
> Please provide help in resolving this issue.
>

7.4 is an ancient dead end release.  update to something released this
century, like 8.4 or 9.0... where, btw, vacuum, analyze, and reindex are
now automatic and no longer need doing manually except in very unusual
situations.




--
john r pierce                            N 37, W 122
santa cruz ca                         mid-left coast

pgsql-general by date:

Previous
From: Venkat Balaji
Date:
Subject: Re: could not access file "$libdir/pg_buffercache": No such file or directory
Next
From: Craig Ringer
Date:
Subject: Re: Decimal vs. Bigint memory usage