Recently in use in a Postgresql database a problems in the project, using the application data query, the prompt out of memory error,
Say the first environment:
Operating system: Windows server 2008 R2 64 - bit system
4 gb memory:

My analysis is as follows:
1, may be a database connection is too much, lead to insufficient memory, prompt the information,
But look at the progress of the PG database is not much, should not connect too much lead to insufficient memory,
2, data query result is more, lead to insufficient memory, prompt the information,
If it is for this reason, you should adjust the PG database configuration file postgresql. Conf in which parameters, can query more data?

In addition, I have another one 8 gb of memory (free of 4 g) test on a computer, the postgresql) in the conf shared_buffers properties changed from 1024 MB to 2048 MB, PG service cannot be started,
Query data haven't seen this limitation, is it because I install Postgresql database is caused by the 32-bit version?

Great god help solve, genuflect is begged

CodePudding user response:

His reply first, add some popularity, the great god, are you all???????

CodePudding user response:

Machine memory is not large, the query table data quantities? Statement execution is what look like? Work_mem? These involve memory, out of the memory is out of memory error application memory and system,

CodePudding user response:

Is there any solution for
Want to see
I also out of the question

CodePudding user response:

Er kang:

- in addition, I have another one 8 gb of memory (free of 4 g) test on a computer, the postgresql. In the conf shared_buffers attributes changed from 1024 MB to 2048 MB, PG service cannot be started,

The problem: pg when start the service, will create the first six process, at this time it would take a set shared_buffers twice the memory, is set to 2 g, start the service you need 4 gb of memory, so the service can fail,

CodePudding user response:

Open up the "ODBC Data Source Administrator 'window after running it as Administrator. Click on the' Data Source 'that you are using and Click on" Configure ". In the' PostgreSQL ANSI ODBC Driver (psqlODBC) Setup "window, Click on 'Datasource'. Ensure that the checkbox 'Use Declare/Fetch' is checked and then Click on" OK "and close the subsequent Windows. This setting resolves the issue. Below is the screenshot

CodePudding user response:

Shared buffer is too big, can't, as Linux suggest 50% of physical memory, generally 12.5 to 25%