nyuuzyou/wikis huggingface dataset:
Oscon 2013 signup

* Time slots are intended to allow people to have enough time to go to a session before it starts and to come to the booth after a session ends for people attending the conference.
* Please send t-shirt sizes and whether you prefer men's or women's cut to markwkm at postgresql.org by July 1. We will order t-shirts for all booth volunteers.
== Tue July 23 (17:00-18:00) (5pm - 6pm) - Opening Reception ==
* Mark Wong (markwkm at postgresql.org)
* gabrielle (gorthx@gmail.com)
* Josh Berkus
== Wed July 24 (10:00-16:30) (10am-4:40pm) ==
=== 10:00 - 11:15 ===
* Eric Hanson (eric@aquameta.com)
* 
=== 11:15 - 12:50 LUNCH ===
* Eric Hanson (eric@aquameta.com)
*
=== 12:50 - 14:25 LUNCH ===
* Christophe Pettus (christophe.pettus@pgexperts.com)
* Kacey Holston (kacey.holston@pgexperts.com)
=== 14:25 - 15:15 ===
* Christophe Pettus (christophe.pettus@pgexperts.com)
* Kacey Holston (kacey.holston@pgexperts.com)
=== 15:15 - 16:40 ===
* Selena Deckelmann (selena@postgresql.org)
* gabrielle (gorthx@gmail.com)
== Thurs July 25 10:00 - 17:00 (10am-5pm) ==
=== 10:00 - 11:25 ===
* Brian Panulla (bpanulla at gmail.com)
* Josh Berkus
=== 11:25 - 12:50 LUNCH ===
* Josh Berkus
* Ed (ed.snajder@jivesoftware.com)
=== 12:50 - 14:25 LUNCH ===
* gabrielle (gorthx@gmail.com)
* ed (ed.snajder@jivesoftware.com)
=== 14:25 - 16:00 ===
* gabrielle (gorthx@gmail.com)
* kris (krispennella@gmail.com)
=== 16:00 - 17:00 ===
* gabrielle (gorthx@gmail.com)
* kris (krispennella@gmail.com)
=== booth closeout/unload ===
We need people to take down booth decorations and tote leftover swag 0.4 miles (0.6k) to local storage. A vehicle will be available if we have a lot of stuff.
* gabrielle (gorthx@gmail.com)
* Brian Panulla (bpanulla@gmail.com)
* Mark Wong (markwkm at postgresql.org) 
*
----
Thanks for participating!
Category:PostgreSQL Events
Oscon 2014 signup

