Skip site navigation (1) Skip section navigation (2)

Why postgresql 8.3.5 created temporary files of size less then work_mem on disk ?

From: "Yves D'Astous" <yves(dot)dastous(at)intertrade(dot)com>
To: pgsql-admin(at)postgresql(dot)org
Subject: Why postgresql 8.3.5 created temporary files of size less then work_mem on disk ?
Date: 2009-05-06 18:56:49
Message-ID: 6807f2cf0905061156o79351fa7pfacf3357cbd72e5a@mail.gmail.com (view raw or flat)
Thread:
Lists: pgsql-admin
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

Responses

pgsql-admin by date

Next:From: Scott MarloweDate: 2009-05-06 19:17:41
Subject: Re: Creating functions
Previous:From: Michael MonnerieDate: 2009-05-06 18:54:20
Subject: Re: Can't drop constraint?

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group