Skip site navigation (1) Skip section navigation (2)

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 (view raw or flat)
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

pgsql-performance by date

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

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group