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. Ev
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.
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
mi
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?
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,
>
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
