Re: [PERFORM] Indexed views.

2005-08-04 Thread Laszlo Hornyak
prasanna s wrote: Does postgres support indexed views/materialised views that some of the other databases support? Thanks Prasanna S Hi! It is not supported, but perhaps this will help you: http://www.varlena.com/varlena/GeneralBits/Tidbits/matviews.html ---(en

Re: [PERFORM] Indexed views.

2005-08-04 Thread Christopher Kings-Lynne
No, unless you use some custom triggers. prasanna s wrote: Does postgres support indexed views/materialised views that some of the other databases support? Thanks Prasanna S ---(end of broadcast)--- TIP 2: Don't 'kill -9' the postmaster