| From: | Frank van Vugt <ftm(dot)van(dot)vugt(at)foxi(dot)nl> |
|---|---|
| To: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> |
| Cc: | pgsql-general(at)postgresql(dot)org |
| Subject: | Re: does this look more like a possible bug or more like a possible hardware problem...? (long) |
| Date: | 2004-03-10 16:48:01 |
| Message-ID: | 200403101748.01104.ftm.van.vugt@foxi.nl |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | 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.
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Tom Lane | 2004-03-10 16:50:22 | Re: does this look more like a possible bug or more like a possible hardware problem...? (long) |
| Previous Message | Stephan Szabo | 2004-03-10 16:47:47 | Re: [NEWBIE] need help optimizing this query |