Viewing profile — davyjones

Careful with this if you want to use it for partitioning data (it was atleast true till 9.6 in my experiments). You will never hit the exclusion parameter and consequently end up s…

Those fall under db authoring/modeling tools. https://github.com/pgmodeler/pgmodeler is a good pick.

I developed and use(d) pgxplorer (github.com/pgxplorer). So, I can tell you this: the best out there is psql (CLI). There exists no use case where a GUI is better than psql.

6 hours to 15 minutes here. This is with the right indices and stock install. I am sure an expert can do much better.

Google something (often results in reading unrelated articles, "link dives", etc.) Cache miss (?)

Why is this getting downvoted? Please don't downvote if you disagree with this viewpoint. Rust has its reasons for is current form, which is OK! In general, the whole song and danc…

Maybe they started with hstore and replaced that over time.

Off the top of my head, Index only scans, overhauled GIN & GiST indices, Trigrams come to mind.

Looking for a co-founder who has a strong ML background for SaaS business in retail/brick'n'mortar space.

gi/go

One way or the other, the company is looking after its interests. You will be reciprocating that when you find something better for yourself. They will understand. I have quit, fol…

Similar for Africa(n) which leads me to believe that the periphery covers only what is extant and only the roots of those are traced back to their origins.

pgaas.com pgsafe.com Was meant for postgres-as-a-service.

Your write up on EC and tensors, I enjoyed it a lot. Thanks for the excellent effort!

Tom Lane on the postgresql lists. His breadth and depth of knowledge on the postgres code is mind boggling. And he takes equal effort in helping out on all lists...ranging from nov…

A while ago, I chanced upon a light mathematical essay that made the case that algebraics were the next 'logical' step after irrational numbers. As I remember it, it built up stead…

file_fdw. I have a file that keeps changing constantly. What was a file read/write at app level has been replaced. Less code, direct access to data and readily "ETL-able".

> At least until we manage to fool the vestibular system as well as we can the eyes. If we can trick the neurons on site, then might as well trick it right before it plugs in at th…

I always do that. I have worked with Strategic Sourcing for a while...so... ;-)

When I changed the country to Japan, the sticker price jumped from 2000 USD to 15,000 USD eq. for a very basic system. I am just at a loss as to what can explain this disparity. Gu…

This was one of the first works I read that changed my perspective to focus on the human elements in science fiction as opposed to the bells and whistles.

My crazy theory: naturally formed nuclear reactor.