Christopher Browne cbbrowne at ca.afilias.info
Fri Dec 14 08:47:01 PST 2007
Simon Riggs <simon at 2ndquadrant.com> writes:
> Chris,
>
> I didn't explicitly make the connection before but my investigation of
> whether we needed to VACUUM at all was connected to Cyril's performance
> decrease described above.
>
> We discussed increasing SLON_DATA_FETCH_SIZE, but we probably wouldn't
> need to do that if VACUUM didn't run and slow us down occasionally. 
>
> So maybe we can knock one thing off your task list, at least?

OK, I'll knock that one off...

> I can't remember where we left the earlier discussion on the vacuuming.
> Did you want me to make a patch, or can I leave it with you guys? No
> reason to rush at all my end, just trying to remember where we were.

Actually, if you have have code in mind, I'd be pleased to see a
patch.  It would seem a good thing to enlarge the set of people that
have some familiarity with the internals :-).
-- 
(format nil "~S@~S" "cbbrowne" "linuxfinances.info")
http://cbbrowne.com/info/spreadsheets.html
Oh,  boy, virtual memory!  Now I'm  gonna make  myself a  really *big*
RAMdisk!


More information about the Slony1-general mailing list