RE: Postgress Performance
Thanks, I had tried these with little improvement. After looking at pgbench.c and reading other comments my conclusion is that postgres is this slow on doing inserts. The fast means of inserts a lot of data is to use COPY which is not useful for creating beans. It looks like my best bet is to ether switch to HSQL or at least use a combination of Postgres and HSQL. > -Original Message- > From: Sach Jobb [SMTP:[EMAIL PROTECTED]] > Sent: Sunday, January 28, 2001 1:42 PM > To: Orion-Interest > Subject: Re: Postgress Performance > > It could be a performance issue with Postgres. By default Postgres uses a > "paranoid" setting that writes each transaction to disk immediately after > the transaction is completed. This is done to protect the integrity of the > database, as at anytime the database could go down and data could be > lost. > > However, when dealing with large numbers of transaction this can severely > impair performance. So, you can disable it by changing your postmaster > line to something like this: > > postmaster -o -F -D /mypath/to/datadir > > You can also get a little speed out of detaching from the tty you started > it from by using the "-S" switch. > > And, of course, in terms of performance when deploying you should really > tweak the number of backend connections. > > Hope that helps. > > > thanks, > sach > > %s/windows/linux/g > > > On Sun, 28 Jan 2001, Paul Fink wrote: > > > 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. > > > > > > >
Re: Postgress Performance
It could be a performance issue with Postgres. By default Postgres uses a "paranoid" setting that writes each transaction to disk immediately after the transaction is completed. This is done to protect the integrity of the database, as at anytime the database could go down and data could be lost. However, when dealing with large numbers of transaction this can severely impair performance. So, you can disable it by changing your postmaster line to something like this: postmaster -o -F -D /mypath/to/datadir You can also get a little speed out of detaching from the tty you started it from by using the "-S" switch. And, of course, in terms of performance when deploying you should really tweak the number of backend connections. Hope that helps. thanks, sach %s/windows/linux/g On Sun, 28 Jan 2001, Paul Fink wrote: > 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. > > >
Postgress Performance
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.