autovacuum Archives - Data Egret

I am looking for a maintenance product for my databaseI need assistance with migration of my databaseI have an issue with my database and need assistanceI am an existing customer and require assistanceOther

Go ahead

Contact

Please fill in the form below and we will get back to you shortly. If the matter is urgent please indicate in the Comments field.

Please note that the information you provide will be used by Data Egret for handling your request. For more information see our Privacy Policy.

Thank you for your message

We will contact you soon.

Your details will be used by Data Egret solely for the purposes of reviewing your job application. If needed you can familiarise with our Privacy policy here.

Thank you for your application!

We will get in touch with you regarding next steps!

We are seeking a dynamic Digital Marketing Associate (Social Media) to join our team and help us to grow our followers across social channels and magnify our message to our audience.

We are looking for somebody, who already has some experience in marketing and in social media specifically and is now looking to grow it further in a specialised industry – IT.

You will be responsible for building and maintaining a brand’s presence across multiple social media channels, including:

development of social media content plan for LinkedIn, Twitter, Facebook and YouTube,
creation of social media copy and visuals,
scheduling and publishing of content consistently across all platforms,
monitor social media trends and competitor activities to inform social media strategy,
measurement and reporting.

You will be working under guidance from Senior Marketing Lead.

Requirements:

Work experience in marketing at least 2 years (social media management experience is a plus),
Strong command of English is a prerequisite. Working command of German is a plus,
Background in IT is a plus,
Having attention to detail is very important,
Excellent communication skills in both editing and writing.

You will be expected to:

work independently and take ownership of your tasks and projects,
have a proactive approach – identify opportunities for improvement and take initiative in solving problems,
be organised and met deadlines.

As a company whose primary focus is the open source community, we are looking for someone who understands the open-source ethos.

Please apply with a covering message, your CV and availability to start.

Apply

Have questions about this opportunity?
Contact us! [email protected]

Data Egret’s Marketing team is looking for a Marketing Assistant who will support our marketing efforts and contribute to our company’s growth. This entry-level role would be a perfect fit for someone looking to learn and grow in marketing.

About Data Egret

We are one of the leading consulting firms that provide support and strategic consulting services around the PostgreSQL database.

PostgreSQL was the database of choice among developers, according to the recent Stack Overflow survey, and has received the highest score from DB-Engines for several years, demonstrating a steady and impressive growth in popularity among Relational DBMS.

About you

You are enthusiastic, organised and reliable Marketing Assistant with a positive attitude and passion for marketing and communications and will have the following:

a skill of articulating complex ideas in a clear and accessible manner,
thorough attention to detail,
interest in growing your skills in the niche industry – IT,
a proactive approach: will identify opportunities for improvement and take initiative in solving problems or enhancing processes without needing constant guidance,
excellent analytical skills,
self-motivation: be organised, meet deadlines, and consistently deliver high-quality work with minimal supervision,
very good working level of English (German is a plus).

Location

This is a fully remote, EU/UK based position with occasional travel to Germany and Benelux.

What your day will look like:

You will be a part of the Marketing team and will assist in all aspects of marketing and communication activities at Data Egret. You will:

Assist with the planning and coordination of events and promotional activities (including content design and on-site support),
Develop promotional copy for emails, flyers, and the website,
Design a range of marketing materials based on the provided brief,
Provide day-to-day support to and work closely with the company’s Marketing Director,
Assist in running webinars and social media campaigns,
Assist in Digital Marketing activities (social media management, website content updates, SEO)

Please apply with a covering message, your CV and availability to start.

Apply

Have questions about this opportunity?
Contact us! [email protected]

We are one of the leading consulting firms that provide support and strategic consulting services around the PostgreSQL database.

PostgreSQL was the database of choice among developers, according to the recent Stack Overflow survey, and has received the highest score from DB-Engines for several years, demonstrating a steady and impressive growth in popularity among Relational DBMS.

We are seeking a skilled and creative WordPress Designer / Developer to join our growing team.

About you

The ideal candidate will have a strong understanding of both front-end and back-end development, with a keen eye for design and user experience. Reporting to the Marketing Director you will work to support Marketing department in their activities.

Your responsibilities will include:

