pgsql-general - April 2020

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

April 1, 2020

Thread Author Time
Database Cache Hit Ratio (Warning) Rajiv Ranjan 04:52
Re: Database Cache Hit Ratio (Warning) David G. Johnston 05:14
Re: Is PostgreSQL SQL Database Command Syntax Similar to MySQL/MariaDB? Turritopsis Dohrnii Teo En Ming 12:18
Re: Index selection issues with RLS using expressions Alastair McKinley 12:27
[No subject] Nicola Contu 12:51
permission denied for schema AC Gomez 13:35
Re: Index selection issues with RLS using expressions Stephen Frost 14:05
Re: permission denied for schema Adrian Klaver 15:59
Re: pgAdmin4 installation on macOS installed a User: can I delete it? Adrian Klaver 16:04
dbeaver Roberto Della Pasqua 16:17
Re: dbeaver Adrian Klaver 16:27
R: dbeaver Roberto Della Pasqua 16:33
postgres: archiver process failed on 000000010000020A00000073 Silvio Fabi - NBS srl 17:09
Re: postgres: archiver process failed on 000000010000020A00000073 Alvaro Herrera 17:36
Re: dbeaver negora 19:44
Re: dbeaver Ravi Krishna 19:53
Re: dbeaver Thomas Kellerer 20:28
Re: R: dbeaver Adrian Klaver 21:53
It is possible to force periodically switch xlog? Edson Richter 22:06
Re: It is possible to force periodically switch xlog? Abdul Sayeed 22:11
Re: It is possible to force periodically switch xlog? Alvaro Herrera 22:55
RE: It is possible to force periodically switch xlog? Edson Richter 23:19
using a common key value on both sides of a union ? David Gauthier 23:39
Re: using a common key value on both sides of a union ? David G. Johnston 23:46

April 2, 2020

Thread Author Time
Re: It is possible to force periodically switch xlog? David Steele 01:09
Re: It is possible to force periodically switch xlog? Kyotaro Horiguchi 01:22
RE: It is possible to force periodically switch xlog? Edson Richter 02:29
RE: It is possible to force periodically switch xlog? Edson Richter 02:31
Re: It is possible to force periodically switch xlog? Alvaro Herrera 02:38
RE: It is possible to force periodically switch xlog? Edson Richter 03:16
Re: dbeaver 📎 negora 06:33
Re: postgres: archiver process failed on 000000010000020A00000073 Silvio Fabi - NBS srl 08:12
EINTR while resizing dsm segment. 📎 Kyotaro Horiguchi 08:25
Re: using a common key value on both sides of a union ? Laurenz Albe 08:53
Fixing set-returning functions are not allowed in UPDATE after upgrade to Postgres 12 Andrus 14:48
Re: Fixing set-returning functions are not allowed in UPDATE after upgrade to Postgres 12 Laurenz Albe 14:57
too many clients already Abraham, Danny 15:06
Re: too many clients already Rob Sargent 15:09
Re: too many clients already Adrian Klaver 15:20
RE: Re: too many clients already Abraham, Danny 15:22
Re: too many clients already Adrian Klaver 15:29
RE: Re: too many clients already Abraham, Danny 15:35
Re: too many clients already Adrian Klaver 15:37
RE: Re: too many clients already Abraham, Danny 15:41
Re: too many clients already Tom Lane 15:51
RE: Re: too many clients already Abraham, Danny 16:20
Re: too many clients already Tom Lane 16:40
RE: Re: too many clients already Abraham, Danny 17:13
Could someone please help us share the procedure to troubleshoot the locks on proc issues. 📎 postgann2020 s 19:37
Help to find-the-maximum-length-of-field-in-a-particular-column-in-all the tables postgann2020 s 19:51
Cstore_fdw issue. Moses Mafusire 20:40
Re: Help to find-the-maximum-length-of-field-in-a-particular-column-in-all the tables David G. Johnston 20:59
Re: Cstore_fdw issue. Adrian Klaver 22:27
Re: Could someone please help us share the procedure to troubleshoot the locks on proc issues. Adrian Klaver 23:00

