Postgres Pro
Downloads
Home   >   mailing lists

Re: "too many trigger records found for relation xyz" - Mailing list pgsql-general

From Mikko Partio
Subject Re: "too many trigger records found for relation xyz"
Date
Msg-id 2ca799770804080405l10083a7dpd34d3a96f8e6657f@mail.gmail.com
Whole thread Raw
In response to Re: "too many trigger records found for relation xyz"  (Zdenek Kotala <Zdenek.Kotala@Sun.COM>)
Responses Re: "too many trigger records found for relation xyz"  (Zdenek Kotala <Zdenek.Kotala@Sun.COM>)
List pgsql-general
Tree view


On Tue, Apr 8, 2008 at 1:45 PM, Zdenek Kotala <Zdenek.Kotala@sun.com> wrote:
Mikko Partio napsal(a):


Should I try remove one of the duplicate rows from pg_class?

Try it with caution. You should use ctid column to refer to exact row.

Try before:

select oid, ctid, xmin, xmax, cmin, cmax, relname from pg_class where oid = 294397;

If both row are identical or not.


 # select oid, ctid, xmin, xmax, cmin, cmax, relname from pg_class where oid = 294397;
  oid   |   ctid    |    xmin    |    xmax    | cmin | cmax |   relname
--------+-----------+------------+------------+------+------+--------------
 294397 | (1125,36) | 3944654557 |          0 |   35 |   35 | abc
 294397 | (1124,55) | 3943984380 | 3943984642 |    3 |    3 | abc
(2 rows)

Which one should I remove? What is the worst case scenario for the delete? The database is 1,5TB so I would rather not restore it from backups :-)

Regards

Mikko

pgsql-general by date:

Previous
From: Zdenek Kotala
Date:
Subject: Re: "too many trigger records found for relation xyz"
Next
From: Gregory Stark
Date:
Subject: Re: select distinct and index usage