* Time slots are intended to allow people to have enough time to go to a session before it starts and to come to the booth after a session ends for people attending the conference.
* We will provide t-shirts for booth volunteers.
== Booth setup Mon July 21 (08:00 - 12:00) ==
We'll meet at Emma to tote stuff over to the convention center. It's about 0.4 miles (0.6k). Usually this project takes 2-3 people and about 90 minutes round trip. Actual start time dependent on the schedule of whoever signs up. You need to register as an exhibitor to get in to the expo hall to help us set up; gabrielle can get you set up with a code.
* gabrielle (gorthx@gmail.com)
* Mark (markwkm@gmail.com)
* Michael Brewer (mbrewer@gmail.com) (I think)
== Mon July 21 (17:00 - 18:00) (5pm-6pm) - Opening Reception ==
* Your name and email here
* Michael Brewer (mbrewer@gmail.com)
* Josh Berkus
== Tues July 22 (10:00-16:30) (10am-4:30pm) ==
=== 10:00 - 11:25 ===
* Josh Berkus
* Your name and email here
=== 11:25 - 12:15 ===
* gabrielle gorthx@gmail.com
* Josh Berkus
=== 12:15 - 13:35 LUNCH ===
* gabrielle gorthx@gmail.com
* kris krispennella@gmail.com
=== 13:35 - 14:25 ===
* gabrielle gorthx@gmail.com
* robert rbernier7390@comcast.net "Depends what time I get into town"
=== 14:25 - 15:15 ===
* gabrielle gorthx@gmail.com
* kris krispennella@gmail.com
=== 15:15 - 16:40 ===
* gabrielle gorthx@gmail.com
* Your name and email here
== Tues July 22 (evening) ==
There's a booth crawl, but we usually don't staff during this time. Come to the Postgres BoF instead.
== Wed July 23 10:00 - 17:00 (10am-5pm) ==
=== 10:00 - 11:25 ===
* gabrielle gorthx@gmail.com
* Robert rbernier7390@comcast.net (I'll be spending most of the day at the booth)
=== 11:25 - 12:15 ===
* gabrielle gorthx@gmail.com
* Your name and email here
=== 12:15 - 13:35 LUNCH ===
* gabrielle gorthx@gmail.com
* Your name and email here
=== 13:35 - 14:25 ===
* Your name and email here
* Your name and email here
=== 14:25 - 15:15 ===
* gabrielle gorthx@gmail.com
* Your name and email here
=== 15:15 - 17:00 ===
* Your name and email here
* Your name and email here
=== 17:00 booth closeout/unload ===
We need people to take down booth decorations and tote leftover swag back to Emma.
* gabrielle (gorthx@gmail.com)
* Michael Brewer (mbrewer@gmail.com)
----
Thanks for participating!
Category:PostgreSQL Events
OSCON 2019 signup

* Time slots are intended to make sure the booth is covered during major breaks around the sessions.
== Booth Setup Tues July 16 (08:00am - 5:00pm) ==
* Mark Wong (markwkm <at> postgresql.org)
== Wed July 17 (8:00am - 7pm) - Sponsor Reception is 5:45pm-7pm ==
=== 8:00am - 10:10am ===
* Your name and email here
=== 10:10am - 12:30pm ===
* Your name and email here
=== 12:30pm - 1:45pm LUNCH ===
* Your name and email here
=== 1:45pm - 3:05pm ===
* Your name and email here
Michel Pelletier (pelletier.michel <at> gmail.com)
=== 3:05pm - 5:45pm ===
* Your name and email here
Michel Pelletier (pelletier.michel <at> gmail.com)
=== 5:45pm - 7pm RECEPTION ===
* Your name and email here
Michel Pelletier (pelletier.michel <at> gmail.com)
== Thurs July 18 (8am - 3pm) ==
=== 8am - 10:10am ===
* Your name and email here
=== 10:10am - 12:30pm ===
* Your name and email here
=== 12:30pm - 1:45pm LUNCH ===
* Your name and email here
Michel Pelletier (pelletier.michel <at> gmai.com)
=== 1:45pm - 3:00pm ===
* Your name and email here
Michel Pelletier (pelletier.michel <at> gmai.com)
----
Thanks for participating!
Category:PostgreSQL Events
Other Git Repositories

Greg Stark mentioned that there are some Git repositories available that show work-in-process of developers. 
During Andrew Sullivan's talk about PostgreSQL Project Management, Marco (sorry, didn't catch the last name) and Greg both mentioned the superior ability of git and mercurial when it comes to integrating a series of small patch sets. 
We're listing Git repositories that developers have made publicly available. Check them out, contribute, contact the authors!
==Conversions of the main PostgreSQL repo==
* http://git.postgresql.org/ (France, updated every 30 minutes) 
* http://repo.or.cz/w/PostgreSQL.git (Czech Republic, updated every 15 minutes)
* http://git.catalyst.net.nz/ (New Zealand)
==PostgreSQL Core Features==
Contact	Git Repository URL	Project
 	 	
 	 	
==Compatibility patches for PostgreSQL used in other applications==
Contact	Git Repository URL	Project
 	 	
 	 	
Category:Git
Packagers

