Re: PHP + PostgreSQL
Elaine Lindelef <eel@cognitivity.com>
From: Elaine Lindelef <eel@cognitivity.com>
To: pgsql-general@postgresql.org
Date: 2002-09-20T18:12:11Z
Lists: pgsql-general
>Good: >* postgres is really good for concurrent accesses (in part because of it's >better-than-row-level-locking) >* postgres is stable. I don't think I've heard of many non-hardware crashes >for a while now >* php has good support for postgres >* good feature set, won't hold you back >* good with a huge amount of data, and/or many table joins > >Bad: >* no replication (I suppose if you really need it, there are replication >soultions, but maybe not as good as oracle or db2), which means if you're >talking intense queries, you'll need to get a really big box that can handle >all those requests by itself. > >Regards, > Jeff Davis Of course, a bigger box running PostgreSQL is still cheaper and easier to maintain than multiple replicated servers. However, if you need to have super-high reliability, such that you've got mulitple servers in different areas of the country running concurrently, all accepting insert/update requests from users, then you'd need real replication. The PostgreSQL solutions around are good enough for a quick swap to a backup server. Elaine Lindelef > > >On Thursday 19 September 2002 09:52 am, Elielson Fontanezi wrote: > > Hi everybody! > > > > I doing a research about Apache Web Server + PHP + PostgreSQL. If it is > > reliable or not. The pros and set backs about it. > > From you what do you have to tell me about it? > > > > .............................................. > > A Question... > > Since before your sun burned hot in space > > and before your race was born, > > I have awaited a question. > > > > Elielson Fontanezi > > DBA Technical Support - PRODAM > > Parque do Ibirapuera s/n - SP - BRAZIL > > +55 11 5080 9493 > > >---------------------------(end of broadcast)--------------------------- >TIP 4: Don't 'kill -9' the postmaster