pgsql-general - November 2016

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

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

Nov. 1, 2016

Thread Author Time
Re: initdb createuser commands Samuel Williams 00:15
Re: initdb createuser commands Adrian Klaver 00:33
Re: Turning slave into a master - PostgreSQL 9.2 Patrick B 01:54
Re: Turning slave into a master - PostgreSQL 9.2 Patrick B 02:01
Re: Validity of using the test_decoding plugin for production? Michael Paquier 08:00
Postgres create database freezes - trying to run with replication Adam Carrgilson 08:58
pgbench support dynamic identifier name 德哥 09:46
Re: Turning slave into a master - PostgreSQL 9.2 Francisco Olarte 10:23
Re: How to hint 2 coulms IS NOT DISTINCT FROM each other Merlin Moncure 13:13
Re: Turning slave into a master - PostgreSQL 9.2 Scott Marlowe 13:55
Statistics on index usage François Battail 14:43
Re: Statistics on index usage Scott Marlowe 14:51
Re: Statistics on index usage Melvin Davidson 14:52
ENABLE ROW LEVEL SECURITY cause huge produce of checkpoints 📎 david.turon 15:09
Re: Validity of using the test_decoding plugin for production? Joshua Kehn 19:01
Re: Turning slave into a master - PostgreSQL 9.2 Patrick B 19:43

Nov. 2, 2016

Thread Author Time
Re: Validity of using the test_decoding plugin for production? Michael Paquier 00:28
Re: Turning slave into a master - PostgreSQL 9.2 Patrick B 00:48
Re: Turning slave into a master - PostgreSQL 9.2 Scott Marlowe 01:13
Replication (BDR) problem: won't catch up after connection timeout Suomela Tero 12:11
libpq backwards compatbility Andy Halsall 14:58
Hardware recommendations? Steve Atkins 17:03
Re: Hardware recommendations? Joshua D. Drake 17:40
Recover from corrupted database due to failing disk Gionatan Danti 19:02
Questions on Post Setup MASTER and STANDBY replication - Postgres9.1 Joanna Xu 19:49
Re: Hardware recommendations? Scott Marlowe 20:20
Google Cloud Compute Maeldron T. 20:41
Re: Hardware recommendations? Steve Crawford 22:01
Re: Hardware recommendations? John R Pierce 22:19
Re: Checking Postgres Streaming replication delay Jim Nasby 22:45
Re: initdb createuser commands Jim Nasby 23:05
Re: Questions on Post Setup MASTER and STANDBY replication - Postgres9.1 Jim Nasby 23:15
Re: Recover from corrupted database due to failing disk Jim Nasby 23:21
Re: Recover from corrupted database due to failing disk Jim Nasby 23:23

Nov. 3, 2016

Thread Author Time
Re: Replication (BDR) problem: won't catch up after connection timeout Craig Ringer 01:08
Re: Replication (BDR) problem: won't catch up after connection timeout Craig Ringer 01:13
Re: Hardware recommendations? Scott Marlowe 01:23
Re: Recover from corrupted database due to failing disk Gionatan Danti 06:18
Re: Exclude pg_largeobject form pg_dump amul sul 07:22
replication setup: advice needed Dmitry Karasik 09:17
Re: libpq backwards compatbility Michael Paquier 09:35
WAL segmentes names in wrong order? Tom DalPozzo 10:28
Re: WAL segmentes names in wrong order? David Steele 10:37
Re: WAL segmentes names in wrong order? hubert depesz lubaczewski 10:45
Re: WAL segmentes names in wrong order? Tom DalPozzo 11:16
Re: Recover from corrupted database due to failing disk Adrian Klaver 13:20
Re: Exclude pg_largeobject form pg_dump 📎 Guillaume Lelarge 14:01
Re: WAL segmentes names in wrong order? David Steele 15:44

Nov. 4, 2016

