pg.ddx.io  pgsql-performance@postgresql.org mailing list archive  

help / color / mirror / Atom feed

Indexed views.
3+ messages / 3 participants
[nested] [flat]

* Indexed views.
@ 2005-08-04 08:24  prasanna s <pingbaghu@gmail.com>
  0 siblings, 2 replies; 3+ messages in thread

From: prasanna s @ 2005-08-04 08:24 UTC (permalink / raw)
  To: pgsql-performance

Does postgres support indexed views/materialised views that some of the 
other databases support?

Thanks
Prasanna S

^ permalink  raw  reply  [nested|flat] 3+ messages in thread

* Re: Indexed views.
@ 2005-08-04 08:37  Christopher Kings-Lynne <chriskl@familyhealth.com.au>
  parent: prasanna s <pingbaghu@gmail.com>
  1 sibling, 0 replies; 3+ messages in thread

From: Christopher Kings-Lynne @ 2005-08-04 08:37 UTC (permalink / raw)
  To: prasanna s <pingbaghu@gmail.com>; +Cc: pgsql-performance

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




^ permalink  raw  reply  [nested|flat] 3+ messages in thread

* Re: Indexed views.
@ 2005-08-04 08:52  Laszlo Hornyak <kocka@forgeahead.hu>
  parent: prasanna s <pingbaghu@gmail.com>
  1 sibling, 0 replies; 3+ messages in thread

From: Laszlo Hornyak @ 2005-08-04 08:52 UTC (permalink / raw)
  To: pgsql-performance

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






^ permalink  raw  reply  [nested|flat] 3+ messages in thread

end of thread, other threads:[~2005-08-04 08:52 UTC | newest]

Thread overview: 3+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2005-08-04 08:24 Indexed views. prasanna s <pingbaghu@gmail.com>
2005-08-04 08:37 ` Christopher Kings-Lynne <chriskl@familyhealth.com.au>
2005-08-04 08:52 ` Laszlo Hornyak <kocka@forgeahead.hu>

This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox