I am totally new to postgres and I wondering what settings should I be
using for autovacuum ?
For now I just uncommented all the defaults, is this good enough ? The
database is not large but it is a web database so there is a lot of
inserts and updates.
autovacuum = on #
I am using triggers and table inheritance for my audit tables. Here is
the function I am using its straight copy from the docs.
CREATE OR REPLACE FUNCTION process_reward_audit()
RETURNS "trigger" AS
$BODY$
BEGIN
IF (TG_OP = 'INSERT') THEN
INSERT IN
Is it possible to give a group the the createuser permission ? This
way if a user in the group they can create users.
---(end of broadcast)---
TIP 3: Have you checked our extensive FAQ?
http://www.postgresql.org/docs/faq