Received: from zenon.apartia.com (APoncelet-101-2-1-171.abo.wanadoo.fr [193.251.42.171]) by postgresql.org (8.11.3/8.11.4) with ESMTP id g0BEI7B24967 for ; Fri, 11 Jan 2002 09:18:08 -0500 (EST) (envelope-from isabelle@apartia.fr) Received: from localhost (argos.apartia.int [10.0.2.1]) by zenon.apartia.com (Postfix) with SMTP id F3E7B638F4; Fri, 11 Jan 2002 15:18:05 +0100 (CET) Received: by localhost (sSMTP sendmail emulation); Fri, 11 Jan 2002 15:17:20 +0100 Date: Fri, 11 Jan 2002 15:17:20 +0100 From: Isabelle Brette To: Gurudutt Cc: pgsql-sql@postgresql.org Subject: Re: Resources Message-ID: <20020111151720.A1754@aparima.com> X-Archive-Number: 200201/84 X-Sequence-Number: 6174 Hello, I just looked at your tables/queries/explains. My piece of advice would be : add indexes on the columns you use the most in the query (especially those used for joins). A "seq scan" takes quite a time, an "index scan" takes nearly no time. Well, indexes take a little space, but if your database is not that big, it should be what you're looking for. Disk space does not cost that much these times ^^ -- Isabelle Brette - isabelle@apartia.fr