pg.ddx.io  pgsql-performance@postgresql.org mailing list archive  
help / color / mirror / Atom feed
From: Michael Fuhr <mike@fuhr.org>
To: Vinicius Bernardi <vinicius.bernardi@gmail.com>
Cc: pgsql-performance@postgresql.org
Subject: Re: Million of rows
Date: Tue, 29 Mar 2005 12:08:15 -0700
Message-ID: <20050329190815.GA15447@winnie.fuhr.org> (raw)
In-Reply-To: <b30adfa205032910335a467c12@mail.gmail.com>
References: <b30adfa205032910335a467c12@mail.gmail.com>

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/



view thread (3+ messages)  latest in thread

Message-ID: <20050329190815.GA15447@winnie.fuhr.org>
Permalink:  ../20050329190815.GA15447@winnie.fuhr.org/
Also on:    postgresql.org/message-id/20050329190815.GA15447@winnie.fuhr.org

 · 

reply

Reply instructions:

You may reply publicly to this message via plain-text email
using any one of the following methods:

* Reply to all the recipients using the --to and --cc options:
  reply via email

  To: pgsql-performance@postgresql.org
  Cc: mike@fuhr.org, vinicius.bernardi@gmail.com
  Subject: Re: Million of rows
  In-Reply-To: <20050329190815.GA15447@winnie.fuhr.org>

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox