Message-ID: <4C23E424.8040605@emolecules.com>
Date: Thu, 24 Jun 2010 16:03:00 -0700
From: Craig James <craig_james@emolecules.com>
User-Agent: Mozilla/5.0 (Macintosh; U; Intel Mac OS X 10.6; en-US;
	rv:1.9.1.10) Gecko/20100512 Thunderbird/3.0.5
MIME-Version: 1.0
To: pgsql-performance@postgresql.org
Subject: Re: requested shared memory size overflows size_t
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>
In-Reply-To: <4C1BB6E9.1090105@2ndquadrant.com>
Content-Type: text/plain; charset=ISO-8859-1; format=flowed
Content-Transfer-Encoding: 7bit

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