pg.ddx.io  pgsql-performance@postgresql.org mailing list archive  
help / color / mirror / Atom feed
From: Ted Jordan <ted@actionstep.com>
To: pgsql-performance@postgresql.org
Subject: Default Performance between 8.0 and 8.1
Date: Sun, 5 Aug 2007 08:35:59 +1200
Message-ID: <20070804203549.A5EA486C6B@mail.phase.net.nz> (raw)

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

view thread (3+ messages)  latest in thread

Message-ID: <20070804203549.A5EA486C6B@mail.phase.net.nz>
Permalink:  ../20070804203549.A5EA486C6B@mail.phase.net.nz/
Also on:    postgresql.org/message-id/20070804203549.A5EA486C6B@mail.phase.net.nz

 · 

reply

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: ted@actionstep.com
  Subject: Re: Default Performance between 8.0 and 8.1
  In-Reply-To: <20070804203549.A5EA486C6B@mail.phase.net.nz>

* 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