Maintaining our WordPress websites
Designing and developing new elements and pages for the website as needed for our marketing team

The right candidate will be an enthusiastic team player and have the following skills:

Minimum of 3 years of experience working with WordPress and interest in further developing their skills
Solid understanding of front-end technologies (HTML, CSS, and JavaScript).
Experience of integrating WP with third party systems via API would be a plus
Python and Django knowledge is a plus
Great attention to detail
Knowledge of security & website performance best practices.
Understanding of core web concepts (Domains, DNS, Hosting).
Good communication skills and a willingness to help support other team members.

Self-motivation: you will be organised, meet deadlines, and consistently deliver high-quality work without the need for micromanagement.

This is a full- (40 hours weekly) or part-time (20 hours weekly), remote position with core hours Monday to Friday 09:00-15:00

Please apply with a covering message, your CV and availability to start.

Apply

Have questions about this opportunity?
Contact us! [email protected]

At Data Egret we truly love PostgreSQL the only true, community driven, disruptive (in a good way) powerful open-source database technology. PostgreSQL is disrupting the global Database Marketplace, which is projected to reach $154.6 billion by the year 2030.

All the evidence suggest PostgreSQL is going to play a major part of that, it already is!

Data Egret is a consulting firm offering advanced PostgreSQL administration services. We seek a Senior Sales Manager to help us grow our European client base and assist in the organic growth of our current customers.

The Senior Sales Manager will be responsible for all activities and interactions associated with driving revenue growth to expand Data Egret client base in Europe.

This is a full-time remote role; however, it is preferable that you reside in the UK, Germany or Benelux.

Experience required:

10+ years of enterprise IT sales experience, selling to C-level executives.
Exceptional communication skills (verbal and written in German and English, French would be a plus.).
Excellent time management and organisational skills
Experience working with distributed teams from diverse cultural backgrounds.
Excellent time management and organisational skills.

Key responsibilities:

Develop Sales plans and work with Marketing and Operations teams to implement and achieve success in lead generation.
Build strong C-level relationships resulting in growth opportunities within Europe.
Helping our prospects and customers to leverage the power of PostgreSQL through utilisation of Data Egret cutting edge support services.
Meet and exceed sales quota through outbound leads.
Qualify and cultivate leads generated from our website, trade shows and other marketing efforts.

Why choose Data Egret as your place of work?

You will be a part of one of the leading PostgreSQL consultancies and named a significant constributing sponsor to PostgreSQL by the Postgres community.
You will have an opportunity for individual growth and will be able to tackle various aspects of sales cycle while working with dynamic team of colleagues and building upon your network and your experience to grow Data Egret sales.
As our first dedicated Sales Manager in a high growth area your responsibilities are sure to develop further, and you will play an increasing key part for the growth of the business over time.

We offer:

A competitive pay based on your experience and annual performance-based bonus scheme.
Full-remote working.
Flexible working hours.
Collaborative and open working environment where you are supported by your colleagues and can learn and thrive.

Apply

Have questions about this opportunity?
Contact us! [email protected]

Ultimate PostgreSQL Support Plan

PostgreSQL expertise — exactly when you need it

You may not need a full-time DBA, but you still need expert guidance when things get complicated.
Our PostgreSQL Support Plan gives your team a direct line to seasoned professionals — for the moments where clarity, precision, and experience matter.

Whether you’re running a lean infrastructure at an early-stage startup or scaling a payments platform across multiple services, we help your team stay in control while avoiding costly mistakes.

What’s Included

60 hours per year, up to 20 hours/month
Ticket support for up to 10 PostgreSQL servers
24-hour SLA (during working hours: Mon–Fri, 08:00–17:00 CET)
Ticket support is provided via Jira ITSM portal
€6,000/year (excl. VAT)

Each request is handled in a Q&A format and rounded to 30-minute increments.
No system access required — your team stays hands-on, we provide the expert direction.

What We Help With

We support your team across key PostgreSQL operational areas — the same challenges your engineers and sysadmins face day to day:

