Hi! What does Vacuumdb actually do!? I have a perl script which inserts records based on certain critera. I have noticed that if I do a vacuum WHILE my script is running, that I get a message: DBD::Pg::st execute failed: ERROR: Unable to locate type oid 150 in catalog I am starting postgres with '-i -B 4096 -o -F' options. The other question is there any other way to get more performace out of postgres? Vacuum seems to hang for a very long time on a table with about 120,000 records (3 indexes), and causes all access to this table to stop. I notice this slowdown when the postmaster has reached its maximum memory limit... Before that it seems to run quickly... Regards Andrew
