When I was researching PG vs MySQL - the big kicker was transaction support
(mySQL doesn't have it). It looks like MySQL is faster than PG and so is
great for serving data to a web site. But if you also need to perform
updates to multiple tables, you probably will want to use transactions - so
use PostgreSQL.
I chose PostgreSQL for this reason.
The PostgreSQL team is incredible. To try and contribute a little, we
switched our development from the released software to the PG development
software (so we can report, and sometimes fix problems) - any bugs we
discovered but couldn't fix ourselves were fixed within hours. Our own
modifications were checked and entered in their development tree in less
than an hour. Cool.
The code itself is of very high quality.
Steve
Vince Vielhaber wrote:
> Can anyone here help?
>
> Vince.
>
> ---------- Forwarded message ----------
> Date: Mon, 10 Jan 2000 08:52:06 +0000
> From: Jude Weaver <exec@shreve.net>
> To: webmaster@postgresql.org
> Subject: Simmultanous Connections
>
> We are a company that writes academic software . We are converting our
> software to use either PostgreSQL or MySQL. We are leaning toward
> PostgreSQL, but, I still have several questions.
> I hope someone can answer these for me.
>
> 1. I have read the Q&A for postgreSQL and would like to know the
> difference between a temporary
> and a permanant connection. Do you have a connection when you open
> the database or only when
> the frontend sends a job to the backend? If 32 people are running
> a module that opens a database
> is that 32 connections or will it vary as users read and write to
> the database?
>
> 2. I saw in the Q&A that to run more than 32 simmultanous connects could
> be a big drain on our re-
> sources. Our Linux boxes , in general, are Intel 166 to 500s, 128MG
> of RAM and 6.2 to 13 GIG.
> Can anyone tell me roughly how much resources per connection does
> PostgreSQL use?
>
> 3. If I have 90 teachers posting grades at the same time, (the grade
> posting program opens 5 dif-
> ferent databases) and 25 secretaries and administrators poking
> around in assorted databases
> looking at information, will postgresql handle that much traffic?
>
> I would appreciate any information you can give me,
> Thank you - Jude Weaver.
>
> ************