Dspace: Postgres vs. Oracle

News group gmane.comp.db.dspace.user

Dspace: Postgres vs. Oracle 2010-07-27 14:54
------=_NextPart_000_0043_01CB2D93.29905B80
Content-Type: multipart/mixed;
boundary="----=_NextPart_001_0044_01CB2D93.299EB360"


------=_NextPart_001_0044_01CB2D93.299EB360
Content-Type: multipart/alternative;
boundary="----=_NextPart_002_0045_01CB2D93.299EB360"


------=_NextPart_002_0045_01CB2D93.299EB360
Content-Type: text/plain;
charset="us-ascii"
Content-Transfer-Encoding: 7bit

Hi,

Just a general question.

We currently have two Dspace repositories running Postgres and are about to
build another. We are considering using Oracle for the new database.

Can anyone give pros and cons of using Oracle?

Cheers

Kevin


Kevin Evans MA
Web Services Developer,
Integration and Webservices,
Room 901,
9th Floor, Laver Building,
University of Exeter
North Park Road,
Exeter,
EX4 4RN
01392 725573
07775027574
http://my.exeter.ac.uk <http://my.exeter.ac.uk/>

This email and any attachment may contain information that is confidential,
privileged, or subject to copyright, and which may be exempt from disclosure
under applicable legislation. It is intended for the addressee only. If you
received this message in error, please let me know and delete the email and
any attachments immediately. The University will not accept responsibility
for the accuracy/completeness of this e-mail and its attachments. The
University cannot guarantee that this message and any attachments are virus
free. Any views or opinions expressed in this message are my own and do not
necessarily represent those of the University....don't waste your life
reading this trash and get out and live.


------=_NextPart_002_0045_01CB2D93.299EB360
Content-Type: text/html;
charset="us-ascii"
Content-Transfer-Encoding: quoted-printable

