On Thu, Jul 14, 2005 at 11:18:30AM +1000, Tim Allen wrote: > Others have given you some of the advice I would have given. One more > suggestion - does your database fit in just one "schema" in the gnumed > database? It would, for the time being, "size-wise". However, we have conceptually separated the data into parts, eg clinical data, demographic data, reference data, BLOB data. Karsten -- GPG key ID E4071346 @ wwwkeys.pgp.net E167 67FD A291 2BEA 73BD 4537 78B9 A9F9 E407 1346 ---------------------------(end of broadcast)--------------------------- TIP 9: In versions below 8.0, the planner will ignore your desire to choose an index scan if your joining column's datatypes do not match