Postgres Pro
Downloads
Home   >   mailing lists

Why postgresql 8.3.5 created temporary files of size less then work_mem on disk ? - Mailing list pgsql-admin

From Yves D'Astous
Subject Why postgresql 8.3.5 created temporary files of size less then work_mem on disk ?
Date
Msg-id 6807f2cf0905061156o79351fa7pfacf3357cbd72e5a@mail.gmail.com
Whole thread Raw
Responses Re: Why postgresql 8.3.5 created temporary files of size less then work_mem on disk ?  (Michael Monnerie <michael.monnerie@is.it-management.at>)
List pgsql-admin
Tree view
Hello,

On a test postgresql server I have set work_mem to 200MB, and I have
stop/start postgressql.
I have also enable the  "log_temp_files = 0"

After restarting my server and executing some sql statements I see in
the postgres log:

LOG:  temporary file: path "base/pgsql_tmp/pgsql_tmp6655.10", size 122869324

So in what case temporary file of size less then work_mem are created on
disk ?


Yves D'Astous

pgsql-admin by date:

Previous
From: Michael Monnerie
Date:
Subject: Re: Can't drop constraint?
Next
From: Scott Marlowe
Date:
Subject: Re: Creating functions