Thread Author Time
Re: Exclude pg_largeobject form pg_dump amul sul 06:52
Re: Exclude pg_largeobject form pg_dump Guillaume Lelarge 08:35
High load average every 105 minutes Nhan Nguyen 08:45
Re: High load average every 105 minutes John R Pierce 09:03
Re: replication setup: advice needed Venkata B Nagothi 09:21
Re: Recover from corrupted database due to failing disk Gionatan Danti 10:20
Re: How to hint 2 coulms IS NOT DISTINCT FROM each other Kim Rose Carlsen 13:08
Re: How to hint 2 coulms IS NOT DISTINCT FROM each other Merlin Moncure 13:41
What is the best thing to do with PUBLIC schema in Postgresql database Hu, Patricia 13:58
Re: How to hint 2 coulms IS NOT DISTINCT FROM each other Alban Hertroys 14:38
Re: Recover from corrupted database due to failing disk Adrian Klaver 14:40
Re: Recover from corrupted database due to failing disk Alban Hertroys 15:24
Re: What is the best thing to do with PUBLIC schema in Postgresql database David Steele 16:54
Re: replication setup: advice needed Dmitry Karasik 17:41
CachedPlan logs until full disk Job 20:00
Re: CachedPlan logs until full disk Tom Lane 20:24

Nov. 5, 2016

Thread Author Time
Re: What is the best thing to do with PUBLIC schema in Postgresql database [email protected] 00:45
Trouble with regexp_matches Edson Richter 17:01
Re: Trouble with regexp_matches Adrian Klaver 17:13
Re: Trouble with regexp_matches Tom Lane 17:21
RES: Trouble with regexp_matches Edson Richter 18:08
RES: Trouble with regexp_matches Edson Richter 18:56
Re: RES: Trouble with regexp_matches Adrian Klaver 19:43

Nov. 6, 2016

Thread Author Time
Parallel pg_dump/restore and LOs Andreas Joseph Krogh 11:34
timestamp without timezone to have timezone Benjamin Adams 14:11
Re: timestamp without timezone to have timezone Melvin Davidson 15:10
Re: timestamp without timezone to have timezone Adrian Klaver 16:07
Re: timestamp without timezone to have timezone Steve Crawford 18:16
Re: timestamp without timezone to have timezone Adrian Klaver 20:29
Re: Exclude pg_largeobject form pg_dump 📎 Guillaume Lelarge 20:33

Nov. 7, 2016

Thread Author Time
Dynamic execution returning large result sets Emrul 01:12
Re: Dynamic execution returning large result sets Adrian Klaver 01:18
Linux equivalent library for "postgres.lib" from Windows Gadamsetty, Kiran 05:28
Re: Exclude pg_largeobject form pg_dump amul sul 06:06
Re: High load average every 105 minutes Nhan Nguyen 06:45
Re: High load average every 105 minutes Chris Mair 09:54
Re: High load average every 105 minutes Chris Mair 10:02
Re: High load average every 105 minutes Chris Mair 10:03
Re: Dynamic execution returning large result sets Emrul 10:04
Changing foreign key referential actions in big databases Arthur Silva 10:09
checkpoint_timout with no WAL activity Tom DalPozzo 10:50
Re: What is the best thing to do with PUBLIC schema in Postgresql database Albe Laurenz 11:00
Re: checkpoint_timout with no WAL activity amul sul 12:14
Re: checkpoint_timout with no WAL activity Tom DalPozzo 12:21
Re: checkpoint_timout with no WAL activity Michael Paquier 12:22
Re: checkpoint_timout with no WAL activity Michael Paquier 12:26
Re: checkpoint_timout with no WAL activity Tom DalPozzo 12:32
Database Recovery from Corrupted Dump or Raw database table file. Howard News 12:44
Surviving connections after internet problem Durumdara 13:12
Re: Database Recovery from Corrupted Dump or Raw database table file. Albe Laurenz 13:12
Documentation archive links broken for 6.3 up to 7.1 Daniel Westermann 13:15
Re: Database Recovery from Corrupted Dump or Raw database table file. Howard News 13:23
Re: Database Recovery from Corrupted Dump or Raw database table file. Vick Khera 13:44
Re: Database Recovery from Corrupted Dump or Raw database table file. Howard News 14:14
Re: How to hint 2 coulms IS NOT DISTINCT FROM each other Merlin Moncure 14:22
Re: Changing foreign key referential actions in big databases Adrian Klaver 14:29
Re: Changing foreign key referential actions in big databases Tom Lane 14:33
Re: Surviving connections after internet problem Albe Laurenz 15:06
Re: Changing foreign key referential actions in big databases Arthur Silva 16:13
Re: Changing foreign key referential actions in big databases Arthur Silva 16:17
Re: Questions on Post Setup MASTER and STANDBY replication - Postgres9.1 Joanna Xu 19:29
Abscence of synonym Rakesh Kumar 19:39
Re: Abscence of synonym Andy Colson 20:01
Re: Exclude pg_largeobject form pg_dump 📎 Guillaume Lelarge 21:01

