pgsql-general since 2016-11-19 00:00

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

Nov. 19, 2016

Thread Author Time
How to change order sort of table in HashJoin Man Trieu 05:46
Database migration to RDS issues permissions Fran ... 13:21
Re: Database migration to RDS issues permissions Adrian Klaver 14:41
Re: [GENERAL] How to change order sort of table in HashJoin Melvin Davidson 14:44
Re: Partial update on an postgres upsert violates constraint Adrian Klaver 14:54
Re: Database migration to RDS issues permissions Fran ... 15:21
Re: [HACKERS] How to change order sort of table in HashJoin Tom Lane 16:18
Re: Database migration to RDS issues permissions Tom Lane 16:25
Re: Database migration to RDS issues permissions Adrian Klaver 17:24
Re: Database migration to RDS issues permissions Fran ... 17:33
Re: Database migration to RDS issues permissions Tom Lane 17:38
Re: Database migration to RDS issues permissions Adrian Klaver 17:41
Re: Database migration to RDS issues permissions Fran ... 19:12
Re: Partial update on an postgres upsert violates constraint Kim Rose Carlsen 19:33
Re: Partial update on an postgres upsert violates constraint Adrian Klaver 20:48
Re: Partial update on an postgres upsert violates constraint Tom Lane 20:57
Strict min and max aggregate functions Jeff Janes 21:12
Re: Database migration to RDS issues permissions Adrian Klaver 21:18
Re: Database migration to RDS issues permissions Adrian Klaver 22:49

Nov. 20, 2016

Thread Author Time
Re: pgbench and scaling rakeshkumar464 00:01
Re: Feature request: separate logging Guillaume Lelarge 03:56
Re: Trim performance on 9.5 Vincent Elschot 08:12
Re: Strict min and max aggregate functions Kim Rose Carlsen 09:35
Re: How to change order sort of table in HashJoin Man 10:21
Re: Strict min and max aggregate functions Pavel Stehule 10:45
Re: Strict min and max aggregate functions Thomas Kellerer 11:01
Autovacuum and frequent pg_bulkload Job 12:51
Re: Autovacuum and frequent pg_bulkload Adrian Klaver 14:50
R: Autovacuum and frequent pg_bulkload Job 15:20
Re: R: Autovacuum and frequent pg_bulkload Adrian Klaver 16:03
Re: How to change order sort of table in HashJoin Tom Lane 16:39
Re: Strict min and max aggregate functions Jeff Janes 19:18
Re: Strict min and max aggregate functions Pavel Stehule 19:29
Re: Strict min and max aggregate functions Tom Lane 19:37

Nov. 21, 2016

