Re: Parameters for PostgreSQL

Поиск
Список
Период
Сортировка
От Jayadevan M
Тема Re: Parameters for PostgreSQL
Дата
Msg-id OFB5D52348.1A6D34E9-ON652578E2.00137B30-652578E2.001450FD@ibsplc.com
обсуждение исходный текст
Ответ на Re: Parameters for PostgreSQL  (Craig Ringer <craig@postnewspapers.com.au>)
Ответы Re: Parameters for PostgreSQL  (Craig Ringer <ringerc@ringerc.id.au>)
Re: Parameters for PostgreSQL  (Craig Ringer <craig@postnewspapers.com.au>)
Список 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 по дате отправления:

Предыдущее
От: Robert Klemme
Дата:
Сообщение: Re: Performance penalty when using WITH
Следующее
От: Adarsh Sharma
Дата:
Сообщение: Need to tune for Heavy Write