Re: [GENERAL] vacuuming - doubt

2013-12-11 Thread Jayadevan
Scott Marlowe-2 wrote > 30 second vacuum lesson: Thank you. -- View this message in context: http://postgresql.1045698.n5.nabble.com/vacuuming-doubt-tp5782828p5783057.html Sent from the PostgreSQL - general mailing list archive at Nabble.com. -- Sent via pgsql-general mailing list (pgsql-g

Re: [GENERAL] vacuuming - doubt

2013-12-11 Thread Scott Marlowe
On Wed, Dec 11, 2013 at 1:08 AM, Jayadevan M wrote: > Hi, > Another theory question - > PostgreSQL documentation says that - > "There are two variants of VACUUM: standard VACUUM and VACUUM FULL. VACUUM > FULL can reclaim more disk space " > I created a table, inserted 1000 records and deleted them

[GENERAL] vacuuming - doubt

2013-12-11 Thread Jayadevan M
Hi, Another theory question - PostgreSQL documentation says that - "There are two variants of VACUUM: standard VACUUM and VACUUM FULL. VACUUM FULL can reclaim more disk space " I created a table, inserted 1000 records and deleted them. The size after a vacuum and a vacuum full are given - select pg