nyuuzyou/wikis huggingface dataset:
NTT roadmap

== Partitioning ==
* Amit Langote is going to continue working on native (declarative) partitioning. Although the initial goal is to implement the DDL on top of existing inheritance-based partitioning capabilities so that certain optimizer and executor enhancements could be realized in near term (which the EDB/Postgres Professional members will be working on as well), he is open to adapting to any alternate partitioning infrastructure that the community thinks to be a way forward. There is no concrete proposal yet for the said alternate infrastructure, but he is currently investigating the options and will prioritize them based on the consensus within the community.
** pgsql-hackers: Declarative partitioning - another take
* Once we have native partitioning, Tatsuro Yamada will work on introducing global indexes on partitioned tables.
== Replication ==
* Masahiko Sawada is working on improving multiple synchronous replication, especially adding quorum commit and more complexed synchronous method.
** pgsql-hackers: Quorum commit for multiple synchronous replication.
== Maintenance ==
* Masahiko Sawada is working on improving VACUUM processing logic. He is also interested in parallel utility commands, especially VACUUM and ANALYZE.
** pgsql-hackers: Optimization for lazy_scan_heap
** pgsql-hackers: Block level parallel vacuum WIP
== Foreign Data Wrappers ==
* Masahiko Sawada and Vinayak Pokale will work on a transaction manager for database sharding with FDW approach. Since some transaction manager approaches are already proposed, he will join the discussion to reach the consensus on community first.
** pgsql-hackers: Transactions involving multiple postgres foreign servers
* Kyotaro Horiguchi is going to continue working on adding support for asynchronous execution of FDWs with Robert Haas of EDB or any other contributors.
** pgsql-hackers: asynchronous and vectorized execution
* Kyotaro Horiguchi will help review the work on adding aggregate pushdown to postgres_fdw, which will be proposed by the EDB members.
* Etsuro Fujita will work on improving the postgres_fdw join pushdown. Currently, it doesn't handle some cases, such as FULL joins on relations with restrictions or SEMI/ANTI joins. And it doesn't yet attempt to create parameterized join paths even though this option does get tried for a base relation scan. He will work on eliminating these limitations.
** pgsql-hackers: Push down more full joins in postgres_fdw
* Etsuro Fujita will work on improving the postgres_fdw DML pushdown so that UPDATE/DELETE on a foreign join can be pushed down to the remote server. He also plans to work on adding INSERT pushdown to postgres_fdw.
** pgsql-hackers: Push down more UPDATEs/DELETEs in postgres_fdw
NYCDPUG

The New York Capital District PostgreSQL Users Group no longer exists. The following contains a listing of past presentations:
* January 7, 2010 - Introduction to PostgreSQL NYCDPUG_NYISO_PostrgreSQL.pdf
* March 4, 2010 - Bruce Momjian's Inside PostgreSQL Shared Memory
* May 6, 2010 - Separation of Duties NYISO_Separation_of_Duties.pdf
* March 3, 2011 - Securing data in transit using SSL and SSL/TLS LDAP.
* May 5, 2011 - Jim Mlodgenski's Scaling PostgreSQL with Stado
* November 3, 2011 - Why is Oracle Better than PostgreSQL? Oracle-better-than-postgres.pdf
Category:Users group
NZPgUG

NZPgUG is the New Zealand PostgreSQL User Group.
==Wellington PgUG==
Wellington Meetup
contact: Miroslav Vujičić
==Wellington Meetup October 20tt 2016 at Catalyst==
===New features in PosgreSQL 9.6.===
The talk will focus 3 areas, with short demonstrations:
* parallel query execution allowing more than one CPU core to be used by a query
* synchronous replication with multiple replicas and synchronous 'apply'
* major improvements to postgres_fdw allowing better cooperation between database servers
About the speaker: Thomas Munro joined the Database Server team at EnterpriseDB about a year ago, where he works on Postgres Plus Advanced Server and PostgreSQL. Previously he worked on mission critical software in the finance and software industries in the UK, New Zealand and France over the past two decades. 
=== Past Events===
ODBC Driver for PostgreSQL

