From: David Shadovitz <david@shadovitz.com>
To: Dennis Bjorklund <db@zigo.dhs.org>
To: 'shridhar_daithankar@persistent.co.in' <shridhar_daithankar@persistent.co.in>
To: 'neilc@samurai.com' <neilc@samurai.com>
Cc: pgsql-performance@postgresql.org <pgsql-performance@postgresql.org>
Subject: Re: Why is restored database faster?
Date: Wed, 17 Dec 2003 19:54:45 -0800
Message-ID: <01C3C4D7.A7F88280.david@shadovitz.com> (raw)
Dennis, Shridhar, and Neil,
Thanks for your input. Here are my responses:
I ran VACUUM FULL on the table in question. Although that did reduce "Pages"
and "UnUsed", the "SELECT *" query is still much slower on this installation
than in the new, restored one.
Old server:
# VACUUM FULL abc;
VACUUM
# VACUUM VERBOSE abc;
NOTICE: --Relation abc--
NOTICE: Pages 1526: Changed 0, Empty 0; Tup 91528; Vac 0, Keep 0, UnUsed 32.
Total CPU 0.07s/0.52u sec elapsed 0.60 sec.
VACUUM
New server:
# VACUUM VERBOSE abc;
NOTICE: --Relation abc--
NOTICE: Pages 1526: Changed 0, Empty 0; Tup 91528; Vac 0, Keep 0, UnUsed 0.
Total CPU 0.02s/0.00u sec elapsed 0.02 sec.
VACUUM
max_fsm_pages is at its default value, 10000.
People don't have the practice of dumping and restoring just for the purpose of
improving performance, do they?
Neil asked how much disk space the database directory takes on each machine.
What directory is of interest? The whole thing takes up about 875 MB on each
machine.
-David
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-performance@postgresql.org
Cc: david@shadovitz.com, db@zigo.dhs.org, shridhar_daithankar@persistent.co.in, neilc@samurai.com
Subject: Re: Why is restored database faster?
In-Reply-To: <01C3C4D7.A7F88280.david@shadovitz.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox