select on 1milion register = 6s - Mailing list pgsql-performance

From Bruno Rodrigues Siqueira
Subject select on 1milion register = 6s
Date
Msg-id 000c01c7d14d$4df223f0$e900a8c0@brunolaptop
Whole thread Raw
Responses Re: select on 1milion register = 6s
Re: select on 1milion register = 6s
List 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

 

 

pgsql-performance by date:

Previous
From: Tilmann Singer
Date:
Subject: Re: Slow query with backwards index scan
Next
From: Craig James
Date:
Subject: Re: select on 1milion register = 6s