From: Kevin Grittner <Kevin.Grittner@wicourts.gov>
To: Mladen Gogala <mladen.gogala@vmsinfo.com>
Cc: pgsql-performance@postgresql.org
Subject: Re: long wait times in ProcessCatchupEvent()
Date: Thu, 30 Dec 2010 08:50:00 -0600
Message-ID: <4D1C47B80200002500038DBB@gw.wicourts.gov> (raw)
In-Reply-To: <4D1BD84C.6080706@vmsinfo.com>
References: <lptyhw1wml.fsf@warpcore.i.openit.de>
<4D1B8BD9.4060105@emolecules.com>
<304.1293652739@sss.pgh.pa.us>
<4D1BD84C.6080706@vmsinfo.com>
Mladen Gogala <mladen.gogala@vmsinfo.com> wrote:
> May I ask what exactly is "sinval"? I took a look at Craig's
> problem and your description but I wasn't able to figure out what
> is sinval lock and what does it lock? I apologize if the question
> is stupid.
This area could probably use a README file, but you can get a good
idea from the comment starting on line 30 of this file:
http://git.postgresql.org/gitweb?p=postgresql.git;a=blob;f=src/backend/storage/ipc/sinvaladt.c;h=791...
It has to do with communication between processes regarding
invalidation of the shared cache.
-Kevin
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients from your mail client; the link fills in
the headers below: reply via email
Some clients, webmail especially, drop In-Reply-To and References from
a link, and the reply then starts a new thread: use the mbox below.
To: pgsql-performance@postgresql.org
Cc: Kevin.Grittner@wicourts.gov, mladen.gogala@vmsinfo.com
Subject: Re: long wait times in ProcessCatchupEvent()
In-Reply-To: <4D1C47B80200002500038DBB@gw.wicourts.gov>
References: <lptyhw1wml.fsf@warpcore.i.openit.de> <4D1B8BD9.4060105@emolecules.com> <304.1293652739@sss.pgh.pa.us> <4D1BD84C.6080706@vmsinfo.com> <4D1C47B80200002500038DBB@gw.wicourts.gov>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox