[ADMIN] PErformance in tables to large

[vlal]

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"