Re: pgfincore (Re: cannot install postgis30 / rhel7)

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