<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML><HEAD>
<META content=3D"text/html; charset=3Dus-ascii" =
http-equiv=3DContent-Type>
<META name=3DGENERATOR content=3D"MSHTML 8.00.6001.18928"></HEAD>
<BODY>
<DIV><FONT color=3D#000080 size=3D2 face=3DArial><SPAN=20
class=3D694224112-27072010>Hi,</SPAN></FONT></DIV>
<DIV><FONT color=3D#000080 size=3D2 face=3DArial><SPAN=20
class=3D694224112-27072010></SPAN></FONT>&nbsp;</DIV>
<DIV><FONT color=3D#000080 size=3D2 face=3DArial><SPAN =
class=3D694224112-27072010>Just a=20
general question.</SPAN></FONT></DIV>
<DIV><FONT color=3D#000080 size=3D2 face=3DArial><SPAN=20
class=3D694224112-27072010></SPAN></FONT>&nbsp;</DIV>
<DIV><FONT color=3D#000080 size=3D2 face=3DArial><SPAN =
class=3D694224112-27072010>We=20
currently have two Dspace repositories running Postgres and are about to =
build=20
another. We are considering using Oracle for the new database.=20
</SPAN></FONT></DIV>
<DIV><FONT color=3D#000080 size=3D2 face=3DArial><SPAN=20
class=3D694224112-27072010></SPAN></FONT>&nbsp;</DIV>
<DIV><FONT color=3D#000080 size=3D2 face=3DArial><SPAN =
class=3D694224112-27072010>Can=20
anyone give pros and cons of using Oracle?</SPAN></FONT></DIV>
<DIV><FONT color=3D#000080 size=3D2 face=3DArial><SPAN=20
class=3D694224112-27072010></SPAN></FONT>&nbsp;</DIV>
<DIV><FONT color=3D#000080 size=3D2 face=3DArial>Cheers</FONT></DIV>
<DIV align=3Dleft><FONT color=3D#000080 size=3D2 =
face=3DArial></FONT>&nbsp;</DIV>
<DIV align=3Dleft><FONT color=3D#000080 size=3D2 =
face=3DArial>Kevin</FONT></DIV>
<DIV align=3Dleft><FONT color=3D#808080 size=3D2 =
face=3DVerdana></FONT>&nbsp;</DIV>
<DIV align=3Dleft><FONT color=3D#808080 size=3D2 =
face=3DVerdana></FONT>&nbsp;</DIV>
<DIV align=3Dleft><FONT color=3D#808080 size=3D2 face=3DVerdana>Kevin =
Evans=20
MA</FONT></DIV>
<DIV align=3Dleft><FONT color=3D#808080 size=3D2 face=3DVerdana>Web =
Services=20
Developer,<BR>Integration and Webservices,<BR>Room 901,<BR>9th Floor, =
Laver=20
Building,<BR>University of Exeter<BR>North Park Road,<BR>Exeter,<BR>EX4=20
4RN</FONT></DIV>
<DIV align=3Dleft><FONT color=3D#808080 size=3D2 face=3DVerdana>01392=20
725573</FONT></DIV>
<DIV align=3Dleft><FONT color=3D#808080 size=3D2 =
face=3DVerdana>07775027574</FONT></DIV>
<DIV align=3Dleft><FONT color=3D#808080 size=3D2 face=3DVerdana><A=20
href=3D"http://my.exeter.ac.uk/">http://my.exeter.ac.uk</A></FONT></DIV>
<DIV align=3Dleft><SPAN=20
style=3D"FONT-FAMILY: Verdana; COLOR: gray; FONT-SIZE: 10pt; =
mso-fareast-font-family: 'Times New Roman'; mso-bidi-font-family: 'Times =
New Roman'; mso-ansi-language: EN-GB; mso-fareast-language: EN-GB; =
mso-bidi-language: AR-SA"><STRONG></STRONG></SPAN>&nbsp;</DIV>
<DIV align=3Dleft>
<DIV align=3Dleft><SPAN=20
style=3D"FONT-FAMILY: Verdana; COLOR: gray; FONT-SIZE: 10pt; =
mso-fareast-font-family: 'Times New Roman'; mso-bidi-font-family: 'Times =
New Roman'; mso-ansi-language: EN-GB; mso-fareast-language: EN-GB; =
mso-bidi-language: AR-SA"><SPAN=20
style=3D"FONT-FAMILY: Verdana; COLOR: gray; FONT-SIZE: 7.5pt" =
lang=3DEN-US>This=20
email and any attachment may contain information that is confidential,=20
privileged, or subject to copyright, and which may be exempt from =
disclosure=20
under applicable legislation. It is intended for the addressee only. If =
you=20
received this message in error, please let me know and delete the email =
and any=20
attachments immediately. The University will not accept responsibility =
for the=20
accuracy/completeness of this e-mail and its attachments. The University =
cannot=20
guarantee that this message and any attachments are virus free. Any =
views or=20
opinions expressed in this message are my own and do not necessarily =
represent=20
those of the University....don't waste your life reading this trash and =
get out=20
and live.</SPAN></SPAN></DIV></DIV>
<DIV><FONT color=3D#000080 size=3D2 =
face=3DArial></FONT>&nbsp;</DIV></BODY></HTML>

------=_NextPart_002_0045_01CB2D93.299EB360--

------=_NextPart_001_0044_01CB2D93.299EB360
Content-Type: text/x-vcard;
name="Evans, Kevin.vcf"
Content-Transfer-Encoding: 7bit
Content-Disposition: attachment;
filename="Evans, Kevin.vcf"

BEGIN:VCARD
VERSION:2.1
N:Evans;Kevin
FN:Evans, Kevin
ORG:;Academic Services
TEL;WORK;VOICE:3946
ADR;WORK:;Academic Services
LABEL;WORK:Academic Services
REV:20071120T120541Z
END:VCARD

------=_NextPart_001_0044_01CB2D93.299EB360--

