pg.ddx.io  pgsql-performance@postgresql.org mailing list archive  
help / color / mirror / Atom feed
Default Performance between 8.0 and 8.1
3+ messages / 2 participants
[nested] [flat]

* Default Performance between 8.0 and 8.1
@ 2007-08-04 20:35 Ted Jordan <ted@actionstep.com>
  2007-08-06 01:56 ` Re: Default Performance between 8.0 and 8.1 Merlin Moncure <mmoncure@gmail.com>
  0 siblings, 1 reply; 3+ messages in thread

From: Ted Jordan @ 2007-08-04 20:35 UTC (permalink / raw)
  To: 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

^ permalink  raw  reply  [nested|flat] 3+ messages in thread

* Re: Default Performance between 8.0 and 8.1
  2007-08-04 20:35 Default Performance between 8.0 and 8.1 Ted Jordan <ted@actionstep.com>
@ 2007-08-06 01:56 ` Merlin Moncure <mmoncure@gmail.com>
  2007-08-06 17:58   ` Re: Default Performance between 8.0 and 8.1 Ted Jordan <ted@actionstep.com>
  0 siblings, 1 reply; 3+ messages in thread

From: Merlin Moncure @ 2007-08-06 01:56 UTC (permalink / raw)
  To: Ted Jordan <ted@actionstep.com>; +Cc: pgsql-performance

On 8/5/07, Ted Jordan <ted@actionstep.com> wrote:
> 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.

a few seconds to several minutes is not the kind of variance that is
explainable by architecture changes between the versions.  something
is amiss.  'maintenance_work_mem' can make a big difference with data
loads due to faster index builds but even that would not account for
the difference.

are you running locally or remotely?  if running remotely, you might
be seeing some networking/tcp problems.

can you reduce your problem down to a single copy statement for analysis?

merlin



^ permalink  raw  reply  [nested|flat] 3+ messages in thread

* Re: Default Performance between 8.0 and 8.1
  2007-08-04 20:35 Default Performance between 8.0 and 8.1 Ted Jordan <ted@actionstep.com>
  2007-08-06 01:56 ` Re: Default Performance between 8.0 and 8.1 Merlin Moncure <mmoncure@gmail.com>
@ 2007-08-06 17:58   ` Ted Jordan <ted@actionstep.com>
  0 siblings, 0 replies; 3+ messages in thread

From: Ted Jordan @ 2007-08-06 17:58 UTC (permalink / raw)
  To: 'Merlin Moncure' <mmoncure@gmail.com>; +Cc: pgsql-performance

Thanks Merlin.  I was running both via ssh so it effectively these were
local results.  I will try to isolate the issue to a single statement.  But
I think you have answered the larger question i.e. there is no well known
situation where this happens so I should expect to see roughly the same
performance between 8.0 and 8.1 for data loads and will therefore focus on
the specifics of our environment.

Regards,
-Ted.

-----Original Message-----
From: pgsql-performance-owner@postgresql.org
[mailto:pgsql-performance-owner@postgresql.org] On Behalf Of Merlin Moncure
Sent: 6 August 2007 1:57 p.m.
To: Ted Jordan
Cc: pgsql-performance@postgresql.org
Subject: Re: [PERFORM] Default Performance between 8.0 and 8.1

On 8/5/07, Ted Jordan <ted@actionstep.com> wrote:
> 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.

a few seconds to several minutes is not the kind of variance that is
explainable by architecture changes between the versions.  something
is amiss.  'maintenance_work_mem' can make a big difference with data
loads due to faster index builds but even that would not account for
the difference.

are you running locally or remotely?  if running remotely, you might
be seeing some networking/tcp problems.

can you reduce your problem down to a single copy statement for analysis?

merlin

---------------------------(end of broadcast)---------------------------
TIP 3: Have you checked our extensive FAQ?

               http://www.postgresql.org/docs/faq




^ permalink  raw  reply  [nested|flat] 3+ messages in thread


end of thread, other threads:[~2007-08-06 17:58 UTC | newest]

Thread overview: 3+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2007-08-04 20:35 Default Performance between 8.0 and 8.1 Ted Jordan <ted@actionstep.com>
2007-08-06 01:56 ` Merlin Moncure <mmoncure@gmail.com>
2007-08-06 17:58   ` Ted Jordan <ted@actionstep.com>

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