Re: High update activity, PostgreSQL vs BigDBMS

From: "Craig A(dot) James" <cjames(at)modgraph-usa(dot)com>
To: Guy Rouillier <guyr-ml1(at)burntmail(dot)com>, PostgreSQL Performance <pgsql-performance(at)postgresql(dot)org>
Subject: Re: High update activity, PostgreSQL vs BigDBMS
Date: 2007-01-07 23:56:31
Message-ID: 45A188AF.5070006@modgraph-usa.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-performance

Craig A. James wrote:
> The "idiom" to replace count() was
> "select col from tbl order by col desc limit 1". It worked miracles for
> my app.

Sorry, I meant to write, "the idiom to replace MAX()", not count()... MAX() was the function that was killing me, 'tho count() also gave me problems.

Craig

In response to

Responses

Browse pgsql-performance by date

  From Date Subject
Next Message Adam Rich 2007-01-08 02:26:29 Re: High update activity, PostgreSQL vs BigDBMS
Previous Message Ben 2007-01-07 19:03:50 tweaking under repeatable load