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
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,
>
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?
On Thu, Nov 1, 2018 at 10:50 AM Ravi Krishna wrote:
> [...] What I need is a constant refresh.
> We plan to use it daily to replicate data from db2 to pg.
Perhaps you've already considered and discarded the idea, but your use
case made me think back to when I was looking at AWS SCT as a way to
On Thu, Nov 1, 2018 at 10:28 AM 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.
Hello,
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
enable_bitmapscan is true.
