Re: Restricting Postgres

From: Martin Foster <martin(at)ethereal-realms(dot)org>
To: pgsql-performance(at)postgresql(dot)org
Subject: Re: Restricting Postgres
Date: 2004-11-05 02:49:42
Message-ID: aTBid.57485$E93.26193@clgrps12
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general pgsql-performance

Matt Clark wrote:

>
>
> Pierre-Frédéric Caillaud wrote:
>
>>
>> check this marvelus piece of 5 minutes of work :
>> http://boutiquenumerique.com/test/iframe_feed.html
>>
> cela m'a fait le sourire :-)
>
> (apologies for bad french)
>
> M
>
>

Javascript is not an option for the scripts, one of the mandates of the
project is to support as many different client setups as possible and we
have encountered everything from WebTV to the latest Firefox release.
It's a chat/roleplay community and not everyone will invest in new
equipment.

Now, it would seem to me that there is a trade off between a JS push
system and a constant ever-present process. With the traditional
method as I use it, a client will incur the initial penalty of going
through authentication, pulling the look and feel of the realms, sites
and simply poll one table from that point on.

Now on the other hand, you have one user making a call for new posts
every x amount of seconds. This means every X seconds the penalty for
authentication and design would kick in, increasing overall the load.

The current scripts can also by dynamically adapted to slow things down
based on heavy load or quiet realms that bring little posts in. It's
much harder to expect Javascript solutions to work perfectly every time
and not be modified by some proxy.

Unfortunately, we are getting way off track. I'm looking for a way to
protect the PostgreSQL server, either from PostgreSQL or some sort of
external script which pools load average once in a while to make that
determination.

Now is there an administrative command in PostgreSQL that will cause it
to move into some sort of maintenance mode? For me that could be
exceedingly useful as it would still allow for an admin connection to be
made and run a VACUUM FULL and such.

Martin Foster
Creator/Designer Ethereal Realms
martin(at)ethereal-realms(dot)org

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Rob Kelk 2004-11-05 03:17:12 Re: RFD: comp.databases.postgresql.general
Previous Message Mike Cox 2004-11-05 02:10:36 Making this group a part of the official comp.* hierarchy.

Browse pgsql-performance by date

  From Date Subject
Next Message Neil Conway 2004-11-05 04:28:39 Re: Anything to be gained from a 'Postgres Filesystem'?
Previous Message Christopher Browne 2004-11-05 02:29:04 Re: Anything to be gained from a 'Postgres Filesystem'?