pgsql-general since 2019-09-27 00:00

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

Sept. 27, 2019

Thread Author Time
pg12 rc1 on CentOS8 depend python2 keisuke kuroda 01:50
Re: "Failed to connect to Postgres database" rob stone 02:28
Re: managing primary key conflicts while restoring data to table with existing data Pankaj Jangid 03:06
Re: pg12 rc1 on CentOS8 depend python2 Adrian Klaver 04:03
Re: pg12 rc1 on CentOS8 depend python2 keisuke kuroda 04:24
RE: Monitor Postgres database status on Docker Daulat Ram 05:25
incoherent dead tuples between pg_stat_user_tables and pgstattuple? Luca Ferrari 10:37
Re: "Failed to connect to Postgres database" Marco Ippolito 10:37
Re: pgq is one of the most underrated pg related stuff Luca Ferrari 10:41
Re: "Failed to connect to Postgres database" Daniel Verite 11:34
Re: Monitor Postgres database status on Docker Olivier Gautherot 12:36
Re: pgq is one of the most underrated pg related stuff Achilleas Mantzios 12:36
Re: "Failed to connect to Postgres database" Marco Ippolito 12:58
Re: pg12 rc1 on CentOS8 depend python2 Tom Lane 13:38
Re: incoherent dead tuples between pg_stat_user_tables and pgstattuple? Tom Lane 13:52
Re: pg12 rc1 on CentOS8 depend python2 Christoph Berg 14:15
Re: incoherent dead tuples between pg_stat_user_tables and pgstattuple? Luca Ferrari 14:29
Re: "Failed to connect to Postgres database" Adrian Klaver 14:38
Re: incoherent dead tuples between pg_stat_user_tables and pgstattuple? Tom Lane 14:43
Re: "Failed to connect to Postgres database" Marco Ippolito 15:10
Re: "Failed to connect to Postgres database" Marco Ippolito 15:20
Re: pg12 rc1 on CentOS8 depend python2 keisuke kuroda 15:25
Re: "Failed to connect to Postgres database" Adrian Klaver 16:37
Re: pgq is one of the most underrated pg related stuff Rene Romero Benavides 16:48
Re: "Failed to connect to Postgres database" Marco Ippolito 18:02
Re: "Failed to connect to Postgres database" Marco Ippolito 18:19
Re: incoherent dead tuples between pg_stat_user_tables and pgstattuple? Luca Ferrari 18:51
Re: "Failed to connect to Postgres database" Adrian Klaver 19:39
Re: "Failed to connect to Postgres database" Adrian Klaver 19:52
steps of a sql PegoraroF10 21:43
Re: Operator is not unique PegoraroF10 21:44
Re: steps of a sql Tom Lane 22:04
Re: Operator is not unique Tom Lane 22:23
Re: Operator is not unique Adrian Klaver 22:28
Re: Operator is not unique Adrian Klaver 22:36
Re: pgq is one of the most underrated pg related stuff Artjom Simon 22:59

Sept. 28, 2019

Thread Author Time
Re: "Failed to connect to Postgres database" Marco Ippolito 07:07
Phone number type extension stan 09:11
Re: Phone number type extension Morris de Oryx 10:13
Re: Phone number type extension Ray O'Donnell 11:42
Re: Pg_auto_failover Sonam Sharma 13:44
Possible bug: SQL function parameter in window frame definition Alastair McKinley 15:33
Re: Possible bug: SQL function parameter in window frame definition Andrew Gierth 15:59
JSONB maximal length ? ROS Didier 16:11
Re: JSONB maximal length ? Pavel Stehule 16:25
RE: JSONB maximal length ? ROS Didier 16:35
Re: JSONB maximal length ? Pavel Stehule 16:43
Re: Possible bug: SQL function parameter in window frame definition Tom Lane 20:37
Re: Possible bug: SQL function parameter in window frame definition 📎 Andrew Gierth 21:30
Re: "Failed to connect to Postgres database" Adrian Klaver 21:49
Re: Possible bug: SQL function parameter in window frame definition Tom Lane 23:10
Re: Phone number type extension Andreas 'ads' Scherbaum 23:12

Sept. 29, 2019

Thread Author Time
Re: Possible bug: SQL function parameter in window frame definition Andrew Gierth 04:43
Re: How to handle things that change over time? Vik Fearing 08:50
Re: Possible bug: SQL function parameter in window frame definition 📎 Andrew Gierth 10:46
Re: Possible bug: SQL function parameter in window frame definition Tom Lane 18:15
Thoughts on a cosntraint ? stan 19:40
Re: Thoughts on a cosntraint ? John W Higgins 19:52
Re: Thoughts on a cosntraint ? Rob Sargent 20:41
Re: Thoughts on a cosntraint ? Adrian Klaver 21:16
Redis 16 times faster than Postgres? Colin 't Hart 21:42
Re: Redis 16 times faster than Postgres? Nathan Woodrow 21:46
Re: Redis 16 times faster than Postgres? Ron 21:52

Sept. 30, 2019

Thread Author Time
Re: Redis 16 times faster than Postgres? Morris de Oryx 00:01
Re: Redis 16 times faster than Postgres? Ron 00:25
Re: Redis 16 times faster than Postgres? Morris de Oryx 00:59
Re: Redis 16 times faster than Postgres? Steve Litt 01:09
Re: Redis 16 times faster than Postgres? raf 03:05
Re: Redis 16 times faster than Postgres? Ron 03:44
Re: Redis 16 times faster than Postgres? Michael Paquier 03:48
Re: Redis 16 times faster than Postgres? Ben Chobot 03:52
Re: Possible bug: SQL function parameter in window frame definition Andrew Gierth 05:37
pg_upgrade (Checking for reg* data types) Gerrit Fouche 09:15
Re: Redis 16 times faster than Postgres? Imre Samu 09:40
Re: pg12 rc1 on CentOS8 depend python2 Devrim Gündüz 11:20
Re: Operator is not unique PegoraroF10 12:46
Re: Operator is not unique PegoraroF10 12:48
Re: Operator is not unique Adrian Klaver 14:21
Re: Operator is not unique PegoraroF10 14:28
Re: Operator is not unique Adrian Klaver 14:39
Re: Operator is not unique Tom Lane 14:54
Re: "Failed to connect to Postgres database" Marco Ippolito 16:01
Re: "Failed to connect to Postgres database" : No usage specified for certificate (update) Marco Ippolito 16:21
Re: Pg_auto_failover Rene Romero Benavides 16:39
Re: Arrays and ANY problem David Salisbury 18:23
Re: Arrays and ANY problem Andrew Gierth 18:55
Need help : pgsql HA issues Shital A 19:39
Behaviour adding a column with and without a default (prior to PG11) Joe Horsnell 20:02
Re: Possible bug: SQL function parameter in window frame definition Tom Lane 20:25
Re: pg_upgrade (Checking for reg* data types) Bruce Momjian 20:29
Re: pg_upgrade (Checking for reg* data types) Bruce Momjian 20:33
Re: pg_upgrade (Checking for reg* data types) Gerrit Fouche 20:37
Re: Behaviour adding a column with and without a default (prior to PG11) Tom Lane 21:19
Re: Behaviour adding a column with and without a default (prior to PG11) Joe Horsnell 21:23

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

Browse Archives

Prev | Next