pg.ddx.io pgsql-docs@postgresql.org mailing list archivehelp / color / mirror / Atom feed
From: Arjen van der Meijden <acm@tweakers.net>
To: 'Sean Chittenden' <sean@chittenden.org>
To: nolan@celery.tssi.com
Cc: '\"Advocacy PostgreSQL\"' <pgsql-advocacy@postgresql.org>
Cc: 'PostgreSQL-general' <pgsql-general@postgresql.org>
Subject: Re: [GENERAL] interesting PHP/MySQL thread
Date: Mon, 23 Jun 2003 11:21:25 +0200
Message-ID: <000a01c33968$ff7956b0$3ac15e91@acm> (raw)
In-Reply-To: <20030623030702.GM97131@perrin.int.nxad.com>
> Sean Chittenden wrote:
>
> Whoa, something's not right. Could you please send along an
> EXPLAIN ANALYZE after doing a VACUUM ANALYZE of your query
> that's taking 3-4x longer? Something smells very strange
> here because my experience has been quite the opposite... I
> can understand 0.05ms longer per connection in setup overhead
> (fork() vs new thread) , but this seems like way too much...
> I wonder if you couldn't benefit from the use of a cursor if
> you're returning a large dataset. -sc
>
Apparently it's hard to believe, but yes that's quite possible. And if
your query takes only 0.01ms than the 0.05 is quite a difference ;)
I've tested and compared both mysql and postgresql a few times and saw
both databases beat each other largely on performance.
If the query was "more complicated", postgresql is probably the winner.
But if it's a simple query (for instance a index-lookup) than mysql
beats postgres, yes 3-4x faster is very possible in such a case.
At least from my experience, but then again I'm not _that_ well educated
on the performance-tuning-options of postgres, I just improve the
sortmem and sharedmem and hope that's all to it. (actually, I left mysql
in more or less the default settings...)
There isn't any real documentation on the performance gains and losses
on all those options anyway, is there? So don't expect people to have
the best tuned database there is, that's relatively impossible if you
don't read this mailinglist 24/7 :)
Regards,
Arjen
view thread (72+ messages) latest in thread
Message-ID: <000a01c33968$ff7956b0$3ac15e91@acm> Permalink: ../000a01c33968$ff7956b0$3ac15e91@acm/ Also on: postgresql.org/message-id/000a01c33968$ff7956b0$3ac15e91@acm ·
reply
Reply instructions: You may reply publicly to this message via plain-text email using any one of the following methods: * Reply to all the recipients using the --to and --cc options: reply via email To: pgsql-docs@postgresql.org Cc: acm@tweakers.net, sean@chittenden.org, nolan@celery.tssi.com, pgsql-advocacy@postgresql.org, pgsql-general@postgresql.org Subject: Re: [GENERAL] interesting PHP/MySQL thread In-Reply-To: <000a01c33968$ff7956b0$3ac15e91@acm> * Save the following mbox file, import it into your mail client, and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions for how to clone and mirror all data and code used for this inbox