4 ms·
were you on an NVMe SSD? how much RAM did you have? how many CPU cores? The hardware is important. If you tried to import that data on a $5/mo DO droplet, I wo
by coder543 7y ago
were you on an NVMe SSD? how much RAM did you have? how many CPU cores?
The hardware is important. If you tried to import that data on a $5/mo DO droplet, I wouldn't be surprised by having issues.
- lcnmrn 7y agoTwo cores CPU with hyperthreading. 16 GB of RAM. But data isn't stored in RAM, right?
- coder543 7y agoNot having enough RAM can significantly degrade database performance. Also, gotta wonder if you have good indices on the data. As others have said, the amount of data you're talking about is not very big. I regularly deal with Postgres databases that are two orders of magnitude larger, and they are lightning fast.
- volkadav 7y agoi don't know the size of the dataset you're talking about, but it may help to open things up to use ram more liberally in particular as the default configs are rather conservative. https://wiki.postgresql.org/wiki/Tuning_Your_PostgreSQL_Server https://wiki.postgresql.org/wiki/Tuning_Your_PostgreSQL_Serv... may help. good luck :)
- GordonS 7y agoSSD makes a huge difference too.