X-Original-To: pgsql-admin-postgresql.org@localhost.postgresql.org Received: from localhost (mx2.hub.org [200.46.204.254]) by postgresql.org (Postfix) with ESMTP id AE6CD11F6B74 for ; Mon, 17 Apr 2006 07:00:34 -0300 (ADT) X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Score: -2.599 X-Spam-Level: X-Spam-Status: No, score=-2.599 required=5 tests=[BAYES_00=-2.599] Received: from postgresql.org ([200.46.204.71]) by localhost (mx2.hub.org [200.46.204.254]) (amavisd-new, port 10024) with ESMTP id 32aY9XgCEqJo for ; Mon, 17 Apr 2006 07:00:32 -0300 (ADT) X-Greylist: from auto-whitelisted by SQLgrey- Received: from mail.pharmaline.de (mail.pharmaline.de [62.153.135.34]) by postgresql.org (Postfix) with ESMTP id D6D9A11F6974 for ; Mon, 17 Apr 2006 07:00:23 -0300 (ADT) Received: from [192.168.0.5] (84.60.176.224) by mail.pharmaline.de with ESMTP (Eudora Internet Mail Server 3.2.7); Mon, 17 Apr 2006 12:00:23 +0200 In-Reply-To: <20060417031801.GA37181@winnie.fuhr.org> References: <20060417024259.12090.qmail@mail.unika.ac.id> <20060417031801.GA37181@winnie.fuhr.org> Mime-Version: 1.0 (Apple Message framework v746.3) Content-Type: multipart/signed; micalg=sha1; boundary=Apple-Mail-5--542896345; protocol="application/pkcs7-signature" Message-Id: Cc: slackman@unika.ac.id, pgsql-admin@postgresql.org From: Guido Neitzer Subject: Re: which is the best Date: Mon, 17 Apr 2006 12:00:27 +0200 To: Michael Fuhr X-Mailer: Apple Mail (2.746.3) X-Archive-Number: 200604/140 X-Sequence-Number: 21309 --Apple-Mail-5--542896345 Content-Transfer-Encoding: 7bit Content-Type: text/plain; charset=US-ASCII; delsp=yes; format=flowed On 17.04.2006, at 5:18 Uhr, Michael Fuhr wrote: > Which way is "better" depends on your access patterns. PostgreSQL > doesn't support cross-database queries (except via functions like > dblink), so if you need to join tables in one database with tables > in another then you'll probably want make A, B, and C schemas in > the same database. But if A, B, and C have no relationship with > one another then you might want to isolate them as separate databases. This is also dependant on the tool you use for accessing the databases. E.g. Apple WebObjects has no problems in working with relationships over severals databases, even if these databases are from different vendors. I have an application running, that joins information from a PostgreSQL, a FrontBase and an Oracle db in one "fetch" without any special voodoo going on on the database side. Only thing to have is that primary and foreign keys are in a compatible format. I think this question can't be answered correctly without specific knowledge about the whole environment. cug -- PharmaLine, Essen, GERMANY Software and Database Development --Apple-Mail-5--542896345 Content-Transfer-Encoding: base64 Content-Type: application/pkcs7-signature; name=smime.p7s Content-Disposition: attachment; filename=smime.p7s MIAGCSqGSIb3DQEHAqCAMIACAQExCzAJBgUrDgMCGgUAMIAGCSqGSIb3DQEHAQAAoIIGNzCCAvAw ggJZoAMCAQICEB7tpxCHG7VYey3bP/Ou4e8wDQYJKoZIhvcNAQEEBQAwYjELMAkGA1UEBhMCWkEx JTAjBgNVBAoTHFRoYXd0ZSBDb25zdWx0aW5nIChQdHkpIEx0ZC4xLDAqBgNVBAMTI1RoYXd0ZSBQ ZXJzb25hbCBGcmVlbWFpbCBJc3N1aW5nIENBMB4XDTA2MDIxMTE3NDM1NFoXDTA3MDIxMTE3NDM1 NFowTTEfMB0GA1UEAxMWVGhhd3RlIEZyZWVtYWlsIE1lbWJlcjEqMCgGCSqGSIb3DQEJARYbZ3Vp ZG8ubmVpdHplckBwaGFybWFsaW5lLmRlMIIBIjANBgkqhkiG9w0BAQEFAAOCAQ8AMIIBCgKCAQEA yLhNUnNv30/r+pFUHocoIWGm8AAwFbwAWqFRhEwZzxLPCMSZme3G7W/5hyK+SxeQoOK8PPCsNyvy sLBqUVHB3nm5w/NzZKk1gfc2QlzjPtv2C7bUnigDJs+X0YlgdxTxs68RdHBn/rbjjaxl+SkiEcsz kZhKsAnS6zhlWSX7zDCIRR5VD08M0/fYSTwEcX1j8lWb/3McY7bCcHbLd+762QQAn03A4cPco4OK 3KAMld0n6qFFMG23IKx7qDTonYtCzsDVspQ1Fk14yJYVdf62RLWGBJPF+RMXB9juFhgdUrHZY3mo wamFF3qZ8HD9wb+G7lhL8F+d5khDuLBYFXCqdQIDAQABozgwNjAmBgNVHREEHzAdgRtndWlkby5u ZWl0emVyQHBoYXJtYWxpbmUuZGUwDAYDVR0TAQH/BAIwADANBgkqhkiG9w0BAQQFAAOBgQCFnjZk bGIY3sGlsEIn98cV+tX9xNTThIwN6jhu7mGuxzvX+hN86kdlhEgaPmaatH8KfXXyfnhpTK3KOk8O zDsxJqQDVe1HEW8M/4MkORMlydbcxSRPL967pgMRNjAMafL/IlssFJ3kF7q/2AjRd4VhnyoA3Yl/ sXF3WLOTJB5OzjCCAz8wggKooAMCAQICAQ0wDQYJKoZIhvcNAQEFBQAwgdExCzAJBgNVBAYTAlpB MRUwEwYDVQQIEwxXZXN0ZXJuIENhcGUxEjAQBgNVBAcTCUNhcGUgVG93bjEaMBgGA1UEChMRVGhh d3RlIENvbnN1bHRpbmcxKDAmBgNVBAsTH0NlcnRpZmljYXRpb24gU2VydmljZXMgRGl2aXNpb24x JDAiBgNVBAMTG1RoYXd0ZSBQZXJzb25hbCBGcmVlbWFpbCBDQTErMCkGCSqGSIb3DQEJARYccGVy c29uYWwtZnJlZW1haWxAdGhhd3RlLmNvbTAeFw0wMzA3MTcwMDAwMDBaFw0xMzA3MTYyMzU5NTla MGIxCzAJBgNVBAYTAlpBMSUwIwYDVQQKExxUaGF3dGUgQ29uc3VsdGluZyAoUHR5KSBMdGQuMSww KgYDVQQDEyNUaGF3dGUgUGVyc29uYWwgRnJlZW1haWwgSXNzdWluZyBDQTCBnzANBgkqhkiG9w0B AQEFAAOBjQAwgYkCgYEAxKY8VXNV+065yplaHmjAdQRwnd/p/6Me7L3N9VvyGna9fww6YfK/Uc4B 1OVQCjDXAmNaLIkVcI7dyfArhVqqP3FWy688Cwfn8R+RNiQqE88r1fOCdz0Dviv+uxg+B79AgAJk 16emu59l0cUqVIUPSAR/p7bRPGEEQB5kGXJgt/sCAwEAAaOBlDCBkTASBgNVHRMBAf8ECDAGAQH/ AgEAMEMGA1UdHwQ8MDowOKA2oDSGMmh0dHA6Ly9jcmwudGhhd3RlLmNvbS9UaGF3dGVQZXJzb25h bEZyZWVtYWlsQ0EuY3JsMAsGA1UdDwQEAwIBBjApBgNVHREEIjAgpB4wHDEaMBgGA1UEAxMRUHJp dmF0ZUxhYmVsMi0xMzgwDQYJKoZIhvcNAQEFBQADgYEASIzRUIPqCy7MDaNmrGcPf6+svsIXoUOW lJ1/TCG4+DYfqi2fNi/A9BxQIJNwPP2t4WFiw9k6GX6EsZkbAMUaC4J0niVQlGLH2ydxVyWN3amc OY6MIE9lX5Xa9/eH1sYITq726jTlEBpbNU1341YheILcIRk13iSx0x1G/11fZU8xggMQMIIDDAIB ATB2MGIxCzAJBgNVBAYTAlpBMSUwIwYDVQQKExxUaGF3dGUgQ29uc3VsdGluZyAoUHR5KSBMdGQu MSwwKgYDVQQDEyNUaGF3dGUgUGVyc29uYWwgRnJlZW1haWwgSXNzdWluZyBDQQIQHu2nEIcbtVh7 Lds/867h7zAJBgUrDgMCGgUAoIIBbzAYBgkqhkiG9w0BCQMxCwYJKoZIhvcNAQcBMBwGCSqGSIb3 DQEJBTEPFw0wNjA0MTcxMDAwMjhaMCMGCSqGSIb3DQEJBDEWBBQQiB6cOjJxZhwIHGdk4nelUtgW vTCBhQYJKwYBBAGCNxAEMXgwdjBiMQswCQYDVQQGEwJaQTElMCMGA1UEChMcVGhhd3RlIENvbnN1 bHRpbmcgKFB0eSkgTHRkLjEsMCoGA1UEAxMjVGhhd3RlIFBlcnNvbmFsIEZyZWVtYWlsIElzc3Vp bmcgQ0ECEB7tpxCHG7VYey3bP/Ou4e8wgYcGCyqGSIb3DQEJEAILMXigdjBiMQswCQYDVQQGEwJa QTElMCMGA1UEChMcVGhhd3RlIENvbnN1bHRpbmcgKFB0eSkgTHRkLjEsMCoGA1UEAxMjVGhhd3Rl IFBlcnNvbmFsIEZyZWVtYWlsIElzc3VpbmcgQ0ECEB7tpxCHG7VYey3bP/Ou4e8wDQYJKoZIhvcN AQEBBQAEggEAmyvF8hdvPGOlYeRAK6tbaaHALSAigmF3V0VtI31lR/3XUilIbp8t52QDharla/yy 4qrNhsVWAS6nfOA6VhzhwVWgtGTEVzeSN0O3FWXK80ai2GSaoUEtpRepLvwFnsOZ8XNnOe7gp35W Bi6TEBwWr8pWmtqTM94zPlYfOkaaYYBKXr+wQvlNREt/Y0SPG3s1bI4ES1BsG6CFbL+aS7GXkIVQ wEVTjZzv370GtosMpNqGcVgC/XLyL3EbsP1QqD/YeGGHcXfUdSn1WNHKsE5l0SYu5lRLABlak495 j0Yf4njv89n5HZpOM23PcQHwawOuQhwdYh8uNL9OciKmaUTmPwAAAAAAAA== --Apple-Mail-5--542896345--