pgsql-general - December 2017

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

Dec. 1, 2017

Thread Author Time
Re: Removing INNER JOINs David Rowley 01:20
Re: large numbers of inserts out of memory strategy David G. Johnston 01:27
Sv: Re: Removing INNER JOINs Andreas Joseph Krogh 01:41
Re: Removing INNER JOINs Simon Riggs 02:30
Sv: Re: Removing INNER JOINs Andreas Joseph Krogh 02:34
Re: Removing INNER JOINs David Rowley 02:35
Re: Re: Removing INNER JOINs David Rowley 02:53
Sv: Re: Re: Removing INNER JOINs Andreas Joseph Krogh 09:32
Re: large numbers of inserts out of memory strategy Steven Lembark 17:49
pg data backup from vps support-tiger 19:56
Re: pg data backup from vps Rob Sargent 20:07
Re: pg data backup from vps Melvin Davidson 20:10
Re: pg data backup from vps Joshua D. Drake 20:36
Re: PostgreSQL and Data Warehouse optimizations legrand legrand 20:38
Re: pg data backup from vps basti 20:44
Re: pg data backup from vps Rory Campbell-Lange 20:46
Problems with triggers and table lock Job 21:39

Dec. 2, 2017

Thread Author Time
Re: pg data backup from vps John R Pierce 00:02
Re: Problems with triggers and table lock Alban Hertroys 11:14
Re: pg data backup from vps Sameer Kumar 12:55
Re: Problems with triggers and table lock 📎 Melvin Davidson 15:22
Warm standby can't start because logs stream too quickly from the master Zach Walton 19:02
Re: Warm standby can't start because logs stream too quickly from the master Joshua D. Drake 19:55
Re: Warm standby can't start because logs stream too quickly from the master Jeff Janes 19:59
Re: Warm standby can't start because logs stream too quickly from the master Zach Walton 23:10

Dec. 3, 2017

Thread Author Time
Re: Partition pruning / agg push down for star schema in pg v11 legrand legrand 17:39
building a server Gmail 20:47
Re: building a server John R Pierce 21:15
Re: building a server Rob Sargent 21:39
Re: building a server John R Pierce 21:45
Re: building a server hvjunk 22:17
JSON out of memory error on PostgreSQL 9.6.x Yuri Budilov 23:18

Dec. 4, 2017

