pg.ddx.io  pgsql-performance@postgresql.org mailing list archive  

help / color / mirror / Atom feed

From: Alvaro Herrera <alvherre@commandprompt.com>
To: Craig James <craig_james@emolecules.com>
Cc: pgsql-performance <pgsql-performance@postgresql.org>
Subject: Re: requested shared memory size overflows size_t
Date: Thu, 24 Jun 2010 19:19:25 -0400
Message-ID: <1277421485-sup-3743@alvh.no-ip.org> (raw)
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>

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

view thread (32+ messages)  latest in thread

Message-ID: <1277421485-sup-3743@alvh.no-ip.org>
Permalink:  ../1277421485-sup-3743@alvh.no-ip.org/
Also on:    postgresql.org/message-id/1277421485-sup-3743@alvh.no-ip.org

copy link · copy postgr.es

reply

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: alvherre@commandprompt.com, craig_james@emolecules.com
  Subject: Re: requested shared memory size overflows size_t
  In-Reply-To: <1277421485-sup-3743@alvh.no-ip.org>

* 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