Maksim Sosnovskiy escreveu:
> The primary key is a set of values. And the key does include IP
> Address as well. Will it be more efficient to also add index on IP
> Address to speedup lookups by IP?
>
It depends on what set of queries that you run. If the most frequent queries
use ip_field, then y
Bill Preston wrote:
Fsync is off in 8.3.
You should consider turning synchronous_commit off instead. That's
almost as good as fsync=off performance-wise, but doesn't leave your
database corrupt in case of power loss or OS crash.
--
Heikki Linnakangas
EnterpriseDB http://www.enterprise
