From: Louie Kwan <lkwan@nuvo.com>
To: 'pgsql-sql@postgresql.org' <pgsql-sql@postgresql.org>
Subject: PostgreSQL is hanging up !?
Date: Thu, 27 May 2004 16:43:47 -0400
Message-ID: <FB4FDC17A002D711BC0C009027DE84AF027F6DB1@EXCHANGE.nuvo.com> (raw)
I have created several domains at Postgresql and I am trying to create some
views on a domain "dcenter" using
create or replace view cw_nodir_v
as
select ...
However, my PostgreSQL hangs up.. on this domain only but not in other
domains...
Don't want to reboot PQ, and methods I can find out the root causes and fix
the issues... and log I can look into..
Any help is appreciated. Thanks in advance.
[root@sedna itm]# ps -ef | grep post
postgres 2162 1 0 May19 ? 00:00:12 /usr/bin/postmaster
-i -p 5432
postgres 2164 2162 0 May19 ? 00:00:02 postgres: stats
buffer process
postgres 2165 2164 0 May19 ? 00:00:05 postgres: stats
collector process
postgres 3016 2162 0 May19 ? 00:00:00 postgres: eoc_sim
eocdb 206.116.78.175 idle
postgres 3018 2162 0 May19 ? 00:00:03 postgres: eoc_sim
eocdb 206.116.78.175 SELECT waiting
postgres 14988 2162 0 15:42 ? 00:00:00 postgres: eoc_core
eocdb 206.116.78.128 SELECT waiting
postgres 16129 2162 23 16:03 ? 00:05:26 postgres: dcenter
eocdb 206.116.78.50 SELECT
postgres 16826 2162 0 16:17 ? 00:00:00 postgres: dcenter
eocdb 206.116.78.128 DROP VIEW waiting
root 17269 3236 0 16:26 pts/3 00:00:00 grep post
Louie Kwan
lkwan@nuvo.com
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 using the --to and --cc options:
reply via email
To: pgsql-sql@postgresql.org
Cc: lkwan@nuvo.com
Subject: Re: PostgreSQL is hanging up !?
In-Reply-To: <FB4FDC17A002D711BC0C009027DE84AF027F6DB1@EXCHANGE.nuvo.com>
* 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