Tue Aug 19 09:56:51 PDT 2008
- Previous message: [Slony1-general] Help with grouping sets
- Next message: [Slony1-general] Help with grouping sets
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ]
What deadlocking issues? We have about 100 tables in a single set and things are working out pretty well. Note: not all of our 100 tables are related to one another via foreign keys; we chose to keep everything in a single set purely for simplicity. --S -----Original Message----- From: slony1-general-bounces at lists.slony.info [mailto:slony1-general-bounces at lists.slony.info] On Behalf Of Adam Olsen Sent: Tuesday, August 19, 2008 9:32 AM To: slony1-general at lists.slony.info Subject: [Slony1-general] Help with grouping sets Hello, First off, I'm sorry if this seems like a stupid question. I'm trying to group my tables into sets. In the online documentation, it says that "It will be vital to group tables together into a single set if those tables are related via foreign key constraints". I am creating a Django application, and every table is related to some other table via a foreign key. Sometimes this relation is to the "User" table, and sometimes this relation is to a table that has a relation to the "User" table. We don't have any tables that aren't somehow associated to the "User" table. We have quite a few tables, so this means that, to my understanding, all of our tables need to be in a single set. From what I understand, this can cause deadlocking issues, and I'd obviously rather avoid that. What can I do to better group my sets? -- Adam Olsen SendOutCards.com http://www.vimtips.org http://last.fm/user/synic _______________________________________________ Slony1-general mailing list Slony1-general at lists.slony.info http://lists.slony.info/mailman/listinfo/slony1-general
- Previous message: [Slony1-general] Help with grouping sets
- Next message: [Slony1-general] Help with grouping sets
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ]
More information about the Slony1-general mailing list