Thread Author Time
Re: JSON out of memory error on PostgreSQL 9.6.x Tom Lane 00:01
Re: JSON out of memory error on PostgreSQL 9.6.x rob stone 00:01
Re: large numbers of inserts out of memory strategy Peter J. Holzer 00:01
Re: ERROR: could not load library libperl.so, PostgreSQL trying to CREATE EXTENSION plperlu Peter J. Holzer 00:13
Re: JSON out of memory error on PostgreSQL 9.6.x Yuri Budilov 00:14
Re: JSON out of memory error on PostgreSQL 9.6.x John R Pierce 00:21
Re: JSON out of memory error on PostgreSQL 9.6.x Yuri Budilov 00:23
Re: JSON out of memory error on PostgreSQL 9.6.x John R Pierce 00:33
Re: JSON out of memory error on PostgreSQL 9.6.x Tom Lane 00:39
Re: JSON out of memory error on PostgreSQL 9.6.x Yuri Budilov 01:38
Re: JSON out of memory error on PostgreSQL 9.6.x Michael Paquier 01:42
ISO8601 vs POSIX offset clarification Bharanee Rathna 02:39
Re: ISO8601 vs POSIX offset clarification Tom Lane 02:55
Re: ISO8601 vs POSIX offset clarification Bharanee Rathna 02:59
Re: ISO8601 vs POSIX offset clarification Bharanee Rathna 03:03
R: Problems with triggers and table lock Job 11:57
Replication causing publisher node to use excessive cpu over time Martin Moore 12:03
Re: ISO8601 vs POSIX offset clarification rob stone 12:07
Re: ERROR: too many dynamic shared memory segments Jakub Glapa 12:18
Re: Replication causing publisher node to use excessive cpu over time Michael Paquier 12:40
Re: Replication causing publisher node to use excessive cpu over time Martin Moore 13:00
Centos 6.9 and centos 7 Nicola Contu 13:19
Re: Adding identity column to a non-empty table Chris Wilson 13:24
Re: Problems with triggers and table lock Melvin Davidson 13:55
[GENERAL] Schema Information . Brahmam Eswar 14:17
Re: Centos 6.9 and centos 7 Chris Mair 14:19
Re: Centos 6.9 and centos 7 Nicola Contu 14:40
Re: Centos 6.9 and centos 7 Nicola Contu 14:51
Re: ISO8601 vs POSIX offset clarification Tom Lane 14:58
Re: Centos 6.9 and centos 7 Tomas Vondra 15:01
Re: Centos 6.9 and centos 7 Alban Hertroys 15:37
Re: [GENERAL] Schema Information . Melvin Davidson 15:50
WAL reducing size sql2pg 15:50
attempting to retrieve column names from information schema fails. Day, David 15:53
Re: Centos 6.9 and centos 7 Nicola Contu 15:57
Re: attempting to retrieve column names from information schema fails. Tom Lane 16:08
Re: Centos 6.9 and centos 7 Tomas Vondra 16:44
RE: attempting to retrieve column names from information schema fails. Day, David 18:15
Re: WAL reducing size David G. Johnston 18:37
Re: [GENERAL] postmaster deadlock while logging after syslogger exited David Pacheco 20:19
Re: [GENERAL] postmaster deadlock while logging after syslogger exited Andres Freund 20:23
Re: Centos 6.9 and centos 7 Alban Hertroys 21:02
Re: WAL reducing size sql2pg 21:05
Re: WAL reducing size Alvaro Herrera 21:12
Re: [GENERAL] postmaster deadlock while logging after syslogger exited David Pacheco 21:57
Re: [GENERAL] postmaster deadlock while logging after syslogger exited Andres Freund 22:12
transaction wrap around chris kim 22:21
Re: [GENERAL] postmaster deadlock while logging after syslogger exited David Pacheco 22:55

Dec. 5, 2017

Thread Author Time
Re: transaction wrap around John R Pierce 01:52
Re: WAL reducing size Michael Paquier 02:20
Re: transaction wrap around Tom Lane 02:25
Re: transaction wrap around Jeff Janes 04:43
Re: [GENERAL] Schema Information . Brahmam Eswar 09:09
Replica on low-bandwitdh network Job 09:12
Re: [GENERAL] Schema Information . Melvin Davidson 14:03
Re: Replica on low-bandwitdh network bricklen 15:27
Migrating From CentOS-6 Oracle 11g R2 To CentOS-7 PostgreSQL ?? Eugene Poole 18:59
RE: Migrating From CentOS-6 Oracle 11g R2 To CentOS-7 PostgreSQL ?? Kevin Brannen 20:07
Feature idea: Dynamic Data Making Riccardo Bassani 20:59
Re: Feature idea: Dynamic Data Making Alvaro Herrera 21:03
Re: Feature idea: Dynamic Data Making Karsten Hilbert 21:11
Re: Feature idea: Dynamic Data Making Riccardo Bassani 21:22
Re: Feature idea: Dynamic Data Making Riccardo Bassani 21:22
Re: Feature idea: Dynamic Data Making John R Pierce 21:24
a back up question Martin Mueller 21:52
Re: a back up question David G. Johnston 21:59
Re: a back up question Carl Karsten 22:06
Re: a back up question Martin Mueller 22:09
Re: a back up question Alvaro Herrera 22:15
Re: a back up question David G. Johnston 22:20
Re: a back up question Carl Karsten 22:51
Re: a back up question John R Pierce 22:55
Re: a back up question Alvaro Herrera 23:05
RE: Replica on low-bandwitdh network Ahmed, Nawaz 23:26
Re: Partition pruning / agg push down for star schema in pg v11 legrand legrand 23:48

