Dear Illinois Prairie PUG members,
Our next meetup will take place on October 15, and 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.
Event location: DRW Training Center, 540 W. Madison, 25th floor.
A reminder about our venue:
- This is a high-security building, which means the names of all participants should be communicated no later than 7:30 AM on the day of the event, and all participants must present a government-issued ID to be admitted. If your meetup profile does not list your full name, please send a DM with the required information to me (Hettie). Please make sure to do so not later than the day before the meetup. Registration for all in-person events will be closed by 7-30 AM the day of the event.
- The food order will be placed a day before the event, so I strongly encourage everybody planning to attend to RSVP at least a day before.
Please RSVP to this event only if you are attending in person.
If you are planning to attend virtually, please wait for a separate event announcement.
Hope to see you there!
Hettie Dombrovskaya
Illinois Prairie PostgreSQL User Group Organizer
