Wed Jul 27 21:49:18 PDT 2005
- Previous message: [Slony1-general] [PATCH] subscribe set performance enhancements
- Next message: [Slony1-general] [PATCH] subscribe set performance enhancements
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ]
Darcy Buskermolen wrote:
>C) determine if the desired log shipping behavior is observed.
>
>
Not the case for the SUBSCRIBE SET event.
It's easy to characterize by grabbing an extract of what is generated
for one table.
------------------------------------------------------------------------------------------------------------------------------------------------
delete from "public"."branches";copy "public"."branches" from stdin;
1 2112818 \N
\.
select "_T1".enableSubscriptionIndexes('"public"."branches"'); reindex
table "public"."branches"; analyze "public"."branches"; select
"_T1".maintenance_work_mem('16384');
------------------------------------------------------------------------------------------------------------------------------------------------
Problems:
1. There should be a query of the following form at the beginning...
select "_T1".disableSubscriptionIndexes('"public"."branches"');
2. The functions enableSubscriptionIndexes(),
disableSubscriptionIndexes(), and maintenance_work_mem() are not defined
in tools/slony1_dump.sh
I'll see about sending you a patch for the latter...
- Previous message: [Slony1-general] [PATCH] subscribe set performance enhancements
- Next message: [Slony1-general] [PATCH] subscribe set performance enhancements
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ]
More information about the Slony1-general mailing list