Forced external sort?

From: rolf(at)winmutt(dot)com
To: pgsql-general(at)postgresql(dot)org
Subject: Forced external sort?
Date: 2015-09-11 18:45:12
Message-ID: 2e9dbd62089a6dd4363575e1d0eab3bf@winmutt.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

I've got a poorly indexed query and was attempting a quick work around
in production by increasing work_mem when it was called. EXPLAIN ANALYZE
is telling me this:

Sort Method: external sort Disk: 1253824kB

So I set the work_mem to 2gb, still going to disk. I read Tom's
suggestion here
(http://www.postgresql.org/message-id/1936.1298394374@sss.pgh.pa.us) and
went all the way up to 92G or work_mem.

Did more googling and found this reference
(http://www.postgresql.org/message-id/CAMkU=1w2y87NJueqwN8-HK2KDb4UOihFAJXpO1NZ3EkHZvBmmQ@mail.gmail.com)
to a 1G sort limit that is going to be removed in 9.3.

Am I possibly experiencing the same issue even though I am on 9.3.1? Was
it really not fixed until 9.4?
(http://www.postgresql.org/message-id/557C7213.8000704@joeconway.com)

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Alvaro Herrera 2015-09-11 19:11:16 Re: clone_schema function
Previous Message Melvin Davidson 2015-09-11 18:35:01 Re: clone_schema function