pgsql-general - February 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)

Browse Archives

Prev | Next

Feb. 1, 2020

Thread Author Time
Re: ERROR: too many dynamic shared memory segments Thomas Munro 03:00
Re: ERROR: too many dynamic shared memory segments Thomas Munro 03:08
Re: Need support on tuning at the time of index creation Peter J. Holzer 10:21

Feb. 2, 2020

Thread Author Time
How to avoid UPDATE on same data in table ? Condor 09:24
Re: How to avoid UPDATE on same data in table ? Andreas Kretschmer 13:37
Re: How to avoid UPDATE on same data in table ? Andreas Kretschmer 14:43
Re: How to avoid UPDATE on same data in table ? Tom Lane 17:18
Re: How to avoid UPDATE on same data in table ? Andreas Kretschmer 19:17
Re: How to avoid UPDATE on same data in table ? Adrian Klaver 21:06

Feb. 3, 2020

Thread Author Time
Restrict connection from pgadmin. Pawan Sharma 06:47
Re: How to avoid UPDATE on same data in table ? Condor 08:27
Re: How to avoid UPDATE on same data in table ? Andrei Zhidenkov 08:29
Slow Query, many tmpfiles basti 13:09
Re: performance of loading CSV data with COPY is 50 times faster than Perl::DBI Steven Lembark 16:01
Re: performance of loading CSV data with COPY is 50 times faster than Perl::DBI Steven Lembark 16:02
Re: How to avoid UPDATE on same data in table ? Condor 16:24
Re: performance of loading CSV data with COPY is 50 times faster than Perl::DBI Ravi Krishna 16:57
Re: Restrict connection from pgadmin. Adrian Klaver 17:03
Re: Restrict connection from pgadmin. David G. Johnston 17:13
Re: Restrict connection from pgadmin. Ravi Krishna 17:15
Re: Restrict connection from pgadmin. Adrian Klaver 17:43
Re: performance of loading CSV data with COPY is 50 times faster than Perl::DBI Matthias Apitz 17:58
Re: performance of loading CSV data with COPY is 50 times faster than Perl::DBI bret_stern 18:28
Re: performance of loading CSV data with COPY is 50 times faster than Perl::DBI Ravi Krishna 18:42
Re: Slow Query, many tmpfiles Tom Lane 18:54
Re: performance of loading CSV data with COPY is 50 times faster than Perl::DBI Ron 19:35
Should I reinstall over current installation? Chris Charley 20:20
Re: Should I reinstall over current installation? Adrian Klaver 20:26
Re: Should I reinstall over current installation? Adrian Klaver 20:47
Re: Should I reinstall over current installation? Chris Charley 20:54
Re: Should I reinstall over current installation? Adrian Klaver 21:01
Re: Should I reinstall over current installation? Chris Charley 21:11
Re: Should I reinstall over current installation? Adrian Klaver 21:23
Postgres Crashing Doug Roberts 21:43
Re: Postgres Crashing Adrian Klaver 21:49
Re: Postgres Crashing Tom Lane 22:28
Re: Postgres Crashing Adrian Klaver 22:34
Re: Should I reinstall over current installation? Chris Charley 23:16
Re: Postgres Crashing Tom Lane 23:21
Re: Should I reinstall over current installation? Adrian Klaver 23:22

Feb. 4, 2020

Thread Author Time
Re: Restrict connection from pgadmin. Pawan Sharma 05:55
Re: Restrict connection from pgadmin. Tom Lane 06:07
Re: Should I reinstall over current installation? Moreno Andreo 12:40
Re: Postgres Crashing Doug Roberts 14:20
Re: Postgres Crashing Doug Roberts 16:06
Re: Postgres Crashing Adrian Klaver 16:18
Re: Postgres Crashing Doug Roberts 16:27
Re: Postgres Crashing Adrian Klaver 16:40
RE: Add column with default value in big table - splitting of updates can help? Kevin Brannen 17:58
Re: Postgres Crashing Doug Roberts 19:19
Re: Postgres Crashing Tom Lane 19:34
Re: Should I reinstall over current installation? Chris Charley 20:18
Better documentation for schema changes in logical replication Mike Lissner 20:22
Re: Postgres Crashing Doug Roberts 21:21
Re: Restrict connection from pgadmin. raf 22:12

