Have you done a vacuum analyze on the tables, what are the
queries you're running and what does the explain output
from them look like?
Stephan Szabo
sszabo@bigpanda.com
On Tue, 26 Sep 2000 vlal@ideay.net.ni wrote:
> Hi all,
>
> I have a table with 3,000,000 of rows, I have two index:
> idx1 on --> (f_name,s_name,f_lastname,s_lastname)
> idx1 on --> (f_name,f_lastname)
>
> if the query is on 4 columns of the idx1, the result is speed, but if teh
> query is on two columns of the idx2 the rsult take 10 minutes.
>
> My postmaster run with option -S -o -F for best performance, but the
> results is very slow.
>
> I need suggestions, Thanks in advance,
>
> Regards,
> "La Vida"
>