Re: Adding more space, and a vacuum question.

From: Herouth Maoz <herouth(at)unicell(dot)co(dot)il>
To: Craig Ringer <craig(at)postnewspapers(dot)com(dot)au>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: Adding more space, and a vacuum question.
Date: 2011-01-31 17:06:12
Message-ID: 750431E5-B208-409F-9B4A-72E684D42215@unicell.co.il
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general


On 31/01/2011, at 03:49, Craig Ringer wrote:

> For approaches to possibly fixing your problem, see:
>
> http://www.depesz.com/index.php/2010/10/17/reduce-bloat-of-table-without-longexclusive-locks/
>
> http://blog.endpoint.com/2010/09/reducing-bloat-without-locking.html

I'm not quite sure what this will do for me. How will Postgresql know that there is free space in low-numbered pages, if the bloat has not been vacuumed off and is not in the fsm?
--
חרות מעוז
יוניסל פתרונות סלולריים מתקדמים
☎ 03-5181717 שלוחה 742

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Tom Lane 2011-01-31 18:07:56 Re: Autovacuum Issues?
Previous Message Tom Lane 2011-01-31 16:55:39 Re: Create Table Question...