Hacker News new | past | comments | ask | show | jobs | submit | yobert's comments login

I have a large production deployment that is still on 9.6 because the software depends on table inheritance. (Oh man!)


Unless I'm mistaken table inheritance is still a thing in current PG versions, in terms of partitioning at least it's just less commonly used in favour of declarative partitioning since it's easier to manage.

It's been a long time since I worked with v9.x in anger, so I could well be forgetting things though

https://www.postgresql.org/docs/current/ddl-partitioning.htm...


Our problem isn't the inheritance feature itself-- it's the removal of the config knob `sql_inheritance` which lets you change whether inherited tables are included in queries by default or not (behavior controlled manually by the * notation). It's a goofy behavior nobody liked, but we have a mountain of SQL that depends on that knob. It's fixable... Just a pain :)


For a while I had a separate version 9 cluster because of one application.

But it wasn't really a nuisance. Postgresql doesn't give a DBA much to worry about.


I bet this is not because alcohol is good for you in any way, but because being intelligent is related to being eager to try new things.


I knew that smoking crack meant I was smart


Yes but a cracked LCD is much more obvious than a single LED segment burning out. Also usually physical damage is required to crack an LCD, where as LEDs can burn out (albeit rarely)


I tried to add a new SQL function to CockroachDB. I had never seen the source before, but since it was such nice Go code, it only took me a few hours to have a working build, with tests.


The ecosystem has settled on NetworkManager for desktops/laptops. The systemd ones are great for servers or VMs.


Amen. I used to be a pacifist before the Ukraine war. Now I feel like a completely different person.


Right there with you. Making it even more surreal to be "pro-war" is that the party of the previous president was rabidly anti-Russia until he came into office and did a 180.


That you changed your principles based on a war started by the sworn enemy of the West on the contrary speaks to being the same person all along.


Really? My journey was the opposite. That war in combo with another war made me realize the indignation is more or less manufactured and that the elite rather have my face blown into pieces than not lose their face in a figurative way.

It is like watching a self-playing piano pitting me against another self-playing piano and I am supposed to cheer the whole parade.


Think about tethering a zeppelin with a curved body shape, where you need to attach in multiple places. Combine that with needing to tether at different elevations and it will get out of hand pretty quick.


You're thinking that shorter lines can be thicker without tearing under their own weight, so the optimal mix is a few heavy lines supported by a larger number of light ones? And/or heavy lines for safety, many light lines for stability?

I suppose that makes sense, though it still seems weird that they needed that many types.


Looks great! You just need https://status.statusnook.com/ to demo monitoring yourself :D


You're right! I've just spun one up at that url.

Could be cool to have a restricted demo version in the future for people to poke around in.


Really cool demo!


How should a public defender behave? He's doing what his job is supposed to be.


He should understand the position his clients are in, where one small admission could lead to an entire sentence pinned on them.

While he might not like it because it makes his job difficult, he should nonetheless understand it and at least pretend to sympathize on some level.


Consider applying for YC's Spring batch! Applications are open till Feb 11.

Guidelines | FAQ | Lists | API | Security | Legal | Apply to YC | Contact

Search: