PErformance in tables to large

From: <vlal(at)ideay(dot)net(dot)ni>
To: pgsql-admin(at)postgresql(dot)org
Subject: PErformance in tables to large
Date: 2000-09-27 02:31:35
Message-ID: Pine.LNX.4.21.0009262025370.14062-100000@ideay.net.ni
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

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"

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message Loïc TREGOUËT 2000-09-27 09:11:38 security , multiple interface
Previous Message Stephan Szabo 2000-09-27 02:15:28 Re: PErformance in tables to large