Postgress Performance

[Paul Fink]

In general Orion and postgres seem to work well together but I have a problem with the performance of inserts.   As the size of the table increases the rate at which I can do inserts, or bean creates, decreases dramatically.   I have a very simple Alarm entity bean with a single Long as the primary key. Running under Linux on a PIII. When I start with an empty table I can create new Alarm beans at a rate of about 40/sec. When the table reaches 10K entries the rate is down to 10/sec and continues to drop.    I have the entity bean wrapped by a session bean and I do several creates per transaction. The only trick I've found for speeding up postgress is the "-o -F" flag which I've done.