pgsql-general - October 2019

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)
Advanced Search

Browse Archives

Prev | Next
Jump to day: 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31

Oct. 1, 2019

Thread Author Time
[QUESTION] Set /MD flag on Windows Build? Nicolas Lehman 01:09
Query Tuning Sonam Sharma 07:12
Re: pg12 rc1 on CentOS8 depend python2 Christoph Berg 07:57
Re: Query Tuning Kyotaro Horiguchi 09:15
fetch time included in pg_stat_statements? Ayub M 09:25
Schema dump/restore not restoring grants on the schema Mike Roest 12:02
Re: "Failed to connect to Postgres database" : No usage specified for certificate (update) Adrian Klaver 14:28
Re: Schema dump/restore not restoring grants on the schema Tom Lane 14:53
Re: Schema dump/restore not restoring grants on the schema Mike Roest 15:49
Support for SLES 15 and PostgreSQL 11.x Steve Williams 16:09
Re: Schema dump/restore not restoring grants on the schema Adrian Klaver 18:08
Re: Schema dump/restore not restoring grants on the schema Adrian Klaver 18:12
Re: Behaviour adding a column with and without a default (prior to PG11) Joe Horsnell 19:25
Users, Roles and Connection Pooling Matt Andrews 22:46

Oct. 2, 2019

Thread Author Time
Re: pg_receivexlog or archive_command Stephen Frost 06:16
Re: pg_receivexlog or archive_command Stephen Frost 06:17
Re: Users, Roles and Connection Pooling Laurenz Albe 07:36
Re: Users, Roles and Connection Pooling Stephen Frost 07:43
Re: Users, Roles and Connection Pooling Matt Andrews 09:41
Re: Users, Roles and Connection Pooling Rob Sargent 11:03
Re: Users, Roles and Connection Pooling Matt Andrews 11:21
A post describing PostgreSQL 12 Generated Columns Pankaj Jangid 12:39
Questions about Partitioned Tables and Indexes Evelyn Dibben 13:04
Performance on JSONB select PegoraroF10 14:37
Re: Possible bug: SQL function parameter in window frame definition Andrew Gierth 15:24
Re: Possible bug: SQL function parameter in window frame definition Tom Lane 15:32
PG11 Parallel Thanks!! Jason Ralph 15:41
Re: Performance on JSONB select Michael Lewis 16:13
Re: Possible bug: SQL function parameter in window frame definition Andrew Gierth 16:20
Re: Possible bug: SQL function parameter in window frame definition Tom Lane 16:31
Re: Possible bug: SQL function parameter in window frame definition 📎 Andrew Gierth 16:50
Re: Possible bug: SQL function parameter in window frame definition Tom Lane 16:56
Re: Possible bug: SQL function parameter in window frame definition Andrew Gierth 17:15
Re: Possible bug: SQL function parameter in window frame definition Tom Lane 17:21
Urgent :: Postgresql streaming replication issue - sync mode Shital A 18:28
Re: Urgent :: Postgresql streaming replication issue - sync mode Ravi Krishna 18:38
Re: Users, Roles and Connection Pooling Stephen Frost 18:44
Drop a primary Martin Mueller 18:48
Re: Drop a primary Ron 18:52
Re: Query Tuning Michael Lewis 19:32
partitions vs indexes Enrico Thierbach 20:09
Re: partitions vs indexes Enrico Thierbach 20:11
Re: partitions vs indexes Michael Lewis 20:16
Wall shiping replica failed to recover database with error: invalid contrecord length 1956 at FED/38FFE208 Aleš Zelený 20:19
Re: Performance on JSONB select PegoraroF10 20:41
Re: Urgent :: Postgresql streaming replication issue - sync mode Shital A 21:00
Re: Performance on JSONB select Stephen Frost 21:57
Re: Wall shiping replica failed to recover database with error: invalid contrecord length 1956 at FED/38FFE208 Stephen Frost 22:09
performance of pg_upgrade "Copying user relation files" Glenn Pierce 22:30
Re: Questions about Partitioned Tables and Indexes legrand legrand 22:37
Re: performance of pg_upgrade "Copying user relation files" Adrian Klaver 23:11
Re: performance of pg_upgrade "Copying user relation files" Adrian Klaver 23:16
Re: Wall shiping replica failed to recover database with error: invalid contrecord length 1956 at FED/38FFE208 Tom Lane 23:23
Re: Wall shiping replica failed to recover database with error: invalid contrecord length 1956 at FED/38FFE208 Stephen Frost 23:24
Re: Users, Roles and Connection Pooling raf 23:27
Re: Users, Roles and Connection Pooling Rob Sargent 23:49

