Where does vacuum FULL write temp-files?

From: Andreas Joseph Krogh <andreas(at)visena(dot)com>
To: "pgsql-general(at)postgresql(dot)org" <pgsql-general(at)postgresql(dot)org>
Subject: Where does vacuum FULL write temp-files?
Date: 2015-04-15 01:09:31
Message-ID: VisenaEmail.3.e1c0e0695d3309d6.14cba9a3f95@tc7-visena
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Hi all.   I'm planning to vacuum FULL a pg_largeobject relation (after
vacuumlo'ing it). The relation is 300GB large so I'm concerned the operation
will write full my pg_xlog directory which is on a 200GB (net) RAID1 SSD.  
Where does vacuum FULL rewrite to, does it use pg_xlog or some other directory?
  Thanks.   -- Andreas Joseph Krogh CTO / Partner - Visena AS Mobile: +47 909
56 963 andreas(at)visena(dot)com <mailto:andreas(at)visena(dot)com> www.visena.com
<https://www.visena.com> <https://www.visena.com>

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Andreas Joseph Krogh 2015-04-15 02:03:38 How to keep pg_largeobject from growing endlessly
Previous Message Pawel Veselov 2015-04-15 00:01:18 Re: Help with slow table update