Re: requested shared memory size overflows size_t

От: Jim Montgomery
Тема: Re: requested shared memory size overflows size_t
Дата: ,
Msg-id: SNT123-W49BF46CDDFB62AD8A15444A7C70@phx.gbl
(см: обсуждение, исходный текст)
Ответ на: Re: requested shared memory size overflows size_t  (Robert Haas)
Список: pgsql-performance

Скрыть дерево обсуждения

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

Remove me from your email traffic.
 
> Date: Thu, 24 Jun 2010 23:05:06 -0400
> Subject: Re: [PERFORM] requested shared memory size overflows size_t
> From:
> To:
> CC: ;
>
> On Thu, Jun 24, 2010 at 7: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.
>
> Yeah - also, it would probably be good to call pg_relation_size on
> pg_class.oid rather than pg_class.relname, to avoid any chance of
> confusion over which objects are in which schema.
>
> --
> Robert Haas
> EnterpriseDB: http://www.enterprisedb.com
> The Enterprise Postgres Company
>
> --
> Sent via pgsql-performance mailing list ()
> To make changes to your subscription:
> http://www.postgresql.org/mailpref/pgsql-performance


Get a free e-mail account with Hotmail. Sign-up now.

В списке pgsql-performance по дате сообщения:

От: Yeb Havinga
Дата:
Сообщение: Re: sudden spurt in swap utilization (was:cpu bound postgresql setup.)
От: Craig James
Дата:
Сообщение: Re: Occasional giant spikes in CPU load