pg.ddx.io  pgsql-performance@postgresql.org mailing list archive  

help / color / mirror / Atom feed
From: DelGurth <delgurth@gmail.com>
To: Tomasz Ostrowski <tometzky@batory.org.pl>
To: Mikkel H?gh <mikkel@hoegh.org>
To: pgsql-general <pgsql-general@postgresql.org>
Subject: Re: Drupal and PostgreSQL - performance issues?
Date: Thu, 16 Oct 2008 17:09:44 +0200
Message-ID: <10268b3e0810160809l3f16fba3k1d45271fbbe865b@mail.gmail.com> (raw)
In-Reply-To: <20081016144046.GH4452@tamriel.snowman.net>
References: <a93e6cbe-0000-4000-9a34-4db3620c619d@mm>
	<C6449FCD-198D-4A04-BACB-1BB2F20DD5B1@hoegh.org>
	<48F4F053.1060201@hagander.net>
	<F933F17A-70BC-4DB0-9491-9EEF0E79ABD9@hoegh.org>
	<b42b73150810141422i5ad693a8la3966fa6334c23f7@mail.gmail.com>
	<7438A981-4B6A-4E5A-A1E0-50432CDEFB00@hoegh.org>
	<48F6EE94.8010904@batory.org.pl>
	<4BE94DFB-8917-4175-9083-7DEABC30BD7F@hoegh.org>
	<48F70157.7010601@batory.org.pl>
	<20081016144046.GH4452@tamriel.snowman.net>

On Thu, Oct 16, 2008 at 4:40 PM, Stephen Frost <sfrost@snowman.net> wrote:
> * Tomasz Ostrowski (tometzky@batory.org.pl) wrote:
> I don't see 'limit 1' anywhere in that patch..  And you don't want to
> use 'limit 1' *and* count(*), that doesn't do what you're expecting
> (since count(*) is an aggregate and limit 1 is applied after).  You
> really want to do something more like:
>
> select true from tab1 limit 1;
>
> And then test if you got back any rows or not (which might be what
> *your* patch does, hadn't looked at it yet).
>
>        Thanks,
>
>                Stephen

Seems Tomasz linked to the wrong patch. The patch he meant was:
http://drupal.org/files/issues/drupal_lookup_path-6.x.patch.txt

Or better... he linked to the correct patch (for drupal 5.x) but the
user Earnie made a mistake or something in the 5.x patch, seeing the
comment[1] that the patches should be the same...

Also nice to see people "benchmark" differences by just executing a
query once[2][3]....

Wessel

[1] http://drupal.org/node/196862#comment-648511
[2] http://drupal.org/node/196862#comment-649791
[3] http://drupal.org/node/196862#comment-649928



view thread (68+ messages)  latest in thread

Message-ID: <10268b3e0810160809l3f16fba3k1d45271fbbe865b@mail.gmail.com>
Permalink:  ../10268b3e0810160809l3f16fba3k1d45271fbbe865b@mail.gmail.com/
Also on:    postgresql.org/message-id/10268b3e0810160809l3f16fba3k1d45271fbbe865b@mail.gmail.com

 · 

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-performance@postgresql.org
  Cc: delgurth@gmail.com, tometzky@batory.org.pl, mikkel@hoegh.org, pgsql-general@postgresql.org
  Subject: Re: Drupal and PostgreSQL - performance issues?
  In-Reply-To: <10268b3e0810160809l3f16fba3k1d45271fbbe865b@mail.gmail.com>

* 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