nyuuzyou/wikis huggingface dataset:
PostgreSQL 8.4

PostgreSQL 8.4 was released on July 1, 2009.
==Release activity archive==
* PostgreSQL 8.4 Development Plan
* Wishlist for 8.4
* Waiting for 8.4 - commentary on commits
* Beta 2 Major Changes List
* PostgreSQL 8.4 Open Items
* 84ReleaseDraft
* WhatsNew84
* 8.4 Release Notes
Category:PostgreSQL 8.4
PostgreSQL 8.4 Development Plan

This is a copy of the email sent to -hackers on 2008-02-06 outlining the core team's plan for attacking the 8.4 development cycle.
----
Hackers,
As you know we've finally released PostgreSQL 8.3, after a development
cycle that lasted well over a year despite our original plans for a 6
month cycle. The core team are aware that there are a number of
factors that contributed to this slippage:
*Lack of prompt and early review of patches.
*A significant rise in the number and complexity of patches submitted.
*Prioritising completion of incomplete patches over meeting the timetable.
In the 8.4 development cycle we would like to try a new style of
development, designed to keep the patch queue to a limited size and to
provide timely feedback to developers on the work they submit. To do
this we will replace the traditional 'feature freeze' with a series of
'commit fests' throughout the development cycle. The idea of commit
fests was discussed last October in -hackers, and it seemed to meet
with general approval. Whenever a commit fest is in progress, the
focus will shift from development to review, feedback and commit of
patches. Each fest will continue until all patches in the queue have
either been committed to the CVS repository, returned to the author
for additional work, or rejected outright, and until that has
happened, no new patches will be considered. Of course, individual
developers are free to continue working on their
patches throughout the fest, but we encourage everyone to do what they
can to help work through the patch queue. We feel that this idea can
only be successful if the whole development community is willing to
focus on patch review during the commit fests, in the same way that
everyone is expected to focus on testing during beta period.
The proposed timetable for the cycle is as follows:
*1st March 2008 - commit fest begins
*1st May 2008 - commit fest begins
*1st July 2008 - commit fest begins
*1st September 2008 - commit fest begins
*1st November 2008 - final commit fest begins
*1st January 2009 - beta 1
*1st March 2009 - 8.4.0 release
Note the lack of any 'feature freeze' date as such. However, any
significant feature patches not submitted by 1st November will clearly
not make it into 8.4.
The hope here is that we will not have enormous, previously unreviewed
patches landing on us at the end of October --- if that happens, we'll
be back in the same position we were in at 8.3 feature freeze.
Although this schedule allows for the final commit fest to take a good
deal of time, we'll reserve the right to reject patches that are too
large to be reviewed in a timely fashion. We want to encourage people
to do development of large features in an incremental fashion, with a
new increment landing during each commit fest.
Category: PostgreSQL 8.4
PostgreSQL 9.1 Development Plan

This is the currently planned timeline for the PostgreSQL 9.1 development cycle, which was mainly agreed upon at the PgCon 2010 Developer Meeting. The schedule basically follows the 8.5/9.0 timeline plus one year, with small changes.
* June 15, 2010 - July 15, 2010: "review fest", like a commit fest, but only reviews, no committing yet; intended for contributors who are not involved in preparing 9.0 release
* July 1, 2010: branch off 9.0, committing into head/trunk/master for 9.1 can begin (likely delayed for a few days until after 9.0beta3)
* July 15, 2010 - August 15, 2010: commit fest 1
* around August 17-20, 2010: Switching PostgreSQL from CVS to Git
* around August 20, 2010: 9.1alpha1 release
* September 15, 2010 - October 15, 2010: commit fest 2
* around October 20, 2010: 9.1alpha2 release
* November 15, 2010 - December 15, 2010: commit fest 3
* around December 20, 2010: 9.1alpha3 release
* January 15, 2011 - February 15, 2011: commit fest 4
* around February 20, 2011: 9.1alpha4 release
* followed by possibly more alpha releases
* beta
* release candidates
* release
Category:PostgreSQL 9.1
PostgreSQL 9.2 Development Plan

