Re: [PERFORM] [pgsql-advocacy] Postgres and really huge tables

2007-01-19 Thread Josh Berkus
> A lot of data, but not a lot of records... I don't know if that's > valid. I guess the people at Greenplum and/or Sun have more exciting > stories ;) Not really. Pretty much multi-terabyte tables are fine on vanilla PostgreSQL if you can stick to partitioned and/or indexed access. If you n

Re: [PERFORM] [pgsql-advocacy] Postgres and really huge tables

2007-01-18 Thread Luke Lonergan
Chris, On 1/18/07 1:42 PM, "Chris Mair" <[EMAIL PROTECTED]> wrote: > A lot of data, but not a lot of records... I don't know if that's > valid. I guess the people at Greenplum and/or Sun have more exciting > stories ;) You guess correctly :-) Given that we're Postgres 8.2, etc compatible, that

Re: [PERFORM] [pgsql-advocacy] Postgres and really huge tables

2007-01-18 Thread Chris Mair
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? We have a problem of that f

Re: [PERFORM] [pgsql-advocacy] Postgres and really huge tables

2007-01-18 Thread Joshua D. Drake
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? > > We