Oct. 3, 2019

Thread Author Time
Re: performance of pg_upgrade "Copying user relation files" Adrian Klaver 00:47
Re: Urgent :: Postgresql streaming replication issue - sync mode Shital A 03:00
Re: PG11 Parallel Thanks!! Pankaj Jangid 04:58
Re: Users, Roles and Connection Pooling raf 05:10
Re: PG11 Parallel Thanks!! Peter Geoghegan 05:26
psql \copy hanging Arnaud L. 06:51
Re: Wall shiping replica failed to recover database with error: invalid contrecord length 1956 at FED/38FFE208 Aleš Zelený 07:44
Advice for geographically dispersed multi master Nikolai Lusan 09:05
Re: partitions vs indexes Enrico Thierbach 10:29
Re: Advice for geographically dispersed multi master Thomas Kellerer 10:40
PMChildFlags array bhargav kamineni 10:57
Re: Advice for geographically dispersed multi master Laurenz Albe 11:20
Re: partitions vs indexes Laurenz Albe 11:34
Re: Urgent :: Postgresql streaming replication issue - sync mode Laurenz Albe 11:41
Re: PMChildFlags array bhargav kamineni 12:23
Re: PMChildFlags array Adrian Klaver 13:26
Re: performance of pg_upgrade "Copying user relation files" Adrian Klaver 13:46
Re: psql \copy hanging Adrian Klaver 13:54
Re: psql \copy hanging Arnaud L. 14:13
Re: psql \copy hanging Adrian Klaver 14:32
Re: Urgent :: Postgresql streaming replication issue - sync mode Jason Wang 14:34
Re: Urgent :: Postgresql streaming replication issue - sync mode Laurenz Albe 15:34
Re: PMChildFlags array bhargav kamineni 15:53
PG12 Igor Neyman 16:27
RE: PG12 Igor Neyman 16:31
Re: PG12 Adrian Klaver 16:31
Re: PMChildFlags array Tom Lane 17:22
RE: PG11 Parallel Thanks!! Jason Ralph 17:31
Re: PMChildFlags array bhargav kamineni 17:31
Re: PG12 Magnus Hagander 19:01
BitmapAnd on correlated column? greigwise 21:22
Re: BitmapAnd on correlated column? Rob Sargent 21:26
Re: BitmapAnd on correlated column? greigwise 21:39
Re: PMChildFlags array Tom Lane 22:19
Re: PMChildFlags array Alvaro Herrera 22:38

Oct. 4, 2019

