On Thu, Jul 8, 2010 at 11:48 PM, Hannu Krosing 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 best placed on the individual webs
On Fri, 2010-07-09 at 00:42 -0400, Tom Lane wrote:
> Samuel Gendler writes:
> > On Thu, Jul 8, 2010 at 8:11 PM, Craig Ringer
> > 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 a
On 07/13/2010 04:48 AM, Elias Ghanem wrote:
> Hi,
> I have table "ARTICLE" containing a String a field "STATUS" that
> represents a number in binary format (for ex: 10011101).
> My application issues queries with where conditions that uses BITAND
> operator on this field (for ex: select * from arti
On 07/11/2010 03:02 PM, Ryan Wexler wrote:
Well I got me a new raid card, MegaRAID 8708EM2, fully equipped with
BBU and read and write caching are enabled. It completely solved my
performance problems. Now everything is way faster than the previous
server. Thanks for all the help everyone.
On 07/13/2010 06:48 AM, Elias Ghanem wrote:
Hi,
I have table "ARTICLE" containing a String a field "STATUS" that represents a
number in binary format (for ex: 10011101).
My application issues queries with where conditions that uses BITAND operator on
this field (for ex: select * from article wh
On Tue, Jul 13, 2010 at 16:42, Dimitri Fontaine wrote:
> Tom Lane writes:
>> I agree with the comments to the effect that this is really a packaging
>> and documentation problem. There is no need for us to re-invent the
>> existing solutions, but there is a need for making sure that they are
>>
Tom Lane writes:
> I agree with the comments to the effect that this is really a packaging
> and documentation problem. There is no need for us to re-invent the
> existing solutions, but there is a need for making sure that they are
> readily available and people know when to use them.
On this t
Hi,
I have table "ARTICLE" containing a String a field "STATUS" that
represents a number in binary format (for ex: 10011101).
My application issues queries with where conditions that uses BITAND
operator on this field (for ex: select * from article where status & 4 = 4).
Thus i'm facing performa
phb07 a écrit :
Dimitri a écrit :
It's probably one of the cases when having HINTS in PostgreSQL may be
very helpful..
SELECT /*+ enable_nestloop=off */ ... FROM ...
will just fix this query without impacting other queries and without
adding any additional instructions into the application co