------=_NextPart_000_0043_01CB2D93.29905B80
Content-Type: application/x-pkcs7-signature; name="smime.p7s"
Content-Transfer-Encoding: base64
Content-Disposition: attachment; filename="smime.p7s"

MIAGCSqGSIb3DQEHAqCAMIACAQExCzAJBgUrDgMCGgUAMIAGCSqGSIb3DQEHAQAAoIIPUTCCBDIw
ggMaoAMCAQICAQEwDQYJKoZIhvcNAQEFBQAwezELMAkGA1UEBhMCR0IxGzAZBgNVBAgMEkdyZWF0
ZXIgTWFuY2hlc3RlcjEQMA4GA1UEBwwHU2FsZm9yZDEaMBgGA1UECgwRQ29tb2RvIENBIExpbWl0
ZWQxITAfBgNVBAMMGEFBQSBDZXJ0aWZpY2F0ZSBTZXJ2aWNlczAeFw0wNDAxMDEwMDAwMDBaFw0y
ODEyMzEyMzU5NTlaMHsxCzAJBgNVBAYTAkdCMRswGQYDVQQIDBJHcmVhdGVyIE1hbmNoZXN0ZXIx
EDAOBgNVBAcMB1NhbGZvcmQxGjAYBgNVBAoMEUNvbW9kbyBDQSBMaW1pdGVkMSEwHwYDVQQDDBhB
QUEgQ2VydGlmaWNhdGUgU2VydmljZXMwggEiMA0GCSqGSIb3DQEBAQUAA4IBDwAwggEKAoIBAQC+
QJ30buHqdoccTUVEjr5GyIMGncEq/hgfjuQC+vOrXVCKFjELmgbQxXAizUktVGPMtm5oRgtT6stM
JMC8ck7q8RWu9FSaEgrDerIzYOLaiVXzIljz3tzP74OGooyUT59o8piQRoQnx3a/48w1LIteB2Rl
gsBIsKiR+WGfdiBQqJHHZrXreGIDVvCKGhPqMaMeoJn9OPb2JzJYbwf1a7j7FCuvt6rM1mNfc4za
BZmoOKjLF3g2UazpnvR4Oo3PD9lC4pgMqy+fDgHe75+ZSfEt36x0TRuYtUfF5SnR+ZAYx2KcvoPH
Jns+iiXHwN2d5jVoECCdj9je0sOEnA1e6C/JAgMBAAGjgcAwgb0wHQYDVR0OBBYEFKARCiM+lvEH
7OKvKe+CpX/QMKS0MA4GA1UdDwEB/wQEAwIBBjAPBgNVHRMBAf8EBTADAQH/MHsGA1UdHwR0MHIw
OKA2oDSGMmh0dHA6Ly9jcmwuY29tb2RvY2EuY29tL0FBQUNlcnRpZmljYXRlU2VydmljZXMuY3Js
MDagNKAyhjBodHRwOi8vY3JsLmNvbW9kby5uZXQvQUFBQ2VydGlmaWNhdGVTZXJ2aWNlcy5jcmww
DQYJKoZIhvcNAQEFBQADggEBAAhW/ALwm+j/pPrWe8ZEgM5PxMX2AFjMpra8FEloBHbo5u5d7AIP
YNaNUBhPJk4B4+awpe6/vHRUQb/9/BK4x09a9IlgBX9gtwVK8/bxwr/EuXSGti19a8zS80bdL8bg
asPDNAMsfZbdWsIOpwqZwQWLqwwv81w6z2w3VQmH3lNAbFjv/LarZW4E9hvcPOBaFcae2fFZSDAh
ZQNs7Okhc+ybA6HgN62gFRiP+roCzqcsqRATLNTlCCarIpdg+JBedNSimlO98qlo4KJuwtdssaMP
nr/raOdW8q7y4ys4OgmBtWuF174t7T8at7Jj4vViLILUagBBUPE5g5+V6TaWmG4wggTdMIIDxaAD
AgECAhBxkvvmGV+sTRKFdHE0ohinMA0GCSqGSIb3DQEBBQUAMHsxCzAJBgNVBAYTAkdCMRswGQYD
VQQIDBJHcmVhdGVyIE1hbmNoZXN0ZXIxEDAOBgNVBAcMB1NhbGZvcmQxGjAYBgNVBAoMEUNvbW9k
byBDQSBMaW1pdGVkMSEwHwYDVQQDDBhBQUEgQ2VydGlmaWNhdGUgU2VydmljZXMwHhcNMDQwMTAx
MDAwMDAwWhcNMjgxMjMxMjM1OTU5WjCBrjELMAkGA1UEBhMCVVMxCzAJBgNVBAgTAlVUMRcwFQYD
VQQHEw5TYWx0IExha2UgQ2l0eTEeMBwGA1UEChMVVGhlIFVTRVJUUlVTVCBOZXR3b3JrMSEwHwYD
VQQLExhodHRwOi8vd3d3LnVzZXJ0cnVzdC5jb20xNjA0BgNVBAMTLVVUTi1VU0VSRmlyc3QtQ2xp
ZW50IEF1dGhlbnRpY2F0aW9uIGFuZCBFbWFpbDCCASIwDQYJKoZIhvcNAQEBBQADggEPADCCAQoC
ggEBALI5haTyfatBO2JGN67NwWB1vDll+UoaR6K5zEjMapjVTTUZuaRC5c5J4oovHnzSMQfHTrSD
ZJ0uKdWiZMSFvYVRNXmkTmiQexx6pJKoF/KYFfKTzMmkMpW7DE8wvZigC4vlbhuiRvp4vKJvq1le
pS/Pytptqi/rrKGzaqq3Lmc1i3nhHmmI4uZGzaCl6r4LznY6eg6b6vzaJ1s9cx8i5khhxkzzabGo
Lhu21DEgLLyCio6kDqXXiUP8FlqvHXHXEVnauocNr/rz4cLwpMVnjNbWVDreCqS6A3ezZcj9HtN0
YqoYymiTHqGFfvVHZcv4TVcodNI0/zC27vZiMBSMLOsCAwEAAaOCAScwggEjMB8GA1UdIwQYMBaA
FKARCiM+lvEH7OKvKe+CpX/QMKS0MB0GA1UdDgQWBBSJgmd9xJ0mcABLtFBIfN49rgRufTAOBgNV
HQ8BAf8EBAMCAQYwDwYDVR0TAQH/BAUwAwEB/zAdBgNVHSUEFjAUBggrBgEFBQcDAgYIKwYBBQUH
AwQwEQYDVR0gBAowCDAGBgRVHSAAMHsGA1UdHwR0MHIwOKA2oDSGMmh0dHA6Ly9jcmwuY29tb2Rv
Y2EuY29tL0FBQUNlcnRpZmljYXRlU2VydmljZXMuY3JsMDagNKAyhjBodHRwOi8vY3JsLmNvbW9k
by5uZXQvQUFBQ2VydGlmaWNhdGVTZXJ2aWNlcy5jcmwwEQYJYIZIAYb4QgEBBAQDAgEGMA0GCSqG
SIb3DQEBBQUAA4IBAQCdlcs8uH6lCcQevwvCx3aOOTyUxhCqTwzJ4KuEXYlU4GU7820cfDcsJVRf
liH8N4SRnRXcFE+Bz1Qda2xFYMct+ZdRTPlmyjyggoymyPDi6dRK+ew/VsnddozDggFPbADzHhph
dARHA6nGQFeRvGUixSdnT1fbZFrZjR+6hi/0Bq6cae3p9M8pF9jgSp8aIC+XTFG7RgfEijdOIOMJ
MWjHnsSLneh+EbwyaBCWEZhE2CpRYE2I63Q630MGMsg5Vow6EVLTQaRDA/Tt7zMn2zngFE4mydj1
OeKJuJNdtykmQeqzm66D/Hd1yujKtf7iZUpjPkTE0MNeh3OpmByvfxV/MIIGNjCCBR6gAwIBAgIR
APwvcKjFYpoxkRHxEkKmmZEwDQYJKoZIhvcNAQEFBQAwga4xCzAJBgNVBAYTAlVTMQswCQYDVQQI
EwJVVDEXMBUGA1UEBxMOU2FsdCBMYWtlIENpdHkxHjAcBgNVBAoTFVRoZSBVU0VSVFJVU1QgTmV0
d29yazEhMB8GA1UECxMYaHR0cDovL3d3dy51c2VydHJ1c3QuY29tMTYwNAYDVQQDEy1VVE4tVVNF
UkZpcnN0LUNsaWVudCBBdXRoZW50aWNhdGlvbiBhbmQgRW1haWwwHhcNMTAwNDE0MDAwMDAwWhcN
MTEwNDE0MjM1OTU5WjCB3zE1MDMGA1UECxMsQ29tb2RvIFRydXN0IE5ldHdvcmsgLSBQRVJTT05B
IE5PVCBWQUxJREFURUQxRjBEBgNVBAsTPVRlcm1zIGFuZCBDb25kaXRpb25zIG9mIHVzZTogaHR0
cDovL3d3dy5jb21vZG8ubmV0L3JlcG9zaXRvcnkxHzAdBgNVBAsTFihjKTIwMDMgQ29tb2RvIExp
bWl0ZWQxFDASBgNVBAMTC0tldmluIEV2YW5zMScwJQYJKoZIhvcNAQkBFhhrZXZpbi5ldmFuc0Bl
eGV0ZXIuYWMudWswggEiMA0GCSqGSIb3DQEBAQUAA4IBDwAwggEKAoIBAQDEWUJhVnnrifGQlvNE
fBl8wpwOVWCs5NMGPU/7xejEbjAPoMjufYYnNn7R6mOZo6wkNGBKpqvx0GomuOcBBAjMSILtq8ji
uz35xu+99taFf2hodrWsFwKARvZdP3M9Y8++KuakFVlCFZwkd/MCN9pbyQkgJlhI1iSaWoobc3g1
EUI5+UNnP96M3ytOrtwKbWILPdpBrACpFFtfKUq9gidd421S8XZI6t/9luV2C7BTexmEody0+CAQ
9AeYQl+6/1d9+qa+Jir5gnocpGB4T5kK+GxMNTqcK/Zb3g1o7vgaQzzqDgOYnYJ/t0rv1uWxB62Y
rnITPtdiL+LFTHztEc0JAgMBAAGjggIaMIICFjAfBgNVHSMEGDAWgBSJgmd9xJ0mcABLtFBIfN49
rgRufTAdBgNVHQ4EFgQUFXC7DCf2JxYJ0PV0razxzc4QFYowDgYDVR0PAQH/BAQDAgWgMAwGA1Ud
EwEB/wQCMAAwIAYDVR0lBBkwFwYIKwYBBQUHAwQGCysGAQQBsjEBAwUCMBEGCWCGSAGG+EIBAQQE
AwIFIDBGBgNVHSAEPzA9MDsGDCsGAQQBsjEBAgEBATArMCkGCCsGAQUFBwIBFh1odHRwczovL3Nl
Y3VyZS5jb21vZG8ubmV0L0NQUzCBpQYDVR0fBIGdMIGaMEygSqBIhkZodHRwOi8vY3JsLmNvbW9k
b2NhLmNvbS9VVE4tVVNFUkZpcnN0LUNsaWVudEF1dGhlbnRpY2F0aW9uYW5kRW1haWwuY3JsMEqg
SKBGhkRodHRwOi8vY3JsLmNvbW9kby5uZXQvVVROLVVTRVJGaXJzdC1DbGllbnRBdXRoZW50aWNh
dGlvbmFuZEVtYWlsLmNybDBsBggrBgEFBQcBAQRgMF4wNgYIKwYBBQUHMAKGKmh0dHA6Ly9jcnQu
Y29tb2RvY2EuY29tL1VUTkFBQUNsaWVudENBLmNydDAkBggrBgEFBQcwAYYYaHR0cDovL29jc3Au
Y29tb2RvY2EuY29tMCMGA1UdEQQcMBqBGGtldmluLmV2YW5zQGV4ZXRlci5hYy51azANBgkqhkiG
9w0BAQUFAAOCAQEAXwnfvMp6gIAtVrNPJH3HesY81niOg0O+IafVXM4wqz/Kp/8TnQaqa99T1yKs
VLYs/PGVcBSK0S7sAZQzTJm6bBLBwi9kABjHduK5heJOSwrJyt1wLBi/IsEo5PQedKjM5Kz1TgXN
0D+QCTv7HNqNy/hcIC1PEvs/Ymb21HS9vTI2xnmUtgmG879LDlnH5PSvth/MnzwZkFwZzZOdL5Dk
Q6SP8zcx602bRxdzvOsL2z0J8+g62Y0vkSpsWQsEXvspjjJfCPGL44/T1K4rSSqjVga/fseaZKo5
Sm97Li+/pK+6ERUhsxvMcve5AX8cumqM8Zd0+OdUbGQg0FVL8CxkETGCBGgwggRkAgEBMIHEMIGu
MQswCQYDVQQGEwJVUzELMAkGA1UECBMCVVQxFzAVBgNVBAcTDlNhbHQgTGFrZSBDaXR5MR4wHAYD
VQQKExVUaGUgVVNFUlRSVVNUIE5ldHdvcmsxITAfBgNVBAsTGGh0dHA6Ly93d3cudXNlcnRydXN0
LmNvbTE2MDQGA1UEAxMtVVROLVVTRVJGaXJzdC1DbGllbnQgQXV0aGVudGljYXRpb24gYW5kIEVt
YWlsAhEA/C9wqMVimjGREfESQqaZkTAJBgUrDgMCGgUAoIICeDAYBgkqhkiG9w0BCQMxCwYJKoZI
hvcNAQcBMBwGCSqGSIb3DQEJBTEPFw0xMDA3MjcxMjUzNThaMCMGCSqGSIb3DQEJBDEWBBSQE0u1
s3X4x1ilZvuA9yOmlOt0xTBnBgkqhkiG9w0BCQ8xWjBYMAoGCCqGSIb3DQMHMA4GCCqGSIb3DQMC
AgIAgDANBggqhkiG9w0DAgIBQDAHBgUrDgMCBzANBggqhkiG9w0DAgIBKDAHBgUrDgMCGjAKBggq
hkiG9w0CBTCB1QYJKwYBBAGCNxAEMYHHMIHEMIGuMQswCQYDVQQGEwJVUzELMAkGA1UECBMCVVQx
FzAVBgNVBAcTDlNhbHQgTGFrZSBDaXR5MR4wHAYDVQQKExVUaGUgVVNFUlRSVVNUIE5ldHdvcmsx
ITAfBgNVBAsTGGh0dHA6Ly93d3cudXNlcnRydXN0LmNvbTE2MDQGA1UEAxMtVVROLVVTRVJGaXJz
dC1DbGllbnQgQXV0aGVudGljYXRpb24gYW5kIEVtYWlsAhEA/C9wqMVimjGREfESQqaZkTCB1wYL
KoZIhvcNAQkQAgsxgceggcQwga4xCzAJBgNVBAYTAlVTMQswCQYDVQQIEwJVVDEXMBUGA1UEBxMO
U2FsdCBMYWtlIENpdHkxHjAcBgNVBAoTFVRoZSBVU0VSVFJVU1QgTmV0d29yazEhMB8GA1UECxMY
aHR0cDovL3d3dy51c2VydHJ1c3QuY29tMTYwNAYDVQQDEy1VVE4tVVNFUkZpcnN0LUNsaWVudCBB
dXRoZW50aWNhdGlvbiBhbmQgRW1haWwCEQD8L3CoxWKaMZER8RJCppmRMA0GCSqGSIb3DQEBAQUA
BIIBAAmhTRqL2DC49yWCnqtttCZUPYhZ67aWvX+XbJNZYA7qKdgcfAkIgZuOEPAU48n4gMhsgO/B
TPaQC2wfy6BEmXrv1Fj/cToHZehNEWFleBxl6uwczI8uWAqFFA+6nbHM8t9vXktOxEmszBn46qv/
9WLfE4yPsdjjeb7Q/qpijqDckhY/YGyIMEmCxJ5anyySjcprkTiktokpZPbhoRYQQZpaGkE3LhBV
BKJxvtNNiRQISyaVJ7tZlP5pNejALhpI9hjbLqj7zjRyzVj+QUYWID4lE3ayOtxmtko6f3rEQm9s
A2ZrMFKYph2RSuNBKuz7ljXnfVvVaUhV2cJEA4s+e8EAAAAAAAA=

