pg.ddx.io  pgsql-admin@postgresql.org mailing list archive  
help / color / mirror / Atom feed
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

view thread (10+ messages)  latest in thread

Message-ID: <bf54be870804080249lf3252b8xb1547ce46a3258bc@mail.gmail.com>
Permalink:  ../bf54be870804080249lf3252b8xb1547ce46a3258bc@mail.gmail.com/
Also on:    postgresql.org/message-id/bf54be870804080249lf3252b8xb1547ce46a3258bc@mail.gmail.com

 · 

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-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