Thread Author Time
Re: pg12 rc1 on CentOS8 depend python2 keisuke kuroda 01:03
Re: psql \copy hanging Arnaud L. 07:19
Archive_clean Sonam Sharma 08:04
Re: Archive_clean Laurenz Albe 08:47
Re: BitmapAnd on correlated column? Laurenz Albe 08:59
Postgres 12: backend crashes when creating non-deterministic collation Thomas Kellerer 10:13
Clarification on the release notes of postgresql 12 regarding pg_upgrade Marcelo Lacerda 13:00
Re: BitmapAnd on correlated column? greigwise 13:19
Perl DBI converts UTF-8 again to UTF-8 before sending it to the server Matthias Apitz 13:25
Re: BitmapAnd on correlated column? Tom Lane 13:35
Re: Postgres 12: backend crashes when creating non-deterministic collation Laurenz Albe 14:04
Re: Clarification on the release notes of postgresql 12 regarding pg_upgrade Laurenz Albe 14:06
Re: Clarification on the release notes of postgresql 12 regarding pg_upgrade Josef Šimánek 14:13
Re: Postgres 12: backend crashes when creating non-deterministic collation Thomas Kellerer 14:21
Re: Perl DBI converts UTF-8 again to UTF-8 before sending it to the server Christoph Moench-Tegeder 14:29
Unexpected plan width with foreign data wrapper Dmitry Bogatov 14:35
Re: Postgres 12: backend crashes when creating non-deterministic collation Daniel Verite 14:44
Re: Postgres 12: backend crashes when creating non-deterministic collation Andreas Kretschmer 14:51
Re: Postgres 12: backend crashes when creating non-deterministic collation Tom Lane 14:52
Pg11 -- MultiXactId xxxx has not been created yet -- apparent wraparound 📎 Moreno Andreo 14:57
Re: Postgres 12: backend crashes when creating non-deterministic collation Andres Freund 15:06
Re: Perl DBI converts UTF-8 again to UTF-8 before sending it to the server Matthias Apitz 15:07
Re: Perl DBI converts UTF-8 again to UTF-8 before sending it to the server Christoph Moench-Tegeder 15:22
Re: Pg11 -- MultiXactId xxxx has not been created yet -- apparent wraparound Alvaro Herrera 15:30
Re: Pg11 -- MultiXactId xxxx has not been created yet -- apparent wraparound 📎 Moreno Andreo 16:01
Re: Clarification on the release notes of postgresql 12 regarding pg_upgrade Tom Lane 16:09
Re: Pg11 -- MultiXactId xxxx has not been created yet -- apparent wraparound Alvaro Herrera 16:28
Re: Clarification on the release notes of postgresql 12 regarding pg_upgrade Peter Geoghegan 16:43
Re: Postgres 12: backend crashes when creating non-deterministic collation Daniel Verite 16:49
Re: Pg11 -- MultiXactId xxxx has not been created yet -- apparent wraparound Moreno Andreo 16:53
Re: Postgres 12: backend crashes when creating non-deterministic collation Thomas Kellerer 17:00
Re: psql \copy hanging Adrian Klaver 17:08
Re: Postgres 12: backend crashes when creating non-deterministic collation Thomas Kellerer 17:22
Re: Postgres 12: backend crashes when creating non-deterministic collation Tom Lane 17:36
Re: PG11 Parallel Thanks!! Peter Geoghegan 18:28
Re: Pg11 -- MultiXactId xxxx has not been created yet -- apparent wraparound Alvaro Herrera 19:14
Event Triggers and Dropping Objects Miles Elam 20:38
Re: Clarification on the release notes of postgresql 12 regarding pg_upgrade Bruce Momjian 22:19

Oct. 5, 2019

Thread Author Time
Re: Event Triggers and Dropping Objects Luca Ferrari 08:50
Re: Performance on JSONB select PegoraroF10 11:34
Re: Performance on JSONB select PegoraroF10 11:38
Re: Postgres 12: backend crashes when creating non-deterministic collation Thomas Kellerer 11:39
Re: Postgres 12: backend crashes when creating non-deterministic collation Thomas Kellerer 12:06
Re: Postgres 12: backend crashes when creating non-deterministic collation Peter Eisentraut 14:44
Re: Performance on JSONB select Pavel Stehule 14:45
Re: Performance on JSONB select PegoraroF10 14:49
Re: Performance on JSONB select Fabrízio de Royes Mello 15:00
Re: PMChildFlags array bhargav kamineni 17:26
Re: Performance on JSONB select PegoraroF10 17:37
Re: Event Triggers and Dropping Objects Miles Elam 20:27

Oct. 6, 2019

