From: | M Simms <grim(at)argh(dot)demon(dot)co(dot)uk> |
---|---|
To: | pgsql-general(at)postgresql(dot)org |
Subject: | A few queries |
Date: | 1999-06-23 18:55:08 |
Message-ID: | 199906231855.TAA21840@argh.demon.co.uk |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
Hi
I have just installed 6.5, and I have a couple of questions that I cannot find
the answer to in the documentation.
Firstly, I am using temporary tables for a number of operations. Is
there a way to direct postgresql to keep these in memory for fast
access, or will it do this anyway?
Secondly, is there a way to instruct postgresql to process a query at
a lower priority, for things like daily maintainence routines that I
dont want to have slowing down the rest of the database ops by taking
all the cpu
Thirdly, how often should I vacuum a database. Is there a general rule
as to how many inserts or updates between vacuums is optimal?
Thanks
M Simms
From | Date | Subject | |
---|---|---|---|
Next Message | David R. Favor | 1999-06-23 18:58:02 | Re: [GENERAL] ERROR: typeidTypeRelid: Invalid type - oid = 0 |
Previous Message | Matt Magoffin (Borders Online) | 1999-06-23 18:54:54 | ERROR: typeidTypeRelid: Invalid type - oid = 0 |