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
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
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
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
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
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
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,
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
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
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?
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 |
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
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
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
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
15 matches
Mail list logo
