postila

6 ms·

1. 1.▲
   Will Postgres live forever? [pdf](momjian.us)

   2 points by postila 8y ago|0 comments
2. 2.▲
   USE, RED and real-world PgBouncer monitoring(blog.okmeter.io)

   2 points by postila 8y ago|0 comments
3. 3.▲
   by postila 8y ago

   Better, automated tools for optimization are needed. Postgres ecosystem right now lacks a lot of things that enterprise systems have for decades.
4. 4.▲
   Solving Data Science Tasks with Greenplum DB(dwhsys.com)

   3 points by postila 8y ago|0 comments
5. 5.▲
   How to store time-series data in MongoDB, and why that’s a bad idea(blog.timescale.com)

   1 points by postila 8y ago|0 comments
6. 6.▲
   HTTP Analytics for 6M requests per second using ClickHouse(blog.cloudflare.com)

   3 points by postila 8y ago|0 comments
7. 7.▲
   PostgreSQL 10 Upgrade(bricklen.github.io)

   3 points by postila 8y ago|0 comments
8. 8.▲
   by postila 9y ago

   things like superuser should be disabled by default (only DBA needs superuser access, not anybody else).
9. 9.▲
   by postila 9y ago

   Also: 3. Ensure that you don't use or provide anybody superuser in Postgres. (Otherwise, there is much simpler way to download&run anything that explain in the article – just `copy tablename from program 'wget ... &&
10. 10.▲
    by postila 9y ago

    This is one of the interesting optimizations that DBMS should do automatically but it doesn't. https://github.com/NikolayS/postgres_dba -- this toolset includes a version of report (see report a1) which analyses a
11. 11.▲
    by postila 9y ago

    I mean, in more recent Postgres versions, more things related to window functions are available – like CUBE, GROUPING SETS, etc. 9.3 was released back in 2013.
12. 12.▲
    by postila 9y ago

    ||'' is another way to do ::text ? :-)
13. 13.▲
    by postila 9y ago

    select version(); PostgreSQL 9.3.20 on x86_64-unknown-linux-gnu, compiled by gcc (Ubuntu 4.8.4-2ubuntu1~14.04.3) 4.8.4, 64-bi I wonder why so old version is being used. I will be not supported by the community pretty soon.
14. 14.▲
    by postila 9y ago

    postgreS
15. 15.▲
    Parallel Hash for PostgreSQL(write-skew.blogspot.com)

    4 points by postila 9y ago|0 comments
16. 16.▲
    CMU 15-721 Advanced Database Systems [video](youtube.com)

    252 points by postila 9y ago|17 comments
17. 17.▲
    Sudoku solver in recursive CTE (Postgres)(wiki.postgresql.org)

    1 points by postila 9y ago|0 comments
18. 18.▲
    by postila 9y ago

    Here is an example of ~$65 item merged with others https://www.amazon.com/gp/product/B076RS1WRZ/ref=oh_aui_deta... – a lot of five-star reviews (marked as verified ), but very bad quality.
19. 19.▲
    by postila 9y ago

    MS Azure also provides Postgres now [1]. And also does Alibaba Cloud [2]. They even have a special version of it – something for analytics/warehousing [3]. So at least 4 big cloud providers have Postgres! 1) https://azure.mi
20. 20.▲
    10 Cool SQL Optimisations That Do Not Depend on the Cost Model(blog.jooq.org)

    4 points by postila 9y ago|0 comments
21. 21.▲
    PostgreSQL 10 New Features with Examples [pdf](h50146.www5.hpe.com)

    23 points by postila 9y ago|0 comments
22. 22.▲
    by postila 9y ago

    +1. I also use *@mydomain.com feature in G Suite, and it's very convenient to understand which companies sell/pass email databases to others w/o my permission. In some cases, you need to reply from that "aliased" ad
23. 23.▲
    by postila 9y ago

    and redash https://redash.io/ and many more
24. 24.▲
    PostgreSQL Index bloat under a microscope(pgeoghegan.blogspot.com)

    3 points by postila 9y ago|0 comments
25. 25.▲
    PostgreSQL 10 New Features. With Examples [pdf](h50146.www5.hpe.com)

    3 points by postila 9y ago|0 comments
26. 26.▲
    Uber Will Merge with the ‘Google of Russia’ Yandex in 6 Countries(fortune.com)

    1 points by postila 9y ago|0 comments
27. 27.▲
    by postila 9y ago

    Ditto. ~1.5 years in one project, ~1y in another. Recent update is excellent -- now you can see HTTP headers & cookies inside Postgres functions, so it's possible to save user IP address, user agent, etc. So easy, quick, scalable a
28. 28.▲
    Advanced SQL in PostgreSQL(slideshare.net)

    6 points by postila 9y ago|0 comments
29. 29.▲
    PostgreSQL 10 Major Features(momjian.us)

    1 points by postila 9y ago|0 comments
30. 30.▲
    Comparing Oracle Spatial and Postgres PostGIS(csjournals.com)

    2 points by postila 9y ago|0 comments