From: Shoaib Mir <shoaibmir@gmail.com>
To: Johann Spies <jspies@sun.ac.za>
To: pgsql-admin@postgresql.org
Subject: Re: Handling large volumes of data
Date: Tue, 8 Apr 2008 19:49:04 +1000
Message-ID: <bf54be870804080249lf3252b8xb1547ce46a3258bc@mail.gmail.com> (raw)
In-Reply-To: <20080408094233.GG13409@sun.ac.za>
References: <20080408094233.GG13409@sun.ac.za>
On Tue, Apr 8, 2008 at 7:42 PM, Johann Spies <jspies@sun.ac.za> wrote:
> Apparently the best approach is not to have very large tables. I am
> thinking of making (as far as the firewall is concerned) a different
> table for each day and then drop the older tables as necessary.
>
> Any advice on how to best handle this kind of setup will be
> appreciated.
>
>
Table paritioning is what you need -->
http://www.postgresql.org/docs/current/static/ddl-partitioning.html and then
I will also advise distribute your tables across different disks through
tablespaces. Tweak the shared buffers and work_mem settings as well.
--
Shoaib Mir
Fujitsu Australia Software Technology
shoaibm@fast.fujitsu.com.au
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: shoaibmir@gmail.com, jspies@sun.ac.za
Subject: Re: Handling large volumes of data
In-Reply-To: <bf54be870804080249lf3252b8xb1547ce46a3258bc@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