There exists a mailing list pgsql-packagers@postgresql.org for individuals who work on downstream packages (RPM, Deb, Windows, etc.) of PostgreSQL.
The packagers mailing list gets advance notice of upcoming releases, and they get access to the release tarballs a few days before general availability, so that packages can be prepared and made available at the same time as the source tarballs. This is especially important for security releases, but it also provides a nice service to users in general.
The pgsql-packagers mailing list is closed-subscription because of the reasons described. A request to join the list can be made to the core team. The follow criteria are unofficial guidelines for deciding whether such a request is appropriate:
* You must actually be working on packages. The packagers list is not a method for learning about releases or security issues or for monitoring packaging work.
* Multiple people working on one package is OK. But we prefer to keep the number of subscribed individuals to a manageable size. If a package maintainer changes, the old packager should be dropped from the list.
* The packages will be made available under open-source licensing terms. Individuals who create packages for internal use or paying clients only will have to wait for the general release.
* You must agree to abide by the core team's release, disclosure, and embargo schedules and policies.
* The packaging effort must be regular and sustainable. That is, you will generally be expected to produce up to date packages for every release according to the release schedule given by the core team. There may be exceptions, such as when the downstream operating system is preparing a release. But if you go missing or skip many releases or don't respond adequately when a security release is being prepared, your membership on the pgsql-packagers list may be dropped.
Category:Development
Paleta de Colores

Azul 
* dark blue : #0064a5
* base blue : #336791
* light blue : #008bb9
Gris
* dark grey : #848484 
* base grey : #666666
* light grey : #585858
Naranja
* dark orange : #cc3b03
* base orange : #d24b03
* light orange : #f26522
Category:Español
Patch Reviews

Add Optional TZ Parameter to TSTZ Functions
===========================================
Idea
----
Currently, timestamp-with-timezone (tstz) functions use the 'timezone' GUC
variable to guide their decision about which timezone to use for their
calculations.
It would be nice if these functions took a TZ name as an optional parameter, and
used that for the calculations, instead of the value of 'timezone' GUC
parameter.
One use-case for this additional functionality would be multi-timezone
applications. Currently, such applications cannot easily perform timestamp
calculations for different timezones. With this change, it would make it easy
for such applications to perform such calculations.
Discussion(s)
-------------
[Proposal][] seems to have gone well. The responses include a committer's
buy-in.
[Proposal]:
https://www.postgresql.org/message-id/flat/01a84551-48dd-1359-bf7e-f6b0203a6bd0%40sztoch.pl
Committer Buy-in
----------------
This [initial response by Tom Lane][], in the [proposal][] thread sounds like he
has bought into the idea.
[initial response by Tom Lane]:
https://www.postgresql.org/message-id/38924.1655214183%40sss.pgh.pa.us
Design
------
Implementation Details
----------------------
Tests
-----
Category:Getting a patch accepted
Patch Status For 8.3

== current patch status ==
 	URL 	Author 	Reviewer 	Status (updated)
concurrent psql 	concurrent psql 	Greg Stark 	Andrew Dunstan 	patch kept for 8.4 (2007-06-14)
Dead space map 	DSM 	ITAGAKI Takahiro 	? 	patch kept for 8.4
SQL/PSM support 	PL/pgPSM 	Pavel Stehule 	Andrew Dunstan 	patch kept for 8.4
RETURNS TABLE Support 	Table function 	Pavel Stehule 	Neil Conway 	RETURNS TABLE patch kept for 8.4
On disk Bitmap Index 	Bitmap Index 	Gavin Sherry 	? 	patch kept for 8.4
POSIX shared memory support 	Posix SHM 	Chris Marcellino 	? 	patch kept for 8.4
stream bitmaps (API change for Group Index Tuples)	stream bitmaps 	Heikki Linnakangas	? 	patch kept for 8.4 (2007-08-16)
bitmap scan changes 	bitmap scan changes 	Heikki Linnakangas	Alexey Klyukin, Alvaro Herrera	patch kept for 8.4 (2007-08-16)
Grouped Index Tuples/Cluster Indexes 	GIT 	Heikki Linnakangas	Alexey Klyukin, Alvaro Herrera	patch kept for 8.4 (2007-08-16)
Group commit 	Group commit discussion 	Heikki Linnakangas	? 	patch kept for 8.4
Maintaining cluster order on insert 	Maintaining cluster order on insert	Heikki Linnakangas	Tom Lane 	patch kept for 8.4 (2007-08-16)
support for dumping only functions in pg_dump 	pg_dump patch 	Dany DeBontridder 	 	
current_query 	current_query patch 	Tomas Doran 	 	
make --enable-integer-datetime the default 	 	Neil Conway 	 	
TOAST thresholds 	[TOAST thresholds ] 	 	 	
Avahi support 	 	Mathias Hasselmann	Peter Eisentraut 	needs more work (2008-02-29)
DTrace enhancements 	 	Robert Lor 	Peter Eisentraut 	chatting (2008-02-29)
EXECUTE USING for plpgsql 	 	Pavel Stehule 	 	This has been saved for the 8.4 release
FOR statement for cursor 	 	Pavel Stehule 	 	This has been saved for the 8.4 release
Category:Closed Commitfests
Pdxpug

