public inbox for [email protected]
help / color / mirror / Atom feedFrom: Michael DNA <[email protected]>
To: Igor Neyman <[email protected]>
Cc: Mariel Cherkassky <[email protected]>
Cc: [email protected] <[email protected]>
Subject: Re: performance problem on big tables
Date: Mon, 21 Aug 2017 10:51:47 -0400
Message-ID: <[email protected]> (raw)
In-Reply-To: <DM5PR17MB14990812A3330DF641866D0ADA870@DM5PR17MB1499.namprd17.prod.outlook.com>
References: <CA+t6e1m06=RkReCDxdyjwAMwVwuKxakV8TKmQ2cnMLFYbOjMCA@mail.gmail.com>
<CA+t6e1nvx3KfKP_QAKQ+WvzJF5k3h5Uq+F674bVk5PjWv2enrw@mail.gmail.com>
<[email protected]>
<CA+t6e1nXJz34ECUfJAkq7JQVkzr2mg-cbsW_acBXcyM2eyBKBw@mail.gmail.com>
<[email protected]>
<CA+t6e1kXc1=z-4yAB+jBXpLNVCvTO2d2W69Re-N4YrckdXoDvg@mail.gmail.com>
<CA+t6e1kijisMi3cjNy3HEEvDMMH_u9WkzS3ViQGZ9cPTZ3YtWQ@mail.gmail.com>
<CAGTBQpaXBW_edddHy649yMVL81zDo=rY8MP1ZxQDxnUZ=9hGaw@mail.gmail.com>
<CA+t6e1nB58DtiMmNeY_Nh+wjRyT_WOFFxNJRJK=M30d4HAWJnQ@mail.gmail.com>
<CA+t6e1n6nqwyh1Jb1WTU6kYr9kgkdZe+GABY9XgDozixoS08DA@mail.gmail.com>
<CA+t6e1=+aig4WoZRG+_qpRG+zs_U--v42dSznT4B55Y=xh9Lhw@mail.gmail.com>
<[email protected]>
<CA+t6e1mGdyVkqB3=3Yt73JCsY0o-wWLyvtQmeNmKA6RwR0BZ6A@mail.gmail.com>
<[email protected]>
<CA+t6e1khEV=YeWR-xCk8i4s7q--FKxo_PNmB+OJ=jxnr8g51dg@mail.gmail.com>
<[email protected]>
<CA+t6e1nqCVwUbSwKNobGQDpM2N_PAufAOE9Ca3BsR6Tjknz8=g@mail.gmail.com>
<DM5PR17MB14990812A3330DF641866D0ADA870@DM5PR17MB1499.namprd17.prod.outlook.com>
List-Unsubscribe: <mailto:[email protected]?body=unsub%20pgsql-performance>
If your procedures to get the data is part is a query predicate, then you can still use ora2pg
Sent from my iPhone
> On Aug 21, 2017, at 10:35 AM, Igor Neyman <[email protected]> wrote:
>
>
> From: [email protected] [mailto:[email protected]] On Behalf Of Mariel Cherkassky
> Sent: Monday, August 21, 2017 10:20 AM
> To: MichaelDBA <[email protected]>
> Cc: [email protected]
> Subject: Re: [PERFORM] performance problem on big tables
>
> I had a system that consist from many objects(procedures,functions..) on an oracle database. We decided to integrate that system to postgresql. That system coppied alot of big tables from a different read only oracle database and preformed on it alot of queries to produce reports. The part of getting the data is part of some procedures, I cant change it so freely. I'm searching a way to improve the perfomance of the database because I'm sure that I didnt conifgure something well. Moreover, When I run complicted queries (joint between 4 big tables and filtering) it takes alot of time and I see that the server is cacheing all my ram memory.
>
>
> Probably your joins are done on Postgres side.
>
> m.b. instead of Postgres pulling data from Oracle, you should try pushing data from Oracle to Postgres using Oracle’s Heterogeneous Services and Postgres ODBC driver. In this case you do your joins and filtering on Oracles side and just push the result set to Postgres.
> That’s how I did migration from Oracle to Postgres.
>
> Regards,
> Igor Neyman
reply
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: [email protected]
Cc: [email protected], [email protected], [email protected]
Subject: Re: performance problem on big tables
In-Reply-To: <[email protected]>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by agora; see mirroring instructions
for how to clone and mirror all data and code used for this inbox