postmaster slowing down

I am using postgres 8.0.0
In my program I have a single connection to a database.
in side this connection i do the following

1. begin transaction
2. insert rows to table/s. (max number of tables = 4)
3. commit transaction

the above 3 steps take place around 800, 000 times
does it mean that it will slow down.

I have seen the behaviour as random, sometimes its fast nd sometimes very slow.

nothing else is running on the m/c
if i see the top output,
it shows 97 % postmaster


thanks,
regards
Surabhi

________________________________

From: Devrim GUNDUZ [mailto:devrim(at)CommandPrompt(dot)com]
Sent: Mon 11/6/2006 12:20 PM
To: surabhi.ahuja
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: [GENERAL] upgrade to 8.0.9

Hi,

On Mon, 2006-11-06 at 10:58 +0530, surabhi.ahuja wrote:
> I am currently using 8.0.0 and I want to upgrade to 8.0.9 Please tell
> if i can just install the rpms for 8.0.9

http://www.postgresql.org/ftp/binary/v8.0.9/linux/rpms/

Regards,
--
The PostgreSQL Company - Command Prompt, Inc. 1.503.667.4564
PostgreSQL Replication, Consulting, Custom Development, 24x7 support
Managed Services, Shared and Dedicated Hosting
Co-Authors: plPHP, plPerlNG - http://www.commandprompt.com/