The timeline for the PostgreSQL 9.2 development cycle was initially planned at the PgCon 2011 Developer Meeting. The schedule is based on the 9.1 timeline moved forward one year, with some optimizations from on developer feedback.
* June 1, 2011: branch off 9.1, committing into head/trunk/master for 9.2 can begin.
* June 15, 2011 - July 14, 2011: commit fest 1. Primarily for contributors who are not involved in preparing the 9.1 release.
* Around July 15, 2011: 9.2alpha1 release
* September 15, 2011 - October 15, 2011: commit fest 2
* Around October 20, 2011: 9.2alpha2 release
* November 15, 2011 - December 15, 2011: commit fest 3
* Around December 20, 2011: 9.2alpha3 release
* January 15, 2012 - February 15, 2012: commit fest 4
* Around February 20, 2012: 9.2alpha4 release
* Followed by possibly more alpha releases
* Beta
* Release candidates
* Release
Category:PostgreSQL 9.2
PostgreSQL 9.3 Development Plan

The timeline for the PostgreSQL 9.3 development cycle was initially planned at the PgCon 2012 Developer Meeting. The schedule is based on the 9.2 timeline moved forward one year, with some optimizations based on developer feedback.
* June 1, 2012: branch off 9.2, committing into head/trunk/master for 9.3 can begin.
* June 15, 2012 - July 15, 2012: commit fest 1. Primarily for contributors who are not involved in preparing the 9.2 release.
* September 15, 2012 - October 15, 2012: commit fest 2
* November 15, 2012 - December 15, 2012: commit fest 3
** Dec 8-15 Final feature planning week
* January 15, 2013 - February 15, 2013: commit fest 4
** Final Triage: Feb 1–7 
* Around February 20, 2013: 9.3 alpha release
* Possibly more alpha releases
* Beta releases
* Release candidates
* Release
Category:PostgreSQL 9.3
PostgreSQL 9.3 Open Items

== Project Planning ==
See the PostgreSQL 9.3 Development Plan.
== Blockers for 9.3 ==
* Improve the 
== Not Blockers for 9.3 ==
* Consider whether COPY into newly created tables should ALWAYS freeze, perhaps only when checksums enabled - requested by Noah, Robert
* 
** If we don't fix it, we should minimally update the limitations section in the docs.
* 
== Meta-Issues ==
== Resolved Issues ==
* Restructure ProcessUtility to fix event-trigger clobber-cache-always failures
* Agree on the new page checksum algorithm
* Fix planner 
* pg_ctl's new idempotent option broke crash recovery cases
* VACUUM breaks matview scannability state
* Do something about 
* Another assertion failure at promotion
* Assertion failure when promoting node by deleting recovery.conf and restart node
* fast promotion and log_checkpoints - trivial cosmetic issue; not a bug of any kind
* Fast promotion failure
* Restore protection against accidentally creating stuff in pg_catalog schema
** There are a couple of ways to fix that, per thread, but we need to do something.
** As a quick fix, reverted commit a475c603.
* pg_isready doesn't handle conninfo properly
* Agree on API for testing view and foreign table updatability
* Bug with .
* Optimizer in some LATERAL queries.
* around adding constraints to materialized views
* 
== Long-term Issues ==
Category:PostgreSQL 9.3
Category:Open_Items
Postgresql93press

= Press Coverage for 9.3 Release =
== English ==
* Hacker News
* ZDnet
* PC World
* ReadWriteWeb
* LWN
* iProgrammer
== German ==
* Heise
* OSS Directory
* Pro-Linux.de
== Italian ==
* Press Release
== French ==
* Clubic.com
* Le Monde informatique
* Interview with Dimitri
* Interview with JPA
* le Journal Du Net 
* Programmez
* ITRpress
* Linuxfr
* Développez
* inspyration
* Solutions IT & Logiciels
== Japanese ==
* Japanese Blog
* Sourceforge
== Russian ==
* Cybersecurity.ru
* PCWeek
== Bulgarian ==
* IDG
== Czech ==
* Root.cz
== Chinese ==
* CSDN Headlines
* ITEYE News
* LinuxEden News
* Geek Headlines
* Blogger 
== Spanish ==
* PostgreSQL Cuba
* Centro Virtual de Recursos
* Sitio Formación y Desarrollo FORDES
== Portuguese ==
* Br-Linux
* Imasters
PostgreSQL 9.4 Open Items

