Default Performance between 8.0 and 8.1

From: "Ted Jordan" <ted(at)actionstep(dot)com>
To: <pgsql-performance(at)postgresql(dot)org>
Subject: Default Performance between 8.0 and 8.1
Date: 2007-08-04 20:35:59
Message-ID: 20070804203549.A5EA486C6B@mail.phase.net.nz
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-performance

Hi

We currently have some databases running under 8.0 and 8.1. I have noticed
a significant difference in the time taken to restore dumps between the two
versions, with 8.0 being much faster. For example a dump of a few MB will
take just seconds to load under 8.0 but the same dump will take several
minutes to load under 8.1. Currently we're just using the default parameter
settings when installed via apt on Ubuntu Linux.

I would just like to know if this is a well known issue and if there is a
quick fix, or should I be digging deeper and seeing if the default settings
are mismatched to certain linux kernel settings etc.

Any help would be most appreciated.

Thanks,

Ted

Responses

Browse pgsql-performance by date

  From Date Subject
Next Message Adriaan van Os 2007-08-04 21:39:31 Re: TRUNCATE TABLE
Previous Message Sven Clement 2007-08-04 20:03:02 Re: Performance problems with large telemetric datasets on 7.4.2