Thread Author Time
v12 and pg_restore -f- Justin Pryzby 19:08
Re: v12 and pg_restore -f- Tom Lane 20:43
Re: v12 and pg_restore -f- Andrew Gierth 21:02
Re: v12 and pg_restore -f- Tom Lane 21:15
Re: v12 and pg_restore -f- Andrew Gierth 21:39

Oct. 7, 2019

Thread Author Time
COPY command returns "ERROR: invalid XML content" Konstantin Izmailov 03:45
Install postgres on rhel 7 Mageshwaran Janarthanam 05:00
will postgresql-12-postgis-2.5 become available in the postgres repository? Arya F 06:05
Re: psql \copy hanging Arnaud L. 07:41
RowDescription message Tatsuo Ishii 08:00
Re: RowDescription message Andres Freund 09:27
Re: COPY command returns "ERROR: invalid XML content" Tomas Vondra 12:13
Re: Install postgres on rhel 7 Tomas Vondra 12:19
Re: Pg11 -- MultiXactId xxxx has not been created yet -- apparent wraparound Moreno Andreo 12:35
Re: RowDescription message Tatsuo Ishii 12:52
Re: RowDescription message Tom Lane 13:32
Re: psql \copy hanging Adrian Klaver 14:36
Re: psql \copy hanging Arnaud L. 14:40
PG 12 not yet for mac Ravi Krishna 15:11
Declarative Range Partitioning Postgres 11 Shatamjeev Dewan 15:47
Re: PG 12 not yet for mac Tomas Vondra 15:47
Re: RowDescription message Wim Bertels 15:49
pgcrypto question Erik Aronesty 16:05
Re: PMChildFlags array Tom Lane 17:40
Re: pgcrypto question Tomas Vondra 18:08
Re: pgcrypto question Erik Aronesty 18:51
Re: pgcrypto question Tomas Vondra 19:49
Re: Event Triggers and Dropping Objects Bruce Momjian 20:12
Re: pgcrypto question Erik Aronesty 20:39
temporary files dangal 20:52
Table locking during backup Artur Zając 21:00
Re: temporary files Tomas Vondra 21:09
Re: Table locking during backup Tomas Vondra 21:19
Re: Performance on JSONB select Michael Lewis 21:27
Re: JSONB maximal length ? Michael Lewis 21:39
Re: Declarative Range Partitioning Postgres 11 Michael Lewis 23:17
Re: Declarative Range Partitioning Postgres 11 Ron 23:56

Oct. 8, 2019

Thread Author Time
Re: PG 12 not yet for mac Pankaj Jangid 00:52
Re: COPY command returns "ERROR: invalid XML content" Konstantin Izmailov 02:03
Re: COPY command returns "ERROR: invalid XML content" Konstantin Izmailov 02:23
RE: Table locking during backup Artur Zając 06:40
Re: psql \copy hanging Arnaud L. 07:06
Re: psql \copy hanging Pavel Stehule 07:28
Re: psql \copy hanging Arnaud L. 09:47
Re: Performance on JSONB select PegoraroF10 09:51
GPS coordinates problem Timmy Siu 10:50
Re: psql \copy hanging Daniel Verite 10:55
Re: psql \copy hanging Arnaud L. 11:12
Re: GPS coordinates problem Andreas Kretschmer 11:30
Re: GPS coordinates problem Robert Heinen 11:57
RE: Declarative Range Partitioning Postgres 11 Shatamjeev Dewan 13:55
Re: psql \copy hanging Arnaud L. 13:59
RE: Declarative Range Partitioning Postgres 11 Shatamjeev Dewan 14:00
Re: psql \copy hanging Adrian Klaver 14:03
Re: psql \copy hanging Arnaud L. 14:22
Re: psql \copy hanging Daniel Verite 14:55
Re: psql \copy hanging Arnaud L. 14:59
Re: Table locking during backup Tom Lane 15:02
Segmentation fault with PG-12 Andreas Joseph Krogh 15:15

Browse Archives

Prev | Next
Jump to day: 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31