Re: Serious Crash last Friday

From: "Henrik Steffen" <steffen(at)city-map(dot)de>
To: "Tom Lane" <tgl(at)sss(dot)pgh(dot)pa(dot)us>
Cc: "pg" <pgsql-general(at)postgresql(dot)org>
Subject: Re: Serious Crash last Friday
Date: 2002-07-11 09:09:34
Message-ID: 107f01c228ba$ad7eed80$7100a8c0@topconcepts.net
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

ok, I now found out that the table altseiten with the oid 16584
has got the reltoastrelid 16586. this is the oid of pg_toast_16584 which
has the reltoastidxid 16588. this again is the oid of pg_toast_16584_idx.

now doing pg_filedump -i 16588 gives 1213 lines, and in Item 109 there is a
block id: 1048595

Then Item 278 has got Block Id 43, Item 279 Block Id 1, Item 280 Block Id 1,
Item 281 Block Id 52 ... looks strange, too, doesn't it?

what does this mean?

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(at)topconcepts(dot)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: "Tom Lane" <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: "Henrik Steffen" <steffen(at)city-map(dot)de>
Cc: "pg" <pgsql-general(at)postgresql(dot)org>
Sent: Thursday, July 11, 2002 9:00 AM
Subject: Re: [GENERAL] Serious Crash last Friday

> "Henrik Steffen" <steffen(at)city-map(dot)de> writes:
> > yes, you are right 16584 is the oid of the table altseiten, but the
> > reltoastidxid is still 0.
>
> Oh, my mistake --- you have to look at the toast table identified by
> reltoastrelid, and then its reltoastidxid fingers the index. For
> example:
>
> test72=# create table foo (t text);
> CREATE
> test72=# select oid,relname,relkind,reltoastrelid,reltoastidxid from
pg_class order by oid desc limit 5;
> oid | relname | relkind | reltoastrelid | reltoastidxid
> --------+---------------------+---------+---------------+---------------
> 812033 | pg_toast_812029_idx | i | 0 | 0
> 812031 | pg_toast_812029 | t | 0 | 812033
> 812029 | foo | r | 812031 | 0
> 812026 | manufacturer_z_key | i | 0 | 0
> 812024 | manufacturer | r | 0 | 0
> (5 rows)
>
> Here, foo is the base table, pg_toast_812029 is its toast table,
> pg_toast_812029_idx is the index.
>
> regards, tom lane
>
> ---------------------------(end of broadcast)---------------------------
> TIP 6: Have you searched our list archives?
>
> http://archives.postgresql.org

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Mark O'Connor 2002-07-11 09:30:35 Re: XML to Postgres conversion
Previous Message Curt Sampson 2002-07-11 09:04:20 Re: Linux max on shared buffers?