pgsql-general since 2019-01-17 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)

Browse Archives

Prev | Next

Jan. 17, 2019

Thread Author Time
Re: Varlena with recursive data structures? George Neuner 03:15
Re: Can anyone please provide me list of customers using postgreSQL Brent Wood 03:17
Question about array_to_string()'s behavior and the behavior might be changed in the future or not Egashira, Yusuke 06:50
Re: Question about array_to_string()'s behavior and the behavior might be changed in the future or not Andrew Gierth 06:56
Re: Weird behaviour of ROLLUP/GROUPING Andrew Gierth 07:27
RE: Question about array_to_string()'s behavior and the behavior might be changed in the future or not Egashira, Yusuke 07:53
Re: Weird behaviour of ROLLUP/GROUPING Guillaume Lelarge 08:23
Re: Barman versus pgBackRest Achilleas Mantzios 11:09
Postgres Automated Failover AI Rumman 13:32
Re: Postgres Automated Failover Deepika S Gowda 13:58
Re: Postgres Automated Failover Jehan-Guillaume (ioguix) de Rorthais 14:06
Re: Barman versus pgBackRest Jehan-Guillaume (ioguix) de Rorthais 14:12
Re: Postgres Automated Failover Fabio Pardi 14:29
RE: Postgres Automated Failover ROS Didier 14:32
Re: Barman versus pgBackRest Achilleas Mantzios 15:15
pgbouncer Nicola Contu 15:18
Re: pgbouncer David G. Johnston 15:32
Identifying comments Rich Shepard 15:37
Re: Identifying comments [ANSWERED] Rich Shepard 15:39
Re: Identifying comments [ANSWERED] David G. Johnston 15:41
Re: pgbouncer Fabio Pardi 16:06
Re: Refining query statement Rich Shepard 16:14
Re: pgbouncer Nicola Contu 16:15
strange slow query performance Ben Snaidero 16:19
Re: pgbouncer David G. Johnston 16:23
Re: Refining query statement Adrian Klaver 16:27
Re: Refining query statement David G. Johnston 16:36
Re: Refining query statement Adrian Klaver 16:41
Re: Refining query statement Rich Shepard 16:46
Re: Refining query statement Rich Shepard 16:50
Re: Refining query statement David G. Johnston 16:56
Re: Refining query statement Rich Shepard 17:07
Re: Refining query statement Adrian Klaver 17:21
Re: Refining query statement David G. Johnston 17:26
Re: Refining query statement Rich Shepard 17:37
Re: Refining query statement Rich Shepard 18:01
Re: Postgres Automated Failover AI Rumman 18:01
Re: Refining query statement Rich Shepard 18:04
Re: Refining query statement Adrian Klaver 18:16
Re: Refining query statement Rich Shepard 18:47
Need aws_oracle_ext.systimestamp function defination for postgres Ahtesham Karajgi 19:59
Re: strange slow query performance Laurenz Albe 20:04
Re: Varlena with recursive data structures? Michel Pelletier 20:39
Re: strange slow query performance David G. Johnston 21:13
Re: Refining query statement Rich Shepard 22:44
Re: Refining query statement Adrian Klaver 23:58

Jan. 18, 2019

Thread Author Time
Re: Refining query statement Rich Shepard 00:04
Re: Refining query statement David G. Johnston 00:07
Re: Refining query statement Rich Shepard 00:24
Re: strange slow query performance Ben Snaidero 02:05
Full text search with more than one word Ritanjali Majihee 10:06
Upgrading from 9.2.15 to 9.4.20 Michal 10:30
Re: Full text search with more than one word Magnus Hagander 10:40
Re: Upgrading from 9.2.15 to 9.4.20 Achilleas Mantzios 10:47
Re: pgbouncer Fabio Pardi 11:47
Re: Upgrading from 9.2.15 to 9.4.20 Michal 11:50
repmgr and automatic failover ROS Didier 12:26
RE: Full text search with more than one word Ritanjali Majihee 14:54
Re: Full text search with more than one word Magnus Hagander 15:15
Re: Upgrading from 9.2.15 to 9.4.20 Adrian Klaver 15:38
Re: Refining query statement [DONE] Rich Shepard 15:56
Why adding BEFORE TRIGGER affect client CPU? George Woodring 18:23
Re: Why adding BEFORE TRIGGER affect client CPU? Adrian Klaver 18:28
Re: Why adding BEFORE TRIGGER affect client CPU? Tom Lane 19:01
Re: Oracke BLOB to Postgres BYTEA using ora2pg Peter J. Holzer 19:32
Re: Why adding BEFORE TRIGGER affect client CPU? George Woodring 20:21
pgint.l -- PostgreSQL interface for PicoLisp Abel Normand 20:41
Re: Why adding BEFORE TRIGGER affect client CPU? Adrian Klaver 22:18

