Skip site navigation (1) Skip section navigation (2)

Re: reindex and copy - deadlock?

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Litao Wu <litaowu(at)yahoo(dot)com>
Cc: pgsql-performance(at)postgresql(dot)org
Subject: Re: reindex and copy - deadlock?
Date: 2004-06-30 19:33:02
Message-ID: 13105.1088623982@sss.pgh.pa.us (view raw or flat)
Thread:
Lists: pgsql-performance
Litao Wu <litaowu(at)yahoo(dot)com> writes:
> Since there are multiple databases and
> there are 170 postgres processes this morning,
> 60 of them are access the problem database,
> and 57 of 60 are non-idle. 

> We only need to gdb those 57 processes, or
> we need gdb 60 or 170?

Potentially the deadlock could be anywhere :-(.  You should definitely
not assume it must be one of the processes connected to the problem
database, because the buffer pool is cluster-wide.

Might be worth setting up a shell script to help.

			regards, tom lane

In response to

Responses

pgsql-performance by date

Next:From: Joseph ShraibmanDate: 2004-07-01 03:14:58
Subject: planner and worst case scenario
Previous:From: Litao WuDate: 2004-06-30 18:45:18
Subject: Re: reindex and copy - deadlock?

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group