ahachete

54 ms·

1. 271.▲
   by ahachete 7y ago

   Interesting. Actually most of the dependencies come from the embedded presentation on speakerdeck. Something to consider. Amazon (AWS) is where the site is hosted (S3 + CloudFront, mostly) so that's understandable.
2. 272.▲
   by ahachete 7y ago

   Thanks for letting us know. We will definitely consider this.
3. 273.▲
   by ahachete 7y ago

   Thank you for the feedback, note taken.
4. 274.▲
   by ahachete 7y ago

   But I mostly disagree with that math also ;) Mostly, because that math is subject to other parameters that are not easy to know statically --otherwise, why aren't them Postgres defaults? For example: shared_buffers is 1/4 of RAM a
5. 275.▲
   by ahachete 7y ago

   Indeed. This is pretty much part of what it will be coming in the next iteration. What we're thinking is providing a set of "cards", where each card contains a theme: logging tuning, memory parameters, autovacuum, etc. And th
6. 276.▲
   by ahachete 7y ago

   I beg to disagree ;) Postgres performance with the default configuration could be significantly slower (30-40%, sometimes more than 100%) than a properly tuned configuration. It is quite important and one of the main recommendations and job
7. 277.▲
   by ahachete 7y ago

   Yes, that is coming. If you want to be woken up when the config file management is up, I'd recommend you to subscribe to the mailing list and/or follow on Twitter, you will be promptly informed ;) Re: Disqus. It's not our fav
8. 278.▲
   by ahachete 7y ago

   We don't believe much in such static tuning recommendations. Our experience tells us that they can do as much good as bad. It is much more important to understand and learn a bit about how to tune them. You need to understand the workl
9. 279.▲
   by ahachete 7y ago

   > Semi-OT rant: can we stop these "for humans" qualifiers? It wasn't really intentional, and I actually didn't even know where or when this originated. It just sounded "right" (non native English speaker her
10. 280.▲
    Show HN: Postgresqlco.nf: PostgreSQL Configuration for Humans(ongres.com)

    223 points by ahachete 7y ago|71 comments
11. 281.▲
    by ahachete 7y ago

    > For the BYO - all we need is the database connection string. Then this means that the database should be publicly accessible. Many would not accept this from a security perspective (regardless of the use of SSL and even certificate aut
12. 282.▲
    by ahachete 7y ago

    As I mentioned on a comment above ( https://news.ycombinator.com/item?id=22115752 ) it doesn't really require the WAL but rather the logical decoding stream. This is offered by some of the PostgreSQL-aaS.
13. 283.▲
    by ahachete 7y ago

    Great. May you ellaborate on the BYO concept? How do you bring it? Or you will just ask Postgres owners to install an agent which will then connect from customers' premises to your middleware? BTW hosting your own Postgres service is a
14. 284.▲
    by ahachete 7y ago

    Just a quick precision, if I'm not mistaken: this project is not decoding the (version, architecture dependent) WAL stream as it seems to be implied by https://news.ycombinator.com/item?id=22114603 But it rather uses l
15. 285.▲
    by ahachete 7y ago

    I think you should include the BTP database in the CI test suite ;)
16. 286.▲
    by ahachete 7y ago

    We have been using postgres-checkup for quite a while. Indeed, we have standardized on it as the basis on which we elaborate the health check and performance report analysis that we provide to our support customers. It is a great project, c
17. 287.▲
    by ahachete 7y ago

    Scottish can do a referendum by themselves because that's allowed by their laws, and goes back to historical reasons. In Spain, the Constitution does not allow for a part of Spain to decide secession. It's very different stories.
18. 288.▲
    by ahachete 7y ago

    I think you read me wrong. I'm not denying that cultural reasons might be valid to support secession. I'm saying that having a different culture or language does not imply that you want or need to secede. Indeed, in my opinion,
19. 289.▲
    by ahachete 7y ago

    > - They do not accept the authority of the government of Spain, and therefore also not the constitution. You are right that they don't do, specially the authorities there. And this is particularly concerning and completely anti de
20. 290.▲
    by ahachete 7y ago

    So what? Also do Galicia, País Vasco, and many other regions and parts of Spain. And there's nothing wrong with that. In fact, it makes Spain a richer and culturally richer place. I love this diversity. But this is not related to seces
21. 291.▲
    by ahachete 7y ago

    There are many alleged reasons why some people from Catalonia want to secede from Spain. They all probably boil down to the perspective that they are a "rich" region and they will do better on their own. Similar to Brexit. Probabl
22. 292.▲
    by ahachete 7y ago

    It's not my business, as I don't use the FB app --and I won't. But even if the original intent was to help the debugging process, this is not acceptable. This is, to put it plainly, copying files from a user's device, wi
23. 293.▲
    by ahachete 7y ago

    Backups on databases like PostgreSQL are strongly consistent, regardless of where you take it from (master or replica). Postgres replication is strictly sequential wrt transaction commit order. As such, splitting the database may incur in s
24. 294.▲
    Having Lunch with PostgreSQL, MongoDB and JSON(ongres.com)

    8 points by ahachete 7y ago|0 comments
25. 295.▲
    by ahachete 8y ago

    Why not Spanish? (OK, I'm biased being Spanish, but that's not the point). While it's "only" spoken natively by 40M+ people in the EU, it is spoken globally by more than 1B people. It's, arguably, easier to lea
26. 296.▲
    by ahachete 8y ago

    Much better: replace Docker with https://podman.io/ , which runs with user privileges, no root.
27. 297.▲
    by ahachete 8y ago

    Cool development. Great to have it handy in the toolbox. I still have two concerns when simulating a workload in order to test configurations / DDL changes: - Processing the logs implies generating all for every query that arrives. Whi
28. 298.▲
    by ahachete 8y ago

    Yes, very frequently. I haven't measured it, but it lasts quite long.
29. 299.▲
    by ahachete 8y ago

    Writing from a Carbon X1 6th gen right now. Ubuntu 18.04 stock, no tweaking required, all worked no problem. The best laptop I ever had. Previously owned a 4th gen. 16.04, minor tweaking, also excellent laptop. Pricey, but the best you can
30. 300.▲
    by ahachete 8y ago

    Feel free to check https://postgresqlco.nf A humble effort to document all PostgreSQL configuration parameters and provide some guidance.