Jan. 19, 2019

Thread Author Time
Capacity Planning bhargav kamineni 10:38

Jan. 20, 2019

Thread Author Time
Re: the installation of pgadmin4 makes me weep in frustration Tony Shelver 06:46
Re: Capacity Planning Allan Kamau 07:29
Re: Capacity Planning Ron 08:29
Re: Capacity Planning bhargav kamineni 10:48

Jan. 21, 2019

Thread Author Time
Memory and hard ware calculation : Rangaraj G 11:24
commit within a procedure loop - cannot commite with subtransaction andyterry 12:43
Re: commit within a procedure loop - cannot commite with subtransaction Adrian Klaver 15:15
Re: commit within a procedure loop - cannot commite with subtransaction Andrew Gierth 16:03
Manage PostgreSQL Database for GITLAB Application? Hilbert, Karin 17:26
Re: commit within a procedure loop - cannot commite with subtransaction andyterry 17:41
Re: Memory and hard ware calculation : Cleiton Luiz Domazak 17:43
Re: commit within a procedure loop - cannot commite with subtransaction andyterry 17:44
Re: Manage PostgreSQL Database for GITLAB Application? Adrian Klaver 18:33
Re: Manage PostgreSQL Database for GITLAB Application? Stephen Frost 18:53
Re: Manage PostgreSQL Database for GITLAB Application? Hilbert, Karin 19:23
Re: Manage PostgreSQL Database for GITLAB Application? Adrian Klaver 19:36
Re: Manage PostgreSQL Database for GITLAB Application? Adrian Klaver 21:18
Re: Manage PostgreSQL Database for GITLAB Application? Tim Cross 22:11
Re: Manage PostgreSQL Database for GITLAB Application? Stephen Frost 23:32

Jan. 22, 2019

Thread Author Time
Re: Manage PostgreSQL Database for GITLAB Application? Dagan McGregor 02:16
Tuning threshold for BAS_BULKREAD (large tables) Jamison, Kirk 07:35
Re: Memory and hard ware calculation : Fabio Pardi 08:11
Re: Tuning threshold for BAS_BULKREAD (large tables) Ron 08:36
RE: Tuning threshold for BAS_BULKREAD (large tables) Jamison, Kirk 09:00
RE: Memory and hard ware calculation : Rangaraj G 12:54
PostgreSQL logical replication depends on WAL segments? Josef Machytka 13:18
Re: PostgreSQL logical replication depends on WAL segments? Achilleas Mantzios 13:25
Re: Marc G. Fournier Invoice Stephen Frost 14:39
Re: PostgreSQL logical replication depends on WAL segments? Adrian Klaver 14:56
Re: PostgreSQL logical replication depends on WAL segments? Josef Machytka 16:01
Re: PostgreSQL logical replication depends on WAL segments? Achilleas Mantzios 16:17
Decrease time needed to CREATE INDEX and FOREIGN KEY on new table column which has all values NULL Denisa Cirstescu 16:29
Re: Decrease time needed to CREATE INDEX and FOREIGN KEY on new table column which has all values NULL Ravi Krishna 16:38
Re: Decrease time needed to CREATE INDEX and FOREIGN KEY on new table column which has all values NULL Alvaro Herrera 16:47
Re: PostgreSQL logical replication depends on WAL segments? Jeremy Finzel 17:10
Re: PostgreSQL logical replication depends on WAL segments? Adrian Klaver 17:53
Re: PostgreSQL logical replication depends on WAL segments? Jeremy Finzel 17:57
Re: PostgreSQL logical replication depends on WAL segments? Andres Freund 18:52
Re: PostgreSQL logical replication depends on WAL segments? Andres Freund 18:52
Re: PostgreSQL logical replication depends on WAL segments? Andres Freund 18:53
Re: PostgreSQL logical replication depends on WAL segments? Jeremy Finzel 18:59
Re: PostgreSQL logical replication depends on WAL segments? Jeremy Finzel 19:03
Re: Memory and hard ware calculation : Ron 20:05
Re: PostgreSQL logical replication depends on WAL segments? Achilleas Mantzios 20:06
Re: PostgreSQL logical replication depends on WAL segments? Jeremy Finzel 20:16
Re: PostgreSQL logical replication depends on WAL segments? Jeremy Finzel 20:18

