Talk About Network

Google


Register and Login
Nick
Password
Register create new account Sign up is FREE and you can post replies, new topics, bookmark posts and more!
Recover lost password


Data Bases > Pgsql Admin > Re: Handling la...
Latest [ Topics | Posts ] Archive Post A New Topic Post a Reply
<< Topic < Post Post 3 of 10 Topic 4890 of 5408
Post > Topic >>

Re: Handling large volumes of data

by postgresql@[EMAIL PROTECTED] (Tino Schwarze) Apr 8, 2008 at 11:55 AM

On Tue, Apr 08, 2008 at 11:42:34AM +0200, Johann Spies wrote:

> 12501 ?        S      0:00 /usr/lib/postgresql/8.1/bin/postmaster -D
/var/lib/postgresql/8.1/main -c
config_file=/etc/postgresql/8.1/main/postgresql.conf
> 12504 ?        D      0:54  \_ postgres: writer process
> 12505 ?        S      1:42  \_ postgres: stats buffer process
> 12506 ?        S      1:03  |   \_ postgres: stats collector process
> 15918 ?        D    1214:28  \_ postgres: autovacuum process   firewall
> 18613 ?        D    130:08  \_ postgres: exilog exilog
146.232.128.197(53907) SELECT
> 18614 ?        S     12:42  \_ postgres: exilog exilog
146.232.128.197(53908) idle
> 31932 ?        D     16:11  \_ postgres: exilog exilog
146.232.128.106(36547) INSERT
> 10380 ?        S      0:00  \_ postgres: log firewall [local] DROP TABLE
waiting

The drop table will wait for the autovacuum to finish. You might want to
kill the autovacuum process (this doesn't do any harm, just aborts the
operation so the drop table may proceed).

Bye,

Tino.

-- 
„Es gibt keinen Weg zum Frieden. Der Frieden ist der Weg.” (Mahatma
Gandhi)

www.craniosacralzentrum.de
www.forteego.de

-- 
Sent via pgsql-admin mailing list (pgsql-admin@[EMAIL PROTECTED]
)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-admin
 




 10 Posts in Topic:
Handling large volumes of data
jspies@[EMAIL PROTECTED]   2008-04-08 11:42:34 
Re: Handling large volumes of data
shoaibmir@[EMAIL PROTECTE  2008-04-08 19:49:04 
Re: Handling large volumes of data
postgresql@[EMAIL PROTECT  2008-04-08 11:55:00 
Re: Handling large volumes of data
jspies@[EMAIL PROTECTED]   2008-04-08 14:16:03 
Re: Handling large volumes of data
michael.monnerie@[EMAIL P  2008-04-08 12:01:14 
Re: Handling large volumes of data
jspies@[EMAIL PROTECTED]   2008-04-08 12:13:36 
Re: Handling large volumes of data
postgresql@[EMAIL PROTECT  2008-04-08 14:00:07 
Re: Handling large volumes of data
michael.monnerie@[EMAIL P  2008-04-08 21:24:07 
Re: Handling large volumes of data
ajs@[EMAIL PROTECTED] (A  2008-04-09 10:00:45 
Re: Handling large volumes of data
tsakai@[EMAIL PROTECTED]   2008-04-08 08:47:06 

Post A Reply:
  Go here to Signup

AddThis Feed Button


About - Advertising - Contact - Frequently Asked Questions - Privacy Policy - Terms of Use - Signup

Contact
tan12V112 Sat Oct 11 12:40:07 CDT 2008.