Re: INSERT performace. - Mailing list pgsql-admin

From Marc Mitchell
Subject Re: INSERT performace.
Date
Msg-id 011c01c1a6f8$49bfeea0$7401a8c0@Home
Whole thread Raw
In response to Re: INSERT performace.  (Bruce Momjian <pgman@candle.pha.pa.us>)
List pgsql-admin
----- Original Message -----
From: "Bruce Momjian" <pgman@candle.pha.pa.us>
To: "Marc Mitchell" <marcm@eisolution.com>
Cc: <pgsql-admin@postgresql.org>
Sent: Saturday, January 26, 2002 10:51 PM
Subject: Re: [ADMIN] INSERT performace.


> Marc Mitchell wrote:
> > We have a fresh database and have begun to observe performance
degradation
> > for INSERTs as a table went from empty to 100,000-ish rows.  Initial
> > INSERTs were sub second while after 30k rows, they were 1-3 seconds.
> >
> > Note that we have done NO performance tuning yet nor are there any
indexes
> > on the tables.
>
> Can we have PostgreSQL version and OS information?

OS is RedHat Linux 2.2.19 #8 SMP Fri Sep 21 10:04:24 CDT
Postgres is  PostgreSQL 7.1.2 on i686-pc-linux-gnu, compiled by GCC 2.96




pgsql-admin by date:

Previous
From: Tom Lane
Date:
Subject: Re: INSERT performace.
Next
From: hubert depesz lubaczewski
Date:
Subject: Re: INSERT performace.