Translate

domingo, 6 de outubro de 2013

How to tune Omega Base for speed?

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.