Re: Quere keep using temporary files

From: Luca Ferrari <fluca1978(at)gmail(dot)com>
To: rihad <rihad(at)mail(dot)ru>
Cc: pgsql-general General <pgsql-general(at)postgresql(dot)org>
Subject: Re: Quere keep using temporary files
Date: 2019-10-25 11:03:57
Message-ID: CAKoxK+5Rw4g4MH7ze1pv_btN8B13wpyqw0UCmnyGwpok2ZTC9A@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

On Fri, Oct 25, 2019 at 10:23 AM rihad <rihad(at)mail(dot)ru> wrote:
> LOG: temporary file: path "base/pgsql_tmp/pgsql_tmp92452.1079", size 166518
> STATEMENT: DELETE FROM "foo" WHERE ((col1, col2, col3) in (select col1,
> col2, col3 from foo_xml_v2('<here goes xml-formatted blob>'))) AND
> "foo"."col_id" IN ($1, $2, $3, $4, $5, $6, $7, $8, $9)

Isn't work_mem used for hashing and sorting, gin and stuff like that?

Luca

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Luca Ferrari 2019-10-25 11:13:00 Re: Index
Previous Message Stephan Sandow 2019-10-25 10:45:40 Error building Postgres for Windows