X-Original-To: pgsql-bugs@postgresql.org Received: from spampd.localdomain (postgresql.org [64.49.215.8]) by postgresql.org (Postfix) with ESMTP id 928D4475B8E; Wed, 7 May 2003 11:37:01 -0400 (EDT) Received: from pns.mm.eutelsat.org (pns.mm.eutelsat.org [194.214.173.227]) by postgresql.org (Postfix) with ESMTP id C89E4476141; Wed, 7 May 2003 11:36:32 -0400 (EDT) Received: from nts-03.mm.eutelsat.org (localhost [127.0.0.1]) by pns.mm.eutelsat.org (8.11.6/linuxconf) with ESMTP id h47EbUi04881; Wed, 7 May 2003 16:37:30 +0200 Received: from GMENDOLA2 (gmendola2.mm.eutelsat.org [194.214.173.26]) by nts-03.mm.eutelsat.org (8.11.6/linuxconf) with SMTP id h47FY6R32321; Wed, 7 May 2003 17:34:06 +0200 Message-ID: <013301c314ae$6e1b6520$152aa8c0@GMENDOLA2> From: "Mendola Gaetano" To: "Achilleus Mantzios" , , , References: Subject: Re: [SQL] An unresolved performance problem. Date: Wed, 7 May 2003 17:36:29 +0200 MIME-Version: 1.0 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: 7bit X-Priority: 3 X-MSMail-Priority: Normal X-Mailer: Microsoft Outlook Express 6.00.2800.1158 x-mimeole: Produced By Microsoft MimeOLE V6.00.2800.1165 X-Spam-Status: No, hits=-16.1 required=5.0 tests=BAYES_10,QUOTED_EMAIL_TEXT,QUOTE_TWICE_1,REFERENCES autolearn=ham version=2.50 X-Spam-Level: X-Spam-Checker-Version: SpamAssassin 2.50 (1.173-2003-02-20-exp) X-Archive-Number: 200305/20 X-Sequence-Number: 5981 ----- Original Message ----- From: "Achilleus Mantzios" To: ; ; Sent: Wednesday, May 07, 2003 6:33 PM Subject: [SQL] An unresolved performance problem. > > Hi, few days ago, i posted some really wierd (at least to me) > situation (maybe a potentian bug) to the performance and bugs list > and to some core hacker(s) privately as well, > and i got no response. I seen around a lot of questions are remaining without any reply, may be in this period the guys like Tom Lane are too busy. > Moreover i asked for some feedback > in order to understand/fix the problem myself, > and again received no response. > > What i asked was pretty simple: > "1. Is it possible that the absense of statistics make the planer produce > better plans > than in the case of statistcs generated with vacuum > analyze/analyze? > 2. If No, i found a bug, > 3. If yes then under what conditions?? > 4. If no person knows the answer or no hacker wants to dig into the > problem then is there a direction i must follow to understand/fix whats > going on myself??"" Can you give us more informations? Like the table structure, wich kind of query are you tring to do and so on... Gaetano