Re: Autovacuum / full vacuum

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Michael Riess <mlriess(at)gmx(dot)de>
Cc: pgsql-performance(at)postgresql(dot)org
Subject: Re: Autovacuum / full vacuum
Date: 2006-01-17 15:36:11
Message-ID: 28618.1137512171@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-performance

Michael Riess <mlriess(at)gmx(dot)de> writes:
> But actually I never understood why the database system slows down at
> all when there is much unused space in the files.

Perhaps some of your common queries are doing sequential scans? Those
would visit the empty pages as well as the full ones.

regards, tom lane

In response to

Browse pgsql-performance by date

  From Date Subject
Next Message Scott Marlowe 2006-01-17 15:59:25 Re: Autovacuum / full vacuum
Previous Message Andrew Sullivan 2006-01-17 15:19:44 Re: Autovacuum / full vacuum