Page to hold PDXPUG-specific files & such. Other PUGs are welcome to use any of this material, except the logo.
If you're looking for the PDXPUG blog or meeting announcements, they're here.
== Logo ==
== Poster ==
== Flyers ==
* PGXPUG PgDay after-party flier (2011): Front ODT | Back ODT. You'll need the following fonts: Strait, monofur.
== Talks & Stuff ==
Past PDXPUG Talks
PDXPUG lab ideas
== Speaker Info ==
Hello!
Thank you for agreeing to speak at PDXPUG’s monthly meeting on [date].
Our meetings are held at the PSU Business Accelerator, 2828 SW Corbett Ave, Portland, OR. Parking is open after 5pm and we're on the second floor. 
Our meetings usually go from 6-7:30pm; we have about 15-30 minutes of announcements/discussion and then our main topic. Plan to speak for 45-60 minutes including questions. Group size ranges anywhere from 5-25 attendees; the average is about a dozen.
We'll provide a projector and VGA dongle; let us know if you need another adapter or a laptop, and we'll arrange something with one of our members.
Thank you! We’re looking forward to having you at our meeting.
PDXPUG
== Agenda ==
=== Welcome to the space ===
* thanks to Business Accelerator for hosting us
* wireless login
* restrooms
* after meeting social hour TBD
=== Announcements/wisecracks ===
* pdxpug twitter feed
* past events
** reports from Pg-related events: PgCon, PgOpen, OSCON, local postgis meeting, etc
* upcoming events
** announcements & plans for Pg-related events, eg conference CFPs and booth signups
* other business
** e.g. patches reviewed/accepted, jobs: who has one, who needs one
=== Intros ===
* silly question + your name
=== Speaker ===
* introduce the speaker
* talk talk talk
* questions
Category:Users group
PDXPUG Agenda

We'll try keeping our agenda here for a little while...
= Standard Agenda =
== Welcome to the space ==
* thanks to Iovation for hosting us
* wireless login
* restrooms
* after meeting social hour TBD, probably Huber's
== Announcements/wisecracks ==
* pdxpug twitter feed
* past events
** PgCon - how was it?
** OSB - how was it?
* upcoming events
** OSCON
*** booth signup is out
*** beering venue will be...
*** we will have t-shirts for booth volunteers, but you have to sign up in advance so we can order them: deadline is July 7!
** PgOpen
*** CFP closes July 1
* other business
** PDXPUG + PgUS
** patches reviewed/accepted
** jobs! 
*** who has a new one? Share your excitement!
*** have an opening?
*** looking for something new to do?
** books
== Intros ==
* silly question + your name
PDXPUGDay2010

== PDXPUG Day OSCON 2010 ==
PDXPUG is the Portland PostgreSQL Users' Group.
Date: July 18, 2010
Time: 9:30 am to 5:30pm, with a break for lunch and a party afterwards
Place: Oregon Convention Center, room D131
Content: Sessions covering PostgreSQL-related topics not included in the main program.
Invited: PDXPUG, PostgreSQL community members, Collaboration Summit participants, OSCON participants
Fee: Suggested donation of $30 to the PostgreSQL Fund
Party: afterwards, join us for a party (details below)
Registration: Sign up for free!
Schedule (subject to change):
9:30am 	Welcome and Introductions 	Mark Wong
10:00am 	What's new in 9.0? 	Selena Deckelmann
11:00am 	ORMs and Their Discontents 	Christophe Pettus
12:00pm 	Lunch 	
1:30pm 	Mining Your Logs For Fun and Profit 	Josh Berkus
2:30pm 	PORTAL 	Dan Colish
3:30pm 	An Introduction to Managing and Troubleshooting PostgreSQL on Windows 	Tim Bruce
4:30pm 	PostgreSQL in Brazilian Army and Air Force 	Luis Dosso
6:00pm - 10:00pm	Party at Gotham Tavern! 2240 N Interstate Avenue, Portland, Oregon 97227	
Category:PostgreSQL Events
PDXPUGDay2011

