pgsql-general - January 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 31

Jan. 1, 2017

Thread Author Time
Re: default representation of null in psql Chris Withers 21:45

Jan. 2, 2017

Thread Author Time
Difficulty modelling sales taxes Frank Millman 10:33
Re: Difficulty modelling sales taxes amul sul 10:42
COPY: row is too big vod vos 11:11
Queries on very big table Job 11:23
Re: Difficulty modelling sales taxes Frank Millman 11:29
Re: Difficulty modelling sales taxes Melvin Davidson 14:38
Re: COPY: row is too big John McKown 14:42
Re: COPY: row is too big Adrian Klaver 14:48
Re: Difficulty modelling sales taxes Adrian Klaver 14:58
Cannot recover from backup on barman Alfredo Palhares 15:20
Re: COPY: row is too big vod vos 15:38
Re: Queries on very big table Andy Colson 15:43
Re: Difficulty modelling sales taxes Melvin Davidson 16:02
Re: Difficulty modelling sales taxes David G. Johnston 16:17
Re: Difficulty modelling sales taxes David G. Johnston 16:20
Re: COPY: row is too big Tom Lane 16:21
Re: Difficulty modelling sales taxes Adrian Klaver 16:27
Re: Difficulty modelling sales taxes Vincent Veyron 16:31
Re: COPY: row is too big vod vos 17:03
Re: COPY: row is too big Adrian Klaver 17:13
Re: COPY: row is too big Rob Sargent 20:57
R: Queries on very big table Job 22:54
Re: streaming replication protocol in Perl? Greg Sabino Mullane 23:24

Jan. 3, 2017

Thread Author Time
Error dumping 9.4: could not parse numeric array Devrim Gündüz 11:19
Re: Error dumping 9.4: could not parse numeric array Achilleas Mantzios 12:50
Re: Cannot recover from backup on barman Michael Paquier 12:52
Re: COPY: row is too big John McKown 13:24
Re: Error dumping 9.4: could not parse numeric array Adrian Klaver 14:18
Re: Error dumping 9.4: could not parse numeric array Tom Lane 14:43
Re: Error dumping 9.4: could not parse numeric array Devrim Gündüz 15:05
questions about 2nd index on one column Ravi Kapoor 19:07
Re: questions about 2nd index on one column Adrian Klaver 19:24
Re: questions about 2nd index on one column Adrian Klaver 19:26
Re: questions about 2nd index on one column Adrian Klaver 20:09
Re: questions about 2nd index on one column Ravi Kapoor 21:00

Jan. 4, 2017

Thread Author Time
could not load library "$libdir/sslutils": in pg_upgrade process DrakoRod 00:39
Re: could not load library "$libdir/sslutils": in pg_upgrade process Adrian Klaver 00:53
Re: What's the benefit (or usage scenario) of a "typed table"? Peter Eisentraut 04:57
Re: could not load library "$libdir/sslutils": in pg_upgrade process DrakoRod 05:01
Performance degradation when using auto_explain Kisung Kim 05:03
Re: Re: could not load library "$libdir/sslutils": in pg_upgrade process Tom Lane 05:14
Re: Performance degradation when using auto_explain Andreas Kretschmer 09:21
Re: COPY: row is too big vod vos 13:00
Re: Row value expression much faster than equivalent OR clauses Kevin Grittner 14:49
Re: COPY: row is too big Adrian Klaver 14:53
Re: COPY: row is too big Pavel Stehule 14:54
vacuum of empty table slows down as database table count grows marcin kowalski 14:57
Re: COPY: row is too big Adrian Klaver 15:11
Re: Re: could not load library "$libdir/sslutils": in pg_upgrade process Adrian Klaver 15:19
Re: COPY: row is too big Pavel Stehule 15:20
Re: COPY: row is too big vod vos 15:21
Fwd: Cannot recover from backup on barman Alfredo Palhares 15:45
Re: COPY: row is too big Peter J. Holzer 15:58
Re: COPY: row is too big rob stone 16:00
Re: COPY: row is too big Adrian Klaver 16:13
Re: COPY: row is too big Steve Crawford 16:32
Re: COPY: row is too big Adrian Klaver 16:39
replication slot to be used in the future Tom DalPozzo 16:44
Index impact on update? Israel Brewster 16:59
Re: Index impact on update? Paul Ramsey 17:08
Re: Index impact on update? Rob Sargent 17:10
Re: Index impact on update? Rob Sargent 17:10
Re: Index impact on update? Israel Brewster 17:16
Re: replication slot to be used in the future Adrian Klaver 17:24
Re: could not load library "$libdir/sslutils": in pg_upgrade process DrakoRod 17:27
Re: replication slot to be used in the future Tom DalPozzo 17:32
Re: Index impact on update? Israel Brewster 17:38
Re: Re: could not load library "$libdir/sslutils": in pg_upgrade process Adrian Klaver 17:41
Re: vacuum of empty table slows down as database table count grows Jerry Sievers 19:22
Re: vacuum of empty table slows down as database table count grows Pavel Stehule 19:32
Re: vacuum of empty table slows down as database table count grows Pavel Stehule 19:33
Re: Performance degradation when using auto_explain Kisung Kim 19:54
Re: Performance PLV8 vs PLPGSQL Merlin Moncure 22:55

