samokhvalov

6 ms·

31.
by samokhvalov 2y ago
have you had minor and major upgrades? with really 0 downtime?
32.
by samokhvalov 2y ago
there is also a problem of data locality and blocks present in caches (page cache, buffer pool) at any given time, in general -- UUIDv4 is losing to bigint and UUIDv7 in this area
33.
by samokhvalov 2y ago
some related stuff: - https://commitfest.postgresql.org/48/4388/ (original patch created live https://www.youtube.com/watch?v=YPq_hiOE-N8 ) - https://postgres.fm/episodes/uuid
34.
Why Postgres Extensions should be packaged and distributed as OCI images(ongres.com)
2 points by samokhvalov 3y ago|0 comments
35.
by samokhvalov 3y ago
Yes But why? Patroni is great for HA and it doesn't require k8s.
36.
by samokhvalov 3y ago
Clusters with HA, backups and so on
37.
by samokhvalov 3y ago
Why, indeed?
38.
by samokhvalov 3y ago
~~ Context: https://twitter.com/samokhvalov/status/1771573110858269014 ~1000 votes in just one day – obviously, this is an attractive topic to discuss, so wanted to have a thoughtful conversation here on HN.
39.
Ask HN: Best way to set up self-managed Postgres clusters?
26 points by samokhvalov 3y ago|16 comments
40.
Postgres.ai Bot(postgres.ai)
2 points by samokhvalov 3y ago|1 comments
41.
by samokhvalov 3y ago
very good example for each setting, we need to remember trade-offs and in this particular case, the trade-off is increased recovery time after potential crashes it is possible to conduct another benchmark that will measure this time, showin
42.
by samokhvalov 3y ago
> You can create a replication slot, take a snapshot, restore the snapshot to a new instance, advance the LSN and replicate from there - boom, you have a logical replica with all the data. Then you upgrade your logical replica. This is a
43.
by samokhvalov 3y ago
> The program is installed with clickhouse-client, has no dependencies, and works on almost any flavor of Linux. You can apply it to any database dump, not just ClickHouse. For instance, you can generate test data from MySQL or PostgreSQ
44.
Avoid Over-Indexing in Postgres(twitter.com)
6 points by samokhvalov 3y ago|0 comments
45.
by samokhvalov 3y ago
I checked the benchmarks and was surprised to see that native search is (a) so slow (seconds), and (b) demonstrating O(N) behavior – with indexing, it should not happen at all. Indeed, looking at the benchmark source code (thanks for provid
46.
by samokhvalov 3y ago
it's no 29
47.
by samokhvalov 3y ago
(Postgres.ai founder here – we develop https://dblab.dev ) There is one more very important difference here, not only FOSS vs proprietary. N thin clones on Aurora give you O(1) in terms of storage costs (you pay 1 time plus only
48.
by samokhvalov 3y ago
Well, understandable. This is true for any open-source product that is under control by a single company and the majority of contributions comes from this company. Yes, we aim to have revenue (as any company) from our paid offering. But not
49.
by samokhvalov 3y ago
Underlying DBLab Engine is FOSS (Apache 2.0), with API, CLI and UI https://github.com/postgres-ai/database-lab-engine
50.
by samokhvalov 3y ago
You'll probably like this: https://github.com/vitabaks/postgresql_cluster
51.
by samokhvalov 3y ago
> Doesn’t handle automatic failover when a node dies Patroni, the most popular autofailover solution for Postgres, is developed in Zalando. Of course it's included in Zalando operator by default.
52.
by samokhvalov 3y ago
beware of the issues related to postgres subtransactions https://postgres.ai/blog/20210831-postgresql-subtransactions...
53.
by samokhvalov 3y ago
(Co-host here) Thanks for posting!
54.
by samokhvalov 3y ago
Hopefully, it will soon have it: https://datatracker.ietf.org/doc/html/draft-ietf-uuidrev-rfc...
55.
by samokhvalov 3y ago
We discussed some of these problems here during a Postgres.tv session, and developed a patch to support ULID / UUIDv7: https://www.youtube.com/watch?v=YPq_hiOE-N8 And then Andrey proposed a patch in the pgsql-hackers m
56.
by samokhvalov 3y ago
What do you do if you need to check index ideas, or new table design?
57.
by samokhvalov 4y ago
:)
58.
by samokhvalov 4y ago
Studied database theory at uni (20002-2004) -> a few years of work with Ora and MS -> startup, attempt to use MySQL (in 2005), cannot use it after all those others -> switched to Postgres, rewriting all the code code in a few days
59.
Intercom's ChatGPT-based support bot(intercom.com)
1 points by samokhvalov 4y ago|1 comments
60.
Postgres Schema Change Mistakes(postgres.ai)
2 points by samokhvalov 4y ago|1 comments

More ›