DSource

[Kyle Furlong]

Brad Anderson wrote:
> Jari-Matti Mäkelä wrote:
>> Is there a
>> good reason to use Postgres in the first place?
>>
> 
> I was getting ready for Digg-type traffic, and I have seen Trac db's stored in
> SQLite lock during write (yes, the whole db locks).  So I chose Postgres.  I
> have heard of using one database and separating the Trac tables for a project
> into different schemas - the problem that was observed separate of dsource's
> actually went away doing this.  This is a big task and I don't have a lot of
> time right now.  A few weeks ago when I had some time, the problem wasn't as
> pronounced...  Murphy.
> 
> I have tried some settings in postgresql.conf to limit connection time-outs
> and they're not working yet.
> 
> Plus, I didn't see nearly the traffic Walter talks about getting on his site,
> because the link to dsource is reasonably obscure.  Some of that lack of
> traffic was the brief periods when we were down, but I would have seen hits in
> the logs, just with errors.
> 
> Also, we weren't down for an entire week as the OP suggests.  Apache resets
> itself, so we were down no longer than 2 hours at a time, and then were fine
> for most likely 12 hrs, until it happened again.
> 
> BA

I guess I got unlucky in that every time I looked in on the site in the 
past week it was down.