We had a problem with either timestamp or date (i can't remember which
now) with the default postgres JDBC driver, so we had to hack the driver
to make it work right. So if you don't need anything to do with time and
you don't need to store large binary data you should be fine. ;)
Actually, it works quite well. We deployed a couple of months ago with 33
million records in the database (4 processor, 4GB RAM, Sun Server) and
orion on two application boxes (dual processor, 4GB sun servers). It's
incredibly fast.
Thanks,
sach
robot6
%s/windows/linux/g
On Wed, 17 Jan 2001, Randahl Fink Isaksen wrote:
> Interesting... but are you stating that without fixing bugs in the JDBC
> driver for PostgreSQL, it just will not work? If so, I would of course like
> to hear what you fixed exactly...
>
> Yours
>
> Randahl
>
> -----Original Message-----
> From: [EMAIL PROTECTED]
> [mailto:[EMAIL PROTECTED]]On Behalf Of Mike
> Cannon-Brookes
> Sent: 17. januar 2001 13:51
> To: Orion-Interest
> Subject: RE: Is combining Orion and PostgreSQL a good choice
>
>
> I'm using PostgreSQL on an application that is about to go live (within the
> next month). Seems to be working fine in testing so far, we're moving off
> Sybase 11.0.3.3 on Linux to PostgreSQL (probably 7.1 by the time we go
> live).
>
> I've personally fixed a bug or two in the JDBC driver, but other than that
> the latest driver seems very solid.
>
> I use the default schema (the latest one from Orion has a lot of fixes
> contributed by myself and others, the original was horrible). Let me know if
> there are any problems with the latest schema.
>
> -mike
>
> > -----Original Message-----
> > From: [EMAIL PROTECTED]
> > [mailto:[EMAIL PROTECTED]]On Behalf Of Randahl Fink
> > Isaksen
> > Sent: Wednesday, January 17, 2001 11:01 PM
> > To: Orion-Interest
> > Subject: Is combining Orion and PostgreSQL a good choice
> >
> >
> > I am wondering if using PostgreSQL with Orion would be a good
> > option. So my
> > questions are:
> >
> > 1. Has anyone tried using PostgreSQL with Orion in a real-life application
> > (running for a long period with no errors) - and was it a success?
> >
> > 2. Do you use the default database schema for PostgreSQL that comes with
> > Orion?
> >
> >
> > Yours
> >
> > Randahl
> >
> >
> >
> >
> >
>
>
>
>