== Open Issues ==
== Not fixing for 9.4 ==
* autovacuum scheduling starvation and frenzy This issue is not new to 9.4, and there are no proposed patches for it.
== Resolved Issues ==
* Missing FIN_CRC32 calls in logical replication code
* numeric_normalize() is wrong, breaking JSONB GIN index behavior
* TAP tests still have some pretty severe problems
* Remove xloginsert_slots/xloginsert_locks GUC
* jsonb data format doesn't work well with toast compression
* Immediate shutdown no longer removes backup_label if backup is in progress
* Revisit default of 4x shared buffers for effective_cache_size
* Bgworker process exit code definitions aren't very sane
* assertion when palloc'ing within a critical section
* prohibit data_directory to be set via Alter System
* the client program tests don't work in vpath builds
* ALTER SYSTEM has issues with PGC_POSTMASTER parameters
* HEAD crashes with assertion and LWLOCK_STATS enabled
* psql output in expanded+wrapped mode has some issues 
* Broken pg_operator info for JSONB operators
* option -T in pg_basebackup doesn't work on windows
* vacuumdb --all --analyze-in-stages - wrong order (fix)
* log_statement and ALTER SYSTEM (fix)
* pg_dump fails with --if-exists and blobs
* GIN fast scan and compression loose ends:
** Cost estimation needs to be fixed (first issue resolved, second moved to TODO)
* psql output change in 9.4
* Remove PQhostaddr()
Category:PostgreSQL_9.4
Category:Open_Items
PostgreSQL and SELinux

It can be very difficult to get a PostgreSQL database running with SELinux (which is most commonly used on RedHat installations). Here are some comments and documents on this topic:
*SELinux strangeness with 8.1.2 and 8.1.3
*Postgresql does not start on reboot
* SELinux + CREATE TABLESPACE?
*Typically I recommend you disable SELinux...
*Permission problem with create tablespace
*Fedora Core 5 SELinux FAQ
* Moving your PGDATA directory to /home in Fedora 17
Category:SELinux
PostgreSQL Conference 2009 Japan

= PostgreSQL Conference 2009 Japan =
The annual PostgreSQL Conference will be held in Japan this year, in celebration of the 10th anniversary of the Japanese PostgreSQL Users Group.
Please consult the main conference page on their website:
http://www.postgresql.jp/events/pgcon09j/e/pgcon2009j
See also: PGCon2009JapanClusterDeveloperMeeting
== Date ==
November 20th - 21st, 2009, schedules for both days are available in English on the conference page cited above.
== Location ==
AP Hamamatsucho is a convention hall, they offer a map with some additional helpful information. This seems to be the place on Google.
== Transportation ==
Citing Koichi-San: "Narita airport is very far from central area of Tokyo. My experience is: by bus, it takes about more than an hour from the airport to the bus terminal, next to a subway station, and will take another half hour to the venue."
An english web schedule is available from Hyperdia or Train Route Finder. Searching for "Narita Airport" to "Hamamatsucho" gives a 1.5 hour journey with 1 transfer.
The Narita Express train is probably the easiest way to get to Tokyo from the airport.
The one indispensible thing to get before you leave for Tokyo is a map and subway map in your native language. While individual signs in the subways and other locations are often transliterated, often the subway maps in the stations are not, and non-Japanese subway maps can be hard to purchase in Tokyo.
== Lodging ==
Recommendations from AP Hamamatsuchō, here with Links to the hotel's English site, prices for the least expensive single room offered:
* 東急ステイ 新橋 Tokyu Stay Shimbashi, http://www.tokyustay.co.jp/e/hotel/SHI/, @ 8'800 JPY
* 芝大門ホテル Daimon Hotel, http://www.shibadaimonhotel.co.jp/e/ @ 9'030 JPY
* 芝パークホテル Shiba Park, http://www.shibaparkhotel.com/en/ @ 8'316 JPY
* メルパルク東京 Tokyo MIELPARQUE, http://www.mielparque.jp/tky/eng.html @ 8'800 JPY
* 東京プリンスホテル Tokyo Prince, http://www.princehotels.com/en/tokyo/ @ 14'500 JPY
* セレスティンホテル Celestine Hotel, http://www.celestinehotel.com/en/index.html @ 10'996 JPY
* Park Hotel Tokyo, http://www.parkhoteltokyo.com/ @ 11'000 JPY
Currently, Dave, Magnus and Stefan are at the Park Hotel Tokyo. Josh, Jeff, DF and Markus are at the Shiba Park. Depending, we may consolidate to one hotel; check here for updated details or e-mail people.
== Weather ==
Same time, last year: weather history. In short: expect about 10-14 °C, always a bit windy but not much rain.
Category:PostgreSQL Events
PostgreSQL Conference Europe Talks 2011

