Re: PErformance in tables to large

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(at)bigpanda(dot)com

On Tue, 26 Sep 2000 vlal(at)ideay(dot)net(dot)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"
>