| From: | Craig James <craig_james(at)emolecules(dot)com> | 
|---|---|
| To: | pgsql-performance(at)postgresql(dot)org | 
| Subject: | Re: requested shared memory size overflows size_t | 
| Date: | 2010-06-24 23:03:00 | 
| Message-ID: | 4C23E424.8040605@emolecules.com | 
| Views: | Whole Thread | Raw Message | Download mbox | Resend email | 
| Thread: | |
| Lists: | pgsql-performance | 
Can anyone tell me what's going on here? I hope this doesn't mean my system tables are corrupt...
Thanks,
Craig
select relname, pg_relation_size(relname) from pg_class
         where pg_get_userbyid(relowner) = 'emol_warehouse_1'
         and relname not like 'pg_%'
         order by pg_relation_size(relname) desc;
ERROR:  relation "rownum_temp" does not exist
emol_warehouse_1=> select relname from pg_class where relname = 'rownum_temp';
        relname
----------------------
  rownum_temp
(1 row)
emol_warehouse_1=> \d rownum_temp
Did not find any relation named "rownum_temp".
emol_warehouse_1=> create table rownum_temp(i int);
CREATE TABLE
emol_warehouse_1=> drop table rownum_temp;
DROP TABLE
emol_warehouse_1=> select relname, pg_relation_size(relname) from pg_class
         where pg_get_userbyid(relowner) = 'emol_warehouse_1'
         and relname not like 'pg_%'
         order by pg_relation_size(relname) desc;
ERROR:  relation "rownum_temp" does not exist
emol_warehouse_1=> select relname, pg_relation_size(relname) from pg_class;
ERROR:  relation "tables" does not exist
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Alvaro Herrera | 2010-06-24 23:19:25 | Re: requested shared memory size overflows size_t | 
| Previous Message | Pavel Stehule | 2010-06-24 21:55:48 | Re: PostgreSQL as a local in-memory cache |