== About ==
Devart ODBC Driver for PostgreSQL provides high-performance and feature-rich connectivity solution for ODBC-based applications to access PostgreSQL databases from from Windows, macOS, Linux, both 32-bit and 64-bit. Full support for standard ODBC API functions and data types implemented in our driver makes interaction of your database applications with PostgreSQL fast, easy and extremely handy.
== Key Features: ==
* Direct ConnectionDatabase applications based on our solution get an opportunity to establish connection to PostgreSQL directly. Direct Connection gives your applications an unrivalled advantage — connection to PostgreSQL databases directly via TCP/IP avoiding PostgreSQL Client. That improves performance of your applications, their quality, reliability and especially the deployment process, since there is no need to supply additional client software together with your application.
* ODBC Conformance ODBC driver provides full support for common ODBC interface:
**ODBC Data Types support
**ODBC API Functions support
 
* Development Platforms Variety ODBC Driver for PostgreSQL doesn't limit your choice of the development platform and environment. The driver installations are available for various operational systems and platforms. The current version supports Windows, both 32-bit and 64-bit. So you can develop both 32-bit and 64-bit cross-platform applications.
* DB Compatibility ODBC Driver for PostgreSQL supports PostgreSQL server versions since 8.0 up to 10.0.
* SSL Encryption Work with PostgreSQL securely using SSL connection options provided in our driver along with support for SSL protocol.
Category:Tool
ODBC Driver for PostgreSQL by CData

== About ==
The ODBC Driver for PostgreSQL by CData enables real-time access to PostgreSQL data, directly from any applications that support ODBC connectivity, the most widely supported interface for connecting applications with data. The driver wraps the complexity of accessing PostgreSQL data in a standard ODBC driver compliant with ODBC 3.8. The driver hides the complexity of accessing data and provides additional powerful security features, smart caching, batching, socket management, and more.
Category:Tool
ODBC Driver for PostgreSQL by Devart

== About ==
ODBC Driver for PostgreSQL by Devart provides high-performance and feature-rich connectivity solution for ODBC-based applications to access PostgreSQL databases from from Windows, macOS, Linux, both 32-bit and 64-bit. Full support for standard ODBC API functions and data types implemented in our driver makes interaction of your database applications with PostgreSQL fast, easy and extremely handy.
== Key Features: ==
* Direct ConnectionDatabase applications based on our solution get an opportunity to establish connection to PostgreSQL directly. Direct Connection gives your applications an unrivalled advantage — connection to PostgreSQL databases directly via TCP/IP avoiding PostgreSQL Client. That improves performance of your applications, their quality, reliability and especially the deployment process, since there is no need to supply additional client software together with your application.
* ODBC Conformance ODBC driver provides full support for common ODBC interface:
**ODBC Data Types support
**ODBC API Functions support
 
* Development Platforms Variety ODBC Driver for PostgreSQL doesn't limit your choice of the development platform and environment. The driver installations are available for various operational systems and platforms. The current version supports Windows, both 32-bit and 64-bit. So you can develop both 32-bit and 64-bit cross-platform applications.
* DB Compatibility ODBC Driver for PostgreSQL supports PostgreSQL server versions since 8.0 up to 10.0.
* SSL Encryption Work with PostgreSQL securely using SSL connection options provided in our driver along with support for SSL protocol.
Category:Tool
ODBC Updates with94

