Tag: Hardware

Feed: Planet PostgreSQL. Development on Citus first started around a decade ago and once a year we release a major new Citus open source version. We wanted to make number 10 something special, but I could not have imagined how truly spectacular this release would become. Citus 10 extends Postgres (12 and 13) with many new superpowers: Columnar storage for Postgres: Compress your PostgreSQL and Citus tables to reduce storage cost and speed up your analytical queries. Sharding on a single Citus node: Make your single-node Postgres server ready to scale out by sharding tables locally using Citus. Shard rebalancer ... Read More

Feed: Teradata Blog. The Big Tech giants dominate their markets by using data to improve product and experience with every interaction. Pulling on digital threads to connect data from every engagement and every touch point they ensure they capture, and keep, their customer’s attention.  The automotive industry can emulate this by analysing data from every journey to improve customer experience and guide individual choices.To do so, automotive OEMs must leverage connected vehicles, browsing behaviour and customer apps to connect to their end customers outside of dealership visits. In the traditional engagement model, the sum of all direct interaction with customers, ... Read More

Feed: AWS Public Sector Blog. Author: AWS Public Sector Blog Team. To allow more visibility into and management of Amazon Web Services (AWS) resources and expenses and minimize the cloud skills training required to operate these resources, AWS Partner RONIN created the RONIN research computing platform. RONIN gives researchers the ability to create exactly the computers or storage that they need in minutes. With access to the flexibility and scalability of the cloud, researchers are able to store and process larger datasets, collaborate globally, and adapt to changing technologies and research methods instantly. Research IT can spend less time provisioning ... Read More

Feed: Liquid Web. Author: Misael Ramirez; Horizontal vs vertical scaling: what’s the meaning of those concepts? Choosing the right solution can dramatically improve your performance or cost-effectiveness. One of the most difficult things in system design and application hosting is trying to estimate the reach of our apps. This might come as a shock, but unfortunately, you can’t predict the future. The best you can do is project what would be our user base and hire computational power based on that projection. But what if the projection goes wrong? If you look at the first graph above, you can see ... Read More

Feed: Microsoft Azure Blog. Author: Jeremy Winter. In response to the global health and macroeconomic crisis that began last year, customers have been accelerating their digital transformation efforts at an unprecedented pace to help bolster organizational resilience. They have depended on the cloud to not only help maintain business continuity throughout the recovery but also reimagine their mission for long-term growth. Customers like Albertsons Companies, Actavo, H&R Block, and Additiv have shared how migrating to the cloud with Microsoft Azure allowed them to stay resilient: "Within the space of a week, we were able to tick a box that said, 'If lockdown ... Read More

Feed: Planet PostgreSQL. 1. Overview PostgreSQL supports many System Information Functions, such as Session Information Functions, Access Privilege Inquiry Functions, Schema Visibility Inquiry Functions, System Catalog Information Functions, Transaction ID and Snapshot Information Functions, etc. However, you may want build some special functions and integrate them into the PostgreSQL. This blog is going to walk through the steps about how to build your own System Information Functions into PostgreSQL. 2. Analyze the requirement Since there are so many functions built-in PostgreSQL already, you should perform some research and analysis before you decide to create a new one. In this blog, ... Read More

Feed: AWS Public Sector Blog. Author: Farhad Jahangirov. Applications running on LAMP (Linux, Apache, MySQL, and PHP) stack are ubiquitous—WordPress alone represents 38% of all content management systems. Other popular CMS applications such as Drupal and Joomla also run on LAMP as well as Moodle, a widely used learning management system (LMS). Because of the popularity of these applications, public sector organisations such as educational institutions should protect their business continuity by implementing disaster recovery (DR) solutions: policies, tools, and procedures to help the recovery or continuation of technology infrastructure and systems following a disaster. Amazon Web Services (AWS) Professional ... Read More

Feed: Microsoft Azure Blog. Author: Roanne Sones. In today’s fast-paced world, there is often a need for instantaneous, real-time responses. Companies are finding the computing needed to support this 24/7 mentality generates staggering amounts of data, often from devices out in the physical world. This influences a shift in priorities as companies look for technology that gives them the flexibility to innovate anywhere in their environment. The biggest trend: the evolution of cloud strategies to include edge and hybrid investments. This hybrid cloud journey gives companies the flexibility to easily handle future growth and technology needs. Add in the movement ... Read More

Feed: Planet PostgreSQL. 03 Mar 2021 Are you tired of this syntax in PostgreSQL? SELECT jsonb_column->'key' FROM table; UPDATE table SET jsonb_column = jsonb_set(jsonb_column, '{"key"}', '"value"'); The select part is actually fine. But for updates, especially for complex updates, it could be pretty verbose and far from being ergonomic. What would you say to this syntax instead? SELECT jsonb_column['key'] FROM table; UPDATE table SET jsonb_column['key'] = '"value"'; With subscripting it looks more concise and probably even familiar for developers due to its “pythonic” style. If you like this syntax more I have good news for you, recently a patch implementing ... Read More

Feed: Microsoft Azure Blog. Author: Erin Chapple. As our customers move beyond immediate crisis needs, such as enabling remote work, many are accelerating cloud adoption to increase competitive advantage and stay more digitally resilient. Enabling an agile, scalable, high-performing, and reliable infrastructure is critical to long-term success. Microsoft is committed to continuous innovation in Azure IaaS capabilities to help customers achieve these goals. Today, we are announcing new updates to our Azure infrastructure portfolio that help address a wide range of customer needs. Increase agility with access to more choices and flexibility Being responsive to rapidly changing business requirements is ... Read More