Search Postgresql Archives

Re: Odd query result

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



On 08/27/2012 12:47 PM, Sergey Konoplev wrote:
On Mon, Aug 27, 2012 at 2:37 PM, Georges Racinet<gracinet@xxxxxxxxx>  wrote:
I guess one must also reindex in case some record changes as well, right ?
Through a trigger maybe ?

You do not need to reindex it in case of record changes. The index
values will be recalculated automatically after committing the
changes.


I see, the fact that it's computed through a function is no exception to that.

Thank you for the clarification,

--
Georges Racinet
Anybox SAS, http://anybox.fr
Bureau: 09 53 53 72 97 Portable: 06 51 32 07 27
GPG: 0x33AB0A35, sur serveurs publics




--
Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general


[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Index of Archives]     [Postgresql Jobs]     [Postgresql Admin]     [Postgresql Performance]     [Linux Clusters]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Books]     [PHP Databases]     [Postgresql & PHP]     [Yosemite]
  Powered by Linux