Thread Author Time
Re: Feature request: separate logging Michael Paquier 01:09
pg_basebackup on slave running for a long time Subhankar Chattopadhyay 05:29
Re: pg_basebackup on slave running for a long time John R Pierce 05:52
Re: pg_basebackup on slave running for a long time Subhankar Chattopadhyay 06:00
Re: pg_basebackup on slave running for a long time John R Pierce 06:12
Re: pg_basebackup on slave running for a long time Subhankar Chattopadhyay 06:37
Re: pg_basebackup on slave running for a long time John R Pierce 06:46
Re: pg_basebackup on slave running for a long time Subhankar Chattopadhyay 07:00
Re: pg_basebackup on slave running for a long time John R Pierce 07:10
Re: Partial update on an postgres upsert violates constraint Andreas Terrius 10:32
query locks up when run concurrently azhwkd 12:57
Re: How to change order sort of table in HashJoin Man 13:12
Re: How the Planner in PGStrom differs from PostgreSQL? Mark Anns 13:15
How to introspect autovacuum analyze settings Benedikt Grundmann 13:44
Re: How to introspect autovacuum analyze settings Adrian Klaver 14:51
Postgresql 9.5 and Shell scripts/variables vs. C programming/defining a value to be used Poul Kristensen 14:56
Re: How to introspect autovacuum analyze settings Guillaume Lelarge 14:57
Re: How to introspect autovacuum analyze settings Benedikt Grundmann 15:05
Re: Postgresql 9.5 and Shell scripts/variables vs. C programming/defining a value to be used Adrian Klaver 15:11
Re: Postgresql 9.5 and Shell scripts/variables vs. C programming/defining a value to be used John McKown 15:15
Re: Partial update on an postgres upsert violates constraint Adrian Klaver 15:24
Re: pg_class (system) table increasing size. dhaval jaiswal 17:34
Re: pg_class (system) table increasing size. Alvaro Herrera 17:44
Re: pg_class (system) table increasing size. David G. Johnston 17:45
Re: pg_class (system) table increasing size. dhaval jaiswal 17:45
Re: pg_class (system) table increasing size. Igor Neyman 17:47
Re: pg_class (system) table increasing size. Alvaro Herrera 17:49
Re: pg_class (system) table increasing size. Kevin Grittner 18:34
variable value in array_to_string Armand Pirvu (home) 22:09
Re: variable value in array_to_string David G. Johnston 22:26
Re: variable value in array_to_string Armand Pirvu (home) 23:02
Re: variable value in array_to_string Armand Pirvu (home) 23:15
Re: Database migration to RDS issues permissions Fran ... 23:34
Re: Postgresql 9.5 and Shell scripts/variables vs. C programming/defining a value to be used John McKown 23:48

Nov. 22, 2016

Thread Author Time
Re: variable value in array_to_string David G. Johnston 01:12
Re: variable value in array_to_string Armand Pirvu (home) 01:33
Re: variable value in array_to_string David G. Johnston 01:58
Methods to quiesce PostgreSQL DB without configuring log archival MEERA 06:23
How to open PGStrom (an extension of PostgreSQL) in Netbeans? Mark Anns 07:28
Re: How to open PGStrom (an extension of PostgreSQL) in Netbeans? Mark Anns 07:38
Re: How to open PGStrom (an extension of PostgreSQL) in Netbeans? John R Pierce 07:59
Re: How to open PGStrom (an extension of PostgreSQL) in Netbeans? Mark Anns 08:29
Replication of a database or schemas from a database Johann Spies 09:24
Re: pg_basebackup on slave running for a long time Subhankar Chattopadhyay 10:34
Re: pg_basebackup on slave running for a long time Subhankar Chattopadhyay 11:41
pg_rewind and WAL size... marin 12:40
Re: pg_rewind and WAL size... Michael Paquier 12:57
Re: Postgresql 9.5 and Shell scripts/variables vs. C programming/defining a value to be used Poul Kristensen 14:22
Re: Database migration to RDS issues permissions Adrian Klaver 14:42
Re: Postgresql 9.5 and Shell scripts/variables vs. C programming/defining a value to be used Tom Lane 14:46
Re: Postgresql 9.5 and Shell scripts/variables vs. C programming/defining a value to be used John McKown 14:50
Re: How to open PGStrom (an extension of PostgreSQL) in Netbeans? John R Pierce 16:40
Re: pg_basebackup on slave running for a long time John R Pierce 16:42
Re: pg_basebackup on slave running for a long time John R Pierce 16:51
Re: Streaming replication failover/failback Israel Brewster 16:57
Re: pg_basebackup on slave running for a long time Subhankar Chattopadhyay 17:04
max_connections limit violation not showing in pg_stat_activity Charles Clavadetscher 18:48
min/max_wal_size Torsten Förtsch 20:51
Re: min/max_wal_size Adrian Klaver 21:34
Re: max_connections limit violation not showing in pg_stat_activity Kevin Grittner 21:37

Nov. 23, 2016

