News for hackers. Stuff that matters.
Re:PostgreSQL Performance on Raspberry Pi by rb808 on Thursday April 04, 2019 @10:50AM (#19572963)
Hopefully nextgen raspberry pi will take sata or some other storage interface. I think SD cards are the main problem with the platform right now.
Re:PostgreSQL Performance on Raspberry Pi by gruturo on Thursday April 04, 2019 @12:03PM (#19573904)
A vast majority of these boards use chips made for mobile phones to keep the costs down - so we have to make do with what these chips have. Which is why they support 2 or 3 camera buses, WiFi, LVDS, HDMI, Bluetooth, SD, but usually no SATA, no PCIe lanes, no Ethernet (it's often a USB device like on the Pi).

The Pi is pretty much the only one with the sales numbers to justify the cost of a customization, but even that would be a small miracle.

Re:PostgreSQL Performance on Raspberry Pi by driverdan on Thursday April 04, 2019 @11:24AM (#19573394)
ODroids are a great alternative with much better performance and SATA for not much more money (~$55).
Re:PostgreSQL Performance on Raspberry Pi by pheleven on Thursday April 04, 2019 @01:38PM (#19575002)
And non-unique MAC addresses and lower stability, at least when we tried to use them a few years ago. Bought 3 and they all had the same MAC.
Re:PostgreSQL Performance on Raspberry Pi by eropple on Thursday April 04, 2019 @02:44PM (#19575735)
I've run into the MAC problem, but found it easy enough to deal with via my standard home Chef configs. I can't echo the stability issues, though; my two have been ticking away happily for a couple years.
Re:PostgreSQL Performance on Raspberry Pi by nurettin on Thursday April 04, 2019 @11:53AM (#19573773)
And 2GB RAM, 2GHz CPU.
Re:PostgreSQL Performance on Raspberry Pi by bityard on Thursday April 04, 2019 @01:13PM (#19574713)
The problem is that regular SD cards were made to store photos and music once in a while, not host an entire operating system.

They make high-endurance SD cards that _are_ more reliable and _can_ handle being written to constantly but everyone cheaps out and just gets the cheapest thing on sale from the rainforest retailer and wonders why their cards keep dying.

Re:PostgreSQL Performance on Raspberry Pi by monocasa on Thursday April 04, 2019 @02:16PM (#19575413)
Particularly you want to look for the keyword 'industrial' when buying SD cards that'll store data that you care about. You can't just throw money at it because the prosumer cards, even from the reputable brands, tend to be crap, just more expensive.
Re:PostgreSQL Performance on Raspberry Pi by dleslie on Thursday April 04, 2019 @11:11AM (#19573214)
It's a shame that ongoing support for other SBCs is almost universally poor. Often you're stuck using older, unpatched kernels and broken video drivers.

RPi has binary blobs, but at least they keep supporting boards with software updates

Re:PostgreSQL Performance on Raspberry Pi by nfriedly on Thursday April 04, 2019 @04:53PM (#19576992)
There is Armbian, which produces up-to-date Debian-based builds for various SBCs: https://www.armbian.com/

But, I still agree with your point. I basically only buy Raspberry PI's now because the software experience has been terrible with everything else I've tried. (I only learned about Armbian recently, haven't actually tried it out yet.)

Re:PostgreSQL Performance on Raspberry Pi by wlll on Thursday April 04, 2019 @01:45PM (#19575062)
Apparently they will, from someone in IRC I trust:

https://dl.sendcat.com/Aip36fb6Sn5KBIFQEV8xQ7A0X5sdEf5tX5zrL...

"USB3, Gigabit ethernet (proper), and on the higher variants, it will have a a sata port, second hdmi port (for in or out), and a higher end FGPA"

However:

"not 2019 according to ebden"

Re:PostgreSQL Performance on Raspberry Pi by extra88 on Thursday April 04, 2019 @01:55PM (#19575192)
That was an April Fool's joke.

https://youtu.be/Y1fcQb708vw

Re:PostgreSQL Performance on Raspberry Pi by wlll on Thursday April 04, 2019 @02:14PM (#19575391)
Well that sucks, and isn't at all funny.
Re:PostgreSQL Performance on Raspberry Pi by monocasa on Thursday April 04, 2019 @02:12PM (#19575373)
AFAIK, they haven't really changed any of the RTL except the ARM cores and some of the caching. I don't really see them adding SATA.