Tue Aug 16 00:39:57 PDT 2005
- Previous message: [Slony1-general] replicated database bigger than master
- Next message: [Slony1-general] Slow catchup
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ]
I'm having trouble with a subscriber failing to catch up with a provider. I have just performed a sync which succeeded with no problem. Initially after the sync, about 4 minutes worth a provider updates were being processed per minute at the subscriber. Now it is down to less than a tenth of the speed of the provider. The subscriber machine itself is running mostly idle. What can I look for in order to track down this problem? If I look at pg_locks I see the following: DbSchema=# select d.datname || '.' || c.relname as object, DbSchema-# l.transaction as trans, l.pid, l.mode DbSchema-# from pg_locks l DbSchema-# left outer join pg_database d DbSchema-# on d.oid = l.database DbSchema-# left outer join pg_class c DbSchema-# on c.oid = l.relation DbSchema-# order by 1; object | trans | pid | mode -----------------------+---------+-------+----------------- DbSchema.pg_class | | 29510 | AccessShareLock DbSchema.pg_class | | 29444 | AccessShareLock DbSchema.pg_locks | | 29510 | AccessShareLock DbSchema.pg_namespace | | 29444 | AccessShareLock DbSchema.sl_setsync | | 29444 | AccessShareLock DbSchema.sl_table | | 29444 | AccessShareLock | 1421292 | 29510 | ExclusiveLock | | 29510 | AccessShareLock | 1421225 | 29444 | ExclusiveLock (9 rows) DbSchema=# I never see any of my own tables being locked. There is also nothing interesting in the slon logfiles. __ Marc Munro -------------- next part -------------- A non-text attachment was scrubbed... Name: not available Type: application/pgp-signature Size: 189 bytes Desc: This is a digitally signed message part Url : http://gborg.postgresql.org/pipermail/slony1-general/attachments/20050816/6cc5b114/attachment.bin
- Previous message: [Slony1-general] replicated database bigger than master
- Next message: [Slony1-general] Slow catchup
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ]
More information about the Slony1-general mailing list