From: | Anil Amarakoon <anil(at)server(dot)awcoldstream(dot)com> |
---|---|
To: | "pgsql-admin(at)postgreSQL(dot)org" <pgsql-admin(at)postgreSQL(dot)org> |
Subject: | Vacuum Problem |
Date: | 1998-07-03 04:47:00 |
Message-ID: | 359C6244.F78A755@awcoldstream.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-admin |
Hi all!
I do have postgres 6.3 running on Redhat 5.0, pentium 166 with 32MB and
100MB swap.
Recently I copied delimited files that contained about 40,000 rows to
three different tables. Once I had to drop the table also. Then I
created another table with those three tables. Each table has 10-15
fields of text,int,floate and datetime types.
Finally I ran vacuum from psql.
It is running for last two days. CPU% started from 45% and slowly
getting close 100%. This afternoon it was
83%. on ps command Status ~> R and Timer counter runs..
Till this afternoon I had a access to tables through another tty. I
lost that this afternoon and when try psql foo, session hangs.
Can I kill the vacuum?
Any ideas are higly appriciated.
Anil
From | Date | Subject | |
---|---|---|---|
Next Message | The Hermit Hacker | 1998-07-04 02:34:59 | Re: [ADMIN] Online Backup |
Previous Message | Jeremy G Byrne | 1998-07-03 04:08:51 | Online Backup |