Re: Bad performance on simple query

From: Dimi Paun <dimi(at)lattica(dot)com>
To: Scott Marlowe <scott(dot)marlowe(at)gmail(dot)com>
Cc: pgsql-performance <pgsql-performance(at)postgresql(dot)org>
Subject: Re: Bad performance on simple query
Date: 2008-11-17 17:07:01
Message-ID: 1226941621.5760.97.camel@dimi.lattica.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-performance


On Mon, 2008-11-17 at 09:53 -0700, Scott Marlowe wrote:
>
> Are you saying it's excessive you need the compound query? Cause
> that's running in 91microseconds as pointed out by Alan.

Of course, my bad. I read that as 91ms (<blush/>).

Confusion came from the fact that pgadminIII reports the query
taking 20-40ms, so I read the 0.091 as seconds not ms.

--
Dimi Paun <dimi(at)lattica(dot)com>
Lattica, Inc.

In response to

Responses

Browse pgsql-performance by date

  From Date Subject
Next Message Scott Marlowe 2008-11-17 17:16:32 Re: Bad performance on simple query
Previous Message Scott Marlowe 2008-11-17 16:53:51 Re: Bad performance on simple query