Some development effort is being put in Postgres ODBC driver to remove outdated code, protocols and clean up the code as well. This effort is made to facilitate maintenance and head up for future releases. The target release for this work is 9.4 release.
= Work flow =
The development effort is done mainly by Michael Paquier under the guidance of Heikki Linnakangas. In order to not impact the released 09.03.XXX versions of ODBC, merge will be done before releasing 09.04.XXXX, which could be released a couple of weeks before 9.4 to facilitate the work of packagers.
= Work items =
The following work items are envisaged on the fork before merge for 9.4 release.
Here are the items already done:
* Done on fork branch: Removal of code paths referencing Postgres servers older than 7.4 (ksqo, schema_support, version-related code)
* Done on fork branch: Cleanup of the documentation, removal of references to servers ~7.4
* Done on fork branch: Renaming of column PRECISION in pgtypes.c to COLUMN_SIZE, per discussion here
* Done on fork branch: Removal of ODBCVER ifdef blocks, it is assumed that it is safe to build code with at least 0x0351.
* Done on fork branch: Reorganization of info*.c, odbcapi*.c, pgapi*.c: removal of 2.5 stuff, grouping of 3.0 APIs with other files for simplicity
And the items not done yet:
* Patch on tracks: Addition of a new parameter for ErrorOnRollback, that is now part of the protocol string as (0|1|2). This setting is the primary one. The old setting is still accepted, just deprecated.
* See if something is doable with PG_INTERVAL_AS_SQL_INTERNAL currently disabled in the code
* See how to deal with odbc.sql, odbc-drop.sql and inouealc.c (removal because dead code?)
Followed by the following complementary work items, mergeable immediately to pgodbc HEAD as they do not impact the older code:
* Regression tests
** Done: Check of ODBC 2.X deprecated API calls, list of functions is referenced here
** Done: pgtypes.c APIs: SQLTables, SQLColumns, etc.
** Done: Additional tests for rollback behavior on error
** Done: Fix regression tests to use ODBC 3.X APIs
** Support for Windows
= Resources =
* Discussion thread of the topic
* Postgres ODBC fork where temporary patches are located. Branch called cleanup-94 is used, and will be rebased on ODBC HEAD from time-to-time to facilitate the future merge.
OHLF

== Ohio Linux Fest ==
Ohio LinuxFest 2007
Columbus, Ohio
Robert Treat is speaking on What's New In PostgreSQL 8.3?
 
=== Resources needed ===
* PostgreSQL flyers
* Perhaps funding for a .ORG table
* CDs
=== Contacts ===
* Robert Treat <xzilla ( at ) users ( dot ) sourceforge ( dot ) net
* Bill Moran <wmoran ( at ) potentialtech ( dot ) com>
* Josh Williams <joshwilliams ( at ) ij ( dot ) net>
=== Discussion threads ===
* June 2007 - PG-advocacy
* May 2007 - PG-advocacy
=== Archives ===
Christopher Browne spoke at the 2006 event, on "what's new with 8.1 and 8.2?"
Category:PostgreSQL Events
ONLF

== Ontario Linux Fest ==
Ontario LinuxFest 2007
Toronto, Ontario, Canada
October 13, 2007
=== Resources needed ===
* PostgreSQL flyers
* Perhaps funding for a .ORG table
* CDs
=== Contacts ===
* Christopher Browne
* Toronto PostgreSQL Locals
=== Discussion threads ===
* June 2007 - PG-advocacy
=== Archives ===
Christopher Browne spoke at the 2006 Ohio event, on "what's new with 8.1 and 8.2?", and has proposed a similar talk on 8.3 for this show.
Category:PostgreSQL Events
Open Source Projects Using PostgreSQL

== Using PostgreSQL exclusively ==
* FusionForge
* Launchpad
* LedgerSMB
* OpenERP
* OpenNMS
* xTuple PostBooks
== Using PostgreSQL as default ==
* JasperReports Server
* OpenStreetMap
* Liquid Feedback
== Using PostgreSQL ==
* Alfresco
* Asterisk
* Bacula
* Bugzilla
* Django
* Dovecot
* Exim
* Icinga
* OTRS
* Postfix
* Redmine
* RT
* Ruby on Rails
* Trac
* Zabbix
Category:Software Ports
OpenVMS port

This page keeps track of the status of porting PostgreSQL to the OpenVMS platform.
== OpenVMS Port ==
=== GNV ===
GNV provides a Unix-like environment on OpenVMS. Many Unix utilities are provided by GNV, including bash, awk, sed, tar, gzip, etc. Note that gcc/g++ is a wrapper around the native OpenVMS compiler.
=== Code changes ===
* fork() on OpenVMS is like vfork() on Unix. Note that Win32 also does not support fork(), so this issue is not new to PostgreSQL. We will need to write a new implementation of internal_forkexec() (in src/backend/postmaster/postmaster.c) that calls OpenVMS specific routines like lib$spawn(), or sys$creprc() for detached process.
* Directory separator on OpenVMS is a dot (.), which is different than a / on Unix. Also, ODS-2 disks have more restrictions on filename; ODS-5 disks allow longer filenames, more legal characters within the filenames, and case preserving filenames.
Category:Operating system
OptimizerHintsDiscussion