= PostgreSQL Conference Europe 2011 Talks =
== Talks: Wednesday 19th October, 2011 ==
=== Ams 1 ===
* 
* Vincent Picavet - Geo in your database : Postgis
* Heralding the Death of nosql — Will Leinweber, Heroku — http://pgeu-plv8.herokuapp.com
* Slony Troubleshooting - Steve Singer, Afilias 
=== Ams 2 ===
* Yeb Havinga: Introducing ISO-21090 Healthcare Datatypes
* Dave Page: PostgreSQL at the centre of your dataverse
* Gilles Darold: Best practices with Ora2Pg
=== Ams 3 ===
* Magnus Hagander, PostgreSQL 9.1 - What's New
* 
** plus four 2D heat diffusion movies, with different starting scenarios: a hot point,
** a hot segment,
** a hot square and
** a cold square.
* Explaining the Postgres Query Optimizer
* Simon Riggs and Greg Smith: Synchronous Replication and Durability Tuning
* 
== Talks: Thursday 20th October, 2011 ==
=== Ams 1 ===
* 
* A Postgres Service (Peter van Hardenberg, Heroku) http://pgconfeu11-service.herokuapp.com/
* 
* 
* 
=== Ams 2 ===
* 
* Exposing the Power of Postgres to Ruby — Will Leinweber, Heroku — http://pgeu-ruby.herokuapp.com
* Jonathan S. Katz: Writing Django Extensions for PostgreSQL
* 
=== Ams 3 ===
* Greg Smith: Improving VACUUM Suction
* 
* Guillaume Lelarge, What use are the statistics views?
* Lightning talk: 
== Talks: Friday 21st October, 2011 ==
=== Ams 1 ===
* Reliable Databases in The Cloud with WAL-E (redux) - Dan Farina, Heroku - http://wal-e-pgeu2011.herokuapp.com/
* Jonathan S. Katz: Accelerating Local Search With PostgreSQL 9.1
=== Ams 2 ===
* Michael Meskes: Mission Impossible?
=== Ams 3 ===
* Greg Smith: Bottom-Up Database Benchmarking
* Magnus Hagander: The PostgreSQL Replication Protocol, Tools and Opportunities
* Bruce Momjian: Closing Keynote
Category:PostgreSQL Europe
PostgreSQL Conference Europe Talks 2012

