X-Original-To: pgsql-performance-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [200.46.204.144]) by svr1.postgresql.org (Postfix) with ESMTP id D68F7535CD for ; Tue, 29 Mar 2005 22:10:49 +0100 (BST) Received: from svr1.postgresql.org ([200.46.204.71]) by localhost (av.hub.org [200.46.204.144]) (amavisd-new, port 10024) with ESMTP id 93789-01 for ; Tue, 29 Mar 2005 21:10:45 +0000 (GMT) Received: from wproxy.gmail.com (wproxy.gmail.com [64.233.184.199]) by svr1.postgresql.org (Postfix) with ESMTP id F2E5F53603 for ; Tue, 29 Mar 2005 22:10:44 +0100 (BST) Received: by wproxy.gmail.com with SMTP id 68so733549wra for ; Tue, 29 Mar 2005 13:10:46 -0800 (PST) DomainKey-Signature: a=rsa-sha1; q=dns; c=nofws; s=beta; d=gmail.com; h=received:message-id:date:from:reply-to:to:subject:in-reply-to:mime-version:content-type:content-transfer-encoding:references; b=CQsMr81v/u3hpa/SunFXQPhYrM9/h59YPJ2DpWzE5/St7xxQFIbG9jpCl9W0dNaUNR/1/3U9tO7qnHT3AVg5f3G+BiB9gCmOkk/fUCvVt8lqaPP39vvl7JAIvgxwc9Kgj2lJKWQakZ0gs3EBLjpX3Y3uGCKd4sCTIg+LLd5G3Ek= Received: by 10.54.2.72 with SMTP id 72mr66818wrb; Tue, 29 Mar 2005 13:10:45 -0800 (PST) Received: by 10.54.54.69 with HTTP; Tue, 29 Mar 2005 13:10:44 -0800 (PST) Message-ID: Date: Tue, 29 Mar 2005 18:10:44 -0300 From: Vinicius Bernardi Reply-To: Vinicius Bernardi To: pgsql-performance@postgresql.org Subject: Re: Million of rows In-Reply-To: <20050329190815.GA15447@winnie.fuhr.org> Mime-Version: 1.0 Content-Type: text/plain; charset=ISO-8859-1 Content-Transfer-Encoding: 7bit References: <20050329190815.GA15447@winnie.fuhr.org> X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, hits=0.304 tagged_above=0 required=5 tests=AWL, DNS_FROM_RFC_ABUSE, RCVD_BY_IP X-Spam-Level: X-Archive-Number: 200503/645 X-Sequence-Number: 11350 At now I have this system runing in a mysql, all the examples I have are in mysql, but the biggest client that will start now, we will use PostgreSQL, so I need a way to do those questions in postgres... Ideas like TABLESPACES or anothe things... Just looking for start ideas... Thanks Vinicius Marques De Bernardi On Tue, 29 Mar 2005 12:08:15 -0700, Michael Fuhr wrote: > On Tue, Mar 29, 2005 at 03:33:24PM -0300, Vinicius Bernardi wrote: > > > > But now the problem starts when I has to select data from this > > vehicles about the history ( I store only 2 months ) something like 40 > > or 50 millions of data about 500 vehicles. > > > > Using the keys VEHICLE_ID and GPS_TIME, the perfomance is very low... > > Please post an example query and the EXPLAIN ANALYZE output. The > table definition might be useful too. > > > I need some ideas for a better perfomance in this table > > Do you have indexes where you need them? Do you cluster on any of > the indexes? Do you VACUUM and ANALYZE the database regularly? > Have you investigated whether you need to increase the statistics > on any columns? Have you tuned postgresql.conf? What version of > PostgreSQL are you using? > > -- > Michael Fuhr > http://www.fuhr.org/~mfuhr/ >