Re: question on TRUNCATE vs VACUUM FULL

Поиск
Список
Период
Сортировка
От Bill Moran
Тема Re: question on TRUNCATE vs VACUUM FULL
Дата
Msg-id 20080319095559.9de777dd.wmoran@collaborativefusion.com
обсуждение исходный текст
Ответ на Re: question on TRUNCATE vs VACUUM FULL  ("Mark Steben" <msteben@autorevenue.com>)
Список 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 по дате отправления:

Предыдущее
От: Bill Moran
Дата:
Сообщение: Re: PG writes a lot to the disk
Следующее
От: Greg Smith
Дата:
Сообщение: Re: PG writes a lot to the disk