* AMatveev@xxxxxxxx (AMatveev@xxxxxxxx) wrote: > > On 08/07/2016 14:11, AMatveev@xxxxxxxx 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 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". > :((( Do you have 100 CPUs on this system which apparently doesn't have 16G of RAM available for PG to use? If not, you should probably consider connection pooling to reduce the number of PG sessions to something approaching the number of CPUs/cores you have in the system. Thanks! Stephen
Attachment:
signature.asc
Description: Digital signature
