3 ms·

> This is exactly a great point. When data size goes to a billion rows, Postgres is tough. You’ve been led astray. You can handle a billion rows on a developer

by orf 2y ago

> This is exactly a great point. When data size goes to a billion rows, Postgres is tough. You’ve been led astray. You can handle a billion rows on a developer laptop, let alone a production grade instance.

asah 2y ago
Depends on row width. 10KB JSON fields are all too common.
- afiori 2y ago
  I have more mongodb experience than postgres but my impression is that a lot of the json handling I ended up doing in mongo would have been easier/reliable in postgres
- orf 2y ago
  Yes, you obviously can’t fit 10 TB of data onto a developer laptop. However you’ll run out of disk before you run into Postgres issues.
  - lostmsu 2y ago
    With an SSD cache + a few external 20TB hard drives I think you can easily make it to 40TB with redundancy.
    - orf 2y ago
      Yes, you obviously can fit 10 TB of data onto a developer laptop with 10tb of external storage. However you’ll run out of disk before you run into Postgres issues.
      - lostmsu 2y ago
        I was kinda agreeing with you :-D