Date: Wed, 2 Oct 2019 18:37:11 -0500
From: Justin Pryzby <pryzby@telsasoft.com>
To: Devrim =?iso-8859-1?B?R/xuZPx6?= <devrim@gunduz.org>
Cc: pgsql-pkg-yum@postgresql.org
Subject: Re: pgfincore (Re: cannot install postgis30 / rhel7)
Message-ID: <20191002233711.GH9680@telsasoft.com>
References: <20190913213909.GA22849@telsasoft.com>
 <3ac9fab65998527517ec0b604e2b1ea5b2526ee3.camel@gunduz.org>
 <20190926221244.GA22423@telsasoft.com>
 <da1d85082cec7b693df5feb9753212515d999ebd.camel@gunduz.org>
MIME-Version: 1.0
Content-Type: text/plain; charset=iso-8859-1
Content-Disposition: inline
Content-Transfer-Encoding: 8bit
In-Reply-To: <da1d85082cec7b693df5feb9753212515d999ebd.camel@gunduz.org>
User-Agent: Mutt/1.5.24 (2015-08-30)
Precedence: bulk

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