davyjones

Joined 15 years ago

Karma
628
Submissions
260
Member since
Oct 19
http://pgxplorer.com/#buy

Two letter initials at above domain.

Feel free to get in touch apropos anything.

View on Hacker News

Recent submissions

Comment · 9 years ago
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 scanning all the child tables in vain.

Hopefully the partitioning thing is soon fixed 'properly'.

Comment · 9 years ago
Comment · 9 years ago
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.
Comment · 10 years ago
6 hours to 15 minutes here. This is with the right indices and stock install. I am sure an expert can do much better.
Comment · 10 years ago

    Google something (often results in reading unrelated articles, "link dives", etc.)  <=====> Cache miss (?)
Comment · 10 years ago
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 dance around GC is a hard problem.

I agree that the syntax is cryptic. I also think that programs are written by humans for human consumption (for accomplishing a certain task).

If you have a long term plan, you might want to factor in the talent pool, hardware cost, and tech debt. For your case, if that leads to Rust, so be it. Or if it means Python, that is fine too.

Comment · 10 years ago
Maybe they started with hstore and replaced that over time.
Comment · 11 years ago
Off the top of my head, Index only scans, overhauled GIN & GiST indices, Trigrams come to mind.
Comment · 11 years ago
Looking for a co-founder who has a strong ML background for SaaS business in retail/brick'n'mortar space.
Comment · 11 years ago
gi/go
Comment · 11 years ago
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, folks weren't too pleased, but I kept everything civil and professional. And I was successful in getting a recommendation.

Comment · 11 years ago
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.
Comment · 11 years ago
pgaas.com

pgsafe.com

Was meant for postgres-as-a-service.

Live from the official Hacker News API

A modern reader for Hacker News · SvelteKit + Skeleton