== PDXPUG Day OSCON 2011 ==
PDXPUG is the Portland PostgreSQL Users' Group.
Date: Sunday, July 24, 2011
Time: 9:30 am to 5:30pm, with a break for lunch and a party afterwards
Place: Oregon Convention Center, room E147
Content: Sessions covering PostgreSQL-related topics not included in the main program.
Invited: PDXPUG, PostgreSQL community members, Collaboration Summit participants, OSCON participants
Fee: Suggested donation of $30 to the PostgreSQL Fund
Party: afterwards, join us for a party (details below)
Registration: Sign up for free!
Schedule (subject to change):
10:00am 	Welcome and Introductions 	Mark Wong
10:30am 	MVCC Unmasked 	Bruce Momjian
12:00pm 	Lunch 	
1:30pm 	Building and Distributing PostgreSQL Extensions Without Learning C 	David E. Wheeler
2:30pm 	PL/Perl6: Butterflies in your PostgreSQL Database 	Jonathan "Duke" Leto
3:30pm 	Advanced WAL file management with OmniPITR 	Rob Treat
4:30pm 	Zooming with PostgreSQL 	Tom Raney
6:00pm - 10:00pm	Party at Gotham Tavern! 2240 N Interstate Avenue, Portland, Oregon 97227	
Category:PostgreSQL Events
== Talk Descriptions ==
===MVCC Unmasked (Bruce Momjian)===
Multi-Version Concurrency Control (MVCC) allows Postgres to offer high concurrency even during significant database read/write activity. MVCC specifically offers behavior where "readers never block writers, and writers never block readers". This talk explains how MVCC is implemented in Postgres and highlights optimizations which minimize the downsides of MVCC. This talk is for advanced users.
===Building and Distributing PostgreSQL Extensions Without Learning C (David E. Wheeler)===
PostgreSQL is extensible like a dynamic programming language. Support for custom functions, operators, types, domains, and other database objects is built right into SQL. This talk will take you through the process of creating a pure-SQL extension and distributing it on [PGXN], the "CPAN for PostgreSQL extensions".
===PL/Perl6: Butterflies in your PostgreSQL Database (Jonathan "Duke" Leto)===
PL/Perl6 is a new PostgreSQL Procedural Language that allows one to write stored procedures in Perl 6.
===Advanced WAL file management with OmniPITR (Robert Treat)===
OmniPITR is a set of scripts designed to help manage and maintain database operations that revolve around Postgres WAL files. It was created in an effort to replace the myriad scripts we've encountered and/or written managing our clients Postgres installs over the years. It includes tools for both archiving, restoration, and creating portable backups on both the master and slave instance.
===Zooming with PostgreSQL (Tom Raney)===
How do you build an advanced medical record system in just a few months that is lightening fast, supports multiple clinics and scales well? Easy! PostgreSQL, Java and the power of OSS!
Pdxpug labs

