Re: Performance Bottleneck - Mailing list pgsql-performance

From Pierre-Frédéric Caillaud
Subject Re: Performance Bottleneck
Date
Msg-id opsb8x5xk3cq72hf@musicbox
Whole thread Raw
In response to Re: Performance Bottleneck  (Martin Foster <martin@ethereal-realms.org>)
Responses Re: Performance Bottleneck  ("Steinar H. Gunderson" <sgunderson@bigfoot.com>)
List pgsql-performance
    Apache processes running for 30 minutes ?.....

    My advice : use frames and Javascript !

    In your webpage, you have two frames : "content" and "refresh".

    "content" starts empty (say, just a title on top of the page).
    "refresh" is refreshed every five seconds from a script on your server.
This script generates a javascript which "document.write()'s" new entries
in the "content" frame, thus adding new records in the upper frame.

    Thus, the refreshing uses a new request every 5 seconds, which terminates
very fast, and does not hog an Apache process.

    Turn keepalive timeout down.

pgsql-performance by date:

Previous
From: Martin Foster
Date:
Subject: Re: Performance Bottleneck
Next
From: Valerie Schneider DSI/DEV
Date:
Subject: Re: [GENERAL] Tuning queries on large database