pgsql-general - January 2018

General discussion area for users. Apart from compile, acceptance test, and bug problems, most new users will probably only be interested in this mailing list (unless they want to contribute to development or documentation). All non-bug related questions regarding PostgreSQL's version of SQL, and all installation related questions that do not involve bugs or failed compiles, should be restricted to this area. Please note that many of the developers monitor this area.

Search the Archives

(enter a message-id to go directly to that message)

Browse Archives

Prev | Next

Jan. 1, 2018

Thread Author Time
Re: is single row update improved with function Rob Sargent 00:04
Re: is single row update improved with function Rob Sargent 03:07
Re: invalid memory alloc request size 576460752438159360 Ibrahim Edib Kokdemir 13:12
Selecting a JSON object of arrays from a PostgreSQL table Alexander Farber 13:41
Re: Selecting a JSON object of arrays from a PostgreSQL table Ivan E. Panchenko 14:34
Re: Selecting a JSON object of arrays from a PostgreSQL table Alexander Farber 16:15
Slow system due to ReorderBufferGetTupleBuf? Martin Moore 16:56
Use of Port 5433 with Postgresql 9.6 Graeme 17:42
Re: Slow system due to ReorderBufferGetTupleBuf? Peter Geoghegan 17:44
Re: Use of Port 5433 with Postgresql 9.6 Karsten Hilbert 18:11
Re: Use of Port 5433 with Postgresql 9.6 Andreas Kretschmer 18:15
Re: Use of Port 5433 with Postgresql 9.6 Jeff Janes 18:40
Re: Use of Port 5433 with Postgresql 9.6 Paul Jungwirth 18:54

Jan. 2, 2018

Thread Author Time
Returning Values from INSERT ON CONFLICT DO NOTHING Igal Sapir 07:07
Re: Returning Values from INSERT ON CONFLICT DO NOTHING Igal Sapir 07:43
Re: Returning Values from INSERT ON CONFLICT DO NOTHING Jov 07:59
Select for update / deadlock possibility? Durumdara 08:22
Re: Selecting a JSON object of arrays from a PostgreSQL table Alexander Farber 09:28
MSSQL compatibility layer James Harper 11:24
Re: Select for update / deadlock possibility? Rakesh Kumar 11:31
PGPool encrypted connections from Application Vikas Sharma 11:36
Re: PGPool encrypted connections from Application Tatsuo Ishii 12:01
Re: Slow system due to ReorderBufferGetTupleBuf? Martin Moore 12:09
Re: Select for update / deadlock possibility? Durumdara 12:22
Re: MSSQL compatibility layer Thomas Kellerer 12:23
Re: Select for update / deadlock possibility? Jeff Janes 14:02
Re: Select for update / deadlock possibility? Durumdara 14:36
5 USD for PostgreSQL books at PacktPub Alexander Farber 15:13
Re: 5 USD for PostgreSQL books at PacktPub Vincenzo Romano 15:16
Re: Select for update / deadlock possibility? Tom Lane 15:23
Re: Use of Port 5433 with Postgresql 9.6 Graeme 16:37
Re: [PATCH] Logical decoding of TRUNCATE Marco Nenciarini 18:11
Re: Slow system due to ReorderBufferGetTupleBuf? Martin Moore 21:28
Error creating a table Dale Seaburg 22:38
Re: Error creating a table Joshua D. Drake 22:40
Need information on the tools available to upload the shape files to the postgreSQL database Ramamoorthi, Meenakshi 23:24
Re: Need information on the tools available to upload the shape files to the postgreSQL database James Keener 23:33

Jan. 3, 2018

