[HACKERS] Re: [GENERAL] Odd VACUUM behavior when it is expected to truncate last empty pages

2011-08-04 Thread Sergey Konoplev
Thank you very much, your explanation helped a lot. This is the tool I needed the solution for http://code.google.com/p/pc-tools/ if you are interested. On 4 August 2011 01:10, Pavan Deolasee wrote: > On Wed, Aug 3, 2011 at 12:33 PM, Pavan Deolasee > wrote: >> >> >> The only problem, other than

[HACKERS] Re: [GENERAL] Odd VACUUM behavior when it is expected to truncate last empty pages

2011-08-03 Thread Pavan Deolasee
On Wed, Aug 3, 2011 at 12:33 PM, Pavan Deolasee wrote: > > > The only problem, other than a surprising behavior that you noted, > that I see with this approach is that we might repeatedly try to > truncate a relation which in fact does not have anything to truncate. > The worst  thing is we might

[HACKERS] Re: [GENERAL] Odd VACUUM behavior when it is expected to truncate last empty pages

2011-08-03 Thread Pavan Deolasee
(moving this to hackers since I suspect we got an issue to fix here) On Wed, Aug 3, 2011 at 6:35 AM, Sergey Konoplev wrote: > Hi all, > > I have PostgreSQL 9.0.3 installed on my Gentoo Linux box. The > configuration is default. There is no any activity in the database but > the described below. >