News for hackers. Stuff that matters.
Re:Postgres Just Cracked the Top Fastest Databases for Analy... by dig1 on Saturday March 08, 2025 @07:18AM (#43299622)
As someone dealing with billions of records on it, BigQuery is far from cheap; G will not charge you much for storage as they will charge you for queries and data transfer.

AFAIK, the cheapest Postgres server on GCP is very expensive compared to the usual Postgres installation (price/performance).

Re:Postgres Just Cracked the Top Fastest Databases for Analy... by michaelmior on Saturday March 08, 2025 @07:59AM (#43299899)
What do you mean by "the usual Postgres installation"?
Re:Postgres Just Cracked the Top Fastest Databases for Analy... by renegade-otter on Saturday March 08, 2025 @08:18AM (#43300023)
That and RDS are kind of a rip-off if you are trying to have a sandbox out there, short of running your own instance.

For that, I found Digital Ocean to be very reasonable.

Re:Postgres Just Cracked the Top Fastest Databases for Analy... by eastbound on Saturday March 08, 2025 @09:21AM (#43300449)
DO’s pricing has increased a lot. I was surprised, I couldn’t start a $5 vm anymore, it’s worth checking again.
Re:Postgres Just Cracked the Top Fastest Databases for Analy... by jmholla on Saturday March 08, 2025 @12:46PM (#43301922)
You can, but I think you have to be in one of the regions that supports it. The generally (globally?) available lowest priced VM is $6 a month.

https://www.digitalocean.com/pricing/droplets

Re:Postgres Just Cracked the Top Fastest Databases for Analy... by sgarland on Saturday March 08, 2025 @10:58AM (#43301156)
Yep. I used it once for a personal project involving GHTorrent [0], and each query was about $20. That may be peanuts for a business, but for someone playing around on their own, it's incredibly prohibitive.

[0]: https://github.com/ghtorrent/ghtorrent.org/blob/master/gclou...

Re:Postgres Just Cracked the Top Fastest Databases for Analy... by LorenzoGood on Saturday March 08, 2025 @12:48PM (#43301942)
What is hardboiled studios?
Re:Postgres Just Cracked the Top Fastest Databases for Analy... by bhouston on Saturday March 08, 2025 @12:50PM (#43301966)
On billions of records my query costs were generally less than a cent. But I partitioned and clustered on the key fields.
Re:Postgres Just Cracked the Top Fastest Databases for Analy... by chrisldgk on Saturday March 08, 2025 @12:51PM (#43301978)
Either the website this is referring to got hacked or you sold it. Either way, this probably shouldn’t be linked on HN.
Re:Postgres Just Cracked the Top Fastest Databases for Analy... by sgarland on Saturday March 08, 2025 @01:02PM (#43302058)
EDIT: The site no longer exists, it seems. The project (which is not my creation) was a regularly-updated dump of all GitHub metadata (PR comments, Issues, etc.). Here's an archive snapshot: https://web.archive.org/web/20220126060859/https://ghtorrent...