Re: Parameters for PostgreSQL - Mailing list pgsql-performance

From Jayadevan M
Subject Re: Parameters for PostgreSQL
Date
Msg-id OFB5D52348.1A6D34E9-ON652578E2.00137B30-652578E2.001450FD@ibsplc.com
Whole thread Raw
In response to Re: Parameters for PostgreSQL  (Craig Ringer <craig@postnewspapers.com.au>)
Responses Re: Parameters for PostgreSQL  (Craig Ringer <ringerc@ringerc.id.au>)
Re: Parameters for PostgreSQL  (Craig Ringer <craig@postnewspapers.com.au>)
List pgsql-performance
Hello,

>The most important spec has been omitted. What's the storage subsystem?

We have storage on SAN, RAID 5.
 
> > We are suing weblogic.
>           ^^^^^
> Best. Typo. Ever.
>
> I hear most people who use it want to, you're just brave enough to do it :-P
I wish I could make a few millions that way.



Thank you for all the replies. The first step is, of course, to migrate the data. I am working with ora2pg for that. I assume creating files with 'COPY' to work as input for PostgreSQL is the right approach? We don't have many stored procedures or packages. So that part should be OK.





DISCLAIMER:


"The information in this e-mail and any attachment is intended only for the person to whom it is addressed and may contain confidential and/or privileged material. If you have received this e-mail in error, kindly contact the sender and destroy all copies of the original communication. IBS makes no warranty, express or implied, nor guarantees the accuracy, adequacy or completeness of the information contained in this email or any attachment and is not liable for any errors, defects, omissions, viruses or for resultant loss or damage, if any, direct or indirect."





pgsql-performance by date:

Previous
From: Robert Klemme
Date:
Subject: Re: Performance penalty when using WITH
Next
From: Adarsh Sharma
Date:
Subject: Need to tune for Heavy Write