X-Original-To: pgsql-performance-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [64.117.224.130]) by svr1.postgresql.org (Postfix) with ESMTP id 12A22D1B510 for ; Fri, 26 Sep 2003 10:58:25 +0000 (GMT) Received: from svr1.postgresql.org ([64.117.224.193]) by localhost (neptune.hub.org [64.117.224.130]) (amavisd-new, port 10024) with ESMTP id 76988-09 for ; Fri, 26 Sep 2003 07:57:55 -0300 (ADT) Received: from smtp2.dei.uc.pt (smtp2.dei.uc.pt [193.137.203.229]) by svr1.postgresql.org (Postfix) with ESMTP id 752FAD1B52B for ; Fri, 26 Sep 2003 07:57:45 -0300 (ADT) Received: from student.dei.uc.pt (student.dei.uc.pt [10.1.0.1]) by smtp2.dei.uc.pt (8.11.7/8.11.7) with ESMTP id h8QAwDP16343 for ; Fri, 26 Sep 2003 11:58:13 +0100 Received: from Debug (mail.dei.uc.pt [193.137.203.250]) by student.dei.uc.pt (8.12.8/8.12.8) with SMTP id h8QAvSXA009541 for ; Fri, 26 Sep 2003 11:57:28 +0100 Message-Id: <200309261057.h8QAvSXA009541@student.dei.uc.pt> To: pgsql-performance@postgresql.org From: rantunes@student.dei.uc.pt Subject: Re: Indices arent being used Date: Fri, 26 Sep 2003 10:57:28 GMT X-Mailer: Endymion MailMan Standard Edition v3.0.33 X-UC-DEI-MailScanner-Information: Please contact helpdesk@dei.uc.pt for more information X-UC-DEI-MailScanner: Found to be clean X-Virus-Scanned: by amavisd-new at postgresql.org X-Archive-Number: 200309/330 X-Sequence-Number: 3696 >Damn.. Seq. scan for actvars? I would say half an hour is a good throughput. > >Are there any indexes on both actvars.product_level and prodlevel.code_level? Are >they exactly compatible type? int2 and int4 are not compatible in postgresql >lingo. > >That plan should go for index scan. Can you show us the table definitions? > >And yes, what tuning you did to postgresql? > >Shridhar The alterations done upon postgresql.conf with 512 RAM were these: max_connections = 3 shared_buffers = 6000 wal_buffers = 32 sort_mem = 2048 fsync = false effective_cache_size = 44800 random_page_cost = 3 default_statistics_target = 50 Yes I have an index on actvars.product_level and an index on prodlevel.code_level.Both indices have character(12) data types. --------------------------------------------- This message was sent using Endymion MailMan. http://www.endymion.com/products/mailman/