I am new to database administration. I've been scraping a website for a month now. I have two drives, each 2TB in size. I have PostgreSQL 10 on my first drive (c:
) and it has 50GB left. I've only scraped about 75% of the website and have another 25% to go. What are my options?
I can't extend my first drive because my computer is old (hp z600) and the RAID software only supports up to 2TB. I would prefer not to stop my scraping process because I was an idiot and didn't keep track of pages that I've already visited. I thought 2TB would be enough, but I was wrong.
Running SHOW autovacuum;
shows that autovacumm is on.