select on 1milion register = 6s

From: "Bruno Rodrigues Siqueira" <bruno(at)ravnus(dot)com>
To: <pgsql-performance(at)postgresql(dot)org>
Subject: select on 1milion register = 6s
Date: 2007-07-28 19:27:14
Message-ID: 000c01c7d14d$4df223f0$e900a8c0@brunolaptop
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-performance

Friends,

Who can help me? My SELECT in a base with 1 milion register,
using expression index = 6seconds.

Please, I don't know how to makes it better.

Thanks

Responses

Browse pgsql-performance by date

  From Date Subject
Next Message Jeremy Harris 2007-07-28 19:40:12 Re: Slow query with backwards index scan
Previous Message Tilmann Singer 2007-07-28 19:27:13 Re: Slow query with backwards index scan