pgsql-general - April 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)
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, 2017

Thread Author Time
Re: Keycloak and Postgres Bill Moran 10:57
vacuum on table with all rows frozen Tom DalPozzo 16:09
Re: vacuum on table with all rows frozen Adrian Klaver 16:34
Re: vacuum on table with all rows frozen Tom DalPozzo 16:50

April 2, 2017

Thread Author Time
My humble tribute to psql -- usql v0.5.0 Kenneth Shaw 12:55
Re: My humble tribute to psql -- usql v0.5.0 Andy Colson 13:36
Re: My humble tribute to psql -- usql v0.5.0 Kenneth Shaw 13:55
Merging records in a table with 2-columns primary key Alexander Farber 14:26
Re: Merging records in a table with 2-columns primary key Andy Colson 15:13
Re: Merging records in a table with 2-columns primary key Alexander Farber 15:27
Re: Merging records in a table with 2-columns primary key Francisco Olarte 15:37
Re: Merging records in a table with 2-columns primary key Francisco Olarte 15:41

April 3, 2017

Thread Author Time
effective_cache_size X shared_buffer Patrick B 01:23
Re: effective_cache_size X shared_buffer Patrick B 03:33
Re: effective_cache_size X shared_buffer Venkata B Nagothi 04:57
Re: effective_cache_size X shared_buffer Venkata B Nagothi 04:58
Suggestion to improve select pg_reload_conf() Thomas Kellerer 07:31
Re: Suggestion to improve select pg_reload_conf() Achilleas Mantzios 07:39
Re: Suggestion to improve select pg_reload_conf() Michael Paquier 08:12
spin locks and starvation Tom DalPozzo 09:40
Oddity with time zones. Steve Rogerson 10:59
Re: Unexpected interval comparison 📎 Kyotaro HORIGUCHI 11:51
Re: Oddity with time zones. Tom Lane 13:49
Re: My humble tribute to psql -- usql v0.5.0 Merlin Moncure 13:51
Re: Unexpected interval comparison Tom Lane 15:35
Re: PostgreSQL and Kubernetes Joe Conway 16:10
Re: spin locks and starvation George Neuner 19:15
Re: PostgreSQL and Kubernetes Alex Kliukin 20:32
Re: My humble tribute to psql -- usql v0.5.0 Kenneth Shaw 20:48
Re: My humble tribute to psql -- usql v0.5.0 Karsten Hilbert 21:08
Re: My humble tribute to psql -- usql v0.5.0 Kenneth Shaw 21:20
Re: My humble tribute to psql -- usql v0.5.0 Kenneth Shaw 21:42
Re: My humble tribute to psql -- usql v0.5.0 Merlin Moncure 22:02

April 4, 2017

Thread Author Time
"Reverse" inheritance? Tim Uckun 02:07
Re: "Reverse" inheritance? David G. Johnston 02:15
Re: "Reverse" inheritance? Tim Uckun 03:19
Re: "Reverse" inheritance? vinny 06:43
Re: "Reverse" inheritance? Tim Uckun 07:12
Re: Unexpected interval comparison 📎 Kyotaro HORIGUCHI 08:15
Re: "Reverse" inheritance? vinny 09:02
Re: browser interface to forums please? vinny 10:01
Re: browser interface to forums please? Thomas Kellerer 10:17
Re: Unexpected interval comparison Vick Khera 12:39
Re: browser interface to forums please? Stephen Frost 13:04
Query never completes with low work_mem (at least not within one hour) Daniel Westermann 13:20
Re: browser interface to forums please? vinny 13:29
Re: browser interface to forums please? Stephen Frost 13:31
Re: browser interface to forums please? Stephen Frost 14:00
Re: Query never completes with low work_mem (at least not within one hour) Merlin Moncure 14:11
keeping WAL after dropping replication slots Tom DalPozzo 14:45
Re: audit function and old.column Armand Pirvu (home) 15:34
store key name pattern search Armand Pirvu (home) 15:41
WAL being written during SELECT * query Tom DalPozzo 15:46
Re: store key name pattern search Oleg Bartunov 15:50
Re: store key name pattern search Armand Pirvu (home) 16:06
Re: WAL being written during SELECT * query Raymond O'Donnell 17:05
Re: WAL being written during SELECT * query Scott Marlowe 17:18
Re: store key name pattern search Jeff Janes 17:42
Re: store key name pattern search Armand Pirvu (home) 21:10
getting column names Armand Pirvu (home) 21:51
Re: getting column names David G. Johnston 22:00
Re: Unexpected interval comparison 📎 Tom Lane 22:06
Re: getting column names Armand Pirvu (home) 22:13
Re: keeping WAL after dropping replication slots Adrian Klaver 23:55

April 5, 2017

