Re: Query with large in clauses uses a lot of memory

From: greigwise <greigwise(at)comcast(dot)net>
To: pgsql-general(at)postgresql(dot)org
Subject: Re: Query with large in clauses uses a lot of memory
Date: 2016-11-28 20:45:31
Message-ID: 1480365931720-5932279.post@n3.nabble.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Wow. Thanks for the prompt answer.

As a follow-up I was wondering if maybe there would be a way to tell it to
NOT try to plan/execute the query (and instead throw an error) if the memory
usage exceeded X.

Thanks again.

Greig

--
View this message in context: http://postgresql.nabble.com/Query-with-large-in-clauses-uses-a-lot-of-memory-tp5931716p5932279.html
Sent from the PostgreSQL - general mailing list archive at Nabble.com.

In response to

Browse pgsql-general by date

  From Date Subject
Next Message kbrannen 2016-11-28 20:47:00 Re: Storing files: 2.3TBytes, 17M file count
Previous Message Eduardo Morras 2016-11-28 19:37:49 Re: Storing files: 2.3TBytes, 17M file count