Postgres Pro
Downloads
Home   >   mailing lists

Re: Poor performance on very simple query ? - Mailing list pgsql-performance

From Steinar H. Gunderson
Subject Re: Poor performance on very simple query ?
Date
Msg-id 20061003120027.GA13395@uio.no
Whole thread Raw
In response to Poor performance on very simple query ?  (Arnaud Lesauvage <thewild@freesurf.fr>)
Responses Re: Poor performance on very simple query ?  (Arnaud Lesauvage <thewild@freesurf.fr>)
List pgsql-performance
Tree view 
On Tue, Oct 03, 2006 at 01:25:10PM +0200, Arnaud Lesauvage wrote:
> For example, this query returns only 7 rows and takes about 1
> second to run !
>
> [...]
>
>   Total runtime: 0.801 ms

0.801 ms is _far_ under a second... Where do you have the latter timing from?

/* Steinar */
--
Homepage: http://www.sesse.net/

pgsql-performance by date:

Previous
From: Arnaud Lesauvage
Date:
Subject: Poor performance on very simple query ?
Next
From: Arnaud Lesauvage
Date:
Subject: Re: Poor performance on very simple query ?