domingo, 6 de outubro de 2013

How to tune Omega Base for speed?

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.
This will give a performance boost on large databases, because PostgreSQL comes with a memory configuration for very small machines.

Edit $(DATABASE)/postgresql.conf
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:

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.

Nenhum comentário:

Postar um comentário