Tue Aug 19 10:00:25 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 ]
The issues described in section 7.2 here: http://slony.info/documentation/definingsets.html The most concerning one is the one regarding "EXECUTE SCRIPT", as, in the beginning our schema might change somewhat frequently. Adam On Tue, Aug 19, 2008 at 10:56 AM, Shahaf Abileah <shahaf at redfin.com> wrote: > 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 > > > -- Adam Olsen SendOutCards.com http://www.vimtips.org http://last.fm/user/synic
- 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