Jan. 5, 2017

Thread Author Time
Re: Performance degradation when using auto_explain Tomas Vondra 00:08
Re: could not load library "$libdir/sslutils": in pg_upgrade process DrakoRod 00:13
Re: Index impact on update? Tomas Vondra 00:18
Postgresql query HAVING do not work Gwork 01:23
Re: Postgresql query HAVING do not work Vitaly Burovoy 01:52
Re: Postgresql query HAVING do not work Vitaly Burovoy 02:22
Re: [BUGS] Postgresql query HAVING do not work Vitaly Burovoy 02:51
Re: [BUGS] Postgresql query HAVING do not work Gwork 03:12
Re: The best way to deal with hierarchical data (was: Postgresql query HAVING do not work) Vitaly Burovoy 05:19
Re: vacuum of empty table slows down as database table count grows marcin kowalski 07:18
Re: COPY: row is too big vod vos 12:44
Re: vacuum of empty table slows down as database table count grows marcin kowalski 12:47
Re: COPY: row is too big Pavel Stehule 13:19
Re: Queries on very big table junior 14:15
Re: COPY: row is too big Adrian Klaver 15:01
requested timeline doesn't contain minimum recovery point Tom DalPozzo 16:01
Re: Postgresql query HAVING do not work Merlin Moncure 16:21
Re: COPY: row is too big Rob Sargent 16:31
Postgres 9.6.1 big slowdown by upgrading 8.4.22 Job 17:18
Re: Postgres 9.6.1 big slowdown by upgrading 8.4.22 Rob Sargent 17:28
Re: Postgres 9.6.1 big slowdown by upgrading 8.4.22 Tom Lane 17:30
Improve PostGIS performance with 62 million rows? Israel Brewster 17:45
Re: Improve PostGIS performance with 62 million rows? Paul Ramsey 17:50
Re: COPY: row is too big Adrian Klaver 18:46
psql error (encoding related?) BRUSSER Michael 18:57
Re: COPY: row is too big Rob Sargent 18:59
Re: Row value expression much faster than equivalent OR clauses Merlin Moncure 19:14
Re: Improve PostGIS performance with 62 million rows? Israel Brewster 19:36
Re: Improve PostGIS performance with 62 million rows? Paul Ramsey 19:38
Re: Improve PostGIS performance with 62 million rows? Israel Brewster 21:00
Re: psql error (encoding related?) Torsten Förtsch 21:43
Re: psql error (encoding related?) Tom Lane 22:04
FATAL: requested WAL segment has already been removed Patrick B 22:07
Re: Improve PostGIS performance with 62 million rows? Paul Ramsey 22:09
Re: Improve PostGIS performance with 62 million rows? Rémi Cura 22:38
Re: Improve PostGIS performance with 62 million rows? Israel Brewster 22:43
Re: Improve PostGIS performance with 62 million rows? Israel Brewster 22:55

Jan. 6, 2017

Thread Author Time
PostgreSQL not reusing free space in table ? Pierre Ducroquet 10:09
Re: requested timeline doesn't contain minimum recovery point Michael Paquier 12:09
Re: psql error (encoding related?) BRUSSER Michael 13:32
Re: requested timeline doesn't contain minimum recovery point Tom DalPozzo 13:41
Re: psql error (encoding related?) Adrian Klaver 14:21
Re: PostgreSQL not reusing free space in table ? Merlin Moncure 15:00
Re: Write-optimized data structures Merlin Moncure 15:27
R: Postgres 9.6.1 big slowdown by upgrading 8.4.22 Job 15:56
Re: PostgreSQL not reusing free space in table ? Pierre Ducroquet 16:00
Re: Queries on very big table Merlin Moncure 20:34
Re: Postgres 9.6.1 big slowdown by upgrading 8.4.22 Alban Hertroys 21:56
Re: Postgres 9.6.1 big slowdown by upgrading 8.4.22 Melvin Davidson 23:47

Jan. 7, 2017

Thread Author Time
Re: Postgres 9.6.1 big slowdown by upgrading 8.4.22 Venkata B Nagothi 03:43
Re: Postgres 9.6.1 big slowdown by upgrading 8.4.22 Tomas Vondra 09:55
R: Postgres 9.6.1 big slowdown by upgrading 8.4.22 Job 14:44
Re: R: Postgres 9.6.1 big slowdown by upgrading 8.4.22 Adrian Klaver 15:18
join_collapse_limit = 14 Andreas Joseph Krogh 16:33
Re: join_collapse_limit = 14 Andreas Joseph Krogh 16:42
Re: join_collapse_limit = 14 Tom Lane 16:48
Re: join_collapse_limit = 14 Andreas Joseph Krogh 17:12
Re: join_collapse_limit = 14 Tom Lane 17:25
Re: join_collapse_limit = 14 Andreas Joseph Krogh 17:44

Jan. 8, 2017

