>>> In our application we defer the updates to a separate asynchronous
>>> process using a simple queue mechanism, but in our case, we found that
>>> the updates are fast enough (in the order of a few milliseconds) not
>>> to warrant batching them into single transactions.
>> A few milliseconds would be cool.
>> In fact, defering to another process is a good idea, but I'm not sure if
>> it is easy to implement. It would be great to have some sort of UPDATE
>> ... LOW PRIORITY to make the request non blocking.
> I use pg_send_query()
> <http://ca2.php.net/manual/en/function.pg-send-query.php> in php to
> achieve this for a views counter. "Script execution is not blocked while
> the queries are executing."
> It looks like this may just be a direct translation of PQsendQuery()
> from libpq. Your preferred language may have a function like this.
I am using PHP. That was one of the thing I was looking for, thank you! :)
We'll combine this with a memcached solution so we just update every
1000 views for example.
In response to
pgsql-performance by date
|Next:||From: Albe Laurenz||Date: 2009-06-24 08:32:19|
|Subject: Re: Implications of having large number of users|
|Previous:||From: Mathieu Nebra||Date: 2009-06-24 07:42:30|
|Subject: Re: How would you store read/unread topic status?|