Re: does this look more like a possible bug or more like a possible hardware problem...? (long) - Mailing list pgsql-general

From Frank van Vugt
Subject Re: does this look more like a possible bug or more like a possible hardware problem...? (long)
Date
Msg-id 200403101748.01104.ftm.van.vugt@foxi.nl
Whole thread Raw
In response to Re: does this look more like a possible bug or more like a possible hardware problem...? (long)  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-general
Some additional info:

# select * from pg_class where relname = 'article_property_tree';
-[ RECORD 1 ]--
+-------------------------------------------------------------------
relname        | article_property_tree
relnamespace   | 2200
reltype        | 8349772
relowner       | 1000
relam          | 0
relfilenode    | 8349771
relpages       | 4
reltuples      | 299
reltoastrelid  | 8349775
reltoastidxid  | 0
relhasindex    | t
relisshared    | f
relkind        | r
relnatts       | 6
relchecks      | 1
reltriggers    | 3
relukeys       | 0
relfkeys       | 0
relrefs        | 0
relhasoids     | t
relhaspkey     | t
relhasrules    | f
relhassubclass | f
relacl         | {vugtf=a*r*w*d*R*x*t*/vugtf,=arwdRxt/vugtf,postgres=arwdRxt/
vugtf}
-[ RECORD 2 ]--
+-------------------------------------------------------------------
relname        | article_property_tree
relnamespace   | 2200
reltype        | 8354495
relowner       | 1000
relam          | 0
relfilenode    | 8354494
relpages       | 4
reltuples      | 299
reltoastrelid  | 8354498
reltoastidxid  | 0
relhasindex    | t
relisshared    | f
relkind        | r
relnatts       | 6
relchecks      | 1
reltriggers    | 5
relukeys       | 0
relfkeys       | 0
relrefs        | 0
relhasoids     | t
relhaspkey     | t
relhasrules    | f
relhassubclass | f
relacl         | {vugtf=a*r*w*d*R*x*t*/vugtf,=arwdRxt/vugtf,postgres=arwdRxt/
vugtf}







--
Best,




Frank.


pgsql-general by date:

Previous
From: Tom Lane
Date:
Subject: Re: does this look more like a possible bug or more like a possible hardware problem...? (long)
Next
From: Stephan Szabo
Date:
Subject: Re: [NEWBIE] need help optimizing this query