pgsql-general - December 2014

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

Dec. 1, 2014

Thread Author Time
Ever increasing pg_clog disk usage v8.4 Powrie, William 00:34
Is "WITH () UPDATE" Thread Safe ? Paul GOERGLER 08:48
What is default password for user postgres M Tarkeshwar Rao 09:08
Re: Is "WITH () UPDATE" Thread Safe ? Albe Laurenz 09:21
Re: What is default password for user postgres Thom Brown 10:30
Re: Ever increasing pg_clog disk usage v8.4 Eduardo Morras 11:37
Re: Synchronous Replication Timeout Glyn Astill 12:00
Re: What is default password for user postgres Adrian Klaver 14:32
Re: Best filesystem for a high load db Vick Khera 14:38
Re: Lock Management: Waiting on locks Vick Khera 14:40
Re: Re: Remote PostgreSQL database - C/C++ program / Unix / Required Libraries Reid Thompson 14:42
Re: Ever increasing pg_clog disk usage v8.4 Tom Lane 14:47
Re: Ever increasing pg_clog disk usage v8.4 Adrian Klaver 14:50
Re: recovering from "too many failures" wal error Andy Colson 14:59
Re: PG94RC1- plv8 functions - problem with input parameter length Misa Simic 15:20
Slow delete when many foreign tables are defined Giuseppe Sacco 15:23
Re: PG94RC1- plv8 functions - problem with input parameter length Adrian Klaver 15:34
The file of toc.dat (got by using the command: pg_dump -Fd ) may be need to have readability lin 15:35
Re: PG94RC1- plv8 functions - problem with input parameter length Adrian Klaver 15:42
Re: The file of toc.dat (got by using the command: pg_dump -Fd ) may be need to have readability Adrian Klaver 15:45
Re: Slow delete when many foreign tables are defined Andy Colson 15:49
Re: Slow delete when many foreign tables are defined Giuseppe Sacco 16:21
Re: Slow delete when many foreign tables are defined Alban Hertroys 16:37
Programmatic access to interval units Nelson Green 16:42
Re: Slow delete when many foreign tables are defined Andy Colson 17:00
Re: Slow delete when many foreign tables are defined Andy Colson 17:05
Partitioning of a dependent table not based on date Herouth Maoz 17:14
Re: Slow delete when many foreign tables are defined Bill Moran 17:20
Re: Partitioning of a dependent table not based on date Andy Colson 17:26
Re: PG94RC1- plv8 functions - problem with input parameter length Andres Freund 18:02
Re: recovering from "too many failures" wal error Andres Freund 18:08
Re: Programmatic access to interval units Merlin Moncure 20:14
Irreversible SET ROLE Bryn Jeffries 21:14
Re: Irreversible SET ROLE Melvin Davidson 22:51
Merge rows based on Levenshtein distance mongoose 23:48

Dec. 2, 2014

Thread Author Time
Re: Irreversible SET ROLE Tom Lane 00:39
Re: Merge rows based on Levenshtein distance David G Johnston 00:49
Re: Irreversible SET ROLE Bryn Jeffries 00:50
Re: Irreversible SET ROLE Bryn Jeffries 00:52
Re: Irreversible SET ROLE Tom Lane 01:39
Re: PG94RC1- plv8 functions - problem with input parameter length Ilya Ashchepkov 05:40
Re: Serialization exception : Who else was involved? Olivier MATROT 09:06
Re: Serialization exception : Who else was involved? Albe Laurenz 09:54
Re: Partitioning of a dependent table not based on date Herouth Maoz 10:26
Auto vacuum not running -- Could not bind socket for statistics collector Tim Schäfer 15:41
Re: Programmatic access to interval units Nelson Green 15:48
Re: Auto vacuum not running -- Could not bind socket for statistics collector Tom Lane 15:51
Trying to get SSPI/JDBC working Dave Rosckes 16:10
update several columns from function returning several values Rémi Cura 16:15
Re: Programmatic access to interval units Melvin Davidson 16:16
Fwd: [GENERAL] Trying to get SSPI/JDBC working Dave Cramer 16:25
Re: update several columns from function returning several values Tom Lane 17:23
Re: Programmatic access to interval units Merlin Moncure 17:57
Re: Programmatic access to interval units Nelson Green 18:05
Re: JSON_AGG produces extra square brakets Davide S 18:08
Re: JSON_AGG produces extra square brakets Tom Lane 18:40
Re: Programmatic access to interval units Nelson Green 18:40
segmentation fault postgres 9.3.5 core dump perlu related ? Day, David 19:16
Re: Programmatic access to interval units Adrian Klaver 20:25
Re: JSON_AGG produces extra square brakets Davide S 20:32
Re: Trying to get SSPI/JDBC working Adrian Klaver 20:40
Re: [Solved] Programmatic access to interval units Nelson Green 21:05
Re: Programmatic access to interval units Merlin Moncure 21:48
Re: Problem with pg_dump and decimal mark Adrian Klaver 23:13
Re: Postgres 9.2 PITR testing to before DROP DATABASE ends up removing file system files Adrian Klaver 23:39
Re: Postgres 9.2 PITR testing to before DROP DATABASE ends up removing file system files Joshua Boyd 23:50

