Hi folks,
here's some new tip for the maillist footers:
"if vacuum (from some scripts) doesnt seem to work, have a
look at the logfile - you're probably using the wrong login"
I just had to learn that's a nice pitfall, if you're trying to do
routine vacuum from some php scripts and l
After a long battle with technology, [EMAIL PROTECTED], an earthling, wrote:
> I need a reliable way to determine the overall size of our database.
> Recently, I started using the database_size() function from the dbsize
> contrib.
>
> Everything seems to work great until I need to delete records.
On Fri, Jul 01, 2005 at 09:30:50AM -0400, [EMAIL PROTECTED] wrote:
>
> I would expect the database size to decrease after the VACUUM.
Note what the documentation says about VACUUM and recovering disk
space:
http://www.postgresql.org/docs/8.0/static/maintenance.html#VACUUM-FOR-SPACE-RECOVERY
"Th
