Shahaf Abileah shahaf at redfin.com
Tue Aug 19 09:56:51 PDT 2008
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




More information about the Slony1-general mailing list