Dec. 3, 2014

Thread Author Time
Re: Programmatic access to interval units Nelson Green 01:15
Re: Merge rows based on Levenshtein distance mongoose 05:05
Re: Is "WITH () UPDATE" Thread Safe ? Paul GOERGLER 05:26
Re: Is "WITH () UPDATE" Thread Safe ? David G Johnston 06:15
Re: Merge rows based on Levenshtein distance David G Johnston 06:36
Fwd: Problem with pg_dump and decimal mark Eric Svenson 08:23
Re: Auto vacuum not running -- Could not bind socket for statistics collector Tim Schäfer 08:36
Re: Is "WITH () UPDATE" Thread Safe ? Albe Laurenz 08:54
I did some testing of GIST/GIN vs BTree indexing… Guyren Howe 09:15
FW: getting error while running sql on mm_activealrm table M Tarkeshwar Rao 11:07
TRUNCATE and CREATE TABLE LIKE for foreign tables sri harsha 11:22
Re: Fwd: [GENERAL] Trying to get SSPI/JDBC working Craig Ringer 11:22
Re: TRUNCATE and CREATE TABLE LIKE for foreign tables Albe Laurenz 11:40
Re: Trying to get SSPI/JDBC working Craig Ringer 14:28
Re: Auto vacuum not running -- Could not bind socket for statistics collector Adrian Klaver 14:48
Re: FW: getting error while running sql on mm_activealrm table Adrian Klaver 14:52
Re: Fwd: Problem with pg_dump and decimal mark Adrian Klaver 15:24
Re: Trying to get SSPI/JDBC working Dave Rosckes 15:39
Re: Auto vacuum not running -- Could not bind socket for statistics collector Tim Schäfer 15:39
Re: update several columns from function returning several values Rémi Cura 15:42
Mistake in documentation? ANALYZE on partitioned tables pinker 15:52
Re: Auto vacuum not running -- Could not bind socket for statistics collector Tom Lane 16:04
Re: Merge rows based on Levenshtein distance pinker 16:14
Re: Auto vacuum not running -- Could not bind socket for statistics collector Tim Schäfer 16:25
Re: Mistake in documentation? ANALYZE on partitioned tables Tom Lane 16:42
Re: Merge rows based on Levenshtein distance mongoose 18:08
Re: Merge rows based on Levenshtein distance David G Johnston 18:12
Re: Merge rows based on Levenshtein distance David G Johnston 18:44
Re: Merge rows based on Levenshtein distance Michael Nolan 18:51
Re: Merge rows based on Levenshtein distance mongoose 18:55
Re: Merge rows based on Levenshtein distance mongoose 19:00
INSERT to partitioned table doesn't return row count Kris Deugau 19:19
Re: Merge rows based on Levenshtein distance Michael Nolan 20:05
Re: INSERT to partitioned table doesn't return row count Adrian Klaver 20:28
Re: INSERT to partitioned table doesn't return row count David G Johnston 20:48
Re: segmentation fault postgres 9.3.5 core dump perlu related ? Tom Lane 20:56
Re: INSERT to partitioned table doesn't return row count Kris Deugau 21:20
Re: INSERT to partitioned table doesn't return row count David G Johnston 21:31
Re: Postgres 9.2 PITR testing to before DROP DATABASE ends up removing file system files Adrian Klaver 23:22
Re: Postgres 9.2 PITR testing to before DROP DATABASE ends up removing file system files Adrian Klaver 23:37
Re: Postgres 9.2 PITR testing to before DROP DATABASE ends up removing file system files Joshua Boyd 23:52
Re: Postgres 9.2 PITR testing to before DROP DATABASE ends up removing file system files Adrian Klaver 23:59

