Re: [GENERAL] PostgresSQL vs. Informix

2007-11-29 Thread Bruce Momjian
Jeff Trout wrote: > iirc, didn't some big us govt group move to PG from Informix? I > think Bruce mentioned something once about that.. US National Weather Service changed 170 weather sites from Informix to Postgres. Postgres worked well for them. -- Bruce Momjian <[EMAIL PROTECTED]>

Re: [GENERAL] PostgresSQL vs. Informix

2007-11-29 Thread Trent Shipley
In answering the question, it might help to have information on two background items. The first item is the politics of the situation. I gather from Chad Hendren's post that an individual in the top-8-OEM-customer enterprise is advocating for Postgresql. The second item is the existing tech

Re: [GENERAL] PostgresSQL vs. Informix

2007-11-29 Thread Jeff Trout
On Nov 28, 2007, at 6:11 PM, Jeff Larsen wrote: I can't offer much in the way of a case study, but I am an Informix customer that has been doing an informal feasibility study on switching to PostgreSQL. I've learned a ton from the high quality PG docs and from the PG mailing lists. I switched a

Re: [GENERAL] PostgresSQL vs. Informix

2007-11-29 Thread David Fetter
On Wed, Nov 28, 2007 at 11:11:07PM -0700, Gregory Williamson wrote: > * There is no equivalent of a "synonym"; a view can be used to fake this > sometimes > but where Informix lets you create a synonym to a table in another > database / > instance, PostgreSQL doesn't. dblink can be use

Re: [GENERAL] PostgresSQL vs. Informix

2007-11-28 Thread Gregory Williamson
Chad -- <...> > > Have you seen any studies (either by Sun or others) that compares > PostgresSQL to other commercial database software (Informix, Oracle, > Sybase,etc.)? I am interested seeing a feature by feature comparison of > PostgresSQL and Informix. > Hope this ain't too late! I can'

Re: [GENERAL] PostgresSQL vs. Informix

2007-11-28 Thread Ron Johnson
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 On 11/28/07 17:11, Jeff Larsen wrote: [snip] > > Lastly on the Informix side, they have more advanced online > backup/restore tools. It's similar to PG PITR backup but does not > depend on file-system level backup tools. The option I use (called > ont

Re: [GENERAL] PostgresSQL vs. Informix

2007-11-28 Thread Jeff Larsen
On Nov 28, 2007 9:32 AM, Chad Hendren <[EMAIL PROTECTED]> wrote: > I have a large OEM customer (one of the top 8 for Sun worldwide) that is > considering embedding PostgreSQL into the core of their primary product > instead of Informix. He is trying to build his case for this change. > Do we have

Re: [GENERAL] PostgresSQL vs. Informix

2007-11-28 Thread Erik Jones
On Nov 28, 2007, at 9:32 AM, Chad Hendren wrote: PostgreSQL Team, I have a large OEM customer (one of the top 8 for Sun worldwide) that is considering embedding PostgreSQL into the core of their primary product instead of Informix. He is trying to build his case for this change. Do we h

Re: [GENERAL] PostgresSQL vs. Informix

2007-11-28 Thread Jutta Horstmann
Hi Merlin, Chad, Merlin Moncure schrieb: > there was a very excellent case study, written by cc'd person, that is > unhappily not available at the moment. see: > http://archives.postgresql.org/pgsql-advocacy/2005-08/msg00147.php Thank you :-) The link in the post is not up to date. The linked c

Re: [GENERAL] PostgresSQL vs. Informix

2007-11-28 Thread Merlin Moncure
On Nov 28, 2007 10:32 AM, Chad Hendren <[EMAIL PROTECTED]> wrote: > PostgreSQL Team, > > I have a large OEM customer (one of the top 8 for Sun worldwide) that is > considering embedding PostgreSQL into the core of their primary product > instead of Informix. He is trying to build his case for this

Re: [GENERAL] PostgresSQL vs. Informix

2007-11-28 Thread mgainty
Hi Chad I had a devil of a time finding any usable doc on Informix whereas Postgres/MySQL and Oracle all had documentation aplenty Im still looking for a whitepaper or any benchmarks http://www.iiug.org/forums/ids/index.cgi/noframes/read/3517 Anyone? M-- - Original Message - Wrom: VFVWR