Reputation
611
Top tag
Next privilege 1,000 Rep.
See votes, expandable usercard
Badges
3 4
Newest
 Yearling
Impact
~35k people reached

  • 0 posts edited
  • 0 helpful flags
  • 4 votes cast
Jan
10
awarded  Yearling
Sep
1
comment What is the best approach to process huge amount of data insertion efficiently
Just so you know, 2 million records a day is not huge; it's a medium database insertion rate. That's 23 records a second. There are PostgreSQL servers that do a billion records a day. You can struggle even with this low amount if you try to do too much CPU heavy work in your triggers though. The advice you've gotten from Erwin already is taking you the right way.
Sep
1
answered How do I maintain high INSERT-performance on PostgreSQL
Sep
1
answered What's the best solution for offline db syncing
Dec
20
awarded  Yearling
Dec
20
awarded  Yearling
Nov
14
awarded  Revival
Oct
17
answered How to wait for PostgreSQL to be startable / restorable?
Oct
17
answered Proper storage size estimation technique for PostgreSQL
Oct
17
answered PostgreSQL Index Caching
Oct
17
answered High Availability for postgresql
Sep
15
comment Does PostgreSQL 9.1 Streaming Replication catch up after a lag without WAL archiving?
This answer is correct, but it highlights the problem. If you do ever pass wal_keep_segments, your replication is dead. Setting up file-based replication is not optional if you want a system that will survive a long disconnection from the master and catch back up.
Sep
15
answered Removing Archive Logs after PostgreSQL PITR online-recovery
May
10
answered How to know there is a maintenance job running on a postgresql database
May
10
answered Performance degradation while updating tables having 10s of millions of records
Feb
24
answered Fastest validation query in PostgreSQL
Feb
24
answered Database for building a realtime analytics system
Feb
24
answered Does running pg_dump on live db produce consistent backups?
Dec
20
awarded  Teacher
Dec
20
awarded  Supporter