anarazel

63 ms·

661.
by anarazel 7y ago
Yes, please do. Best with a short description of what the workload is, so we know what areas have been tested how. Just one word of caution: I'd be careful deploying betas into production. Even leaving possible bugs aside, while they&#
662.
by anarazel 7y ago
Hm, that should have gotten better with 11 (shared parallel hashjoin), but even before, there's plenty plans where parallelism is possible (by e.g. building the hashtable for a hashjoin over the smaller table(s) in each worker). Any ch
663.
by anarazel 7y ago
With parallelism, default settings (i.e. 2 workers).
664.
by anarazel 7y ago
> I couldn't create an index after the import, too slow. What made that "too slow"? I just tested it, and it's not too bad. This is on my development environment (~3yo laptop, reasonably powerful), with all kinds of c
665.
by anarazel 7y ago
That should already have been improved a lot over the last few versions. Which version did you observe this with last, and if it was PG 10 or PG11, what type of query was this?
666.
by anarazel 7y ago
The pluggable table storage abstraction in v12 is one major stepping stone towards zheap. Another major piece (general undo infrastructure), is being discussed on the PG development list right now.
667.
by anarazel 7y ago
That doesn't sound normal. Those lists are pretty much tiny compared to a lot of other data stored in postgres. So there must have been something else going on. It'd be cool if you could report details of the problem you had.
668.
by anarazel 7y ago
jsonpath does allow a lot more complicated expressions than before. See https://www.postgresql.org/docs/devel/functions-json.html#FU... for example, and also https://www.depesz.com/2019/03&#x2
669.
by anarazel 7y ago
Indeed, that's one of the major reasons to introduce the tablem ("table access method") infrastructure. Interest in integrating at least one form of columnar storage is another.
670.
by anarazel 7y ago
The more people test, the more likely we'll feel comfortable to release sooner ;)
671.
by anarazel 7y ago
It's indeed not that easy to quantify. A lot of indexes get considerably smaller - whether and how much that increases performance hugely depends on whether that means your workload afterwards fits into memory. It also depends hugely w
672.
by anarazel 7y ago
You can. But sometimes you can't drop indexes without further consequences. It might be e.g. a primary key, or a unique index used to enforce uniqueness on the referred-to side of a foreign key. You can work around those, but that requ
673.
by anarazel 7y ago
Would probably need a good bit of extra fuel for course corrections too. I'd imagine that a lot of ablative material gassing off on the side close to the earth would have course impact. And influence aerodynamics.
674.
by anarazel 7y ago
Allegedly how to get access to another user's creds, to avoid having to download further data Uber Manning's account.
675.
by anarazel 7y ago
Isn't project fi exclusively a US thing? Why wouldn't google just get it thrown out due to lack of jurisdiction when sued in Europe?
676.
by anarazel 7y ago
I don't want to click far enough into the signup to get to an actual contract, but I'd be extremely surprised if it didn't have an arbitration clause as requirement. For some things you can opt out of arbitration, but not fo
677.
by anarazel 7y ago
Well, OS updates weren't going through the play store anyway, no? And it appears you'll continue to be able to download app updates via the play store "But users of existing Huawei devices who have access to the Google Play S
678.
by anarazel 7y ago
> Only postgresql said "such a nice port". It is a crazy port ;). But the native windows port is much crazier :) /me wishes for a fountain of time to change postgres' threading model.
679.
by anarazel 7y ago
Because that's what you want in your organisation. The person best at being an unchallanged dictator.
680.
by anarazel 7y ago
Hi, > They say its for rollback, but why wouldn't you just mark rows deleted during transaction, then actually delete them later in the background? > Anyone know if other database do this differently, I think Postgres doesn'
681.
by anarazel 7y ago
Well, sure, inverting a binary tree isn't hard to learn. But there's countless interview questions, not just that one. A lot are more tricky - and not everyone is good at coming up with such solutions from first principles under i
682.
by anarazel 7y ago
> A truly senior developer who really wants the job, with a few weeks of practice for an hour every night can considerably improve their chances. But why would I want to spend that time? There's a lot of companies out there looking
683.
by anarazel 7y ago
That's an interesting theory that I'd not heard before (and haven't found iterated anywhere within a few minutes of searching). Any additional details / references?
684.
by anarazel 7y ago
Given the fact that Switzerland is second in ppp adjusted health care costs (after the US, of course), I'm not sure modeling a system after the Swiss one is necessarily the best approach. The link is for 2016, but iirc the 2017 trends
685.
by anarazel 7y ago
His dissents in the Garza v Hargan case kind of did.
686.
by anarazel 7y ago
Hash indexes can't be used for primary keys: postgres[7878][1]=# SELECT amname, pg_indexam_has_property(oid, 'can_unique') FROM pg_am WHERE amtype = 'i'; ┌────────┬─────────────────────────┐ │ amname │ pg
687.
by anarazel 7y ago
Peer authentication for local postgres servers / poolers (authenticate using the OS users, doesn't work remotely, and yes, it's safe), kerberos / [gs]sspi authentication, client certificates.
688.
by anarazel 7y ago
I fail to see how that actually reduces risks. Mail/Packages across international borders are routinely searched without warrant. It's explicitly allowed by law: https://www.law.cornell.edu/uscode/text/
689.
by anarazel 8y ago
Barr's press conference was at 9.30 AM EDT, however.
690.
by anarazel 8y ago
And they announced it while they thought the attention was elsewhere (due to the Muller report release), and in an easy to miss manner (as an update to a blog post). Very trust inspiring.

More ›