samokhvalov

16 ms·

1. 151.▲
   by samokhvalov 7y ago

   Not yet. Is there any particular interest? If so, I'd love to explore how it could work, let's connect.
2. 152.▲
   by samokhvalov 7y ago

   Thank you for very detailed feedback!! > People's existing tendency to expose critical data via Slack shouldn't be reinforced I agree with you. However, depending on company's policy, raw SQL, even with some concrete value
3. 153.▲
   by samokhvalov 7y ago

   Joe uses Docker and ZFS (or LVM+ext4, alternatively) on a separate machine, where data is transferred, normally, from archives (optionally, being transferred constantly, if there is a small Postgres "sync" server with "restor
4. 154.▲
   by samokhvalov 7y ago

   Hi, Postgres.ai founder here. Production is not affected, the chatbot works with thin clones provided by Database Lab https://gitlab.com/postgres-ai/database-lab/ . In general, you are right. If, in your case, usin
5. 155.▲
   Joe, a Postgres query optimization bot(postgres.ai)

   174 points by samokhvalov 7y ago|37 comments
6. 156.▲
   “PostgreSQL Is the Linux of Databases”(twitter.com)

   2 points by samokhvalov 7y ago|0 comments
7. 157.▲
   by samokhvalov 7y ago

   Sure. Thin cloning is a way to obtain a clone of data that looks fully independent (you can modify, add, delete data), but physically multiple clones share physically the same data -- except those blocks that were changed. This is implement
8. 158.▲
   by samokhvalov 7y ago

   Thank you! I'll check out aquameta, looks interesting.
9. 159.▲
   by samokhvalov 7y ago

   Well, not really. Two key differences: 1) dump/restore approach is one of "thick cloning" methods. It will take a really significant amount of time. Roughly, thick cloning speed for modern hardware and networks is somewhat ~1
10. 160.▲
    by samokhvalov 7y ago

    There are various approaches here, and there are some FOSS tools that you can use. Some links: - https://blog.taadeem.net/english/2019/01/03/8_anonymization_... – description of methods, and a tool for P
11. 161.▲
    by samokhvalov 7y ago

    Hi! Postgres.ai founder here. This is requested quite often – for example, if we copy the database from production, sometimes it's needed to remove all personal data not to break regulations. It is possible in Database Lab, but it&#x27
12. 162.▲
    by samokhvalov 7y ago

    Great news. But unfortunately, it is not the original data snapshot as the title says, it's Apache Parquet format. So this is useful for analytical tasks only. For operational tasks, still, the only option (besides RDS cloning) for Pos
13. 163.▲
    Odyssey 1.0, a scalable multi-threaded PostgreSQL connection pooler(github.com)

    3 points by samokhvalov 7y ago|0 comments
14. 164.▲
    by samokhvalov 7y ago

    No, it was a single real-world database. Just in case if it looks surprisingly that Postgres can deal with such numbers of objects, I suggest checking this out: https://www.pgcon.org/2013/schedule/attachments/
15. 165.▲
    by samokhvalov 7y ago

    One single database. Yes, quite unusual case of multi-tenant database. We needed to use checkup there a while ago so made some optimizations. I agree with you, the statement is not 100% clear. We will double-check it (and maybe will simulat
16. 166.▲
    by samokhvalov 7y ago

    Hi, the founder of Postgres.ai here. The footprint is very minimalistic. I have 15+ years of Postgres DBA experience, and what this tool does basically is what I usually do myself with performing Postgres health checks under heavy load. But