Nov. 8, 2016

Thread Author Time
Re: Exclude pg_largeobject form pg_dump Andreas Joseph Krogh 00:06
Re: checkpoint_timout with no WAL activity Michael Paquier 02:17
Re: High load average every 105 minutes Nhan Nguyen 02:41
Fwd: Creating multiple instances of postresql on Windows environment 📎 kaustubh kelkar 03:27
Re: Linux equivalent library for "postgres.lib" from Windows Michael Paquier 03:51
Re: Linux equivalent library for "postgres.lib" from Windows John R Pierce 04:29
Re: Linux equivalent library for "postgres.lib" from Windows John R Pierce 04:32
Re: Exclude pg_largeobject form pg_dump amul sul 05:01
Re: Linux equivalent library for "postgres.lib" from Windows Gadamsetty, Kiran 05:01
Re: Linux equivalent library for "postgres.lib" from Windows Michael Paquier 05:15
Re: Surviving connections after internet problem Durumdara 10:32
Re: Linux equivalent library for "postgres.lib" from Windows Albe Laurenz 10:37
Re: Surviving connections after internet problem Albe Laurenz 10:42
Re: Fwd: Creating multiple instances of postresql on Windows environment Adrian Klaver 14:44
PHP-Shop with PostgreSQL Michelle Konzack 14:46
Re: PHP-Shop with PostgreSQL John DeSoi 15:51
Re: Fwd: Creating multiple instances of postresql on Windows environment Howard News 17:32
Gin indexes on intarray is fast when value in array does not exists, and slow, when value exists otar shavadze 17:43
Must I create an index for child table if master table have one? Edmundo Robles 18:08
Re: PHP-Shop with PostgreSQL Joshua D. Drake 18:24
Re: Must I create an index for child table if master table have one? David G. Johnston 18:33
Re: Must I create an index for child table if master table have one? Melvin Davidson 18:46
Re: Must I create an index for child table if master table have one? Melvin Davidson 18:51
which work memory parameter is used for what? Hector Yuen 18:53
Re: Gin indexes on intarray is fast when value in array does not exists, and slow, when value exists Oleg Bartunov 18:56
Re: Gin indexes on intarray is fast when value in array does not exists, and slow, when value exists Jeff Janes 19:40
Running on Docker, AWS with Data Stored on EBS Ryan Mahoney 19:48
resolution order for foreign key actions? Karl Czajkowski 20:08
Best practices to manage custom statistics Moreno Andreo 20:13
Re: Running on Docker, AWS with Data Stored on EBS David G. Johnston 20:19
Re: resolution order for foreign key actions? Adrian Klaver 20:20
Gin indexes on intarray is fast when value in array does not exists, and slow, when value exists 📎 otar shavadze 20:27
Re: Best practices to manage custom statistics Adrian Klaver 20:28
Re: Running on Docker, AWS with Data Stored on EBS Ryan Mahoney 20:41
Re: Running on Docker, AWS with Data Stored on EBS David G. Johnston 20:48
Re: resolution order for foreign key actions? David G. Johnston 20:56
Re: PHP-Shop with PostgreSQL Raymond O'Donnell 21:16
which work memory parameter is used for what? Hector Yuen 22:34
Re: resolution order for foreign key actions? 📎 Karl Czajkowski 22:41
Re: Gin indexes on intarray is fast when value in array does not exists, and slow, when value exists Tom Lane 23:05

Nov. 9, 2016

