On Fri, 2010-07-09 at 00:42 -0400, Tom Lane wrote:
Samuel Gendler sgend...@ideasculptor.com writes:
On Thu, Jul 8, 2010 at 8:11 PM, Craig Ringer
cr...@postnewspapers.com.au wrote:
If you're not using a connection pool, start using one.
I see this issue and subsequent advice cross this
Scott Marlowe scott.marl...@gmail.com wrote:
Hannu Krosing ha...@2ndquadrant.com wrote:
One example where you need a separate connection pool is pooling
really large number of connections, which you may want to do on
another host than the database itself is running.
Definitely. Often it's
On Wed, 2010-07-14 at 08:58 -0500, Kevin Grittner wrote:
Scott Marlowe scott.marl...@gmail.com wrote:
Hannu Krosing ha...@2ndquadrant.com wrote:
One example where you need a separate connection pool is pooling
really large number of connections, which you may want to do on
another host
Craig Ringer wrote:
It'll need to separate running queries from running processes, or
start threading backends, so that one way or the other a single query
can benefit from the capabilities of multiple CPUs. The same separation,
or a move to async I/O, might be needed to get one query to
Two problems to recognize. First is that building something in has the
potential to significantly limit use and therefore advancement of work
on external pools, because of the let's use the built in one instead of
installing something extra mentality. I'd rather have a great external
On 2010-07-10 00:59, Greg Smith wrote:
Matthew Wakeling wrote:
If you have an external pool solution, you can put it somewhere
else - maybe on multiple somewhere elses.
This is the key point to observe: if you're at the point where you
have so many connections that you need a pool, the
Jesper Krogh wrote:
I dont think a build-in connection-poller (or similiar) would in any
way limit the actions and abillities of an external one?
Two problems to recognize. First is that building something in has the
potential to significantly limit use and therefore advancement of work
on
On 09/07/10 12:42, Tom Lane wrote:
Samuel Gendler sgend...@ideasculptor.com writes:
On Thu, Jul 8, 2010 at 8:11 PM, Craig Ringer
cr...@postnewspapers.com.au wrote:
If you're not using a connection pool, start using one.
I see this issue and subsequent advice cross this list awfully
Thanx you all for the replies.
I got a gist on where should I head towards
like I should rely a bit on postgres for performance and rest on my
tomcat and application.
And will try connection pooling on postgres part.
And if I come back for any query (related to this topic) then this
time it will
Otherwise I'm wondering if PostgreSQL will begin really suffering in
performance on workloads where queries are big and expensive but there
are relatively few of them running at a time.
Oh, I should note at this point that I'm *not* whining that someone
should volunteer to do this, or that the
On Fri, 2010-07-09 at 00:42 -0400, Tom Lane wrote:
Samuel Gendler sgend...@ideasculptor.com writes:
On Thu, Jul 8, 2010 at 8:11 PM, Craig Ringer
cr...@postnewspapers.com.au wrote:
If you're not using a connection pool, start using one.
I see this issue and subsequent advice cross this
Thanx you all for the replies.
I got a gist on where should I head towards
like I should rely a bit on postgres for performance and rest on my
tomcat and application.
And will try connection pooling on postgres part.
And if I come back for any query (related to this topic) then this
time it will
Brad Nicholson bnich...@ca.afilias.info wrote:
Just like replication, pooling has different approaches. I do
think that in both cases, having a solution that works, easily,
out of the box will meet the needs of most users.
Any thoughts on the minimalist solution I suggested a couple weeks
On Fri, 9 Jul 2010, Kevin Grittner wrote:
Any thoughts on the minimalist solution I suggested a couple weeks
ago?:
http://archives.postgresql.org/pgsql-hackers/2010-06/msg01385.php
http://archives.postgresql.org/pgsql-hackers/2010-06/msg01387.php
So far, there has been no comment by anyone
In case there's any doubt, the questions below aren't rhetorical.
Matthew Wakeling matt...@flymine.org wrote:
Interesting idea. As far as I can see, you are suggesting solving
the too many connections problem by allowing lots of connections,
but only allowing a certain number to do anything
If your app is running under Tomcat, connection pooling is extremely easy to
set up from there: It has connection pooling mechanisms built in. Request your
db connections using said mechanisms, instead of doing it manually, make a
couple of changes to server.xml, and the problem goes away.
On Fri, 9 Jul 2010, Kevin Grittner wrote:
Interesting idea. As far as I can see, you are suggesting solving
the too many connections problem by allowing lots of connections,
but only allowing a certain number to do anything at a time?
Right.
I think in some situations, this arrangement would
Matthew Wakeling matt...@flymine.org wrote:
On Fri, 9 Jul 2010, Kevin Grittner wrote:
Interesting idea. As far as I can see, you are suggesting
solving the too many connections problem by allowing lots of
connections, but only allowing a certain number to do anything
at a time?
Right.
I
If anything was built in the database to handle such connections, I'd recommend
a big, bold warning, recommending the use of client-side pooling if available.
For something like, say, a web-server, pooling connections to the database
provides a massive performance advantage regardless of how
Jorge Montero jorge_mont...@homedecorators.com wrote:
If anything was built in the database to handle such connections,
I'd recommend a big, bold warning, recommending the use of client-
side pooling if available.
+1
-Kevin
--
Sent via pgsql-performance mailing list
On Fri, Jul 9, 2010 at 12:42 AM, Tom Lane t...@sss.pgh.pa.us wrote:
Samuel Gendler sgend...@ideasculptor.com writes:
On Thu, Jul 8, 2010 at 8:11 PM, Craig Ringer
cr...@postnewspapers.com.au wrote:
If you're not using a connection pool, start using one.
I see this issue and subsequent advice
Matthew Wakeling wrote:
If you have an external pool solution, you can put it somewhere else -
maybe on multiple somewhere elses.
This is the key point to observe: if you're at the point where you have
so many connections that you need a pool, the last place you want to put
that is on the
Greg Smith g...@2ndquadrant.com wrote:
if you're at the point where you have so many connections that you
need a pool, the last place you want to put that is on the
overloaded database server itself. Therefore, it must be an
external piece of software to be effective, rather than being part
On 10/07/10 00:56, Brad Nicholson wrote:
On Fri, 2010-07-09 at 00:42 -0400, Tom Lane wrote:
Perhaps not, but there's no obvious benefit either. Since there's
More Than One Way To Do It, it seems more practical to keep that as a
separate problem that can be solved by a choice of add-on
Hi,
I want to fine tune my postgresql to increase number of connects it
can handle in a minutes time.
Decrease the response time per request etc.
The exact case will be to handle around 100 concurrent requests.
Can any one please help me in this.
Any hardware suggestions are also welcomed.
Harpreet singh Wadhwa harpreetsingh.wad...@gmail.com wrote:
I want to fine tune my postgresql to increase number of connects
it can handle in a minutes time.
Decrease the response time per request etc.
The exact case will be to handle around 100 concurrent requests.
I have found that
On 9/07/2010 3:20 AM, Harpreet singh Wadhwa wrote:
Hi,
I want to fine tune my postgresql to increase number of connects it
can handle in a minutes time.
Decrease the response time per request etc.
The exact case will be to handle around 100 concurrent requests.
If you're not using a
On Thu, Jul 8, 2010 at 8:11 PM, Craig Ringer
cr...@postnewspapers.com.au wrote:
If you're not using a connection pool, start using one.
Do you really need 100 *active* working query threads at one time? Because
if you do, you're going to need a scary-big disk subsystem and a lot of
Samuel Gendler sgend...@ideasculptor.com writes:
On Thu, Jul 8, 2010 at 8:11 PM, Craig Ringer
cr...@postnewspapers.com.au wrote:
If you're not using a connection pool, start using one.
I see this issue and subsequent advice cross this list awfully
frequently. Is there in architectural
29 matches
Mail list logo