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
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
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 |
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
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.