Postgres Pro
Downloads
Home   >   mailing lists

Re: Handling large volumes of data - Mailing list pgsql-admin

From Shoaib Mir
Subject Re: Handling large volumes of data
Date
Msg-id bf54be870804080249lf3252b8xb1547ce46a3258bc@mail.gmail.com
Whole thread Raw
In response to Handling large volumes of data  (Johann Spies <jspies@sun.ac.za>)
List pgsql-admin
Tree view


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

pgsql-admin by date:

Previous
From: Johann Spies
Date:
Subject: Handling large volumes of data
Next
From: Tino Schwarze
Date:
Subject: Re: Handling large volumes of data