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