Skip to content

About us

Hey there! It’s great to have you on our page.

We’re a friendly group of PostgreSQL enthusiasts in and around London who meet every couple of months for a drink, a chat, and some good old Postgres talk.

Each meetup usually starts with a short talk to spark discussion, but anything in the PostgreSQL ecosystem is fair game — from performance tuning to migration stories (and everything in between).

Whether you’re a DBA, developer, or just curious about PostgreSQL — come join us! No fees, no formality, just great people and great conversations.

So if you’d like to see what the world’s most advanced open-source database holds for you, come along — and we’ll show you just how deep the rabbit hole goes. 🐘

Participation Policy
London PostgreSQL Meetup Group is dedicated to providing a safe, harassment-free and enjoyable meetup experience for everyone. Please be helpful, considerate, friendly, and respectful towards all other participants and venue staff.

We do not tolerate harassment of any members or organisers in any form. Imagery and language which promotes, supports, glorifies, or encourages acts of violence, harassment of any form, sexism or sexual misconduct, or hate speech, is not appropriate for any events including exhibition booths, talks and social events. Members violating these rules may be sanctioned or expelled from the meetup group and the events.

The meet-up abides by PostgreSQL Code of Conduct.

Trademark
Postgres, PostgreSQL and the Slonik Logo are trademarks or registered trademarks of the PostgreSQL Community Association of Canada, and used with their permission.

New Postgres Tools for Analytics

New Postgres Tools for Analytics

Doggett's Coat and Badge, 1 Blackfriars Bridge, London SE1 9UD, UK, London, GB

On 7 October we will be gathering again for some Postgres and a pint. This time we'll have the following talks:

Block your calendars and come!

We are a very informal bunch, so hoping to see you and your colleagues there!
We do need to know the numbers, so please register if you are planning on coming.

This event is generously sponsored by Snowflake, a global data and AI company offering a range of data products, including data analytics, machine learning, and fully managed PostgreSQL databases.

WHERE
Doggett's Coat and Badge
1 Blackfriars Bridge, SE1 9UD
on Wednesday, 7th October from 18:30.

PROGRAMME
18:30 Welcome
19:00-19:45 New Postgres Tools for Analytics (Elizabeth Christensen, Snowflake) - Abstract below.
19:45 Food and bar snacks
Lightning talks
20:00-20:15 Analytics over Postgres data with DuckDB (Alex Kasko, DuckLabs (AWS)) - Abstract below.
20:15-20:30 ColdFront: Transparent PostgreSQL Data Tiering to Apache Iceberg (Jimmy Angelakos, pgEdge)
20:30 It's a pub, so we'll stay and hang out a bit longer — but feel free to leave whenever you prefer!

ABSTRACTS
Main talk
New Postgres Tools for Analytics (Elizabeth Christensen, Snowflake)
Let’s talk about some Postgres tools for doing large scale analytics on really big data sets right from your psql driver’s seat. We’ll hit this from two sides, first, doing analytics on huge tables in Postgres with approximation tools like table sample and Apache DataSketches and then, bringing in the pg_lake / DuckDB extension to do analytics on object storage.

Lightning talks
Analytics over Postgres data with DuckDB (Alex Kasko, DuckLabs (AWS))
DuckDB is an in-process analytical database, sometimes called "SQLite for analytics". DuckDB uses plug-in extensions to read data from various sources. In this short talk Alex will describe the implementation details of the "postgres" DuckDB extension, that allows to run highly-parallel analytical queries on data stored in PostgreSQL.

About Alex Kasko
Alex Kasko is a software engineer at DuckLabs (AWS) working on integrating PostgreSQL with DuckDB. He lives in Cork, Ireland.

ColdFront: Transparent PostgreSQL Data Tiering to Apache Iceberg (Jimmy Angelakos, pgEdge)
ColdFront transparently tiers cold PostgreSQL data to Apache Iceberg on cheap object storage, cutting costs while keeping rows fully accessible to your applications. Because the tiered data becomes columnar Parquet, it instantly unlocks DuckDB-powered analytics inside Postgres and direct access for your AI/ML pipelines. We'll explore decoupled mode, Spock active-active cluster integration, and the TLA+ verified protocol that makes distributed concurrent writes safe.

About Jimmy Angelakos
Jimmy Angelakos is a Staff Software Engineer at pgEdge and Significant Contributor to PostgreSQL. He organises the PostgreSQL Edinburgh User Group and writes software and books.
***
THE OFFICIAL BITS
The meet-up abides by PostgreSQL Code of Conduct.
Postgres, PostgreSQL and the Slonik Logo are trademarks or registered trademarks of the PostgreSQL Community Association of Canada, and used with their permission.

  • Photo of the user
  • Photo of the user
  • Photo of the user
30 attendees

Upcoming events

1

See all
  • New Postgres Tools for Analytics

    New Postgres Tools for Analytics

    Doggett's Coat and Badge, 1 Blackfriars Bridge, London SE1 9UD, UK, London, GB

    On 7 October we will be gathering again for some Postgres and a pint. This time we'll have the following talks:

    Block your calendars and come!

    We are a very informal bunch, so hoping to see you and your colleagues there!
    We do need to know the numbers, so please register if you are planning on coming.

    This event is generously sponsored by Snowflake, a global data and AI company offering a range of data products, including data analytics, machine learning, and fully managed PostgreSQL databases.

    WHERE
    Doggett's Coat and Badge
    1 Blackfriars Bridge, SE1 9UD
    on Wednesday, 7th October from 18:30.

    PROGRAMME
    18:30 Welcome
    19:00-19:45 New Postgres Tools for Analytics (Elizabeth Christensen, Snowflake) - Abstract below.
    19:45 Food and bar snacks
    Lightning talks
    20:00-20:15 Analytics over Postgres data with DuckDB (Alex Kasko, DuckLabs (AWS)) - Abstract below.
    20:15-20:30 ColdFront: Transparent PostgreSQL Data Tiering to Apache Iceberg (Jimmy Angelakos, pgEdge)
    20:30 It's a pub, so we'll stay and hang out a bit longer — but feel free to leave whenever you prefer!

    ABSTRACTS
    Main talk
    New Postgres Tools for Analytics (Elizabeth Christensen, Snowflake)
    Let’s talk about some Postgres tools for doing large scale analytics on really big data sets right from your psql driver’s seat. We’ll hit this from two sides, first, doing analytics on huge tables in Postgres with approximation tools like table sample and Apache DataSketches and then, bringing in the pg_lake / DuckDB extension to do analytics on object storage.

    Lightning talks
    Analytics over Postgres data with DuckDB (Alex Kasko, DuckLabs (AWS))
    DuckDB is an in-process analytical database, sometimes called "SQLite for analytics". DuckDB uses plug-in extensions to read data from various sources. In this short talk Alex will describe the implementation details of the "postgres" DuckDB extension, that allows to run highly-parallel analytical queries on data stored in PostgreSQL.

    About Alex Kasko
    Alex Kasko is a software engineer at DuckLabs (AWS) working on integrating PostgreSQL with DuckDB. He lives in Cork, Ireland.

    ColdFront: Transparent PostgreSQL Data Tiering to Apache Iceberg (Jimmy Angelakos, pgEdge)
    ColdFront transparently tiers cold PostgreSQL data to Apache Iceberg on cheap object storage, cutting costs while keeping rows fully accessible to your applications. Because the tiered data becomes columnar Parquet, it instantly unlocks DuckDB-powered analytics inside Postgres and direct access for your AI/ML pipelines. We'll explore decoupled mode, Spock active-active cluster integration, and the TLA+ verified protocol that makes distributed concurrent writes safe.

    About Jimmy Angelakos
    Jimmy Angelakos is a Staff Software Engineer at pgEdge and Significant Contributor to PostgreSQL. He organises the PostgreSQL Edinburgh User Group and writes software and books.
    ***
    THE OFFICIAL BITS
    The meet-up abides by PostgreSQL Code of Conduct.
    Postgres, PostgreSQL and the Slonik Logo are trademarks or registered trademarks of the PostgreSQL Community Association of Canada, and used with their permission.

    • Photo of the user
    • Photo of the user
    • Photo of the user
    30 attendees

Group links

Organizers

PostgreSQL is a Super Organizer

Find us also at