Re: Autovacuum / full vacuum - Mailing list pgsql-performance

From Tom Lane
Subject Re: Autovacuum / full vacuum
Date
Msg-id 28618.1137512171@sss.pgh.pa.us
Whole thread Raw
In response to Re: Autovacuum / full vacuum  (Michael Riess <mlriess@gmx.de>)
List pgsql-performance
Michael Riess <mlriess@gmx.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

pgsql-performance by date:

Previous
From: Andrew Sullivan
Date:
Subject: Re: Autovacuum / full vacuum
Next
From: Scott Marlowe
Date:
Subject: Re: Autovacuum / full vacuum