Postgres 9.5 pg_prewarm

Поиск
Список
Период
Сортировка
От Thomas SIMON
Тема Postgres 9.5 pg_prewarm
Дата
Msg-id 56B35934.7060209@neteven.com
обсуждение исходный текст
Ответы Re: [MASSMAIL]Postgres 9.5 pg_prewarm  ("Gilberto Castillo" <gilberto.castillo@etecsa.cu>)
Re: Postgres 9.5 pg_prewarm  ("Simpson, John (IMS)" <SimpsonJ@imsweb.com>)
Список pgsql-admin
Hi all,

I have just migrated my db to PG 9.5, an I would like to use pg_prewarm contrib function, but when I want to use it, I have an error message I don't understand :


It should do this :

  1. postgres=# select pg_prewarm('foo');  
  2.  pg_prewarm  
  3. ------------  
  4.      113278  
  5. (1 row) 


but it do that :

psql (9.5.0)
postgres=# create extension pg_prewarm;
CREATE EXTENSION

db=# select pg_prewarm('accounts');
ERROR:  function pg_prewarm(unknown) does not exist
LINE 1: select pg_prewarm('accounts');
               ^
HINT:  No function matches the given name and argument types. You might need to add explicit type casts.

(table accounts exists)


Does anyone have an idea ?

Thanks,
thomas

-- 

Thomas

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

Предыдущее
От: Guillaume Lelarge
Дата:
Сообщение: Re: Re: Postgres 9.4 unlogged table. Under any circumstance after server crash would data persist?
Следующее
От: "Gilberto Castillo"
Дата:
Сообщение: Re: [MASSMAIL]Postgres 9.5 pg_prewarm