April 3, 2020

Thread Author Time
Backing out of privilege grants rabbit hole AC Gomez 03:34
Re: Backing out of privilege grants rabbit hole Guyren Howe 03:37
Re: Backing out of privilege grants rabbit hole Guyren Howe 03:41
Re: Backing out of privilege grants rabbit hole AC Gomez 03:42
Improve COPY performance into table with indexes. James Brauman 04:42
Re: Backing out of privilege grants rabbit hole raf 04:57
Re: Backing out of privilege grants rabbit hole AC Gomez 04:59
Re: Could someone please help us share the procedure to troubleshoot the locks on proc issues. postgann2020 s 05:11
Re: Help to find-the-maximum-length-of-field-in-a-particular-column-in-all the tables postgann2020 s 05:15
Re: Fixing set-returning functions are not allowed in UPDATE after upgrade to Postgres 12 Andrus 06:37
Re: Fixing set-returning functions are not allowed in UPDATE after upgrade to Postgres 12 David G. Johnston 07:17
Re: Help to find-the-maximum-length-of-field-in-a-particular-column-in-all the tables David G. Johnston 07:25
Re: Improve COPY performance into table with indexes. Tim Cross 07:27
Out of memory in big transactions after upgrade to 12.2 Jan Strube 07:42
Re: Improve COPY performance into table with indexes. Laurenz Albe 08:47
Re: Backing out of privilege grants rabbit hole Laurenz Albe 08:50
Re: Out of memory in big transactions after upgrade to 12.2 Pavel Stehule 11:50
Re: Database Cache Hit Ratio (Warning) Rajiv Ranjan 12:16
Re: Cstore_fdw issue. Moses Mafusire 12:53
Re: Out of memory in big transactions after upgrade to 12.2 David Day 13:29
Re: Backing out of privilege grants rabbit hole Rob Sargent 13:55
Re: Database Cache Hit Ratio (Warning) David G. Johnston 15:07
Re: Cstore_fdw issue. Adrian Klaver 15:39
Re: Improve COPY performance into table with indexes. Adrian Klaver 15:52
Re: Improve COPY performance into table with indexes. Rob Sargent 16:08
Re: Cstore_fdw issue. Moses Mafusire 16:26
Re: Out of memory in big transactions after upgrade to 12.2 Michael Lewis 16:30
Re: Cstore_fdw issue. Adrian Klaver 16:39
Re: Backing out of privilege grants rabbit hole Adrian Klaver 17:18
Re: Backing out of privilege grants rabbit hole Adrian Klaver 17:23
Re: Backing out of privilege grants rabbit hole AC Gomez 17:29
Re: Cstore_fdw issue. Moses Mafusire 17:48
Re: Cstore_fdw issue. Adrian Klaver 17:56
Re: Cstore_fdw issue. Moses Mafusire 18:52
Re: Cstore_fdw issue. Adrian Klaver 19:10
Re: Cstore_fdw issue. Adrian Klaver 19:25

April 4, 2020

Thread Author Time
Re: EINTR while resizing dsm segment. Thomas Munro 00:48
Re: Help to find-the-maximum-length-of-field-in-a-particular-column-in-all the tables postgann2020 s 03:02
Why there is 30000 rows is sample Andrus 07:07
Re: Why there is 30000 rows is sample Julien Rouhaud 07:28
Re: Using compression on TCP transfer Andrus 08:08
Re: Why there is 30000 rows is sample Peter J. Holzer 14:05

April 5, 2020

