Hi,
( this msg has 2 questions )
I would like to create a db of all files (home + office + backups +
friends_backups from floppies, tapes, CDs, etc), and would like to store
it in pg. Now every row (a file or a directory) will have an node ID, name
(filename / dirname) and a parent node ID,
i've got a database with several million records.
i've found that from time to time i need to nuke the primary index in order
to get a vacuum done on it.
i don't like this, but i can live with it.
now, i'm vacuuming it and the backen process is growing to enormous size:
(i was gonna cut and p
Try to use --
-- Patient Records are really cool.
CREATE TABLE patient
(
id integer unqiue not null, -- A nifty column, eh?
);
-Message d'origine-
De : Bruce Tong <[EMAIL PROTECTED]>
À : PostgreSQL General <[EMAIL PROTECTED]>
Date : samedi 14 août 1999 04:55
Objet : [GENERA
Okay, if you run "ps ax" do you have a line reading something like
"/usr/bin/postmaster -S
-D/var/lib/pgsql -i"?. Second, if you do "ls /var/lib/pgsql/base" (as root), do you
see a subdirectory called template1?
Regards,
Mike Anderson
-Original Message-
From: Duncan Kinder [SMTP:
