Jim Nasby
Sr. Database Engineer at Amazon Web Services
Jim discovered a passion for data and databases early in life, and was working as a database consultant before high school. Since then he has worked with everything from Foxpro to Oracle. For the past 15 years he has specialized in PostgreSQL and is an active member of it's development community. He specializes in tackling complex data challenges where data quality is critical.
Upcoming presentations
No upcoming presentations...
Past presentations
- MVCC details
- HOT overview
- Identifying tuples to be vacuumed/frozen
- Visibility and Freeze...
- MVCC details
- HOT overview
- Identifying tuples to be vacuumed/frozen
- Vis...
- MVCC details
- HOT overview
- Identifying tuples to be vacuumed/frozen
- ...
- MVCC details
- HOT overview
- Identifying tuples to be vacuumed/frozen
- Vis...
Babelfish for PostgreSQL
Babelfish for PostgreSQL accelerates the journey to migrate SQL Server applications to PostgreSQL
Babelfish for PostgreSQL is an open source project available under the Apache 2.0 and PostgreSQL licenses. It provides the capability for PostgreSQL to understand queries from applications written for Microsoft SQL Server. Babelfish understands the SQL Server wire-protocol and T-SQL, the Microsoft SQL Server query language, so you don’t have to switch database driver...
Apr 8 2022
Vacuum can be one of the most challenging parts of managing a Postgres database. In this talk we'll walk through common vacuum related issues related to performance, space usage, and the dreaded wraparound. We'll discuss how to avoid these issues, as well as what RDS does to assist.
Topics:
All the dirt on VACUUM
Postgres 11 edition
The use of Multi-Version Concurrency Control (MVCC) is perhaps one of the most powerful features PostgreSQL has to offer, but it can be a source of confusion for new and experienced users alike. In this talk we will provide an in-depth walkthrough of why Postgres needs to vacuum and what vacuum does.
Topics:
Mar 22 2019
All the dirt on Vacuum
A detailed look at how vacuum works
The use of Multi-Version Concurrency Control (MVCC) is perhaps one of the most powerful features PostgreSQL has to offer, but it can be a source of confusion for new and experienced users alike. In this talk we will provide an in-depth walkthrough of why Postgres needs to vacuum and what vacuum does.
Topics
Nov 14 2017
Jupyter notebooks are a powerful tool for interacting with code. They provide a combination of documentation and interaction that works well for demos, education, presentation, as well as data exploration. This talk will demonstrate two methods for interacting with Postgres via both python and Jupyter notebooks.
The use of Multi-Version Concurrency Control (MVCC) is perhaps one of the most powerful features PostgreSQL has to offer, but it can be a source of confusion for new and experienced users alike. In this talk we will provide an in-depth walkthrough of why Postgres needs to vacuum and what vacuum does. Topics: MVCC details HOT overview Identifying tuples to be vacuumed/frozen Visibility and Freez...
Jupyter notebooks are a powerful tool for interacting with code. They provide a combination of documentation and interaction that works well for demos, education, presentation, as well as data exploration. This talk will demonstrate two methods for interacting with Postgres via both python and Jupyter notebooks.
Data rescue is an opportunity for programmers, scientists, archivists, activists, and volunteers of all kinds to identify, back-up, and help preserve publicly accessible federal data resources in the public interest, in the event they are removed from public view and use.
In data science there is often a huge disconnect between data scientists trying to create models and the application development team responsible for implementing them. Often this is made worse by data scientists using a different language for modeling than the application is written in. Modeling in Postgres eliminates this issue by allowing the model to be written in any supported language (su...
All the dirt on VACUUM
10.0 edition
The use of Multi-Version Concurrency Control (MVCC) is perhaps one of the most powerful features PostgreSQL has to offer, but it can be a source of confusion for new and experienced users alike. In this talk we will provide an in-depth walkthrough of why Postgres needs to vacuum and what vacuum does.
Topics:
Apr 20 2018