Re: [GENERAL] Where does vacuum FULL write temp-files?

2015-04-16 Thread Andreas Joseph Krogh
På fredag 17. april 2015 kl. 00:05:47, skrev Guillaume Lelarge guilla...@lelarge.info mailto:guilla...@lelarge.info: 2015-04-15 10:46 GMT+02:00 Andreas Joseph Kroghandr...@visena.com mailto:andr...@visena.com: På onsdag 15. april 2015 kl. 04:34:31, skrev Venkata Balaji N nag1...@gmail.com

Re: [GENERAL] Where does vacuum FULL write temp-files?

2015-04-16 Thread Guillaume Lelarge
2015-04-15 10:46 GMT+02:00 Andreas Joseph Krogh andr...@visena.com: På onsdag 15. april 2015 kl. 04:34:31, skrev Venkata Balaji N nag1...@gmail.com: 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

Re: [GENERAL] Where does vacuum FULL write temp-files?

2015-04-15 Thread Andreas Joseph Krogh
På onsdag 15. april 2015 kl. 04:34:31, skrev Venkata Balaji N nag1...@gmail.com mailto:nag1...@gmail.com:   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

[GENERAL] Where does vacuum FULL write temp-files?

2015-04-14 Thread Andreas Joseph Krogh
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

Re: [GENERAL] Where does vacuum FULL write temp-files?

2015-04-14 Thread Venkata Balaji N
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?