pgsql-general - December 2015

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, 2015

Thread Author Time
Re: using a postgres table as a multi-writer multi-updater queue Steve Petrie, P.Eng. 04:07
Re: using a postgres table as a multi-writer multi-updater queue Alban Hertroys 08:56
plperlu stored procedure seems to freeze for a minute Peter J. Holzer 14:51
Re: plperlu stored procedure seems to freeze for a minute Adrian Klaver 15:16
Re: plperlu stored procedure seems to freeze for a minute Alvaro Herrera 15:38
Re: plperlu stored procedure seems to freeze for a minute Kevin Grittner 15:42
Re: using a postgres table as a multi-writer multi-updater queue George Neuner 15:55
Re: 2 questions Scott Mead 16:26
Re: XID wraparound with huge pg_largeobject Jeff Janes 17:12
Re: 2 questions anj patnaik 17:16
Re: plperlu stored procedure seems to freeze for a minute Peter J. Holzer 17:58
Re: 2 questions Adrian Klaver 18:01
Re: plperlu stored procedure seems to freeze for a minute Tom Lane 18:13
Re: plperlu stored procedure seems to freeze for a minute Adrian Klaver 18:20
Re: plperlu stored procedure seems to freeze for a minute Peter J. Holzer 19:34
Re: plperlu stored procedure seems to freeze for a minute Peter J. Holzer 19:55
Re: plperlu stored procedure seems to freeze for a minute Peter J. Holzer 20:04
Re: XID wraparound with huge pg_largeobject Roxanne Reid-Bennett 21:48

Dec. 2, 2015

Thread Author Time
Re: Replication with 9.4 Thomas Munro 00:57
json indexing and data types Kaare Rasmussen 06:03
Re: Exclusively locking parent tables while disinheriting children. Amit Langote 07:24
how to import "where exists(subquery)" EXISTS CONDITION performance? shili 07:51
Re: [GENERAL] how to import "where exists(subquery)" EXISTS CONDITION performance? David Rowley 10:51
Re: plperlu stored procedure seems to freeze for a minute Peter J. Holzer 15:26
Could not connect to server: No buffer space available (0x00002747/10055) Leonardo M. Ramé 15:53
Re: Could not connect to server: No buffer space available (0x00002747/10055) Adrian Klaver 16:20
Re: XID wraparound with huge pg_largeobject David Kensiski 16:25
Re: XID wraparound with huge pg_largeobject David Kensiski 16:36
AccessExclusiveLock on tuple? Christophe Pettus 17:01
Re: XID wraparound with huge pg_largeobject CS DBA 17:04
Re: XID wraparound with huge pg_largeobject Jeff Janes 17:18
Re: AccessExclusiveLock on tuple? Bill Moran 17:25
Re: AccessExclusiveLock on tuple? Christophe Pettus 17:31
Re: AccessExclusiveLock on tuple? Bill Moran 17:50
Re: Could not connect to server: No buffer space available (0x00002747/10055) Leonardo M. Ramé 18:07
Re: AccessExclusiveLock on tuple? Christophe Pettus 18:18
Re: AccessExclusiveLock on tuple? Tom Lane 18:29
Re: AccessExclusiveLock on tuple? Christophe Pettus 18:47
Re: Pgbasebackup help David Steele 19:56
Re: AccessExclusiveLock on tuple? rob stone 20:06
Re: full_page_writes on SSD? Jim Nasby 22:43
Re: Can row level security policies also be implemented for views? Jim Nasby 22:46
Re: Can row level security policies also be implemented for views? Caleb Meredith 22:59
Re: Can row level security policies also be implemented for views? Jim Nasby 23:01
Re: XID wraparound with huge pg_largeobject Jim Nasby 23:20
Re: Pgbasebackup help Jim Nasby 23:25

Dec. 3, 2015

