Re: Vacuum performance question

From: Rod Taylor <rbt(at)rbt(dot)ca>
To: jeremy(dot)guthrie(at)berbee(dot)com
Cc: Postgresql Performance <pgsql-performance(at)postgresql(dot)org>
Subject: Re: Vacuum performance question
Date: 2003-08-14 18:04:58
Message-ID: 1060884297.14006.27.camel@jester
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-performance

> I've allocated 196MB of RAM to vacuums.

I would be willing to bet that you have kicked the system into swap
because of this. Hence the large decrease in speed.

Try sliding back to 32MB for vacuum. A ton more ram doesn't really help
it all that much.

In response to

Browse pgsql-performance by date

  From Date Subject
Next Message Scott Cain 2003-08-14 18:11:07 Re: [SQL] EXTERNAL storage and substring on long strings
Previous Message Tom Lane 2003-08-14 18:00:21 Re: [SQL] EXTERNAL storage and substring on long strings