nikita

8 ms·

61.
by nikita 2y ago
I believe you had to opt in and it has some legal language before it. All the data pages were stripped and SQL Servers stores all data in the buffer pool. But of course you could find some stuff on the stack and other caches.
62.
by nikita 2y ago
Microsoft is really good at this BTW. At SQL Server we had mini dumps they were tiny stripped out of personal info and incredibly useful. And a full dump of a production SQL Server even at that time (15 years ago) would be a huge file - too
63.
by nikita 2y ago
(Neon CEO) I'm sorry you had this experience. We had several instabilities in Q4 as the system became popular. That was the one of the reasons we called it "preview" until we got stability to where it needs to be. We are also
64.
by nikita 3y ago
Postgres \ commands are incredible shortcuts that are a pain to write in sql. E.g. \dt+ translates to SELECT schemaname, tablename, tableowner, tablespace, pg_size_pretty(pg_total_relation_size(quote_ident(schemaname) || &#x2
65.
by nikita 3y ago
When Neon goes down twitter lights up, we haven't had it for a long time now. Internally we are measuring the number of projects under 5 min in the last 30 days and it's been lower double digits over 700K+ total databases under ma
66.
by nikita 3y ago
Merging is a tricky one for operational databases. We think merging schemas is a useful feature. Merging data is likely not. The feature is coming!
67.
by nikita 3y ago
You will likely save money on Neon. Please reach out to our team (contact sales, support or discord) and we will give you an estimate
68.
by nikita 3y ago
We are currently lumping storage retention history (we store all the history for a period of time so you can time travel) and backups together. We are rethinking this, please stay tuned
69.
by nikita 3y ago
Yes :)
70.
by nikita 3y ago
Please join our discord a number of people are doing that and the community is helping out.
71.
by nikita 3y ago
(Neon ceo) Our storage tech is amazing :) And written in Rust for extra fun and profit
72.
by nikita 3y ago
(Neon ceo) They never exceed the limit you set in the number of cpus. In practice the cost a lot less than max number of cpus * time. Think about area under the curve of cpu(t).
73.
by nikita 3y ago
There are some limits. Architecture wise storage indefinitely and compute up to the largest bare metal node on Amazon plus as many read replicas as you want.
74.
by nikita 3y ago
(Neon ceo) 1. You should try and see the experience 2. It scales to 0. If you have lots of projects aurora costs really add up 3. It supports branches and integrates with vercel. You can have environment for every dev and every pr. 4. We
75.
by nikita 3y ago
We don’t charge for egress. We are going to be on GCP eventually, but azure will come first
76.
by nikita 3y ago
One thing that is very important is what you charge for. Software or service. We are only charging for the cloud service and it has major implications in the “company architecture”. When you charge for software like yuga and roach and for t
77.
by nikita 3y ago
This is pretty much the first part of the strategy: database is just a url. We have more cool stuff coming!
78.
by nikita 3y ago
The problem that shared nothing systems lose compatibility with the single node system. So planetscale and yugabyte are not 100% compatible with Postgres. They are also very expensive at the low end hence the free tiers are discontinued. I
79.
by nikita 3y ago
Neon is open source and under a good license: Apache 2
80.
by nikita 3y ago
This is a very deliberate effort which is venture funded. It started with a deck three years ago and a team of myself, Heikki and Stas. Since it’s my second company (prev was singlestore) the early funding was relatively easy. Later funding
81.
by nikita 3y ago
(neon ceo) Yes you will have an S3 fetch latency for downloading a layer file for such data. However we don't page out aggressively so it's a very unlikely event. Most of the time you will be fetching from a locally attached SSD w
82.
New benchmark study puts Recraft ahead of Midjourney v6 and DALL-E 3(recraft.ai)
2 points by nikita 3y ago|1 comments
83.
Running Postgres in Bun(twitter.com)
3 points by nikita 3y ago|0 comments
84.
by nikita 3y ago
We are happy to try for sure. Analytics workloads really benefit from separation of storage and compute!
85.
by nikita 3y ago
I’m CEO of Neon. Happy to answer questions here
86.
Bring your own S3 to Neon Postgres(neon.tech)
3 points by nikita 3y ago|3 comments
87.
by nikita 3y ago
What volumes are we talking about. There are ways to speed things up dramatically. Index build just became multithreaded (see above). We have ideas on what to do with ingest. Also do you interest from S3 ?
88.
by nikita 3y ago
Lol rare collaboration between neon, AWS, and supabase. But if Postgres wins we all win!
89.
by nikita 3y ago
What is taking the most time at scale? Is this ingest, index build or lookups ?
90.
by nikita 3y ago
(Neon CEO) It’s about to get a lot better too. Pgvector now supports multi-threaded build https://github.com/pgvector/pgvector/issues/409#issuecomment...

More ›