pg.ddx.io  pgsql-admin@postgresql.org mailing list archive  
help / color / mirror / Atom feed
From: Tsirkin Evgeny <tsurkin@mail.jct.ac.il>
To: Bruno Wolff III <bruno@wolff.to>
Cc: pgsql-admin@postgresql.org
Subject: Re: preventing deadlocks
Date: Thu, 05 Jan 2006 10:53:40 +0200
Message-ID: <43BCDE94.3030902@mail.jct.ac.il> (raw)
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>


Bruno,thanks for the answer but this was not at ALL that i asked.
Neither mind .
Note however, how polite i am .
Thanks anyway.
Evgeny

Bruno Wolff III wrote:

>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!
>>    
>>
>
>---------------------------(end of broadcast)---------------------------
>TIP 1: if posting/reading through Usenet, please send an appropriate
>       subscribe-nomail command to majordomo@postgresql.org so that your
>       message can get through to the mailing list cleanly
>  
>




view thread (12+ messages)  latest in thread

Message-ID: <43BCDE94.3030902@mail.jct.ac.il>
Permalink:  ../43BCDE94.3030902@mail.jct.ac.il/
Also on:    postgresql.org/message-id/43BCDE94.3030902@mail.jct.ac.il

 · 

reply

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: tsurkin@mail.jct.ac.il, bruno@wolff.to
  Subject: Re: preventing deadlocks
  In-Reply-To: <43BCDE94.3030902@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> <20060105084030.GA32572@wolff.to> <43BCDE94.3030902@mail.jct.ac.il>

* 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