Received: from newmail.DKFZ-Heidelberg.DE (newmail.inet.dkfz-heidelberg.de [193.174.53.39]) by postgresql.org (8.11.3/8.11.4) with ESMTP id fA1G84P52608 for ; Thu, 1 Nov 2001 11:08:04 -0500 (EST) (envelope-from d.richter@dkfz-heidelberg.de) Received: from perkeo.inet.dkfz-heidelberg.de (perkeo.inet.dkfz-heidelberg.de [193.174.61.66]) by newmail.DKFZ-Heidelberg.DE (8.9.3/8.9.3/DKFZ-8.9.3) with ESMTP id RAA18236; Thu, 1 Nov 2001 17:07:59 +0100 (MET) Received: from dkfz.de (perkeo.inet.dkfz-heidelberg.de [193.174.61.66]) by perkeo.inet.dkfz-heidelberg.de (980427.SGI.8.8.8/DKFZ-8.6.4) with ESMTP id RAA27404; Thu, 1 Nov 2001 17:08:00 +0100 (MET) Message-ID: <3BE17360.42511BD1@dkfz.de> Date: Thu, 01 Nov 2001 17:08:00 +0100 From: "David M. Richter" Organization: German Cancer Research Center X-Mailer: Mozilla 4.7 [en] (X11; I; IRIX64 6.4 IP27) X-Accept-Language: en MIME-Version: 1.0 To: Tom Lane CC: "David M. Richter" , pgsql-sql@postgresql.org Subject: Re: View consistency References: <3BE15A2F.B0CDF610@dkfz.de> <21914.1004629690@sss.pgh.pa.us> Content-Type: multipart/mixed; boundary="------------EDC966C04C28567424574C41" X-Archive-Number: 200111/45 X-Sequence-Number: 5429 This is a multi-part message in MIME format. --------------EDC966C04C28567424574C41 Content-Type: text/plain; charset=us-ascii Content-Transfer-Encoding: 7bit Hi, Thanks, but what I am concerning is the performance. In my database are some tables bigger than 6 Millions of rows. If one row has been changed in the normal table, so the rule will be invoked and the view will be kept in consistance. But this will take some time, isn't it? I cannot simulate that case with my database, because Im still developing. So i have to know: Where is the rule or the macro stored? How could I disable it? Perhaps I could do a reinit of the view not after any Select, but after any transaction. But I dont know that rule or macro! How can I get some information about the rule (wich was automatically generated by creating the view)? Thanks for Your hints DAvid --------------------------------------------------------------- "David M. Richter" writes: > How does postgres keep the views consistent to the according tables( if > the original table has been changed)? It doesn't have to; views are not materialized in Postgres. A view is just a rewrite rule, or macro. regards, tom lane --------------EDC966C04C28567424574C41 Content-Type: text/x-vcard; charset=us-ascii; name="d.richter.vcf" Content-Transfer-Encoding: 7bit Content-Description: Card for David M. Richter Content-Disposition: attachment; filename="d.richter.vcf" begin:vcard url;quoted-printable:http://mbi.DKFZ-Heidelberg.de/=0D=0A n:M. Richter;David x-mozilla-html:FALSE org:Deutsches Krebsforschungszentrum/German Cancer Research Center;Division Medizinische und Biologische Informatik version:2.1 email;internet:d.richter@dkfz-heidelberg.de adr;quoted-printable:;;Im Neuenheimer Feld 280 url: http://mbi.DKFZ-Heidelberg.de/=0D=0AD-69120 Heidelberg, Germany ;Heidelberg;Germany;; x-mozilla-cpt:;-17024 fn:David M. Richter end:vcard --------------EDC966C04C28567424574C41--