= Optimizer and Query Hints Discussion =
Many people over the years have requested that the PostgreSQL project implement "optimizer hints" or "query hints" as they are implemented in other RDBMSes such as Oracle and MySQL. The official current stance from the community is this:
We are not interested in implementing hints in the exact ways they are commonly implemented on other databases. Proposals based on "because they've got them" will not be welcomed. If you have an idea that avoids the problems that have been observed with other hint systems, that could lead to valuable discussion.
== Problems with existing Hint systems ==
* Poor application code maintainability: hints in queries require massive refactoring.
* Interference with upgrades: today's helpful hints become anti-performance after an upgrade.
* Encouraging bad DBA habits slap a hint on instead of figuring out the real issue.
* Does not scale with data size: the hint that's right when a table is small is likely to be wrong when it gets larger.
* Failure to actually improve query performance: most of the time, the optimizer is actually right.
* Interfering with improving the query planner: people who use hints seldom report the query problem to the project.
== Where Existing Hint Systems Benefit ==
* "One-shot" issues, such as annual or one-time reports, for which maintainability is not a concern
* Ability to "test" various execution paths in detail and see how the optimizer is working (or not)
* Optimizer failure 
** Implementation failure (known issues)
** Theoretical failure (estimation limits, n^2 correlation problem)
== Available mechanisms for query troubleshooting ==
There are several existing controls with the database that have an impact similar to what people expect hinting to accomplish. See Hinting at PostgreSQL for one list.
== Discussions about Optimizer Hints ==
* Re: An Idea for planner hints
* Index Tuning Features
* Re: [PERFORM] Hints proposal
* Re: Why we don't want hints Was: Slow count(*) again...
* Planner hints in Postgresql
Category:Development
Oracle Compatibility Tasks

= Implementation Jobs for Improving Oracle Compatibility in PostgreSQL =
Here are a few jobs and research projects for improving Oracle compatibility in and around PostgreSQL. This is based upon Peter Eisentraut's talk at PGCon 2008. Please add your thoughts.
== Syntax ==
* Quoted identifiers, upper vs. lower case folding
* MINUS vs. EXCEPT (check whether Oracle also supports EXCEPT)
== Data Types ==
* Implement varchar2 as alias for varchar [orafce]
* Implement clob as alias for text [PG core]
* Implement long as alias for text or clob? [orafce]
* Implement nchar, nvarchar2, nclob as appropriate [orafce and PG core]
* Implement number as alias for numeric [orafce]
* Implement binary_float, binary_double as aliases for float4, float8 [orafce]
* Implement blob [PG core]
* Implement raw, long raw [orafce]
* Figure out some way to allow Oracle-behavior with date (???)
* Fix interval type to be compatible with SQL standard.
== Null Behavior ==
I would like to see a detailed analysis and definition of how null values
really behave in Oracle. We can probably implement workarounds to make the
behavior optionally more similar, but at the moment the Oracle behavior just
appears weird and totally inconsistent.
== Sequences ==
* Add NOCACHE clause to CREATE SEQUENCE
== Formatting ==
* Add more features and robustness to to_char.
* Maybe add custom variables for the NLS_ settings that internally change the right PostgreSQL settings.
== Triggers ==
* Allow creating triggers and associated functions in one statement. The function would be created automatically as a depend
== PL/pgSQL ==
* Make DECLARE optional
* Make PERFORM optional for procedure calls
Category:Oracle
Oracle Functions

