Re: Help - corruption issue?

From: Tomas Vondra <tv(at)fuzzy(dot)cz>
To: pgsql-general(at)postgresql(dot)org
Subject: Re: Help - corruption issue?
Date: 2011-04-25 19:08:28
Message-ID: 4DB5C6AC.60706@fuzzy.cz
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Dne 25.4.2011 20:40, Phoenix Kiula napsal(a):
>
> I did a COPY FROM and populated the entire table. In my hard disk, the
> space consumption went up by 64GB.

So you have dumped the table piece by piece, it worked, and now you have
a complete copy of the table? All the rows?

> Yet, when I do a "SELECT * FROM mytable LIMIT 1" the entire DB
> crashes. There is no visible record.
>
> What's this?

Hmmmm, that's strange ... you're saying that's a freshly populated DB?

Tomas

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Tom Lane 2011-04-25 19:10:15 Re: Help - corruption issue?
Previous Message Phoenix Kiula 2011-04-25 18:40:00 Re: Help - corruption issue?