From: | Martijn van Oosterhout <kleptog(at)svana(dot)org> |
---|---|
To: | Henrik Steffen <steffen(at)city-map(dot)de> |
Cc: | pgsql-general(at)postgresql(dot)org |
Subject: | Re: Serious Crash last Friday |
Date: | 2002-06-17 12:05:49 |
Message-ID: | 20020617220549.E31261@svana.org |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
On Mon, Jun 17, 2002 at 01:44:22PM +0200, Henrik Steffen wrote:
> > so, "parsed data" <= "length" is good, though hopefully it's not too much
> > less.
>
> well,
>
> parsed data == 825242056
> length == 84
>
> I fear, it's toooooo much less.
That's wierd. Something is really wierd here, as that number is 0x313031C8,
which has '101' in text format. What datatypes are you using. Seems more
like a bug in my program.
> BTW: The count of rows printed by the pgfsck increases permanently.
> In my last mail, there were only 814 rows, 2 hours ago, there were 1200
> rows, now there are 1600 rows !!! What does this mean? In the table, there
> are only 185 rows like before.
>
> There is always about 800000000 parsed data, and about 100-150 of length.
Are you using -a? It will print all rows, including deleted ones. That will
obviously continue to increase during usage. Are you doing this on a live
database?
--
Martijn van Oosterhout <kleptog(at)svana(dot)org> http://svana.org/kleptog/
> There are 10 kinds of people in the world, those that can do binary
> arithmetic and those that can't.
From | Date | Subject | |
---|---|---|---|
Next Message | Dustin Dortch | 2002-06-17 13:06:53 | Stored Procedures for Shell Execution |
Previous Message | Henrik Steffen | 2002-06-17 11:44:22 | Re: Serious Crash last Friday |