Re: Why is restored database faster?

From: Shridhar Daithankar <shridhar_daithankar(at)persistent(dot)co(dot)in>
To: Neil Conway <neilc(at)samurai(dot)com>
Cc: "david(at)shadovitz(dot)com" <david(at)shadovitz(dot)com>, "pgsql-performance(at)postgresql(dot)org" <pgsql-performance(at)postgresql(dot)org>
Subject: Re: Why is restored database faster?
Date: 2003-12-17 06:31:06
Message-ID: 3FDFF82A.2070201@persistent.co.in
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-performance

Neil Conway wrote:

>>How can I get the original server to perform as well as the new one?

Well, you have the answer. Dump the database, stop postmaster and restore it.
That should be faster than original one.

>
> (BTW, "SELECT count(*) FROM table" isn't a particularly good DBMS
> performance indication...)

Particularly in case of postgresql..:-)

Shridhar

In response to

Browse pgsql-performance by date

  From Date Subject
Next Message Dennis Bjorklund 2003-12-17 06:42:46 Re: Why is restored database faster?
Previous Message Neil Conway 2003-12-17 06:00:13 Re: Why is restored database faster?