It used to be that we would get 'out of memory' errors from slon processes after the grew gradually for a wekk. Now, we have them dying when trying to process a SYNC event.
We do have some really large records. I think the biggest is 3.7 million bytes and one table in sl_log_1 has an average length of 127,000. The machine has 16 GB of RAM. We are running 32-bit slon processes on 64-bit x86_64 kernel so there should be say 2 GB of process memory. I suspect that there is a memory leak in the slon daemon. Even the largest 100 records should fit in memory. - Ian _______________________________________________ Slony1-general mailing list [email protected] http://gborg.postgresql.org/mailman/listinfo/slony1-general