Feb. 5, 2020

Thread Author Time
The best way to solve a problem Nikolai Lusan 00:36
Re: The best way to solve a problem David G. Johnston 01:14
Re: The best way to solve a problem Nikolai Lusan 07:18
Force Commit İlyas Derse 08:06
Re: Force Commit Pavel Stehule 08:11
Restore is failing Sonam Sharma 08:24
Re: Restore is failing Rob Sargent 08:31
Re: Restore is failing Sonam Sharma 08:47
Re: Force Commit Andrei Zhidenkov 09:22
Read: The best way to solve a problem Satheesh-Gsuite 09:22
Re: Restore is failing Peter J. Holzer 10:40
Get rid of brackets around variable Raul Kaubi 10:48
Re: Get rid of brackets around variable Geoff Winkless 11:10
Unable to startup postgres: Could not read from file "pg_clog/00EC" Nick Renders 11:14
Declare variable from other variable Raul Kaubi 11:21
Re: Get rid of brackets around variable Raul Kaubi 11:22
Re: Should I reinstall over current installation? Moreno Andreo 11:45
Re: Unable to startup postgres: Could not read from file "pg_clog/00EC" Alvaro Herrera 11:51
Re: Declare variable from other variable Yasin Sari 12:28
Re: Declare variable from other variable Thomas Kellerer 12:29
Re: Declare variable from other variable Raul Kaubi 12:42
Re: Declare variable from other variable hubert depesz lubaczewski 12:50
Re: Declare variable from other variable Raul Kaubi 14:02
Error handling: Resume work after error Raul Kaubi 14:17
Re: Error handling: Resume work after error hubert depesz lubaczewski 15:03
Re: initialize and use variable in query Олег Самойлов 15:22
Re: Error handling: Resume work after error Raul Kaubi 15:23
Re: Restore is failing Adrian Klaver 15:43
Re: Should I reinstall over current installation? Chris Charley 17:15
Weird behavior with update cascade on partitioned tables when moving data between partitions Márcio Antônio Sepp 17:30
Re: calculating the MD5 hash of role passwords in C Stephen Frost 18:59

Feb. 6, 2020

Thread Author Time
POLL: Adding transaction status to default psql prompt Vik Fearing 02:54
Re: POLL: Adding transaction status to default psql prompt Nikolay Samokhvalov 03:13
RE: POLL: Adding transaction status to default psql prompt Ahmed, Nawaz (Fuji Xerox Australia) 03:15
Re: POLL: Adding transaction status to default psql prompt Matt Zagrabelny 03:41
Re: POLL: Adding transaction status to default psql prompt Ian Barwick 03:49
Re: POLL: Adding transaction status to default psql prompt Steve Baldwin 03:55
Re: POLL: Adding transaction status to default psql prompt Vik Fearing 04:05
Re: POLL: Adding transaction status to default psql prompt Hari Kiran 04:14
Re: POLL: Adding transaction status to default psql prompt Michael Paquier 05:16
Re: POLL: Adding transaction status to default psql prompt Christophe Pettus 05:17
Re: POLL: Adding transaction status to default psql prompt Adrian Klaver 05:18
Re: POLL: Adding transaction status to default psql prompt David G. Johnston 05:22
Re: POLL: Adding transaction status to default psql prompt Daevor The Devoted 05:52
Re: POLL: Adding transaction status to default psql prompt Laurenz Albe 06:11
Re: POLL: Adding transaction status to default psql prompt Guillaume Lelarge 07:20
Function not imported in Entity Framework Vikram Sah 09:36
Re: POLL: Adding transaction status to default psql prompt hubert depesz lubaczewski 10:21
Re: POLL: Adding transaction status to default psql prompt Daniel Westermann (DWE) 10:33
Re: POLL: Adding transaction status to default psql prompt Ray O'Donnell 10:44
Re: Unable to startup postgres: Could not read from file "pg_clog/00EC" Nick Renders 12:47
Re: POLL: Adding transaction status to default psql prompt Victor Yegorov 13:36
Re: POLL: Adding transaction status to default psql prompt Charles Clavadetscher 14:06
Re: Function not imported in Entity Framework Adrian Klaver 15:38
Re: POLL: Adding transaction status to default psql prompt Fabrízio de Royes Mello 16:32
Re: Unable to startup postgres: Could not read from file "pg_clog/00EC" Thomas Munro 22:01
Re: POLL: Adding transaction status to default psql prompt Nikolay Samokhvalov 23:00

