From: | John McKown <john(dot)archie(dot)mckown(at)gmail(dot)com> |
---|---|
To: | PostgreSQL General <pgsql-general(at)postgresql(dot)org> |
Subject: | Re: Memory usage per session |
Date: | 2016-07-08 13:27:00 |
Message-ID: | CAAJSdjjSnsutHByJ90J5+=HbWx+nTJMq0rOoTqdffg=wcgu5Jg@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
On Fri, Jul 8, 2016 at 8:16 AM, <AMatveev(at)bitec(dot)ru> wrote:
> Hi
>
> > On 08/07/2016 14:11, AMatveev(at)bitec(dot)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
> performance.
> Of cause we understand that unix is faster( damn fork :)))
> Our Current problem is memory:
> (160m vs 5M) * 100 sessions = 16G vs 0.5G
> We just can get "out of memory".
> :(((
>
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 scale up as the number of clients
increased because every clients would share the same cache data within the
server. Or are you measuring the memory usage where the client is on one
machine and the PostgreSQL server is a different machine, with the client
machine getting the memory hit?
--
"Pessimism is a admirable quality in an engineer. Pessimistic people check
their work three times, because they're sure that something won't be right.
Optimistic people check once, trust in Solis-de to keep the ship safe, then
blow everyone up."
"I think you're mistaking the word optimistic for inept."
"They've got a similar ring to my ear."
From "Star Nomad" by Lindsay Buroker:
Maranatha! <><
John McKown
From | Date | Subject | |
---|---|---|---|
Next Message | Stephen Frost | 2016-07-08 13:35:50 | Re: Memory usage per session |
Previous Message | Pavel Stehule | 2016-07-08 13:26:54 | Re: Memory usage per session |