Hello Kevin, On Wed, Jan 30, 2013 at 12:09 AM, Kevin Grittner <kgri...@ymail.com> wrote: > Alexander Farber <alexander.far...@gmail.com> wrote: > >> update pref_users set medals = 0; >> UPDATE 223456 > > You're probably going to like your performance a lot better if you > modify that to: > > update pref_users set medals = 0 where medals <> 0;
is it really so? I only have 65 users (out of 223456) with medals != 0. When programming other languages, I never do if (x != 0) { x = 0; } but just set x = 0 straight away. Regards Alex -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general