On 07/07/2014 06:59 AM, Nicolas Paris wrote: > - Can postgresql support such table (this table is the fact table of a > datamart -> many join query with dimensions tables) ?
Yes, it can. > - If yes, I would like to test (say insert 2 billion test rows), what > serveur configuration do I need ? How much RAM ? > - If not, would it be better to think about a cluster or other ? > - (Have you any idea to optimize this table ?) Consider also trying cstore_fdw: https://github.com/citusdata/cstore_fdw -- Josh Berkus PostgreSQL Experts Inc. http://pgexperts.com -- Sent via pgsql-performance mailing list (pgsql-performance@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-performance