= PostgreSQL Conference Europe 2012 Talks =
== Trainings: Tuesday 23th October, 2012 ==
=== Clyde ===
* Mastering PostgreSQL Administration (Bruce Momjian, Devrim GÜNDÜZ)
=== Seine ===
* PostgreSQL Performance Training (Greg Smith, Peter Geoghegan)
* PostgreSQL Replication Training (Dimitri Fontaine, Simon Riggs)
=== Thames ===
* Implementace uložených procedur v PostgreSQL (Pavel Stehule)
* Čtení exekučních plánů (Tomas Vondra)
=== Vltava ===
* A day of SQL with Celko (Joe Celko)
== Talks: Wednesday 24th October, 2012 ==
=== Bellevue ===
* Opening keynote (Joe Celko)
=== Seine ===
* Programming the SQL Way with Common Table Expressions (Bruce Momjian)
* PostgreSQL on AWS (Christophe Pettus)
* Understanding EXPLAIN's output (Guillaume Lelarge)
* Boosting Performance and Reliability by using pgpool-II (Tatsuo Ishii)
* CREATE EXTENSION pgchess; (Gianni Ciolli)
=== Thames ===
* 
* MultiMaster Replication: Applications, Comparison, Implementation (Andres Freund, Simon Riggs)
* (Sebastian 'tokkee' Harl)
* 
* High availability in Postgres-XC, the symmetric PostgreSQL cluster (Koichi Suzuki)
=== Vltava ===
* Provoz PostgreSQL na AWS (Tomas Vondra)
* 
* Migrace z MySQL na PostgreSQL (Tomas Vondra)
* 
* Load dat do PostgreSQL (Jan Holčapek)
== Talks: Thursday 25th October, 2012 ==
=== Bellevue (Lightning Talks) ===
* 
* 
* PGQ Cooperative Consumers (Dimitri Fontaine & Marko Kreen)
* PostgreSQL Drinking Game (Josh Berkus)
=== Seine ===
* How fast is PostgreSQL? (Cédric Villemain)
* Implementing High Availability (Dimitri Fontaine)
* Inside PostgreSQL Shared Memory (Bruce Momjian)
* Embracing the Web with JSON and PLV8 (Will Leinweber)
=== Thames ===
* Topology and network analysis with PostgreSQL and PostGIS (Vincent Picavet)
* 
* PostGIS 2.0 and beyond (Vincent Picavet)
* Practical Tips for Better PostgreSQL Applications (Marc Balmer)
* Pacemaker and PostgreSQL: to serve and protect your data (Jehan-Guillaume (ioguix) de Rorthais)
=== Vltava ===
* 
* Java Stored Procedure Wrapper and PGObserver (Jan Mussler)
* Elephants and Windmills (Josh Berkus)
* 
* Index support for regular expression search (Alexander Korotkov)
== Talks: Friday 26th October, 2012 ==
=== Bellevue ===
* Postgres Adoption at the Tipping Point: Users Around the World and Their Deployment Profile (Ed Boyajian)
* Community PostgreSQL (Simon Riggs, Harald Armin Massa)
* Closing (Dave Page)
=== Seine ===
* Beyond Query Logging (Greg Smith, Peter Geoghegan)
* PostgreSQL Backup Strategies (Magnus Hagander)
* Maintaining Very Large Databases (VLDs) (Devrim GÜNDÜZ)
* Large Scale MySQL Migration to PostgreSQL (Dimitri Fontaine)
=== Thames ===
* 
* 
* Debugging complex SQL queries with writable CTEs (Gianni Ciolli)
* Limiting PostgreSQL resource consumption using the Linux kernel (Hans-Jürgen Schönig)
=== Vltava ===
* 
Category:PostgreSQL Europe
* PostgreSQL makes dev happy, a pgAgent + pl/pgsql use case (Julien Rouhaud)
* 
Category:PostgreSQL Europe
* Using PostgreSQL for storing time-series data (Sebastian 'tokkee' Harl)
Category:PostgreSQL Events
PostgreSQL Conference Europe Talks 2018

Most Slides can be retrieved visiting the website of the conference:
https://www.postgresql.eu/events/pgconfeu2018/schedule/
Follow the links to the talks in the schedule. If speakers have delivered their slides, you will find them there.
Here are direct links to the same slides (alphabetical order):
* Lætitia Avrot, Be efficient, Use PSQL
* Charles Clavadetscher, Time Related Range Types Revisited
* Dimitri Fontaine, Data Modeling, Normalization and Denormalisation
* Andreas Scherbaum, Tour de (PostgreSQL) Data Types
* Rubens Souza, Fast, not furious - What a benchmark can tell you
* Gülçin Yıldırım Jelínek, PostgreSQL is NOT your traditional SQL database
PostgreSQLConferenceWest2008

== Papers from PostgreSQL Conference West 2008 ==
* David Fetter, OLAP Made Easy: Windowing Functions in SQL
* David Fetter, Trees and More in SQL
* Tom Raney, Planner Exposed
* Joshua Tolley, Creating a PL in PostgreSQL
* Matt Trout, Catalyst, DBIx::Class and PostgreSQL
* Matt Trout, Perl5's Alive!
* Joshua Williams, Proprietary to PostgreSQL
* Richard Broersma, Hierarchical Data Modeling
== Lightning Talks ==
* 
* 
* 
* 
* 
Category:PostgreSQL Events
PostgreSQL Data Access Components

