| From: | Gavin Sherry <swm(at)alcove(dot)com(dot)au> |
|---|---|
| To: | Brian Hurt <bhurt(at)janestcapital(dot)com> |
| Cc: | pgsql-performance(at)postgresql(dot)org |
| Subject: | Re: Postgres and really huge tables |
| Date: | 2007-01-18 23:09:57 |
| Message-ID: | Pine.LNX.4.58.0701191006530.3671@linuxworld.com.au |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-advocacy pgsql-performance |
Hi Brian,
On Thu, 18 Jan 2007, Brian Hurt wrote:
> Is there any experience with Postgresql and really huge tables? I'm
> talking about terabytes (plural) here in a single table. Obviously the
> table will be partitioned, and probably spread among several different
> file systems. Any other tricks I should know about?
Here is a blog post from a user who is in the multi-tb range:
http://www.lethargy.org/~jesus/archives/49-PostreSQL-swelling.html
I think Theo sums up some of the pros and cons well.
Your best bet is a test on scale. Be sure to get our feed back if you
encounter issues.
Gavin
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Denis Lussier | 2007-01-19 05:09:40 | EnterpriseDB Apology |
| Previous Message | Luke Lonergan | 2007-01-18 22:41:30 | Re: Postgres and really huge tables |
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Arjen van der Meijden | 2007-01-19 06:15:12 | Re: Configuration Advice |
| Previous Message | Luke Lonergan | 2007-01-18 22:41:30 | Re: Postgres and really huge tables |