From: Scott Marlowe <scott.marlowe@gmail.com>
To: olivier boissard <olivier.boissard@cerene.fr>
Cc: A.Burbello <burbello3000@yahoo.com.br>
Cc: pgsql-admin@postgresql.org
Subject: Re: improve performance in a big table
Date: Thu, 13 Dec 2007 12:04:47 -0600
Message-ID: <dcc563d10712131004m4d81b878ra6c5d7d5fb1e82e6@mail.gmail.com> (raw)
In-Reply-To: <47613061.9000004@cerene.fr>
References: <222808.5599.qm@web36215.mail.mud.yahoo.com>
<47613061.9000004@cerene.fr>
On Dec 13, 2007 7:15 AM, olivier boissard <olivier.boissard@cerene.fr> wrote:
> A.Burbello a écrit :
> > Hi people,
> >
> > I have a case and I got a doubt what should be the
> > best ways.
> >
> > One table has more than 150 million of rows, and I
> > thought that could divided by state.
> > For each row has person ID, state and other
> > informations, but the search would be done only by
> > person ID (number column).
> >
> > I can improve the query by putting index in that
> > column, but is there any other ways?
>
> I also studies how to improve performances on big tables.
> Like you , I don't know how to improve without index. It's the only way
> I found .
> I find postgresql is fast on small table but I got real performance
> problem when increases the number of rows
> Do anyone know if there is specific postgresql tuning parameters in
> .conf file for big tables ?
>
> max_fsm_pages ?
> max_fsm_relations ?
More often than not, the answer lies not in tuning but in rearranging
how you think of your data and how you create indexes.
If you guys post some schema and queries (with explain analyze) that
aren't running so fast, we'll try to help. although pgsql-perform is
the better place to do that.
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-admin@postgresql.org
Cc: scott.marlowe@gmail.com, olivier.boissard@cerene.fr, burbello3000@yahoo.com.br
Subject: Re: improve performance in a big table
In-Reply-To: <dcc563d10712131004m4d81b878ra6c5d7d5fb1e82e6@mail.gmail.com>
* 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