Postgres Pro
Downloads
Home   >   mailing lists

Re: question on most efficient way to increment a column - Mailing list pgsql-general

From Alban Hertroys
Subject Re: question on most efficient way to increment a column
Date
Msg-id 7FAB13E7-78F2-47E2-B803-865A7D2BF7CD@gmail.com
Whole thread Raw
In response to Re: question on most efficient way to increment a column  (Tyson Maly <tvmaly@yahoo.com>)
List pgsql-general
Tree view

On May 8, 2013, at 21:14, Tyson Maly <tvmaly@yahoo.com> wrote:

The simple update is one I considered, but I think if I put it into a stored procedure it should run faster


Well, you would partially circumvent the query planner, but you would also circumvent any optimisation said query planner would be able to do based on the statistics for the values being updated.

Alban Hertroys
--
If you can't see the forest for the trees,
cut the trees and you'll find there is no forest.

pgsql-general by date:

Previous
From: Jon Smark
Date:
Subject: Normal errors codes in serializable transactions
Next
From: Tatsuo Ishii
Date:
Subject: Re: Normal errors codes in serializable transactions