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
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? |