Re: fun fact about temp tables

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Grigory Smolkin <g(dot)smolkin(at)postgrespro(dot)ru>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: fun fact about temp tables
Date: 2016-08-05 14:51:44
Message-ID: 5191.1470408704@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Grigory Smolkin <g(dot)smolkin(at)postgrespro(dot)ru> writes:
> I`ve noticed interesting aspect in temp tables working. It appears
> postgres is trying to reserve space on disk for temp tables even before
> temp_buffers overflow.

Sure. Just like it reserves space for ordinary tables right away,
long before there's any need to push the data out of shared_buffers.
Otherwise, you might find yourself having to throw an "out of disk
space" error after having already committed the relevant INSERTs.

regards, tom lane

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Grigory Smolkin 2016-08-05 15:02:08 Re: fun fact about temp tables
Previous Message Grigory Smolkin 2016-08-05 14:37:37 fun fact about temp tables