Jan. 23, 2019

Thread Author Time
Re: PostgreSQL logical replication depends on WAL segments? Achilleas Mantzios 02:19
Re: PostgreSQL logical replication depends on WAL segments? Jeremy Finzel 03:26
Re: PostgreSQL logical replication depends on WAL segments? Achilleas Mantzios 07:37
Re: PostgreSQL logical replication depends on WAL segments? Josef Machytka 08:50
Reclaiming space for dropped database Alban Hertroys 12:33
Re: Reclaiming space for dropped database Tom Lane 15:02
Re: PostgreSQL logical replication depends on WAL segments? Josef Machytka 15:05
Betr: Re: Reclaiming space for dropped database Alban Hertroys 16:22
Monitoring PITR recovery progress Ivan Voras 17:58
Re: Monitoring PITR recovery progress Alan Hodgson 18:58
Re: Reclaiming space for dropped database Jerry Sievers 19:36

Jan. 24, 2019

Thread Author Time
how to properly start postgresql with no TCP listeners in ubuntu 16.04 LTS Alex Morris 02:08
Re: how to properly start postgresql with no TCP listeners in ubuntu 16.04 LTS Stephen Frost 02:15
Re: how to properly start postgresql with no TCP listeners in ubuntu 16.04 LTS Alex Morris 02:41
Re: how to properly start postgresql with no TCP listeners in ubuntu 16.04 LTS Ron 07:06
Get attributes names ramsiddu007 08:54
Need a command to take the backup of the child tables along with its master table. Raghavendra Rao J S V 09:40
Re: Get attributes names Arthur Zakirov 09:54
Re: Need a command to take the backup of the child tables along with its master table. Ron 10:01
Re: Get attributes names ramsiddu007 10:03
[pgbackrest] Expiring the last backup? Ron 10:11
Casting Integer to Boolean in assignment Alexandre GRAIL 11:04
Re: Casting Integer to Boolean in assignment Geoff Winkless 11:45
Re: Casting Integer to Boolean in assignment Thomas Kellerer 12:17
Re: Need a command to take the backup of the child tables along with its master table. Francisco Olarte 12:35
How duplicate values inserted into the primary key column of table and how to fix it Raghavendra Rao J S V 12:46
Re: [pgbackrest] Expiring the last backup? Stephen Frost 13:26
Re: Casting Integer to Boolean in assignment Geoff Winkless 13:27
Re: [pgbackrest] Expiring the last backup? Ron 14:01
Re: Casting Integer to Boolean in assignment Ron 14:09
Re: [pgbackrest] Expiring the last backup? Stephen Frost 14:11
Postgres 11 chooses seq scan instead of index-only scan twoflower 14:23
log_min_duration_statement bhargav kamineni 14:23
Re: Casting Integer to Boolean in assignment David G. Johnston 14:28
Re: How duplicate values inserted into the primary key column of table and how to fix it Hellmuth Vargas 14:43
Re: Postgres 11 chooses seq scan instead of index-only scan Tom Lane 14:44
Re: Postgres 11 chooses seq scan instead of index-only scan twoflower 15:01
Re: Casting Integer to Boolean in assignment Geoff Winkless 15:05
Re: Postgres 11 chooses seq scan instead of index-only scan Don Seiler 15:06
Re: [pgbackrest] Expiring the last backup? Ron 15:07
Re: Casting Integer to Boolean in assignment Ron 15:09
Re: Casting Integer to Boolean in assignment Tom Lane 15:11
Re: [pgbackrest] Expiring the last backup? Stephen Frost 15:13
Re: Casting Integer to Boolean in assignment Adrian Klaver 15:17
Re: Casting Integer to Boolean in assignment Geoff Winkless 15:21
Re: log_min_duration_statement Adrian Klaver 15:23
Re: Casting Integer to Boolean in assignment Adrian Klaver 15:28
Re: How duplicate values inserted into the primary key column of table and how to fix it Adrian Klaver 15:30
Re: Casting Integer to Boolean in assignment Geoff Winkless 15:32
Re: Casting Integer to Boolean in assignment Geoff Winkless 15:36
Re: Casting Integer to Boolean in assignment Adrian Klaver 15:40
Re: Casting Integer to Boolean in assignment Geoff Winkless 15:48
Re: log_min_duration_statement bhargav kamineni 15:52
Re: Casting Integer to Boolean in assignment Adrian Klaver 16:00
Re: Casting Integer to Boolean in assignment Geoff Winkless 16:19
Re: Casting Integer to Boolean in assignment Alexandre GRAIL 17:26
Re: Casting Integer to Boolean in assignment Alexandre GRAIL 17:39
Recommended Hardware requirements for PostgreSQL DB Server. Kaushal Shriyan 18:06
Re: Recommended Hardware requirements for PostgreSQL DB Server. Ron 19:04
duplicate OID issue when using pg_upgrade to move from 9.3 to 9.5 Duarte Carreira 19:28
Re: How duplicate values inserted into the primary key column of table and how to fix it Patrick Headley 20:28
Re: duplicate OID issue when using pg_upgrade to move from 9.3 to 9.5 Tom Lane 21:02
Re: log_min_duration_statement Adrian Klaver 21:13
Re: duplicate OID issue when using pg_upgrade to move from 9.3 to 9.5 Duarte Carreira 21:51
Geographical multi-master replication Ruben Rubio Rey 23:02

Jan. 25, 2019

Thread Author Time
Re: Recommended Hardware requirements for PostgreSQL DB Server. Kaushal Shriyan 02:41
Re: Geographical multi-master replication Jeremy Finzel 05:10
Re: [pgbackrest] Expiring the last backup? David Steele 05:22
Re: Casting Integer to Boolean in assignment Laurenz Albe 05:38
Re: Geographical multi-master replication Andreas Kretschmer 05:45
Re: [pgbackrest] Expiring the last backup? Ron 06:02
Re: [External] Re: Geographical multi-master replication Vijaykumar Jain 06:12
Re: [pgbackrest] Expiring the last backup? David Steele 06:49
Sv: Re: Geographical multi-master replication Andreas Joseph Krogh 09:10
Re: Sv: Re: Geographical multi-master replication Andreas Kretschmer 09:39
Re: Sv: Re: Geographical multi-master replication Andrew Smith 10:01
RE: Full text search with more than one word Ritanjali Majihee 11:53
Re: Full text search with more than one word Magnus Hagander 11:57
RE: duplicate OID issue when using pg_upgrade to move from 9.3 to 9.5 Duarte Carreira 12:49
Re: duplicate OID issue when using pg_upgrade to move from 9.3 to 9.5 Tom Lane 14:27
RE: duplicate OID issue when using pg_upgrade to move from 9.3 to 9.5 Duarte Carreira 15:00
RE: duplicate OID issue when using pg_upgrade to move from 9.3 to 9.5 📎 Duarte Carreira 15:16
Re: duplicate OID issue when using pg_upgrade to move from 9.3 to 9.5 Tom Lane 16:04
RE: duplicate OID issue when using pg_upgrade to move from 9.3 to 9.5 Duarte Carreira 18:02
RE: duplicate OID issue when using pg_upgrade to move from 9.3 to 9.5 Duarte Carreira 18:05

Browse Archives

Prev | Next