Re: INSERT performace.

----- 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