On 11/29/2007 12:06 PM, Simon Riggs wrote:
> Have the cleanup_thread measure the size of the log table. If it exceeds
> a specified size then we DELETE, otherwise we just wait for TRUNCATE. If
> people have enough space they can just let the table build up and let it
> be truncated when we switch log tables.

Simon is right. We could as well live without a DELETE ever.

Note that in 1.2 the TRUNCATE periodically is necessary to ensure that 
the xxid wraparound problem never corrupts indexes. Since DELETE alone 
doesn't remove heap or index tuples, it doesn't make the subscribers 
scan effort any smaller at all. So a more frequent log switch and no 
DELETE or VACUUM at all should do.


Jan

-- 
#======================================================================#
# It's easier to get forgiveness for being wrong than for being right. #
# Let's break this rule - forgive me.                                  #
#================================================== JanWieck at Yahoo.com #