Thread Author Time
Is there a point to having both a normal gist index and an exclude index? Bruno Wolff III 02:58
AEXPR_OR, AEXPR_AND is not in postgres 9.6, how can I rewrite where it used in 9.3 ? lin 03:28
Re: Is there a point to having both a normal gist index and an exclude index? Tom Lane 04:05
Re: AEXPR_OR, AEXPR_AND is not in postgres 9.6, how can I rewrite where it used in 9.3 ? Peter Eisentraut 05:06
Re: keeping WAL after dropping replication slots Tom DalPozzo 06:52
Re: Query never completes with low work_mem (at least not within one hour) Daniel Westermann 06:57
Re: Query never completes with low work_mem (at least not within one hour) Pavel Stehule 07:05
Re: Keycloak and Postgres Marc Tempelmeier 07:24
Re: Query never completes with low work_mem (at least not within one hour) Daniel Westermann 07:28
calculating table and index size Günce Kaya 07:44
expensive function in select list vs limit clause Chris Mair 08:01
Re: Query never completes with low work_mem (at least not within one hour) Pavel Stehule 08:06
Re: Query never completes with low work_mem (at least not within one hour) Daniel Westermann 08:13
Re: Query never completes with low work_mem (at least not within one hour) Pavel Stehule 08:21
Re: Query never completes with low work_mem (at least not within one hour) Daniel Westermann 08:33
Re: Query never completes with low work_mem (at least not within one hour) Pavel Stehule 08:36
Re: calculating table and index size Guillaume Lelarge 08:56
Re: Query never completes with low work_mem (at least not within one hour) Daniel Westermann 09:24
How does hot_standby_feedback work 📎 Александр Киселев 09:37
Re: calculating table and index size Steven Chang 10:02
Re: expensive function in select list vs limit clause Albe Laurenz 10:34
Re: Unexpected interval comparison 📎 Kyotaro HORIGUCHI 11:07
Re: Keycloak and Postgres Bill Moran 11:54
Re: browser interface to forums please? Vincent Veyron 13:11
Re: Query never completes with low work_mem (at least not within one hour) Tom Lane 14:04
Re: browser interface to forums please? vinny 14:14
Re: expensive function in select list vs limit clause Tom Lane 14:29
Re: browser interface to forums please? Adrian Klaver 14:39
Advise on primary key for detail tables (OS: Raspberry Pi) Ertan Küçükoğlu 15:04
Re: expensive function in select list vs limit clause Chris Mair 15:20
Re: expensive function in select list vs limit clause Chris Mair 15:23
Re: Advise on primary key for detail tables (OS: Raspberry Pi) Adrian Klaver 16:16
Re: browser interface to forums please? Magnus Hagander 16:17
Re: browser interface to forums please? Adrian Klaver 16:31
Re: browser interface to forums please? Magnus Hagander 16:49
Re: browser interface to forums please? Steve Litt 16:51
Re: How does hot_standby_feedback work Scott Marlowe 16:59
Re: browser interface to forums please? John McKown 17:05
Re: browser interface to forums please? Joshua D. Drake 17:22
Re: browser interface to forums please? Tim Clarke 17:26
Re: Advise on primary key for detail tables (OS: Raspberry Pi) George Neuner 17:31
Re: browser interface to forums please? Joshua D. Drake 17:44
Re: browser interface to forums please? Adrian Klaver 17:45
Re: browser interface to forums please? Vincent Elschot 17:48
Re: browser interface to forums please? Joshua D. Drake 17:57
Re: Is there a point to having both a normal gist index and an exclude index? Bruno Wolff III 18:04
Re: Is there a point to having both a normal gist index and an exclude index? Rob Sargent 18:11
Re: browser interface to forums please? Adrian Klaver 18:14
Re: Is there a point to having both a normal gist index and an exclude index? Bruno Wolff III 18:20
Re: browser interface to forums please? George Neuner 18:30
Re: browser interface to forums please? John R Pierce 18:39
Re: browser interface to forums please? George Neuner 18:39
Re: Query never completes with low work_mem (at least not within one hour) Daniel Westermann 18:44
Re: browser interface to forums please? Magnus Hagander 18:46
Re: browser interface to forums please? Joshua D. Drake 18:52
Re: Unexpected interval comparison 📎 Tom Lane 19:51
Re: Is there a point to having both a normal gist index and an exclude index? Tom Lane 19:56
Re: browser interface to forums please? George Neuner 20:31
Re: Unexpected interval comparison 📎 Tom Lane 21:06
Re: browser interface to forums please? George Neuner 21:19
Archiving data to another server using copy, psql with pipe pinker 21:26
Re: browser interface to forums please? David G. Johnston 21:44
Is this pgbouncer configuration suitable for a production environment with hundreds of databases? Lisandro 22:29
Re: Is this pgbouncer configuration suitable for a production environment with hundreds of databases? David G. Johnston 22:57
Re: [GENERAL] C++ port of Postgres Andres Freund 23:14
Re: Is this pgbouncer configuration suitable for a production environment with hundreds of databases? Lisandro 23:33

April 6, 2017

