On 12/14/12 12:48 AM, Harvey Rothenberg wrote:
Hi Harvey,
> To All,
>
> I belong to another list and some of the Data-Base Application Admins
are switching their application from an Oracle configuration to a
PostgreSQL data-base engine.
>
> They could use some configuration tips on the best way to install and
configure this engine. On this other list, another admin indicated that
he felt that placing the application data-base upon a RAID 0 solved his
indexing issues and sped up his application's performance. Do you find
this as a real solution and/or are there any tips that you could suggest ?
>
> Can you suggest any general configuration tips that would help in the
performance of the application
The RAID0 idea might help, although it provides no redundancy. You'll
probably find that a lot of the general recommendations for Oracle will
apply to Postgres as well. "SAME" (stripe and mirror everything) will
usually be the ideal. Put the database files (i.e. $PGDATA) and the WAL
(write ahead logs, analogous to Oracle redo logs) on different RAID
groups. If you're archiving WAL (analogous to Oracle archivelog mode),
put that somewhere else.
In my case I have $PGDATA on a RAID10 array, WAL on a RAID 0 (different
controller) and archive goes to an NFS server.
> Are there any installation hints that you can offer to help with the
performance and/or transferring of the data from the Oracle engine to
the PostgreSql engine ?
There are lots of things to tune in $PGDATA/postgresql.conf, and the
out-of-the-box configuration is designed so it will work on a minimally
configured machine; you will want to do some tuning. Google "pgtune" for
a tool that will give you some good starting points.
> Can you recommend any internet resources for either Data-Base engines
for information and tips for configuring and installing these systems ?
> Any assistance or true direction would be appreciated.
http://wiki.postgresql.org is helpful. Also I highly recommend Greg
Smith's book "PostgreSQL 9.0 High Performance", it covers every knob you
could possibly want to turn.
> Let me wish all members of the list and those that reply, a safe and
happy holidays !
Same to you and good luck with the project. At http://ctdbase.org we
dumped Oracle for Postgres two years ago yesterday... no regrets!
Best wishes,
Roy
--
Roy McMorran
Bar Harbor, ME
_______________________________________________
Discuss mailing list
[email protected]
https://lists.lopsa.org/cgi-bin/mailman/listinfo/discuss
This list provided by the League of Professional System Administrators
http://lopsa.org/
