From: | Bruce Momjian <maillist(at)candle(dot)pha(dot)pa(dot)us> |
---|---|
To: | bibach(at)infomansol(dot)com (Brandon Ibach) |
Cc: | hackers(at)postgreSQL(dot)org |
Subject: | Re: [HACKERS] Table corrupt? |
Date: | 1998-06-09 20:32:25 |
Message-ID: | 199806092032.QAA03998@candle.pha.pa.us |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-hackers |
>
> Hey, guys...
> I suppose this probably belongs in questions, but I thought I might
> get a quicker answer here. I have a table in a customer's database
> that has gotten quite large via lack of vacuuming (57MB). Queries
> involving this table started failing in the form of the backend just
> sitting there chugging away on the CPU (but not disk so much) for
> hours on end.
> This began about 24 hours ago, and as of about 12 hours ago, no
> queries on this table work. I started a vacuum about 3 hours ago, and
> it has had upper-90s percent CPU usage the whole time, and still
> hasn't completed.
> Any ideas on what might be going on here? And, if postgres won't
> be able to access the table, is there any hope of extracting rows from
> the raw database file, such that I could reconstruct the table?
> Please cc responses to me directly, as I'm only on the digest list,
> and thanks in advance for any advice/help!
pg_dump -t tablename, drop and reload?
--
Bruce Momjian | 830 Blythe Avenue
maillist(at)candle(dot)pha(dot)pa(dot)us | Drexel Hill, Pennsylvania 19026
+ If your life is a hard drive, | (610) 353-9879(w)
+ Christ can be your backup. | (610) 853-3000(h)
From | Date | Subject | |
---|---|---|---|
Next Message | Brandon Ibach | 1998-06-09 21:13:12 | Re: [HACKERS] Table corrupt? |
Previous Message | Brandon Ibach | 1998-06-09 20:21:12 | Table corrupt? |