Re: Deadlock of REINDEX and SELECT queries in PostgresSQL 7.4

From: John R Pierce <pierce(at)hogranch(dot)com>
To: pgsql-general(at)postgresql(dot)org
Subject: Re: Deadlock of REINDEX and SELECT queries in PostgresSQL 7.4
Date: 2011-09-30 05:53:22
Message-ID: 4E855952.4070502@hogranch.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

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

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Craig Ringer 2011-09-30 06:00:39 Re: Decimal vs. Bigint memory usage
Previous Message Venkat Balaji 2011-09-30 05:29:03 Re: could not access file "$libdir/pg_buffercache": No such file or directory