Skip site navigation (1) Skip section navigation (2)

A few misc. questions.

From: "Rainer Mager" <rmager(at)vgkk(dot)com>
To: <pgsql-admin(at)postgresql(dot)org>
Subject: A few misc. questions.
Date: 2000-05-25 23:45:47
Message-ID: NEBBJBCAFMMNIHGDLFKGGEALCCAA.rmager@vgkk.com (view raw or flat)
Thread:
Lists: pgsql-admin
Hi all,

	I have a few miscellaneous questions. If anyone has any ideas I'd
appreciate hearing them.


1. What happens when the primary key index runs out. That is, if we use an
INT(4) for a key and we create and delete enough to reach that number then
what happens?


2. Does anyone one know a standard SQL method (that works with Postgres) to
retrieve the primary key of a newly INSERTed record? We've found one way but
it will not work with order databases since it relies on reading data from
the sequence tables.


3. Does anyone know of any way to perform a database backup/synchronization
that somehow does its work when the database is otherwise not busy? Which is
preferred, backing up the PG files or doing some sort of sync?


4. Does anyone have any advice on how often to run VACUUM? Any rules of
thumb, etc?


Thanks,

--Rainer


In response to

Responses

pgsql-admin by date

Next:From: Faisal Haji MustaffaDate: 2000-05-26 04:03:07
Subject: fe_sendauth
Previous:From: J Carlos Morales Duarte.Date: 2000-05-25 22:28:17
Subject: Data field whit long + 45000 car

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group