Re: Optimizing select count query which often takes over 10 seconds

From: Alexander Farber <alexander(dot)farber(at)gmail(dot)com>
To:
Cc: pgsql-general <pgsql-general(at)postgresql(dot)org>
Subject: Re: Optimizing select count query which often takes over 10 seconds
Date: 2013-01-31 09:01:14
Message-ID: CAADeyWjtd8P6USe4kY-QFuWwggyw=pceQxeS5Ftguq-L7cuwPw@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

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

Thank you all for your insightful comments

This has cured my cronjob

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Neil Worden 2013-01-31 09:48:03 Re: naming of wal-archives
Previous Message Neil Worden 2013-01-31 08:50:34 Re: naming of wal-archives