Dylan  Iqbal

Dylan Iqbal


Build More Connected Products with Fermax | What I Wish I Knew

Francisco Sanchez, Chief Information Officer (CIO) of Fermax, shares his insights around the early stages of IoT implementation. Watch as he delves into the importance of having connected devices and the ability to communicate with said devices in a reliable and secure way.

Learn when Fermax realized they needed to make a change and discover how they implemented that change for their business, simplifying technical complexity using Azure IoT products.

  • 0:00 – Introduction
  • 0:39 – Fermax intro
  • 1:08 – When did you realize you needed to make a change?
  • 1:34 – What challenges were you solving?
  • 2:43 – What has been the impact of having a more connected product lifecycle?
  • 3:05 – How has this impacted the way you engage with your customers?
  • 3:47 – What would you have done differently?
  • 4:43 - What advice would you give to someone on a digital transformation journey?
  • 5:08 - What is the biggest lesson you’ve learned?

#iot #developer

What is GEEK

Buddha Community

Build More Connected Products with Fermax | What I Wish I Knew

PostgreSQL Connection Pooling: Part 4 – PgBouncer vs. Pgpool-II

In our previous posts in this series, we spoke at length about using PgBouncer  and Pgpool-II , the connection pool architecture and pros and cons of leveraging one for your PostgreSQL deployment. In our final post, we will put them head-to-head in a detailed feature comparison and compare the results of PgBouncer vs. Pgpool-II performance for your PostgreSQL hosting !

The bottom line – Pgpool-II is a great tool if you need load-balancing and high availability. Connection pooling is almost a bonus you get alongside. PgBouncer does only one thing, but does it really well. If the objective is to limit the number of connections and reduce resource consumption, PgBouncer wins hands down.

It is also perfectly fine to use both PgBouncer and Pgpool-II in a chain – you can have a PgBouncer to provide connection pooling, which talks to a Pgpool-II instance that provides high availability and load balancing. This gives you the best of both worlds!

Using PgBouncer with Pgpool-II - Connection Pooling Diagram

PostgreSQL Connection Pooling: Part 4 – PgBouncer vs. Pgpool-II


Performance Testing

While PgBouncer may seem to be the better option in theory, theory can often be misleading. So, we pitted the two connection poolers head-to-head, using the standard pgbench tool, to see which one provides better transactions per second throughput through a benchmark test. For good measure, we ran the same tests without a connection pooler too.

Testing Conditions

All of the PostgreSQL benchmark tests were run under the following conditions:

  1. Initialized pgbench using a scale factor of 100.
  2. Disabled auto-vacuuming on the PostgreSQL instance to prevent interference.
  3. No other workload was working at the time.
  4. Used the default pgbench script to run the tests.
  5. Used default settings for both PgBouncer and Pgpool-II, except max_children*. All PostgreSQL limits were also set to their defaults.
  6. All tests ran as a single thread, on a single-CPU, 2-core machine, for a duration of 5 minutes.
  7. Forced pgbench to create a new connection for each transaction using the -C option. This emulates modern web application workloads and is the whole reason to use a pooler!

We ran each iteration for 5 minutes to ensure any noise averaged out. Here is how the middleware was installed:

  • For PgBouncer, we installed it on the same box as the PostgreSQL server(s). This is the configuration we use in our managed PostgreSQL clusters. Since PgBouncer is a very light-weight process, installing it on the box has no impact on overall performance.
  • For Pgpool-II, we tested both when the Pgpool-II instance was installed on the same machine as PostgreSQL (on box column), and when it was installed on a different machine (off box column). As expected, the performance is much better when Pgpool-II is off the box as it doesn’t have to compete with the PostgreSQL server for resources.

Throughput Benchmark

Here are the transactions per second (TPS) results for each scenario across a range of number of clients:

#database #developer #performance #postgresql #connection control #connection pooler #connection pooler performance #connection queue #high availability #load balancing #number of connections #performance testing #pgbench #pgbouncer #pgbouncer and pgpool-ii #pgbouncer vs pgpool #pgpool-ii #pooling modes #postgresql connection pooling #postgresql limits #resource consumption #throughput benchmark #transactions per second #without pooling

studio52 dubai

studio52 dubai


How to find the best video production company in Dubai?

How to find the best video production company in Dubai?We are the best video production company in Dubai, UAE. We offer Corporate Video, event video, animation video, safety video and timelapse video in most engaging and creative ways.

#video production company #video production dubai #video production services #video production services dubai #video production #video production house

studio52 dubai

studio52 dubai


Top Video Production Companies in Dubai 2021

Looking for the top video production companies in Dubai in 2021? Choose the right video production company to enhance your product and service with the best video services.

#dubai video production company #video production company #video production house #top video production companies in dubai 2021 #video production #video production companies in dubai

Ajay Kapoor


Software Product Development Company, SaaS Development Services

PixelCrayons: Being a top software product development company, we are known for providing robust, secure, feature-packed, and scalable Software product engineering solutions as per the specific needs of businesses.

Get SaaS-based software product development services from initial strategy & planning to final deployment and after delivery support.

Being a trusted SaaS product development company, we cover the entire array of software product engineering services from consulting to development, testing and devops.

We turn your software product idea into reality by putting custom skillsets in place. With 16+ years of domain expertise, we have created 13800+ successful projects and garnered 6800+ happy customers from 38+ countries.

#software product development companies in india #software product development services #software product development company #software product development india #product development companies in india #software product development companies

Java Questions

Java Questions


Top Data Science Products Build In India - 2020

Analytics India Magazine brings the list of leading analytics and data science products for the year 2020 that have positively impacted businesses across the globe, helping them make decisions. To source the best 10 products, we reached out to more than 25 companies. Ranging from serving financial sectors to manufacturing, retailsolar and other industries, these products have made a significant impact on driving business value for the companies.

_Please note that this is not a ranking and the list is in no particular order. _

Cora Finance Analytics By Genpact

Cora Finance Analytic by Genpact is a comprehensive and persona-based financial analytics suite that enables data-driven decision making for finance professionals across all business units and functions. It aims at driving faster business outcomes by augmenting the evidence-based decision making cycle through Robust Data Foundation Layer, Advanced Analytics, Data Science Application, Domain Expertise and Smart Processes. It is built on a domain-centric data platform and can do real-time and API-based integration, including semi-structured and unstructured data.

**Key Differentiation Factor: **It is a technology platform agnostic and can be easily embedded into clients’ business workflows in any production environment — On-Prem, Cloud or Hybrid.

**Client, Sectors and Geographies Served: **It is being used by over 25 clients across sectors such as hi-tech, manufacturing and services, consumer packaged goods and retail. It serves across geographies such as the US, Europe, Asia, Australia.

About the Company: A global professional services firm, Genpact drives digital-led innovation and digitally-enabled intelligent operations for clients guided by deep experience in data and analytics. Headquartered in New York, it operates in more than 25 countries, accelerating the digital transformation to create bold, lasting results.

Prediction, Anomaly Detection By Quadrical AI

Working with the Renewable Industry (right now only Solar), Prediction by Quadrical AI helps companies maximise their returns on solar fields by assisting them in predicting with much higher precision exactly how much energy they will produce. It also points out faults, fissures and failures so they can be fixed. Using AI, they can track degradations to turn unplanned maintenance to planned maintenance. The platform further keeps learning and improving with time, reducing maintenance costs, and allowing for greater Return-on-Assets for the Solar companies.

Key Differentiation Factor: With Digital Twin technology, it aims to build an identical digital twin of the plant to make it an energy-efficient world.

#featured #analytics products india #data science products 2020 #data science products build in india 2020 #data science products india