Dec. 4, 2014

Thread Author Time
Re: High Availability Cluster Sameer Kumar 04:14
Re: Synchronous Replication Timeout Sameer Kumar 04:19
Re: recovering from "too many failures" wal error Sameer Kumar 04:26
Re: High Availability Cluster Tatsuo Ishii 04:32
Re: FW: getting error while running sql on mm_activealrm table M Tarkeshwar Rao 05:30
Re: FW: getting error while running sql on mm_activealrm table John R Pierce 06:14
Re: High Availability Cluster Sameer Kumar 06:28
Re: Fwd: Problem with pg_dump and decimal mark Eric Svenson 10:01
Re: FW: getting error while running sql on mm_activealrm table M Tarkeshwar Rao 11:08
Re: FW: getting error while running sql on mm_activealrm table M Tarkeshwar Rao 12:01
Re: FW: getting error while running sql on mm_activealrm table Adrian Klaver 13:59
Re: FW: getting error while running sql on mm_activealrm table Adrian Klaver 14:06
Re: Fwd: Problem with pg_dump and decimal mark Adrian Klaver 14:23
Re: Trying to get SSPI/JDBC working Dave Rosckes 14:31
Re: Trying to get SSPI/JDBC working Craig Ringer 14:37
Re: segmentation fault postgres 9.3.5 core dump perlu related ? Day, David 14:46
Re: segmentation fault postgres 9.3.5 core dump perlu related ? Tom Lane 15:15
Vacuum freeze Mike Blackwell 17:02
Re: Vacuum freeze Vick Khera 17:26
Re: Vacuum freeze Josh Kupershmidt 18:48
Re: issue in postgresql 9.1.3 in using arrow key in Solaris platform Josh Berkus 19:10
Re: Vacuum freeze Jeff Janes 20:13
execute trigger after another one Carlos Carcamo 22:38
Re: execute trigger after another one David G Johnston 22:46
Re: execute trigger after another one Carlos Carcamo 23:11
Re: execute trigger after another one Stephen Cook 23:21
Re: execute trigger after another one Adrian Klaver 23:31
Re: execute trigger after another one Carlos Carcamo 23:36

Dec. 5, 2014

Thread Author Time
Fwd: Fwd: Problem with pg_dump and decimal mark Eric Svenson 09:13
(never executed) in the execution plan Thomas Kellerer 10:00
Re: (never executed) in the execution plan Albe Laurenz 11:14
Help with ltree queries Tim Smith 11:43
Re: Fwd: Fwd: Problem with pg_dump and decimal mark Adrian Klaver 15:22
Multiple call handlers per language Kelly Burkhart 16:05
Re: Multiple call handlers per language Tom Lane 16:23
Re: autovacuum with inheritance David G Johnston 22:01

Dec. 6, 2014

Thread Author Time
Array Comparison Ian Harding 00:55
Re: Array Comparison Ian Harding 00:59
Weird CPU utilization patterns with Postgres István 01:14
Re: Array Comparison David G Johnston 01:37
Fwd: Array Comparison David Johnston 03:33
Re: Updating timezone setting Bruce Momjian 14:37
Re: I did some testing of GIST/GIN vs BTree indexing… Bruce Momjian 20:38

Dec. 7, 2014

