Re: Parameters for PostgreSQL

From: Jayadevan M <Jayadevan(dot)Maymala(at)ibsplc(dot)com>
To: Craig Ringer <craig(at)postnewspapers(dot)com(dot)au>, Merlin Moncure <mmoncure(at)gmail(dot)com>
Cc: pgsql-performance(at)postgresql(dot)org
Subject: Re: Parameters for PostgreSQL
Date: 2011-08-04 03:42:28
Message-ID: OFB5D52348.1A6D34E9-ON652578E2.00137B30-652578E2.001450FD@ibsplc.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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."

In response to

Responses

Browse pgsql-performance by date

  From Date Subject
Next Message Craig Ringer 2011-08-04 03:54:48 Re: Parameters for PostgreSQL
Previous Message Clem Dickey 2011-08-04 01:53:19 Re: Re: GROUP BY with reasonable timings in PLAN but unreasonable execution time