Thread Author Time
Re: browser interface to forums please? George Neuner 01:40
A change in the Debian install rob stone 03:03
Re: Unexpected interval comparison Kyotaro HORIGUCHI 03:07
Re: Unexpected interval comparison Tom Lane 03:31
regexp_matches where clause - PG 9.1 Patrick B 03:54
Re: A change in the Debian install Tom Lane 04:05
Re: A change in the Debian install Adrian Klaver 04:14
Re: regexp_matches where clause - PG 9.1 Arjen Nienhuis 05:35
Re: regexp_matches where clause - PG 9.1 Patrick B 06:10
Re: Advise on primary key for detail tables (OS: Raspberry Pi) Ertan Küçükoğlu 10:27
Re: Archiving data to another server using copy, psql with pipe Moreno Andreo 11:24
Re: Archiving data to another server using copy, psql with pipe pinker 11:58
Re: A change in the Debian install Karsten Hilbert 12:03
Re: Archiving data to another server using copy, psql with pipe Moreno Andreo 12:28
Re: Advise on primary key for detail tables (OS: Raspberry Pi) Adrian Klaver 13:17
Re: Advise on primary key for detail tables (OS: Raspberry Pi) Ertan Küçükoğlu 13:40
Re: A change in the Debian install Stephen Frost 13:46
Re: Archiving data to another server using copy, psql with pipe pinker 14:10
Re: Advise on primary key for detail tables (OS: Raspberry Pi) Adrian Klaver 14:33
Re: Archiving data to another server using copy, psql with pipe Moreno Andreo 14:53
Re: Advise on primary key for detail tables (OS: Raspberry Pi) Scott Marlowe 14:57
Re: A change in the Debian install Magnus Hagander 15:04
Re: Archiving data to another server using copy, psql with pipe David G. Johnston 15:46
Re: WAL being written during SELECT * query Tom DalPozzo 15:51
Re: WAL being written during SELECT * query David G. Johnston 16:30
Re: [GENERAL] C++ port of Postgres Peter Eisentraut 18:23
Re: keeping WAL after dropping replication slots Adrian Klaver 19:51
Re: A change in the Debian install rob stone 22:16
Re: A change in the Debian install Adrian Klaver 22:58

April 7, 2017

Thread Author Time
Re: regexp_matches where clause - PG 9.1 Patrick B 01:33
Re: regexp_matches where clause - PG 9.1 David G. Johnston 02:08
Re: regexp_matches where clause - PG 9.1 Patrick B 02:15
Re: regexp_matches where clause - PG 9.1 Arjen Nienhuis 02:15
Re: regexp_matches where clause - PG 9.1 Arjen Nienhuis 02:18
Re: regexp_matches where clause - PG 9.1 David G. Johnston 02:19
Re: regexp_matches where clause - PG 9.1 Patrick B 02:49
Re: A change in the Debian install rob stone 03:01
Re: A change in the Debian install Adrian Klaver 04:24
Re: keeping WAL after dropping replication slots Tom DalPozzo 06:18
Re: keeping WAL after dropping replication slots Chris Mair 06:26
Re: calculating table and index size Günce Kaya 07:11
Re: A change in the Debian install Christoph Berg 13:38
Re: keeping WAL after dropping replication slots Adrian Klaver 13:57
Re: A change in the Debian install Joshua D. Drake 14:10
Re: [ADMIN] calculating table and index size Alban Hertroys 14:58
Re: [ADMIN] calculating table and index size Guillaume Lelarge 15:30
Re: pg_dump: creates dumps that cannot be restored 📎 Thorsten Glaser 18:10
SELECT and RowExclusiveLock Tim Nelson 20:25
Re: SELECT and RowExclusiveLock Adrian Klaver 20:40
Re: SELECT and RowExclusiveLock David G. Johnston 20:40
Unable to connect to Postgresql John Iliffe 21:38
Re: Unable to connect to Postgresql Adrian Klaver 22:51
Re: Unable to connect to Postgresql Adrian Klaver 22:58
Re: Unable to connect to Postgresql Adrian Klaver 23:51
Re: Unable to connect to Postgresql John Iliffe 23:57

April 8, 2017

Thread Author Time
Re: Unable to connect to Postgresql Adrian Klaver 00:35
Re: Unable to connect to Postgresql Adrian Klaver 00:39
Re: Unable to connect to Postgresql John Iliffe 00:56
Re: Unable to connect to Postgresql John Iliffe 01:11
Re: Unable to connect to Postgresql Joe Conway 02:45
Re: SELECT and RowExclusiveLock Tom Lane 03:04
Re: A change in the Debian install rob stone 03:56
Re: Unable to connect to Postgresql Adrian Klaver 04:10
Re: keeping WAL after dropping replication slots Tom DalPozzo 08:15
Re: A change in the Debian install Daniel Verite 11:55
Re: Unable to connect to Postgresql John Iliffe 13:12
Re: Unable to connect to Postgresql Daniel Verite 13:20
Re: Unable to connect to Postgresql John Iliffe 13:26
Re: Unable to connect to Postgresql John Iliffe 13:31
Re: A change in the Debian install Adrian Klaver 13:35

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