Most recent activity
-
Funny you ask. Only a couple of days ago my wife sent me a link to a website that sells those things. They were nice, but selling for hundreds of dollars. I told her to pick one and I'd build it, but she never did. Probably fully aware of the fact that I wouldn't actually get around to it until our kids had kids.
-
moocher - Enter The Dragon ()
https://www.lfgss.com/comments/15390701/
King_Saxlingham - Ghostbusters ()
https://www.lfgss.com/comments/15391299/
WillMelling - Gandhi. ()
https://www.lfgss.com/comments/15391357/
YorkshiremaninSurrey - Karate Kid ()
https://www.lfgss.com/comments/15391815/
i_am_lono - Rear Window (1)
https://www.lfgss.com/comments/15392011/
graunch - The Beach ()
https://www.lfgss.com/comments/15392046/ -
I heard that only the barbour jackets sold in the UK have that distinctive mouldy old piss smell. Barbour jackets sold in all other countries moved to an odourless wax decades ago.
-
fwiw, I decided to make an LFGSS android app a while back. Unfortunately life got in the way and I never really made much progress, but in the process, I did containerise Microcosm, and I can tell you now that it builds and boots up just as easily with 9.2 as it does with 12.
I've upgraded Postgres versions a few times and it's usually not much more hassle than doing a dump and restore. Last time I upgraded from 9.3 to 10, the syntax checker for stored procedures was a bit stricter and forced us to correct some errors no one had noticed before, but other than that it was pretty painless.
-
What version of postgres is lfgss on? Pre 9.6 wasn't multithreaded, and pre 12, CTEs (and sub queries?) were basically optimisation fences.
If a DISTINCT ON causes performance issues, upgrading postgres could be a solution
-
Maybe just whack a
distinct onon the big union? (and update the order by clause appropriately)SELECT DISTINCT ON (created, item_type_id, item_id), COUNT(*) OVER() AS total, ...I haven't grokked the whole query so I could be way off.
-
King_Saxlingham - Dead Wood. ()
https://www.lfgss.com/comments/15372887/
moocher - Trunk ()
https://www.lfgss.com/comments/15375034/
WillMelling ()
https://www.lfgss.com/comments/15377341/
YorkshiremaninSurrey - Underneath the surface wood ()
https://www.lfgss.com/comments/15377438/
i_am_lono - Cone. wood (1)
https://www.lfgss.com/comments/15377476/
Landslide - SMILE ()
https://www.lfgss.com/comments/15377588/
pullingteth - Woodshed ()
https://www.lfgss.com/comments/15377604/ -
Some really cracking shots in there.
@WillMelling Clicking a hashtag on LFGSS will show if it's ever been used before.
-
King_Saxlingham - Holy Trinity of Blendworth, Charlton and Idsworth, the three churches in the Benefice. ()
https://www.lfgss.com/comments/15355500/
skydancer - The end is death & decay ()
https://www.lfgss.com/comments/15358774/
pullingteth - Chiptych ()
https://www.lfgss.com/comments/15361243/
oat44 - allegory of prunence ()
https://www.lfgss.com/comments/15362383/
moocher ()
https://www.lfgss.com/comments/15362541/
WillMelling ()
https://www.lfgss.com/comments/15363227/
YorkshiremaninSurrey - Transition triptych ()
https://www.lfgss.com/comments/15363263/
Airhead - Same Light triptych ()
https://www.lfgss.com/comments/15363435/
Eejit - Spotlight on socks triptych ()
https://www.lfgss.com/comments/15363473/
i_am_lono - Abstraction. triptych (1)
https://www.lfgss.com/comments/15363497/
Loving Kraken Cove!
My favourites parts are when Benny says something totally wild, and then you say "well, funny you should say that..."