On 7/8/2016 12:00 PM, Karl Czajkowski wrote:
3. Rewrite or refactor such complex stored procedures in a different
programming language such as C or Python, so your PL/pgsql stored
procedures remain small glue around libraries of code. Postgres
makes it very trivial to extend the
On Jul 08, John McKown modulated:
...
> I think the "problem" that he is having is fixable only by changing how
> PostgreSQL itself works. His problem is a PL/pgSQL function which is
> 11K lines in length. When invoked, this function is "compiled" into a
> large tokenized parse tree. This parse
On 7/8/2016 11:52 AM, Paul Tilles - NOAA Federal wrote:
I am currently running Version 9.3.10 of postgres with RHEL 6. I am
going to upgrade my O/S soon to RHEL 7. Do I need to upgrade to
version 9.4.x of postgres?
was 9.3 installed from the PGDG yum repository, or from the default RHEL
I am currently running Version 9.3.10 of postgres with RHEL 6. I am going
to upgrade my O/S soon to RHEL 7. Do I need to upgrade to version 9.4.x of
postgres?
Paul Tilles
Tom Lane wrote:
> Francisco Olarte writes:
> > On Thu, Jul 7, 2016 at 8:18 PM, Alvaro Herrera
> > wrote:
> >> I've wished sometimes for a "\set READLINE off" psql metacommand for
> >> this kind of thing. It's pretty annoying when the text being
2016-07-08 17:49 GMT+02:00 :
> Hi
>
>
> >> Oracle: about 5M
> >> postgreSql: about 160М
>
>
>
> >The almost session memory is used for catalog caches. So you should to
> have big catalog and long living sessions.
>
> >What do you do exactly?
>
> I've generate test code that
On Fri, Jul 8, 2016 at 11:26 AM, Melvin Davidson
wrote:
>
>
> On Fri, Jul 8, 2016 at 11:49 AM, wrote:
>
>> Hi
>>
>>
>> >> Oracle: about 5M
>> >> postgreSql: about 160М
>>
>>
>>
>> >The almost session memory is used for catalog caches. So you should to
>>
On Fri, Jul 8, 2016 at 11:49 AM, wrote:
> Hi
>
>
> >> Oracle: about 5M
> >> postgreSql: about 160М
>
>
>
> >The almost session memory is used for catalog caches. So you should to
> have big catalog and long living sessions.
>
> >What do you do exactly?
>
> I've generate test
Title: Re: [GENERAL] Memory usage per session
Hi
>> Oracle: about 5M
>> postgreSql: about 160М
>The almost session memory is used for catalog caches. So you should to have big catalog and long living sessions.
>What do you do exactly?
I've generate test code that emulates instruction
Title: Re: [GENERAL] Memory usage per session
Hi
>> >> The test performs about 11K lines of code
>> >> Oracle: about 5M
>> >> postgreSql: about 160М
>What is the actual O/S that PostgreSQL is installed on?
>How much total memory is on the server?
>I would be very curious about the values
On 08/07/2016 17:07, amatv...@bitec.ru wrote:
Hi
The test performs about 11K lines of code
Oracle: about 5M
postgreSql: about 160М
Do you have 100 CPUs on this system which apparently doesn't have 16G
of RAM available for PG to use?
We can say at fact:
We currently work at oracle.
Our
On Fri, Jul 8, 2016 at 10:07 AM, wrote:
> Hi
>
> >> >> The test performs about 11K lines of code
> >> >> Oracle: about 5M
> >> >> postgreSql: about 160М
>
>
> > Do you have 100 CPUs on this system which apparently doesn't have 16G
> > of RAM available for PG to use?
> We can
Title: Re: [GENERAL] Memory usage per session
Здравствуйте.
>> Oracle: about 5M
>> postgreSql: about 160М
>I'm admittedly ignorant of this type of testing. But if the memory usage for PostgreSQL is in the server, perhaps due to caching (how to test?), then it likely would _not_ linearly
Francisco Olarte writes:
> On Thu, Jul 7, 2016 at 8:18 PM, Alvaro Herrera
> wrote:
>> I've wished sometimes for a "\set READLINE off" psql metacommand for
>> this kind of thing. It's pretty annoying when the text being pasted
>> contains tabs
Hi
>> >> The test performs about 11K lines of code
>> >> Oracle: about 5M
>> >> postgreSql: about 160М
> Do you have 100 CPUs on this system which apparently doesn't have 16G
> of RAM available for PG to use?
We can say at fact:
We currently work at oracle.
Our code base about 4000 k line of
* amatv...@bitec.ru (amatv...@bitec.ru) wrote:
> > On 08/07/2016 14:11, amatv...@bitec.ru wrote:
> >> The test performs about 11K lines of code
> >> Memory usage per session:
> >> Oracle: about 5M
> >> MSSqlServer: about 4M
> >> postgreSql: about 160М
>
> > Visual C???
> > You will have to run
On Fri, Jul 8, 2016 at 8:16 AM, wrote:
> Hi
>
> > On 08/07/2016 14:11, amatv...@bitec.ru wrote:
> >> Hi.
> >> The test performs about 11K lines of code
> >> Memory usage per session:
> >> Oracle: about 5M
> >> MSSqlServer: about 4M
> >> postgreSql: about 160М
>
>
> > Visual
Hi
2016-07-08 15:16 GMT+02:00 :
> Hi
>
> > On 08/07/2016 14:11, amatv...@bitec.ru wrote:
> >> Hi.
> >> The test performs about 11K lines of code
> >> Memory usage per session:
> >> Oracle: about 5M
> >> MSSqlServer: about 4M
> >> postgreSql: about 160М
>
>
> > Visual C???
> >
Hi
> On 08/07/2016 14:11, amatv...@bitec.ru wrote:
>> Hi.
>> The test performs about 11K lines of code
>> Memory usage per session:
>> Oracle: about 5M
>> MSSqlServer: about 4M
>> postgreSql: about 160М
> Visual C???
> You will have to run PostgreSQL on a proper Unix system to test for
>
On Fri, 8 Jul 2016, 8:06 p.m. Prashanth Adiyodi,
wrote:
> Hi Sameer, Please see comments inline
>
>
>
>
>
> *Prashanth Adiyodi *
>
> *Technical Account Manager*
>
> *Skype: prashanth.adiyodi*
>
> *Mob: +91-9819488395*
>
> [image: celltick]
>
>
>
>
>
>
>
> *From:* Sameer
On 08/07/2016 14:11, amatv...@bitec.ru wrote:
Hi.
We have tested postgreSql,Oracle,MSSqlServer.
The test performs about 11K lines of code
Memory usage per session:
Oracle: about 5M
MSSqlServer: about 4M
postgreSql: about 160М
The result of postgreSql is very sad(Our typical business logic has
Hi.
We have tested postgreSql,Oracle,MSSqlServer.
The test performs about 11K lines of code
Memory usage per session:
Oracle: about 5M
MSSqlServer: about 4M
postgreSql: about 160М
The result of postgreSql is very sad(Our typical business logic has about 30K
lines of code).
How can I reduce memory
Hi:
On Thu, Jul 7, 2016 at 8:18 PM, Alvaro Herrera wrote:
>> You might have better luck with "psql -n", or maybe not.
> I've wished sometimes for a "\set READLINE off" psql metacommand for
> this kind of thing. It's pretty annoying when the text being pasted
> contains
On Fri, Jul 8, 2016 at 5:38 PM Francisco Olarte
wrote:
> 1.- CCing to the list ( remember to hit reply-all or whatever your MUA
> uses for that, otherwise threads may get lost ).
>
> 2.- Try to avoid top-posting, it's not the style of the list ( or mine ).
>
> On Fri, Jul
1.- CCing to the list ( remember to hit reply-all or whatever your MUA
uses for that, otherwise threads may get lost ).
2.- Try to avoid top-posting, it's not the style of the list ( or mine ).
On Fri, Jul 8, 2016 at 4:43 AM, Prashanth Adiyodi
wrote:
> Basically my
25 matches
Mail list logo