This is work in progress
== Numeric Functions ==
Oracle Function	Postgres
ABS 	ABS
ACOS 	ACOS
ASIN 	ASIN
ATAN 	ATAN
ATAN2 	ATAN2
BITAND 	& (Operator)
CEIL 	CEIL
COS 	COS
COSH 	by extension orafce
EXP 	EXP
FLOOR 	FLOOR
LN 	LN
LOG 	LOG
MOD 	MOD	or & (Operator)
NANVL 	Currently no known implementation
POWER 	POWER
REMAINDER 	Currently no known implementation
ROUND (number) 	ROUND (number)
SIGN 	SIGN
SIN 	SIN
SINH 	by extension orafce
SQRT 	SQRT
TAN 	TAN
TANH 	by extension orafce
TRUNC (number) 	TRUNC (number)
WIDTH_BUCKET 	WIDTH_BUCKET
== Character Functions Returning Character Values ==
== Character Functions Returning Number Values ==
== Character Set Functions ==
== Collation Functions ==
== Datetime Functions ==
== General Comparison Functions ==
== Conversion Functions ==
== Large Object Functions ==
== Collection Functions ==
== Hierarchical Functions ==
== Data Mining Functions ==
== XML Functions ==
== JSON Functions ==
== Encoding and Decoding Functions ==
== NULL-Related Functions ==
== Environment and Identifier Functions ==
OSCON07PGDay

== PDXPUG Day OSCON 2007 ==
PDXPUG is the Portland PostgreSQL Users' Group.
Date: July 22, 2007
Time: 11 am to 5pm, with a break for lunch and a party afterwards
Place: Oregon Convention Center, Room F149
Content: 5 sessions covering PostgreSQL-related topics not included in the main program.
Invited: PDXPUG, PostgreSQL community members, Ubuntu Live attendees
Fee: Suggested donation of $20 to the PostgreSQL Fund
Party: afterwards, join us for the party sponsored by Command Prompt.
Registration: Registration Page
Further details are on the Registration Page
Schedule:
11a-12p: How PostgreSQL Development Works, or: 50 Ways to Contribute To PostgreSQL, Josh Berkus
12-1p: Time-oriented databases in PostgreSQL, Jeff Davis & Selena Deckelmann
1-2p: LUNCH (on your own)
2-3p: Build a PostgreSQL Web 2.0 Application in 10 Minutes, Rob Napier
3-4p: PostgreSQL and Solaris for large-scale applications, Theo Schlossnagle
4-5p: LedgerSMB Features & Architecture, Chris Travers
Category:PostgreSQL Events
OSCon 2004

=== Joe Conway ===
Power PostgreSQL: Extending the Database with C: slides | code
Flexible Data Acquisition and Analysis: slides | code
=== George Essig ===
Tsearch2: slides
=== Vivek Khera ===
Setting up a Large PostgreSQL Server: A Case Study: slides
=== Bruce Momjian ===
State of PostgreSQL: slides
=== Robert Treat ===
Applying Advanced Database Features: slides | code
Category:PostgreSQL Events
OSCon 2005

== Chris Browne ==
Replicating PostgreSQL Databases Using Slony-I
Event Propagation in Slony-I
Sample Replication RT/3
Upcoming Slony-I Enhancements
== Joe Conway ==
Terrabytes of Business Intelligence
== Lance Obermeyer ==
Running PostgreSQL On Windows
== Bruce Momjian ==
State of PostgreSQL 8.1
Porting PostgreSQL To Windows
== Aaron Thul ==
PostgreSQL Built Your Car
== Robert Treat ==
Explaining Explain
Category:PostgreSQL Events
OSCON2007

