On Monday 21 September 2009, Christian Koetschan <c.koetschan@xxxxxxxxxxxxxxxxxxxxxxxxxxx> wrote: > Is everything I insert into mycolA and mycolB stored twice, or > is there something like a pointer/reference from mycolA to the things > stored in mycolB? > It's stored twice and for performance you need to index it in both tables. If you put ON UPDATE CASCADE on it, an update to the master will hit both tables though. -- "No animals were harmed in the recording of this episode. We tried but that damn monkey was just too fast." -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
