PostgreSQL slammed by PHP creator
Hi all,
Any response to this:
http://www.internetnews.com/dev-news/article.php/3631831
From the FA:
One performance enhancement that Lerdorf suggested based on code analysis was to use MySQL instead of PostgreSQL for the database.
"If you can fit your problem into what MySQL can handle it's very fast," Lerdorf said. "You can gain quite a bit of performance."
For the items that MySQL doesn't handle as well as PostgreSQL, Lerdorf noted that some features can be emulated in PHP itself, and you still end up with a net performance boost.
-arturo
Arturo Perez wrote:
Any response to this:
http://www.internetnews.com/dev-news/article.php/3631831
Oh please! Can we skip this one?
Maybe on the advocacy groups, not on [GENERAL], pleeeeeze!
thanks,
bkw
On Sep 14, 2006, at 11:27 , Arturo Perez wrote:
Hi all,
Any response to this:
http://www.internetnews.com/dev-news/article.php/3631831From the FA:
One performance enhancement that Lerdorf suggested based on code
analysis was to use MySQL instead of PostgreSQL for the database."If you can fit your problem into what MySQL can handle it's very
fast," Lerdorf said. "You can gain quite a bit of performance."For the items that MySQL doesn't handle as well as PostgreSQL,
Lerdorf noted that some features can be emulated in PHP itself, and
you still end up with a net performance boost.
I wasn't able to find anything the "article" worth discussing. If you
give up A, C, I, and D, of course you get better performance- just
like you can get better performance from a wheel-less Yugo if you
slide it down a luge track.
-M
AgentM wrote:
On Sep 14, 2006, at 11:27 , Arturo Perez wrote:
One performance enhancement that Lerdorf suggested based on code
analysis was to use MySQL instead of PostgreSQL for the database....If you give up A, C, I, and D, of course you get better
performance- just like you can get better performance from a
wheel-less Yugo if you slide it down a luge track.
ROTFL. That has got to go down as a classic quotation.
Arturo Perez wrote:
Hi all,
Any response to this:
http://www.internetnews.com/dev-news/article.php/3631831From the FA:
One performance enhancement that Lerdorf suggested based on code analysis was to use MySQL instead of PostgreSQL for the database.
"If you can fit your problem into what MySQL can handle it's very fast," Lerdorf said. "You can gain quite a bit of performance."
For the items that MySQL doesn't handle as well as PostgreSQL, Lerdorf noted that some features can be emulated in PHP itself, and you still end up with a net performance boost.
Considering the quality piece of software that PHP is, I don't hold much
weight to his comment.
However, he does carry some umpf in certain circles. Perhaps we should
prove him wrong?
Joshua D. Drake
-arturo
--
=== The PostgreSQL Company: Command Prompt, Inc. ===
Sales/Support: +1.503.667.4564 || 24x7/Emergency: +1.800.492.2240
Providing the most comprehensive PostgreSQL solutions since 1997
http://www.commandprompt.com/
Joshua D. Drake wrote:
However, he does carry some umpf in certain circles. Perhaps we should
prove him wrong?
I take it you mean "oomph"?
Main Entry: oomph
Pronunciation: 'um(p)f
Function: noun
Etymology: imitative of a sound made under exertion
1 : personal charm or magnetism : GLAMOUR
2 : SEX APPEAL
3 : PUNCH, VITALITY
--
Alvaro Herrera http://www.CommandPrompt.com/
The PostgreSQL Company - Command Prompt, Inc.
Alvaro Herrera wrote:
Joshua D. Drake wrote:
However, he does carry some umpf in certain circles. Perhaps we should
prove him wrong?I take it you mean "oomph"?
Yeah probably :)
Main Entry: oomph
Pronunciation: 'um(p)f
Function: noun
Etymology: imitative of a sound made under exertion
1 : personal charm or magnetism : GLAMOUR
2 : SEX APPEAL
3 : PUNCH, VITALITY
--
=== The PostgreSQL Company: Command Prompt, Inc. ===
Sales/Support: +1.503.667.4564 || 24x7/Emergency: +1.800.492.2240
Providing the most comprehensive PostgreSQL solutions since 1997
http://www.commandprompt.com/
I wasn't able to find anything the "article" worth discussing. If you
give up A, C, I, and D, of course you get better performance- just like
you can get better performance from a wheel-less Yugo if you slide it
down a luge track.
I don't think a Yugo would give you better performance no matter what
you do ;)
-M
---------------------------(end of broadcast)---------------------------
TIP 3: Have you checked our extensive FAQ?
--
=== The PostgreSQL Company: Command Prompt, Inc. ===
Sales/Support: +1.503.667.4564 || 24x7/Emergency: +1.800.492.2240
Providing the most comprehensive PostgreSQL solutions since 1997
http://www.commandprompt.com/
* Arturo Perez (aperez@hayesinc.com) wrote:
Any response to this:
http://www.internetnews.com/dev-news/article.php/3631831
Turn fsync off and try again. Don't expect your data to stay consistant
tho.
Enjoy,
Stephen
pgsql-general-owner@postgresql.org wrote on 15/09/2006 04:40:04 a.m.:
I wasn't able to find anything the "article" worth discussing. If you
give up A, C, I, and D, of course you get better performance- just
like
you can get better performance from a wheel-less Yugo if you slide it
down a luge track.I don't think a Yugo would give you better performance no matter what
you do ;)
I found in my youth that a mini slides better on it roof than on it's
wheels.
As a comment on his points though, isn't it better to use the right tool
for the job rather than try to force one tool to do everything? I've
never used a hammer to put in a screw.
I don't use what is basically a web page generator to improve the
performance of my database.
-M
---------------------------(end of
broadcast)---------------------------
TIP 3: Have you checked our extensive FAQ?
--
=== The PostgreSQL Company: Command Prompt, Inc. ===
Sales/Support: +1.503.667.4564 || 24x7/Emergency: +1.800.492.2240
Providing the most comprehensive PostgreSQL solutions since 1997
http://www.commandprompt.com/---------------------------(end of broadcast)---------------------------
TIP 3: Have you checked our extensive FAQ?
****************************************************************************
Statement of confidentiality: This e-mail message and any accompanying
attachments may contain information that is IN-CONFIDENCE and subject to
legal privilege.
If you are not the intended recipient, do not read, use, disseminate,
distribute or copy this message or attachments.
If you have received this message in error, please notify the sender
immediately and delete this message.
****************************************************************************
*************************************************************************************
This e-mail message has been scanned for Viruses and Content and cleared
by the Ministry of Health's Content and Virus Filtering Gateway
*************************************************************************************
Simon_Kelly@moh.govt.nz wrote:
pgsql-general-owner@postgresql.org wrote on 15/09/2006 04:40:04 a.m.:
I wasn't able to find anything the "article" worth discussing. If you
give up A, C, I, and D, of course you get better performance- justlike
you can get better performance from a wheel-less Yugo if you slide it
down a luge track.I don't think a Yugo would give you better performance no matter what
you do ;)I found in my youth that a mini slides better on it roof than on it's
wheels.
I can top that :). I hit a telephone pole at 135MPH in a 66 Cuda :)
If it hadn't been for the gravel around that corner, I would have beat
the other car too.
Joshua D. Drake
--
=== The PostgreSQL Company: Command Prompt, Inc. ===
Sales/Support: +1.503.667.4564 || 24x7/Emergency: +1.800.492.2240
Providing the most comprehensive PostgreSQL solutions since 1997
http://www.commandprompt.com/
And yet this man is smart enough not to run MySQL on Windows. Methinks
this says something....
--
Brandon Aiken
CS/IT Systems Engineer
-----Original Message-----
From: pgsql-general-owner@postgresql.org
[mailto:pgsql-general-owner@postgresql.org] On Behalf Of Joshua D. Drake
Sent: Thursday, September 14, 2006 5:16 PM
To: Simon_Kelly@moh.govt.nz
Cc: PostgreSQL General ML
Subject: Re: [GENERAL] PostgreSQL slammed by PHP creator
Simon_Kelly@moh.govt.nz wrote:
pgsql-general-owner@postgresql.org wrote on 15/09/2006 04:40:04 a.m.:
I wasn't able to find anything the "article" worth discussing. If
you
give up A, C, I, and D, of course you get better performance- just
like
you can get better performance from a wheel-less Yugo if you slide
it
down a luge track.
I don't think a Yugo would give you better performance no matter what
you do ;)
I found in my youth that a mini slides better on it roof than on it's
wheels.
I can top that :). I hit a telephone pole at 135MPH in a 66 Cuda :)
If it hadn't been for the gravel around that corner, I would have beat
the other car too.
Joshua D. Drake
--
=== The PostgreSQL Company: Command Prompt, Inc. ===
Sales/Support: +1.503.667.4564 || 24x7/Emergency: +1.800.492.2240
Providing the most comprehensive PostgreSQL solutions since 1997
http://www.commandprompt.com/
---------------------------(end of broadcast)---------------------------
TIP 4: Have you searched our list archives?
Brandon Aiken wrote:
And yet this man is smart enough not to run MySQL on Windows. Methinks
this says something....
Heh..
Joshua D. Drake
--
Brandon Aiken
CS/IT Systems Engineer-----Original Message-----
From: pgsql-general-owner@postgresql.org
[mailto:pgsql-general-owner@postgresql.org] On Behalf Of Joshua D. Drake
Sent: Thursday, September 14, 2006 5:16 PM
To: Simon_Kelly@moh.govt.nz
Cc: PostgreSQL General ML
Subject: Re: [GENERAL] PostgreSQL slammed by PHP creatorSimon_Kelly@moh.govt.nz wrote:
pgsql-general-owner@postgresql.org wrote on 15/09/2006 04:40:04 a.m.:
I wasn't able to find anything the "article" worth discussing. If
you
give up A, C, I, and D, of course you get better performance- just
like
you can get better performance from a wheel-less Yugo if you slide
it
down a luge track.
I don't think a Yugo would give you better performance no matter what
you do ;)
I found in my youth that a mini slides better on it roof than on it's
wheels.I can top that :). I hit a telephone pole at 135MPH in a 66 Cuda :)
If it hadn't been for the gravel around that corner, I would have beat
the other car too.Joshua D. Drake
--
=== The PostgreSQL Company: Command Prompt, Inc. ===
Sales/Support: +1.503.667.4564 || 24x7/Emergency: +1.800.492.2240
Providing the most comprehensive PostgreSQL solutions since 1997
http://www.commandprompt.com/
On Thu, 2006-09-14 at 11:40, Joshua D. Drake wrote:
I wasn't able to find anything the "article" worth discussing. If you
give up A, C, I, and D, of course you get better performance- just like
you can get better performance from a wheel-less Yugo if you slide it
down a luge track.I don't think a Yugo would give you better performance no matter what
you do ;)
http://www.youtube.com/watch?v=mCkOpfLiRcA
mini on a ski jump.
I found in my youth that a mini slides better on it roof than on it's
wheels.I can top that :). I hit a telephone pole at 135MPH in a 66 Cuda :)
If it hadn't been for the gravel around that corner, I would have beat
the other car too.
I used to dream of hitting 70mph in the mini. I also had nightmares about
hitting other things in the mini ....
and on one memorable occation the nightmares came true and I hit the back
of my mates LandRover.
Guess who came off worst :o)
****************************************************************************
Statement of confidentiality: This e-mail message and any accompanying
attachments may contain information that is IN-CONFIDENCE and subject to
legal privilege.
If you are not the intended recipient, do not read, use, disseminate,
distribute or copy this message or attachments.
If you have received this message in error, please notify the sender
immediately and delete this message.
****************************************************************************
*************************************************************************************
This e-mail message has been scanned for Viruses and Content and cleared
by the Ministry of Health's Content and Virus Filtering Gateway
*************************************************************************************
Joshua D. Drake wrote:
Simon_Kelly@moh.govt.nz wrote:
pgsql-general-owner@postgresql.org wrote on 15/09/2006 04:40:04 a.m.:
I wasn't able to find anything the "article" worth discussing. If
you give up A, C, I, and D, of course you get better performance- justlike
you can get better performance from a wheel-less Yugo if you slide
it down a luge track.I don't think a Yugo would give you better performance no matter what
you do ;)I found in my youth that a mini slides better on it roof than on it's
wheels.I can top that :). I hit a telephone pole at 135MPH in a 66 Cuda :)
If it hadn't been for the gravel around that corner, I would have beat
the other car too.
' (a tear for your 66 cuda...)
--
Until later, Geoffrey
Those who would give up essential Liberty, to purchase a little
temporary Safety, deserve neither Liberty nor Safety.
- Benjamin Franklin
I can top that :). I hit a telephone pole at 135MPH in a 66 Cuda :)
If it hadn't been for the gravel around that corner, I would have beat
the other car too.' (a tear for your 66 cuda...)
Hell I cried more then a tear. The cop felt so bad for me, he didn't
even ticket me... All white, red interior... man I loved that car. It
was the first car that *I* bought with *my* money and I *owned* it. No
bank :)
Note that this was a very long time ago :)
Joshua D. Drake
--
=== The PostgreSQL Company: Command Prompt, Inc. ===
Sales/Support: +1.503.667.4564 || 24x7/Emergency: +1.800.492.2240
Providing the most comprehensive PostgreSQL solutions since 1997
http://www.commandprompt.com/
Joshua D. Drake wrote:
I can top that :). I hit a telephone pole at 135MPH in a 66 Cuda :)
If it hadn't been for the gravel around that corner, I would have
beat the other car too.' (a tear for your 66 cuda...)
Hell I cried more then a tear. The cop felt so bad for me, he didn't
even ticket me... All white, red interior... man I loved that car. It
was the first car that *I* bought with *my* money and I *owned* it. No
bank :)Note that this was a very long time ago :)
We are showing our age...
--
Until later, Geoffrey
Those who would give up essential Liberty, to purchase a little
temporary Safety, deserve neither Liberty nor Safety.
- Benjamin Franklin
Joshua D. Drake wrote:
I can top that :). I hit a telephone pole at 135MPH in a 66 Cuda :)
If it hadn't been for the gravel around that corner, I would have beat
the other car too.' (a tear for your 66 cuda...)
Hell I cried more then a tear. The cop felt so bad for me, he didn't
even ticket me... All white, red interior... man I loved that car. It
was the first car that *I* bought with *my* money and I *owned* it. No
bank :)
Are we talking about this one?
http://www.musclecarclub.com/musclecars/plymouth-cuda/plymouth-cuda.shtml
Note that this was a very long time ago :)
I hope it wasn't on 1966 ...
--
Alvaro Herrera http://www.CommandPrompt.com/
PostgreSQL Replication, Consulting, Custom Development, 24x7 support
Alvaro Herrera wrote:
Joshua D. Drake wrote:
I can top that :). I hit a telephone pole at 135MPH in a 66 Cuda :)
If it hadn't been for the gravel around that corner, I would have beat
the other car too.' (a tear for your 66 cuda...)
Hell I cried more then a tear. The cop felt so bad for me, he didn't
even ticket me... All white, red interior... man I loved that car. It
was the first car that *I* bought with *my* money and I *owned* it. No
bank :)Are we talking about this one?
http://www.musclecarclub.com/musclecars/plymouth-cuda/plymouth-cuda.shtmlNote that this was a very long time ago :)
I hope it wasn't on 1966 ...
I am not going to ask how you got to 135MPH.
--
Bruce Momjian bruce@momjian.us
EnterpriseDB http://www.enterprisedb.com
+ If your life is a hard drive, Christ can be your backup. +
