Étiquette : sql

Postgresql : How to add an index on a computed column

Postgresql offers a great way to add computed column, but do you know there is a way to index those columns ?   CREATE INDEX your_table_ix ON your_table USING btree (computed_column_name(your_table.*)   Notice that the computed column has to be

Publié dans postgresql, sql Tagués avec : ,

reset pgagent jobs

Here is the brutal method to reset jobs from a restart fails of postgresql pgAgent delete from pgAgent.pga_jobagent; delete from pgAgent.pga_joblog; delete from pgAgent.pga_jobsteplog;

Publié dans sql Tagués avec : ,