Sorry for an off topic posting...
Michal,
> Honza Novak napsal(a):
> > And my questions:
> > 1. Does someone hes similar experience? or clue what to do with it?
>
> Sure, this is considered "normal" behavior for web applications. The
> solution is to use connection pooling.
>
> > 2. What is co
>>> On Wed, Oct 24, 2007 at 7:15 AM, in message
<[EMAIL PROTECTED]>, Honza Novak
<[EMAIL PROTECTED]> wrote:
> But sometimes (i don't know exactly for what reason) some queries gets
> stuck (mostly they are inserts or updates, but realy simple) and
> postgres is unable to answer in time
In a
Hi Honza,
as Gregory wrote, let apache do the job.
The apache does queue a request if all running workers are busy.
1. Split static content.
We have an apache as frontend which serves all static content and
forwards (reverse-proxy) dynamic content to the "backends"
2. Split different types of dy
On 10/24/07, Tom Lane <[EMAIL PROTECTED]> wrote:
> "Giulio Cesare Solaroli" <[EMAIL PROTECTED]> writes:
> > How can I try to isolate the trigger taking so long, in oder to
> > understand which is/are the missing index(es)?
>
> Try SET CONSTRAINTS ALL IMMEDIATE and then EXPLAIN ANALYZE the
> delete.
"Giulio Cesare Solaroli" <[EMAIL PROTECTED]> writes:
> How can I try to isolate the trigger taking so long, in oder to
> understand which is/are the missing index(es)?
Try SET CONSTRAINTS ALL IMMEDIATE and then EXPLAIN ANALYZE the
delete. This should cause all the triggers to run within the
scope
Hello Tom,
On 10/24/07, Tom Lane <[EMAIL PROTECTED]> wrote:
> "Giulio Cesare Solaroli" <[EMAIL PROTECTED]> writes:
> > As you may notice, the commit phase takes almost 2 full minutes. :-(
>
> Yow. It's hard to believe that the actual commit (ie, flushing the
> commit record to WAL) could take mor
Ron St-Pierre wrote:
> We vacuum only a few of our tables nightly, this one is the last one
> because it takes longer to run. I'll probably re-index it soon, but I
> would appreciate any advice on how to speed up the vacuum process (and
> the db in general).
I am a novice to postgreSQL, so I have
"Honza Novak" <[EMAIL PROTECTED]> writes:
> Hi all,
> i'm looking for correct or at least good enough solution for use of multiple
> apaches with single postgres database. (apaches are 2.0.x, and postgres is
> 8.1.x)
>
> At this moment i'm involved in management of a website where we have large
>
Honza Novak napsal(a):
And my questions:
1. Does someone hes similar experience? or clue what to do with it?
Sure, this is considered "normal" behavior for web applications. The
solution is to use connection pooling.
2. What is correct setup of postgresql backend serving data for many
(4+)
"Giulio Cesare Solaroli" <[EMAIL PROTECTED]> writes:
> As you may notice, the commit phase takes almost 2 full minutes. :-(
Yow. It's hard to believe that the actual commit (ie, flushing the
commit record to WAL) could take more than a fraction of a second.
I'm thinking there must be a pile of pr
Hi all,
i'm looking for correct or at least good enough solution for use of
multiple apaches with single postgres database. (apaches are 2.0.x, and
postgres is 8.1.x)
At this moment i'm involved in management of a website where we have
large user load on our web servers. Apaches are set up t
Hello,
I am having a strange latency problem on my instance of Postgres that
I don't know how to investigate.
I am accessing the db instance using a Java application and the
Cayenne mapping framework. Everything works fine, except when it is
time to delete a user account (that is a user of the ap
In article <[EMAIL PROTECTED]>,
Ron St-Pierre <[EMAIL PROTECTED]> writes:
>> For what it's worth NUMERIC columns take more space than you might expect.
>> Figure a minimum of 12 bytes your rows are at about 1.5k each even if the
>> non-numeric columns aren't large themselves. What are the other co
13 matches
Mail list logo