Re: Slow Vacuum was: vacuum output question

From: "Dan Armbrust" <daniel(dot)armbrust(dot)list(at)gmail(dot)com>
To: "Alan Hodgson" <ahodgson(at)simkin(dot)ca>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: Slow Vacuum was: vacuum output question
Date: 2009-01-06 21:25:29
Message-ID: 82f04dc40901061325q5a967c51g66e994165100021@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

>
> Obviously the choice of operating system has no impact on the contents of
> your index.
>
> A better question might be, what did your application or maintenance
> procedures do different in the different tests?
>
>
> --
> Alan

Our problem for a long time has been assuming the "obvious". But we
now have tests that show otherwise.

I'm now thinking something along the lines of an obscure file system
or kernel interaction bug now - that was perhaps corrected in newer
releases of the OS.

Now that we can finally reproduce the problem in house, we are still
doing more tests to figure out specifics - does the problem go away
with Postgres 8.3, ext2/ext3/reiserFS, etc.

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Francisco Figueiredo Jr. 2009-01-06 21:31:37 Re: Generic provider for .Net
Previous Message Alan Hodgson 2009-01-06 21:15:06 Re: Slow Vacuum was: vacuum output question