Thread Author Time
Re: json indexing and data types Jim Nasby 00:04
9.4 upgrade Help using pg_upgrade Sheena, Prabhjot 00:33
Re: 2 questions Jim Nasby 00:39
Re: 9.4 upgrade Help using pg_upgrade Bruce Momjian 00:58
json indexing and data types Merlin Moncure 01:06
Re: plperlu stored procedure seems to freeze for a minute Jim Nasby 01:07
Re: json indexing and data types Jim Nasby 01:11
loading data into cluster - can I daisy-chain streaming replication? Florin Andrei 01:24
Re: loading data into cluster - can I daisy-chain streaming replication? Dennis 03:54
Re: json indexing and data types Tom Lane 04:04
Support for hardware tokens for server/replication private key mdaswani 04:31
Re: json indexing and data types Kaare Rasmussen 04:38
Re: json indexing and data types Kaare Rasmussen 04:43
Re: json indexing and data types Kaare Rasmussen 04:48
Re: Pgbasebackup help Yelai, Ramkumar IN BLR STS 05:59
Comparing two postgres dump files. Kaushal Shriyan 06:12
RE: [GENERAL] how to import "where exists(subquery)" EXISTS CONDITION performance? Albe Laurenz 09:32
Re: how to import "where exists(subquery)" EXISTS CONDITION performance? John R Pierce 09:42
Re: Comparing two postgres dump files. Nicolas Paris 09:58
Re: fast refresh materialized view 📎 Nguyễn Trần Quốc Vinh 10:17
Re: fast refresh materialized view Nguyễn Trần Quốc Vinh 10:39
Re: fast refresh materialized view Nguyễn Trần Quốc Vinh 10:40
Re: Can row level security policies also be implemented for views? Caleb Meredith 13:17
Re: json indexing and data types Merlin Moncure 14:25
Re: json indexing and data types Merlin Moncure 14:30
Re: plperlu stored procedure seems to freeze for a minute Peter J. Holzer 14:36
Re: plperlu stored procedure seems to freeze for a minute Tom Lane 15:02
Re: Pgbasebackup help John R Pierce 20:38
Re: Pgbasebackup help Andreas Kretschmer 21:04
Re: json indexing and data types Jim Nasby 22:09
Re: loading data into cluster - can I daisy-chain streaming replication? Jim Nasby 22:15
Re: JSONB performance enhancement for 9.6 Jim Nasby 22:31
Re: json indexing and data types Jeff Janes 23:37
Re: Pgbasebackup help Jim Nasby 23:47
Re: Can row level security policies also be implemented for views? Jim Nasby 23:53

Dec. 4, 2015

Thread Author Time
BDR: ALTER statement hanging Selim Tuvi 00:03
Re: fast refresh materialized view Jim Nasby 00:09
How to audit non LDAP connections? Francisco Reyes 00:16
Re: ALTER statement hanging Selim Tuvi 00:31
Re: ALTER statement hanging Selim Tuvi 00:42
Re: BDR: ALTER statement hanging Andreas Kretschmer 06:49
JDBC and inet type Tim Smith 09:41
Re: plperlu stored procedure seems to freeze for a minute Peter J. Holzer 10:15
Re: JDBC and inet type rob stone 11:41
Re: JDBC and inet type Bill Moran 12:17
Re: Pgbasebackup help David Steele 12:38
Re: Pgbasebackup help David Steele 12:56
Re: Pgbasebackup help Yelai, Ramkumar IN BLR STS 13:21
Table with invalid page blocks Gerdan Rezende dos Santos 17:34
question about replication slots Andreas Kretschmer 17:35
Table with invalid page blocks Gerdan Rezende dos Santos 17:35
Re: BDR: ALTER statement hanging Selim Tuvi 17:46
Re: BDR: ALTER statement hanging Andreas Kretschmer 17:59
Re: BDR: ALTER statement hanging Sylvain MARECHAL 18:14
Re: BDR: ALTER statement hanging Selim Tuvi 18:28
Re: BDR: ALTER statement hanging Selim Tuvi 18:31
bdr manual cleanup required Selim Tuvi 19:40

Dec. 5, 2015

Thread Author Time
Deletion Challenge Berend Tober 16:08

Dec. 6, 2015

Thread Author Time
Re: bdr manual cleanup required Sylvain Marechal 12:23
Re: question about replication slots Michael Paquier 14:08
Re: question about replication slots Andreas Kretschmer 16:28
Generating an XSD file from an existing database Blake McBride 21:30
Re: Generating an XSD file from an existing database Rob Sargent 21:47
Re: Generating an XSD file from an existing database Blake McBride 21:59
Re: Generating an XSD file from an existing database Adrian Klaver 22:46

Dec. 7, 2015

Thread Author Time
Re: Table with invalid page blocks Jim Nasby 00:18
Re: plperlu stored procedure seems to freeze for a minute Jim Nasby 00:28
Re: Convert from hex to string Jim Nasby 00:47
Re: FATAL: unable to read data from DB node 0 Jim Nasby 00:56
Re: BDR: ALTER statement hanging Craig Ringer 03:05
Re: JDBC and inet type Tim Smith 11:57
Interrupted streaming replication Tony Nelson 13:25
Re: Interrupted streaming replication Andreas Kretschmer 13:45
Re: Interrupted streaming replication Tony Nelson 13:50
Re: Interrupted streaming replication Melvin Davidson 13:58
Re: Interrupted streaming replication Adrian Klaver 14:00
Re: Interrupted streaming replication Tony Nelson 14:04
Re: Interrupted streaming replication Andreas Kretschmer 14:13
Re: Interrupted streaming replication Adrian Klaver 14:41
Packages for Ubuntu Wily (15.10) Antony Gelberg 17:27
Re: Packages for Ubuntu Wily (15.10) Steve Crawford 17:43
Re: Packages for Ubuntu Wily (15.10) Adrian Klaver 17:45

Dec. 8, 2015

Thread Author Time
aggregation question Chris Withers 11:44
Re: aggregation question David Rowley 11:51
Re: union/difference/intersection question Chris Withers 12:21
Re: BDR: ALTER statement hanging Selim Tuvi 16:50
error on pg_restore anj patnaik 17:00
Re: bdr manual cleanup required Selim Tuvi 17:36
Re: bdr manual cleanup required Sylvain MARECHAL 18:50
Re: Support for hardware tokens for server/replication private key Magnus Hagander 21:05

