pgsql-general - July 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

July 1, 2019

Thread Author Time
Re: iterate over partitions Achilleas Mantzios 07:12
Use ctid in where clause in update from statement Dirk Mika 09:13
Re: Use ctid in where clause in update from statement Achilleas Mantzios 09:27
Re: Use ctid in where clause in update from statement Thomas Kellerer 09:35
RE: Memory settings Daulat Ram 09:42
Re: Use ctid in where clause in update from statement Achilleas Mantzios 09:50
Re: Use ctid in where clause in update from statement Dirk Mika 10:02
Re: Use ctid in where clause in update from statement Dirk Mika 10:04
Re: Use ctid in where clause in update from statement Dirk Mika 11:18
Re: Use ctid in where clause in update from statement Thomas Kellerer 11:25
Re: Use ctid in where clause in update from statement Thomas Kellerer 11:33
Re: Use ctid in where clause in update from statement Dirk Mika 11:40
Re: Use ctid in where clause in update from statement Achilleas Mantzios 12:04
Re: Use ctid in where clause in update from statement Thomas Kellerer 12:08
Re: Use ctid in where clause in update from statement Dirk Mika 12:13
Re: Use ctid in where clause in update from statement Tom Lane 14:19
Statistics tables not being updated anymore Ron 17:27
Re: Statistics tables not being updated anymore Adrian Klaver 18:07
Re: Statistics tables not being updated anymore Ron 18:24
Re: Statistics tables not being updated anymore Jerry Sievers 18:48
Re: Statistics tables not being updated anymore Tom Lane 18:48
Re: Statistics tables not being updated anymore Adrian Klaver 18:48
Argument casting hierarchy? Wells Oliver 19:18
Re: Statistics tables not being updated anymore Ron 19:30
Re: Statistics tables not being updated anymore Ron 19:35
Re: Statistics tables not being updated anymore Adrian Klaver 19:43
Re: Argument casting hierarchy? Adrian Klaver 20:15
Re: Argument casting hierarchy? Wells Oliver 20:18
Re: Argument casting hierarchy? Adrian Klaver 20:22
Re: Statistics tables not being updated anymore Ron 20:38
Re: Statistics tables not being updated anymore Adrian Klaver 22:20
Re: Statistics tables not being updated anymore Ron 22:25
Re: Statistics tables not being updated anymore Tom Lane 23:41

July 2, 2019

Thread Author Time
Re: Argument casting hierarchy? Andrew Gierth 03:26
restore error Prakash Ramakrishnan 05:51
"invalid contrecord" error on replica JOULAUD François 07:25
Re: restore error Laurenz Albe 07:35
Re: restore error Prakash Ramakrishnan 07:36
[No subject] Prakash Ramakrishnan 07:39
Re: Statistics tables not being updated anymore Laurenz Albe 07:39
Re: Laurenz Albe 07:45
plpgsql: How to modify a field in an array of records Dirk Mika 07:49
Re: Prakash Ramakrishnan 08:02
Sequences part 2 Karl Martin Skoldebrand 10:44
Re: Sequences part 2 Thomas Kellerer 11:02
RE: Sequences part 2 Karl Martin Skoldebrand 11:20
Re: Sequences part 2 Karsten Hilbert 11:25
RE: Sequences part 2 Karl Martin Skoldebrand 11:42
Re: Sequences part 2 Thomas Kellerer 11:53
Re: Statistics tables not being updated anymore Ron 13:28
Re: Statistics tables not being updated anymore Adrian Klaver 13:36
Re: plpgsql: How to modify a field in an array of records Tom Lane 13:52
Re: Statistics tables not being updated anymore Adrien Nayrat 16:45
pglogical extension. - 2 node master <-> master logical replication ? Day, David 17:54
refresh materialized view concurrently alternatives Zsolt Ero 22:09
Re: raf 23:04
Re: Andrew Kerber 23:08
Re: Adrian Klaver 23:14
Re: plpgsql: How to modify a field in an array of records raf 23:38

