Re: [BUGS] BUG #1552: massive performance hit between 7.4

From: Karim Nassar <karim(dot)nassar(at)NAU(dot)EDU>
To: Simon Riggs <simon(at)2ndquadrant(dot)com>
Cc: Keith Browne <tuxedo(at)deepsky(dot)com>, Brian O'Reilly <fade(at)deepsky(dot)com>, pgsql-performance(at)postgresql(dot)org
Subject: Re: [BUGS] BUG #1552: massive performance hit between 7.4
Date: 2005-03-25 10:50:36
Message-ID: 1111747837.898.19.camel@k2.cet.nau.edu
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs pgsql-performance

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

In response to

Responses

Browse pgsql-bugs by date

  From Date Subject
Next Message Tom Lane 2005-03-25 14:41:09 Re: BUG #1552: massive performance hit between 7.4 and 8.0.1
Previous Message Steinhaus, Harald 2005-03-25 10:43:08 BUG #1564: special Character OleDB

Browse pgsql-performance by date

  From Date Subject
Next Message Tom Lane 2005-03-25 14:41:09 Re: BUG #1552: massive performance hit between 7.4 and 8.0.1
Previous Message Simon Riggs 2005-03-25 10:18:37 Re: BUG #1552: massive performance hit between 7.4 and 8.0.1