From: Craig James <craig_james@emolecules.com>
To: pgsql-performance@postgresql.org
Subject: Re: requested shared memory size overflows size_t
Date: Thu, 24 Jun 2010 16:03:00 -0700
Message-ID: <4C23E424.8040605@emolecules.com> (raw)
In-Reply-To: <4C1BB6E9.1090105@2ndquadrant.com>
References: <584872.74177.qm@web39702.mail.mud.yahoo.com>
<4C167A8D.1060002@gmail.com>
<AANLkTinl1XU1IYUv2lmBXeKPKk37TKutBSNbcGvPmjJI@mail.gmail.com>
<4C16B97F.4080201@gmail.com>
<4C1A96A2.2050607@2ndquadrant.com>
<4C1AB3C3.9090606@gmail.com>
<20100618124826.GW23529@aart.is.rice.edu>
<4C1BB6E9.1090105@2ndquadrant.com>
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
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-performance@postgresql.org
Cc: craig_james@emolecules.com
Subject: Re: requested shared memory size overflows size_t
In-Reply-To: <4C23E424.8040605@emolecules.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox