Illinois Prairie PUG Meetup - zoom version!
Details
Dear Prairie PUG Members! This is a Zoom version of our October 15 meetup. You can find in-person event details here. A friendly reminder: if you want to attend in person, I need both your first and last name!
On October 15, the presenter will be yours truly, Hettie Dombrovskaya. This will be a test run of my new talk, which I will be presenting at Pg Conf EU in Riga later in October.
Talk title: Long Queries and the Art of Full Scan
Talk Description:
Some queries just can’t run in a fraction of a second, no matter how well-written. This does not mean they cannot be optimized. Many practitioners hold that since analytical reports do not have strict response time requirements, it is not important how fast or slow they run. What's a big deal if a query only runs once a day, or once a week, or once a month? This is a dangerous practice. If report performance is neglected, performance can easily degrade from minutes to hours or even days! Let's learn how to be proactive and build reports the right way from the start, so that they won't become a performance disaster when the data volumes increase!
About the speaker:
Henrietta Dombrovskaya (currently a Database Architect at DRW) is a database researcher and developer with 40 years of academic and industrial experience. She holds a Ph.D. in Computer Science from the University of Saint Petersburg, Russia.
Her professional experience includes providing IT and Data services in the financial sector, manufacturing, distribution, education, and government. She authored, together with B. Novikov and A. Bailliekova, the book "PostgreSQL Query Optimization," Apress, 2024.
Henrietta is very active in the PostgreSQL community. She is a founder of Prairie Postgres NFP, an organization supporting Postgres education in the Midwest states of the US. She regularly talks at the PostgreSQL conferences. Her contributions to the community include the pg_bitemporal project, which supports two-dimensional time in PostgreSQL, postgres_air training database (the largest open-source PostgreSQL training database), and the NORM technology - the novel way of communications between applications and databases.
Please RSVP here only if you are going to attend virtually.
For the in-person event, please RSVP here.
Hettie Dombrovskaya
Illinois Prairie PostgreSQL User Group Organizer