Re: Copy data from DB2 (Linux) to PG

2018-11-02 Thread Achilleas Mantzios
On 1/11/18 7:27 μ.μ., Ravi Krishna wrote: I have a project to develop a script/tool to copy data from DB2 to PG. The approach I am thinking is 1. Export data from db2 in a text file, with, say pipe as delimiter. 2. Load the data from the text file to PG using COPY command. In order to make it

Re: rw_redis_fdw: SQL Errors when statement is within a function

2018-11-02 Thread GPT
Good morning, >> 1) You are asking Postgres to do what previously you said you did not >> want it to do: >> >> >> https://www.postgresql.org/message-id/CADep2PMJVpVu-ne42yYpqjzGHQ1cunvX92Oo6_hNLfgrj%2BMa_Q%40mail.gmail.com >> >> " You are looking for Postgres to >> > follow its responses all the

Re: Working around, or with, bitmap heap scan?

2018-11-02 Thread Laurenz Albe
James A. Robinson wrote: > I'm newly exposed to a Postgres 9.4 database system, and am > trying to understand how I might optimize a query that is taking > a long time to return. > > What I'm observing is an uncached query that takes much much > longer to complete, sometimes minutes longer, when >

cannot find PGXS file when installing an extension?

2018-11-02 Thread Luca Ferrari
I'm using 11.0 on FreeBSD: testdb=> select version(); version - PostgreSQL 11.0 on x86_64-unknown-freebsd11.1, compiled by gcc (FreeBSD Ports Co

Re: Working around, or with, bitmap heap scan?

2018-11-02 Thread Laurenz Albe
James A. Robinson wrote: > Thank you. Do you need the entire output of 'EXPLAIN (ANALYZE, > BUFFERS) ...', or will just the sub-section, as I emailed for the > plain 'EXPLAIN ...' I initially e-mailed. do? It should be the whole thing. Yours, Laurenz Albe -- Cybertec | https://www.cybertec-post

Re: Working around, or with, bitmap heap scan?

2018-11-02 Thread James A. Robinson
Thank you. Do you need the entire output of 'EXPLAIN (ANALYZE, BUFFERS) ...', or will just the sub-section, as I emailed for the plain 'EXPLAIN ...' I initially e-mailed. do?

Re: cannot find PGXS file when installing an extension?

2018-11-02 Thread Pavel Luzanov
Luca, 'sudo make install' command works in the environment of the superuser and most likely does not see pg_config utility . Specify the location of pg_config explicitly: sudo make install PG_CONFIG=/opt/pg11/bin/pg_config - Pavel Luzanov Postgres Professional: http://www.postgrespro.com

Re: Working around, or with, bitmap heap scan?

2018-11-02 Thread James A. Robinson
Well, so as to not spam the list here's a link to a folder with copies of the output: https://drive.google.com/open?id=1lSlx7UMUMNgRft2B3Rq2zc4WIRJLLOqU On Fri, Nov 2, 2018 at 4:12 AM James A. Robinson wrote: > > Thank you. Do you need the entire output of 'EXPLAIN (ANALYZE, > BUFFERS) ...', or

Re: cannot find PGXS file when installing an extension?

2018-11-02 Thread Luca Ferrari
On Fri, Nov 2, 2018 at 12:46 PM Pavel Luzanov wrote: > > Luca, > > 'sudo make install' command works in the environment of the superuser and > most likely does not see pg_config utility . > > Specify the location of pg_config explicitly: > sudo make install PG_CONFIG=/opt/pg11/bin/pg_config No,

Re: Add columns to table; insert values based on row

2018-11-02 Thread Rich Shepard
On Thu, 1 Nov 2018, Ken Tanzer wrote: I'm not sure what format your text file is in, but you could probably use \copy to bring it into a (temporary) table in Postgres. As long as it had your four new columns and the site_nbr, you could then update from that table in one swoop: Ken, Thank yo

Re: cannot find PGXS file when installing an extension?

2018-11-02 Thread Luca Ferrari
On Fri, Nov 2, 2018 at 1:16 PM Luca Ferrari wrote: > > On Fri, Nov 2, 2018 at 12:46 PM Pavel Luzanov > wrote: > > > > Luca, > > > > 'sudo make install' command works in the environment of the superuser and > > most likely does not see pg_config utility . > > > > Specify the location of pg_confi

Re: Working around, or with, bitmap heap scan?

2018-11-02 Thread Laurenz Albe
On Fri, 2018-11-02 at 04:55 -0700, James A. Robinson wrote: > Well, so as to not spam the list here's a link to a folder with copies > of the output: I have no idea how to improve that, sorry. Yours, Laurenz Albe -- Cybertec | https://www.cybertec-postgresql.com

Re: Working around, or with, bitmap heap scan?

2018-11-02 Thread James A. Robinson
On Fri, Nov 2, 2018 at 6:21 AM Laurenz Albe wrote: > I have no idea how to improve that, sorry. Heh, thank you for looking. From your response I've got a vision of a medical drama where the doctor looks over some test results and sadly informs the patient "I'm sorry, there's nothing more we can

Logical replication hangs up.

2018-11-02 Thread Aleš Zelený
Hello, we are suing logical replication on 10.4 and it now hangs. After some timeout it is retarted again, replaying 18GB of data and then hangs (while 7GB of wals remains to be proceeded). The backlog of 18GB comes from a failed migration adding new table to replication while replication user w

Re: backend crash on DELETE, reproducible locally

2018-11-02 Thread Tom Lane
Karsten Hilbert writes: > On Thu, Nov 01, 2018 at 11:43:56AM -0400, Tom Lane wrote: >> Yeah, apparently we've passed a null OLD tuple to an RI_FKey_cascade_del >> trigger, which surely shouldn't happen. It'd be interesting to look at >> the set of triggers on this table. I don't entirely trust p