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 ? Ho
PostgreSQL will definitely be able to handle it.
However, besides the schema, an important parameter is the kind of request
you will be submitting to PostgreSQL. Reporting queries, low-latency
queries ?
You may found PostgreSQL weak if you mainly submit analytical queries (eg.
SELECT count(1) fro
Hi Nicolas,
I do believe Postgresql can handle that.
I've worked with tables that have 2 millions rows per day, which give us an
average of 700 mi/year.
It's hard to say how much hardware power you will need, but I would say
test it with a server in the cloud, since servers in the cloud are usua
Hello,
I have a fact table ( table and indexes are bellow ) that will probably get
arround 2 billion rows.
- Can postgresql support such table (this table is the fact table of a
datamart -> many join query with dimensions tables) ?
- If yes, I would like to test (say insert 2 billion
