Postgres 9.5 pg_prewarm

From: Thomas SIMON <tsimon(at)neteven(dot)com>
To: "pgsql-admin(at)postgresql(dot)org" <pgsql-admin(at)postgresql(dot)org>
Subject: Postgres 9.5 pg_prewarm
Date: 2016-02-04 13:59:16
Message-ID: 56B35934.7060209@neteven.com
Views: Whole Thread | Raw Message | Download mbox | Resend email
Thread:
Lists: 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

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message Gilberto Castillo 2016-02-04 14:09:58 Re: [MASSMAIL]Postgres 9.5 pg_prewarm
Previous Message Guillaume Lelarge 2016-02-03 17:47:21 Re: Re: Postgres 9.4 unlogged table. Under any circumstance after server crash would data persist?