Our labs are very informal and do not have a set agenda or leader. We *may* have an list of topics we'd like to cover, but you are in no way required to do them in order, or do all of them, and you may certainly add your own. We all answer questions and help each other out.
The objective is to mess around with Pg-related stuff in a more relaxed environment than you may have at work. And on non-production equipment. :)
==Ideas for workshops==
* Schemaverse! https://schemaverse.com/
* Replication
** BDR (Dec 2014)
** streaming rep (Jan & Feb 2014)
*** group project: flowchart of all the different options & pieces parts
*** try this: https://github.com/darkixion/pg_rep_test
** slony
** bucardo
* Choosing a High Availability plan
* Upgrading
** old-school pgdump, binary or plain
** Slony
** pg_upgrade
* Different ways to take backups
* Troubleshooting slow queries
* Monitoring (this could easily be a series on its own)
** check_postgres
** Try out pgbadger (bring your logs!)
* Disaster Recovery
** Oh no, somebody deleted pg_xlog
** Transaction wraparound
* Postgres on zfs
* Postgres packet captures
* Tour of contrib modules
* Foreign Data Wrappers (Jan 2015)
* Try out different transaction levels
* Inheritance
* Row-level security
* Try out WAL-E
* Admin tools
** PgAdminIII
** PostgreSQL Studio
* Perf testing
** pgbench
** pgreplay https://github.com/laurenz/pgreplay
** Benchmarking changes to GUCs, e.g. maintenance_work_mem.
* Connection poolers:
** pgpool
** pgbouncer
* Contrib modules:
** tablefunc (crosstab!)
Performance Optimization

== How to Effectively Ask Questions Regarding Performance on Postgres Lists ==
* Slow_Query_Questions
== General Setup and Optimization ==
* Tuning Your PostgreSQL Server by Greg Smith, Robert Treat, and Christopher Browne
* PostgreSQL Query Profiler in dbForge Studio by Devart
* Performance Tuning PostgreSQL by Frank Wiles
* QuickStart Guide to Tuning PostgreSQL by Christopher Browne
* Performance Tuning by Josh Berkus and Shridhar Daithankar
* Replacing Slow Loops in PostgreSQL by Joel Burton
* PostgreSQL Hardware Performance Tuning by Bruce Momjian
* The effects of data fragmentation in a mixed load database by Dmitry Dvoinikov
* Understanding Postgres Performance by Craig Kerstiens
* More on Postgres Performance by Craig Kerstiens
* Faster PostgreSQL counting by Joe Nelson
* Row count estimates in Postgres by David Conlin
* Index-only scans in Postgres by David Conlin
* Optimize PostgreSQL Server Performance Through Configuration by Tom Swartz
Performance courses are available from a number of companies. Check events and trainings for further details.
==Critical maintenance for performance==
*Introduction to VACUUM, ANALYZE, EXPLAIN, and COUNT by Jim Nasby.
* PostgreSQL EXPLAIN for Analyzing Query Execution Plans by Devart
*VACUUM FULL and why you should avoid it
*Planner Statistics
*Using EXPLAIN
*Logging Difficult Queries
*Logging Checkpoints
*Bulk Loading and Restores
*Performance Analysis Tools by Craig Ringer
== Database architecture ==
* Limiting and prioritizing user/query/database resource usage by Craig Ringer
* Prioritizing databases by separating into multiple clusters by Craig Ringer
* Clustering
* Shared Storage
==Database Hardware Selection and Setup==
* Database Hardware
* Reliable Writes
==Benchmark Workloads==
* :Category:Benchmarking
Category:AdministrationCategory:PerformanceCategory:Benchmarking
Category:General articles and guides
Performance Optimization/ja

== 一般的な設定と最適化 ==
* PostgreSQLサーバをチューニングする by Greg Smith, Robert Treat, and Christopher Browne
== 性能改善のための重要なメンテナンス==
*Introduction to VACUUM, ANALYZE, EXPLAIN, and COUNT by Jim Nasby.（訳注：未翻訳）
*VACUUM FULL とそれを避けるべき理由（訳注：8.4以前が対象の記事です。未翻訳）
*プランナ統計情報
*EXPLAINを使用する
*難しいクエリのログ記録
*チェックポイントのログ記録
*バルクロードとリストア
*性能分析ツール by Craig Ringer
== データベースアーキテクチャ ==
* Limiting and prioritizing user/query/database resource usage by Craig Ringer（訳注：未翻訳）
* Prioritizing databases by separating into multiple clusters by Craig Ringer（訳注：未翻訳）
==データベースハードウェアの選定と構築==
* Database Hardware（訳注：未翻訳）
* Reliable Writes（訳注：未翻訳）
==ベンチマークワークロード== 
* ベンチマークカテゴリ
Category:AdministrationCategory:PerformanceCategory:Benchmarking
Category:Japanese
Category:General articles and guides