Tue Jul 28 12:14:23 PDT 2009
- Previous message: [Slony1-general] slony1-2.0.2 lag time
- Next message: [Slony1-general] sl_log_1 not used
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ]
Hi, A client has an installation of slony I 1.2.15 with pg 8.3.7 and they are having troubles with the size of the database... while checking i found that sl_log_2 has more than 102784620 dead tuples and the table size grows to 22gb, vac_frecuency is 0 and autovacuum is enabled but no vacuum has happened... i will execute a manual vacuum later today when the impact is not so big AFAIUI, slony should switch sl_log_* tables from time to time and then truncate the other one but i don't see sl_log_1 being used (never), it has 0 live tuples and 0 dead tuples... ideas? -- Atentamente, Jaime Casanova Soporte y capacitación de PostgreSQL Asesoría y desarrollo de sistemas Guayaquil - Ecuador Cel. +59387171157
- Previous message: [Slony1-general] slony1-2.0.2 lag time
- Next message: [Slony1-general] sl_log_1 not used
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ]
More information about the Slony1-general mailing list