Feb. 7, 2020

Thread Author Time
Re: POLL: Adding transaction status to default psql prompt Ken Tanzer 01:29
deallocate statement failing rob stone 05:02
Re: deallocate statement failing Adrian Klaver 05:15
Re: deallocate statement failing Tom Lane 05:48
Re: deallocate statement failing rob stone 06:46
sensible configuration of max_connections Chris Withers 08:35
Fwd: sensible configuration of max_connections Chris Ellis 12:49
Re: Fwd: sensible configuration of max_connections Chris Withers 13:18
Re: sensible configuration of max_connections Justin 13:29
Re: Fwd: sensible configuration of max_connections Steve Atkins 13:35
periodic refresh of pre-production stages Zwettler Markus (OIZ) 16:48
Re: POLL: Adding transaction status to default psql prompt Kasun Kulathunga 16:52
Re: sensible configuration of max_connections Michael Lewis 18:06
Re: Fwd: sensible configuration of max_connections Sam Gendler 18:56
Re: Fwd: sensible configuration of max_connections Justin 19:14
Re: periodic refresh of pre-production stages Adrian Klaver 20:38
Re: Fwd: sensible configuration of max_connections Sam Gendler 20:40
Query returns no results until REINDEX Colin Adler 23:06

Feb. 8, 2020

Thread Author Time
Re: Query returns no results until REINDEX Peter Geoghegan 01:07
Postgres 12.1 : UPPER() in WHERE clause restarts server Nick Renders 20:09
Re: Postgres 12.1 : UPPER() in WHERE clause restarts server Adrian Klaver 20:16
Re: Postgres 12.1 : UPPER() in WHERE clause restarts server Marc 20:28
Re: Postgres 12.1 : UPPER() in WHERE clause restarts server Adrian Klaver 21:18
Re: Postgres 12.1 : UPPER() in WHERE clause restarts server Marc 22:24
Re: Postgres 12.1 : UPPER() in WHERE clause restarts server Christoph Moench-Tegeder 22:40
Re: Postgres 12.1 : UPPER() in WHERE clause restarts server Tom Lane 22:45
Re: Postgres 12.1 : UPPER() in WHERE clause restarts server Adrian Klaver 22:52

Feb. 9, 2020

Thread Author Time
Re: Unable to startup postgres: Could not read from file "pg_clog/00EC" Marc 15:28
Re: Postgres 12.1 : UPPER() in WHERE clause restarts server Marc 15:35
Re: Query returns no results until REINDEX Colin Adler 20:50

Feb. 10, 2020

Thread Author Time
Re: Postgres 12.1 : UPPER() in WHERE clause restarts server Thomas Munro 02:04
work_mem and shared_buffers question Ayub M 08:03
Re: work_mem and shared_buffers question Naresh g 08:50
Re: work_mem and shared_buffers question Ayub M 10:30
Re: work_mem and shared_buffers question Naresh g 10:34
Pre-version pg_upgrade syntax check Rich Shepard 21:59
Re: Pre-version pg_upgrade syntax check Rich Shepard 22:00
Re: Pre-version pg_upgrade syntax check Adrian Klaver 22:59
Re: Pre-version pg_upgrade syntax check Rich Shepard 23:30
Re: Pre-version pg_upgrade syntax check Rich Shepard 23:40
Re: Pre-version pg_upgrade syntax check Adrian Klaver 23:45

Feb. 11, 2020

Thread Author Time
Re: Pre-version pg_upgrade syntax check Rich Shepard 00:07
Re: Postgres 12.1 : UPPER() in WHERE clause restarts server Jerry Sievers 00:50
Re: Pre-version pg_upgrade syntax check Adrian Klaver 00:58
Re: Postgres 12.1 : UPPER() in WHERE clause restarts server Thomas Munro 01:51
Re: Postgres 12.1 : UPPER() in WHERE clause restarts server Nick Renders 11:32
Re: Function not imported in Entity Framework Vikram Sah 11:56
Re: Pre-version pg_upgrade syntax check Rich Shepard 13:43
Re: PostgreSQL Installer issue George Weaver 15:05
Re: Pre-version pg_upgrade syntax check Rich Shepard 15:24
Re: Pre-version pg_upgrade syntax check [FIXED] Rich Shepard 15:29
Re: Function not imported in Entity Framework Adrian Klaver 16:27
Re: Pre-version pg_upgrade syntax check Adrian Klaver 16:31
JIT on Windows with Postgres 12.1 Catch All 16:32
Re: Function not imported in Entity Framework Vikram Sah 16:35
Re: Function not imported in Entity Framework Adrian Klaver 16:45
Re: Pre-version pg_upgrade syntax check Rich Shepard 17:00
Re: Pre-version pg_upgrade syntax check Adrian Klaver 17:44
Re: Query returns no results until REINDEX Peter Geoghegan 19:32
Re: Query returns no results until REINDEX Julien Rouhaud 20:13
How to restore roles without changing postgres password Andrus 22:26
Re: How to restore roles without changing postgres password Justin 22:37
Re: How to restore roles without changing postgres password Tom Lane 22:46
Re: How to restore roles without changing postgres password Justin 23:04

Feb. 12, 2020

Thread Author Time
Re: Function not imported in Entity Framework 📎 Vikram Sah 01:17
Re: POLL: Adding transaction status to default psql prompt Anthony Nowocien 07:22
Re: How to restore roles without changing postgres password Andrus 07:31
Re: JIT on Windows with Postgres 12.1 Josef Šimánek 08:39
Avoiding out of date statistics / planner Tim Kane 09:06
pg_basebackup connection closed unexpectedly... Mladen Marinović 09:22
Re: How to restore roles without changing postgres password Andrus 10:06
RE: Function not imported in Entity Framework farjad.farid 11:52
Help : Removal of leading spaces in all the columns of a table srikkanth 12:42
Re: Help : Removal of leading spaces in all the columns of a table Charles Clavadetscher 13:23
Re: Help : Removal of leading spaces in all the columns of a table Charles Clavadetscher 14:00
Re: Help : Removal of leading spaces in all the columns of a table Susan Hurst 14:09
Re: Help : Removal of leading spaces in all the columns of a table Rob Sargent 14:33
Re: pg_basebackup connection closed unexpectedly... Tom Lane 15:09
Re: Avoiding out of date statistics / planner Tom Lane 15:15
Natural sort order extension. Dmitry Igrishin 15:45
Re: How to restore roles without changing postgres password Adrian Klaver 16:39
Re: Natural sort order extension. Laurenz Albe 16:55
Re: How to restore roles without changing postgres password Tom Lane 16:59
Re: Natural sort order extension. Dmitry Igrishin 17:14
Re: Avoiding out of date statistics / planner Michael Lewis 17:23
Re: JIT on Windows with Postgres 12.1 Andres Freund 19:42
Re: JIT on Windows with Postgres 12.1 Tom Lane 19:54
Re: JIT on Windows with Postgres 12.1 Justin 20:01

Browse Archives

Prev | Next