Thread Author Time
Re: Using compression on TCP transfer Olivier Gautherot 08:59
psql show me the : and ask user input, when running one sql file arden liu 12:50
Re: psql show me the : and ask user input, when running one sql file Tim Clarke 13:46
Re: psql show me the : and ask user input, when running one sql file David G. Johnston 14:24
Re: psql show me the : and ask user input, when running one sql file Rob Sargent 14:36
Re: psql show me the : and ask user input, when running one sql file David G. Johnston 14:51
Re: Using compression on TCP transfer Andrus 15:57
Re: psql show me the : and ask user input, when running one sql file Adrian Klaver 16:13
Re: psql show me the : and ask user input, when running one sql file Adrian Klaver 16:46
Re: psql show me the : and ask user input, when running one sql file Adrian Klaver 16:47
Re: psql show me the : and ask user input, when running one sql file Adrian Klaver 17:10
Re: psql show me the : and ask user input, when running one sql file arden liu 17:30
Re: psql show me the : and ask user input, when running one sql file arden liu 17:32
Re: psql show me the : and ask user input, when running one sql file arden liu 17:51
Re: psql show me the : and ask user input, when running one sql file Adrian Klaver 18:09
Re: psql show me the : and ask user input, when running one sql file arden liu 18:29
Re: psql show me the : and ask user input, when running one sql file Daniel Verite 18:32
Re: psql show me the : and ask user input, when running one sql file arden liu 18:46

April 6, 2020

Thread Author Time
Server with hot standby slave wont start after vacuum Andrus 06:39
How to prevent master server crash if hot standby stops Andrus 08:03
Re: How to prevent master server crash if hot standby stops Laurenz Albe 08:27
Re: How to prevent master server crash if hot standby stops Michael Paquier 08:28
Re: Server with hot standby slave wont start after vacuum Laurenz Albe 08:33
Re: How to prevent master server crash if hot standby stops Andrus 08:47
Re: How to prevent master server crash if hot standby stops Andrus 08:59
AW: Out of memory in big transactions after upgrade to 12.2 Jan Strube 12:12
Logical replication Konireddy Rajashekar 13:02
Re: How to prevent master server crash if hot standby stops Laurenz Albe 13:51
Re: Logical replication Michael Lewis 16:18
Re: How to prevent master server crash if hot standby stops Andrus 21:50
Re: Cstore_fdw issue. Devrim Gündüz 23:41
Re: Cstore_fdw issue. Devrim Gündüz 23:43

April 7, 2020

Thread Author Time
How to unnest nested arrays Guyren Howe 01:11
extract property value from set of json arrays AC Gomez 02:21
Re: How to unnest nested arrays David G. Johnston 02:44
Re: extract property value from set of json arrays David G. Johnston 02:51
Re: extract property value from set of json arrays AC Gomez 03:43
what happens when you issue ALTER SERVER in a hot environment? AC Gomez 04:08
Re: what happens when you issue ALTER SERVER in a hot environment? David G. Johnston 04:29
Re: what happens when you issue ALTER SERVER in a hot environment? Tom Lane 04:53
Re: How to unnest nested arrays Pavel Stehule 05:03
Re: How to unnest nested arrays Guyren Howe 05:24
Re: How to unnest nested arrays Pavel Stehule 05:49
Re: Logical replication Konireddy Rajashekar 06:29
Re: what happens when you issue ALTER SERVER in a hot environment? Laurenz Albe 06:59
Re: How to prevent master server crash if hot standby stops Laurenz Albe 07:12
Re: EINTR while resizing dsm segment. Nicola Contu 08:58
Re: How to prevent master server crash if hot standby stops Andrus 09:05
Re: EINTR while resizing dsm segment. Nicola Contu 10:25
Re: EINTR while resizing dsm segment. Thomas Munro 10:25
Re: How to prevent master server crash if hot standby stops Laurenz Albe 10:50
PostgreSQL native multi-master Vano Beridze 11:39
Re: what happens when you issue ALTER SERVER in a hot environment? AC Gomez 13:16
Re: PostgreSQL native multi-master Andreas Kretschmer 13:46
Using of --data-checksums BGoebel 15:10
Estimated resources for a 500 connections instance (VM) David Gauthier 16:24
Re: Estimated resources for a 500 connections instance (VM) Josef Šimánek 16:28
Re: Mixed Locales and Upgrading Don Seiler 16:41
Performance degradation if query returns no rows and column expression is used after upgrading to 12 Andrus 16:47
Re: Performance degradation if query returns no rows and column expression is used after upgrading to 12 Pavel Stehule 16:57
Re: Performance degradation if query returns no rows and column expression is used after upgrading to 12 Andrus 17:09
Re: Estimated resources for a 500 connections instance (VM) Laurenz Albe 17:19
Re: Performance degradation if query returns no rows and column expression is used after upgrading to 12 Pavel Stehule 17:26
Re: Estimated resources for a 500 connections instance (VM) David Gauthier 19:51
Re: Estimated resources for a 500 connections instance (VM) Sándor Daku 20:23
Re: Estimated resources for a 500 connections instance (VM) Tim Cross 20:31
Re: Estimated resources for a 500 connections instance (VM) Rob Sargent 20:31
Re: Estimated resources for a 500 connections instance (VM) Adrian Klaver 20:32
Re: Performance degradation if query returns no rows and column expression is used after upgrading to 12 Andrus 21:56

