davyjones
Re:Why Use Postgres?
on Sunday April 30, 2017 @09:42PM (#14234975)
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'.
Re:RethinkDB Postmortem
on Wednesday January 18, 2017 @06:21PM (#13431454)
Those fall under db authoring/modeling tools. https://github.com/pgmodeler/pgmodeler is a good pick.
Re:RethinkDB Postmortem
on Wednesday January 18, 2017 @01:59AM (#13424633)
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.
Re:Let Postgres Do the Work (2013)
on Saturday November 26, 2016 @08:01PM (#13047072)
6 hours to 15 minutes here. This is with the right indices and stock install. I am sure an expert can do much better.
Re:Say hello to Google Allo: a smarter messaging app
on Wednesday September 21, 2016 @03:41PM (#12551533)
Google something (often results in reading unrelated articles, "link dives", etc.) <=====> Cache miss (?)
Re:My experience rewriting Enjarify in Rust
on Monday September 19, 2016 @06:48PM (#12535408)
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.
Re:Show HN: BedquiltDB – A Mongo-like JSON doc store built on Postgres
on Tuesday April 19, 2016 @08:12PM (#11531477)
Maybe they started with hstore and replaced that over time.
Re:Try PostgreSQL 9.5
on Sunday July 05, 2015 @02:29AM (#9832710)
Off the top of my head, Index only scans, overhauled GIN & GiST indices, Trigrams come to mind.
Re:Ask HN: Who's looking for a cofounder?
on Sunday June 28, 2015 @09:30PM (#9795972)
Looking for a co-founder who has a strong ML background for SaaS business in retail/brick'n'mortar space.
Re:Suddenly, a leopard print sofa appears
on Saturday June 20, 2015 @06:10PM (#9751213)
gi/go
Re:
on Saturday May 23, 2015 @08:12PM (#9594876)
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.
Re:The World Religions Tree (huge visualization)
on Sunday May 10, 2015 @05:43PM (#9521454)
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.
Re:Ask HN: What domain names do you have that you aren't utilizing?
on Tuesday April 21, 2015 @08:42PM (#9418040)
pgaas.com
pgsafe.com
Was meant for postgres-as-a-service.
Zubulake v. UBS Warburg
Re:Math for eight-year-olds: graph theory for kids
on Saturday April 11, 2015 @01:35AM (#9358634)
Your write up on EC and tensors, I enjoyed it a lot. Thanks for the excellent effort!
Re:Ask HN: Which developers/programmers do you closely follow?
on Tuesday April 07, 2015 @10:58PM (#9338581)
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 novice to hackers.
Ask HN: Essay on naturals, rationals, irrationals, algebraics
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 steadily from natural numbers to rational to irrational to algebraics using equations.Sadly I lost the link. If anyone remembers reading something like this and has a link, I would appreciate it very much.Thanks!ps. This...
Re:PostgreSQL Foreign Data Wrappers
on Wednesday March 18, 2015 @07:37PM (#9229348)
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".
Re:Valve's SteamVR solves big problems and poses bigger questions
on Monday March 16, 2015 @01:08AM (#9209969)
> 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 the brain...in which case, we probably will have optics covered as well. Thence we can get rid of the headset altogether.
Re:We use RethinkDB
on Saturday March 14, 2015 @08:07PM (#9204751)
I always do that. I have worked with Strategic Sourcing for a while...so... ;-)
Re:We use RethinkDB
on Thursday March 12, 2015 @04:15AM (#9189591)
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. Guess I will have to call up my vendor to get a comparable quote.
Re:Gravitational Lensing to Observe Ancient Earth
on Sunday March 08, 2015 @12:29AM (#9164685)
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.
Re:Ceres' Deepening Mysteries
on Tuesday March 03, 2015 @12:41AM (#9136291)
My crazy theory: naturally formed nuclear reactor.
Re:Show HN: Interactive Essay on Signals, Sampling and the Fourier Tra...
on Monday March 02, 2015 @09:40PM (#9135805)
As a side note, the pressure that is waxing and waning in that diagram is very very small compared to atmospheric pressure.
The actual air molecules are moving at a much higher speed (the root mean squared velocity is dependent on the temperature). But if we imagine that these are weightless dust particles suspended in air, the diagram is accurate.
PgAdmin4
Re:Ask HN: Freelancer? Seeking freelancer? (March 2015)
on Sunday March 01, 2015 @07:21PM (#9129582)
SEEKING WORK: MVP, Product Management, Engineering; Kansai area or Remote.
Formal Learning Theory
Re:There exists a classical model of the photon after all
on Monday February 23, 2015 @10:49PM (#9098573)
Usually a pretty common mistake. Fluid is always compressible (else sound won't travel in STP water). It is whether one chooses to model the flow as compressible or not.
Re:How Likely Is It That Birth Control Could Let You Down?
on Sunday February 15, 2015 @04:19AM (#9052132)
> Don't want kids? Don't want to take chances? Don't have sex.
If you are done with predetermined quota, one can go under the knife and start shooting blanks at no bodily cost.