On Thu, 2005-04-28 at 14:54, Joshua D. Drake wrote: > Karsten Hilbert wrote: > > On Thu, Apr 28, 2005 at 11:59:59AM -0700, Patrick Haugen wrote: > > > > > >>Pseudo code: > >>When databse xyz table companyname is updated update the same table > >>and rows in database abc; > > > > ... > > > >>What is a good clustering technique for PostgreSQL? > > > > > > Slony-I. > > Slony-I isn't clustering. They would have to look at pgCluster or > something like that. True. But the description of what the OP wanted to do, slony sounded like what he was after. ---------------------------(end of broadcast)--------------------------- TIP 9: the planner will ignore your desire to choose an index scan if your joining column's datatypes do not match