Postgres Pro
Downloads
Home   >   mailing lists

Re: Optimizing select count query which often takes over 10 seconds - Mailing list pgsql-general

From Alexander Farber
Subject Re: Optimizing select count query which often takes over 10 seconds
Date
Msg-id CAADeyWjtd8P6USe4kY-QFuWwggyw=pceQxeS5Ftguq-L7cuwPw@mail.gmail.com
Whole thread Raw
In response to Re: Optimizing select count query which often takes over 10 seconds  (Kevin Grittner <kgrittn@ymail.com>)
List pgsql-general
Tree view 
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

pgsql-general by date:

Previous
From: Neil Worden
Date:
Subject: Re: naming of wal-archives
Next
From: Neil Worden
Date:
Subject: Re: naming of wal-archives