Thread Author Time
Fwd: Query error: could not resize shared memory segment Thuc Nguyen Canh 00:22
Mailing list archiver Jordan Deitch 02:45
BDR: remove junk replication identifier milist ujang 03:51
Re: Query error: could not resize shared memory segment Thomas Munro 03:53
Re: Query error: could not resize shared memory segment Thuc Nguyen Canh 04:05
Re: Query error: could not resize shared memory segment Thomas Munro 04:13
Re: Query error: could not resize shared memory segment Thuc Nguyen Canh 04:22
Re: Query error: could not resize shared memory segment Tom Lane 04:39
Re: Query error: could not resize shared memory segment Thomas Munro 04:43
Re: Query error: could not resize shared memory segment Thuc Nguyen Canh 04:49
Re: Query error: could not resize shared memory segment Thomas Munro 05:05
Re: Query error: could not resize shared memory segment Thuc Nguyen Canh 05:13
Re: Query error: could not resize shared memory segment Thomas Munro 05:16
Re: Query error: could not resize shared memory segment Tom Lane 05:34
Re: Query error: could not resize shared memory segment Thuc Nguyen Canh 05:50
Re: Returning Values from INSERT ON CONFLICT DO NOTHING Igal Sapir 06:18
RE: Mailing list archiver Kellner Thiemo 07:27
Re: Mailing list archiver Michelle Konzack 10:19
Re: Mailing list archiver Magnus Hagander 10:28
Re: Mailing list archiver Peter J. Holzer 11:10
Re: Mailing list archiver Michelle Konzack 13:20
Re: Mailing list archiver Alvaro Herrera 13:50
Re: Mailing list archiver Jordan Deitch 14:00
Re: Mailing list archiver Michelle Konzack 14:15
Request to Enforce the password Strength for PostgreSQL Databases Goli, Vijay 14:53
Re: Mailing list archiver Steve Atkins 17:53
RE: Replication questions - read-only and temporary read/write slaves Jonathan Ruiz 18:43
Re: Deadlock between concurrent index builds on different tables Jeff Janes 18:43
Re: Mailing list archiver Ivan E. Panchenko 18:47
Re: Mailing list archiver Magnus Hagander 21:36
Re: Mailing list archiver Jordan Deitch 21:44

Jan. 4, 2018

Thread Author Time
Re: Request to Enforce the password Strength for PostgreSQL Databases Michael Paquier 04:45
Re: Replication questions - read-only and temporary read/write slaves Michael Paquier 04:52
Re: Pg Upgrade failing as it is not able to start and stop server properly kiran gadamsetty 08:19
Re: [PATCH] Logical decoding of TRUNCATE Simon Riggs 11:24
Re: Pg Upgrade failing as it is not able to start and stop server properly Bruce Momjian 15:24
Production Database requirement Azimuddin Mohammed 17:47
Re: Production Database requirement Francis Santiago 17:58
Re: Production Database requirement Vincenzo Romano 18:22
Re: Replication questions - read-only and temporary read/write slaves Tiffany Thang 18:58
Re: Production Database requirement Michelle Konzack 19:02
Bulk Insert/Update Scenario Mana M 19:39
Re: Bulk Insert/Update Scenario Jordan Deitch 20:43
Re: Bulk Insert/Update Scenario legrand legrand 21:19
Re: Bulk Insert/Update Scenario Mana M 21:47
Re: Bulk Insert/Update Scenario Jordan Deitch 22:03
Re: Replication questions - read-only and temporary read/write slaves Michael Paquier 23:04

Jan. 5, 2018

Thread Author Time
BDR PG9.4 Replica Identity Full ning chan 03:57
Re: [PATCH] Logical decoding of TRUNCATE 📎 Marco Nenciarini 15:46
What generates pg_config.h? Travis Allison 17:07
Re: What generates pg_config.h? Adrian Klaver 18:24
Postgres HA Azimuddin Mohammed 19:07
Re: Postgres HA Scott Marlowe 19:18
Re: Postgres HA Rui DeSousa 19:32
Re: What generates pg_config.h? Travis Allison 19:57
Re: What generates pg_config.h? Tom Lane 20:15
Re: What generates pg_config.h? Adrian Klaver 20:19
Re: What generates pg_config.h? rob stone 20:49
Re: What generates pg_config.h? Travis Allison 20:51
Re: Postgres HA Jehan-Guillaume (ioguix) de Rorthais 21:00
Re: What generates pg_config.h? Alvaro Herrera 21:27
Re: What generates pg_config.h? Tom Lane 22:56
Re: What generates pg_config.h? Travis Allison 23:03
Re: What generates pg_config.h? Tom Lane 23:29
Re: What generates pg_config.h? Adrian Klaver 23:40

