Re: Is it possible to know where is the "deadlock"

From: "Claus Guttesen" <kometen(at)gmail(dot)com>
To: arnaulist(at)andromeiberica(dot)com
Cc: "PostgreSQL Performance" <pgsql-performance(at)postgresql(dot)org>
Subject: Re: Is it possible to know where is the "deadlock"
Date: 2007-07-19 17:05:24
Message-ID: b41c75520707191005n500b1286s2ac377535c72b42e@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-performance

> The iostat -c says about 8% of time waiting for IO. I'm afraid this
> is due to locks between concurrent queries, is there anyway to have more
> info about?

I do believe that if you told what OS you're running, what pg-version
you're running, what type of sql-statements you perform the list can
provide some help.

--
regards
Claus

When lenity and cruelty play for a kingdom,
the gentlest gamester is the soonest winner.

Shakespeare

In response to

Browse pgsql-performance by date

  From Date Subject
Next Message Tom Lane 2007-07-19 17:25:38 Re: User concurrency thresholding: where do I look?
Previous Message Bill Moran 2007-07-19 17:03:26 Re: Is it possible to know where is the "deadlock"