Re: Bad performance on simple query

On Mon, 2008-11-17 at 10:40 -0700, Scott Marlowe wrote:
> I'm guessing a fair bit of that time is pgadminIII prettifying the
> output for you, etc.  I.e. it's not all transfer time.  Hard to say
> without hooking some kind of profiler in pgadminIII.  Is psql running
> local and pgadminIII remotely?  Or are they both remote?  If both psql
> and pgadminIII are remote (i.e. same basic circumstances) then it's
> got to be a difference in the client causing the extra time.  OR is
> this output of explain analyze?

With \timing on I get basically the same output (local vs remote)
in psql (0.668ms vs. 0.760ms). More like it.


WTH is pgadminIII reporting?!?

--
Dimi Paun <dimi@lattica.com>
Lattica, Inc.