Thread Author Time
Re: Postgres 9.6.1 big slowdown by upgrading 8.4.22 Alban Hertroys 00:12
Re: Postgres 9.6.1 big slowdown by upgrading 8.4.22 Tomas Vondra 02:28
Re: Postgres 9.6.1 big slowdown by upgrading 8.4.22 Tom Lane 02:37
Catalog table which stores database level information Shrikant Bhende 04:12
Re: Catalog table which stores database level information Adrian Klaver 04:18
R: Postgres 9.6.1 big slowdown by upgrading 8.4.22 Job 10:23
Re: R: Postgres 9.6.1 big slowdown by upgrading 8.4.22 Thomas Kellerer 11:21
R: Postgres 9.6.1 big slowdown by upgrading 8.4.22 Job 11:24
Re: Catalog table which stores database level information Feike Steenbergen 11:46
some amazing stuff sin 11:51
R: Postgres 9.6.1 big slowdown by upgrading 8.4.22 Job 13:05
Re: Postgres 9.6.1 big slowdown by upgrading 8.4.22 Chris Mair 15:25
R: Postgres 9.6.1 big slowdown by upgrading 8.4.22 Job 15:30
Re: R: Postgres 9.6.1 big slowdown by upgrading 8.4.22 Tom Lane 16:21
Re: R: Postgres 9.6.1 big slowdown by upgrading 8.4.22 Adrian Klaver 17:14

Jan. 9, 2017

Thread Author Time
R: R: Postgres 9.6.1 big slowdown by upgrading 8.4.22 Job 09:33
checkpoint clarifications needed Tom DalPozzo 14:14
Re: Querying dead rows Albe Laurenz 14:24
Re: checkpoint clarifications needed Adrian Klaver 14:26
Re: checkpoint clarifications needed Tom DalPozzo 14:47
Re: checkpoint clarifications needed Adrian Klaver 15:11
Re: checkpoint clarifications needed Adrian Klaver 15:37
Re: R: R: Postgres 9.6.1 big slowdown by upgrading 8.4.22 Adrian Klaver 16:26
Why autvacuum is not started? Edmundo Robles 16:45
Re: Why autvacuum is not started? Adrian Klaver 17:24
Re: Improve PostGIS performance with 62 million rows? Israel Brewster 17:49
Re: Why autvacuum is not started? Jeff Janes 17:51
Re: Improve PostGIS performance with 62 million rows? Paul Ramsey 18:00
Re: Improve PostGIS performance with 62 million rows? Jonathan Vanasco 19:11
Re: Improve PostGIS performance with 62 million rows? Rémi Cura 20:53
Re: checkpoint clarifications needed Tom DalPozzo 21:10
Re: checkpoint clarifications needed Adrian Klaver 21:24
Matching indexe for timestamp Job 21:58
Re: checkpoint clarifications needed Alvaro Herrera 22:01
Re: checkpoint clarifications needed Tom DalPozzo 22:23
Re: checkpoint clarifications needed Alvaro Herrera 22:31
Re: checkpoint clarifications needed Tom DalPozzo 22:45
Re: checkpoint clarifications needed Tom DalPozzo 22:47
Re: Improve PostGIS performance with 62 million rows? Kevin Grittner 22:54
Re: Matching indexe for timestamp Adrian Klaver 23:27
Re: R: Matching indexe for timestamp Adrian Klaver 23:50
Re: Matching indexe for timestamp David G. Johnston 23:53

Jan. 10, 2017

Thread Author Time
Re: Matching indexe for timestamp Vitaly Burovoy 00:09
Slow index scan - Pgsql 9.2 Patrick B 01:06
Re: Slow index scan - Pgsql 9.2 Jan de Visser 02:30
Re: Slow index scan - Pgsql 9.2 David Rowley 02:34
Re: Slow index scan - Pgsql 9.2 David G. Johnston 02:34
Re: Slow index scan - Pgsql 9.2 Patrick B 03:05
Re: Slow index scan - Pgsql 9.2 David G. Johnston 03:20
Not clear how to switch role without permitting switch back Guyren Howe 07:05
Re: Not clear how to switch role without permitting switch back John R Pierce 08:56
Re: Not clear how to switch role without permitting switch back Alexander M. Sauer-Budge 11:09
Re: Not clear how to switch role without permitting switch back Alexander M. Sauer-Budge 11:40
Re: requested timeline doesn't contain minimum recovery point Tom DalPozzo 13:35
Re: Slow index scan - Pgsql 9.2 Tomas Vondra 15:05
Re: Not clear how to switch role without permitting switch back George Neuner 17:09
Re: some amazing stuff Edmundo Robles 17:22
i got a process holding the lock Edmundo Robles 17:56
Re: i got a process holding the lock Edmundo Robles 17:58
Re: i got a process holding the lock Melvin Davidson 18:02
Re: some amazing stuff Alvaro Herrera 18:27
Materialized view vs. view Job 18:27
Re: Materialized view vs. view Adrian Klaver 18:36
Re: i got a process holding the lock Melvin Davidson 18:39
Re: Materialized view vs. view David G. Johnston 18:42
Re: Materialized view vs. view Melvin Davidson 18:44
Re: i got a process holding the lock Vick Khera 18:50

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