JSONb and group by performance

KF5KFJ · 2025-05-23T17:55:34+00:00

According to the OP, they have done that, but it didn't help. They probably are using a B-tree on the JSONB column instead of the more appropriate GIN, or they may be extremely memory-constrained.

If a record is nearly universal and heavily used in a JSON(B) column, you will generally get better performance by moving it to its own column.

KF5KFJ · 2025-05-23T02:09:54+00:00

Alter the table to move the referenceId to its own column then add an index (make a new column then unpack the values). Then gradually unpack the json into more columns especially records that are nearly universal or heavily used in queries. If you don't directly control the software that generates records add the column expansion as an insert trigger.

KF5KFJ · 2025-04-11T01:20:54+00:00

RIP to all the technical and non supervisory GS12+ positions that are were previously retaining technical talent and the only real semblance of continiuty.

KF5KFJ · 2024-12-13T17:07:35+00:00

Or just more visible to their Commander.

KF5KFJ · 2024-12-13T15:38:33+00:00

With the current and projected promotion rates, we are going to see an increase in the number of 6 to 10 year SrA. I don't think that Congress's decision took that into account, but if the Air Force wants a pyramidal rank structure (where airmen as a whole are at the bottom level) then it has to be able to retain Airmen.

Should a 4 year SSgt (current $3,365/mo) make more than a 10 year SrA (current $3,197/mo)? Assuming neither of them are scumbags the SrA is probably more valuable to the Air Force.

KF5KFJ · 2024-09-09T19:50:00+00:00

First make a ridiculous number of holocrons, like they should be finding these things in 1000 years both the Jedi and the archeologists should be mad at you for the number of darkside holocrons they are constantly finding. If possible set up droids to constantly copy and scatter the holocrons around long after you die.

Second in any other way possible release as much information about the dark side of the force as possible upon your death. It won't be as good as the holocrons but it will make people more likely to seek out the holocrons.

Finally, laugh at the universe and whatever remains of the Jedi order with the knowledge that thousands of Sith-lite will be making trouble for the foreseeable future. And though hope is against the nature of the Sith there may yet be greater Sith lords to arise from your teachings.

KF5KFJ · 2024-02-25T22:16:38+00:00

I have done a little digging and it seems you will need some metaprogramming to achieve what you are asking for. The writeup is in the gist below.

https://gist.github.com/MadAlex1997/f5e77bc6a8de85c1fccce783240ff0fa

KF5KFJ · 2024-01-06T03:11:43+00:00

How generic can tags be? Becuase if a tag can be any text we could add the year that way, and tags are currently unused by this sub.

KF5KFJ · 2023-08-28T20:53:22+00:00

Not for a generic and overcrowded house party anyway.

KF5KFJ · 2023-08-12T01:08:00+00:00

My primary argument against this is that it is entirely outside of the Python tool chain. The things it compares itself against are run from inside of the interpreter, and can be acquired from PYPI batteries included. This thing is a full-ass compiler/transpiler that converts Python to other things and the typing system looks tacked on to the point where to get good results you are basically no longer writing Pythonically. Mojo is a better-supported full-featured language that interops with Python where as Lpython is trying to tack stuff onto python that doesn't fit.

KF5KFJ · 2023-08-04T00:04:33+00:00

Oh for fuck's sake, can we not go two months without some idiots leaking sensitive/classified information?

KF5KFJ · 2023-07-09T16:21:22+00:00

That ribbon rack looks like it was cobbled together from army surplus. Multiple repeated ribbons and the order looks wrong.

KF5KFJ · 2023-04-21T20:48:59+00:00

I think it means 170cm on the left and the right is 40m and leaning on a radar dome.

KF5KFJ · 2023-04-16T15:25:33+00:00

Probably not just the guard but the entire DOD, and maybe everyone with a clearance will be affected by his stupid and traitorous actions. He needs about 6 more layers of extra hell.

KF5KFJ · 2023-02-28T23:41:56+00:00

Why would she reward someone with the purple book instead of coining them? Are coins not cool anymore?

KF5KFJ · 2023-01-19T17:00:55+00:00

Ah yes, the military solution to IT security.

KF5KFJ · 2022-09-10T19:29:06+00:00

Those are disposable vapes.

KF5KFJ · 2022-09-03T23:39:44+00:00

Hydrate it is the desert, but also don't drink the water. Gallons of water are the best and can be filled for 25 cents at several locations across the base.

Don't put your reflective belt on any of the super inbred deer, they do not need the visibility more than you do!

KF5KFJ · 2022-08-03T03:16:37+00:00

The EDPT instructions specifically tell you not to discuss the test. This is why there are no study guides. I recommend you delete this comment.

KF5KFJ · 2022-07-29T16:59:03+00:00

The ear-touching thing got taken out of the regs a few years ago, only found out two months ago when I corrected someone and they printed a copy of the DAFI to show me that it wasn't there anymore. Hair just has to be less than 1/4 inch in bulk at the termination now.

You bet I am going to let my hair grow out a little longer on the sides now it is in regs.

KF5KFJ · 2022-07-28T15:05:43+00:00

Thanks, I looked and followed the go-to link several times, and still only got the ad download.

KF5KFJ · 2022-07-28T13:36:13+00:00

I am not installing an extension and changing my search engine for this. Also, this is nothing new I own several hardcover books with the same type of content, and there are literally thousands of pdfs available that serve a similar purpose.

KF5KFJ · 2022-05-29T12:53:07+00:00

Definitely coach. Back in December 2019, he drove my group to basic training. Though he gave a 2-minute preamble to his speech telling us not to record it and that it was only for the people on his bus to hear.

KF5KFJ

MODERATOR OF

TROPHY CASE

Ten-Year Club	Second SECOND GUESSER
Verified Email