Re: Repeated semop calls

From: "Anand Kumar, Karthik" <Karthik(dot)AnandKumar(at)classmates(dot)com>
To: Jeff Janes <jeff(dot)janes(at)gmail(dot)com>
Cc: PostgreSQL General <pgsql-general(at)postgresql(dot)org>
Subject: Re: Repeated semop calls
Date: 2014-06-27 20:10:52
Message-ID: CFD31CB4.84C56%karthik.anandkumar@classmates.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

>Are there a lot of tuples in the table that have been inserted or
updated by still-open transactions?

Yes, there are likely to be inserts. That table is a log capture table
used by our replication software, so essentially every
update/delete/insert will have a record inserted into the table. It has no
updates. The only thing that deletes from it is the process that had all
the semop calls.

We¹ll look into the postgres minor upgrade and recompile, thanks.

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Pavel Stehule 2014-06-27 20:53:03 plpgsql_check is for PostgreSQL 9.2 now
Previous Message Anand Kumar, Karthik 2014-06-27 20:05:36 Re: Repeated semop calls