Home > mailing lists

Postgres 8.3.10 Alter Table Waiting issue - Mailing list pgsql-general

From	Pratheeban Jebasingh Tharmaraj
Subject	Postgres 8.3.10 Alter Table Waiting issue
Date	June 16, 2011 17:48:39
Msg-id	BANLkTikQyR_Mmg9uLmRXfNP4XQC5azG4Hg@mail.gmail.com Whole thread Raw
Responses	Re: Postgres 8.3.10 Alter Table Waiting issue
List	pgsql-general

Hi Team,

I am trying to add column to the table that's hanging.

alter table hr_firms add column_name biginit;

This is the lock I see in the db

relation | 564709 | 586888 | | | | | | | | 1/8 | 1871 | AccessExclusiveLock | f

Version of postgres: 8.3.10

Is it known issue or any fix available?

--
With Warm Regards,

Pratheeban .T

From: BRUSSER Michael
Date: 16 June 2011, 17:34:39
Subject: Re: Invalid byte sequence for encoding "UTF8": 0xedbebf

From: "Simon Windsor"
Date: 16 June 2011, 18:10:12
Subject: Postgres performance and the Linux scheduler