Hi,
there are many Hash and Merge joins that may generate a lot of temp space,
it could also be a problem of forgotten column in the join.
Could you also provide indexes definitions (pk, uk and others)
with the EXPLAIN (ANALYZE BUFFERS)
(you can limit the scope of the query to help it to finish
, November 20, 2017 7:17 AM
To: pgsql-general@postgresql.org
Subject: [GENERAL] Query Using Massive Temp Space
Hello,
I have a query that is using a tremendous amount of temp disk space given the
overall size of the dataset. I'd love for someone to try to explain what PG is
doing and wh
Cory Tucker wrote:
> I have a query that is using a tremendous amount of temp disk space given the
> overall size of the dataset.
> I'd love for someone to try to explain what PG is doing and why its using so
> much space for the query.
It could be a sort or a hash operation.
Do determine what
Hello,
I have a query that is using a tremendous amount of temp disk space given
the overall size of the dataset. I'd love for someone to try to explain
what PG is doing and why its using so much space for the query.
First off, the system is PG 9.6 on Ubuntu with 4 cores and 28 GB of RAM.
The qu