Query tuning & performance: EXPLAIN plans, indexing, joins, rewrites
Configuration best practices: memory tuning, WAL setup, autovacuum, connection limits
Backup & recovery: choosing tools, planning retention, avoiding false confidence in pg_dump
Bloat analysis: diagnosing and reducing table/index bloat
Security recommendations: privileges, roles, basic audit monitoring
Incident post-mortems: RCA based on your monitoring and test data
Upgrade guidance: what to expect, compatibility gotchas
Tool support: pgBackRest, Patroni, PostGIS, pgvector, and other commonly used extensions

When your question crosses into “this needs a deeper investigation,” we’ll flag it clearly and you can switch to On-Demand Consulting if needed.

Why It Works

This plan is designed for technology teams that want to stay in control while ensuring access to deep PostgreSQL expertise.
It’s not an outsourced DBA model or a one-size-fits-all support contract.
Instead, it delivers targeted, high-value guidance that supports your team’s existing capabilities — when and where it matters most.

Need expert PostgreSQL support without the overhead of a full-time DBA or costly vendor plan?

📨 Contact us to get started

We are a consulting company that offers PostgreSQL administration services. We are looking for a seasoned PostgreSQL DBA specialist for a full-time remote position.

Who will you be working with?

Depending on the client’s team structure you will be working with either client’s DBAs, developers, DevOps, technical managers and CTOs.

Irrespective of client’s team structure you will be surrounded by best in class Data Egret PostgreSQL DBA, who have many years of experience supporting companies that work with PostgreSQL.

What skills will you gain?

In addition to harnessing your technical skills you will grow as a technical support specialist, who is able to listen to our clients, ask questions, review possible solutions with them, and be a reliable partner, who will be a valuable member of the extended client’s team beyond their expectations.

What will your job be like?

You will be the focal point to our clients when it comes to databases – figuring out why things don’t work the way they should, providing guidance and fixes to ensure that our client’s HA projects go like clockwork.

Here are a few examples of your day-to-day technical tasks:

Working with physical/logical replication.
Make changes in schema under load with minimum downtime.
Perform slow query analysis and optimization.
Implementing and troubleshooting backup and recovery practices.
Setting up and configuring Postgres.
Explaining to a customer how to use Postgres in the best way.
Finding and troubleshooting performance issues.
Perform minor and major PostgreSQL upgrades.

What do we expect from you?

You are a seasoned DBA with 2 or more years of experience in the management of high-availability clusters.
PostgreSQL projects (including replication configuration, performance tuning, monitoring configuration etc.).
Have experience in optimizing complex SQL queries.
Enjoy working independently and leading an open dialog with clients in order to obtain the necessary information regarding client’s problems, identify the issue, offer and discuss with client possible solutions and communicate upon delivery.
You are a confident Linux user and know how to perform basic system administration (Ubuntu/Debian/RedHat).
Have general understanding of database theory.
Have basic knowledge of shell scripting (writing screens-lengthy scripts that will be understandable to other admins and to yourself a few months later).
You can write and especially read complex (and very complex) SQL queries.
You are a keen learner and eager to discover new solutions to old problems.

Important: This is a client facing role and the ability to communicate your actions and be able to reason with client is imperative.

What skills would be a plus?

Working knowledge of German would be a plus.
Familiarity with Patroni.
Experience with PostgreSQL in cloud (AWS, RDS etc.)
Familiarity with some DevOps tools such as Ansible/Docker/Kubernetes.
Experience performing recovery from a backup.
C programming skills and experience in analysing with perf/strace/gdb.
Administration experience with cloud platforms.
Interest in giving conference talks and/or writing technical blog posts.
Experience working with PgBouncer.
Experience working with Postgres source code.
You performed or supported through migrations to Postgres from other DBMS.
You know how to work with monitoring solutions (DataDog, Odarix, NewRelic, Zabbix, pgwatch2 or other services/tools), as well as working with PostgreSQL logs gathering and interpreting data.

Why choose Data Egret as your place of work?

You will be a part of one of the leading PostgreSQL DBA teams working in a consultancy that has been named a significant sponsor to PostgreSQL by the Postgres community.
You will be able to brush up your database administration skills on a multitude of databases in different environments and gain experience that would normally take you years to get working in-house within months.

We offer:

