Received: from news.tht.net (news.hub.org [216.126.91.242]) by postgresql.org (8.11.3/8.11.4) with ESMTP id fB7G9Bm85903 for ; Fri, 7 Dec 2001 11:09:11 -0500 (EST) (envelope-from news@news.tht.net) Received: (from news@localhost) by news.tht.net (8.11.4/8.11.4) id fB7FeIO40968 for pgsql-sql@postgresql.org; Fri, 7 Dec 2001 10:40:18 -0500 (EST) (envelope-from news) From: "David M. Richter" X-Newsgroups: comp.databases.postgresql.sql Subject: Vacuum analyze decreases speed Date: Fri, 07 Dec 2001 16:39:51 +0100 Organization: German Cancer Research Center Lines: 61 Message-ID: <3C10E2C7.BA8D361D@dkfz.de> Mime-Version: 1.0 Content-Type: multipart/mixed; boundary="------------A4EBC4871B9D93E035F7D91B" X-Complaints-To: scrappy@hub.org X-Mailer: Mozilla 4.7 [en] (X11; I; IRIX64 6.4 IP27) X-Accept-Language: en To: pgsql-sql@postgresql.org X-Archive-Number: 200112/89 X-Sequence-Number: 5912 This is a multi-part message in MIME format. --------------A4EBC4871B9D93E035F7D91B Content-Type: text/plain; charset=us-ascii Content-Transfer-Encoding: 7bit Hello! We have postgresql 6.5.3 There is running a big database, the biggest table takes 1 Gigabayte place. We used vacuum every night, but without analyze. So we decided, according of the suggestions of all the books , to make a vacuum analyze. Now, the speed is down. Not usable! We recreated all the index. Nothing better! We cannot update to 7.1x at a short time (means now, but is planed) because this is a medical radiology database in heavy use. Maybe at a later time. What is vacuum analyze exactly doing? Where ist the statistic made by analyze stored? So I could just delete it and make a normal vacuum without analyze to get the old state of the database? How can I redo that analyze to get the old state of the database? I cannot give You an exact query. it doesnt matter, all queries are slower than before. # Did you have experienced the same? Any suggestions? Thanks in advance David --------------A4EBC4871B9D93E035F7D91B 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 --------------A4EBC4871B9D93E035F7D91B--