----- Original Message ----- From: "Bruce Momjian" <[EMAIL PROTECTED]> To: "Marc Mitchell" <[EMAIL PROTECTED]> Cc: <[EMAIL PROTECTED]> 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 ---------------------------(end of broadcast)--------------------------- TIP 3: if posting/reading through Usenet, please send an appropriate subscribe-nomail command to [EMAIL PROTECTED] so that your message can get through to the mailing list cleanly