------=_NextPart_000_0043_01CB2D93.29905B80--
Menu
Re: Dspace: Postgres vs. Oracle 2010-07-27 17:05
--Apple-Mail-1--859280782
Content-Transfer-Encoding: quoted-printable
Content-Type: text/plain;
charset=us-ascii

Hi Kevin,

I just finished migrating a Dspace instance away from Oracle, so have run the same Dspace instance under both Postgres and Oracle. I also saw a dramatic speed bump after running under Postgres, but the hardware was newer, so cannot be completely certain it was just due to the migration.

I felt (as do many fortune 500 companies, from my research) that Postgres is a better solution for medium and small sized databases. My three main reasons for migrating were:

1) price
2) footprint / speed
3) ease of administration

Oracle really shines when your datasets are so large, or used so heavily, that your database is hosted over multiple boxes. Another reason for using Oracle, is if you already have Oracle in place for other projects, and don't want to host both Postgres AND Oracle.

Having said that, properly admin'ing Oracle requires a great deal more knowledge than admin'ing Postgres. It is very common (and a quick search on Google verifies this) for an entire team of DBAs to be needed to host Oracle in the same manner that Postgres can be admin'ed by one DBA.

Also, the data stored in the database for Dspace is mostly metadata, not the actual archived files, which are stored on disk. Oracle cannot be justified for data set used by Dspace. One Postgres instance is likely to handle anything a typical Dspace app can throw at it.

Finally, Oracle has a much larger footprint than Postgres. Honestly, Oracle is a resource hog. If you migrate to Oracle, isolate it on its own box, and I suggest making that a pretty beefy box, also.

Hope that helps.

Best regards,

Terrance Davis
Re: Dspace: Postgres vs. Oracle 2010-07-27 15:46
--_000_4599B203DF7C49BE996E4FBC7EADA891mitedu_
Content-Type: text/plain; charset="us-ascii"
Content-Transfer-Encoding: quoted-printable

It's my (perhaps skewed?) perception that there is a much larger number of Postgres DSpace installs out there, thus it is the more heavily tested option.

Also, all things being equal, isn't it far more expensive to run an Oracle instance, vs. the free Postgres license?  You would also be diversifying your administration skills having multiple types of databases, which I never see as a good thing.

Dspace: Postgres vs. Oracle 2010-07-27 14:54
Re: Dspace: Postgres vs. Oracle 2010-07-27 17:05
Re: Dspace: Postgres vs. Oracle 2010-07-27 15:46