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

Re: Bad performance on simple query

From: "Scott Marlowe" <scott(dot)marlowe(at)gmail(dot)com>
To: "Dimi Paun" <dimi(at)lattica(dot)com>
Cc: pgsql-performance <pgsql-performance(at)postgresql(dot)org>
Subject: Re: Bad performance on simple query
Date: 2008-11-17 17:16:32
Message-ID: dcc563d10811170916n622e4f86g8f2b2dbe9b9e2a61@mail.gmail.com (view raw or flat)
Thread:
Lists: pgsql-performance
On Mon, Nov 17, 2008 at 10:07 AM, Dimi Paun <dimi(at)lattica(dot)com> wrote:
>
> 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.

Ahhh.  Keep in mind that if you just run the query, pgadminIII will
tell you how long it took to run AND return all the data across the
network, so it will definitely take longer then.  But most of that's
network io wait so it's not a real issue unless you're saturating your
network.

In response to

Responses

pgsql-performance by date

Next:From: Dimi PaunDate: 2008-11-17 17:31:02
Subject: Re: Bad performance on simple query
Previous:From: Dimi PaunDate: 2008-11-17 17:07:01
Subject: Re: Bad performance on simple query

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