A few queries

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

In response to

Browse pgsql-general by date

  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