>> >>> 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. >> >> Thanks. >> >> > 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. -- Sent via pgsql-performance mailing list (pgsql-performance@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-performance
