In larger databases, you´ll need to configure PostgreSQL to give better responses to users:
1-) Make either vacuum of the PostgreSQL database or enable the autovacuum of the tables.
(This is for 1.0.2 and earlier, in 1.0.5 and later autovacuum is enabled as default).
Read this for information(VACUUM).
This is crucial for mainteance of a PostgreSQL database like Omega Base.
2-) Augment PostgreSQL buffers.
will give a performance boost on large databases, because PostgreSQL
comes with a memory configuration for very small machines.
shared_buffers = Can be 1/4 of the total amount of RAM of the machine without problems.
effetive_cache_size = Size of the RAM cache for disk.
More info: http://wiki.postgresql.org/wiki/Tuning_Your_PostgreSQL_Server
3-) Make some more indexes.
If you don't know what is this, make sure to know someone to help you to make these indexes.