Dec. 6, 2017

Thread Author Time
Re: transaction wrap around Thomas Munro 01:50
Re: Replica on low-bandwitdh network Ben Madin 02:53
Re: a back up question Karsten Hilbert 10:39
Re: a back up question Martin Mueller 12:52
replication terminated by primary server Bruyninckx Kristof 13:07
Does Postgresql 10 query partitions in parallel? Maltsev Eduard 13:11
Re: a back up question Karsten Hilbert 13:24
Why the planner does not use index for a large amount of data? hmidi slim 14:37
Re: Why the planner does not use index for a large amount of data? Melvin Davidson 14:47
Re: Why the planner does not use index for a large amount of data? David G. Johnston 14:52
Re: a back up question Stephen Frost 14:57
Re: a back up question Vick Khera 14:57
Re: a back up question Magnus Hagander 15:00
Why the creation of spatial indexes decrease the performance of a query? hmidi slim 15:26
Re: Does Postgresql 10 query partitions in parallel? John R Pierce 18:53
Re: Does Postgresql 10 query partitions in parallel? Andres Freund 19:33
Re: Does Postgresql 10 query partitions in parallel? John R Pierce 19:34
Re: Does Postgresql 10 query partitions in parallel? Thomas Kellerer 20:39
Re: Does Postgresql 10 query partitions in parallel? Thomas Kellerer 20:54
Re: Migrating From CentOS-6 Oracle 11g R2 To CentOS-7 PostgreSQL ?? Jeremy Schneider 22:28
Re: Migrating From CentOS-6 Oracle 11g R2 To CentOS-7 PostgreSQL ?? John R Pierce 23:10
RE: Migrating From CentOS-6 Oracle 11g R2 To CentOS-7 PostgreSQL ?? Vijay Chaudhery 23:26

Dec. 7, 2017

Thread Author Time
clean out ./data/base/pgsql_tmp Dylan Luong 04:18
Re: clean out ./data/base/pgsql_tmp Thomas Munro 04:26
Re: clean out ./data/base/pgsql_tmp Michael Paquier 04:36
Re: clean out ./data/base/pgsql_tmp Jeff Janes 05:00
Re: Migrating From CentOS-6 Oracle 11g R2 To CentOS-7 PostgreSQL ?? John R Pierce 05:02
RE: clean out ./data/base/pgsql_tmp Dylan Luong 05:29
Re: Migrating From CentOS-6 Oracle 11g R2 To CentOS-7 PostgreSQL ?? Eugene Poole 05:46
Re: Migrating From CentOS-6 Oracle 11g R2 To CentOS-7 PostgreSQL ?? Laurenz Albe 06:22
Re: clean out ./data/base/pgsql_tmp Jeff Janes 07:06
Enforcing adjacent ranges Ben Leslie 07:42
Missing RHEL rpm(pg_catcheck-10) in postgres 10 repo. Kaliappa, Karthic 11:29
Infinite replication loop with pglogical Peter J. Holzer 13:41
Re: Infinite replication loop with pglogical Peter J. Holzer 14:01
Re: replication terminated by primary server Payal Singh 18:29
Re: ERROR: too many dynamic shared memory segments Thomas Munro 21:30

Dec. 8, 2017

Thread Author Time
Re: ERROR: too many dynamic shared memory segments Jakub Glapa 07:59
RE: replication terminated by primary server 📎 Bruyninckx Kristof 11:30
Secured ldap connectivity between PostgreSQL and LDAPs server chiru r 12:40
Re: Secured ldap connectivity between PostgreSQL and LDAPs server Adam Tauno Williams 13:56
Re: Secured ldap connectivity between PostgreSQL and LDAPs server Stephen Frost 15:16

