Click here to Skip to main content
15,036,363 members
Home / Discussions / Database
   

Database

 
GeneralRe: Oracle Collection Objects Pin
lionelcyril18-Aug-11 8:21
Memberlionelcyril18-Aug-11 8:21 
AnswerRe: Oracle Collection Objects Pin
Wendelius18-Aug-11 8:32
mveWendelius18-Aug-11 8:32 
GeneralRe: Oracle Collection Objects Pin
lionelcyril18-Aug-11 8:37
Memberlionelcyril18-Aug-11 8:37 
GeneralRe: Oracle Collection Objects Pin
Wendelius18-Aug-11 8:56
mveWendelius18-Aug-11 8:56 
QuestionMax. number of concurrent user in PostGre database Pin
Navin Pandit17-Aug-11 18:55
MemberNavin Pandit17-Aug-11 18:55 
AnswerRe: Max. number of concurrent user in PostGre database Pin
Wendelius17-Aug-11 19:00
mveWendelius17-Aug-11 19:00 
GeneralRe: Max. number of concurrent user in PostGre database Pin
Navin Pandit17-Aug-11 19:10
MemberNavin Pandit17-Aug-11 19:10 
GeneralRe: Max. number of concurrent user in PostGre database Pin
Wendelius17-Aug-11 19:35
mveWendelius17-Aug-11 19:35 
Sorry, but I don't quite follow. From the settings documentation:

"Determines the maximum number of concurrent connections to the database server...This parameter can only be set at server start"

So my understanding is that with this startup parameter you define the maximum number of concurrent connections that can be taken to the server (well actually max_connections-superuser_reserved_connections). As far as I know, the actual maximum you can define is operating system dependent.

The setting itself is defined in postgresql.conf.
The need to optimize rises from a bad design.My articles[^]

GeneralRe: Max. number of concurrent user in PostGre database Pin
jschell18-Aug-11 13:02
Memberjschell18-Aug-11 13:02 
GeneralRe: Max. number of concurrent user in PostGre database Pin
Navin Pandit18-Aug-11 18:33
MemberNavin Pandit18-Aug-11 18:33 
GeneralRe: Max. number of concurrent user in PostGre database Pin
jschell19-Aug-11 7:34
Memberjschell19-Aug-11 7:34 
QuestionSearching with optional parameters [modified] Pin
Pascal Ganaye16-Aug-11 1:36
MemberPascal Ganaye16-Aug-11 1:36 
AnswerRe: Searching with optional parameters Pin
PIEBALDconsult16-Aug-11 3:23
professionalPIEBALDconsult16-Aug-11 3:23 
GeneralRe: Searching with optional parameters Pin
Pascal Ganaye16-Aug-11 4:16
MemberPascal Ganaye16-Aug-11 4:16 
AnswerRe: Searching with optional parameters Pin
Pascal Ganaye16-Aug-11 4:21
MemberPascal Ganaye16-Aug-11 4:21 
GeneralRe: Searching with optional parameters Pin
PIEBALDconsult16-Aug-11 17:56
professionalPIEBALDconsult16-Aug-11 17:56 
GeneralRe: Searching with optional parameters Pin
Mycroft Holmes16-Aug-11 18:06
professionalMycroft Holmes16-Aug-11 18:06 
GeneralRe: Searching with optional parameters Pin
PIEBALDconsult17-Aug-11 2:48
professionalPIEBALDconsult17-Aug-11 2:48 
GeneralRe: Searching with optional parameters Pin
Mycroft Holmes17-Aug-11 5:40
professionalMycroft Holmes17-Aug-11 5:40 
GeneralRe: Searching with optional parameters Pin
PIEBALDconsult17-Aug-11 14:11
professionalPIEBALDconsult17-Aug-11 14:11 
GeneralRe: Searching with optional parameters Pin
S Douglas20-Aug-11 7:53
professionalS Douglas20-Aug-11 7:53 
GeneralRe: Searching with optional parameters Pin
PIEBALDconsult20-Aug-11 13:01
professionalPIEBALDconsult20-Aug-11 13:01 
QuestionRe: Searching with optional parameters Pin
Shameel16-Aug-11 4:52
professionalShameel16-Aug-11 4:52 
AnswerRe: Searching with optional parameters Pin
Pascal Ganaye16-Aug-11 6:02
MemberPascal Ganaye16-Aug-11 6:02 
GeneralRe: Searching with optional parameters Pin
PIEBALDconsult16-Aug-11 18:04
professionalPIEBALDconsult16-Aug-11 18:04 

General General    News News    Suggestion Suggestion    Question Question    Bug Bug    Answer Answer    Joke Joke    Praise Praise    Rant Rant    Admin Admin   

Use Ctrl+Left/Right to switch messages, Ctrl+Up/Down to switch threads, Ctrl+Shift+Left/Right to switch pages.