A competitive pay based on your experience and annual performance-based bonus scheme.
Full-remote working.
Flexible working hours.
An opportunity to work alongside DBA colleagues, who live and breathe Postgres and contribute to its development.
Support of your participation in conferences and other PostgreSQL community-related work.
Collaborative and open environment where you are supported by your colleagues and can learn and thrive.

Apply

Have questions about this opportunity?
Contact us! [email protected]

Want to be part of our team? Our current vacancies are listed below, but we always welcome applications from specialists who are eager to learn and grow.

01
Word Press Designer/Developer

02
Marketing Assistant

03
Digital Marketing Associate

04
Senior DBA (PostgreSQL)

Questions?

Get in touch

Training program is developed based on our client’s specific requirements and is run by our highly skilled DBA.

tailored program, developed specifically to address your company’s business needs;
the knowledge and hands-on experience acquired during the training can be used by your team straight away;
training by one of the leading PostgreSQL DBA in the industry.

Workshops usually have hands-on elements, we therefore suggest limiting the number of attendees to a maximum of 15.

Looking to upscale your team with PostgreSQL know-how? Contact us now.

Health Check

Most emergencies leading to service unavailability and loss of your data can be mitigated and detected at an early stage with minimal effort. Data Egret Health Check will ensure a smooth running of your service, give you a headstart for your launch or migration and will allow better budgetary planning.

We will provide you a tailored offering based on your system specifications, however, below rates will give you an idea of pricing for our Health Check solution.

Package	Price*
PostgreSQL configuration analysis	from 500 €
Hardware and OS configuration analysis	from 600 €
Slow SQL queries analysis	from 500 €
Comprehensive performance Health Check*	from 3500 €
* For single PostgreSQL installation (1 master + 1 replica)

PostgreSQL Consulting

Whether you are looking for an immediate support for your system or an advice on how best to maintain it in a long run, our experts are there for you. A bundle of DBA hours that can be used for getting expert advice as well as hands-on assistance on:

Query optimisation
Architectural improvements
Performance tuning
Backup and recovery

With our PostgreSQL Consulting service our clients:

Improved their PostgreSQL performance
Established correct scaling strategy
Decreased response time of their services

Mitigated future emergencies
Increased uptime of their system
Have set up a reliable backup system
Established the PostgreSQL performance monitoring process

For price calculation please contact us.

Time is billed in 15-minute increments.

24/7 PostgreSQL Support

24/7 PostgreSQL Support offers you a combination of ongoing consultancy from our experts as well as round the clock support from dedicated team. To ensure smooth running of your systems and give you peace of mind we will be providing following services:

Dedicated Data Egret team

that will be your contact in case of any questions or concerns. Team that will be aware of your system’s specifications and will work on any arising issues within 15 minutes to an hour from enquiry.

Real time counsel

on everything PostgreSQL provided by our team of experts to your company developers and operations engineers.

Ongoing monitoring of your databases

that includes query performance, issues management and recommendation on performance improvements.

Regular upgrades

of PostgreSQL and related software.

Backup and recovery

that includes regular backup of your database and recovery solution with regular test recovery.

Basic	Premium	VIP
Incl. up to 5h/month DBA time	Incl. up to 15h/month DBA time	Incl. up to 30h/month DBA time
Slack, Mattermost, Telegram	Slack, Mattermost, Telegram	Slack, Mattermost, Telegram
Response time — 1 Hour	Response time — 1 Hour	Response time — 30 minutes
Up to 2 PostgreSQL instances	Up to 5 PostgreSQL instances	Up to 10 PostgreSQL instances

When using websites dataegret.com and dataegret.de, submitting contact forms or registering and watching recorded webinars your personal data may be processed. On this page we inform you about these processing activities in accordance with the legal provisions of the General Data Protection Regulation (GDPR).