Thread Author Time
Use cases for lateral that do not involve a set returning function AJ Welch 04:40
Strange behavior in generate_series(date, date, interval) with DST Sérgio Saquetim 20:11
Re: Strange behavior in generate_series(date, date, interval) with DST Adrian Klaver 20:49
Re: Strange behavior in generate_series(date, date, interval) with DST Adrian Klaver 22:04
Re: Strange behavior in generate_series(date, date, interval) with DST Sérgio Saquetim 22:25
FW: SQL rolling window without aggregation Huang, Suya 23:13

Dec. 8, 2014

Thread Author Time
Re: FW: SQL rolling window without aggregation AJ Welch 00:42
Re: Strange behavior in generate_series(date, date, interval) with DST Andrew Sullivan 01:05
Re: FW: SQL rolling window without aggregation David G Johnston 02:18
Removing duplicate records from a bulk upload Daniel Begin 03:31
Re: Fwd: Fwd: Problem with pg_dump and decimal mark Eric Svenson 08:21
Re: Strange behavior in generate_series(date, date, interval) with DST Francisco Olarte 09:27
Idle Sessions inTransaction with RELEASE_EXEC_SVP queries and locks chris.jurado 10:05
Updating single/multiple fields of JSON document bln prasad 11:26
Re: Will modifications to unlogged tables also be flused to disk? frank 12:43
Speeding up an in-progress wraparound-preventing vacuum Vincent de Phily 12:54
Re: Fwd: Fwd: Problem with pg_dump and decimal mark Adrian Klaver 14:22
Re: Fwd: Fwd: Problem with pg_dump and decimal mark Eric Svenson 14:53
Re: Fwd: Fwd: Problem with pg_dump and decimal mark Adrian Klaver 15:42
Incremental update for matview - automatic trigger-in-c generator Nguyễn Trần Quốc Vinh 15:59
Re: Removing duplicate records from a bulk upload Andy Colson 16:30
Re: Removing duplicate records from a bulk upload Andy Colson 16:38
Re: Will modifications to unlogged tables also be flused to disk? Jeff Janes 17:55
Divergences in view source code - both servers 9.3.5 Edson Richter 18:13
Re: Speeding up an in-progress wraparound-preventing vacuum Jeff Janes 18:17
Re: Divergences in view source code - both servers 9.3.5 Tom Lane 18:53
Re: Divergences in view source code - both servers 9.3.5 Edson Richter 19:09
Streaming Replication - changing IP addresses Dara Unglaube 19:56
Re: Divergences in view source code - both servers 9.3.5 Tom Lane 20:00
Re: Streaming Replication - changing IP addresses John R Pierce 20:11
Re: Fwd: Fwd: Problem with pg_dump and decimal mark Adrian Klaver 21:57
Re: Removing duplicate records from a bulk upload (rationale behind selecting a method) Daniel Begin 21:59
Re: Removing duplicate records from a bulk upload (rationale behind selecting a method) John R Pierce 23:22

Dec. 9, 2014

Thread Author Time
Re: Speeding up an in-progress wraparound-preventing vacuum Vincent de Phily 00:58
Re: Removing duplicate records from a bulk upload (rationale behind selecting a method) Andy Colson 01:22
Re: Removing duplicate records from a bulk upload (rationale behind selecting a method) Scott Marlowe 02:35
Re: Removing duplicate records from a bulk upload (rationale behind selecting a method) Tom Lane 02:52
Re: FW: SQL rolling window without aggregation Huang, Suya 04:59
Re: FW: SQL rolling window without aggregation David Johnston 05:47
Detecting corruption Anthony Nowocien 07:55
Re: Use cases for lateral that do not involve a set returning function Albe Laurenz 10:24
Re: Removing duplicate records from a bulk upload (rationale behind selecting a method) Daniel Begin 14:58
pg_restore -n sch1 : schema "sch1" does not exist lin 15:29
Re: pg_restore -n sch1 : schema "sch1" does not exist Tom Lane 15:54
List of shorthand casts FarjadFarid(ChkNet) 15:54
Re: Streaming Replication - changing IP addresses Dara Unglaube 17:07
Help Optimizing a Summary Query Robert DiFalco 18:15
Re: Help Optimizing a Summary Query Robert DiFalco 18:18
Re: Streaming Replication - changing IP addresses John R Pierce 18:51

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