Re: vacuum, performance, and MVCC - Mailing list pgsql-hackers

From Christopher Kings-Lynne
Subject Re: vacuum, performance, and MVCC
Date
Msg-id 449B4A40.80106@calorieking.com
Whole thread Raw
In response to Re: vacuum, performance, and MVCC  ("Mark Woodward" <pgsql@mohawksoft.com>)
Responses Re: vacuum, performance, and MVCC  (Agent M <agentm@themactionfaction.com>)
Re: vacuum, performance, and MVCC  ("Mark Woodward" <pgsql@mohawksoft.com>)
List 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



pgsql-hackers by date:

Previous
From: Tom Lane
Date:
Subject: Re: Going for "all green" buildfarm results
Next
From: Tom Lane
Date:
Subject: Re: [CORE] GPL Source and Copyright Questions