Re: vacuum, performance, and MVCC

From: Christopher Kings-Lynne <chris(dot)kings-lynne(at)calorieking(dot)com>
To: Mark Woodward <pgsql(at)mohawksoft(dot)com>
Cc: Rod Taylor <pg(at)rbt(dot)ca>, Hannu Krosing <hannu(at)skype(dot)net>, Christopher Browne <cbbrowne(at)acm(dot)org>, pgsql-hackers(at)postgresql(dot)org
Subject: Re: vacuum, performance, and MVCC
Date: 2006-06-23 01:56:16
Message-ID: 449B4A40.80106@calorieking.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

> The example is a very active web site, the flow is this:
>
> query for session information
> process HTTP request
> update session information
>
> This happens for EVERY http request. Chances are that you won't have
> concurrent requests for the same row, but you may have well over 100 HTTP
> server processes/threads answering queries in your web server farm.

You're crazy :) Use memcache, not the DB :)

Chris

In response to

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Steve Atkins 2006-06-23 02:08:48 Re: vacuum, performance, and MVCC
Previous Message Agent M 2006-06-23 01:56:12 Re: vacuum, performance, and MVCC