The responsible body for processing (“data controller”) is Data Egret GmbH Herrenstr.1 A 2, 66583 Spiesen-Elversberg, Germany (https://www.dataegret.com). If you have any questions about this data protection information or data protection at Data Egret GmbH in general, please contact us at [email protected] before submitting any forms or registering to webinars through our website.

We periodically update our Privacy Policy to comply with most recent regulations and to encompass our marketing activities. We therefore encourage you to review this Privacy Policy periodically. Current Policy has been updated on 21 February 2024.

Information we collect

You are free to explore our Websites (dataegret.com and dataegret.de) without providing any Personal Information about yourself.

Google Analytics – when you visit our Websites we use Google Analytics tool to collect information about traffic to our websites and the website usage to be able to analyse it and provide you with a better experience in the future.

Google Analytics transmits collected website traffic data to Google servers in the United States. It doesn’t identify individual users or associate your IP address with any other data held by Google.

Google Analytics uses ‘cookies’ to collect information about website traffic and site usage. Cookies are industry standard and majority of the websites using them. A ‘cookie’ is a small text file that our site may place on your computer as a tool to remember your preferences. You may refuse the use of cookies by selecting the appropriate settings on cookie banner on our website when you first log in, however, please note that if you do that you may not be able to use full functionality of our websites.

Pipedrive Services – a web-based sales CRM – tracks pages viewed, visitor sources, and time spent on the site to provide insight into a company’s engagement.

ZenLeads Inc. d/b/a Apollo.io – a web-based sales CRM – monitors website activity, including page visits, to gather data for its sales and marketing platform. This includes identifying companies that visit specific pages.

Personal Information

This refers to any information that you voluntarily submit to us and that identifies you personally, including contact information, such as your name, e-mail address, company name, address, phone number, and other information about yourself or your business.

When you contact us through “Contact us” button on our websites we will use information provided for responding to your enquiry and will save it for future reference. We will not use this information for sending you any marketing emails without receiving prior consent from you.

The information you provide through Contact form is saved using variety of security technologies and procedures through our European data processor service – Pipedrive. You can read more about it here https://support.pipedrive.com/hc/en-us/articles/360000335129-Pipedrive-and-GDPR

When we have no ongoing legitimate business need to process your Personal Information, we securely delete the information or anonymise it or, if this is not possible, then we will securely store your Personal Information and isolate it from any further processing until deletion is possible. We will delete this information from the servers at an earlier date if you request it.

Social Media Features

Our Websites (dataegret.com and dataegret.de) include Social Media Features, such as the Facebook Like button and Widgets, such as the Share This button. These features may collect your IP address, which page you are visiting on our sites, and may set a cookie to enable the feature to function properly. Social Media Features and Widgets are either hosted by a third party or hosted directly on our Websites. This Privacy Policy does not apply to these features. Your interactions with these features are governed by the privacy policy and other policies of the companies providing them.

Registration to participate in webinars

When you register to participate in our webinars, we process your name and contact information, which we use for:

sending you participation links,
remind you of your webinar participation,
notify of any changes and
sending you webinar recording
notify you of additional webinars that we run.

While participating in the webinar, technical information from your end device or your Internet connection will be processed to ensure optimal call quality. The processing is necessary for the fulfilment of the agreement to participate in the webinar (Art. 6 (1) b GDPR).

We use Zoom Video Communications, Inc. (“Zoom”) platform for conducting our Webinars, which means that information you provide during registration to our Webinars will be stored on Zoom servers. You can read about Zoom GDPR compliance here.

Recording of webinars

In some of the webinars it is possible to ask questions. This can be done either with the chat function included in the Zoom application or as audio/video if the microphone or camera is activated. Since most of our webinars are recorded, your data will also be part of the recording in these cases. The processing takes place with your consent in accordance with Art. 6 (1) a GDPR and the transmission to countries outside the European Union on the basis of Art. 49 (1) a GDPR. Consent is voluntary, alternatively you can send your question by email [email protected] and your name will not be mentioned in the webinar.

Subscription Services

We do not currently have any subscription services.

Should we launch such activity and you submitted your personal information through our online Contact form in the past we will ask for your explicit permission to receive such information from us.

Category: autovacuum

Automated index bloat management: How pg_index_watch keeps PostgreSQL indexes lean.

Please welcome Pg_index_watch – a utility for dealing with index bloat on frequently updated tables.

VACUUM на часто обновляемых таблицах

Ускоряем VACUUM в PostgreSQL

Vacuuming update-heavy tables

Accelerating VACUUM in Postgres