Dec. 9, 2017

Thread Author Time
Problem with COPY command on pg_dump Blake McBride 15:42
Re: Problem with COPY command on pg_dump Rob Sargent 15:53
Windows XP to Win 10 migration issue Dale Seaburg 16:11
Re: Problem with COPY command on pg_dump Tom Lane 16:23
Re: Problem with COPY command on pg_dump Blake McBride 16:29
Future of PlPython2 Boshomi DeWiki 17:15
Re: Future of PlPython2 Joshua D. Drake 19:17
PG Schema to be used as log and monitoring store Stefan Keller 19:22
Re: PG Schema to be used as log and monitoring store James Keener 19:48
Re: Windows XP to Win 10 migration issue Scott Mead 21:03
Re: Future of PlPython2 Peter Eisentraut 21:28
Re: Windows XP to Win 10 migration issue John R Pierce 21:55
Re: PG Schema to be used as log and monitoring store Steven Lembark 22:01

Dec. 10, 2017

Thread Author Time
Re: PG Schema to be used as log and monitoring store Stefan Keller 01:46
Re: PG Schema to be used as log and monitoring store John R Pierce 01:53
Re: PG Schema to be used as log and monitoring store Thomas Kellerer 09:01
Re: PG Schema to be used as log and monitoring store Stefan Keller 13:16
Re: Feature idea: Dynamic Data Making Joe Conway 17:02
Re: Missing RHEL rpm(pg_catcheck-10) in postgres 10 repo. Devrim Gündüz 19:26
Display table entries using partial column entry Sherman Willden 21:50
Re: transaction wrap around Jeff Janes 23:07
Re: Display table entries using partial column entry Melvin Davidson 23:10
Re: Display table entries using partial column entry Gmail 23:39

Dec. 11, 2017

Thread Author Time
Re: Removing INNER JOINs Jim Finnerty 04:33
Is it possible to sort strings in EBCDIC order in PostgreSQL server? Tsunakawa, Takayuki 07:09
Re: Removing INNER JOINs David Rowley 07:15
Re: Is it possible to sort strings in EBCDIC order in PostgreSQL server? Laurenz Albe 08:52
Re: Display table entries using partial column entry Luuk 09:55
Unsigned RPM's ? Patrik Martinsson 10:19
Re: Windows XP to Win 10 migration issue Vincent Veyron 13:37
Re: Removing INNER JOINs Jim Finnerty 13:38
PostgreSQL is so hip again Ray Stell 14:43
Re: Is it possible to sort strings in EBCDIC order in PostgreSQL server? Tom Lane 14:46
Re: Removing INNER JOINs Tom Lane 15:04
Re: PostgreSQL is so hip again Achilleas Mantzios 15:10
Re: Unsigned RPM's ? Patrik Martinsson 15:13
How to know if a database has changed marcelo 16:48
pg_dump and logging marcelo 16:51
Re: How to know if a database has changed Karsten Hilbert 16:58
Re: How to know if a database has changed Walter Nordmann 17:00
Re: pg_dump and logging Karsten Hilbert 17:01
Re: How to know if a database has changed James Keener 17:01
Re: How to know if a database has changed Jaime Casanova 17:13
Re: How to know if a database has changed Andreas Kretschmer 17:26
Re: How to know if a database has changed Andreas Kretschmer 18:49
Re: Is it possible to sort strings in EBCDIC order in PostgreSQL server? Peter Geoghegan 19:00
SearchSysCache() tutorial? Paul Ramsey 19:25
Re: SearchSysCache() tutorial? Paul Ramsey 19:26
Re: SearchSysCache() tutorial? Melvin Davidson 19:37
Re: SearchSysCache() tutorial? Paul Ramsey 19:39
Re: SearchSysCache() tutorial? Melvin Davidson 19:42

Browse Archives

Prev | Next