Thread Author Time
Re: which work memory parameter is used for what? John R Pierce 02:02
Re: which work memory parameter is used for what? Andreas Joseph Krogh 02:45
Re: Gin indexes on intarray is fast when value in array does not exists, and slow, when value exists Jeff Janes 04:19
Re: Gin indexes on intarray is fast when value in array does not exists, and slow, when value exists Tom Lane 04:35
Re: ENABLE ROW LEVEL SECURITY cause huge produce of checkpoints Michael Paquier 06:10
Re: ENABLE ROW LEVEL SECURITY cause huge produce of checkpoints david.turon 07:20
FTS query, statistics and planner estimations… Pierre Ducroquet 09:22
Re: [GENERAL] FTS query, statistics and planner estimations… Francisco Olarte 09:40
Re: [GENERAL] Re: [GENERAL] FTS query, statistics and planner estimations… Pavel Stehule 09:51
Re: FTS query, statistics and planner estimations… Artur Zakirov 10:01
Re: FTS query, statistics and planner estimations… Pierre Ducroquet 10:11
Re: Re: [GENERAL] FTS query, statistics and planner estimations… Pierre Ducroquet 10:13
Re: FTS query, statistics and planner estimations… Pierre Ducroquet 10:19
Re: [GENERAL] FTS query, statistics and planner estimations… Pavel Stehule 10:41
Re: [GENERAL] FTS query, statistics and planner estimations… Francisco Olarte 10:44
Re: ENABLE ROW LEVEL SECURITY cause huge produce of checkpoints Tom Lane 14:45
Re: which work memory parameter is used for what? Adrian Klaver 14:54
Re: which work memory parameter is used for what? Andreas Joseph Krogh 15:05
Re: which work memory parameter is used for what? David G. Johnston 16:07
Re: which work memory parameter is used for what? Melvin Davidson 16:11
Postgresql error (and service disruption) on Windows [email protected] 18:10
Postgresql errors on Windows with F-Secure AntiVirus Moreno Andreo 18:29
Re: Postgresql errors on Windows with F-Secure AntiVirus Scott Marlowe 18:56
Re: Postgresql errors on Windows with F-Secure AntiVirus Scott Marlowe 18:58
Role and grants Fran ... 19:05
Re: Role and grants Melvin Davidson 19:53
Re: Role and grants Adrian Klaver 20:02
Re: Role and grants Fran ... 22:46
Re: Role and grants John R Pierce 22:52
Re: Role and grants Adrian Klaver 23:37

Nov. 10, 2016

Thread Author Time
Re: which work memory parameter is used for what? Melvin Davidson 01:35
Re: Postgresql error (and service disruption) on Windows Michael Paquier 02:24
Syncing Data of data type BLOB into Postgres- Bytea Cynthia Hombakazi Ngejane 06:55
How the Planner in PGStrom differs from PostgreSQL? Mark Anns 07:11
Syncing Data of data type BLOB into Postgres- Bytea Cynthia Hombakazi Ngejane 07:35
Re: Linux equivalent library for "postgres.lib" from Windows David Guyot 08:14
Re: initdb createuser commands Samuel Williams 09:59
Import data from MS SQL Server 2014 to Postgresql 9.6 using dbi-link and fdw (error: utf-8/uft-16) Juliano 10:34
Re: Import data from MS SQL Server 2014 to Postgresql 9.6 using dbi-link and fdw (error: utf-8/uft-16) Raymond O'Donnell 10:44
Re: Gin indexes on intarray is fast when value in array does not exists, and slow, when value exists otar shavadze 12:41
Re: Import data from MS SQL Server 2014 to Postgresql 9.6 using dbi-link and fdw (error: utf-8/uft-16) JingYuan Chen 12:49
Postgresql 94 from PostgreSQL RPM Repository (with Yum) Steve Clark 12:56
Re: Import data from MS SQL Server 2014 to Postgresql 9.6 using dbi-link and fdw (error: utf-8/uft-16) Tim Clarke 13:20
Re: Import data from MS SQL Server 2014 to Postgresql 9.6 using dbi-link and fdw (error: utf-8/uft-16) rob stone 13:31
Re: Syncing Data of data type BLOB into Postgres- Bytea Adrian Klaver 14:31
Re: Postgresql 94 from PostgreSQL RPM Repository (with Yum) Devrim Gündüz 14:36
Re: Postgresql 94 from PostgreSQL RPM Repository (with Yum) Adrian Klaver 14:40
Re: Row level security performance joining large tables Stephen Frost 14: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