Received: from news.tht.net (news.hub.org [216.126.91.242]) by postgresql.org (8.11.3/8.11.1) with ESMTP id f6OFVXf62924 for ; Tue, 24 Jul 2001 11:31:33 -0400 (EDT) (envelope-from news@news.tht.net) Received: (from news@localhost) by news.tht.net (8.11.4/8.11.4) id f6OFR5Y82581 for pgsql-sql@postgresql.org; Tue, 24 Jul 2001 11:27:05 -0400 (EDT) (envelope-from news) From: "David M. Richter" X-Newsgroups: comp.databases.postgresql.sql Subject: Re: Query optimizing - paradox behave Date: Tue, 24 Jul 2001 17:24:46 +0200 Organization: German Cancer Research Center Lines: 42 Message-ID: <3B5D933E.A1A12DAA@freenet.de> References: Mime-Version: 1.0 Content-Type: multipart/mixed; boundary="------------9397BBC33A599633882B4E4B" X-Complaints-To: scrappy@hub.org To: Stephan Szabo X-Mailer: Mozilla 4.7 [en] (X11; I; IRIX64 6.4 IP27) X-Accept-Language: en To: pgsql-sql@postgresql.org X-Archive-Number: 200107/329 X-Sequence-Number: 4142 This is a multi-part message in MIME format. --------------9397BBC33A599633882B4E4B Content-Type: text/plain; charset=us-ascii Content-Transfer-Encoding: 7bit Hallo Stephan! Are there several versions of dbPG95GetIndex existing, or did you mention postgres version 7.1.2? With a little help I have killed the Problem!! Yeah, But now I trying to improve the C-code. Do You have any experience with optimizing C-Code. Are there some new miracle-like function, wich improves the speed dramatically? Do You know some database options wich I could change for better performance? Thanks a lot for Your suggestions!! David >What version are you using? (dbPG95GetIndex?) --------------9397BBC33A599633882B4E4B Content-Type: text/x-vcard; charset=us-ascii; name="David.M.Richter.vcf" Content-Transfer-Encoding: 7bit Content-Description: Card for David M. Richter Content-Disposition: attachment; filename="David.M.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;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:;-15296 fn:David M. Richter end:vcard --------------9397BBC33A599633882B4E4B--