Content-Type: text/plain; charset=UTF-8
Cc: pgsql-performance <pgsql-performance@postgresql.org>
Subject: Re: requested shared memory size overflows size_t
From: Alvaro Herrera <alvherre@commandprompt.com>
To: Craig James <craig_james@emolecules.com>
In-reply-to: <4C23E424.8040605@emolecules.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>
	<4C23E424.8040605@emolecules.com>
Date: Thu, 24 Jun 2010 19:19:25 -0400
Message-Id: <1277421485-sup-3743@alvh.no-ip.org>
User-Agent: Sup/0.11
Content-Transfer-Encoding: 8bit

Excerpts from Craig James's message of jue jun 24 19:03:00 -0400 2010:

> 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)

What's the full row?  I'd just add a "WHERE relkind = 'r'" to the above
query anyway.

-- 
Álvaro Herrera <alvherre@commandprompt.com>
The PostgreSQL Company - Command Prompt, Inc.
PostgreSQL Replication, Consulting, Custom Development, 24x7 support