From: "Mark Dexter" <[EMAIL PROTECTED]>
> Thanks very much for the information. It would appear that our best
option might be to vacuum analyze these tables in our
> application at a point in time when they contain rows instead of doing it
at night. Needlesst to say, it would nice to have > an
From: Richard Huxton [mailto:[EMAIL PROTECTED]
Sent: Wed 11/24/2004 1:26 AM
To: Mark Dexter
Cc: [EMAIL PROTECTED]
Subject: Re: [GENERAL] VACUUM and ANALYZE With Empty Tables
Mark Dexter wrote:
> We use a development environment that works with Postgres via ODBC
Mark Dexter wrote:
We use a development environment that works with Postgres via ODBC and
uses cursors to insert and update rows in Postgres tables. I'm using
Postgres version 7.4.5.
A. If I TRUNCATE or DELETE all of the rows in the table and then run
VACUUM or ANALYZE on the empty table, the tes