July 3, 2019

Thread Author Time
Re: plpgsql: How to modify a field in an array of records Dirk Mika 04:53
Re: plpgsql: How to modify a field in an array of records Dirk Mika 05:04
multiple nodes in FDW create server statement Vijaykumar Jain 05:27
Partitioning an existing table - pg10.6 Ayub M 07:01
Re: multiple nodes in FDW create server statement Laurenz Albe 07:18
Re: [External] Re: multiple nodes in FDW create server statement Vijaykumar Jain 07:24
Re: Partitioning an existing table - pg10.6 Achilleas Mantzios 08:35
Re: Partitioning an existing table - pg10.6 legrand legrand 08:37
Too short field Karl Martin Skoldebrand 11:30
Re: Too short field Thomas Kellerer 11:56
RE: Too short field Karl Martin Skoldebrand 12:02
Re: Too short field Karsten Hilbert 12:10
Re: Too short field Karsten Hilbert 12:21
RE: Too short field Karl Martin Skoldebrand 12:22
Error updating column of type text as boolean type Marllius 15:09
Re: Error updating column of type text as boolean type John McKown 15:15
Re: Error updating column of type text as boolean type Marllius 16:40
Re: postgres 11 issue? 📎 Steve Rogerson 16:42
Re: postgres 11 issue? Adrian Klaver 19:32
Re: postgres 11 issue? Tom Lane 19:36
Allocating shared memory in Postgres Souvik Bhattacherjee 20:06
Re: Allocating shared memory in Postgres Tom Lane 20:17
Re: postgres 11 issue? Tom Lane 22:18
Re: Too short field Gavin Flower 22:22

July 4, 2019

Thread Author Time
Re: Allocating shared memory in Postgres Souvik Bhattacherjee 01:11
Expression of check constraint Dirk Mika 05:58
Re: Expression of check constraint rob stone 08:49
Re: Expression of check constraint Dirk Mika 08:57
Help with a selection paul.malm 09:51
Re: Help with a selection Dirk Mika 10:01
Re: Expression of check constraint Laurenz Albe 10:32
Error: rows returned by function are not all of the same row type Andrey Sychev 12:20
Why does jsonb_set() remove non-mentioned keys? Thomas Kellerer 13:18
Re: Error: rows returned by function are not all of the same row type Tom Lane 14:38
Re: Expression of check constraint Tom Lane 14:45
PostgreSQL upgrade from 9.4.2 to 9.6.12 Ashwini Singh 14:48
Re: PostgreSQL upgrade from 9.4.2 to 9.6.12 Adrian Klaver 14:58
Re: Why does jsonb_set() remove non-mentioned keys? David G. Johnston 16:20
Re: pg_dump (COPY) hanging intermittently Ben Snaidero 16:37
Re: PostgreSQL upgrade from 9.4.2 to 9.6.12 Jonathan Harden 17:13
Converting to identity columns with domains on PK columns PegoraroF10 19:41
Re: Converting to identity columns with domains on PK columns Adrian Klaver 19:53
Re: Converting to identity columns with domains on PK columns PegoraroF10 20:03
Re: Converting to identity columns with domains on PK columns Adrian Klaver 20:27
Re: Why does jsonb_set() remove non-mentioned keys? Thomas Kellerer 20:33
Re: Converting to identity columns with domains on PK columns Adrian Klaver 20:56
Re: Why does jsonb_set() remove non-mentioned keys? Gianni Ceccarelli 21:03
Re: Why does jsonb_set() remove non-mentioned keys? David G. Johnston 21:09
Re: Converting to identity columns with domains on PK columns Adrian Klaver 21:20
Re: Why does jsonb_set() remove non-mentioned keys? David G. Johnston 21:42

July 5, 2019

