From: Bruno Wolff III <bruno@wolff.to>
To: Tsirkin Evgeny <tsurkin@mail.jct.ac.il>
Cc: pgsql-admin@postgresql.org
Subject: Re: preventing deadlocks
Date: Thu, 5 Jan 2006 02:40:30 -0600
Message-ID: <20060105084030.GA32572@wolff.to> (raw)
In-Reply-To: <43BCDA17.6070806@mail.jct.ac.il>
References: <43B10E07.7010503@mail.jct.ac.il>
<20051228202607.GA5194@wolff.to>
<Pine.GSO.4.58_heb2.09.0601021131080.10840@ketubot.jct.ac.il>
<20060104003001.GY82560@pervasive.com>
<Pine.GSO.4.58_heb2.09.0601041035520.7100@ketubot.jct.ac.il>
<20060105065747.GA17322@wolff.to>
<43BCDA17.6070806@mail.jct.ac.il>
On Thu, Jan 05, 2006 at 10:34:31 +0200,
Tsirkin Evgeny <tsurkin@mail.jct.ac.il> wrote:
>
> I understand THAT ,I meant why int will give me more performance.
Because if you have a bunch of processes sitting around waiting for table
locks, the average time to process queries will be higher. If you are
already limited by IO throughput or CPU usage this may not be a big deal,
but in many cases it will be.
> Well i DO have a lot of concurrent queries,that is the whole point.
Then you probably want to do what people have been recommending you do.
> That does not help me .What i want is :
> select 1 from table a where whatever for update;
> issuing this should fire a trigger that does:
You can't trigger on select statements. So this approach won't workin any case.
> select 1 from table counter where a.pkey=counter.ident or something
> however this should only be done for select FOR UPDATE!
> And i can't know that inside the trigger!
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-admin@postgresql.org
Cc: bruno@wolff.to, tsurkin@mail.jct.ac.il
Subject: Re: preventing deadlocks
In-Reply-To: <20060105084030.GA32572@wolff.to>
References: <43B10E07.7010503@mail.jct.ac.il> <20051228202607.GA5194@wolff.to> <Pine.GSO.4.58_heb2.09.0601021131080.10840@ketubot.jct.ac.il> <20060104003001.GY82560@pervasive.com> <Pine.GSO.4.58_heb2.09.0601041035520.7100@ketubot.jct.ac.il> <20060105065747.GA17322@wolff.to> <43BCDA17.6070806@mail.jct.ac.il> <20060105084030.GA32572@wolff.to>
* 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