SPEED UP. - Mailing list pgsql-sql

I would like to know is there is a specific way to speed up my query to
postgres.

I have a DB-MACHINE that I use just and only for postgres witch runs
linux RedHad 6.2 with 1Gb of RAM on ULTRA SCSI discs.

I run vacuum every hour, but there is something else I can do (compile
postgres in a special way ) to get the best from postgres ??


Thanks in advance

Alex