== OSCON 2007 (Plus Ubuntu Live!) ==
== PostgreSQL Day July 22 ==
We will have a full day of sessions run by PDXPUG. See the PDXPUG Day page for sessions, schedule and other information.
This day will end in a party hosted by Command Prompt.
== Talks & Tutorials ==
The following Talks & Tutorials in the main OSCON program will be about PostgreSQL, tools which can be used with PostgreSQL, or by PostgreSQL community members:
* Pro PostgreSQL - Robert Treat
* Open Source Geospatial Boot Camp - Schuyler Erle
* SQLAlchemy - Taming ORM with Python Jonathan Ellis
* Data-mining from Open APIs - Toby Segaran
* Open Solutions Alliance Hack-a-thon 
* Performance Whack-a-Mole - Josh Berkus
* Advanced Production Troubleshooting - Theo Schlossnagle
* Next Generation Data Warehousing: Using Open APIs for Embedding Massively Parallel BI Analytics into the Data Warehouse - Luke Lonergan
* How I Learned to Stop Worrying and Love My Database: MySQL to PostgreSQL - Kevin Falcone
* Apache OFBiz, a Real-world Open Source ERP: Using the Power of Business to Your Benefit - Bruno Souza
* State of Lightning Talks - Josh Berkus
* PostgreSQL Gems: Running Perl and Ruby Inside the Database - David Fetter
* PDO: PHP Data Objects - Wez Furlong
* OSGeo: All About Maps - Aaron Racicot
* Nobody Ever Regretted Making a Backup - Dan Langille 
* Introduction to PL/PHP - Robert Treat
* Rich Internet Application Development for Dummies: Rob Napier
BOF: PostgreSQL Community Update, Room D135, Thursday, 7:30-8:30.
I'm sure I've missed a few, so please add to the list!
== Booth ==
Booth is open Wednesday and Thursday of the conference. The following people have committed to being there. If you can help email jd<at>commandprompt.com
Wednesday
9am Michael Brewer
10-11:30am David Fetter
11:30-1pm Erik Jones
1-2:30pm Rob Lemley, Gabrielle
2:30-4pm Chris Travers
4-5:30pm Josh Berkus
5:30-7pm Michael Brewer, Josh Berkus, Yi Ma, Jeff Davis
Thursday
10-11:30am 
11:30-1pm Erik Jones
1-2:30pm Chris Travers
2:30-4pm Josh Berkus, Noel Proffitt
== Commercial Participation ==
Command Prompt: Running community booth and helping run PGDay. Joshua, and Alvaro present.
Greenplum: Conference sponsor. Booth, Session
Sun: Conference sponsor. Booth, several sessions. Party.
EnterpriseDB: possibly present for OSA hack-a-thon. Booth?
Once Technologies: booth
Category:PostgreSQL Events
Oscon 2008 signup

*To keep the cohesive "Army of Smurfs" appearance, JD would like everyone to wear a PostgreSQL t-shirt while staffing the booth. If you do not already have one, one will be provided for you.
== Wed (10:00-16:30) (10am-4:30pm) ==
=== 10:45 - 11:30 ===
* Daniel Johnson
=== 11:35 - 12:15 ===
Robert Bernier
=== 12:20 - 13:40 LUNCH ===
* David Wheeler
=== 13:45 - 14:30 ===
* Greg Smith
=== 14:35 - 15:15 ===
* Greg Smith (Selena & Gabrielle are OUT)
=== 15:20 - 16:25 ===
Robert Bernier
=== 18:00 - 19:30 RECEPTION ===
* Not sure if we need somebody at the booth or not, but sign up if you feel like it.
== Thurs 10:00 - 17:00 (10am-5pm) ==
=== 10:45 - 11:30 ===
* Michael Ewan
=== 11:35 - 12:15 ===
=== 12:20 - 13:40 LUNCH ===
=== 13:45 - 14:30 ===
=== 14:35 - 15:15 ===
=== 15:20 - 16:25 ===
=== 16:30 - 17:00 ===
----
Thanks for participating!
Category:PostgreSQL Events
Oscon 2012 signup

* Sign up and email markwkm@postgresql with a t-shirt size by July 1 and we will try to have one waiting for you at the booth. 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.
== Tue July 17 (17:00-18:00) (5pm - 6pm) - Opening Reception ==
* Mark Wong
== Wed July 18 (10:00-16:30) (10am-4:30pm) ==
=== 10:00 - 11:15 ===
* Ed Snajder
* David Throckmorton
=== 11:15 - 12:50 LUNCH ===
=== 12:50 - 14:25 LUNCH ===
* Jesse Hallett <hallettj@gmail.com>
=== 14:25 - 15:15 ===
* wintel2006
=== 15:15 - 16:30 ===
== Thurs July 19 10:00 - 17:00 (10am-5pm) ==
=== 10:00 - 11:25 ===
* Ed Snajder
=== 11:25 - 12:50 LUNCH ===
=== 12:50 - 14:25 LUNCH ===
=== 14:25 - 16:00 ===
* wintel2006
=== 16:00 - 17:00 ===
----
Thanks for participating!
Category:PostgreSQL Events