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

help / color / mirror / Atom feed
From: Stephen Frost <sfrost@snowman.net>
To: Tomasz Ostrowski <tometzky@batory.org.pl>
Cc: Mikkel H?gh <mikkel@hoegh.org>
Cc: pgsql-general <pgsql-general@postgresql.org>
Subject: Re: Drupal and PostgreSQL - performance issues?
Date: Thu, 16 Oct 2008 10:40:47 -0400
Message-ID: <20081016144046.GH4452@tamriel.snowman.net> (raw)
In-Reply-To: <48F70157.7010601@batory.org.pl>
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>

* Tomasz Ostrowski (tometzky@batory.org.pl) wrote:
> There is an issue report with lengthy discussion on drupal.org:
> http://drupal.org/node/196862
> And a proposed patch:
> http://drupal.org/files/issues/drupal_lookup_path-5.x.patch.txt
> which uses "limit 1". This patch is not applied though. I don't know why.

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

Attachments:

  signature.asc (application/pgp-signature, 196B) download

view thread (68+ messages)  latest in thread

Message-ID: <20081016144046.GH4452@tamriel.snowman.net>
Permalink:  ../20081016144046.GH4452@tamriel.snowman.net/
Also on:    postgresql.org/message-id/20081016144046.GH4452@tamriel.snowman.net

 · 

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: sfrost@snowman.net, tometzky@batory.org.pl, mikkel@hoegh.org, pgsql-general@postgresql.org
  Subject: Re: Drupal and PostgreSQL - performance issues?
  In-Reply-To: <20081016144046.GH4452@tamriel.snowman.net>

* 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