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 Tom,
Thanks for your reply. As you said, the weirdest part is the the SP ran fine
in primary server and hot standby server. I did another test over the
weekend:
(1) restore the production DB dump to an internal server with replication
set up.
(2) ran the SP in internal hot standy DB
(3) surpri
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
