Thread: Re: PostgreSQL a slow DB?

pgman wrote:
> Relaxin wrote:
> > > Except when it doesn't work.  It's a completely non-scientific method
> > > of determining answers, and has *enormous* bias due to ignorance.
> > >
> >
> > That has been my question all along...
> > Instead of "beating" people down when they (and others) have a concern,
> > rather it's real or not, you guy have to put real concrete information and
> > solutions out there to counter these misconceptions.
> >
> > My co-workers and I believe that PG is slow.
> > A way of helping this is by providing a solution to configuring the database
> > to work the best for a person setup, or give them some general parameters to
> > look into.
> >
> > The impression of PG being slow will not be solved by statements such as
> > "Some people believe Elvis is still alive."
>
> Let me tell you what I say at trade show booths when someone asks why
> they should use PostgreSQL rather than MySQL:
>
>     "Oh, I think you should use MySQL.  It has a nice cute name."
>
> Of course, the questioner gets this strange look on their face, and
> might ask another question, or just leave.
>
> Of course, the question is similar to, "Convince me to date your
> sister."  It isn't a very reasonable question.

Just to clarify, only one person hasn't realized it was a joke, and it
usually is a nice opener for discussion.  We all get a laugh out of it
with other booth staff talking about PostgreSQL and me making ridiculous
arguments on why they should use MySQL.

--
  Bruce Momjian   http://candle.pha.pa.us
  EnterpriseDB    http://www.enterprisedb.com

  + If your life is a hard drive, Christ can be your backup. +

> Just to clarify, only one person hasn't realized it
> was a joke, and it
> usually is a nice opener for discussion.  We all get
> a laugh out of it
> with other booth staff talking about PostgreSQL and
> me making ridiculous
> arguments on why they should use MySQL.

Bruce is and has been a big contributor to this
thread.  i don't think he's particularly represented
himself too well in this thread...  but i understand
why,

poster comes on using uninformed allegations to claim
postgresql is "slow."

this thread tone isn't all on Bruce, the OP basically
came here and instigated with baseless accusations.

i posted a link with a company using postgresql and he
objected using marketing "statistics" (lies, d*mned
lies and statistics). i posted another high profile
site using postgresql (sesamestreet.org) and not a
peep.

i'm beginning to think we may have been trolled.

what kind of response would one expect if one trolled
the mysql novice mailing list with "i heard mysql is a
"toy database" - is this true?  i've heard it enough
that i think there must be fire amongst all the
smoke."

btw, i have heard that accusation much more than i've
heard pgsql is slow.

in any case, pgsql isn't slow.  mysql isn't a toy
database (although it does have some gotchas that may
be deal killers for some minority of apps.  pgsql may
have some deal killers for a minority of apps, too,
although this will be for fewer apps than mysql). my
intranet app is blazing fast and i use adodb which is
suppose to slow things down on the web server side by
about 30%.  it still is blazing fast.

i don't have a lot of data, but i do have some complex
sql statements (20+ lines) and i have done zippo
tuning.

if the OP wants to use mysql, go for it and good luck.

if the OP wants to use pgsql, we'd (mostly others who
know more than i!) would be glad to help.

including Bruce.  i think, anyway...  ;-)

__________________________________________________
Do You Yahoo!?
Tired of spam?  Yahoo! Mail has the best spam protection around
http://mail.yahoo.com