Search

Top 60 Oracle Blogs

Recent comments

Announcing pgio (The SLOB Method for PostgreSQL) Is Released Under Apache 2.0 and Available at GitHub

This is just a quick post to advise readers that I have released pgio (The SLOB Method for PostgreSQL) under Apache 2.0. The bits are available at the following link: https://github.com/therealkevinc/pgio/releases/tag/1.0. The README is quite informative.

My last testing before the release showed “out of the box” data loading into Amazon Aurora with PostgreSQL compatibility at a rate of 1.69 TB/h. I only modified the pgio.conf file to specify the connection string and to set scale to 128 GB per schema:

#000000;" src="https://kevinclosson.files.wordpress.com/2019/09/pgio-aurora-setup.png?w=500&h=159" alt="" width="500" height="159" srcset="https://kevinclosson.files.wordpress.com/2019/09/pgio-aurora-setup.png?w=500&h=159 500w, https://kevinclosson.files.wordpress.com/2019/09/pgio-aurora-setup.png?w... 1000w, https://kevinclosson.files.wordpress.com/2019/09/pgio-aurora-setup.png?w... 150w, https://kevinclosson.files.wordpress.com/2019/09/pgio-aurora-setup.png?w... 300w, https://kevinclosson.files.wordpress.com/2019/09/pgio-aurora-setup.png?w... 768w" sizes="(max-width: 500px) 100vw, 500px" />

After loading data I edited pgio.conf to increase the number of threads per schema to 16 and then easily drove IOPS to the current, advertised IOPS limit of 120,000 for Amazon Aurora with PostgreSQL compatibility.

#000000;" src="https://kevinclosson.files.wordpress.com/2019/09/pgio-aurora-runit.png?w=500&h=154" alt="" width="500" height="154" srcset="https://kevinclosson.files.wordpress.com/2019/09/pgio-aurora-runit.png?w=500&h=154 500w, https://kevinclosson.files.wordpress.com/2019/09/pgio-aurora-runit.png?w... 1000w, https://kevinclosson.files.wordpress.com/2019/09/pgio-aurora-runit.png?w... 150w, https://kevinclosson.files.wordpress.com/2019/09/pgio-aurora-runit.png?w... 300w, https://kevinclosson.files.wordpress.com/2019/09/pgio-aurora-runit.png?w... 768w" sizes="(max-width: 500px) 100vw, 500px" />

Testing PostgreSQL physical I/O on any platform could not be any easier, repeatable, nor understandable.

Enjoy pgio!