Thread Author Time
Wal files - Question | Postgres 9.2 Patrick B 02:03
Re: Wal files - Question | Postgres 9.2 Venkata B Nagothi 02:55
Re: Wal files - Question | Postgres 9.2 Patrick B 02:59
Re: Wal files - Question | Postgres 9.2 Venkata B Nagothi 03:18
Re: How to open PGStrom (an extension of PostgreSQL) in Netbeans? Mark Anns 05:15
query locks up when run concurrently azhwkd 07:41
Re: min/max_wal_size Torsten Förtsch 08:44
Re: min/max_wal_size Albe Laurenz 10:04
Re: max_connections limit violation not showing in pg_stat_activity Charles Clavadetscher 10:43
Re: Postgresql 9.5 and Shell scripts/variables vs. C programming/defining a value to be used Poul Kristensen 10:46
Re: [SPAM] Re: Best practices to manage custom statistics Moreno Andreo 13:24
Re: query locks up when run concurrently Adrian Klaver 15:25
Re: Postgresql 9.5 and Shell scripts/variables vs. C programming/defining a value to be used David G. Johnston 15:25
Re: Postgresql 9.5 and Shell scripts/variables vs. C programming/defining a value to be used Tom Lane 15:44
Re: [SPAM] Re: Best practices to manage custom statistics Adrian Klaver 15:59
Re: max_connections limit violation not showing in pg_stat_activity Kevin Grittner 16:04
Re: query locks up when run concurrently Tom Lane 16:47
Thank you Melvin Davidson 16:53
Re: Partial update on an postgres upsert violates constraint John R Pierce 17:53
Re: Methods to quiesce PostgreSQL DB without configuring log archival Scott Mead 17:53
Backup "Best Practices" Israel Brewster 18:16
Re: Backup "Best Practices" John R Pierce 18:42
Re: Backup "Best Practices" Israel Brewster 19:20
Re: Backup "Best Practices" John R Pierce 19:31
Re: Backup "Best Practices" Israel Brewster 19:50
Re: Backup "Best Practices" Joe Conway 19:59
Re: Backup "Best Practices" Andreas Kretschmer 20:18
Re: Partial update on an postgres upsert violates constraint Tom Lane 20:19
Re: Postgresql 9.5 and Shell scripts/variables vs. C programming/defining a value to be used Poul Kristensen 20:31
Re: Methods to quiesce PostgreSQL DB without configuring log archival Kevin Grittner 20:34
Re: Methods to quiesce PostgreSQL DB without configuring log archival John R Pierce 20:58
Re: query locks up when run concurrently azhwkd 21:47
Re: query locks up when run concurrently azhwkd 21:52
Query with large in clauses uses a lot of memory greigwise 21:56
Re: Query with large in clauses uses a lot of memory Tom Lane 22:39
Re: query locks up when run concurrently Adrian Klaver 23:26
Re: query locks up when run concurrently Adrian Klaver 23:28

Nov. 24, 2016

Thread Author Time
Re: query locks up when run concurrently azhwkd 06:26
Re: query locks up when run concurrently azhwkd 06:41
PostgreDB stores table name is lower case 王波 07:52
Invoice Table Design Robert Heinen 14:17
Re: Backup "Best Practices" Vick Khera 14:37
Extension compatibility between postgresql minor version David Richer 15:40
Re: Invoice Table Design Melvin Davidson 15:50
Re: Invoice Table Design Rich Shepard 16:11
Re: Extension compatibility between postgresql minor version Vladimir Rusinov 16:19
Re: Extension compatibility between postgresql minor version David Richer 16:23
Re: Extension compatibility between postgresql minor version Adrian Klaver 16:55
Re: Extension compatibility between postgresql minor version David Richer 17:01
Re: Extension compatibility between postgresql minor version Adrian Klaver 17:05
Re: Extension compatibility between postgresql minor version Tom Lane 17:10
Re: query locks up when run concurrently Adrian Klaver 17:20
Re: query locks up when run concurrently Adrian Klaver 17:29
Re: query locks up when run concurrently Adrian Klaver 17:33
Re: [SPAM] Re: [SPAM] Re: Best practices to manage custom statistics Moreno Andreo 17:59
Re: Extension compatibility between postgresql minor version David Richer 18:09
Re: performance problems with bulk inserts/updates on tsrange with gist-based exclude constrains Chris Withers 18:12
Re: query locks up when run concurrently Adrian Klaver 18:14
Re: performance problems with bulk inserts/updates on tsrange with gist-based exclude constrains Chris Withers 18:14
Re: [SPAM] Re: [SPAM] Re: Best practices to manage custom statistics Adrian Klaver 18:51
Re: query locks up when run concurrently azhwkd 21:23
Re: query locks up when run concurrently Adrian Klaver 21:34
Re: query locks up when run concurrently azhwkd 22:14

