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