|
|
|
|
|
|
by fulafel
2351 days ago
|
|
|
Like you said, not easy: Recreating the functionality of views using triggers is error prone and a heavy maintenance burden, and the triggers have to be implemented differently based on what each query is like... In a lot of cases it's better to just optimize the query and indexing. In PG you can make a lot of queries run straight from one index if you tailor an index to a query, since you can index your own plpgsql functions. |
|
|