Re: Serious Crash last Friday

Поиск
Список
Период
Сортировка
От Henrik Steffen
Тема Re: Serious Crash last Friday
Дата
Msg-id 04b601c215f4$5367a4a0$7100a8c0@topconcepts.net
обсуждение исходный текст
Ответ на Serious Crash last Friday  ("Henrik Steffen" <steffen@city-map.de>)
Ответы Re: Serious Crash last Friday  (Martijn van Oosterhout <kleptog@svana.org>)
Список pgsql-general
> 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.

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.


Mit freundlichem Gruß

Henrik Steffen
Geschäftsführer

top concepts Internetmarketing GmbH
Am Steinkamp 7 - D-21684 Stade - Germany
--------------------------------------------------------
http://www.topconcepts.com          Tel. +49 4141 991230
mail: steffen@topconcepts.com       Fax. +49 4141 991233
--------------------------------------------------------
24h-Support Hotline:  +49 1908 34697 (EUR 1.86/Min,topc)
--------------------------------------------------------
System-Partner gesucht: http://www.franchise.city-map.de
--------------------------------------------------------
Handelsregister: AG Stade HRB 5811 - UstId: DE 213645563
--------------------------------------------------------

----- Original Message -----
From: "Martijn van Oosterhout" <kleptog@svana.org>
To: "Henrik Steffen" <steffen@city-map.de>
Cc: <pgsql-general@postgresql.org>
Sent: Monday, June 17, 2002 12:02 PM
Subject: Re: [GENERAL] Serious Crash last Friday


> On Mon, Jun 17, 2002 at 11:38:00AM +0200, Henrik Steffen wrote:
> > same employee table (but after initdb, and restored from fridays dump)
> >
> > how can i find out the correct length of the tuples?
>
> Tuple incorrect length (parsed data=xxxxxx, length=xxx)
>
> "parsed data" is what was processed
> "length" is the amount allocated in the tuple header
>
> so, "parsed data" <= "length" is good, though hopefully it's not too much
> less.
>
> HTH,
> --
> Martijn van Oosterhout   <kleptog@svana.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.
>
> ---------------------------(end of broadcast)---------------------------
> TIP 3: if posting/reading through Usenet, please send an appropriate
> subscribe-nomail command to majordomo@postgresql.org so that your
> message can get through to the mailing list cleanly


В списке pgsql-general по дате отправления:

Предыдущее
От: Herbert Liechti
Дата:
Сообщение: Re: TEXT and NULL...
Следующее
От: Martijn van Oosterhout
Дата:
Сообщение: Re: Serious Crash last Friday