using an index worst performances

From: Gaetano Mendola <mendola(at)bigfoot(dot)com>
To: pgsql-performance(at)postgresql(dot)org
Subject: using an index worst performances
Date: 2004-08-19 17:26:01
Message-ID: cg2nrf$sc1$1@floppy.pyrenet.fr
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-performance

Hi all,
I'm tring to optimize the following query:

http://rafb.net/paste/results/YdO9vM69.html

as you can see from the explain after defining the
index the performance is worst.

If I raise the default_statistic_target to 200
then the performance are worst then before:

Without index: 1.140 ms
With index: 1.400 ms
With default_statistic_targer = 200: 1.800 ms

tought anyone ?

Regards
Gaetano Mendola

Responses

Browse pgsql-performance by date

  From Date Subject
Next Message Daniel Ceregatti 2004-08-19 18:03:04 What is the best way to do attribute/values?
Previous Message Josh Berkus 2004-08-19 16:18:31 Re: Help specifying new machine