performance - Mailing list pgsql-general

From Gustavo Henrique
Subject performance
Date
Msg-id 200005061605.NAA25066@backup.gbl.com.br
Whole thread Raw
List 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@sysadmin.com.br

pgsql-general by date:

Previous
From: Bruce Momjian
Date:
Subject: Re: What do you think?
Next
From: Alfred Perlstein
Date:
Subject: psql 7.0 startup - ERROR: ExecOpenScanR: failed to open relation 0