Thread Author Time
Re: Converting to identity columns with domains on PK columns Laurenz Albe 07:21
Re: Why does jsonb_set() remove non-mentioned keys? Gianni Ceccarelli 08:00
Re: Active connections are terminated because of small wal_sender_timeout AYahorau 08:03
Vacuum and freeing dead rows Simon T 08:16
Re: Why does jsonb_set() remove non-mentioned keys? Thomas Kellerer 08:59
Re: Error: rows returned by function are not all of the same row type Andrey Sychev 09:39
Re: postgres 11 issue? Steve Rogerson 11:18
Re: Converting to identity columns with domains on PK columns PegoraroF10 11:38
Re: Why does jsonb_set() remove non-mentioned keys? Peter J. Holzer 11:50
Re: Error: rows returned by function are not all of the same row type Joe Conway 12:15
Unavailability of Jar for connectivity in Postgres Abraham, Nikhil (COR), Vodafone Idea 12:35
Re: Unavailability of Jar for connectivity in Postgres Adrian Klaver 13:50
Re: Vacuum and freeing dead rows Ron 13:52
Re: Active connections are terminated because of small wal_sender_timeout Tom Lane 14:03
Re: Converting to identity columns with domains on PK columns Adrian Klaver 14:03
Re: PostgreSQL upgrade from 9.4.2 to 9.6.12 Michael Lewis 18:59
xpath differences between postgres 11.4 and 10.3 Felipe de Jesús Molina Bravo 19:22
Re: Converting to identity columns with domains on PK columns PegoraroF10 20:01
Re: Converting to identity columns with domains on PK columns Tom Lane 20:16
Re: Converting to identity columns with domains on PK columns Adrian Klaver 20:22
Re: Partitioning an existing table - pg10.6 legrand legrand 20:22
Re: Converting to identity columns with domains on PK columns PegoraroF10 20:49
Re: Partitioning an existing table - pg10.6 Michael Lewis 20:55
Re: Converting to identity columns with domains on PK columns PegoraroF10 20:55
Re: Converting to identity columns with domains on PK columns Adrian Klaver 20:55
Re: Converting to identity columns with domains on PK columns Adrian Klaver 21:10
Re: Converting to identity columns with domains on PK columns Tom Lane 22:32
Re: Converting to identity columns with domains on PK columns Adrian Klaver 23:03

July 6, 2019

Thread Author Time
xpath differences between postgres 11.4 and 10.3 David G. Johnston 07:29
Re: xpath differences between postgres 11.4 and 10.3 Felipe de Jesús Molina Bravo 22:09

July 7, 2019

Thread Author Time
Re: pglogical extension. - 2 node master <-> master logical replication ? Peter Eisentraut 18:44
Measuring the Query Optimizer Effect: Turning off the QO? Tom Mercha 23:22
Re: Measuring the Query Optimizer Effect: Turning off the QO? Rob Sargent 23:46
Re: Measuring the Query Optimizer Effect: Turning off the QO? Tom Mercha 23:49

July 8, 2019

