sanjeetkamble wrote:
> Please explain in details im not able to understand.
https://wiki.postgresql.org/wiki/Number_Of_Database_Connections
http://stackoverflow.com/questions/10419665/how-does-pgbouncer-help-to-speed-up-django/10420469#10420469
https://wiki.postgresql.org/wiki/PgBouncer
--
Ke
On 05/04/2015 11:11 PM, sanjeetkamble wrote:
Hello,
Please explain in details im not able to understand.
You are going to have to be more specific.
Do you want to know why setting max_connections=1 will not work?
Do you want to know about connection pooling?
Or do you want to know how t
Hello,
Please explain in details im not able to understand.
--
View this message in context:
http://postgresql.nabble.com/Setting-up-a-database-for-1-concurrent-users-tp1848801p5848004.html
Sent from the PostgreSQL - general mailing list archive at Nabble.com.
--
Sent via pgsql-general
On 05/04/2015 02:02 AM, sanjeetkamble wrote:
Hello,
Please let me know how The database server is started with
max_connections =
1 ???
I have same issue, but i have a SAN storage where Postgresql is
installed.
Sanjeet
On Mon, May 4, 2015 a
I suggest pg_bouncer as opposed to pg_pool. My testing showed it handled
connections better. Ultimately the choice is yours, but with 1
connections, you absolutely need a connection manger.
On Mon, May 4, 2015 at 10:08 AM, Andy Colson wrote:
> On 05/04/2015 02:02 AM, sanjeetkamble wrote:
>
>
On 05/04/2015 02:02 AM, sanjeetkamble wrote:
Hello,
Please let me know how The database server is started with max_connections =
1 ???
I have same issue, but i have a SAN storage where Postgresql is installed.
Sanjeet
No doubt that would be a problem. Its bad idea. set max_connecti
Hello,
Please let me know how The database server is started with max_connections =
1 ???
I have same issue, but i have a SAN storage where Postgresql is installed.
Sanjeet
--
View this message in context:
http://postgresql.nabble.com/Setting-up-a-database-for-1-concurrent-us
10GB of RAM isn't that farfetched nowadays.
However I/O might be a problem. A single drive can typically write/read
about 10MB a second (64KB chunks random access - not sure if you'd want
to bet on getting sequential throughput ;) ).
Anyway, it'll be something interesting to see ;).
Link.
At 09:45 PM 9/5/2005 +0100, Richard Huxton wrote:
Poul Møller Hansen wrote:
I'm trying to setup a database for 1 concurrent users for a test.
I have a system with 1GB of RAM where I will use 512MB for PostgreSQL.
It is running SuSE 9.3
I think you're being horribly optimistic if you actu
"Sergey E. Koposov" <[EMAIL PROTECTED]> writes:
> But I really doubt that it it possible/reasonable to have 1
> simultaneous connections.
You're going to need a heck of a beefy machine to do it, anyway.
I would expect that after fixing the semaphore configuration problem,
the next thing that
On Mon, 5 Sep 2005, [UTF-8] Poul Mц╦ller Hansen wrote:
> I'm trying to setup a database for 1 concurrent users for a test.
> I have a system with 1GB of RAM where I will use 512MB for PostgreSQL.
> It is running SuSE 9.3
>
> I have changed SHMMAX & SHMALL
> echo "536870912" >/proc/sys/kernel/
I think you're being horribly optimistic if you actually want 1
concurrent connections, with users all doing things. Even if you only
allow 1MB for each connection that's 10GB of RAM you'd want. Plus a big
chunk more to actually cache your database files and do work in. Then,
if you had 1
Poul Møller Hansen wrote:
I'm trying to setup a database for 1 concurrent users for a test.
I have a system with 1GB of RAM where I will use 512MB for PostgreSQL.
It is running SuSE 9.3
I think you're being horribly optimistic if you actually want 1
concurrent connections, with users a
Calculated the values should be
SEMMNI = 1 / 16
SEMMNS = (1 / 16) * 17 "plus room for other applications" How much
should that be ?
And where can I change those values on a 2.6 kernel ?
I will try to answer myself with another question.
Can it be that it should be changed in
/usr/src/
I'm trying to setup a database for 1 concurrent users for a test.
I have a system with 1GB of RAM where I will use 512MB for PostgreSQL.
It is running SuSE 9.3
I have changed SHMMAX & SHMALL
echo "536870912" >/proc/sys/kernel/shmmax
echo "536870912" >/proc/sys/kernel/shmall
and max_connectio
15 matches
Mail list logo
