Re: High update activity, PostgreSQL vs BigDBMS - Mailing list pgsql-performance

From Craig A. James
Subject Re: High update activity, PostgreSQL vs BigDBMS
Date
Msg-id 45A188AF.5070006@modgraph-usa.com
Whole thread Raw
In response to Re: High update activity, PostgreSQL vs BigDBMS  ("Craig A. James" <cjames@modgraph-usa.com>)
Responses Re: High update activity, PostgreSQL vs BigDBMS
List 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

pgsql-performance by date:

Previous
From: Ben
Date:
Subject: tweaking under repeatable load
Next
From: "Adam Rich"
Date:
Subject: Re: High update activity, PostgreSQL vs BigDBMS