Jan. 6, 2018

Thread Author Time
Re: Postgres HA John Scalia 01:07
Re: Postgres HA Tatsuo Ishii 02:09
Re: Postgres HA Azimuddin Mohammed 02:30
Re: What generates pg_config.h? Travis Allison 04:01
Re: What generates pg_config.h? Tom Lane 04:05
Re: What generates pg_config.h? Travis Allison 05:36
Ideas to deal with table corruption Luis Marin 10:11
Re: [PATCH] Logical decoding of TRUNCATE 📎 Marco Nenciarini 14:40
Re: What generates pg_config.h? Adrian Klaver 15:24
Re: What generates pg_config.h? Christoph Berg 15:42
Re: [PATCH] Logical decoding of TRUNCATE 📎 Marco Nenciarini 17:21
Re: Ideas to deal with table corruption Adrian Klaver 17:39
Re: Ideas to deal with table corruption Rui DeSousa 18:16
Re: Ideas to deal with table corruption Peter Geoghegan 18:23
Re: Ideas to deal with table corruption Melvin Davidson 18:30
Re: Ideas to deal with table corruption Corey Taylor 19:11
Re: Ideas to deal with table corruption scott ribe 19:14
Re: Ideas to deal with table corruption Rui DeSousa 19:59
Re: What generates pg_config.h? Travis Allison 20:36

Jan. 7, 2018

Thread Author Time
Two columns with same name in subselect--any way to SELECT without *? Ken Tanzer 04:46
Re: Two columns with same name in subselect--any way to SELECT without *? Adrian Klaver 05:10
Re: Two columns with same name in subselect--any way to SELECT without *? Ken Tanzer 05:16
Re: Two columns with same name in subselect--any way to SELECT without *? Ken Tanzer 07:01
Re: Two columns with same name in subselect--any way to SELECT without *? David G. Johnston 07:33

Jan. 8, 2018

Thread Author Time
Re: core system is getting unresponsive because over 300 cpu load pinker 00:35
Re: Pg Upgrade failing as it is not able to start and stop server properly Guru Prashanth Thanakodi 14:20
Materialized views in PGSQL 9.3 with replication on. Vikas Sharma 15:46
Re: Pg Upgrade failing as it is not able to start and stop server properly Tom Lane 16:32
Supartitions in PGSQL 10 Kumar, Virendra 21:12
Re: Supartitions in PGSQL 10 Thomas Kellerer 21:15
RES: Supartitions in PGSQL 10 Márcio A. Sepp 22:44
How Many Partitions are Good Performing Kumar, Virendra 23:20
Re: How Many Partitions are Good Performing Rakesh Kumar 23:54

Jan. 9, 2018