Dec. 9, 2015

Thread Author Time
Re: error on pg_restore Adrian Klaver 00:23
HELP!!! The WAL Archive is taking up all space FattahRozzaq 00:55
Re: Deletion Challenge Steve Crawford 01:02
Re: Deletion Challenge Adrian Klaver 01:23
Re: bdr manual cleanup required Craig Ringer 04:18
Re: bdr manual cleanup required Sylvain MARECHAL 08:09
Re: Deletion Challenge Berend Tober 08:13
Re: Deletion Challenge Berend Tober 08:24
Re: bdr manual cleanup required Craig Ringer 08:29
Function in PostgreSQL Sachin Srivastava 08:49
Re: Function in PostgreSQL Albe Laurenz 09:28
Postgresql INET select and default route ? Tim Smith 11:20
Re: Postgresql INET select and default route ? Albe Laurenz 12:45
Feature Request: Faceting for full text search Mirek Svoboda 17:30
Re: HELP!!! The WAL Archive is taking up all space Alan Hodgson 19:15
Re: HELP!!! The WAL Archive is taking up all space Adrian Klaver 19:22
Re: HELP!!! The WAL Archive is taking up all space John R Pierce 19:38
Re: Deletion Challenge Adrian Klaver 20:31
Re: Deletion Challenge David G. Johnston 20:43
Re: Deletion Challenge Steve Crawford 21:45
regexp_replace question / help needed Christopher Molnar 21:56
Regexp_replace question / help needed Christopher Molnar 21:58
Re: Regexp_replace question / help needed Tom Lane 22:24
Re: Regexp_replace question / help needed Nicolas Paris 22:25
Re: Regexp_replace question / help needed Jerry Sievers 22:41
Re: Regexp_replace question / help needed Christopher Molnar 23:02
Overhead changing varchar(2000) to text Edson Richter 23:13
Re: Overhead changing varchar(2000) to text Kevin Grittner 23:17
Re: Overhead changing varchar(2000) to text Kevin Grittner 23:31
Re: Overhead changing varchar(2000) to text Edson Richter 23:43

Dec. 10, 2015

Thread Author Time
Re: HELP!!! The WAL Archive is taking up all space FattahRozzaq 00:27
Re: HELP!!! The WAL Archive is taking up all space FattahRozzaq 00:38
Re: HELP!!! The WAL Archive is taking up all space Joshua D. Drake 00:46
Re: HELP!!! The WAL Archive is taking up all space John R Pierce 00:55
Re: HELP!!! The WAL Archive is taking up all space FattahRozzaq 00:59
Re: HELP!!! The WAL Archive is taking up all space Adrian Klaver 01:02
Re: HELP!!! The WAL Archive is taking up all space Andreas Kretschmer 01:05
Re: Deletion Challenge Berend Tober 01:59
[JDBC] plpgsql function with RETURNS SETOF refcursor in JAVA Corradini, Carlos 13:38
[PostgreSQL+SOCI+BOOST] Compile error in core\exchange-traits.h with PG and SOCI on Windows Lawry, Brian 14:55
Re: [PostgreSQL+SOCI+BOOST] Compile error in core\exchange-traits.h with PG and SOCI on Windows Tom Lane 15:10
Re: [PostgreSQL+SOCI+BOOST] Compile error in core\exchange-traits.h with PG and SOCI on Windows Adrian Klaver 15:14
Re: [PostgreSQL+SOCI+BOOST] Compile error in core\exchange-traits.h with PG and SOCI on Windows Adrian Klaver 15:59
Loggingt psql meta-commands oleg yusim 17:58
Re: Loggingt psql meta-commands Adrian Klaver 18:13
Re: Loggingt psql meta-commands Andreas Kretschmer 18:14
Re: Loggingt psql meta-commands John R Pierce 19:40
Re: Loggingt psql meta-commands oleg yusim 19:49
Re: Loggingt psql meta-commands oleg yusim 19:50
Re: Loggingt psql meta-commands Pavel Stehule 19:54
Re: Loggingt psql meta-commands Scott Mead 20:00
Re: Loggingt psql meta-commands Adrian Klaver 20:02
Re: Loggingt psql meta-commands Jerry Sievers 20:16
Re: Loggingt psql meta-commands oleg yusim 20:20
Re: Loggingt psql meta-commands David G. Johnston 20:25
Re: Loggingt psql meta-commands oleg yusim 20:46
Re: Loggingt psql meta-commands David G. Johnston 20:50
Re: Loggingt psql meta-commands oleg yusim 20:56
Re: Loggingt psql meta-commands David G. Johnston 21:24
Re: [JDBC] plpgsql function with RETURNS SETOF refcursor in JAVA Adrian Klaver 21:25
Re: Loggingt psql meta-commands Adrian Klaver 21:29
Re: Loggingt psql meta-commands oleg yusim 21:36
Re: Loggingt psql meta-commands John R Pierce 21:49
Re: Loggingt psql meta-commands Adrian Klaver 22:03

Browse Archives

Prev | Next