== About ==
PostgreSQL Data Access Components (PgDAC) is a library of components that provides native connectivity to PostgreSQL from Delphi, C++Builder, Lazarus (and Free Pascal) on Windows, Mac OS X, iOS, Android, Linux, and FreeBSD for both 32-bit and 64-bit platforms. PgDAC is designed to help programmers develop really lightweight, faster and cleaner PostgreSQL database applications without deploying any additional libraries.
== Key Features: ==
* Direct Mode Allows your application to work with PostgreSQL directly without involving PostgreSQL connectivity solutions, thus significantly facilitating deployment and configuration of your applications.
* Mobile Development Develompent for iOS and Android mobile devices using PgDAC becomes still easier, as PgDAC allows your mobile applications to work with PostgreSQL database as simply as desktop applications do.
 
* DB Compatibility PostgreSQL Data Access Components supports the latest PostgreSQL server versions up to 10.0. We also provide compatibility with Microsoft Azure Database for PostgreSQL.
* IDE Compatibility PostgreSQL Data Access Components is compatible with the latest IDE versions: Embarcadero RAD Studio 10.2 Tokyo, Delphi 10.2 Tokyo, C++Builder 10.2 Tokyo, Lazarus (and FPC). It is also compatible with the previous IDE versions since Delphi 6 and C++Builder 6.
* Data Type Mapping If you want to make custom correspondence between PostgreSQL and Delphi data types, you can use a simple and flexible Data Type Mapping engine provided by PgDAC.
* Development Platforms Now you can develop not only VCL-based applications in Delphi and LCL-based ones in Lazarus, but also use the newest FireMonkey application development platform.
* Performance All our components and libraries are designed to help you write high-performance, lightweight data access layers, therefore they use advanced data access algorithms and techniques of optimization.
* Monitoring Use Devart freeware dbMonitor tool to monitor and analyze all the DB calls made by your application using PostgreSQL data access components. dbMonitor performs per­component tracing of SQL statement execution, commits, rollbacks, etc.
[[Category:Tool]
PostgreSQL Gotchas

=psql=
==Listing objects in schemas not in the search path==
If you have a table in a schema named my_schema, you cannot see it using \dt unless you type:
\dt *.*
to list all tables in all schemas, or
\dt my_schema.*
to list all tables in a my_schema.
To include the schema in the search path, type:
SET search_path TO my_schema,public;
Category:Tool
PostgreSQL Meetup Geneve 2018 Oct

Le Meetup PostgreSQL à Genève était intitulé : First PostgreSQL meetup in Geneva.
Nous avons eu le plaisir de suivre les quatre présentations suivantes :
* «PostgreSQL pour les débutants» par Leatitia Avrot
* «Periods et les tables versionnées» par Vik Fearing
* Fluidifier ses transferts de données avec PostgreSQL par Cédric Villemain
* Disponibilité de service avec PostgreSQL par Fabrice Chapuis
PostgreSQL Meetup Geneve 2019 Oct

Meetup PostgreSQL à Genève Postgres - Industrialistation et Haute Disponibilité 
Nous avons eu le plaisir de suivre les quatre présentations suivantes :
* TemBoard - Pierre Giraud - Dalibo 
* La réplication encore plus facile - Pierre Boizot - freelance
* OpenDB Appliance - Pierre Sicot - Dbi-Services
* Déploiement automatisé d'un cluster Postgres: Fabrice Chapuis - Banque Lombard Odier
PostgreSQL Meetup Paris 2014 Sept

Le Meetup PostgreSQL à Paris était intitulé : PostgreSQL : DBA et Développeurs enfin réunis.
Nous avons eu le plaisir de suivre les quatre présentations suivantes :
* Agrégation temporelle sous contrainte d'IOPS par Jean-Gérard Pailloncy
* Le partitionnement de tables démystifié, par Flavio Henrique Araque Gurgel
* PoWA, par Thomas Reiss et Julien Rouhaud
* PostgreSQL pour les développeurs, par Dimitri Fontaine