BEGIN:VCALENDAR PRODID;X-RICAL-TZSOURCE=TZINFO:-//Calagator//EN CALSCALE:GREGORIAN X-WR-CALNAME:Calagator METHOD:PUBLISH VERSION:2.0 BEGIN:VTIMEZONE TZID;X-RICAL-TZSOURCE=TZINFO:America/Los_Angeles BEGIN:DAYLIGHT DTSTART:20080309T020000 RDATE:20080309T020000 RDATE:20090308T020000 RDATE:20100314T020000 RDATE:20110313T020000 RDATE:20120311T020000 RDATE:20130310T020000 RDATE:20140309T020000 RDATE:20150308T020000 RDATE:20160313T020000 RDATE:20170312T020000 RDATE:20180311T020000 RDATE:20190310T020000 RDATE:20200308T020000 RDATE:20210314T020000 RDATE:20220313T020000 RDATE:20230312T020000 RDATE:20240310T020000 RDATE:20250309T020000 TZOFFSETFROM:-0800 TZOFFSETTO:-0700 TZNAME:PDT END:DAYLIGHT BEGIN:STANDARD DTSTART:20081102T020000 RDATE:20081102T020000 RDATE:20091101T020000 RDATE:20101107T020000 RDATE:20111106T020000 RDATE:20121104T020000 RDATE:20131103T020000 RDATE:20141102T020000 RDATE:20151101T020000 RDATE:20161106T020000 RDATE:20171105T020000 RDATE:20181104T020000 RDATE:20191103T020000 RDATE:20201101T020000 RDATE:20211107T020000 RDATE:20221106T020000 RDATE:20231105T020000 RDATE:20241103T020000 RDATE:20251102T020000 TZOFFSETFROM:-0700 TZOFFSETTO:-0800 TZNAME:PST END:STANDARD END:VTIMEZONE BEGIN:VEVENT CREATED;VALUE=DATE-TIME:20080828T035250Z DTEND;TZID=America/Los_Angeles;VALUE=DATE-TIME:20080918T210000 DTSTART;TZID=America/Los_Angeles;VALUE=DATE-TIME:20080918T190000 DTSTAMP;VALUE=DATE-TIME:20080828T035250Z LAST-MODIFIED;VALUE=DATE-TIME:20080915T221918Z UID:http://calagator.org/events/1250455658 DESCRIPTION:PostgreSQL Users' Group monthly meeting. Followed by refresh ments at the Lucky Lab. \;\n \;\nTopic: Visual Planner \;\nPres enter: Tom Raney\, PSU \;\nWhere: FreeGeek\, 1731 SE 10th Avenue\, Po rtland\, OR \;\nWhen: 7pm\, September 18\, 2008 \;\n \;\nTom Ra ney will be presenting the Visual Planner\, a GUI tool written in Java t hat enables the user to peek inside the PostgreSQL planner's decision ma king process. The tool shows all plans that were evaluated including the plan that was picked for execution. Tom worked on this during Google Su mmer of Code\, and credits Dr. Len Shapiro\, a professor at Portland Sta te University and PDXPUG regular\, as a great help. \;\n \;\nTom s howed off his tool during OSCON and has gotten some feedback from commun ity members on it. He's working up a test example that should appeal to DBAs\, and I'll link directly to the source code once he's got it ready. \;\n \;\nThis work also involves a patch to PostgreSQL\, which sh ould be available soon! \;\n \;\nAfter the meeting\, retire to the Lucky Lab for refreshments! \;\n\n\nTags: postgresql\, postgres\, sq l\, database\n\nImported from: http://calagator.org/events/1250455658 URL:http://pugs.postgresql.org/pdx SUMMARY:PDXPUG LOCATION:Free Geek: 1731 SE 10th Avenue\, Portland OR 97214 US SEQUENCE:0 END:VEVENT BEGIN:VEVENT CREATED;VALUE=DATE-TIME:20080916T194632Z DTEND;VALUE=DATE:20081013 DTSTART;VALUE=DATE:20081010 DTSTAMP;VALUE=DATE-TIME:20080916T194632Z LAST-MODIFIED;VALUE=DATE-TIME:20080916T195310Z UID:http://calagator.org/events/1250455749 DESCRIPTION:This event runs from Friday\, October 10\, 2008 at 8am throug h Sunday\, October 12\, 2008 at 5pm.\n\nDescription:\nJoin us for the se cond annual PostgreSQL Conference West! Scheduled to begin October 10 an d go through the weekend\, West being held at Portland State University is going to be the destination for learning\, fun and general education about PostgreSQL. \n\nTags: postgresql\, postgres\, database\, pdxpug\n\ nImported from: http://calagator.org/events/1250455749 URL:http://www.postgresqlconference.org/ SUMMARY:PostgreSQL Conference West LOCATION:Portland State University Native American Student & Community Ce nter: 710 SW Jackson Street\, Portland Oregon 97201 US SEQUENCE:0 END:VEVENT BEGIN:VEVENT CREATED;VALUE=DATE-TIME:20090202T172546Z DTEND;TZID=America/Los_Angeles;VALUE=DATE-TIME:20090212T210000 DTSTART;TZID=America/Los_Angeles;VALUE=DATE-TIME:20090212T190000 DTSTAMP;VALUE=DATE-TIME:20090202T172546Z LAST-MODIFIED;VALUE=DATE-TIME:20090202T173520Z UID:http://calagator.org/events/1250456618 DESCRIPTION:2nd THURSDAY OF EACH MONTH\, BEGINNING JANUARY 8\, 7:00 PM 3\;\nPORTLAND STATE UNIVERSITY\, 1900 SW 4th AVENUE\, \;\nFOURTH AVEN UE BUILDING – ROOM 86-01 \;\n \;\nSee website for more details.\n\ nTags: postgresql\, postgres\, pg\, pdxpug\n\nImported from: http://cala gator.org/events/1250456618 URL:http://pugs.postgresql.org/node/504 SUMMARY:PostgreSQL Portland Performance Practice Project (P5) LOCATION:Portland State University Fourth Avenue Building (FAB): 1900 SW 4th Ave.\, Portland OR 97201 US SEQUENCE:0 END:VEVENT BEGIN:VEVENT CREATED;VALUE=DATE-TIME:20090202T173912Z DTEND;TZID=America/Los_Angeles;VALUE=DATE-TIME:20090219T210000 DTSTART;TZID=America/Los_Angeles;VALUE=DATE-TIME:20090219T190000 DTSTAMP;VALUE=DATE-TIME:20090202T173912Z LAST-MODIFIED;VALUE=DATE-TIME:20160621T232742Z UID:http://calagator.org/events/1250456619 DESCRIPTION:Monthly meeting of the Portland PostgreSQL Users' Group. \ ;\n \;\nEd Borasky will be speaking about Data Visualization. \;\n \;\nBeers after at the Lucky Lab on Hawthorne.\n\nTags: pdxpug\, pg\ , postgres\, postgresql\n\nImported from: http://calagator.org/events/12 50456619 URL:http://pugs.postgresql.org/pdx/ SUMMARY:PDXPUG: PostgreSQL Data Visualization LOCATION:Free Geek: 1731 SE 10th Avenue\, Portland OR 97214 US SEQUENCE:6 END:VEVENT BEGIN:VEVENT CREATED;VALUE=DATE-TIME:20090223T165823Z DTEND;TZID=America/Los_Angeles;VALUE=DATE-TIME:20090312T200000 DTSTART;TZID=America/Los_Angeles;VALUE=DATE-TIME:20090312T190000 DTSTAMP;VALUE=DATE-TIME:20090223T165823Z LAST-MODIFIED;VALUE=DATE-TIME:20090223T165823Z UID:http://calagator.org/events/1250456742 DESCRIPTION:Sponsored by the Computer Science Department\, Portland State University \;\n \;\nThis series will consist of 5 to 6 presentati ons aimed at PostgreSQL database users who wish to learn more about tuni ng their systems for performance. Attendees will learn how to generate a nd interpret operating system (Linux) and database statistics\, and the effects of some system tuning techniques. This involves studying the wel l known Online Transaction Processing (OLTP) benchmark called TPC-C ( ww w.tpc.org ). TPC-C was developed by a committee\, representing all major players in the database marketplace\, to be representative of typical o nline enterprise databases. TPC-C consists of a precisely defined schema and 19 queries. We will review the schema and queries and demonstrate h ow each tuning technique affects their performance. We will use an open source package that the speaker has developed\, called DBT-2\, which man y DBAs have found useful. \;\n \;\nPORTLAND STATE UNIVERSITY\, 19 00 SW 4th AVENUE\, \;\nFOURTH AVENUE BUILDING – ROOM 86-01\n\nTags: p ortland state university\, psu\, postgres\, postgresql\, dbt-2\, dbt2\n\ nImported from: http://calagator.org/events/1250456742 URL:http://pugs.postgresql.org/node/504 SUMMARY:PostgreSQL Portland Performance Practice Project (P5) LOCATION:Portland State University Fourth Avenue Building (FAB): 1900 SW 4th Ave.\, Portland OR 97201 US SEQUENCE:0 END:VEVENT BEGIN:VEVENT CREATED;VALUE=DATE-TIME:20090223T170233Z DTEND;TZID=America/Los_Angeles;VALUE=DATE-TIME:20090319T200000 DTSTART;TZID=America/Los_Angeles;VALUE=DATE-TIME:20090319T190000 DTSTAMP;VALUE=DATE-TIME:20090223T170233Z LAST-MODIFIED;VALUE=DATE-TIME:20090223T170233Z UID:http://calagator.org/events/1250456743 DESCRIPTION:Monthly meeting of the Portland PostgreSQL Users' Group. \ ;\n \;\nKristin Tufte will be speaking about the Portland Transportat ion Archive Listing (PORTAL) database schema. \;\n \;\nBeers after at the Lucky Lab on Hawthorne. \;\n\n\nTags: postgres\, postgresql\, pdxpug\n\nImported from: http://calagator.org/events/1250456743 URL:http://pugs.postgresql.org/pdx/ SUMMARY:PDXPUG: eXtreme Database Makeover 2: PORTAL LOCATION:Free Geek: 1731 SE 10th Avenue\, Portland OR 97214 US SEQUENCE:0 END:VEVENT BEGIN:VEVENT CREATED;VALUE=DATE-TIME:20090331T215355Z DTEND;TZID=America/Los_Angeles;VALUE=DATE-TIME:20090409T200000 DTSTART;TZID=America/Los_Angeles;VALUE=DATE-TIME:20090409T190000 DTSTAMP;VALUE=DATE-TIME:20090331T215355Z LAST-MODIFIED;VALUE=DATE-TIME:20090331T215446Z UID:http://calagator.org/events/1250456914 DESCRIPTION:PostgreSQL Portland Performance Practice Project (P5) \;\n \;\nSponsored by the Computer Science Department\, Portland State Un iversity \;\n \;\nThis series will consist of 5 to 6 presentations aimed at PostgreSQL database users who wish to learn more about tuning their systems for performance. Attendees will learn how to generate and interpret operating system (Linux) and database statistics\, and the eff ects of some system tuning techniques. This involves studying the well k nown Online Transaction Processing (OLTP) benchmark called TPC-C ( www.t pc.org ). TPC-C was developed by a committee\, representing all major pl ayers in the database marketplace\, to be representative of typical onli ne enterprise databases. TPC-C consists of a precisely defined schema an d 19 queries. We will review the schema and queries and demonstrate how each tuning technique affects their performance. We will use an open sou rce package that the speaker has developed\, called DBT-2\, which many D BAs have found useful. \;\n \;\nMark Wong has an MS in Computer Sc ience from OGI and several years of experience developing and executing various database systems benchmarks. Most relevant to this series are hi s years spent at the OSDL developing and using a fair-use derivative of the TPC-C benchmark to characterize system performance of open source so ftware. \;\n \;\n2nd THURSDAY OF EACH MONTH\, BEGINNING JANUARY 8\ , 7:00 PM \;\nPORTLAND STATE UNIVERSITY\, 1900 SW 4th AVENUE\, \;\ nFOURTH AVENUE BUILDING – ROOM 86-01\n\nTags: postgresql\, postgres\, p5 \, dbt2\, database test 2\, dbt-2\n\nImported from: http://calagator.org /events/1250456914 URL:http://web.cecs.pdx.edu/~len/P5.pdf SUMMARY:PostgreSQL Portland Performance Practice Project (P5) - Linux Fil esystems LOCATION:Portland State University Fourth Avenue Building (FAB): 1900 SW 4th Ave.\, Portland OR 97201 US SEQUENCE:0 END:VEVENT BEGIN:VEVENT CREATED;VALUE=DATE-TIME:20090331T215922Z DTEND;TZID=America/Los_Angeles;VALUE=DATE-TIME:20090416T200000 DTSTART;TZID=America/Los_Angeles;VALUE=DATE-TIME:20090416T190000 DTSTAMP;VALUE=DATE-TIME:20090331T215922Z LAST-MODIFIED;VALUE=DATE-TIME:20090410T152551Z UID:http://calagator.org/events/1250456915 DESCRIPTION:Monthly meeting of the Portland PostgreSQL Users' Group. \ ;\n \;\nChris May will be speaking. \;\n \;\nLooking forward to seeing everyone there...and of course\, drinks at the Lucky Lab (http:/ /www.luckylab.com/ ) at 915 SE Hawthorne Blvd. afterwards.\n\nTags: pdxp ug\, postgresql\, postgres\n\nImported from: http://calagator.org/events /1250456915 URL:http://pugs.postgresql.org/node/540 SUMMARY:PDXPUG - MySQL war stories: Tales from the Crater LOCATION:Free Geek: 1731 SE 10th Avenue\, Portland OR 97214 US SEQUENCE:0 END:VEVENT BEGIN:VEVENT CREATED;VALUE=DATE-TIME:20090512T200044Z DTEND;TZID=America/Los_Angeles;VALUE=DATE-TIME:20090514T200000 DTSTART;TZID=America/Los_Angeles;VALUE=DATE-TIME:20090514T190000 DTSTAMP;VALUE=DATE-TIME:20090512T200044Z LAST-MODIFIED;VALUE=DATE-TIME:20090513T162930Z UID:http://calagator.org/events/1250457199 DESCRIPTION:This session will survey a few PostgreSQL tuning \;\nparam eters and their effects on the OLTP workload DBT-2. \;\n \;\n-- 3\;\n \;\nPostgreSQL Portland Performance Practice Project (P5) \; \n \;\nSponsored by the Computer Science Department\, Portland State University \;\n \;\nThis series will consist of 5 to 6 presentatio ns aimed at PostgreSQL database users who wish to learn more about tunin g their systems for performance. Attendees will learn how to generate an d interpret operating system (Linux) and database statistics\, and the e ffects of some system tuning techniques. This involves studying the well known Online Transaction Processing (OLTP) benchmark called TPC-C ( www .tpc.org ). TPC-C was developed by a committee\, representing all major players in the database marketplace\, to be representative of typical on line enterprise databases. TPC-C consists of a precisely defined schema and 19 queries. We will review the schema and queries and demonstrate ho w each tuning technique affects their performance. We will use an open s ource package that the speaker has developed\, called DBT-2\, which many DBAs have found useful. \;\n \;\nMark Wong has an MS in Computer Science from OGI and several years of experience developing and executin g various database systems benchmarks. Most relevant to this series are his years spent at the OSDL developing and using a fair-use derivative o f the TPC-C benchmark to characterize system performance of open source software. \;\n \;\n2nd THURSDAY OF EACH MONTH\, BEGINNING JANUARY 8\, 7:00 PM \;\nPORTLAND STATE UNIVERSITY\, 1900 SW 4th AVENUE\, \ ;\nFOURTH AVENUE BUILDING – ROOM 86-01 \;\n\n\nTags: database test 2\ , dbt-2\, dbt2\, p5\, postgres\, postgresql\n\nImported from: http://cal agator.org/events/1250457199 URL:http://web.cecs.pdx.edu/~len/P5.pdf SUMMARY:PostgreSQL Portland Performance Practice Project (P5) LOCATION:Portland State University Fourth Avenue Building (FAB): 1900 SW 4th Ave.\, Portland OR 97201 US SEQUENCE:0 END:VEVENT BEGIN:VEVENT CREATED;VALUE=DATE-TIME:20090515T233648Z DTEND;TZID=America/Los_Angeles;VALUE=DATE-TIME:20090521T200000 DTSTART;TZID=America/Los_Angeles;VALUE=DATE-TIME:20090521T190000 DTSTAMP;VALUE=DATE-TIME:20090515T233648Z LAST-MODIFIED;VALUE=DATE-TIME:20090515T233648Z UID:http://calagator.org/events/1250457210 DESCRIPTION:by Len Shapiro \;\n \;\nAbstract: I'll survey how I tea ch the introductory database course at \;\nPSU. My goal for the talk is to elicit suggestions for how I could do \;\na better job. The t heme of the course is "\;transforming data into \;\nInformation&q uot\;. I use a 200 Meg database\, hosted on PostgreSQL\, instead \;\ nof the one-slide databases used in typical intro courses\, to \;\nil lustrate the principles of the course. The database is Federal \;\nE lections Commission data re donations to candidates\, so queries often&# 13\;\nreflect real questions about the real data. \;\n \;\nBio: Le n Shapiro has been a professor at PSU for 23 years. His \;\nresearch interests are primarily in query processing.\n\nTags: pdxpug\, postgres ql\, postgres\, psu\, portland state university\n\nImported from: http:/ /calagator.org/events/1250457210 URL:http://pugs.postgresql.org/pdx/ SUMMARY:PDXPUG: Introductory Database Education at PSU LOCATION:Free Geek: 1731 SE 10th Avenue\, Portland OR 97214 US SEQUENCE:0 END:VEVENT BEGIN:VEVENT CREATED;VALUE=DATE-TIME:20090710T030015Z DTEND;TZID=America/Los_Angeles;VALUE=DATE-TIME:20090716T200000 DTSTART;TZID=America/Los_Angeles;VALUE=DATE-TIME:20090716T190000 DTSTAMP;VALUE=DATE-TIME:20090710T030015Z LAST-MODIFIED;VALUE=DATE-TIME:20090715T192212Z UID:http://calagator.org/events/1250457404 DESCRIPTION:Webb Sprague will be speaking about PostGIS and the Census Da ta at the next PDXPUG meeting at FreeGeek (at 7:00pm - 1731 SE 10th Aven ue\, Portland\, OR). \;\n \;\nLooking forward to seeing everyone t here....and of course\, drinks at the Lucky Lab http://www.luckylab.com/ ) at 915 SE Hawthorne Blvd. \;\nafterwards. \;\n \;\nMore deta ils from Webb: \;\n \;\nIf anyone is wondering about specifics\, I will describe how I recently \;\ncreated a "\;crosswalk"\; table that correlates census tracts in 1980 with \;\ncensus tracts in 2000 in the Portland region (well\, Washington\, \;\nMultnomah\, and Clackamas counties)\, so that we could see poverty \;\ntrends over t he last 25 years. \;\n \;\nI used PostGIS\, Census naming conventi ons ("\;FIPS codes"\;)\, and lots of \;\nouter joins. So if you like that sort of thing\, I would love to hear \;\nyour comments tomorrow!\n\nTags: pdxpug\, postgresql\, postgis\, postgres\n\nImported from: http://calagator.org/events/1250457404 URL:http://pugs.postgresql.org/node/554 SUMMARY:PDXPUG - PostGIS and the Census Data LOCATION:Free Geek: 1731 SE 10th Avenue\, Portland OR 97214 US SEQUENCE:0 END:VEVENT BEGIN:VEVENT CREATED;VALUE=DATE-TIME:20090814T000804Z DTEND;TZID=America/Los_Angeles;VALUE=DATE-TIME:20090820T210000 DTSTART;TZID=America/Los_Angeles;VALUE=DATE-TIME:20090820T190000 DTSTAMP;VALUE=DATE-TIME:20090814T000804Z LAST-MODIFIED;VALUE=DATE-TIME:20090814T000934Z UID:http://calagator.org/events/1250457552 DESCRIPTION:Join the Portland PostgreSQL Users' Group for our monthly mee ting! \;\n \;\nWhere: FreeGeek \;\nWhen: 7pm 20 August\, 2009 \;\nWho: Jim Cser \;\nWhat: Metro simulation database \;\n&# 13\;\nDrinks afterward at the SE Lucky Lab.\n\nTags: pdxpug\, postgresql \, postgres\, sql\n\nImported from: http://calagator.org/events/12504575 52 URL:http://pugs.postgresql.org/pdx SUMMARY:PDXPUG LOCATION:Free Geek: 1731 SE 10th Avenue\, Portland OR 97214 US SEQUENCE:0 END:VEVENT BEGIN:VEVENT CREATED;VALUE=DATE-TIME:20090821T163321Z DTEND;TZID=America/Los_Angeles;VALUE=DATE-TIME:20090917T210000 DTSTART;TZID=America/Los_Angeles;VALUE=DATE-TIME:20090917T190000 DTSTAMP;VALUE=DATE-TIME:20090821T163321Z LAST-MODIFIED;VALUE=DATE-TIME:20090910T152257Z UID:http://calagator.org/events/1250457591 DESCRIPTION:PDXPUG monthly meeting. \;\n \;\nWhere: FreeGeek \;\ nWhen: 7pm 17 Sept\, 2009 \;\nWho: David Wheeler \;\nWhat: Unit Te st Your Database! \;\n \;\nDrinks afterward at the SE Lucky Lab.\n \nTags: pdxpug\, postgresql\, postgres\, sql\n\nImported from: http://ca lagator.org/events/1250457591 URL:http://pugs.postgresql.org/pdx/ SUMMARY:PDXPUG LOCATION:Free Geek: 1731 SE 10th Avenue\, Portland OR 97214 US SEQUENCE:0 END:VEVENT BEGIN:VEVENT CREATED;VALUE=DATE-TIME:20091014T230945Z DTEND;TZID=America/Los_Angeles;VALUE=DATE-TIME:20091015T210000 DTSTART;TZID=America/Los_Angeles;VALUE=DATE-TIME:20091015T190000 DTSTAMP;VALUE=DATE-TIME:20091014T230945Z LAST-MODIFIED;VALUE=DATE-TIME:20091015T092246Z UID:http://calagator.org/events/1250457860 DESCRIPTION:PDXPUG monthly meeting. \;\n \;\nWhere: FreeGeek \;\ nWhen: 7pm 15 Oct\, 2009 \;\nWho: Selena Deckelmann \;\nWhat: Buca rdo: Replication with tiny little goats \;\n \;\nDrinks afterward at the SE Lucky Lab.\n\nTags: pdxpug\, postgres\, postgresql\, sql\n\nIm ported from: http://calagator.org/events/1250457860 URL:http://pugs.postgresql.org/pdx/ SUMMARY:PDXPUG: Bucardo replication with tiny little goats LOCATION:Free Geek: 1731 SE 10th Avenue\, Portland OR 97214 US SEQUENCE:2 END:VEVENT BEGIN:VEVENT CREATED;VALUE=DATE-TIME:20091115T204334Z DTEND;TZID=America/Los_Angeles;VALUE=DATE-TIME:20091119T210000 DTSTART;TZID=America/Los_Angeles;VALUE=DATE-TIME:20091119T190000 DTSTAMP;VALUE=DATE-TIME:20091115T204334Z LAST-MODIFIED;VALUE=DATE-TIME:20091115T204655Z UID:http://calagator.org/events/1250458006 DESCRIPTION:PDXPUG monthly meeting. \;\n \;\nWhere: FreeGeek \;\ nWhen: 7pm 19 Nov\, 2009 \;\nWho: Dan Colish \;\nWhat: Materialize d Views (with cupcakes) \;\n \;\nDrinks afterward at the SE Lucky Lab.\n\nTags: pdxpug\, postgres\, postgresql\, sql\n\nImported from: htt p://calagator.org/events/1250458006 URL:http://pugs.postgresql.org/pdx/ SUMMARY:PDXPUG: November meeting: Materialized Views LOCATION:Free Geek: 1731 SE 10th Avenue\, Portland OR 97214 US SEQUENCE:2 END:VEVENT BEGIN:VEVENT CREATED;VALUE=DATE-TIME:20100310T012557Z DTEND;TZID=America/Los_Angeles;VALUE=DATE-TIME:20100318T210000 DTSTART;TZID=America/Los_Angeles;VALUE=DATE-TIME:20100318T190000 DTSTAMP;VALUE=DATE-TIME:20100310T012557Z LAST-MODIFIED;VALUE=DATE-TIME:20100310T012557Z UID:http://calagator.org/events/1250458412 DESCRIPTION:PDXPUG monthly meeting. \;\n \;\nWhere: FreeGeek \;\ nWhen: 7pm 18 Mar\, 2010 \;\nWho: you! \;\nWhat: PostgreSQL 9.0alp ha testing party \;\n \;\nDrinks afterward at the SE Lucky Lab.\n\ nTags: pdxpug\, postgres\, postgresql\, sql\n\nImported from: http://cal agator.org/events/1250458412 URL:http://pugs.postgresql.org/pdx/ SUMMARY:PDXPUG LOCATION:Free Geek: 1731 SE 10th Avenue\, Portland OR 97214 US SEQUENCE:1 END:VEVENT BEGIN:VEVENT CREATED;VALUE=DATE-TIME:20100513T194521Z DTEND;TZID=America/Los_Angeles;VALUE=DATE-TIME:20100520T210000 DTSTART;TZID=America/Los_Angeles;VALUE=DATE-TIME:20100520T190000 DTSTAMP;VALUE=DATE-TIME:20100513T194521Z LAST-MODIFIED;VALUE=DATE-TIME:20100513T194521Z UID:http://calagator.org/events/1250458686 DESCRIPTION:Join the Portland PostgreSQL Users' Group for our monthly mee ting! \;\n \;\nWhen: 7pm Thursday\, May 20 \;\nWhere: FreeGee k \;\nWho: Melissa Hollingsworth \;\nWhat: Normalization! \;\ n \;\nDrinks afterward at the SE Lucky Lab.\n\nTags: pdxpug\, postgre s\, postgresql\, sql\n\nImported from: http://calagator.org/events/12504 58686 URL:http://pugs.postgresql.org/pdx SUMMARY:PDXPUG LOCATION:Free Geek: 1731 SE 10th Avenue\, Portland OR 97214 US SEQUENCE:1 END:VEVENT BEGIN:VEVENT CREATED;VALUE=DATE-TIME:20100607T193618Z DTEND;TZID=America/Los_Angeles;VALUE=DATE-TIME:20100617T210000 DTSTART;TZID=America/Los_Angeles;VALUE=DATE-TIME:20100617T190000 DTSTAMP;VALUE=DATE-TIME:20100607T193618Z LAST-MODIFIED;VALUE=DATE-TIME:20100607T211103Z UID:http://calagator.org/events/1250458749 DESCRIPTION:Join the Portland PostgreSQL Users' Group for our monthly mee ting! \;\n \;\nWhen: 7pm Thursday\, May 20 \;\nWhere: FreeGee k \;\nWho: Mark &\; gabrielle \;\nWhat: What's new in 9.0 \;\n \;\nDrinks afterward at the SE Lucky Lab.\n\nTags: pdxpug\, post gres\, postgresql\, sql\, databases\n\nImported from: http://calagator.o rg/events/1250458749 URL:http://pugs.postgresql.org/pdx SUMMARY:PDXPUG (Portland PostgreSQL Users' Group) LOCATION:Free Geek: 1731 SE 10th Avenue\, Portland OR 97214 US SEQUENCE:2 END:VEVENT BEGIN:VEVENT CREATED;VALUE=DATE-TIME:20100913T233155Z DTEND;TZID=America/Los_Angeles;VALUE=DATE-TIME:20100916T210000 DTSTART;TZID=America/Los_Angeles;VALUE=DATE-TIME:20100916T190000 DTSTAMP;VALUE=DATE-TIME:20100913T233155Z LAST-MODIFIED;VALUE=DATE-TIME:20100914T150141Z UID:http://calagator.org/events/1250459222 DESCRIPTION:Location-based services are all the rage these days\, and alm ost \;\neveryone has a latitude and longitude or two stashed away in a numeric column somewhere. But\, there is so much more to it than just a point. Once relegated to government and academia\, geographic inform ation systems are becoming increasingly visible. With the PostGIS exten sion\, PostgreSQL is a first-class geodatabase and an incredible platfor m for working with spatial data\, but what is PostGIS and why would one use it? And beyond PostGIS there are a dizzying array of tools to load\ , visualize and interact with the wonderful geospatial information in yo ur database. This talk will cover GIS and PostGIS basics and provide an introduction to geodatabases and spatial queries. \;\n \;\n-- \;\n \;\nEdwin Knuth spent quite some time as a sysadmin and web deve loper before going back to school to study Environmental Science at the University of Alaska Southeast. He quickly became fascinated with Geogr aphic Information Systems and realized that GIS was just a really neat d atabase application. In Alaska\, Edwin worked on several unique project s\, including building bat detectors and using PostGIS to manage a wirel ess sensor network on the Juneau Icefield. He has lived in Portland for the past year and loves it very much. \;\n \;\nThen a trip to the Lucky Lab after.\n\nTags: postgres\, postgis\, postgresql\, pdxpug\n\nI mported from: http://calagator.org/events/1250459222 URL:http://pugs.postgresql.org/node/1649 SUMMARY:All about PostGIS (at Portland PostgreSQL Users Group) LOCATION:Free Geek: 1731 SE 10th Avenue\, Portland OR 97214 US SEQUENCE:4 END:VEVENT BEGIN:VEVENT CREATED;VALUE=DATE-TIME:20101014T204810Z DTEND;TZID=America/Los_Angeles;VALUE=DATE-TIME:20101021T210000 DTSTART;TZID=America/Los_Angeles;VALUE=DATE-TIME:20101021T190000 DTSTAMP;VALUE=DATE-TIME:20101014T204810Z LAST-MODIFIED;VALUE=DATE-TIME:20101014T224351Z UID:http://calagator.org/events/1250459352 DESCRIPTION:PDXPUG monthly meeting. \;\n \;\nWhere: FreeGeek \;\ nWhen: 7pm 21 Oct\, 2010 \;\nWho: Aurynn Shaw \;\nWhat: PostgreSQL and node.js \;\n \;\nPostgres and Node.js\, a powerful event-driv en programming environment paired with our favourite open-source databas e\, now together in the same great package! Aurynn will be going over th e node.js environment\, how it differs from other programming environmen ts\, and how to use postgres with node. \;\n \;\nAurynn Shaw is Le ad Userspace Developer at Command Prompt\, Inc. She has come all the wa y from another country to present this talk\, so don't miss it! \;\n& #13\;\nBeer afterwards at the Lucky Lab. \;\n \;\nSee you there!\n \nTags: pdxpug\, postgres\, postgresql\, sql\n\nImported from: http://ca lagator.org/events/1250459352 URL:http://pugs.postgresql.org/pdx/ SUMMARY:PDXPUG: Postgres + node.js LOCATION:Free Geek: 1731 SE 10th Avenue\, Portland OR 97214 US SEQUENCE:2 END:VEVENT BEGIN:VEVENT CREATED;VALUE=DATE-TIME:20110415T003137Z DTEND;TZID=America/Los_Angeles;VALUE=DATE-TIME:20110421T200000 DTSTART;TZID=America/Los_Angeles;VALUE=DATE-TIME:20110421T190000 DTSTAMP;VALUE=DATE-TIME:20110415T003137Z LAST-MODIFIED;VALUE=DATE-TIME:20110415T003402Z UID:http://calagator.org/events/1250460492 DESCRIPTION:This month's meeting marks the fourth installment in our &quo t\;Founders Series"\;.. \;\n \;\nWhen: 7-9pm Thu Apr 21\, 2011 \;\nWhere: FreeGeek \;\nWho: David Wheeler \;\nWhat: Distribut ing Extensions on PGXN \;\n \;\nSo you've solved a common problem in PostgreSQL\, a serious pain point that lots of other people could tak e advantage of. You want to open-source the code\, and would like to pac kage it up and distribute it where people can find it\, read its docs\, and download and install it. \;\n \;\nThe newest destination for d istributing PostgreSQL extensions is PGXN\, the PostgreSQL Extension net work. PGXN offers a central index of PostgreSQL extensions and their doc umentation\, making it easy for people to find an install extensions. 3\;\n \;\nHow do you optimize your extension distribution for maximum PGXN exposure? By careful packaging\, thorough documentation\, and simp le installation. Join me for an overview of how best to achieve that — i ncluding how to build extensions compatible with PostgreSQL 9.1's improv ed extension support. \;\n \;\nDavid Wheeler is an associate at PG Experts\, and is responsible for PGXN\, the PostgreSQL Extension Network ) and pgTAP. He's into testing and extension distribution. \;\n \; \nBeer afterwards at the Lucky Lab. See you there!\n\nTags: postgres\, p ostgresql\, pdxpug\n\nImported from: http://calagator.org/events/1250460 492 URL:http://pugs.postgresql.org/pdx SUMMARY:PDXPUG: Distributing Extensions on PGXN LOCATION:Free Geek: 1731 SE 10th Avenue\, Portland OR 97214 US SEQUENCE:2 END:VEVENT BEGIN:VEVENT CREATED;VALUE=DATE-TIME:20110506T224851Z DTEND;TZID=America/Los_Angeles;VALUE=DATE-TIME:20110519T200000 DTSTART;TZID=America/Los_Angeles;VALUE=DATE-TIME:20110519T190000 DTSTAMP;VALUE=DATE-TIME:20110506T224851Z LAST-MODIFIED;VALUE=DATE-TIME:20110506T224851Z UID:http://calagator.org/events/1250460572 DESCRIPTION:Normally\, Gabrielle ensures that we have thoughtful and info rmative presentations. Unfortunately for you\, I -- Melissa -- am guest -hosting this month. \;\n \;\nWhat I'll come up with is anyone's guess\, but BYOB is strongly recommended. Muahahaha. \;\n \;\nOh \, and we may also talk about Postgres or something. And we'll join tho se folks at the Lucky Lab afterwards. \;\n\n\nTags: epdx:group=31\, p ostgres\, windows\, installation\, shenanigans\, byob\n\nImported from: http://calagator.org/events/1250460572 SUMMARY:PDXPUG LOCATION:Free Geek: 1731 SE 10th Avenue\, Portland OR 97214 US SEQUENCE:1 END:VEVENT BEGIN:VEVENT CREATED;VALUE=DATE-TIME:20110715T143639Z DTEND;TZID=America/Los_Angeles;VALUE=DATE-TIME:20110721T210000 DTSTART;TZID=America/Los_Angeles;VALUE=DATE-TIME:20110721T190000 DTSTAMP;VALUE=DATE-TIME:20110715T143639Z LAST-MODIFIED;VALUE=DATE-TIME:20110715T143639Z UID:http://calagator.org/events/1250460830 DESCRIPTION:This month's topic is "\;Data Visualization and Explorati on Techniques Using R and Postgres"\; with PSU's Dr Christopher Mons ere. \;\n \;\nFull details: \;\nhttp://pugs.postgresql.org/node /1669 \;\n\n\nTags: postgres\, databases\, r\, visualization\, epdx:g roup=31\, epdx:group=551\, epdx:group=591\n\nImported from: http://calag ator.org/events/1250460830 URL:http://pugs.postgresql.org/pdx SUMMARY:PDXPUG LOCATION:Free Geek: 1731 SE 10th Avenue\, Portland OR 97214 US SEQUENCE:1 END:VEVENT BEGIN:VEVENT CREATED;VALUE=DATE-TIME:20110712T161344Z DTEND;TZID=America/Los_Angeles;VALUE=DATE-TIME:20110724T170000 DTSTART;TZID=America/Los_Angeles;VALUE=DATE-TIME:20110724T093000 DTSTAMP;VALUE=DATE-TIME:20110712T161344Z LAST-MODIFIED;VALUE=DATE-TIME:20110712T161344Z UID:http://calagator.org/events/1250460814 DESCRIPTION:Coming to OSCON? Be sure to come a day early and join us for another PgDay! This summer marks PDXPUG's 5th anniversary\, and we want to see *your* smiling face! We will be celebrating at Gotham Tavern afte r the day of sessions. Sign up for sessions and afterparty here: http:// bit.ly/f1F2Mz . \;\n \;\nYes\, it's ok to show up just for the aft ernoon (or the party) if your flight arrives on Sunday. \;\n \;\nW e'd like a $30 donation to SPI for the sessions\, but don't let lack of funds deter you from attending.\n\nTags: oscon\, postgres\, postgresql\, databases\, pdxpug\n\nImported from: http://calagator.org/events/125046 0814 URL:http://wiki.postgresql.org/wiki/PDXPUGDay2011 SUMMARY:PgDay at OSCON LOCATION:Oregon Convention Center: 777 NE Martin Luther King Jr. Blvd.\, Portland OR 97232 US SEQUENCE:1 END:VEVENT BEGIN:VEVENT CREATED;VALUE=DATE-TIME:20110816T021259Z DTEND;TZID=America/Los_Angeles;VALUE=DATE-TIME:20110818T203000 DTSTART;TZID=America/Los_Angeles;VALUE=DATE-TIME:20110818T190000 DTSTAMP;VALUE=DATE-TIME:20110816T021259Z LAST-MODIFIED;VALUE=DATE-TIME:20110816T214501Z UID:http://calagator.org/events/1250461220 DESCRIPTION:Rob Wultsch\, a recent addition to Facebook's Database Operat ions team\, will compare and contrast the Facebook deployment with his p revious work with another large deployment of open source databases. In this db-agnostic talk\, he'll go over: the bizarre becoming ordinary\, t he many types of infrastructure that do not scale and what does and does not work when building a DBA team. \;\n \;\nBefore joining Facebo ok\, Rob worked for a very large hosting company as a database administr ator and a newspaper as a web developer. In his free time he enjoys ridi ng his motorcycle and bicycle and fantasizes about moving to Portland.&# 13\;\n \;\nAs always\, beer afterwards at the Lucky Lab. See you ther e!\n\nTags: postgresql\, postgres\, mysql\, ops\, facebook\, plancast:pl an=6xft\n\nImported from: http://calagator.org/events/1250461220 URL:http://Pugs.PostgreSQL.org/pdx SUMMARY:PDXPUG: Lessons from managing way too many databases at Facebook LOCATION:Free Geek: 1731 SE 10th Avenue\, Portland OR 97214 US SEQUENCE:3 END:VEVENT BEGIN:VEVENT CREATED;VALUE=DATE-TIME:20110908T215543Z DTEND;TZID=America/Los_Angeles;VALUE=DATE-TIME:20110915T200000 DTSTART;TZID=America/Los_Angeles;VALUE=DATE-TIME:20110915T190000 DTSTAMP;VALUE=DATE-TIME:20110908T215543Z LAST-MODIFIED;VALUE=DATE-TIME:20110909T130955Z UID:http://calagator.org/events/1250461298 DESCRIPTION:When: 7-9pm Thu Sep 15\, 2011 \;\nWhere: FreeGeek \;\nW ho: Joshua Drake \;\nWhat: Practical PostgreSQL Performance \;\n&# 13\;\nThis presentation provides down tot earth performance advice. \ ;\n \;\nJoshua D. Drake (JD) is lead consultant at Command Prompt\, I nc. and \;\nPresident of PgUS. \;\n \;\nBeer afterwards at the Lucky Lab. See you there!\n\nTags: pdxpug\, postgres\, postgresql\n\nImp orted from: http://calagator.org/events/1250461298 URL:http://pugs.postgresql.org/node/1675 SUMMARY:PDXPUG: Practical PostgreSQL Performance LOCATION:Free Geek: 1731 SE 10th Avenue\, Portland OR 97214 US SEQUENCE:2 END:VEVENT BEGIN:VEVENT CREATED;VALUE=DATE-TIME:20111007T015400Z DTEND;TZID=America/Los_Angeles;VALUE=DATE-TIME:20111020T210000 DTSTART;TZID=America/Los_Angeles;VALUE=DATE-TIME:20111020T190000 DTSTAMP;VALUE=DATE-TIME:20111007T015400Z LAST-MODIFIED;VALUE=DATE-TIME:20111007T015400Z UID:http://calagator.org/events/1250461435 DESCRIPTION:When: 7-9pm Thu Oct 20\, 2011 \;\nWhere: Iovation \;\nW ho: Brent Dombrowski \;\nWhat: Upgrading PostGIS from 8.something to 9.0 \;\n \;\nSee PDXPUG blog (linked) for details.\n\nTags: pdxpug \, postgres\, postgresql\, postgis\, epdx:group=31\n\nImported from: htt p://calagator.org/events/1250461435 URL:http://pugs.postgresql.org/node/1678 SUMMARY:PDXPUG: Upgrading PostGIS LOCATION:Iovation: 111 SW 5th\, Portland Oregon 97204 US SEQUENCE:1 END:VEVENT BEGIN:VEVENT CREATED;VALUE=DATE-TIME:20111104T032658Z DTEND;TZID=America/Los_Angeles;VALUE=DATE-TIME:20111117T210000 DTSTART;TZID=America/Los_Angeles;VALUE=DATE-TIME:20111117T190000 DTSTAMP;VALUE=DATE-TIME:20111104T032658Z LAST-MODIFIED;VALUE=DATE-TIME:20111104T032658Z UID:http://calagator.org/events/1250461544 DESCRIPTION:See PDXPUG blog (linked) for details.\n\nTags: postgresql\, p ostgres\, pdxpug\, epdx:group=31\, database\n\nImported from: http://cal agator.org/events/1250461544 URL:http://pugs.postgresql.org/node/1679 SUMMARY:PDXPUG: collectd and Postgres LOCATION:Free Geek: 1731 SE 10th Avenue\, Portland OR 97214 US SEQUENCE:2 END:VEVENT BEGIN:VEVENT CREATED;VALUE=DATE-TIME:20120107T014653Z DTEND;TZID=America/Los_Angeles;VALUE=DATE-TIME:20120119T210000 DTSTART;TZID=America/Los_Angeles;VALUE=DATE-TIME:20120119T190000 DTSTAMP;VALUE=DATE-TIME:20120107T014653Z LAST-MODIFIED;VALUE=DATE-TIME:20120107T014653Z UID:http://calagator.org/events/1250461819 DESCRIPTION:See PDXPUG blog (linked) for details.\n\nTags: postgresql\, d atabase\, postgres\, pdxpug\, epdx:group=31\n\nImported from: http://cal agator.org/events/1250461819 URL:http://pdxpug.wordpress.com/2012/01/07/pdxpug-january-meeting/ SUMMARY:PDXPUG: Database Tracking LOCATION:Iovation: 111 SW 5th\, Portland Oregon 97204 US SEQUENCE:1 END:VEVENT BEGIN:VEVENT CREATED;VALUE=DATE-TIME:20120211T000427Z DTEND;TZID=America/Los_Angeles;VALUE=DATE-TIME:20120216T210000 DTSTART;TZID=America/Los_Angeles;VALUE=DATE-TIME:20120216T190000 DTSTAMP;VALUE=DATE-TIME:20120211T000427Z LAST-MODIFIED;VALUE=DATE-TIME:20120211T000427Z UID:http://calagator.org/events/1250461943 DESCRIPTION:See PDXPUG blog (linked) for details.\n\nTags: postgresql\, d atabase\, postgres\, pdxpug\, epdx:group=31\n\nImported from: http://cal agator.org/events/1250461943 URL:http://pdxpug.wordpress.com/2012/02/10/pdxpug-february-meeting/ SUMMARY:PDXPUG: Locks\, etc LOCATION:Iovation: 111 SW 5th\, Portland Oregon 97204 US SEQUENCE:1 END:VEVENT BEGIN:VEVENT CREATED;VALUE=DATE-TIME:20120310T074400Z DTEND;TZID=America/Los_Angeles;VALUE=DATE-TIME:20120315T210000 DTSTART;TZID=America/Los_Angeles;VALUE=DATE-TIME:20120315T190000 DTSTAMP;VALUE=DATE-TIME:20120310T074400Z LAST-MODIFIED;VALUE=DATE-TIME:20120310T074400Z UID:http://calagator.org/events/1250462127 DESCRIPTION:See PDXPUG blog (linked) for details. Also\, "\;beware t he Ides of March"\;\, &\;c.\n\nTags: postgresql\, database\, post gres\, pdxpug\, epdx:group=31\n\nImported from: http://calagator.org/eve nts/1250462127 URL:http://pdxpug.wordpress.com/2012/03/09/pdxpug-march-meeting-next-week / SUMMARY:PDXPUG: NoSQL for People Living Under a Rock LOCATION:Iovation: 111 SW 5th\, Portland Oregon 97204 US SEQUENCE:1 END:VEVENT BEGIN:VEVENT CREATED;VALUE=DATE-TIME:20120306T200412Z DTEND;TZID=America/Los_Angeles;VALUE=DATE-TIME:20120402T170000 DTSTART;TZID=America/Los_Angeles;VALUE=DATE-TIME:20120402T080000 DTSTAMP;VALUE=DATE-TIME:20120306T200412Z LAST-MODIFIED;VALUE=DATE-TIME:20120306T200412Z UID:http://calagator.org/events/1250462114 DESCRIPTION:Get 10% off this developer event with code\, "\;epdx_10&q uot\;! (That's on top of the 50% early bird special - ends March 18!) 3\;\nThe Cloud Foundry Open Tour gives enterprise developers expert inst ruction on how to get the best results from Platform-as-a-Service in the cloud. Register for this event to learn: \;\n* Basic Cloud Foundry c ommands for both the public and micro clouds \;\n*Cloud application d evelopment tips for Spring\, Java\, Ruby and Node.js \;\n* How to con nect to application services like MySQL\, MongoDB\, Redis and RabbitMQ&# 13\;\n \;\nMeet the experts behind the leading open source cloud plat form for enterprise applications\, discuss the latest innovations with o ther developers and expand your opportunities by attending the Cloud Fou ndry Open Tour. \n\nTags: ruby\, postgres\, java\, mysql\, web developme nt\, scala\, nosql\, spring\, mongodb\, redis\, rabbitmq\, node.js\, paa s\, platform as a service\, vmware\n\nImported from: http://calagator.or g/events/1250462114 URL:http://cloudfoundryopen.com/2012/portland SUMMARY:Cloud Foundry Open Tour 2012 - Portland LOCATION:The Nines Hotel: 525 SW Morrison St\, Portland OR 97204 US SEQUENCE:1 END:VEVENT BEGIN:VEVENT CREATED;VALUE=DATE-TIME:20120406T001114Z DTEND;TZID=America/Los_Angeles;VALUE=DATE-TIME:20120419T210000 DTSTART;TZID=America/Los_Angeles;VALUE=DATE-TIME:20120419T190000 DTSTAMP;VALUE=DATE-TIME:20120406T001114Z LAST-MODIFIED;VALUE=DATE-TIME:20120406T001114Z UID:http://calagator.org/events/1250462241 DESCRIPTION:See PDXPUG blog (linked) for details. \n\nTags: postgresql\, database\, postgres\, pdxpug\, epdx:group=31\n\nImported from: http://ca lagator.org/events/1250462241 URL:http://pdxpug.wordpress.com/2012/04/05/pdxpug-april-meeting-in-two-we eks/ SUMMARY:PDXPUG: Data Near Here LOCATION:Iovation: 111 SW 5th\, Portland Oregon 97204 US SEQUENCE:1 END:VEVENT BEGIN:VEVENT CREATED;VALUE=DATE-TIME:20120504T021518Z DTEND;TZID=America/Los_Angeles;VALUE=DATE-TIME:20120517T210000 DTSTART;TZID=America/Los_Angeles;VALUE=DATE-TIME:20120517T190000 DTSTAMP;VALUE=DATE-TIME:20120504T021518Z LAST-MODIFIED;VALUE=DATE-TIME:20120504T021518Z UID:http://calagator.org/events/1250462358 DESCRIPTION:See PDXPUG blog (linked) for details. \n\nTags: postgresql\, database\, postgres\, pdxpug\, epdx:group=31\n\nImported from: http://ca lagator.org/events/1250462358 URL:http://pdxpug.wordpress.com/2012/05/03/pdxpug-may-meeting-in-two-week s/ SUMMARY:PDXPUG: Replication Without Tears LOCATION:Iovation: 111 SW 5th\, Portland Oregon 97204 US SEQUENCE:1 END:VEVENT BEGIN:VEVENT CREATED;VALUE=DATE-TIME:20120607T231815Z DTEND;TZID=America/Los_Angeles;VALUE=DATE-TIME:20120621T210000 DTSTART;TZID=America/Los_Angeles;VALUE=DATE-TIME:20120621T190000 DTSTAMP;VALUE=DATE-TIME:20120607T231815Z LAST-MODIFIED;VALUE=DATE-TIME:20120607T231815Z UID:http://calagator.org/events/1250462452 DESCRIPTION:See PDXPUG blog (linked) for details. \n\nTags: postgresql\, database\, postgres\, pdxpug\, android\, epdx:group=31\n\nImported from: http://calagator.org/events/1250462452 URL:http://pdxpug.wordpress.com/2012/06/07/pdxpug-june-meeting-in-two-wee ks/ SUMMARY:PDXPUG: Databases from Android LOCATION:Iovation: 111 SW 5th\, Portland Oregon 97204 US SEQUENCE:2 END:VEVENT BEGIN:VEVENT CREATED;VALUE=DATE-TIME:20120803T003113Z DTEND;TZID=America/Los_Angeles;VALUE=DATE-TIME:20120816T210000 DTSTART;TZID=America/Los_Angeles;VALUE=DATE-TIME:20120816T190000 DTSTAMP;VALUE=DATE-TIME:20120803T003113Z LAST-MODIFIED;VALUE=DATE-TIME:20120803T003113Z UID:http://calagator.org/events/1250462677 DESCRIPTION:See PDXPUG blog (linked) for details. \n\nTags: postgresql\, database\, postgres\, pdxpug\, android\, epdx:group=31\n\nImported from: http://calagator.org/events/1250462677 URL:http://pdxpug.wordpress.com/2012/08/02/pdxpug-august-meeting-in-two-w eeks-2/ SUMMARY:PDXPUG: Vertically Scaling Postgres LOCATION:Iovation: 111 SW 5th\, Portland Oregon 97204 US SEQUENCE:1 END:VEVENT BEGIN:VEVENT CREATED;VALUE=DATE-TIME:20120908T011549Z DTEND;TZID=America/Los_Angeles;VALUE=DATE-TIME:20120920T210000 DTSTART;TZID=America/Los_Angeles;VALUE=DATE-TIME:20120920T190000 DTSTAMP;VALUE=DATE-TIME:20120908T011549Z LAST-MODIFIED;VALUE=DATE-TIME:20120920T162404Z UID:http://calagator.org/events/1250462832 DESCRIPTION:See PDXPUG blog (linked) for details. \;\n \;\nSqitch information is at http://sqitch.org/\n\nTags: postgresql\, database\, po stgres\, pdxpug\, epdx:group=31\n\nImported from: http://calagator.org/e vents/1250462832 URL:http://pdxpug.wordpress.com/2012/09/07/pdxpug-september-meeting-comin g-up/ SUMMARY:PDXPUG: Sqitch LOCATION:Iovation: 111 SW 5th\, Portland Oregon 97204 US SEQUENCE:2 END:VEVENT BEGIN:VEVENT CREATED;VALUE=DATE-TIME:20121026T150450Z DTEND;TZID=America/Los_Angeles;VALUE=DATE-TIME:20121115T210000 DTSTART;TZID=America/Los_Angeles;VALUE=DATE-TIME:20121115T190000 DTSTAMP;VALUE=DATE-TIME:20121026T150450Z LAST-MODIFIED;VALUE=DATE-TIME:20121026T150450Z UID:http://calagator.org/events/1250463037 DESCRIPTION:See PDXPUG blog (linked) for details. \n\nTags: postgresql\, database\, postgres\, pdxpug\, epdx:group=31\n\nImported from: http://ca lagator.org/events/1250463037 URL:http://pdxpug.wordpress.com/2012/10/25/pdxpug-november-meeting-in-thr ee-weeks/ SUMMARY:PDXPUG: Sqitch LOCATION:Iovation: 111 SW 5th\, Portland Oregon 97204 US SEQUENCE:1 END:VEVENT BEGIN:VEVENT CREATED;VALUE=DATE-TIME:20130110T012641Z DTEND;TZID=America/Los_Angeles;VALUE=DATE-TIME:20130117T210000 DTSTART;TZID=America/Los_Angeles;VALUE=DATE-TIME:20130117T190000 DTSTAMP;VALUE=DATE-TIME:20130110T012641Z LAST-MODIFIED;VALUE=DATE-TIME:20130110T012641Z UID:http://calagator.org/events/1250463361 DESCRIPTION:See PDXPUG blog (linked) for details. \n\nTags: postgresql\, database\, postgres\, pdxpug\, epdx:group=31\n\nImported from: http://ca lagator.org/events/1250463361 URL:https://pdxpug.wordpress.com/2013/01/09/pdxpug-january-meeting-2/ SUMMARY:PDXPUG: PostgreSQL in the Cloud LOCATION:Iovation: 111 SW 5th\, Portland Oregon 97204 US SEQUENCE:1 END:VEVENT BEGIN:VEVENT CREATED;VALUE=DATE-TIME:20130219T025129Z DTEND;TZID=America/Los_Angeles;VALUE=DATE-TIME:20130221T210000 DTSTART;TZID=America/Los_Angeles;VALUE=DATE-TIME:20130221T190000 DTSTAMP;VALUE=DATE-TIME:20130219T025129Z LAST-MODIFIED;VALUE=DATE-TIME:20130219T025129Z UID:http://calagator.org/events/1250463670 DESCRIPTION:See PDXPUG blog (linked) for details. \n\nTags: postgresql\, database\, postgres\, pdxpug\, epdx:group=31\n\nImported from: http://ca lagator.org/events/1250463670 URL:https://pdxpug.wordpress.com/2013/02/18/pdxpug-february-meeting-this- week/ SUMMARY:PDXPUG: Dawn of a New Backup Era LOCATION:Iovation: 111 SW 5th\, Portland Oregon 97204 US SEQUENCE:1 END:VEVENT BEGIN:VEVENT CREATED;VALUE=DATE-TIME:20130319T171632Z DTEND;TZID=America/Los_Angeles;VALUE=DATE-TIME:20130321T210000 DTSTART;TZID=America/Los_Angeles;VALUE=DATE-TIME:20130321T190000 DTSTAMP;VALUE=DATE-TIME:20130319T171632Z LAST-MODIFIED;VALUE=DATE-TIME:20130319T171632Z UID:http://calagator.org/events/1250463830 DESCRIPTION:Autovacuum’s like a Roomba\, right? You just turn it on and i t does all the work for you. Well\, not quite – for one\, your pets can’ t ride around on it – and occasionally it may get stuck in a (figurative ) corner. In this talk\, we’ll discuss vacuum\, analyze\, and their daem onic counterparts: how to adjust them to perform appropriately*\, and pe rhaps more importantly\, what the heck are they actually doing? \;\n& #13\;\nThis is a beginner-to-intermediate level talk\, but you will lear n something new about vacuuming\, regardless.** \;\n– \;\n \;\n Gabrielle Roth is a consultant with EnterpriseDB. She specializes in net work\, database\, and system monitoring\, as well as abusing SQL. \;\ n \;\n– \;\n \;\nAfter-meeting beer location: Huber’s\, the old est bar in Portland. See you there!\n\nTags: postgresql\, postgres\, pdx pug\n\nImported from: http://calagator.org/events/1250463830 URL:http://pdxpug.wordpress.com/2013/03/18/pdxpug-may-meeting-autovacuum- and-you/ SUMMARY:PDXPUG: Autovacuum and You LOCATION:Iovation: 111 SW 5th\, Portland Oregon 97204 US SEQUENCE:1 END:VEVENT BEGIN:VEVENT CREATED;VALUE=DATE-TIME:20130327T011710Z DTEND;TZID=America/Los_Angeles;VALUE=DATE-TIME:20130418T210000 DTSTART;TZID=America/Los_Angeles;VALUE=DATE-TIME:20130418T190000 DTSTAMP;VALUE=DATE-TIME:20130327T011710Z LAST-MODIFIED;VALUE=DATE-TIME:20130327T011710Z UID:http://calagator.org/events/1250463881 DESCRIPTION:See link for details.\n\nTags: postgresql\, postgres\, pdxpug \n\nImported from: http://calagator.org/events/1250463881 URL:http://pdxpug.wordpress.com SUMMARY:PDXPUG: Extreme Database Makeover LOCATION:Iovation: 111 SW 5th\, Portland Oregon 97204 US SEQUENCE:1 END:VEVENT BEGIN:VEVENT CREATED;VALUE=DATE-TIME:20130507T174427Z DTEND;TZID=America/Los_Angeles;VALUE=DATE-TIME:20130515T200000 DTSTART;TZID=America/Los_Angeles;VALUE=DATE-TIME:20130515T180000 DTSTAMP;VALUE=DATE-TIME:20130507T174427Z LAST-MODIFIED;VALUE=DATE-TIME:20130507T174427Z UID:http://calagator.org/events/1250464167 DESCRIPTION:Join us for the kickoff of the Portland PHP Meetup! The first meeting will be very informal. We will meet and discuss what topics we' d like to schedule for future meetup. \;\n \;\nBring a friend!\n\n Tags: beer\, php\, postgres\, javascript\, jquery\, mysql\, zend\, behat \n\nImported from: http://calagator.org/events/1250464167 URL:http://www.meetup.com/PDX-PHP/ SUMMARY:PDX PHP LOCATION:McMenamins Market St. Pub: 1526 Southwest 10th Avenue\, Portland OR 97201 US SEQUENCE:1 END:VEVENT BEGIN:VEVENT CREATED;VALUE=DATE-TIME:20130327T011757Z DTEND;TZID=America/Los_Angeles;VALUE=DATE-TIME:20130516T210000 DTSTART;TZID=America/Los_Angeles;VALUE=DATE-TIME:20130516T190000 DTSTAMP;VALUE=DATE-TIME:20130327T011757Z LAST-MODIFIED;VALUE=DATE-TIME:20130327T011757Z UID:http://calagator.org/events/1250463882 DESCRIPTION:See link for details.\n\nTags: postgresql\, postgres\, pdxpug \n\nImported from: http://calagator.org/events/1250463882 URL:http://pdxpug.wordpress.com SUMMARY:PDXPUG: Lightning Talks LOCATION:Iovation: 111 SW 5th\, Portland Oregon 97204 US SEQUENCE:1 END:VEVENT BEGIN:VEVENT CREATED;VALUE=DATE-TIME:20130617T200624Z DTEND;TZID=America/Los_Angeles;VALUE=DATE-TIME:20130620T210000 DTSTART;TZID=America/Los_Angeles;VALUE=DATE-TIME:20130620T190000 DTSTAMP;VALUE=DATE-TIME:20130617T200624Z LAST-MODIFIED;VALUE=DATE-TIME:20130617T200624Z UID:http://calagator.org/events/1250464401 DESCRIPTION:See link for details.\n\nTags: postgresql\, postgres\, pdxpug \n\nImported from: http://calagator.org/events/1250464401 URL:http://pdxpug.wordpress.com/2013/06/06/pdxpug-june-meeting-lightning- talks-really/ SUMMARY:PDXPUG: Lightning Talks LOCATION:Iovation: 111 SW 5th\, Portland Oregon 97204 US SEQUENCE:1 END:VEVENT BEGIN:VEVENT CREATED;VALUE=DATE-TIME:20130627T180439Z DTEND;TZID=America/Los_Angeles;VALUE=DATE-TIME:20130724T200000 DTSTART;TZID=America/Los_Angeles;VALUE=DATE-TIME:20130724T180000 DTSTAMP;VALUE=DATE-TIME:20130627T180439Z LAST-MODIFIED;VALUE=DATE-TIME:20130724T164245Z UID:http://calagator.org/events/1250464479 DESCRIPTION:We have some special out-of-town guests here for OSCON\, so w e're having a special meeting for July. Details will be posted on the p dxpug website: http://wp.me/p25MlK-4r \;\n \;\nNote that this is n ot our regular meeting time\, day\, or location!\n\nTags: postgresql\, p ostgres\, pdxpug\n\nImported from: http://calagator.org/events/125046447 9 URL:http://pdxpug.wordpress.com SUMMARY:PDXPUG: July meeting LOCATION:Emma: 524 E Burnside St.\, Suite 510\, Portland Oregon 97214 Uni ted States SEQUENCE:2 END:VEVENT BEGIN:VEVENT CREATED;VALUE=DATE-TIME:20130801T022429Z DTEND;TZID=America/Los_Angeles;VALUE=DATE-TIME:20130815T210000 DTSTART;TZID=America/Los_Angeles;VALUE=DATE-TIME:20130815T190000 DTSTAMP;VALUE=DATE-TIME:20130801T022429Z LAST-MODIFIED;VALUE=DATE-TIME:20130801T022429Z UID:http://calagator.org/events/1250464645 DESCRIPTION:See link for details.\n\nTags: postgresql\, postgres\, pdxpug \n\nImported from: http://calagator.org/events/1250464645 URL:http://pdxpug.wordpress.com SUMMARY:PDXPUG: YAMS Aren't Sweet Potatoes LOCATION:Iovation: 111 SW 5th\, Portland Oregon 97204 US SEQUENCE:1 END:VEVENT BEGIN:VEVENT CREATED;VALUE=DATE-TIME:20130905T212350Z DTEND;TZID=America/Los_Angeles;VALUE=DATE-TIME:20130919T210000 DTSTART;TZID=America/Los_Angeles;VALUE=DATE-TIME:20130919T190000 DTSTAMP;VALUE=DATE-TIME:20130905T212350Z LAST-MODIFIED;VALUE=DATE-TIME:20130905T212350Z UID:http://calagator.org/events/1250464840 DESCRIPTION:See link for details.\n\nTags: postgresql\, postgres\, pdxpug \n\nImported from: http://calagator.org/events/1250464840 URL:http://pdxpug.wordpress.com SUMMARY:PDXPUG: JSON LOCATION:Iovation: 111 SW 5th\, Portland Oregon 97204 US SEQUENCE:1 END:VEVENT BEGIN:VEVENT CREATED;VALUE=DATE-TIME:20131003T141449Z DTEND;TZID=America/Los_Angeles;VALUE=DATE-TIME:20131017T210000 DTSTART;TZID=America/Los_Angeles;VALUE=DATE-TIME:20131017T190000 DTSTAMP;VALUE=DATE-TIME:20131003T141449Z LAST-MODIFIED;VALUE=DATE-TIME:20131017T221324Z UID:http://calagator.org/events/1250465006 DESCRIPTION:Portland Postgres Users Group. See link for details.\n\nTags: postgresql\, postgres\, pdxpug\n\nImported from: http://calagator.org/e vents/1250465006 URL:http://pdxpug.wordpress.com SUMMARY:PDXPUG: UrbanFootprint LOCATION:Iovation: 111 SW 5th\, Portland Oregon 97204 US SEQUENCE:2 END:VEVENT BEGIN:VEVENT CREATED;VALUE=DATE-TIME:20131101T140043Z DTEND;TZID=America/Los_Angeles;VALUE=DATE-TIME:20131121T210000 DTSTART;TZID=America/Los_Angeles;VALUE=DATE-TIME:20131121T190000 DTSTAMP;VALUE=DATE-TIME:20131101T140043Z LAST-MODIFIED;VALUE=DATE-TIME:20131101T140043Z UID:http://calagator.org/events/1250465164 DESCRIPTION:Portland Postgres Users Group. See link for details.\n\nTags: postgresql\, postgres\, pdxpug\n\nImported from: http://calagator.org/e vents/1250465164 URL:http://pdxpug.wordpress.com SUMMARY:PDXPUG: Aquameta LOCATION:Iovation: 111 SW 5th\, Portland Oregon 97204 US SEQUENCE:1 END:VEVENT BEGIN:VEVENT CREATED;VALUE=DATE-TIME:20140110T000648Z DTEND;TZID=America/Los_Angeles;VALUE=DATE-TIME:20140116T210000 DTSTART;TZID=America/Los_Angeles;VALUE=DATE-TIME:20140116T190000 DTSTAMP;VALUE=DATE-TIME:20140110T000648Z LAST-MODIFIED;VALUE=DATE-TIME:20140110T000648Z UID:http://calagator.org/events/1250465469 DESCRIPTION:Portland Postgres Users Group. See link for details.\n\nTags: postgresql\, postgres\, pdxpug\n\nImported from: http://calagator.org/e vents/1250465469 URL:http://pdxpug.wordpress.com SUMMARY:PDXPUG: January meeting LOCATION:Iovation: 111 SW 5th\, Portland Oregon 97204 US SEQUENCE:1 END:VEVENT BEGIN:VEVENT CREATED;VALUE=DATE-TIME:20140120T161214Z DTEND;TZID=America/Los_Angeles;VALUE=DATE-TIME:20140125T140000 DTSTART;TZID=America/Los_Angeles;VALUE=DATE-TIME:20140125T100000 DTSTAMP;VALUE=DATE-TIME:20140120T161214Z LAST-MODIFIED;VALUE=DATE-TIME:20140120T161214Z UID:http://calagator.org/events/1250465548 DESCRIPTION:See web link for details. \;\n \;\nAdvanced signup is r equired.\n\nTags: pdxpug\, postgres\n\nImported from: http://calagator.o rg/events/1250465548 URL:http://pdxpug.wordpress.com/2013/12/30/streaming-rep-saturday/ SUMMARY:PDXPUG: Streaming Rep Saturday workshop LOCATION:Emma: 524 E Burnside St.\, Suite 510\, Portland Oregon 97214 Uni ted States SEQUENCE:1 END:VEVENT BEGIN:VEVENT CREATED;VALUE=DATE-TIME:20140204T143053Z DTEND;TZID=America/Los_Angeles;VALUE=DATE-TIME:20140220T210000 DTSTART;TZID=America/Los_Angeles;VALUE=DATE-TIME:20140220T190000 DTSTAMP;VALUE=DATE-TIME:20140204T143053Z LAST-MODIFIED;VALUE=DATE-TIME:20140204T143053Z UID:http://calagator.org/events/1250465634 DESCRIPTION:Portland Postgres Users Group. See link for details.\n\nTags: postgresql\, postgres\, pdxpug\n\nImported from: http://calagator.org/e vents/1250465634 URL:http://pdxpug.wordpress.com SUMMARY:PDXPUG: February meeting LOCATION:Iovation: 111 SW 5th\, Portland Oregon 97204 US SEQUENCE:1 END:VEVENT BEGIN:VEVENT CREATED;VALUE=DATE-TIME:20140228T221525Z DTEND;TZID=America/Los_Angeles;VALUE=DATE-TIME:20140320T210000 DTSTART;TZID=America/Los_Angeles;VALUE=DATE-TIME:20140320T190000 DTSTAMP;VALUE=DATE-TIME:20140228T221525Z LAST-MODIFIED;VALUE=DATE-TIME:20140228T221525Z UID:http://calagator.org/events/1250465772 DESCRIPTION:Portland Postgres Users Group. See link for details.\n\nTags: postgresql\, postgres\, pdxpug\n\nImported from: http://calagator.org/e vents/1250465772 URL:http://pdxpug.wordpress.com SUMMARY:PDXPUG: March meeting LOCATION:Iovation: 111 SW 5th\, Portland Oregon 97204 US SEQUENCE:1 END:VEVENT BEGIN:VEVENT CREATED;VALUE=DATE-TIME:20140414T144616Z DTEND;TZID=America/Los_Angeles;VALUE=DATE-TIME:20140417T210000 DTSTART;TZID=America/Los_Angeles;VALUE=DATE-TIME:20140417T190000 DTSTAMP;VALUE=DATE-TIME:20140414T144616Z LAST-MODIFIED;VALUE=DATE-TIME:20140414T144616Z UID:http://calagator.org/events/1250466011 DESCRIPTION:Portland Postgres Users Group. See link for details.\n\nTags: postgresql\, postgres\, pdxpug\n\nImported from: http://calagator.org/e vents/1250466011 URL:http://pdxpug.wordpress.com SUMMARY:PDXPUG: April meeting LOCATION:Iovation: 111 SW 5th\, Portland Oregon 97204 US SEQUENCE:1 END:VEVENT BEGIN:VEVENT CREATED;VALUE=DATE-TIME:20140508T153849Z DTEND;TZID=America/Los_Angeles;VALUE=DATE-TIME:20140515T210000 DTSTART;TZID=America/Los_Angeles;VALUE=DATE-TIME:20140515T190000 DTSTAMP;VALUE=DATE-TIME:20140508T153849Z LAST-MODIFIED;VALUE=DATE-TIME:20140508T153849Z UID:http://calagator.org/events/1250466159 DESCRIPTION:Portland Postgres Users Group. See link for details.\n\nTags: postgresql\, postgres\, pdxpug\n\nImported from: http://calagator.org/e vents/1250466159 URL:http://pdxpug.wordpress.com SUMMARY:PDXPUG: May meeting LOCATION:Iovation: 111 SW 5th\, Portland Oregon 97204 US SEQUENCE:1 END:VEVENT BEGIN:VEVENT CREATED;VALUE=DATE-TIME:20140604T042702Z DTEND;TZID=America/Los_Angeles;VALUE=DATE-TIME:20140619T210000 DTSTART;TZID=America/Los_Angeles;VALUE=DATE-TIME:20140619T190000 DTSTAMP;VALUE=DATE-TIME:20140604T042702Z LAST-MODIFIED;VALUE=DATE-TIME:20140604T042702Z UID:http://calagator.org/events/1250466388 DESCRIPTION:Portland Postgres Users Group. See link for details.\n\nTags: postgresql\, postgres\, pdxpug\n\nImported from: http://calagator.org/e vents/1250466388 URL:http://pdxpug.wordpress.com SUMMARY:PDXPUG: June meeting LOCATION:Iovation: 111 SW 5th\, Portland Oregon 97204 US SEQUENCE:1 END:VEVENT BEGIN:VEVENT CREATED;VALUE=DATE-TIME:20140620T153034Z DTEND;TZID=America/Los_Angeles;VALUE=DATE-TIME:20140722T200000 DTSTART;TZID=America/Los_Angeles;VALUE=DATE-TIME:20140722T190000 DTSTAMP;VALUE=DATE-TIME:20140620T153034Z LAST-MODIFIED;VALUE=DATE-TIME:20140620T153146Z UID:http://calagator.org/events/1250466534 DESCRIPTION:Portland Postgres Users Group. See link for details. \;\n& #13\;\nNote that this is not our regular meeting time or place!\n\nTags: postgresql\, postgres\, pdxpug\n\nImported from: http://calagator.org/e vents/1250466534 URL:http://pdxpug.wordpress.com SUMMARY:PDXPUG: July meeting: OSCON BoF SEQUENCE:4 END:VEVENT BEGIN:VEVENT CREATED;VALUE=DATE-TIME:20140807T213051Z DTEND;TZID=America/Los_Angeles;VALUE=DATE-TIME:20140821T210000 DTSTART;TZID=America/Los_Angeles;VALUE=DATE-TIME:20140821T190000 DTSTAMP;VALUE=DATE-TIME:20140807T213051Z LAST-MODIFIED;VALUE=DATE-TIME:20140807T213051Z UID:http://calagator.org/events/1250466785 DESCRIPTION:Portland Postgres Users Group. See link for details.\n\nTags: postgresql\, postgres\, pdxpug\n\nImported from: http://calagator.org/e vents/1250466785 URL:http://pdxpug.wordpress.com SUMMARY:PDXPUG: August meeting SEQUENCE:2 END:VEVENT BEGIN:VEVENT CREATED;VALUE=DATE-TIME:20140906T013748Z DTEND;TZID=America/Los_Angeles;VALUE=DATE-TIME:20140918T210000 DTSTART;TZID=America/Los_Angeles;VALUE=DATE-TIME:20140918T190000 DTSTAMP;VALUE=DATE-TIME:20140906T013748Z LAST-MODIFIED;VALUE=DATE-TIME:20140906T013748Z UID:http://calagator.org/events/1250466941 DESCRIPTION:Portland Postgres Users Group. See link for details. \;\n& #13\;\nWhen: 7-9pm Thu Sep 18\, 2014 \;\nWhere: Iovation \;\nWho: Jay Riddle \;\nWhat: Using Postgresql to enable Google like Search 3\;\n \;\nJay’s been experimenting with Pg’s full text search capabil ities. At our next meeting\, he’ll cover the following: \;\n* Brief i ntro on why Google like search capabilities are fun. \;\n* Introduce Postgresql full text abilities. Discuss at a high level why a full text index may be a bit heavier than a normal index. \;\n* Look at possibl e solutions for use cases where the data you want to index is spread acr oss multiple columns and multiple tables. \;\n \;\nJay Riddle is a database administrator at Viewpoint software. \;\n \;\nOur meetin g will be held at Iovation\, on the 32nd floor of the US Bancorp Tower a t 111 SW 5th (5th &\; Oak). It’s right on the Green &\; Yellow Max lines. Underground bike parking is available in the parking garage\; ou tdoors all around the block in the usual spots. No bikes in the office\, sorry! \;\n \;\nElevators open at 6:45 and building security clos es access to the floor at 7:30. \;\n \;\nThe building is on the Gr een &\; Yellow Max lines. Underground bike parking is available in th e parking garage\; outdoors all around the block in the usual spots. \;\n \;\nSee you there!\n\nTags: postgresql\, postgres\, pdxpug\n\nIm ported from: http://calagator.org/events/1250466941 URL:http://pdxpug.wordpress.com SUMMARY:PDXPUG: September meeting LOCATION:Iovation: 111 SW 5th\, Portland Oregon 97204 US SEQUENCE:2 END:VEVENT BEGIN:VEVENT CREATED;VALUE=DATE-TIME:20140926T013020Z DTEND;TZID=America/Los_Angeles;VALUE=DATE-TIME:20141016T200000 DTSTART;TZID=America/Los_Angeles;VALUE=DATE-TIME:20141016T180000 DTSTAMP;VALUE=DATE-TIME:20140926T013020Z LAST-MODIFIED;VALUE=DATE-TIME:20140926T013020Z UID:http://calagator.org/events/1250467047 DESCRIPTION:What: PgOpen Recap (gabrielle\, Mark\, John M)\; New Relic I nstrumentation of Pg Queries (Andrew) \;\n \;\nPlease note the new earlier meeting time! We’ll try this over the winter. \;\n \;\nTw o topics this month: PgOpen attendees will discuss highlights of that c onference\, and Andrew will talk about some New Relic-y stuff. \;\n&# 13\;\nOur meeting will be held at Iovation\, on the 32nd floor of the US Bancorp Tower at 111 SW 5th (5th &\; Oak). It’s right on the Green &\; Yellow Max lines. Underground bike parking is available in the p arking garage\; outdoors all around the block in the usual spots. No b ikes in the office\, sorry! \;\n \;\nElevators open at 5:45 and bu ilding security closes access to the floor at 6:30.\n\nTags: postgresql\ , postgres\, pdxpug\n\nImported from: http://calagator.org/events/125046 7047 URL:http://pdxpug.wordpress.com SUMMARY:PDXPUG: October meeting LOCATION:Iovation: 111 SW 5th\, Portland Oregon 97204 US SEQUENCE:3 END:VEVENT BEGIN:VEVENT CREATED;VALUE=DATE-TIME:20141106T032655Z DTEND;TZID=America/Los_Angeles;VALUE=DATE-TIME:20141120T200000 DTSTART;TZID=America/Los_Angeles;VALUE=DATE-TIME:20141120T180000 DTSTAMP;VALUE=DATE-TIME:20141106T032655Z LAST-MODIFIED;VALUE=DATE-TIME:20141106T032655Z UID:http://calagator.org/events/1250467322 DESCRIPTION:See website for details.\n\nTags: postgresql\, postgres\, pdx pug\n\nImported from: http://calagator.org/events/1250467322 URL:http://pdxpug.wordpress.com SUMMARY:PDXPUG: November meeting LOCATION:Iovation: 111 SW 5th\, Portland Oregon 97204 US SEQUENCE:2 END:VEVENT BEGIN:VEVENT CREATED;VALUE=DATE-TIME:20141127T164405Z DTEND;TZID=America/Los_Angeles;VALUE=DATE-TIME:20141204T200000 DTSTART;TZID=America/Los_Angeles;VALUE=DATE-TIME:20141204T180000 DTSTAMP;VALUE=DATE-TIME:20141127T164405Z LAST-MODIFIED;VALUE=DATE-TIME:20141127T164405Z UID:http://calagator.org/events/1250467435 DESCRIPTION:See website for details.\n\nTags: postgresql\, postgres\, pdx pug\n\nImported from: http://calagator.org/events/1250467435 URL:http://pdxpug.wordpress.com/2014/11/27/pdxpug-december-lab-no-regular -december-meeting/ SUMMARY:PDXPUG: December lab night LOCATION:Renewable Funding: 400 SW 6th Avenue\, Suite 902\, Portland OR 9 7204 US SEQUENCE:2 END:VEVENT BEGIN:VEVENT CREATED;VALUE=DATE-TIME:20150107T152158Z DTEND;TZID=America/Los_Angeles;VALUE=DATE-TIME:20150115T200000 DTSTART;TZID=America/Los_Angeles;VALUE=DATE-TIME:20150115T180000 DTSTAMP;VALUE=DATE-TIME:20150107T152158Z LAST-MODIFIED;VALUE=DATE-TIME:20150107T152158Z UID:http://calagator.org/events/1250467594 DESCRIPTION:When: 6-8pm Thu Jan 15\, 2015 \;\nWhere: Iovation \;\nW ho: Gabrielle Roth \;\nWhat: RDS Postgres \;\n \;\nAmazon integ rated Postgres into their general Relational Database Services (RDS) off erings July 1\, 2014. RDS offers automatic failover\, scalability\, and easy configuration\, plus Amazon handles all the patching and upgrades f or you! Their SDK supports many languages and includes a robust CLI\, if you want to automate management of your deployments. They also support several popular Postgres extensions. \;\n \;\nOf course\, since it ’s a managed service\, you can’t do everything you might expect or want to. In this talk\, I’ll discuss the fun\, the quirky\, and the downright maddening features I’ve discovered working with production RDS deployme nts. Come find out what it’s like to use RDS Postgres day-to-day. \;\ n \;\nThe building is on the Green &\; Yellow Max lines. Undergrou nd bike parking is available in the parking garage\; outdoors all around the block in the usual spots. \;\n \;\nWe’ll go to Huber’s for af ter-meeting socializing. \;\n \;\nSee you there!\n\nTags: postgres ql\, postgres\, pdxpug\n\nImported from: http://calagator.org/events/125 0467594 URL:http://pdxpug.wordpress.com SUMMARY:PDXPUG: January meeting LOCATION:Iovation: 111 SW 5th\, Portland Oregon 97204 US SEQUENCE:2 END:VEVENT BEGIN:VEVENT CREATED;VALUE=DATE-TIME:20150203T041827Z DTEND;TZID=America/Los_Angeles;VALUE=DATE-TIME:20150219T200000 DTSTART;TZID=America/Los_Angeles;VALUE=DATE-TIME:20150219T180000 DTSTAMP;VALUE=DATE-TIME:20150203T041827Z LAST-MODIFIED;VALUE=DATE-TIME:20150203T041827Z UID:http://calagator.org/events/1250467769 DESCRIPTION:When: 6-8pm Thu Feb 19\, 2015 \;\nWhere: Iovation \ ;\nWho: David Kerr \;\nWhat: Using Bucardo to Migrate your Pg datab ase to RDS with minimal downtime \;\n \;\nAs a followup to January ’s RDS discussion\, Dave Kerr works through strategies to move your exis ting Postgres database into RDS. \;\n \;\nUsing Bucardo and Master /Master Replication we can achieve a migration to RDS with minimal or no downtime. \;\n \;\nDave will show some tools and techniques so he lp facilitate this transition as well as go over the idiosyncrasies of u sing Bucardo with RDS.\n\nTags: postgresql\, postgres\, pdxpug\n\nImport ed from: http://calagator.org/events/1250467769 URL:http://pdxpug.wordpress.com SUMMARY:PDXPUG: February meeting LOCATION:Iovation: 111 SW 5th\, Portland Oregon 97204 US SEQUENCE:4 END:VEVENT BEGIN:VEVENT CREATED;VALUE=DATE-TIME:20150311T024916Z DTEND;TZID=America/Los_Angeles;VALUE=DATE-TIME:20150319T200000 DTSTART;TZID=America/Los_Angeles;VALUE=DATE-TIME:20150319T180000 DTSTAMP;VALUE=DATE-TIME:20150311T024916Z LAST-MODIFIED;VALUE=DATE-TIME:20150311T024916Z UID:http://calagator.org/events/1250468039 DESCRIPTION:\n\nTags: postgresql\, postgres\, pdxpug\n\nImported from: ht tp://calagator.org/events/1250468039 URL:http://pdxpug.wordpress.com SUMMARY:PDXPUG: March meeting LOCATION:Iovation: 111 SW 5th\, Portland Oregon 97204 US SEQUENCE:1 END:VEVENT BEGIN:VEVENT CREATED;VALUE=DATE-TIME:20150410T004911Z DTEND;TZID=America/Los_Angeles;VALUE=DATE-TIME:20150416T200000 DTSTART;TZID=America/Los_Angeles;VALUE=DATE-TIME:20150416T180000 DTSTAMP;VALUE=DATE-TIME:20150410T004911Z LAST-MODIFIED;VALUE=DATE-TIME:20150410T004911Z UID:http://calagator.org/events/1250468207 DESCRIPTION:\n\nTags: postgresql\, postgres\, pdxpug\n\nImported from: ht tp://calagator.org/events/1250468207 URL:http://pdxpug.wordpress.com SUMMARY:PDXPUG: April meeting LOCATION:Iovation: 111 SW 5th\, Portland Oregon 97204 US SEQUENCE:2 END:VEVENT BEGIN:VEVENT CREATED;VALUE=DATE-TIME:20150502T020646Z DTEND;TZID=America/Los_Angeles;VALUE=DATE-TIME:20150521T200000 DTSTART;TZID=America/Los_Angeles;VALUE=DATE-TIME:20150521T180000 DTSTAMP;VALUE=DATE-TIME:20150502T020646Z LAST-MODIFIED;VALUE=DATE-TIME:20150502T020646Z UID:http://calagator.org/events/1250468356 DESCRIPTION:\n\nTags: postgresql\, postgres\, pdxpug\n\nImported from: ht tp://calagator.org/events/1250468356 URL:http://pdxpug.wordpress.com SUMMARY:PDXPUG: May meeting LOCATION:Iovation: 111 SW 5th\, Portland Oregon 97204 US SEQUENCE:1 END:VEVENT BEGIN:VEVENT CREATED;VALUE=DATE-TIME:20170220T213913Z DTEND;TZID=America/Los_Angeles;VALUE=DATE-TIME:20170221T200000 DTSTART;TZID=America/Los_Angeles;VALUE=DATE-TIME:20170221T183000 DTSTAMP;VALUE=DATE-TIME:20170220T213913Z LAST-MODIFIED;VALUE=DATE-TIME:20170220T213913Z UID:http://calagator.org/events/1250471494 DESCRIPTION:Gilt is an e-commerce fashion retailer. Gilt's application pl atform leverages popular programming languages such as Java\, Scala\, Ru by\, and JavaScript. \;\n \;\nThis talk will focus on data persis tence strategies in Gilt's core systems: order processing\, payment mana gement\, invoicing\, and checkout. We'll discuss the Event Sourcing patt ern and its implementation in a production system. \;\n \;\nSpeake r: \;\n \;\nSean Sullivan is a Principal Software Engineer at Gilt . Sean has been a member of Gilt's backoffice team since 2011. \;\n&# 13\;\nDoors open at 6pm for pizza provided by TEKSystems. The presentati on will begin at 6:30pm. \;\n \;\nslides: https://speakerdeck.com /sullis/e-commerce-under-the-hood \;\n \;\n\n\nTags: java\, ecomme rce\, scala\, postgres\, mongodb\, dynamodb\, aws\, gilt\, gilttech\n\nI mported from: http://calagator.org/events/1250471494 URL:https://www.meetup.com/PDXJUG/ SUMMARY:Portland Java User Group: E-commerce under the hood LOCATION:Oracle (Downtown Campus): 1211 SW 5th Avenue\, Suite 800\, Room 8005\, Portland Oregon 97204 US SEQUENCE:2 END:VEVENT BEGIN:VEVENT CREATED;VALUE=DATE-TIME:20180130T164631Z DTEND;TZID=America/Los_Angeles;VALUE=DATE-TIME:20180215T200000 DTSTART;TZID=America/Los_Angeles;VALUE=DATE-TIME:20180215T180000 DTSTAMP;VALUE=DATE-TIME:20180130T164631Z LAST-MODIFIED;VALUE=DATE-TIME:20180130T164631Z UID:http://calagator.org/events/1250473187 DESCRIPTION:Want automated high availability PostgreSQL *without* relying on someone else's cloud service? It's possible today\, and easier than you think\; we just need a little container orchestration pixiedust\, an d your DBAs can take the weekend off. \;\n \;\nJosh Berkus will ex plain the current state of HA Postgres services on Kubernetes/OpenShift\ , introducing the several projects in this area\, and then going into a deep dive on Patroni/Spilo. He'll bring you up to date on the new "\ ;Kube-native"\; Patroni\, and work expected in the future. With live demos! \;\n \;\n--------- \;\n \;\nJosh Berkus helps manage the Kubernetes community for Red Hat. He is a "\;hacker emeritus&qu ot\; for PostgreSQL. He lives in NE Portland with a large black cat\, a pottery studio\, and a librarian.\n\nTags: postgres\, postgresql\, OpenS hift\, kubernetes\, patroni\, spilo\n\nImported from: http://calagator.o rg/events/1250473187 URL:https://pdx.postgresql.us SUMMARY:PDXPUG: Automatic For The People LOCATION:Iovation: 111 SW 5th\, Portland Oregon 97204 US SEQUENCE:1 END:VEVENT BEGIN:VEVENT CREATED;VALUE=DATE-TIME:20180312T171454Z DTEND;TZID=America/Los_Angeles;VALUE=DATE-TIME:20180315T200000 DTSTART;TZID=America/Los_Angeles;VALUE=DATE-TIME:20180315T180000 DTSTAMP;VALUE=DATE-TIME:20180312T171454Z LAST-MODIFIED;VALUE=DATE-TIME:20180312T171454Z UID:http://calagator.org/events/1250473406 DESCRIPTION:Ahoy database folk! Time for another meetup and more contain er chit chat. Yeah yeah\, you\, like me\, have heard that you shouldn’t run databases in containers. Well without throwing all caution to the wind\, I’m hoping to show you guys some container workflows with Postgre s that I’ve been using lately. We’ll talk a bit about why you haven’t b een running databases in containers\, then walk through some development work flows with Postgres\, and lastly look at options for deploying and running persistent databases in containers. \;\n \;\n——— \;\n& #13\;\nHi\, its me Grant Holly. I work at Iovation on the data science and analytics team wrangling our data into visualizations and machine le arning models. I live in SE\, play in bands\, and am a learning machine .\n\nTags: postgres\, sql\, database\, docker\, container\n\nImported fr om: http://calagator.org/events/1250473406 URL:https://pdxpug.wordpress.com/ SUMMARY:PDX Postgres meetup LOCATION:Iovation: 111 SW 5th\, Portland Oregon 97204 US SEQUENCE:1 END:VEVENT BEGIN:VEVENT CREATED;VALUE=DATE-TIME:20180405T143332Z DTEND;TZID=America/Los_Angeles;VALUE=DATE-TIME:20180419T200000 DTSTART;TZID=America/Los_Angeles;VALUE=DATE-TIME:20180419T180000 DTSTAMP;VALUE=DATE-TIME:20180405T143332Z LAST-MODIFIED;VALUE=DATE-TIME:20180831T072303Z UID:http://calagator.org/events/1250473542 DESCRIPTION:Presented by: Dr. Kristin Tufte \;\n \;\nThis talk will describe work in Smart Cities in the Portland region. We’ll begin with the framework and motivation for the Smart Cities work and the question What is a Smart City? We’ll discuss Portland’s approach to Smart Cities\ , provide some historical context and then give an overview of ongoing S mart Cities projects including work on AV policy\, the Portland Urban Da ta Lake\, new sensors and earthquake resilience. The goal of the talk is to give the audience an overview of the work being done in Portland to bring a human face to data and technology and to inspire question and di scussion. \;\n \;\nDr. Tufte is actively involved in Portland’s Sm art Cities work and was the data lead on the City of Portland’s Smart Ci ties proposal. Dr. Tufte has collaborated closely with transportation ag encies in the Portland-Vancouver area for the past ten years and directs PORTAL — the regional transportation data archive. Dr. Tufte is a membe r of the Transportation Research Board’s Urban Data Committee\, co-chair ing its Urban Big Data subcommittee and Portland Global Cities Team Chal lenge Action Cluster. Dr. Tufte has a PhD in Database Management from th e University of Wisconsin - Madison. Dr. Tufte’s passion is using data a nd technology to change people’s lives\, especially those in traditional ly underserved communities.\n\nTags: postgresql\, postgres\, Data Lake\, smart cities\n\nImported from: http://calagator.org/events/1250473542 URL:https://pdx.postgresql.us/ SUMMARY:PDXPUG: PUDL: Portland Urban Data Lake LOCATION:Iovation: 111 SW 5th\, Portland Oregon 97204 US SEQUENCE:3 END:VEVENT BEGIN:VEVENT CREATED;VALUE=DATE-TIME:20180508T040408Z DTEND;TZID=America/Los_Angeles;VALUE=DATE-TIME:20180517T200000 DTSTART;TZID=America/Los_Angeles;VALUE=DATE-TIME:20180517T180000 DTSTAMP;VALUE=DATE-TIME:20180508T040408Z LAST-MODIFIED;VALUE=DATE-TIME:20180508T040408Z UID:http://calagator.org/events/1250473715 DESCRIPTION:\n\nTags: postgresql\, postgres\n\nImported from: http://cala gator.org/events/1250473715 URL:https://pdx.postgresql.us/ SUMMARY:PDXPUG May meeting LOCATION:Iovation: 111 SW 5th\, Portland Oregon 97204 US SEQUENCE:2 END:VEVENT BEGIN:VEVENT CREATED;VALUE=DATE-TIME:20180614T013909Z DTEND;TZID=America/Los_Angeles;VALUE=DATE-TIME:20180621T200000 DTSTART;TZID=America/Los_Angeles;VALUE=DATE-TIME:20180621T180000 DTSTAMP;VALUE=DATE-TIME:20180614T013909Z LAST-MODIFIED;VALUE=DATE-TIME:20180614T013909Z UID:http://calagator.org/events/1250473882 DESCRIPTION:\n\nTags: postgresql\, postgres\n\nImported from: http://cala gator.org/events/1250473882 URL:https://pdx.postgresql.us/ SUMMARY:PDXPUG June meeting LOCATION:Iovation: 111 SW 5th\, Portland Oregon 97204 US SEQUENCE:1 END:VEVENT BEGIN:VEVENT CREATED;VALUE=DATE-TIME:20180815T032857Z DTEND;TZID=America/Los_Angeles;VALUE=DATE-TIME:20180816T200000 DTSTART;TZID=America/Los_Angeles;VALUE=DATE-TIME:20180816T180000 DTSTAMP;VALUE=DATE-TIME:20180815T032857Z LAST-MODIFIED;VALUE=DATE-TIME:20180815T032857Z UID:http://calagator.org/events/1250474119 DESCRIPTION:Stored procedure support is coming to PostgreSQL 11. Come he ar about what a stored procedure is and how it differs from the existing user-defined functions.\n\nTags: postgres\, postgresql\, stored procedu res\n\nImported from: http://calagator.org/events/1250474119 URL:https://pdx.postgresql.us/ SUMMARY:PDXPUG: Sneak peek at stored procedures LOCATION:Iovation: 111 SW 5th\, Portland Oregon 97204 US SEQUENCE:1 END:VEVENT BEGIN:VEVENT CREATED;VALUE=DATE-TIME:20180402T005516Z DTEND;TZID=America/Los_Angeles;VALUE=DATE-TIME:20180910T180000 DTSTART;TZID=America/Los_Angeles;VALUE=DATE-TIME:20180910T090000 DTSTAMP;VALUE=DATE-TIME:20180402T005516Z LAST-MODIFIED;VALUE=DATE-TIME:20180402T005516Z UID:http://calagator.org/events/1250473528 DESCRIPTION:The Portland PostgreSQL Users Group (PDXPUG)\, Portland State University Maseeh College of Engineering and Computer Science\, and Dat alab\, the PSU Data and Information Management Laboratory and is proud to present a day of presentations about PostgreSQL\, an open source rela tional database management system. \;\n\n\nTags: postgresql\, postgre s\n\nImported from: http://calagator.org/events/1250473528 URL:https://pdx.postgresql.us/pdxpgday2018 SUMMARY:Portland PostgreSQL Day (PDXPUG PGDay) 2018 LOCATION:Portland State University Engineering Building: 1930 SW 4th Ave\ , Portland Oregon 97201 US SEQUENCE:1 END:VEVENT BEGIN:VEVENT CREATED;VALUE=DATE-TIME:20190105T021558Z DTEND;TZID=America/Los_Angeles;VALUE=DATE-TIME:20190124T200000 DTSTART;TZID=America/Los_Angeles;VALUE=DATE-TIME:20190124T180000 DTSTAMP;VALUE=DATE-TIME:20190105T021558Z LAST-MODIFIED;VALUE=DATE-TIME:20190105T021558Z UID:http://calagator.org/events/1250474769 DESCRIPTION:Note new location and we are meeting the 4th Thursday this mo nth! \;\n \;\npdxpug.wordpress.com \;\n \;\nBDR (bi-directio nal replication) enables asynchronous multi-master replication in Postgr es as an extension and has been in full production status since 2014. We will discuss the use cases that BDR is most appropriate for\, and where is might not be best suited. \;\n \;\nMark works at 2ndQuadrant a s a consultant for English Speaking Territories\, based out of Oregon. H e is a Contributor to PostgreSQL\, co-organizer of the Portland PostgreS QL User Group\, and serves as a Director and Treasurer for the United St ates PostgreSQL Association.\n\nTags: pdxpug\, postgres\, postgresql\, b dr\, replication\, multi-master\n\nImported from: http://calagator.org/e vents/1250474769 URL:https://pdx.postgresql.us SUMMARY:PDXPUG: Bi-Directional Replication for Postgres LOCATION:New Relic: 111 SW 5th Avenue\, Suite 2700\, Portland Oregon 9720 4 United States SEQUENCE:1 END:VEVENT BEGIN:VEVENT CREATED;VALUE=DATE-TIME:20190206T194854Z DTEND;TZID=America/Los_Angeles;VALUE=DATE-TIME:20190221T200000 DTSTART;TZID=America/Los_Angeles;VALUE=DATE-TIME:20190221T180000 DTSTAMP;VALUE=DATE-TIME:20190206T194854Z LAST-MODIFIED;VALUE=DATE-TIME:20190206T194854Z UID:http://calagator.org/events/1250475002 DESCRIPTION:Temporal databases let you record history: either a history o f the database (what the table used to say)\, a history of the thing its elf (what it used to be)\, or both at once. The theory of temporal datab ases goes back to the 90s\, but standardization has only just begun with some modest recommendations in SQL:2011\, and database products (includ ing Postgres) are still missing major functionality. \;\n \;\nThis talk will cover how temporal tables are structured\, how they are queri ed and updated\, what SQL:2011 offers (and doesn't)\, what functionality Postgres has already\, and what remains to be built. \;\n \;\nPau l started programming on a Tandy 1000 at age 8 and hasn't been able to s top since. He helped build one of the Mac's first web servers in 1994 an d has founded software companies in politics and technical hiring. He wo rks as an independent consultant specializing in Rails\, Postgres\, and Chef.\n\nTags: postgres\, postgresql\, pdxpug\, temporal\n\nImported fro m: http://calagator.org/events/1250475002 URL:https://pdx.postgresql.us/ SUMMARY:PDXPUG: Temporal Databases: Theory and Postgres LOCATION:PSU Business Accelerator: 2828 SW Corbett Ave\, Portland OR 9720 1 US SEQUENCE:1 END:VEVENT BEGIN:VEVENT CREATED;VALUE=DATE-TIME:20190306T141445Z DTEND;TZID=America/Los_Angeles;VALUE=DATE-TIME:20190321T200000 DTSTART;TZID=America/Los_Angeles;VALUE=DATE-TIME:20190321T180000 DTSTAMP;VALUE=DATE-TIME:20190306T141445Z LAST-MODIFIED;VALUE=DATE-TIME:20190306T141445Z UID:http://calagator.org/events/1250475200 DESCRIPTION:Speaker: Hannah Stepanek \;\n \;\nLet’s talk databases in python! What’s an ORM? Is there a way to write database queries so th at they are compatible with multiple types of databases? How do you make database changes (such as adding a new table or a new column) safely? W hat is a connection pool and why is it useful? What are some things that can go wrong when operating at scale? In this talk we’ll take a deep di ve into how the python libraries sqlalchemy and alembic make managing pr oduction databases simple\, efficient\, and painless so you can get back to feature development. \;\n \;\nHannah has been working in indus try for over 6 years as a python software engineer. She currently works at Hypothesis\, a web application for annotating web pages and pdfs. In her spare time she enjoys riding her horse Sophie and playing board game s.\n\nTags: pdxpug\, postgres\, postgresql\, python\, orm\n\nImported fr om: http://calagator.org/events/1250475200 URL:https://pdx.postgresql.us SUMMARY:PDXPUG: March Meetup: Let’s talk databases in python! LOCATION:PDX Code Guild: 2828 SW Corbett Ave #208\, Portland OR 97201 Uni ted States SEQUENCE:1 END:VEVENT BEGIN:VEVENT CREATED;VALUE=DATE-TIME:20190410T171745Z DTEND;TZID=America/Los_Angeles;VALUE=DATE-TIME:20190418T200000 DTSTART;TZID=America/Los_Angeles;VALUE=DATE-TIME:20190418T180000 DTSTAMP;VALUE=DATE-TIME:20190410T171745Z LAST-MODIFIED;VALUE=DATE-TIME:20190410T171745Z UID:http://calagator.org/events/1250475419 DESCRIPTION:Speaker: Grant Holly \;\n \;\nThis month I will be demo nstrating using non-blocking IO database access using Scala and the Slic k library. No really\, the library is called Slick AND it is very cool to use. Slick and Scala are great for working with Postgres with either straight SQL\, or using the FRM (that’s a Functional Relation Mapper li ke in functional programming). After Hannah gave a great talk talk abou t Python\, Postgres\, and ORMs\, I got to thinking that I could do a lan guage and ORM talk. Thanks Hannah\, that was great. \;\n \;\nhttp s://github.com/grantholly/pdx_pug_scala_and_pg \;\n \;\nHi\, it’s me still Grant. I work at New Relic as an engineer on the database engi neering team. I’ve been using Postgres in production since 9.2 and have been using and enjoying Scala for about two years having worked on a co uple of production high throughput applications.\n\nTags: pdxpug\, postg res\, postgresql\, scala\n\nImported from: http://calagator.org/events/1 250475419 URL:https://pdx.postgresql.us SUMMARY:PDXPUG: Postgres with non-blocking IO and Scala LOCATION:PSU Business Accelerator: 2828 SW Corbett Ave\, Portland OR 9720 1 US SEQUENCE:1 END:VEVENT BEGIN:VEVENT CREATED;VALUE=DATE-TIME:20190514T221434Z DTEND;VALUE=DATE:20190518 DTSTART;VALUE=DATE:20190516 DTSTAMP;VALUE=DATE-TIME:20190514T221434Z LAST-MODIFIED;VALUE=DATE-TIME:20190514T221434Z UID:http://calagator.org/events/1250475606 DESCRIPTION:This event runs from Thursday\, May 16\, 2019 at 6pm through Friday\, May 17\, 2019 at 8pm.\n\nDescription:\nLearn about the consider ations in planning for disaster recovery in order to maintain business c ontinuity. There are solutions available that can help you achieve your backup and recovery objectives by taking advantage of PostgreSQL feature s\, such as point-in-time recovery\, and help implement retention polici es. \;\n \;\nAlso learn how to take advantage of PostgreSQL’s repl ication features to keep your database highly-available\, and the basic cluster architectures to consider to keep a PostgreSQL cluster up and ru nning. \;\n \;\nMark works at 2ndQuadrant as a consultant for Engl ish Speaking Territories\, based out of Oregon. He is a Contributor to P ostgreSQL\, co-organizer of the Portland PostgreSQL User Group\, and ser ves as a Director and Treasurer for the United States PostgreSQL Associa tion.\n\nTags: pdxpug\, postgres\, postgresql\n\nImported from: http://c alagator.org/events/1250475606 URL:https://pdx.postgresql.us SUMMARY:PDXPUG: Disaster Recovery and High Availability Planning LOCATION:PSU Business Accelerator: 2828 SW Corbett Ave\, Portland OR 9720 1 US SEQUENCE:1 END:VEVENT BEGIN:VEVENT CREATED;VALUE=DATE-TIME:20190605T160755Z DTEND;TZID=America/Los_Angeles;VALUE=DATE-TIME:20190620T200000 DTSTART;TZID=America/Los_Angeles;VALUE=DATE-TIME:20190620T180000 DTSTAMP;VALUE=DATE-TIME:20190605T160755Z LAST-MODIFIED;VALUE=DATE-TIME:20190605T160755Z UID:http://calagator.org/events/1250475705 DESCRIPTION:Speaker: Will McLean \;\n \;\nTo follow the presentatio ns on accessing Postgres from Python and Scala\, I will lead a discussio n on accessing Postgres with Java. I'll start with a jdbc tutorial and f inish with adding data access to a springboot webapp. \;\n \;\nI h ave twenty years experience in e-commerce applications\, the last eight here in Portland\, mostly at Nike.For the last few years everything has been moving to Amazon RDS Postgres\, that's a trend pdxpug can get behin d! \;\nI am currently working for Navis on CRM applications for the h ospitality industry.\n\nTags: pdxpug\, postgres\, postgresql\, java\, cr m\, springbot\n\nImported from: http://calagator.org/events/1250475705 URL:https://pdx.postgresql.us SUMMARY:PDXPUG Meetup: Accessing Postgres with Java LOCATION:PSU Business Accelerator: 2828 SW Corbett Ave\, Portland OR 9720 1 US SEQUENCE:1 END:VEVENT BEGIN:VEVENT CREATED;VALUE=DATE-TIME:20190806T044445Z DTEND;TZID=America/Los_Angeles;VALUE=DATE-TIME:20190815T200000 DTSTART;TZID=America/Los_Angeles;VALUE=DATE-TIME:20190815T180000 DTSTAMP;VALUE=DATE-TIME:20190806T044445Z LAST-MODIFIED;VALUE=DATE-TIME:20190806T044445Z UID:http://calagator.org/events/1250475956 DESCRIPTION:Jackson will discuss the basics of GIS\, and the current envi ronment in which enterprise spatial analytics are performed. Considering the many pitfalls of this current system\, he will discuss how FOSS too ls – especially PostgreSQL/PostGIS – are vitally important for modern sp atial analytics. In addition to the PostGIS extension\, Jackson will tal k about network routing using the PgRouting extension and the interface between R and PostgreSQL. This talk will act more as a showcase of GIS a nd “spatial SQL” within PostgreSQL than it will nitty-gritty database de velopment. \;\n \;\nJackson Voelkel is a Health Data Analyst on Ka iser Permanente’s GIS Team as well as an Adjunct Professor of Geography at Portland State University. He focuses on developing infrastructure fo r and performing advanced spatial analytics across healthcare\, environm ent\, urban planning\, utilities\, and econometrics. He teaches courses on advanced spatial analytics in R as well as spatial database design wi th PostgreSQL/PostGIS.\n\nTags: pdxpug\, postgres\, postgresql\, gis\, p ostgis\n\nImported from: http://calagator.org/events/1250475956 URL:https://pdx.postgresql.us SUMMARY:PDXPUG August Meetup: PostGIS LOCATION:PSU Business Accelerator: 2828 SW Corbett Ave\, Portland OR 9720 1 US SEQUENCE:2 END:VEVENT BEGIN:VEVENT CREATED;VALUE=DATE-TIME:20190917T032340Z DTEND;TZID=America/Los_Angeles;VALUE=DATE-TIME:20190919T200000 DTSTART;TZID=America/Los_Angeles;VALUE=DATE-TIME:20190919T180000 DTSTAMP;VALUE=DATE-TIME:20190917T032340Z LAST-MODIFIED;VALUE=DATE-TIME:20190917T032340Z UID:http://calagator.org/events/1250476209 DESCRIPTION:This month I am going to be talking about my current work on sharding large mysql databases with Vitess. My team has been on a journ ey towards splitting our largest mysql databases and I want to share my experiences and lessons learned. We are going to look at the problems a nd possible solutions to scaling reads and writes in relational database s. \;\n \;\nVitess is an open source project born at youtube to sc ale their largest and most critical databases. It has been adopted in a s a Cloud Native Compute Foundation incubator project. With PostgreSQL on the medium-term road map\, let’s take a look at what we have been abl e to do with mysql. \;\n \;\nHi its me Grant. I work on the datab ase engineering team at New Relic. I’ve been using Postgres in producti on since 9.2. I co-organize the Postgres user group in Portland with Ma rk Wong.\n\nTags: pdxpug\, postgres\, postgresql\, mysql\, vitess\n\nImp orted from: http://calagator.org/events/1250476209 URL:https://pdx.postgresql.us SUMMARY:PDXPUG: Sharding large MySQL databases with Vitess LOCATION:PSU Business Accelerator: 2828 SW Corbett Ave\, Portland OR 9720 1 US SEQUENCE:1 END:VEVENT BEGIN:VEVENT CREATED;VALUE=DATE-TIME:20191009T160136Z DTEND;TZID=America/Los_Angeles;VALUE=DATE-TIME:20191017T200000 DTSTART;TZID=America/Los_Angeles;VALUE=DATE-TIME:20191017T180000 DTSTAMP;VALUE=DATE-TIME:20191009T160136Z LAST-MODIFIED;VALUE=DATE-TIME:20191009T160136Z UID:http://calagator.org/events/1250476315 DESCRIPTION:pg_top was born in 2007 from a fork of the unixtop\, a termin al program displaying top processes on the system\, where pg_top focuses on the processes with the PostgreSQL database you are connected to. Rec ently pg_systat was forked from systat to display additional database st atistics. \;\n \;\nThese tools have can help do more such as explo re query execution plans and create reports from system and database res ources. \;\n \;\nCome learn about the statistics PostgreSQL keeps and how to use these tools to view them. \;\n \;\nMark leads the 2 ndQuadrant performance practice as a Performance Consultant for English Speaking Territories\, based out of Oregon in the USA. He is a long time Contributor to PostgreSQL\, co-organizer of the Portland PostgreSQL Use r Group\, and serves as a Director and Treasurer for the United States P ostgreSQL Association.\n\nTags: postgres\, postgresql\, pdxpug\, pg_top\ , pg_systat\, pg_proctab\n\nImported from: http://calagator.org/events/1 250476315 URL:https://pdx.postgresql.us SUMMARY:PDXPUG October Meetup: Terminal Tools & Database Statistics LOCATION:PSU Business Accelerator: 2828 SW Corbett Ave\, Portland OR 9720 1 US SEQUENCE:1 END:VEVENT BEGIN:VEVENT CREATED;VALUE=DATE-TIME:20200115T180802Z DTEND;TZID=America/Los_Angeles;VALUE=DATE-TIME:20200116T200000 DTSTART;TZID=America/Los_Angeles;VALUE=DATE-TIME:20200116T180000 DTSTAMP;VALUE=DATE-TIME:20200115T180802Z LAST-MODIFIED;VALUE=DATE-TIME:20200115T180802Z UID:http://calagator.org/events/1250476695 DESCRIPTION:Speaker: Alex Theodore \;\n \;\nAs a CTO I saw everythi ng that went into and came out of the web development process\, from the "\;client needs"\; to the source-controlled code. But being ski lled in database development showed me time and time again that database s (and their architecture) were often sidelined treated as after-thought s and often times served as little more than flexible storage spaces. Ye t\, their contents were the very essence of value for the process/client /company being served. This strange inversion of priorities led me to de velop a way of looking at databases as "\;outside"\; the applica tion and ultimately to interacting with them as API's. In my talk I'll b e presenting this concept and showing with simple rules and examples how it can be done. \;\n \;\nBio: \;\n \;\nI was the product an d technology founder of Fracture.me and CTO up until 2018 where I develo ped the manufacturing processes and ERP software that powered our produc tion process. That got me deeply involved in database work\, especially with architecture and process design and optimization. Now I work part t ime as a database consultant and part time building modern\, minimalisti c furniture for my new (small) company MillFinish.com. \;\n \;\n\n \nTags: pdxpug\, postgres\, postgresql\n\nImported from: http://calagato r.org/events/1250476695 URL:https://pdx.postgresql.us SUMMARY:PDXPUG: Interacting with databases as API's LOCATION:Portland State Business Accelerator: 2828 SW Corbett Ave.\, Port land OR 97201 us SEQUENCE:1 END:VEVENT BEGIN:VEVENT CREATED;VALUE=DATE-TIME:20200206T164845Z DTEND;TZID=America/Los_Angeles;VALUE=DATE-TIME:20200220T200000 DTSTART;TZID=America/Los_Angeles;VALUE=DATE-TIME:20200220T180000 DTSTAMP;VALUE=DATE-TIME:20200206T164845Z LAST-MODIFIED;VALUE=DATE-TIME:20200206T164845Z UID:http://calagator.org/events/1250476774 DESCRIPTION:Speakers: Gabrielle Roth &\; Michelle Franz \;\n \;\ nIn February\, long-term PDXPUGers Michelle Franz &\; Gabrielle Roth return to discuss DBLINK and FDW\, two methods of accessing data that’s outside your database. We’ll briefly mention SQL/MED on the way\, and te ll a couple of bad (Dad) jokes. \;\n \;\nWe’ll cover use (and mis- use) cases\, configuration of each\, and interesting quirks. Gabrielle w ill attempt a live demo of file_fdw and postgres_fdw. You’re welcome to follow along if you’d like\, just show up with a couple of Pg databases: they can be on the same cluster (or container or RDS instance or what h ave you) or different ones\, doesn’t really matter. One of them should h ave at least one table with data in it. \;\n \;\nAbout the speaker s: \;\n \;\nFrom embedded systems to UI to relational database pro gramming\, Michelle’s running an interesting path through the software w orld. Working with databases is her current episode\, with some programm ing\, some DBA\, some SysAdmin and a healthy dose of learning agile. She ’s very quickly come to appreciate and enjoy working with Postgres and h er work has allowed her to learn from some super talented database exper ts. \;\n \;\nGabrielle has been using Postgres since sometime in t he version 7s\, and thinks that the best part of using Open Source softw are is the culture of sharing knowledge. She’s a Senior Data Engineer at NS1 and co-founder and former co-lead of PDXPUG.\n\nTags: postgres\, po stgresql\, pdxpug\, dblink\, fdw\, sql\n\nImported from: http://calagato r.org/events/1250476774 URL:https://pdx.postgresql.us/ SUMMARY:PDXPUG February 2020 Meetup: DBlink and SQL/MED and FDW\, oh my! External Data Access tricks LOCATION:PSU Business Accelerator: 2828 SW Corbett Ave\, Portland OR 9720 1 US SEQUENCE:1 END:VEVENT BEGIN:VEVENT CREATED;VALUE=DATE-TIME:20200415T154356Z DTEND;TZID=America/Los_Angeles;VALUE=DATE-TIME:20200423T203000 DTSTART;TZID=America/Los_Angeles;VALUE=DATE-TIME:20200423T183000 DTSTAMP;VALUE=DATE-TIME:20200415T154356Z LAST-MODIFIED;VALUE=DATE-TIME:20200415T154356Z UID:http://calagator.org/events/1250476979 DESCRIPTION:We are using Meetup.com to distribute the link to the online meeting [1]\, which will be set shortly before the meeting as we will be using Jitsi [2]. Meetup does require you to RSVP to get access to the link. Jitsi can be used directly with Firefox and Chrome (with extension )\, or phones/tablets with the Jitsi Meet app. \;\n \;\nSpeaker: P aul Jungwirth \;\n \;\nI'd like to present a couple patches I have in-progress for Postgres\, the first to add a new type called "\;mu ltiranges"\;\, and the second to add various SQL:2011 temporal datab ase features: temporal primary &\; foreign keys\, and temporal UPDATE and DELETE. I'll discuss what these features look like to users and als o highlight some of the implementation details behind them. \;\n \ ;\n[1] https://www.meetup.com/pdxpug/events/270062132/ \;\n[2] https: //jitsi.org \;\n\n\nTags: pdxpug\, postgres\, postgresql\, multirange s\, temporal\, datatypes\n\nImported from: http://calagator.org/events/1 250476979 URL:https://www.meetup.com/pdxpug/events/270062132/ SUMMARY:PDXPUG: Multiranges and SQL:2011 Temporal Features LOCATION:Online: placeholder for on-line events\, SEQUENCE:1 END:VEVENT BEGIN:VEVENT CREATED;VALUE=DATE-TIME:20221215T205235Z DTEND;TZID=America/Los_Angeles;VALUE=DATE-TIME:20230119T203000 DTSTART;TZID=America/Los_Angeles;VALUE=DATE-TIME:20230119T183000 DTSTAMP;VALUE=DATE-TIME:20221215T205235Z LAST-MODIFIED;VALUE=DATE-TIME:20221215T205235Z UID:http://calagator.org/events/1250480086 DESCRIPTION:PostgreSQL 15 was released on October 13\, 2022 so let's give it a look! \;\n \;\nWe will shamelessly use a presentation readil y available on the internet to see all the newness in this latest releas e. \;\n \;\nCome learn what's new\, share experiences with changes \, or just meet with local peers! Casual\, informal.\n\nTags: postgres\, postgresql\, databases\n\nImported from: http://calagator.org/events/12 50480086 URL:https://www.meetup.com/pdxpug/events/290336190/ SUMMARY:PDXPUG: What's new in PostgreSQL 15 (Note last minute venue chang e.) LOCATION:PDX Code Guild: 407 NE 12th Avenue\, Portland OR 97232 USA SEQUENCE:2 END:VEVENT BEGIN:VEVENT CREATED;VALUE=DATE-TIME:20230514T005531Z DTEND;TZID=America/Los_Angeles;VALUE=DATE-TIME:20230518T203000 DTSTART;TZID=America/Los_Angeles;VALUE=DATE-TIME:20230518T183000 DTSTAMP;VALUE=DATE-TIME:20230514T005531Z LAST-MODIFIED;VALUE=DATE-TIME:20230514T005531Z UID:http://calagator.org/events/1250480524 DESCRIPTION:Getting started with Django is a delight. However\, as your a pplication grows\, that sqlite database you start with can become a limi tation. We are going to look at how to wire up a new Django project to P ostgres\, and we will talk about some of the neat features in Postgres a nd Django that you can utilize including JSON\, UDFs/procs\, and extensi ons to name a few. \;\n \;\nHopefully you can pick a few ideas\, o r even share your own with the group. This talk is for all levels of exp erience from “I just heard about Django” to “We run production Django”\, from “oh Postgres\, that’s the elephant one right?” to “Ask me anything about Postgres”. \;\n \;\nWe will also have zoom link available c loser to the presentation date if you want to attend remotely. Sign up on MeetUp for this notification: https://www.meetup.com/pdxpug/events/29 3519969/\n\nTags: postgres\, postgresql\, django\, python\n\nImported fr om: http://calagator.org/events/1250480524 URL:https://www.meetup.com/pdxpug/events/293519969/ SUMMARY:PDXPUG MeetUp: Django and Postgres LOCATION:PDX Code Guild: 407 NE 12th Avenue\, Portland OR 97232 USA SEQUENCE:1 END:VEVENT BEGIN:VEVENT CREATED;VALUE=DATE-TIME:20230517T222306Z DTEND;TZID=America/Los_Angeles;VALUE=DATE-TIME:20230615T203000 DTSTART;TZID=America/Los_Angeles;VALUE=DATE-TIME:20230615T183000 DTSTAMP;VALUE=DATE-TIME:20230517T222306Z LAST-MODIFIED;VALUE=DATE-TIME:20230517T222306Z UID:http://calagator.org/events/1250480527 DESCRIPTION:Few abstractions and tools have proved as enduring in the fie ld of Computer Science as the relational database model. Due to the dili gent efforts of the Postgres team\, the Postgres project has an ever inc reasing popularity in the software world and a fully modernized feature set. One effect of the longevity of the project has been to create a dee p pool of received wisdom regarding the use and misuse of Data Models an d SQL. Revisit some of the wisdom from a classic of the genre: SQL Antip atterns: Avoiding the Pitfalls of Database Programming by Bill Karwin\, with updated opinions and commentary to modernize the material. Stay aft er for pizza and a rousing exchange of ideas on the past\, present\, and future of SQL and of the Postgres project. \;\n \;\nSpeaker: Jose ph Hammerman \;\n \;\nJoseph Hammerman is a Linux Systems Administ rator and Database Reliability Engineer with 18 years of experience. For the last 10 years that work has focused on Postgresql database reliabil ity and High Availability engineering practices. Some career highlights include: serving on the iHeartRadio launch team\, working at SecondMarke t prior to and during their acquisition by NASDAQ Private Markets\, and founding and serving on the Squarespace Database Reliability Engineering team. He is currently employed as Technical Lead for the DataDog Postgr esql database reliability engineering team. He is a passionate advocate of Free and Open Source software and the ideals that it embodies.\n\nTag s: postgres\, postgresql\, sql\, antipatterns\n\nImported from: http://c alagator.org/events/1250480527 URL:https://www.meetup.com/pdxpug/events/293599321/ SUMMARY:PDXPUG: SQL Antipatterns LOCATION:PDX Code Guild: 2828 SW Corbett Ave\, Portland OR 97201 us SEQUENCE:1 END:VEVENT BEGIN:VEVENT CREATED;VALUE=DATE-TIME:20230804T005513Z DTEND;TZID=America/Los_Angeles;VALUE=DATE-TIME:20230817T083000 DTSTART;TZID=America/Los_Angeles;VALUE=DATE-TIME:20230817T063000 DTSTAMP;VALUE=DATE-TIME:20230804T005513Z LAST-MODIFIED;VALUE=DATE-TIME:20230817T231158Z UID:http://calagator.org/events/1250480640 DESCRIPTION:Speaker: Jerry Sievert \;\n \;\nExtensions are part of what makes Postgres such a powerful and popular database. Being able to add new capabilities to your database allows developers to adapt Postgre s to many different use cases from geospatial (PostGIS)\, to multi-serve r sharding (Citus)\, to custom datatypes (pg_semver)\, to foreign data w rappers (postgres_fdw)\, and others. \;\n \;\nJerry is going to wa lk us through getting started working on database extensions. We will co ver how extensions work and getting started authoring your very own firs t database extension! Time permitting\, and with interest\, we will cove r operators and types. This talk is intended for all developers and DBA’ s alike\, so bring your questions. If you have a favorite extension\, we want to know\, so bring it to the discussion. I’ll go first: favorite e xtension: most flavors of FDW’s for sure. \;\n \;\nNow a bit about Jerry. He’s currently working at Hydra (https://hydra.so/) on data ware housing with Postgres\, but has been using Postgres for waaaay too long. If you’ve ever used PLJS (https://github.com/plv8/pljs)\, he’s the auth or\, and he is the maintainer of PLV8 (https://plv8.github.io/).\n\nTags : postgres\, postgresql\n\nImported from: http://calagator.org/events/12 50480640 URL:https://www.meetup.com/pdxpug/events/295229582/ SUMMARY:PDXPUG: Developing Your Own Database Extensions LOCATION:WeWork: 830 NE Holldaday St\, Portland Oregon 97232 USA SEQUENCE:3 END:VEVENT BEGIN:VEVENT CREATED;VALUE=DATE-TIME:20231020T233446Z DTEND;TZID=America/Los_Angeles;VALUE=DATE-TIME:20231102T203000 DTSTART;TZID=America/Los_Angeles;VALUE=DATE-TIME:20231102T183000 DTSTAMP;VALUE=DATE-TIME:20231020T233446Z LAST-MODIFIED;VALUE=DATE-TIME:20231020T233446Z UID:http://calagator.org/events/1250480741 DESCRIPTION:PostgreSQL 16 was released on September 14\, 2023 so let's gi ve it a look! \;\n \;\nWe will shamelessly use a presentation read ily available on the internet to see all the newness in this latest rele ase. \;\n \;\nCome learn what's new\, share experiences with chang es\, or just meet with local peers! Casual\, informal. \;\n \;\nNo te that this will be the last PDXPUG meeting of the year until 2024.\n\n Tags: postgres\, postgresql\, pgsql\n\nImported from: http://calagator.o rg/events/1250480741 URL:https://www.meetup.com/pdxpug/events/296865128/ SUMMARY:PDXPUG: What's new in PostgreSQL 16 LOCATION:American Red Cross: 3131 N Vancouver Ave\, Portland OR 97227 USA SEQUENCE:1 END:VEVENT BEGIN:VEVENT CREATED;VALUE=DATE-TIME:20240214T021517Z DTEND;TZID=America/Los_Angeles;VALUE=DATE-TIME:20240215T203000 DTSTART;TZID=America/Los_Angeles;VALUE=DATE-TIME:20240215T183000 DTSTAMP;VALUE=DATE-TIME:20240214T021517Z LAST-MODIFIED;VALUE=DATE-TIME:20240214T021517Z UID:http://calagator.org/events/1250480973 DESCRIPTION:Speaker: Grant Holly \;\n \;\nMoving a live production dataset between servers is hard to do. I’m going to share a few examples of how I’ve been able to move data and workloads between servers withou t downtime\, dropped writes\, or stale reads. I had to break out more th an a few Postgres tricks like logical replication\, foreign data wrapper s\, and writable views\, all of which we will be reviewing. \;\n \ ;\nMy goal is to share a few strategies that have worked and how they ha ndle the common difficulties with moving live datasets. Please bring you r own stories and questions and add to the conversation.\n\nTags: postgr es\, postgresql\n\nImported from: http://calagator.org/events/1250480973 URL:https://www.meetup.com/pdxpug/events/299185648/ SUMMARY:PDXPUG: Zero Downtime: Live Data and Server Migrations LOCATION:American Red Cross: 3131 N Vancouver Ave\, Portland OR 97227 USA SEQUENCE:1 END:VEVENT BEGIN:VEVENT CREATED;VALUE=DATE-TIME:20240329T184614Z DTEND;TZID=America/Los_Angeles;VALUE=DATE-TIME:20240418T203000 DTSTART;TZID=America/Los_Angeles;VALUE=DATE-TIME:20240418T183000 DTSTAMP;VALUE=DATE-TIME:20240329T184614Z LAST-MODIFIED;VALUE=DATE-TIME:20240329T184614Z UID:http://calagator.org/events/1250481024 DESCRIPTION:PostgreSQL 17 is in feature freeze. The expected release date is sometime this September. \;\n \;\nWe will review freely availa ble presentations available on the internet to see what we can can expec t in the next major release. \;\n \;\nCome learn what's new\, shar e experiences with changes\, or just meet with local peers! Casual\, inf ormal. \;\n \;\nPlease RSVP in the MeetUp link to help us gauge ex pected attendance. https://www.meetup.com/pdxpug/events/300096141/\n\nTa gs: postgres\, postgresql\n\nImported from: http://calagator.org/events/ 1250481024 URL:https://www.meetup.com/pdxpug/events/300096141/ SUMMARY:PDXPUG: What's coming up in PostgreSQL 17 LOCATION:American Red Cross: 3131 N Vancouver Ave\, Portland OR 97227 USA SEQUENCE:2 END:VEVENT BEGIN:VEVENT CREATED;VALUE=DATE-TIME:20240814T230142Z DTEND;TZID=America/Los_Angeles;VALUE=DATE-TIME:20240822T203000 DTSTART;TZID=America/Los_Angeles;VALUE=DATE-TIME:20240822T183000 DTSTAMP;VALUE=DATE-TIME:20240814T230142Z LAST-MODIFIED;VALUE=DATE-TIME:20240814T230142Z UID:http://calagator.org/events/1250481254 DESCRIPTION:Speaker: Paul Jungwirth \;\n \;\nBenchmarking is an imp ortant part of developing database systems like Postgres. For businesses \, benchmarking can guide important decisions around selecting a databas e management system\, or evaluate configuration changes. However\, while there are many standard benchmarks out there\, setting up\, configuring \, running\, and collecting results was left as an exercise to the reade r. \;\n \;\nBenchbase is an open-source benchmarking framework fro m Carnegie Melon University’s Database Group (https://github.com/cmu-db/ benchbase). It helps you configure\, run\, and collect results from vari ous standard benchmarks. It also provides a framework for authoring your own performance benchmarks\, and wiring it up to the batteries-included configuration\, running\, and results collection provided by it. \;\ n \;\nPaul is going to walk us through Benchbase\, and some recent wo rk he has embarked on around creating a benchmark. If you are a veteran of benchmarking\, or have never done a benchmark before\, this talk is f or everyone. \;\n \;\nNow a bit about Paul. He’s a freelance softw are developer here in Portland\, and has been building applications with Postgres since 2011. Paul has been working on the Postgres project itse lf. He’s authored many database extensions\, and his contributions to Po stgres include work on GiST indexes\, multiranges\, and SQL:2011 applica tion-time features.\n\nTags: postgres\, postgresql\, benchmarking\, benc hbase\n\nImported from: http://calagator.org/events/1250481254 URL:https://www.meetup.com/pdxpug/events/302834998/ SUMMARY:PDXPUG: Benchmarking with Benchbase LOCATION:American Red Cross: 3131 N Vancouver Ave\, Portland OR 97227 USA SEQUENCE:1 END:VEVENT BEGIN:VEVENT CREATED;VALUE=DATE-TIME:20241218T203051Z DTEND;TZID=America/Los_Angeles;VALUE=DATE-TIME:20250116T203000 DTSTART;TZID=America/Los_Angeles;VALUE=DATE-TIME:20250116T183000 DTSTAMP;VALUE=DATE-TIME:20241218T203051Z LAST-MODIFIED;VALUE=DATE-TIME:20241218T203051Z UID:http://calagator.org/events/1250481694 DESCRIPTION:PostgreSQL 17 was release September 26\, 2024. \;\n \;\ nWe will review freely available presentations available on the internet . \;\n \;\nCome learn what's new\, share experiences\, or just mee t with local peers! Casual\, informal.\n\nTags: postgres\, postgresql\n\ nImported from: http://calagator.org/events/1250481694 URL:https://www.meetup.com/pdxpug/events/305148196/ SUMMARY:PDXPUG: What's new in PostgreSQL 17 LOCATION:American Red Cross: 3131 N Vancouver Ave\, Portland OR 97227 USA SEQUENCE:1 END:VEVENT BEGIN:VEVENT CREATED;VALUE=DATE-TIME:20250123T210418Z DTEND;TZID=America/Los_Angeles;VALUE=DATE-TIME:20250220T203000 DTSTART;TZID=America/Los_Angeles;VALUE=DATE-TIME:20250220T183000 DTSTAMP;VALUE=DATE-TIME:20250123T210418Z LAST-MODIFIED;VALUE=DATE-TIME:20250123T210418Z UID:http://calagator.org/events/1250481749 DESCRIPTION:Postgres has a wide array of supported authentication methods . The \;\nstrongest methods have trouble scaling across large numbers of \;\ndatabase instances\, though\, and while organizations have wa ys to \;\ncentralize user credentials -- for example by using LDAP or Kerberos \;\n-- those solutions come with their own large lists of c aveats.I'm \;\ncurrently developing Postgres-native support for OAuth \, which is a \;\nwidely-deployed framework for authorizing clients u sing a third-party \;\nprovider. I'll talk about the current state of the patchset\, explain \;\nsome of the elements of the design\, and demonstrate what it might look \;\nlike to deploy it yourself.\n\nTag s: postgres\, postgresql\, oauth\n\nImported from: http://calagator.org/ events/1250481749 URL:https://www.meetup.com/pdxpug/events/305777417/ SUMMARY:PDXPUG Meetup: OAuth Support in PostgreSQL LOCATION:American Red Cross: 3131 N Vancouver Ave\, Portland OR 97227 USA SEQUENCE:2 END:VEVENT BEGIN:VEVENT CREATED;VALUE=DATE-TIME:20250822T205723Z DTEND;TZID=America/Los_Angeles;VALUE=DATE-TIME:20250904T203000 DTSTART;TZID=America/Los_Angeles;VALUE=DATE-TIME:20250904T183000 DTSTAMP;VALUE=DATE-TIME:20250822T205723Z LAST-MODIFIED;VALUE=DATE-TIME:20250822T205723Z UID:http://calagator.org/events/1250482180 DESCRIPTION:Cheap\, Fast\, Scalable: Introducing Analytics with Open Sour ce ClickHouse® \;\n \;\nReal-time analytic databases are indispens able tools for quick insights on large datasets\, and ClickHouse current ly leads the pack in speed and usage. This talk shows the major features that make ClickHouse popular for real-time analytics and provides a jum ping off point to build your own apps. We’ll explain internals of ClickH ouse and provide explicit guidance on when to reach for it. (And when no t to.\;) We will also demo new work from Altinity that adds separable co mpute and storage using shared Apache Iceberg tables. We’ll include thou ghts on design patterns for using PostgreSQL and ClickHouse productively together. \;\n \;\nClickhouse is a horizontally scaling columnar database that absolutely rips. Huge datasets\, JSON\, partitioning\, sh arding\, aggregations\, JOINs: Clickhouse handles massive queries in mil liseconds. We are so excited to host Robert and have him introduce anot her open source database Clickhouse. Robert has been working on database s since 1982\, from pre-relational systems through modern analytic DBMS\ , with a focus on distributed systems and transaction processing He has worked principally with open source databases since 2006 and Kubernetes since 2018. His day job is running Altinity\, a ClickHouse vendor. \; \n \;\nLooking forward to seeing you all there.\n\nTags: databases\, postgres\, OLA\, column store\, big data\, sql\, OLAP\n\nImported from: http://calagator.org/events/1250482180 URL:https://pdxpug.wordpress.com/2025/08/11/pdxpug-sept-4th-oss-database- spotlight-clickhouse/ SUMMARY:Portland PostgreSQL user group introduces Clickhouse LOCATION:3131 N Vancouver Ave · Portland\, OR: false SEQUENCE:1 END:VEVENT BEGIN:VEVENT CREATED;VALUE=DATE-TIME:20260120T220648Z DTEND;TZID=America/Los_Angeles;VALUE=DATE-TIME:20260219T203000 DTSTART;TZID=America/Los_Angeles;VALUE=DATE-TIME:20260219T183000 DTSTAMP;VALUE=DATE-TIME:20260120T220648Z LAST-MODIFIED;VALUE=DATE-TIME:20260120T220648Z UID:http://calagator.org/events/1250482416 DESCRIPTION:Please note different location at Multnomah Arts Center. Also \, please RSVP on MeetUp as space is limited: https://www.meetup.com/pdx pug/events/312977438/ \;\n \;\nPostgreSQL 18 was released Septembe r 25\, 2025. \;\n \;\nWe will review freely available presentation s available on the internet. \;\n \;\nCome learn what's new\, shar e experiences\, or just meet with local peers! Casual\, informal.\n\nTag s: pdxpug\, postgres\, postgresql\n\nImported from: http://calagator.org /events/1250482416 URL:https://www.meetup.com/pdxpug/events/312977438/ SUMMARY:PDXPUG: Portland PostgreSQL Users Meetup : What's new in PostgreS QL 18 LOCATION:Multnomah Arts Center: 7688 Sw Capitol Hwy\, Portland OR 97219 U S SEQUENCE:1 END:VEVENT END:VCALENDAR