Re: Query Using Massive Temp Space

From: Laurenz Albe <laurenz(dot)albe(at)cybertec(dot)at>
To: Cory Tucker <cory(dot)tucker(at)gmail(dot)com>, "pgsql-general(at)postgresql(dot)org" <pgsql-general(at)postgresql(dot)org>
Subject: Re: Query Using Massive Temp Space
Date: 2017-11-20 07:08:12
Message-ID: 1511161692.2567.5.camel@cybertec.at
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

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 is going on, EXPLAIN (ANALYZE, BUFFERS) output
would be useful.

Yours,
Laurenz Albe

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Luca Ferrari 2017-11-20 08:05:03 Re: unnest-like pg_stats.most_common_values and pg_stats.most_common_freqs
Previous Message Cory Tucker 2017-11-20 06:16:48 Query Using Massive Temp Space