nikita

8 ms·

31.
Top Features in Postgres 17(neon.tech)
5 points by nikita 2y ago|0 comments
32.
by nikita 2y ago
Neon CEO here. Happy to answer any questions
33.
by nikita 2y ago
Are you guys planning to opensource your work at crunchy?
34.
by nikita 2y ago
Very soon, it needs to get a bit more stable.
35.
by nikita 2y ago
Postgres IS missing an analytics engine. benchmark.clickhouse.com puts it at the bottom of the list and ~1000x slower than @duckdb and @ClickHouseDB. Here are the scenarios and how to address them 1. Query Parquet and Iceberg from Postgres.
36.
by nikita 2y ago
It’s mostly a region question. If the data centers are physically close to each other latencies will be low as well: https://neon.tech/blog/sub-10ms-postgres-queries-for-vercel-...
37.
by nikita 2y ago
Price/performance will be a wash at least for steady workloads. But usability will be massively better. Both platforms offer various things to make developer more efficient and dev cycle shorter
38.
by nikita 2y ago
Yes of course. People do it all the time. For small workloads egress cost doesn’t matter. For larger - well it does. I wish it was illegal to charge so much for egress for cloud providers.
39.
by nikita 2y ago
Ah, it is whatever AWS calls vCPU. Virtual core in an EC2 instance
40.
by nikita 2y ago
Compute size is measured in CUs. 1CU is 1vCPU and 4GiB of RAM. Database compute and it's read replicas autoscale from 0.25 to 10 CU based on load and down to zero when inactive. And autoscaling works like this: https://neon.
41.
by nikita 2y ago
Neon CEO: Storage is will be long term unlimited. Short term it is few terabytes - we are constantly increasing the ceiling as storage sharding improves: https://neon.tech/blog/how-we-scale-an-open-source-multi-ten...
42.
by nikita 2y ago
It's full compatibility with libpq Postgres protocol vs performance. Libpq is chatty and therefore you incur roundtrip costs. HTTP Post is one shot, but you lose transactional semantics if you don't provide all the queries in the
43.
by nikita 2y ago
We will consider it in the future. The important property in sharding should be the ability to go up and down in the number of shards. Each shard will increase write throughput and we should allow to go from 1 shard (default) to N to M and
44.
by nikita 2y ago
Please say more of what you would change in the README and we will update
45.
by nikita 2y ago
We debated internally if we wanted to provide MySQL too. On one hand it’s not that different and our storage can be adapted to run MySQL. On the other hand focus and product identity are very important for startups. So it’s only Postgres
46.
by nikita 2y ago
I'm CEO at Neon. We are very excited to partner with Microsoft. Happy to answer questions!
47.
The State of the Postgres Community(vondra.me)
3 points by nikita 2y ago|0 comments
48.
by nikita 2y ago
(Neon CEO) What makes it not serverless in your opinion? This is our architecuture: https://neon.tech/docs/introduction/architecture-overview and no, you can not get the same from CloudSQL.
49.
by nikita 2y ago
Neon CEO Happy to answer any questions here. We hope we will make this happen some time
50.
Multi-Threaded Postgres [video](youtube.com)
2 points by nikita 2y ago|1 comments
51.
Postgres has low connection limits and goes towards multi-threaded architecture(twitter.com)
13 points by nikita 2y ago|1 comments
52.
by nikita 2y ago
(Neon CEO) We could consider that. Right now we are exploring to actually run the app in the same or next to the micro-VM that runs Postgres. https://neon.tech/docs/introduction/architecture-overview
53.
Motherduck Is Now GA(motherduck.com)
15 points by nikita 2y ago|0 comments
54.
by nikita 2y ago
(CEO of Neon.tech) Aurora is one of the few real innovations in the database space recognized by SIGMOD: https://sigmod.org/sigmod-awards/citations/2019-sigmod-syste... It provides a lot of benefits to the user an
55.
by nikita 2y ago
Postgres is missing a proper columnstore implementation. It's a big gap and it's not easy to build. One solution could be integrating duckdb in a similar way as pgvector. You need to map duckdb storage to Postgres storage and reus
56.
by nikita 2y ago
I have another question. So far on the clickbench leaderboard it's 15x slower than baseline. The number 1 place is 1.67 slower the baseline. I assume that's DataFusion speed. What's the plan to improve upon it?
57.
by nikita 2y ago
It looks like hyper scalers can still host it as long as they are publishing changes to the source code ? Am I reading the license right ?
58.
by nikita 2y ago
This is great work! Could you please comment on the choice of your license. Lost Postgres extension that achieve wide adoption use Postgres, MIT or Apache license.
59.
MIT Uncovers Photomolecular Effect: Light Can Vaporize Water Without Heat(scitechdaily.com)
2 points by nikita 2y ago|1 comments
60.
Postgres Storage as a Transaction Journal(neon.tech)
22 points by nikita 2y ago|0 comments

More ›