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.
> >
> >
> >
>