Postgres Pro
Downloads
Home   >   mailing lists

Re: using an index worst performances - Mailing list pgsql-performance

From Tom Lane
Subject Re: using an index worst performances
Date
Msg-id 22026.1093018762@sss.pgh.pa.us
Whole thread Raw
In response to Re: using an index worst performances  (Gaetano Mendola <mendola@bigfoot.com>)
Responses Re: using an index worst performances  (Gaetano Mendola <mendola@bigfoot.com>)
List pgsql-performance
Tree view 
Gaetano Mendola <mendola@bigfoot.com> writes:
> Using a prepared query:

> Without index and default stat 10 :    1.12 ms
> Without index and default stat 1000 :  1.25 ms
> With index and default stat 10:        1.35 ms
> With index and default stat 1000:      1.6 ms

Could we see EXPLAIN ANALYZE EXECUTE output for each case?

            regards, tom lane

pgsql-performance by date:

Previous
From: Gaetano Mendola
Date:
Subject: Re: using an index worst performances
Next
From: "Danilo Mota"
Date:
Subject: Query performance problem