Nov. 25, 2016

Thread Author Time
Re: Wal files - Question | Postgres 9.2 Patrick B 01:05
Re: Wal files - Question | Postgres 9.2 Michael Paquier 01:21
Re: query locks up when run concurrently rob stone 01:34
Query regarding deadlock Yogesh Sharma 01:44
Re: Query regarding deadlock John R Pierce 01:55
Re: Query regarding deadlock Yogesh Sharma 02:06
Re: Query regarding deadlock Sameer Kumar 02:14
Re: Query regarding deadlock Jan de Visser 02:17
Re: Query regarding deadlock Michael Paquier 02:19
Re: Query regarding deadlock Sameer Kumar 02:24
Re: Query regarding deadlock Tom Lane 04:45
Re: Import data from MS SQL Server 2014 to Postgresql 9.6 using dbi-link and fdw (error: utf-8/uft-16) Juliano 11:03
pg_dump system catalog Juliano 11:11
Re: pg_dump system catalog Achilleas Mantzios 11:31
pg_am access in simple transaction? pinker 12:40
Replicating hundreds of thousandw of rows Job 14:23
Re: Replicating hundreds of thousandw of rows Simon Riggs 14:52
Re: pg_am access in simple transaction? Adrian Klaver 14:54
Re: query locks up when run concurrently Adrian Klaver 15:01
Re: pg_am access in simple transaction? pinker 15:04
Re: Replicating hundreds of thousandw of rows Moreno Andreo 15:35
Re: pg_am access in simple transaction? Adrian Klaver 15:42
Re: pg_am access in simple transaction? Tom Lane 17:24
Re: [GENERAL] Documentation archive links broken for 6.3 up to 7.1 Bruce Momjian 18:09
Re: [GENERAL] Documentation archive links broken for 6.3 up to 7.1 Magnus Hagander 18:57
Re: Backup "Best Practices" Jeff Janes 22:00
Re: PostgreDB stores table name is lower case Gavin Flower 22:49
Re: Query regarding deadlock Jeff Janes 23:08
Re: PostgreDB stores table name is lower case Adrian Klaver 23:19
Re: PostgreDB stores table name is lower case Tom Lane 23:44

Nov. 26, 2016

Thread Author Time
'pg_ctl restart' does not terminate twoflower 15:15
Re: 'pg_ctl restart' does not terminate Adrian Klaver 15:25
Re: 'pg_ctl restart' does not terminate twoflower 15:47
Re: 'pg_ctl restart' does not terminate Adrian Klaver 17:13
Re: 'pg_ctl restart' does not terminate twoflower 19:08
Re: 'pg_ctl restart' does not terminate Adrian Klaver 19:25
Re: 'pg_ctl restart' does not terminate twoflower 19:33
Re: query locks up when run concurrently azhwkd 19:42
Re: 'pg_ctl restart' does not terminate Adrian Klaver 19:47
Re: 'pg_ctl restart' does not terminate twoflower 19:52
Re: 'pg_ctl restart' does not terminate Melvin Davidson 22:17

Nov. 27, 2016

Thread Author Time
Re: Postgresql 9.5 and Shell scripts/variables vs. C programming/defining a value to be used Poul Kristensen 21:56

Nov. 28, 2016

Thread Author Time
Re: pg_dump system catalog Juliano 11:40

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