[prev in list] [next in list] [prev in thread] [next in thread] 

List:       postgresql-general
Subject:    Re: [GENERAL] Optimizing select count query which often takes over 10 seconds
From:       Alexander Farber <alexander.farber () gmail ! com>
Date:       2013-01-31 9:01:14
Message-ID: CAADeyWjtd8P6USe4kY-QFuWwggyw=pceQxeS5Ftguq-L7cuwPw () mail ! gmail ! com
[Download RAW message or body]

On Wed, Jan 30, 2013 at 2:06 PM, Kevin Grittner <kgrittn@ymail.com> wrote:
> update pref_users set medals = 0 where medals <> 0;

Thank you all for your insightful comments

This has cured my cronjob


-- 
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
[prev in list] [next in list] [prev in thread] [next in thread]