performance

From: Gustavo Henrique <gustavoh(at)sysadmin(dot)com(dot)br>
To: pgsql-general(at)postgresql(dot)org
Subject: performance
Date: 2000-05-06 17:54:59
Message-ID: 200005061605.NAA25066@backup.gbl.com.br
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

I have a table with about 200,000 entries and growing up.

Mostly i'm doing searchs based on 4 fields that are numbers...

can i create indexes for them ??

What are the problems of creating indexes for all fields, besides
disk space ?

Thanks for your attention,

Gustavo Henrique Maultasch de Oliveira
gustavoh(at)sysadmin(dot)com(dot)br

Browse pgsql-general by date

  From Date Subject
Next Message Tom Lane 2000-05-06 18:14:13 Re: You're on SecurityFocus.com for the cleartext passwords.
Previous Message Bruce Momjian 2000-05-06 17:30:24 Re: You're on SecurityFocus.com for the cleartext passwords.