Thread Author Time
Re: How Many Partitions are Good Performing Michael Paquier 00:51
help with generation_series in pg10 Márcio A. Sepp 01:25
Re: help with generation_series in pg10 Adrian Klaver 05:19
Re: help with generation_series in pg10 David G. Johnston 05:42
Getting started with first user. Agnar Renolen 09:48
Re: help with generation_series in pg10 Alvaro Herrera 10:01
Re: help with generation_series in pg10 Vincenzo Romano 10:03
Sv: Re: [GENERAL] pg_dump streaming fails - PostgreSQL 9.2 Andreas Joseph Krogh 11:48
Re: Sv: Re: [GENERAL] pg_dump streaming fails - PostgreSQL 9.2 Jeff Janes 12:44
Number of rows returned by Sort node 📎 Vitaliy Garnashevich 15:20
Re: Number of rows returned by Sort node Tom Lane 15:23
Re: Getting started with first user. Adrian Klaver 16:13
Re: Getting started with first user. Jaime Soler 16:14
RES: help with generation_series in pg10 Márcio A. Sepp 16:14
Re: Getting started with first user. John McKown 16:17
Re: RES: help with generation_series in pg10 Alvaro Herrera 16:23
Re: Getting started with first user. Raymond O'Donnell 16:32
Re: Number of rows returned by Sort node Vitaliy Garnashevich 16:43
Re: How Many Partitions are Good Performing Andrew Staller 17:15
Re: Supartitions in PGSQL 10 Andrew Staller 17:20
RE: How Many Partitions are Good Performing Kumar, Virendra 17:21
Re: How Many Partitions are Good Performing Vincenzo Romano 17:25
data-checksums Rakesh Kumar 17:42
Re: data-checksums Stephen Frost 17:54
Re: data-checksums Rakesh Kumar 17:58
Re: data-checksums Andres Freund 18:39
Re: data-checksums Alvaro Herrera 18:41
Re: data-checksums Rakesh Kumar 19:02
Re: data-checksums Rakesh Kumar 19:04
Re: data-checksums Jeff Janes 19:20
Re: Getting started with first user. Agnar Renolen 19:20
Hi i like to unscribe me, sorry for the incovenient. Moises Lima dos Anjos 19:30
Re: data-checksums George Neuner 20:02
Re: data-checksums Andres Freund 20:22
Re: data-checksums Joshua D. Drake 20:37
Sv: Re: data-checksums Andreas Joseph Krogh 20:47
Re: Sv: Re: data-checksums Andres Freund 22:06
Sv: Re: Sv: Re: data-checksums Andreas Joseph Krogh 22:30
Re: Sv: Re: Sv: Re: data-checksums Rob Sargent 22:42
Sv: Re: Sv: Re: Sv: Re: data-checksums Andreas Joseph Krogh 23:25

Jan. 10, 2018

Thread Author Time
Re: Sv: Re: Sv: Re: Sv: Re: data-checksums Andres Freund 00:01
Sv: Re: Sv: Re: Sv: Re: Sv: Re: data-checksums Andreas Joseph Krogh 00:31
Re: Sv: Re: Sv: Re: Sv: Re: Sv: Re: data-checksums Stephen Frost 01:51
Re: Sv: Re: Sv: Re: Sv: Re: Sv: Re: data-checksums Andres Freund 01:55
Segmentation fault with core dump Glauco Torres 11:49
String comparison problem in select - too many results Durumdara 12:21
Re: help with generation_series in pg10 Merlin Moncure 14:19
Re: help with generation_series in pg10 Merlin Moncure 14:28
RES: help with generation_series in pg10 Márcio A. Sepp 15:22
Re: String comparison problem in select - too many results David G. Johnston 15:25
Re: How Many Partitions are Good Performing pinker 17:06
Re: Segmentation fault with core dump Tom Lane 17:08
Re: Segmentation fault with core dump Merlin Moncure 17:13
Re: Segmentation fault with core dump Alvaro Herrera 17:37
Re: Segmentation fault with core dump Tom Lane 17:41
Re: Segmentation fault with core dump Alvaro Herrera 17:47
Re: Segmentation fault with core dump Glauco Torres 18:04
Re: Segmentation fault with core dump Tom Lane 18:12
Re: Segmentation fault with core dump Glauco Torres 18:21
Re: Segmentation fault with core dump Tom Lane 18:38
Re: Sv: Re: Sv: Re: Sv: Re: Sv: Re: data-checksums Andres Freund 19:39
Re: Sv: Re: Sv: Re: Sv: Re: Sv: Re: data-checksums Thomas Poty 20:23
Re: Sv: Re: Sv: Re: Sv: Re: Sv: Re: data-checksums Jeff Janes 21:36
Sv: Re: Sv: Re: Sv: Re: Sv: Re: Sv: Re: data-checksums Andreas Joseph Krogh 21:59
RE: How Many Partitions are Good Performing 📎 Kumar, Virendra 22:33

Browse Archives

Prev | Next