Instaclustr Blog » PostgreSQL
2 FOLLOWERS
Managed Services and Support for Apache Cassandra, Apache Kafka, PostgreSQL, OpenSearch, Elasticsearch and Redis
Instaclustr Blog » PostgreSQL
1M ago
Check out all the new features and updates added to our platform over the last few months!
As always, if you have specific feature requests or improvement ideas you’d love to see, please get in touch with us.
Major Announcements: Apache Cassandra®
AWS PrivateLink for Apache Cassandra® on the Instaclustr Managed Platform
NetApp is excited to announce that the Instaclustr Platform now supports the use of AWS PrivateLink to connect to Apache Cassandra clusters running on the platform. This new feature provides customers running on AWS with a more secu ..read more
Instaclustr Blog » PostgreSQL
2M ago
PostgreSQL® and Planning for Those Unknown Events
“You won’t need it for every instance. But when you do, you’ll notice the difference right away.”
Sure, this quote may be squarely about Instaclustr Managed PostgreSQL on Azure NetApp Files (ANF) but the underlying lesson certainly rings true for countless other (read: non-technical) situations as well:
Going for a hike on a trail you already know like the back of your hand? You probably won’t need a compass, but it could prove rather handy if you become disoriented
Driving around in snowy conditions all winter? You won ..read more
Instaclustr Blog » PostgreSQL
2M ago
We are thrilled to announce an exciting new feature that takes data protection and accessibility to the next level: Multi-region replication for Instaclustr for PostgreSQL®. This innovative feature is designed to provide you with a robust backup that you can rely on, even in the face of a complete regional outage.
In today’s digital landscape, data is the lifeblood of any organization, and ensuring its safety and accessibility is paramount. As part of our ongoing commitment to provide our clients with the most reliable and secure data management solutions, we have developed multi-region ..read more
Instaclustr Blog » PostgreSQL
2M ago
They’re 2 of the most popular database systems used today, and for good reason: PostgreSQL® and MySQL.
Choosing the right technology for your tech stack is vital for long-term success, and PostgreSQL and MySQL offer their unique benefits and drawbacks.
But how should you go about deciding which database to adopt? What are the critical factors and key differences to take into consideration?
From overall architecture, data types, and indexing options, to scalability, security, and more, we’ll examine the strengths, weaknesses—and everything in between—of PostgreSQL ..read more
Instaclustr Blog » PostgreSQL
4M ago
The pgvector open source extension for similarity search is now available as an add-on to your Instaclustr for PostgreSQL® services.
The pgvector extension provides the ability to store and search ML-generated vector type data. Using a specific index type for querying a table, pgvector allows you to find a vector’s exact or approximate nearest neighbors, or data items.
Utilizing machine learning models, all data items from a set can be mapped into a single n–dimensional vector space, irrespective of the dataset’s size. Known as data vectorizing, this process transforms ..read more
Instaclustr Blog » PostgreSQL
5M ago
There have been a lot of exciting things happening at Instaclustr! Here’s a roundup of the updates to our platform over the last few months.
As always, if you have a specific feature request or improvement you’d love to see, please get in contact with us.
Major Announcements: Cadence®
The Instaclustr Managed Platform adds HTTP API for Cadence®:
The Instaclustr Managed Platform now provides an HTTP API to allow interaction with Cadence® workflows from virtually any language. For further information or a technical briefing, contact an Instaclustr Customer Success represe ..read more
Instaclustr Blog » PostgreSQL
5M ago
Instaclustr is excited to announce the availability of PostgreSQL® 16, the latest major release on the Instaclustr Managed Platform.
PostgreSQL is the world’s most advanced open source, object-relational database system. Instaclustr is a leading provider of open source data solutions, helping customers avoid the risks of vendor lock-in and unsupported software.
PostgreSQL 16 brings significant performance improvements, including optimized query planning, parallel joins, and accelerated CPU processing. It enhances developer experience with expanded SQL/JSON support. Moni ..read more
Instaclustr Blog » PostgreSQL
6M ago
Why Use PGVector?
We’ve all been in this position before: trying to quickly solve a technical problem just to end up spending hours browsing through endless documentation in the hope of finding a solution. With all that time going to waste, there has to be a better way to search documentation.
And now, there is.
Instaclustr has recently introduced the PGVector extension to our PostgreSQL Managed Service, enabling users to quickly and easily search text data without the need for a specialized database to store your embeddings—a major development in the realm of textual d ..read more
Instaclustr Blog » PostgreSQL
7M ago
Where Did I Drop My PostgreSQL® Cluster?
Instaclustr by Netapp has seen enormous growth in the number of accounts that our larger enterprise customers have created to manage their deployments. This naturally led to the introduction of Instaclustr Organizations linked to accounts in a similar, flexible way; you could even have a user manage multiple organizations.
That can be a lot of users, linked to even more accounts, linked to a few organizations, all of whom are creating and managing increasingly large clusters, reliably serving data upstream into their business functions.  ..read more
Instaclustr Blog » PostgreSQL
7M ago
A fast and convenient (and common) way to deploy PostgreSQL® is in a Docker container. However, this can have some unexpected complications since PostgreSQL relies heavily on shared memory, and Docker handles shared memory differently from a traditional system. This means some extra care is needed to ensure your PostgreSQL system is running as well as it can.
What is Shared Memory?
A computer will normally have several different types of memory, all with different access latency and read and write speeds. The fastest of these is the cache that lives on the same chip as your CPU, an ..read more