Re: [GENERAL] postmaster slowing down

2006-11-06 Thread Richard Huxton
surabhi.ahuja wrote: Answer to Question 1: I forgot to mention this: before i start running this program (refer to the mail below) I clean up (rm -rf) and create the data directory (PGDATA, by doing initdb) then i create the 4 tables (stored procedures etc) and then run the program Please see t

Re: [GENERAL] postmaster slowing down

2006-11-06 Thread surabhi.ahuja
Title: Re: [GENERAL] postmaster slowing down Answer to Question 1:   I forgot to mention this: before i start running this program (refer to the mail below)  I clean up (rm -rf) and create the data directory (PGDATA, by doing initdb) then i create the 4 tables (stored procedures etc

Re: [GENERAL] postmaster slowing down

2006-11-06 Thread Richard Huxton
surabhi.ahuja wrote: 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 time

[GENERAL] postmaster slowing down

2006-11-06 Thread surabhi.ahuja
Title: Re: [GENERAL] upgrade to 8.0.9 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 pl