Could you show me what parameter of pgbouncer.ini can do that. I read
pgbouncer and can not make pgbouncer open and keep 200 connect to postgres
(Sorry for my English)
Thanks you very much.
Tuan Hoang ANh
On Wed, Dec 22, 2010 at 7:13 PM, Gurjeet Singh singh.gurj...@gmail.comwrote:
On Wed, Dec
tuanhoanganh hatua...@gmail.com wrote:
Could you show me what parameter of pgbouncer.ini can do that. I
read pgbouncer and can not make pgbouncer open and keep 200
connect to postgres
What makes you think that 200 connections to PostgreSQL will be a
good idea? Perhaps you want a smaller
On Thu, Dec 23, 2010 at 09:20:59PM +0700, tuanhoanganh wrote:
Could you show me what parameter of pgbouncer.ini can do that. I read
pgbouncer and can not make pgbouncer open and keep 200 connect to postgres
(Sorry for my English)
Thanks you very much.
Tuan Hoang ANh
You need to use
On Thu, Dec 23, 2010 at 9:37 PM, Kevin Grittner kevin.gritt...@wicourts.gov
wrote:
tuanhoanganh hatua...@gmail.com wrote:
Could you show me what parameter of pgbouncer.ini can do that. I
read pgbouncer and can not make pgbouncer open and keep 200
connect to postgres
What makes you
What you still haven't clarified is how long each exe/user combo keeps
the connection open for.
If for a day, then who cares that it takes 4 seconds each morning to
open them all?
If for a fraction of a second, then you do not need 200 simultaneous
open connections, they can probably share a
As far as i know, Pgbouncer can help to minimum connect to postgresql, I
want tool can open and keep 200 connect to postgresql (be cause start new
connect to postgresql in windows very slow, i want it open 200 connect in
first time and my application connect to this tool)
Is there any tool like
On Wed, Dec 22, 2010 at 6:28 AM, tuanhoanganh hatua...@gmail.com wrote:
As far as i know, Pgbouncer can help to minimum connect to postgresql, I
want tool can open and keep 200 connect to postgresql (be cause start new
connect to postgresql in windows very slow, i want it open 200 connect in
On Tue, Dec 21, 2010 at 04:35, Scott Marlowe scott.marl...@gmail.com wrote:
On Mon, Dec 20, 2010 at 8:31 PM, tuanhoanganh hatua...@gmail.com wrote:
Is there any tool work on windows can open 200 connect to postgresql and
application connect to this tool to decrease time connect to PostgreSQL
Here is my new pgbench's point
pgbench -h 127.0.0.1 -p -U postgres -c 200 -t 100 -s 10 pgbench
Scale option ignored, using pgbench_branches table count = 10
starting vacuum...end.
transaction type: TPC-B (sort of)
scaling factor: 10
query mode: simple
number of clients: 200
number of
On Mon, Dec 20, 2010 at 7:10 AM, tuanhoanganh hatua...@gmail.com wrote:
Here is my new pgbench's point
pgbench -h 127.0.0.1 -p -U postgres -c 200 -t 100 -s 10 pgbench
Your -c should always be the same or lower than -s. Anything higher
and you're just thrashing your IO system waiting for
P.s. here's one of my two slower slave machines. It has dual quad
core opterons (2352 2.1GHz) and 32 Gig ram. Controller is an Areca
1680 with 512M battery backed cache and 2 disks for pg_xlog and 12 for
the data/base directory. Running Centos 5.4 or so.
pgbench -c 10 -t 1 test
starting
Is there any tool work on windows can open 200 connect to postgresql and
application connect to this tool to decrease time connect to PostgreSQL
(because PostgreSQL start new process when have a new connect, I want this
tool open and keep 200 connect to postgreSQL, my application connect to this
On Mon, Dec 20, 2010 at 8:31 PM, tuanhoanganh hatua...@gmail.com wrote:
Is there any tool work on windows can open 200 connect to postgresql and
application connect to this tool to decrease time connect to PostgreSQL
(because PostgreSQL start new process when have a new connect, I want this
I have server computer install Windows 2008R2, PostgreSQL 9.0.1 64 bit, 8G
RAM, RAID 10 - 4 disks, dedicated server
Here is config of postgresql.conf after running pgtune
default_statistics_target = 100 # pgtune wizard 2010-12-15
maintenance_work_mem = 480MB # pgtune wizard 2010-12-15
tuanhoanganh wrote:
tps = 20.143494 (including connections establishing)
tps = 256.630260 (excluding connections establishing)
Why pgbench on my server is very low or is it common value with my
server ?
Those numbers look pretty low to me. I would start with looking at
why it is
On Sat, Dec 18, 2010 at 10:15 AM, tuanhoanganh hatua...@gmail.com wrote:
I have server computer install Windows 2008R2, PostgreSQL 9.0.1 64 bit, 8G
...
pgbench -h 127.0.0.1 -p 5433 -U postgres -c 100 -t 10 -C -s 10 pgbench
Why the -C option? You are essentially benchmarking how fast you can
No, I don't use SSL. Here is my pg_hba.conf
# IPv4 local connections:
hostall all 0.0.0.0/0trust
# IPv6 local connections:
hostall all ::1/128 trust
On Sun, Dec 19, 2010 at 1:35 AM, Kevin Grittner
My app has ~ 20 exe file, each of exe create new connect to postgesql and
there are 10-30 user use my application so I need -C to check PostgreSQL
performance.
I will test without -C option. But is there any way to decrease connect time
when there are 200 process, each of process will create new
Here is my result without -C
pgbench -h 127.0.0.1 -p -U postgres -c 100 -t 10 -s 10 pgbench
Scale option ignored, using pgbench_branches table count = 10
starting vacuum...end.
transaction type: TPC-B (sort of)
scaling factor: 10
query mode: simple
number of clients: 100
number of threads: 1
On Sat, Dec 18, 2010 at 11:13 AM, tuanhoanganh hatua...@gmail.com wrote:
My app has ~ 20 exe file, each of exe create new connect to postgesql
But how often do they do that? Does each exe make a new connection,
do one transaction, and then exit? Or does each exe make one
connection, do one
On 12/18/10 20:42, tuanhoanganh wrote:
Here is my result without -C
pgbench -h 127.0.0.1 -p -U postgres -c 100 -t 10 -s 10 pgbench
You really should replace -t 10 with something like -T 60 or more.
--
Sent via pgsql-performance mailing list (pgsql-performance@postgresql.org)
To make
21 matches
Mail list logo
