pg.ddx.io  pgsql-performance@postgresql.org mailing list archive  
help / color / mirror / Atom feed
From: Karim Nassar <karim.nassar@NAU.EDU>
To: Simon Riggs <simon@2ndquadrant.com>
Cc: Keith Browne <tuxedo@deepsky.com>
Cc: Brian O'Reilly <fade@deepsky.com>
Cc: pgsql-performance@postgresql.org
Subject: Re: [BUGS] BUG #1552: massive performance hit between	7.4
Date: Fri, 25 Mar 2005 03:50:36 -0700
Message-ID: <1111747837.898.19.camel@k2.cet.nau.edu> (raw)
In-Reply-To: <1111745917.11750.713.camel@localhost.localdomain>
References: <20050318232102.08FA0F0E5D@svr2.postgresql.org>
	<1111567230.11750.596.camel@localhost.localdomain>
	<4241C1DF.2020000@deepsky.com>
	<1111745917.11750.713.camel@localhost.localdomain>

On Fri, 2005-03-25 at 10:18 +0000, Simon Riggs wrote:
> > When running with PostgreSQL 7.4 on a dual-CPU Athlon MP2400+ machine 
> > with a gigabyte of RAM, running Debian Linux version 2.6.8.1, we were 
> > able to insert all this data in 5-7 minutes.  It's taken a while to 
> > install Postgres 8.0.1 on the same machine, but now I have, and it's 
> > taking 40-45 minutes to run the same insert script.  

<snip>

> OK. Not-a-bug.
>
> Your situation is covered in the manual with some sage advice
> http://www.postgresql.org/docs/8.0/static/populate.html
> It doesn't go into great lengths about all the reasons why those
> recommendations are good ones - but they are clear.


Simon, this begs the question: what changed from 7.4->8.0 to require he
modify his script?


TIA,
-- 
Karim Nassar
Department of Computer Science
Box 15600, College of Engineering and Natural Sciences
Northern Arizona University,  Flagstaff, Arizona 86011
Office: (928) 523-5868 -=- Mobile: (928) 699-9221




view thread (14+ messages)  latest in thread

Message-ID: <1111747837.898.19.camel@k2.cet.nau.edu>
Permalink:  ../1111747837.898.19.camel@k2.cet.nau.edu/
Also on:    postgresql.org/message-id/1111747837.898.19.camel@k2.cet.nau.edu

 · 

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: karim.nassar@NAU.EDU, simon@2ndquadrant.com, tuxedo@deepsky.com, fade@deepsky.com
  Subject: Re: [BUGS] BUG #1552: massive performance hit between	7.4
  In-Reply-To: <1111747837.898.19.camel@k2.cet.nau.edu>

* 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