Are you a non-expert wondering how to use Postgres properly?

Some customers just need a little advice on which direction to go in. A short consultancy session can save you from making mistakes that could be fatal in the future.

  • How do I build my architecture?
  • What are the advantages/disadvantages of using a particular type of data (UUID, JSON…)?
  • Do I need to shard my database?
  • How can I perform full-text searches?
  • How do I partition?
  • What type of instance should I choose?
  • Which server should I buy?
  • Which monitoring solution?

Here’s a non-exhaustive list of the subjects I work on:

  • Audit/consulting and architecture consulting: connection pooler, pgbouncer
  • Cost reduction with cloud providers
  • Engine and operating system tuning (Linux)
  • Query optimization
  • Modeling consulting
  • Backup (and restore!)
  • Postgres monitoring (Nagios, icinga, Datadog)
  • Physical and logical replication
  • Advanced uses of postgres: partitioning, Full Text Search, indexing strategies, sharding…

In all cases, I will respect my commitments, I will not recommend a solution that I would not want in production.

Adrien Nayrat
Adrien Nayrat
PostgreSQL DBA Freelance

Postgres and opensource passionate