Re: question on TRUNCATE vs VACUUM FULL

From: Bill Moran <wmoran(at)collaborativefusion(dot)com>
To: "Mark Steben" <msteben(at)autorevenue(dot)com>
Cc: pgsql-performance(at)postgresql(dot)org
Subject: Re: question on TRUNCATE vs VACUUM FULL
Date: 2008-03-19 13:55:59
Message-ID: 20080319095559.9de777dd.wmoran@collaborativefusion.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-performance

In response to "Mark Steben" <msteben(at)autorevenue(dot)com>:

> Bill,
> Thanks for your quick response.
> We are at version 8.2.5 - just recently upgraded from 7.4.5.
> This strategy using truncate was just implemented yesterday.
> Now I will revisit the vacuum full strategy. Does seem to
> Be redundant.
> Is there a procedure to begin reporting a bug? Is there
> Someone or an email address that I could bring evidence to?

You're kinda on the right path already. The next thing to do (if nobody
gets back to you with an explanation or solution) is to put together a
simple, reproducible case that others can use to reproduce the behaviour
on systems where they can investigate it. Once you have that, use the
bug reporting form on the web site to report it as a bug.

--
Bill Moran
Collaborative Fusion Inc.
http://people.collaborativefusion.com/~wmoran/

wmoran(at)collaborativefusion(dot)com
Phone: 412-422-3463x4023

In response to

Browse pgsql-performance by date

  From Date Subject
Next Message Greg Smith 2008-03-19 14:16:19 Re: PG writes a lot to the disk
Previous Message Bill Moran 2008-03-19 13:49:22 Re: PG writes a lot to the disk