From: Craig James <craig_james@emolecules.com>
To: Alvaro Herrera <alvherre@commandprompt.com>
To: pgsql-performance <pgsql-performance@postgresql.org>
Subject: Re: System tables screwed up? (WAS requested shared memory size overflows size_t)
Date: Thu, 24 Jun 2010 16:24:44 -0700
Message-ID: <4C23E93C.7010504@emolecules.com> (raw)
In-Reply-To: <1277421485-sup-3743@alvh.no-ip.org>
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>
<1277421485-sup-3743@alvh.no-ip.org>
On 6/24/10 4:19 PM, Alvaro Herrera wrote:
> 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.
Thanks, in fact that works. But my concern is that these are system tables and system functions and yet they seem to be confused. I've used this query dozens of times and never seen this behavior before. It makes me really nervous...
Craig
P.S. Sorry I got the Subject wrong the first time by hitting the REPLY key mindlessly, I've changed it now.
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, alvherre@commandprompt.com
Subject: Re: System tables screwed up? (WAS requested shared memory size overflows size_t)
In-Reply-To: <4C23E93C.7010504@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