Re: requested shared memory size overflows size_t

Поиск
Список
Период
Сортировка
От Craig James
Тема Re: requested shared memory size overflows size_t
Дата
Msg-id 4C23E424.8040605@emolecules.com
обсуждение исходный текст
Ответ на Re: requested shared memory size overflows size_t  (Greg Smith <greg@2ndquadrant.com>)
Ответы Re: requested shared memory size overflows size_t  (Alvaro Herrera <alvherre@commandprompt.com>)
Список pgsql-performance
Can anyone tell me what's going on here?  I hope this doesn't mean my system tables are corrupt...

Thanks,
Craig


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)

emol_warehouse_1=> \d rownum_temp
Did not find any relation named "rownum_temp".
emol_warehouse_1=> create table rownum_temp(i int);
CREATE TABLE
emol_warehouse_1=> drop table rownum_temp;
DROP TABLE
emol_warehouse_1=> 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, pg_relation_size(relname) from pg_class;
ERROR:  relation "tables" does not exist





В списке pgsql-performance по дате отправления:

Предыдущее
От: Pavel Stehule
Дата:
Сообщение: Re: PostgreSQL as a local in-memory cache
Следующее
От: Alvaro Herrera
Дата:
Сообщение: Re: requested shared memory size overflows size_t