On Thu, Oct 03, 2019 at 12:18:04AM +0100, Devrim Gündüz wrote:
>
> Hi
>
> On Thu, 2019-09-26 at 17:12 -0500, Justin Pryzby wrote:
> > No package pgfincore12 available.
>
> Please use pg_prewarm. pgfincore does not have v12 support (and does not
> compile anywa)
>
> > No package pg_repack12 available.
>
> https://github.com/reorg/pg_repack/pull/207
> https://github.com/reorg/pg_repack/issues/216
Thanks.
For pgfincore, I don't use it to read blocks, but (very infrequently) in a
tuning query to check "if incore"...
I compiled it fine just now for HEAD (under ubuntu).
make PG_CONFIG=/usr/local/pgsql/bin/pg_config install
waiting for server to start....2019-10-02 18:33:44.409 CDT [25266] LOG: starting PostgreSQL 13devel on
x86_64-pc-linux-gnu,compiled by gcc (Ubuntu 4.9.2-10ubuntu13) 4.9.2, 64-bit
2019-10-02 18:33:44.410 CDT [25266] LOG: listening on IPv4 address "127.0.0.1", port 5678
2019-10-02 18:33:44.492 CDT [25266] LOG: listening on Unix socket "/tmp/.s.PGSQL.5678"
2019-10-02 18:33:44.614 CDT [25277] LOG: database system was shut down at 2019-10-02 12:07:06 CDT
2019-10-02 18:33:44.649 CDT [25266] LOG: database system is ready to accept connections
done
server started
postgres=# CREATE EXTENSION pgfincore;
CREATE EXTENSION
postgres=# SELECT * FROM pgfincore('pg_class');
relpath | segment | os_page_size | rel_os_pages | pages_mem | group_mem | os_pages_free | databit |
pages_dirty| group_dirty
-----------------+---------+--------------+--------------+-----------+-----------+---------------+---------+-------------+-------------
base/12708/1259 | 0 | 4096 | 26 | 26 | 1 | 196465 | |
0| 0
(1 row)
postgres=# SELECT version();
version | PostgreSQL 13devel on x86_64-pc-linux-gnu, compiled by gcc (Ubuntu 4.9.2-10ubuntu13) 4.9.2, 64-bit
Justin