Re: question on TRUNCATE vs VACUUM FULL - Mailing list pgsql-performance

From Bill Moran
Subject Re: question on TRUNCATE vs VACUUM FULL
Date
Msg-id 20080319095559.9de777dd.wmoran@collaborativefusion.com
Whole thread Raw
In response to Re: question on TRUNCATE vs VACUUM FULL  ("Mark Steben" <msteben@autorevenue.com>)
List pgsql-performance
In response to "Mark Steben" <msteben@autorevenue.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@collaborativefusion.com
Phone: 412-422-3463x4023

pgsql-performance by date:

Previous
From: Bill Moran
Date:
Subject: Re: PG writes a lot to the disk
Next
From: Greg Smith
Date:
Subject: Re: PG writes a lot to the disk