Re: large dataset with write vs read clients

From: Florian Weimer <fw(at)deneb(dot)enyo(dot)de>
To: Greg Smith <greg(at)2ndquadrant(dot)com>
Cc: Aaron Turner <synfinatic(at)gmail(dot)com>, pgsql-performance <pgsql-performance(at)postgresql(dot)org>
Subject: Re: large dataset with write vs read clients
Date: 2010-10-09 20:45:47
Message-ID: 87ocb3yu10.fsf@mid.deneb.enyo.de
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-performance

* Greg Smith:

> Given the size of your database, I'd advise you consider a migration
> to a new version ASAP. 8.4 is a nice stable release at this point,
> that's the one to consider moving to.

It also offers asynchronous commits, which might be a good tradeoff
here (especially if the data gathered is not used for billing purposes
8-).

In response to

Responses

Browse pgsql-performance by date

  From Date Subject
Next Message Mladen Gogala 2010-10-09 21:35:02 Re: large dataset with write vs read clients
Previous Message Ben Chobot 2010-10-08 18:08:21 Re: BBU Cache vs. spindles