postila

10 ms·

61.
Page-level compression and encryption in PostgreSQL [pdf](garret.ru)
1 points by postila 10y ago|0 comments
62.
PgCenter – a top-like PostgreSQL admin tool(github.com)
2 points by postila 10y ago|0 comments
63.
How Twitch Uses PostgreSQL(blog.twitch.tv)
2 points by postila 10y ago|0 comments
64.
by postila 10y ago
The very short video posted in CMAS news doesn't fully reflect the awesomeness of what's been done. The full recordings of one of the competition's days can be found here: https://www.youtube.com/watch?v=nyWBh
65.
The first YouTube streaming of a freediving competition captured by drone(cmas.org)
1 points by postila 10y ago|1 comments
66.
by postila 10y ago
Decision to store plain text user passwords must cost someone's job.
67.
Open Source SQL databases enter millions queries per second era(slideshare.net)
4 points by postila 10y ago|0 comments
68.
PostgreSQL migrations made easy(github.com)
15 points by postila 10y ago|0 comments
69.
by postila 10y ago
This looks like really good and well-timed reaction to Uber's case. And shame on Uber that it was absolutely not transparent, hiding its problems. If you use FOSS, you must be open to communications with the Open Source community. Ther
70.
Reasons to choose PostgreSQL 9.6(blog.taadeem.net)
109 points by postila 10y ago|51 comments
71.
by postila 10y ago
Have you tried this? https://github.com/ivalkeen/vim-simpledb
72.
by postila 10y ago
For some cases (like single HDD and low amount of RAM) it should be so, but for some cases(from "the whole table is already loaded to RAM" to "SSD" and to "a table is partitioned among multiple drives"), it mus
73.
Is there any tool to see all HN discussions for given URL?
2 points by postila 10y ago|2 comments
74.
by postila 10y ago
Many people smarter than me do think that caching [SQL] queries proved to be really bad idea (regardless of DBMS). Why caching API queries would be better? Even if I would use query caching, I cannot imagine how it would help me to deal wit
75.
by postila 10y ago
Ok, but nested loop in so many situations is totally losing to other algorithms to join data (like merge join, hash join) when you deal with large datasets, right? So again, it will be inefficient by default, for so many cases.
76.
by postila 10y ago
There is a lot of cases when user needs just 20 rows from billions but getting them is very hard problem. One of such examples is well-known: it's twitter-like data model, where a user can "follow" thousands of others and you
77.
by postila 10y ago
Yes but if in the past you could blame your internal developer for making slow SQL query, now these rich possibilities to perform really stressful queries to your DBMS are open to the public, right? The main riddle to me is: in case of RDBM
78.
by postila 10y ago
Does anybody considered this problem at all? (Giving too much flexibility to client and allowing non-optimal queries like joining several big tables or data collections w/o proper index support.) It's so weird that all materials I
79.
by postila 10y ago
oh, it was a pretty funny message. Official one! With huge amount of grammar errors in Russian text :-)
80.
by postila 10y ago
Yes, you're missing the fact that it's Russia, not SV. Couple of years ago ruble's exchange rates dropped significantly (it was ~33RUR for USD, now it's 64-65 rubles). Monthly salaries for a good engineer in Moscow are u
81.
by postila 10y ago
Rambler (rambler.ru) is more like Yahoo, not Yandex. Like Google, Yandex is more service-oriented, Rambler is more media-oriented. Rambler's numbers are also going down during many-many years, like Yahoo's. It alsotruggling from c
82.
by postila 10y ago
But you're right – a lot of such companies exist unfortunately. If Uber DBAs came to IRC or any public place (see http://Postgres.chat ) where Postgres experts are present and didn't hesitate asking questions, they woul
83.
by postila 10y ago
It's already seen during couple of years – google author's name on postgresql.org (maillists archives)
84.
by postila 10y ago
And I understand what you're saying. Similar things are happening when your child goes to school/college/etc. You pay for smth and she/he gets preferences. As I see, it's common both in US and Russia. But between br
85.
by postila 10y ago
Go on and try offering "campaign financing", or "creative accounting" to a policeman stopped you for speeding somewhere in California. Don't forget to record it on your smartphone. In Russia, literally ANY road poli
86.
by postila 10y ago
Details were in the talk itself, watch the video https://www.youtube.com/watch?v=-SS4R1sFH3c . In particular, they mentioned how Tom Lane fixed a bug they found and did it just in 38 minutes.
87.
by postila 10y ago
1. Price if obvious reason of migration, and in their case (multiple datacenters and "-1 datacenter" policy) it was huge benefit. 2. The other concern was Oracle's slow bugfixing and reaction to feedback. So, this is a good c
88.
by postila 10y ago
Let's talk Oracle vs Postgres rather than USA vs Russia
89.
Yandex.Mail's successful migration from Oracle to Postgres [pdf](pgcon.org)
415 points by postila 10y ago|210 comments
90.
by postila 10y ago
What kind of nightmares?

More ›