Re: requested shared memory size overflows size_t

From: Alvaro Herrera
Subject: Re: requested shared memory size overflows size_t
Date: ,
Msg-id: 1277421485-sup-3743@alvh.no-ip.org
(view: Whole thread, Raw)
In response to: Re: requested shared memory size overflows size_t  (Craig James)
Responses: Re: System tables screwed up? (WAS requested shared memory size overflows size_t)  (Craig James)
Re: requested shared memory size overflows size_t  (Robert Haas)
List: pgsql-performance

Tree view

requested shared memory size overflows size_t  ("Uwe Bartels", )
 Re: requested shared memory size overflows size_t  (Tom Lane, )
  Re: requested shared memory size overflows size_t  ("Stephen Conley", )
 Re: requested shared memory size overflows size_t  (Tom Wilcox, )
  Re: requested shared memory size overflows size_t  ("Kevin Grittner", )
   Re: requested shared memory size overflows size_t  (Stephen Frost, )
  Re: requested shared memory size overflows size_t  (Bob Lunney, )
   Re: requested shared memory size overflows size_t  (Robert Haas, )
    Re: requested shared memory size overflows size_t  (Bob Lunney, )
  Re: requested shared memory size overflows size_t  (Joshua Tolley, )
 Re: requested shared memory size overflows size_t  (Bob Lunney, )
  Re: requested shared memory size overflows size_t  (Tom Wilcox, )
   Re: requested shared memory size overflows size_t  (Robert Haas, )
    Re: requested shared memory size overflows size_t  (Tom Wilcox, )
     Re: requested shared memory size overflows size_t  (Greg Smith, )
      Re: requested shared memory size overflows size_t  (Tom Wilcox, )
       Re: requested shared memory size overflows size_t  (Kenneth Marshall, )
        Re: requested shared memory size overflows size_t  (Greg Smith, )
         Re: requested shared memory size overflows size_t  (Craig James, )
          Re: requested shared memory size overflows size_t  (Alvaro Herrera, )
           Re: System tables screwed up? (WAS requested shared memory size overflows size_t)  (Craig James, )
            Re: System tables screwed up? (WAS requested shared memory size overflows size_t)  (Alvaro Herrera, )
           Re: requested shared memory size overflows size_t  (Robert Haas, )
            Re: requested shared memory size overflows size_t  (Jim Montgomery, )
   Re: requested shared memory size overflows size_t  (Dave Crooke, )
    Re: requested shared memory size overflows size_t  (Tom Wilcox, )
     Re: requested shared memory size overflows size_t  (Dave Crooke, )
      Re: requested shared memory size overflows size_t  (Tom Wilcox, )
   Re: requested shared memory size overflows size_t  (Greg Smith, )
    Re: requested shared memory size overflows size_t  (Scott Carey, )
     Re: requested shared memory size overflows size_t  (Tom Lane, )
      Re: requested shared memory size overflows size_t  (Alvaro Herrera, )
       Re: requested shared memory size overflows size_t  (Scott Carey, )
   Re: requested shared memory size overflows size_t  (Scott Carey, )

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 <>
The PostgreSQL Company - Command Prompt, Inc.
PostgreSQL Replication, Consulting, Custom Development, 24x7 support


pgsql-performance by date:

From: Greg Smith
Date:
Subject: Re: Occasional giant spikes in CPU load
From: "Joshua D. Drake"
Date:
Subject: Re: PostgreSQL as a local in-memory cache