Thread Author Time
Re: Measuring the Query Optimizer Effect: Turning off the QO? Rob Sargent 00:01
Re: Measuring the Query Optimizer Effect: Turning off the QO? Rob Sargent 00:02
Re: Measuring the Query Optimizer Effect: Turning off the QO? Rob Sargent 00:04
Re: Measuring the Query Optimizer Effect: Turning off the QO? Tom Mercha 00:14
Re: Measuring the Query Optimizer Effect: Turning off the QO? Rob Sargent 00:29
Re: Measuring the Query Optimizer Effect: Turning off the QO? Rob Sargent 00:31
Re: Measuring the Query Optimizer Effect: Turning off the QO? Ron 00:39
Re: Measuring the Query Optimizer Effect: Turning off the QO? Tom Lane 01:26
Re: Active connections are terminated because of small wal_sender_timeout Michael Paquier 07:45
Incremental aggregate/rollup strategy advice Morris de Oryx 07:48
Re: Incremental aggregate/rollup strategy advice Tatsuo Ishii 08:21
Re: Incremental aggregate/rollup strategy advice Morris de Oryx 09:16
RE: Incremental aggregate/rollup strategy advice Steven Winfield 13:02
Re: Incremental aggregate/rollup strategy advice Morris de Oryx 13:34
Re: Incremental aggregate/rollup strategy advice Tatsuo Ishii 14:04
Re: Measuring the Query Optimizer Effect: Turning off the QO? Andrew Gierth 14:23
Re: Measuring the Query Optimizer Effect: Turning off the QO? Andrew Gierth 16:14
Re: REINDEX : new parameter to preserve current average leaf density as new implicit FILLFACTOR John Lumby 16:23
Re: Measuring the Query Optimizer Effect: Turning off the QO? Tom Lane 16:29
OOM with many sorts 📎 Justin Pryzby 16:44
Elastic Search much faster at statistics? Guyren Howe 16:54
Re: REINDEX : new parameter to preserve current average leaf density as new implicit FILLFACTOR Peter Geoghegan 17:39
Re: REINDEX : new parameter to preserve current average leaf density as new implicit FILLFACTOR John Lumby 19:10
Re: Measuring the Query Optimizer Effect: Turning off the QO? Tom Mercha 19:17
Re: REINDEX : new parameter to preserve current average leaf density as new implicit FILLFACTOR Peter Geoghegan 19:19
Re: Measuring the Query Optimizer Effect: Turning off the QO? Tom Mercha 19:20
Re: REINDEX : new parameter to preserve current average leaf density as new implicit FILLFACTOR Peter Geoghegan 19:34
PGPOOL Question Andrew Kerber 19:41
Re: Elastic Search much faster at statistics? Miles Elam 20:12
pgpool, pgmaster and pgslave migration to ubuntu 18.04 a venkatesh 21:36
Re: pgpool, pgmaster and pgslave migration to ubuntu 18.04 Tatsuo Ishii 22:57

July 9, 2019

Thread Author Time
Logical Replication for Very Large Databases Taylor Sarrafian 00:15
Re: OOM with many sorts Thomas Munro 04:43
pg_dump and search_path Igal @ Lucee.org 06:48
Re: pg_dump and search_path Igal @ Lucee.org 06:54
Re: pg_dump and search_path Laurenz Albe 07:22
Re: Error: rows returned by function are not all of the same row type Andrey Sychev 08:06
Re: Active connections are terminated because of small wal_sender_timeout AYahorau 08:12
PGSQL 11.4: shared_buffers and /dev/shm size Konstantin Malanchev 09:50
Re: PGSQL 11.4: shared_buffers and /dev/shm size Jean Louis 09:53
Re: PGSQL 11.4: shared_buffers and /dev/shm size Konstantin Malanchev 10:09
Re: PGSQL 11.4: shared_buffers and /dev/shm size Jean Louis 10:15
Re: PGSQL 11.4: shared_buffers and /dev/shm size Thomas Munro 10:51
Re: PGSQL 11.4: shared_buffers and /dev/shm size Konstantin Malanchev 11:11
Re: PGSQL 11.4: shared_buffers and /dev/shm size Thomas Munro 11:54
Re: PGSQL 11.4: shared_buffers and /dev/shm size Konstantin Malanchev 12:27
SuperUser permission denied when creating table. Dave Hughes 12:31
Re: PGSQL 11.4: shared_buffers and /dev/shm size Thomas Munro 12:59
Re: SuperUser permission denied when creating table. Achilleas Mantzios 13:28
Re: pg_dump and search_path Ron 13:28
Re: PGSQL 11.4: shared_buffers and /dev/shm size Konstantin Malanchev 13:31
Re: SuperUser permission denied when creating table. 📎 Dave Hughes 13:50
Re: pg_dump and search_path Adrian Klaver 14:02
Re: SuperUser permission denied when creating table. Achilleas Mantzios 14:08
Re: pg_dump and search_path Adrian Klaver 14:12
Re: SuperUser permission denied when creating table. Tom Lane 14:14
Re: pg_dump and search_path Igal @ Lucee.org 14:41

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