Re: [GENERAL] PostgreSQL not reusing free space in table ?

2017-01-06 Thread Pierre Ducroquet
On Friday, January 6, 2017 9:00:06 AM CET Merlin Moncure wrote: > On Fri, Jan 6, 2017 at 4:09 AM, Pierre Ducroquet > > wrote: > > Hi > > > > Running PostgreSQL 9.4, I am running in the following issue. > > On a huge table, I have to remove the content (set to

Re: [GENERAL] PostgreSQL not reusing free space in table ?

2017-01-06 Thread Merlin Moncure
On Fri, Jan 6, 2017 at 4:09 AM, Pierre Ducroquet wrote: > Hi > > Running PostgreSQL 9.4, I am running in the following issue. > On a huge table, I have to remove the content (set to '') of a column that > makes for 99% of the weight of the table. Since the

[GENERAL] PostgreSQL not reusing free space in table ?

2017-01-06 Thread Pierre Ducroquet
Hi Running PostgreSQL 9.4, I am running in the following issue. On a huge table, I have to remove the content (set to '') of a column that makes for 99% of the weight of the table. Since the production can not be stopped, I will not be able to do a VACUUM FULL nor any direct rewrite of the