pgaddict

61 ms·

241.
by pgaddict 10y ago
There's PostgreSQL 9 Admin Cookbook from Simon Riggs, for example (disclosure: I work for Simon). Packt has several other good books about PostgreSQL, but always check the author - they started publishing books authored by people entir
242.
by pgaddict 10y ago
I wonder why not to go for a changelog-based implementation. Instead of modifying the materialized view directly, write the changes into a changelog, and then update the matview in the background. More efficient, less locking issues, etc.
243.
by pgaddict 10y ago
To be fair, the extended statistics available in PG10 are about the most primitive ones possible. If the PG10 stats help with your queries, great, but otherwise it's mainly laying infrastructure for the more advanced stuff - histograms
244.
by pgaddict 10y ago
This somewhat mixes two issues, really. Firstly, there are issues with glibc versioning, when the collation rules change even without proper version bump. I don't have a link to details at hand, but I've heard a number of complain
245.
by pgaddict 10y ago
True. Actually, this execution efficiency is usually way more important benefit of column stores than just saving disk space. Sadly, PostgreSQL does not support that now, but hopefully it's not that far in the future. It's becomin
246.
by pgaddict 10y ago
I think it's pretty clear Postgres is getting to a situation where the storage format becomes the limiting factor for a lot of workloads, particularly verious types of analytics. Timeseries are example of yet another type of data that
247.
by pgaddict 10y ago
I don't think COW in general is a big issue for databases. You can get pretty good performance for ZFS (very stable and consistent behavior), for example. The COW is not free, of course, but you get interesting features in return, and
248.
by pgaddict 10y ago
http://www.theregister.co.uk/2016/12/16/oracle_targets_java_...
249.
by pgaddict 10y ago
Definitely agreed.
250.
by pgaddict 10y ago
Well, people don't realize a lot of the bad stuff actually makes business sense. It's not that the companies are meant to be evil, but once you are a customer, they have little to gain from treating you as well as potential custom
251.
by pgaddict 10y ago
MVCC has nothing to do with timestamps, particularly not with timestamps generated from gettimeofday(), but with XIDs which you might imagine as a monotonous sequence of integers, assigned at the start of a transaction. You might call that
252.
by pgaddict 10y ago
The fact that PayPal claims to be the safest payment solution is pretty irrelevant, especially if it's meant to be safest for the buyers and you're the seller. This is not the first story of PayPal freezing accounts with substanti
253.
by pgaddict 10y ago
pice3 -> pcie3
254.
by pgaddict 10y ago
It's complex stuff, no doubt about that. For me, it's much simpler - I come from the PostgreSQL world, so gettimeofday() is pretty much what EXPLAIN ANALYZE does to instrument queries. Good time source means small overhead, bad ti
255.
by pgaddict 10y ago
Not sure, but it can't be better than moving processes between CPUs I guess. Also, does EC2 silently move VMs like this?
256.
by pgaddict 10y ago
Not really. Recent CPUs (at least those from Intel, which is what EC2 runs on) implement constant_tsc, so the frequency does not affect the tsc. A worse issue is that the counters may not be synchronized between cpus, which may be an issue
257.
by pgaddict 10y ago
I wonder why the blog post claims setting clock source to 'tsc' is considered dangerous.
258.
by pgaddict 10y ago
We're in the business of PostgreSQL support, and some of our customers use RDS for various reasons. Not having to care about the deployment is one of the usual goals of using a managed environment, but considering they subsequently go
259.
by pgaddict 10y ago
It's always a cost/benefit evaluation. When the costs stay roughly constant, the outcome is usually to use the same stuff as for previous projects. But when the vendor significantly increases the costs, like Oracle does in the rec
260.
by pgaddict 10y ago
I agree the companies are unlikely to rework the current code from Oracle to PostgreSQL (or some other database), but they'll definitely think twice when starting new stuff.
261.
by pgaddict 10y ago
I may be missing something, but I don't see any mention of 2 nodes in that blog post. In fact, BDR is designed to be run with many more nodes. That being said, it's an asynchronous multi-master, suitable for geo-distributed archit
262.
by pgaddict 10y ago
AFAIK OxygenOS is more about optimization than about security, but I might be wrong. There's CopperheadOS and also SilentOS, both Android-based, the formed being open source and working on the Nexus phone. Don't ask me about how g
263.
by pgaddict 10y ago
The current state is not free either - the attacks cost money too, although it's paid by the targets and not the manufacturers. But ultimately it's paid by consumers.
264.
by pgaddict 10y ago
Sadly, no info about license in the github repository ...
265.
by pgaddict 10y ago
Judging by the pictures, the new models have pretty much the same keyboard as XPS. And the 15" models only come with numpad, which is a bit silly IMNSHO.
266.
by pgaddict 10y ago
I personally do care about the open source aspect - not only because I work on open source projects, but because it means I'm not so awfully dependent on the manufacturer. Does the proprietary driver support the kernel version / d
267.
by pgaddict 10y ago
I don't think it's particularly noisy. Sure, you can hear it when doing CPU-intensive stuff (say, doing "make -j4" on a large project), but well - the heat needs to go somewhere, otherwise the laptop would get quite hot
268.
by pgaddict 10y ago
Sure, there may be people who are used to / need to do video from the laptop. FWIW I do work remotely / from home, and I do chat with my coworkers and customers regularly, but we only do voice. If I needed to do video more often,
269.
by pgaddict 10y ago
If you're looking for a larger laptop with the same design, look also at the Dell Precision 5510 line, not just XPS 15. I've been waiting for an XPS15 with a good CPU and without discrete GPU, and gave up - they only do i3 version
270.
by pgaddict 10y ago
I don't even remember when I actually used a webcam on a laptop. I'm either in a conference room with dedicated camera, or doing voice-only meetings when traveling.

More ›