About
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.
- 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
presented by Jim Nasby, Debra Cerda, and Gopinath Pai
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...
more Fri 8 2022 Ops
All the Dirt on Vacuum: RDS edition
presented by Jim Nasby and Scott Mead
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
presented by Jim Nasby
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:
All the dirt on Vacuum
A detailed look at how vacuum works
presented by Jim Nasby
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
Python + Jupyter + Postgres
presented by Jim Nasby
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.
Dev
All the dirt on VACUUM: 9.6 edition
presented by Jim Nasby
video
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...
more Thu 30 2017 Internals
Python + Jupyter + Postgres
presented by Jim Nasby
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.
Development
Data Rescue
presented by Debra Cerda and Jim Nasby
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.
Operations
Predictive Analytics IN Postgres
presented by Jim Nasby
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...
more Development
All the dirt on VACUUM
10.0 edition
presented by Jim Nasby
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: