jpitz

44 ms·

421.
by jpitz 15y ago
[edited for formatting] Speaking only to the differences between PostgreSQL and SQL Server: 1. "Live" clustered indexes 2. Query Parallelism 3. A richer API for data partitioning and _arguably_ a better query optimizer for partitioned data.
422.
by jpitz 15y ago
Object Pascal?
423.
by jpitz 15y ago
You're making the arguably extraordinary claim that _someone_ is spinning up Facebook-sized workloads on AWS, multiple times a day. Until you can back that up with a source, you're going to get downvoted.
424.
by jpitz 15y ago
I was under the impression that ODBC, OLEDB and ADO.NET all spoke TDS on the wire.
425.
by jpitz 15y ago
Notch seems to kick ass doing things that way.
426.
by jpitz 15y ago
When you're 3-4 orders of magnitude ahead of the game because you've ditched network round trips and disk accesses, indices become less ( not completely un- ) necessary. The impedance mismatch between database and application is a lot of co
427.
by jpitz 15y ago
Thank you for that clarification.
428.
by jpitz 15y ago
It sounds like their solution is set up that way. From https://postgres.heroku.com/#protect : "Every change to your data is written to write-ahead logs, which are shipped to multi-datacenter, high-durability storage. In the unlikely eve
429.
by jpitz 15y ago
Thank you!
430.
by jpitz 15y ago
"You write on your site; I write on mine." http://daringfireball.net/2010/06/whats_fair It _still_ isn't clear whether the parent is Daring Fireball's author ( but I don't suppose I doubt it much )
431.
by jpitz 15y ago
Just about every non-trivial strategy for screening applicants will yield false-positives. Do you understand where the false-positives in your screening process are?
432.
by jpitz 15y ago
With all due respect… a keymaster is just another component that can fail in a distributed system. GUIDs just work. I don't think I have an exceptional use case, and my nodes are dynamic in that very sense. Meta: I don't get why you are bei
433.
by jpitz 15y ago
What about in a peer-to-peer/multi master scenario where nodes can be added or removed at whim?
434.
by jpitz 15y ago
I've tried but given up finding even a cached version of the original source material. Has anyone else had any luck?
435.
by jpitz 15y ago
I thought all these years that Hungarian's job wasn't to communicate the data type i.e. int vs float, but to convey things at a more semantic level - pixels vs em ( when not using a richer data type to encapsulate them )
436.
by jpitz 15y ago
I've no idea how those behave with utf8 data. I'm more interested in what the memory settings do to the benchmark. After that, I'd want to see EXPLAIN ANALYZE.
437.
by jpitz 15y ago
lc_collate | en_AU.utf8 lc_ctype | en_AU.utf8 server_encoding | UTF8 Does r17 use utf-8? shared_buffers | 32MB Thats mean! :D Should be 3GB on that machine. effective_cache_size ought to be 10-12GB ish.
438.
by jpitz 15y ago
The effective_cache_size and shared_buffers settings from the revsys link are good, but thats generally older guidance ( max_fsm_pages is gone now ) If r17 doesn't use fsync.... Well. Perhaps you could show a postgres benchmark with that of
439.
by jpitz 15y ago
Agree. Can we see the results of running the query on this page? http://wiki.postgresql.org/wiki/Server_Configuration The stock config is violently wrong for a machine with 12GB of RAM.
440.
by jpitz 15y ago
I've served in the military. We had an asset we needed to secure - not nukes, but fairly important. We did the risk analysis and wound up with this layered approach: big thick blast-, TEMPEST-, and EMP-resistant door, retinal scan identific
441.
by jpitz 15y ago
Not so true. When the government REALLY wants to secure something, like, say, nukes, no matter what the technical security measures, there are always guys with guns.
442.
by jpitz 15y ago
The Win32 subsystem certainly does enforce, at least in a default install, a lot of conventions that allow the system to maintain backwards compatibility with a long, long, MASSIVE legacy of software. Many, though not all, of them can be ch
443.
by jpitz 15y ago
PowerShell can certainly output in vanilla text, if needed.
444.
by jpitz 15y ago
Full disclosure: I am a college dropout - so take this with a grain of salt. At the very least, it matters, if only a little, to the reputation of the institution. If they start turning out plagiarizing idiots, eventually they become unable
445.
by jpitz 15y ago
Randall?
446.
by jpitz 15y ago
PuTTY and Cygwin are still the most popular ways to get an SSH client on Windows, so far as I'm aware.
447.
by jpitz 15y ago
Oh yes double plus yes yes yes.
448.
by jpitz 15y ago
Where did that quote come from? In the linked article, the closest I see is this: "Researchers estimate the new model could shave almost 1,000 pounds off a car's weight currently taken up by conventional engine systems." A somewhat differen
449.
by jpitz 15y ago
I'll disagree, and assert that this is the logical conclusion of your statement: http://xkcd.com/378/
450.
by jpitz 15y ago
That's not refactoring. That's a specific refactoring known as rename. Rename is handy, and might even be the most often applied refactoring, but it's also the easiest to craft. Move Method, Pull Up, et al are useful and not as easy to cr

More ›