April 8, 2020

Thread Author Time
Announcing "common" YUM repository Devrim Gündüz 01:24
Re: Using of --data-checksums Michael Paquier 02:29
Re: Mixed Locales and Upgrading Peter Eisentraut 07:32
Re: Estimated resources for a 500 connections instance (VM) Laurenz Albe 07:39
Re: Performance degradation if query returns no rows and column expression is used after upgrading to 12 Pavel Stehule 11:47
Re: Mixed Locales and Upgrading Peter J. Holzer 11:53
Re: Performance degradation if query returns no rows and column expression is used after upgrading to 12 Andrus 13:34
Best method to display table information in predefined formats Mark Bannister 13:39
Re: Performance degradation if query returns no rows and column expression is used after upgrading to 12 Pavel Stehule 14:03
Unexpected behavior sorting strings Jimmy Thrasher 14:35
Re: Best method to display table information in predefined formats Adrian Klaver 15:28
Re: Best method to display table information in predefined formats Mark Bannister 15:39
Re: Best method to display table information in predefined formats Adrian Klaver 15:41
Re: Unexpected behavior sorting strings Tom Lane 15:47
Re: Unexpected behavior sorting strings Adrian Klaver 15:49
Re: Best method to display table information in predefined formats melvin6925 15:53
Re: PostgreSQL native multi-master Stephen Frost 15:53
Re: Using of --data-checksums Stephen Frost 15:54
Re: Unexpected behavior sorting strings Jimmy Thrasher 16:08
full text Roberto Della Pasqua 17:28
Re: full text Joshua Drake 21:27

April 9, 2020

Thread Author Time
Re: PostgreSQL native multi-master Joshua Drake 07:27
Re: full text Martin Gainty 10:08
order by not working in view ? David Gauthier 14:33
Re: full text Stephen Frost 14:41
Re: order by not working in view ? Tom Lane 14:41
Re: order by not working in view ? David G. Johnston 14:57
ext4 tuning parameters Casey Meijer 21:29

April 10, 2020

Thread Author Time
Different Lock Behavior With Create and Drop Foreign Key Virendra Kumar 01:40
Re: Different Lock Behavior With Create and Drop Foreign Key Laurenz Albe 05:27
Re: Different Lock Behavior With Create and Drop Foreign Key Tom Lane 16:13
Huge number of pg_temp and pg_toast_temp schemas 📎 Andrus 16:32
Re: Huge number of pg_temp and pg_toast_temp schemas Tom Lane 17:27
Re: Huge number of pg_temp and pg_toast_temp schemas 📎 Andrus 18:06
Re: Huge number of pg_temp and pg_toast_temp schemas Adrian Klaver 18:30

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