pgsql-hackers since 2018-11-09 17:07

The PostgreSQL developers team lives here. Discussion of current development issues, problems and bugs, and proposed new features. If your question cannot be answered by people in the other lists, and it is likely that only a developer will know the answer, you may re-post your question in this list. You must try elsewhere first!

Search the Archives

(enter a message-id to go directly to that message)

Browse Archives

Prev | Next

Nov. 9, 2018

Thread Author Time
Re: BUG #15212: Default values in partition tables don't work as expected and allow NOT NULL violation Alvaro Herrera 17:07
Re: Alternative to \copy in psql modelled after \g Daniel Verite 17:23
Re: [HACKERS] Surjective functional indexes 📎 Konstantin Knizhnik 17:23
Re: speeding up planning with partitions Jesper Pedersen 17:43
Re: ALTER DEFAULT PRIVILEGES is buggy, and so is its testing 📎 Tom Lane 17:45
Changing SQL Inlining Behaviour (or...?) Paul Ramsey 19:01
repeated procedure call error Pavel Stehule 19:05
Re: repeated procedure call error Pavel Stehule 19:07
Re: Changing SQL Inlining Behaviour (or...?) Paul Ramsey 19:14
Re: repeated procedure call error Pavel Stehule 19:37
Re: unused/redundant foreign key code Daniel Gustafsson 20:37
Re: BUG #15212: Default values in partition tables don't work as expected and allow NOT NULL violation Jürgen Strobel 21:03
Re: BUG #15212: Default values in partition tables don't work as expected and allow NOT NULL violation Alvaro Herrera 21:11
Convert MAX_SAOP_ARRAY_SIZE to new guc 📎 James Coleman 21:32
Re: BUG #15212: Default values in partition tables don't work as expected and allow NOT NULL violation Jürgen Strobel 21:34
Re: BUG #15212: Default values in partition tables don't work as expected and allow NOT NULL violation Alvaro Herrera 21:42
Re: BUG #15212: Default values in partition tables don't work as expected and allow NOT NULL violation Tom Lane 22:33
Re: csv format for psql Michael Paquier 23:44

Nov. 10, 2018

Thread Author Time
Re: Make description of heap records more talkative for flags 📎 Michael Paquier 00:11
Re: Add extension options to control TAP and isolation tests Michael Paquier 00:14
Re: Does slot_deform_tuple need to care about dropped columns? Andres Freund 01:41
Re: pgsql: Make WAL segment size configurable at initdb time. David Steele 02:45
Re: repeated procedure call error Tom Lane 03:05
Re: pgsql: Make WAL segment size configurable at initdb time. Andres Freund 03:30
Re: pgsql: Make WAL segment size configurable at initdb time. David Steele 03:50
Re: Undo logs Amit Kapila 03:57
Re: Skylake-S warning 📎 Andres Freund 05:01
Re: Performance improvements of INSERTs to a partitioned table David Rowley 09:29
Re: Patch for Delta Materialized View Refreshes 📎 John Dent 10:14
Re: Delta Materialized View Refreshes? denty 10:43
Re: speeding up planning with partitions 📎 David Rowley 11:59
Re: zheap: a new storage format for PostgreSQL Daniel Westermann 15:21
Re: unused/redundant foreign key code Peter Eisentraut 15:23
Re: proposal: variadic argument support for least, greatest function Vik Fearing 18:12
Re: proposal: variadic argument support for least, greatest function Andrew Gierth 18:41
Re: proposal: variadic argument support for least, greatest function Pavel Stehule 18:52
Re: [HACKERS] Fix performance degradation of contended LWLock on NUMA Dmitry Dolgov 19:18
Re: [HACKERS] Fix performance degradation of contended LWLock on NUMA Andres Freund 19:37
Proving IS NOT NULL inference for ScalarArrayOpExpr's 📎 James Coleman 21:33
Re: Skylake-S warning Thomas Munro 22:29

Nov. 11, 2018

Thread Author Time
Re: Skylake-S warning Andres Freund 00:19
Re: Connections hang indefinitely while taking a gin index's LWLock buffer_content lock Peter Geoghegan 01:42
Re: Uninterruptible long planning of a query with too many WHERE clauses 📎 Tom Lane 04:38
Re: csv format for psql Daniel Verite 14:51
Re:Re: Connections hang indefinitely while taking a gin index's LWLock buffer_content lock 📎 chenhj 17:10
Re:Re: Connections hang indefinitely while taking a gin index's LWLock buffer_content lock chenhj 17:33
Re: zheap: a new storage format for PostgreSQL Kuntal Ghosh 18:24
Re: COPY FROM WHEN condition Tomas Vondra 20:59
Re: [HACKERS] [PATCH v2] Add and report the new "session_read_only" GUC pseudo-variable. Melanie Plageman 23:30

Nov. 12, 2018

Thread Author Time
Re:Re: Connections hang indefinitely while taking a gin index's LWLock buffer_content lock 📎 [email protected] 01:46
RE: [PROPOSAL]a new data type 'bytea' for ECPG 📎 Matsumura, Ryo 02:14
Re: BUG #15212: Default values in partition tables don't work as expected and allow NOT NULL violation Amit Langote 02:47
Re: Refactoring the checkpointer's fsync request queue 📎 Thomas Munro 02:58
Re: zheap: a new storage format for PostgreSQL Amit Kapila 03:07
Re: BUG #15212: Default values in partition tables don't work as expected and allow NOT NULL violation Tom Lane 03:59
Re: Adding a TAP test checking data consistency on standby with minRecoveryPoint 📎 Michael Paquier 04:08
Re: BUG #15212: Default values in partition tables don't work as expected and allow NOT NULL violation Amit Langote 04:17
Re: csv format for psql David G. Johnston 04:18
RE: speeding up planning with partitions Imai, Yoshikazu 04:35
Re: Tid scan improvements 📎 Edmund Horner 04:35
Re: New function pg_stat_statements_reset_query() to reset statistics of a specific query Haribabu Kommi 05:25
Re: csv format for psql Pavel Stehule 05:36
Re: PostgreSQL vs SQL/XML Standards Markus Winand 05:58
Re: Perl 5.26 and windows build system Noah Misch 06:55
Re: New function pg_stat_statements_reset_query() to reset statistics of a specific query Amit Kapila 07:34
RE: COPY FROM WHEN condition myungkyu.lim 07:44
doc fix for pg_stat_activity.backend_type 📎 John Naylor 07:50
Re: DSM segment handle generation in background workers Noah Misch 08:33
Re: BUG #15449: file_fdw using program cause exit code error when using LIMIT Kyotaro HORIGUCHI 09:23
Re: BUG #15449: file_fdw using program cause exit code error when using LIMIT Kyotaro HORIGUCHI 09:52
Re: PostgreSQL vs SQL/XML Standards Pavel Stehule 09:58
Re: DSM segment handle generation in background workers Thomas Munro 10:11
Re: shared-memory based stats collector 📎 Kyotaro HORIGUCHI 11:10
Re: BUG #15449: file_fdw using program cause exit code error when using LIMIT Etsuro Fujita 11:41
Re: Uninterruptible long planning of a query with too many WHERE clauses Alexander Kuzmenkov 12:05
Re: doc fix for pg_stat_activity.backend_type Amit Kapila 12:20
Re: Index Skip Scan Sergei Kornilov 12:28
Re: Index Skip Scan Dmitry Dolgov 12:55
Re: Continue work on changes to recovery.conf API Peter Eisentraut 13:17
Re: Small run-time pruning doc fix Peter Eisentraut 13:46
Re: BUG #15212: Default values in partition tables don't work as expected and allow NOT NULL violation Jürgen Strobel 13:52
Re: move PartitionBoundInfo creation code 📎 Michael Paquier 13:55
Re: BUG #15212: Default values in partition tables don't work as expected and allow NOT NULL violation Alvaro Herrera 14:00
Re: Changes to error handling for background worker initialization? Jeremy Finzel 14:32
Re: DSM segment handle generation in background workers Tom Lane 14:39
Re: doc fix for pg_stat_activity.backend_type John Naylor 14:42
Re: Removal of unnecessary CommandCounterIncrement() when doing ON COMMIT DELETE ROWS Alvaro Herrera 16:19
Re: Uninterruptible long planning of a query with too many WHERE clauses Tom Lane 16:21
Re: BUG #15212: Default values in partition tables don't work as expected and allow NOT NULL violation Tom Lane 16:33
Re: NULL handling in exconfig deconstruction Tom Lane 16:50
Re: [HACKERS] [PATCH v2] Add and report the new "session_read_only" GUC pseudo-variable. Tom Lane 18:08
Re: Libpq support to connect to standby server as priority Tom Lane 18:23
Race condition in WaitForBackgroundWorkerStartup Jeremy Finzel 18:25
Re: Support custom socket directory in pg_upgrade Tom Lane 19:00
PostgreSQL BuildFarm Client Release 9 Andrew Dunstan 19:08
Re: [HACKERS] [PATCH v2] Add and report the new "session_read_only" GUC pseudo-variable. Elvis Pranskevichus 19:29
Re: [HACKERS] Optional message to user when terminating/cancelling backend Tom Lane 19:35
Re: PostgreSQL BuildFarm Client Release 9 Tom Lane 19:45
Re: PostgreSQL BuildFarm Client Release 9 Andrew Dunstan 20:17
Re: Libpq support to connect to standby server as priority Laurenz Albe 20:26
Re: Copy data to DSA area Robert Haas 20:45
Re: libpq debug log Jim Doty 20:51
Re: Small run-time pruning doc fix David Rowley 21:20
Re: [HACKERS] Decimal64 and Decimal128 Thomas Munro 21:39
Re: [HACKERS] Decimal64 and Decimal128 David Rowley 22:01
Re: libpq debug log Jacob Champion 22:46
Re: [HACKERS] Decimal64 and Decimal128 David Fetter 22:51
Re: [HACKERS] Decimal64 and Decimal128 Andres Freund 22:57
Re: [HACKERS] Decimal64 and Decimal128 David Fetter 23:01
Re: [HACKERS] Decimal64 and Decimal128 Andres Freund 23:04
Re: BUG #15212: Default values in partition tables don't work as expected and allow NOT NULL violation Jürgen Strobel 23:06
Re: [Bug Fix]ECPG: cancellation of significant digits on ECPG 📎 Tom Lane 23:07
Re: Speeding up INSERTs and UPDATEs to partitioned tables 📎 David Rowley 23:17
Re: Support custom socket directory in pg_upgrade Peter Eisentraut 23:46
Re: Support custom socket directory in pg_upgrade Tom Lane 23:50
Re: [HACKERS] Decimal64 and Decimal128 Tom Lane 23:53
Re: BUG #15212: Default values in partition tables don't work as expected and allow NOT NULL violation Tom Lane 23:57

Nov. 13, 2018

Thread Author Time
Re: Removal of unnecessary CommandCounterIncrement() when doing ON COMMIT DELETE ROWS Michael Paquier 00:04
Re: doc fix for pg_stat_activity.backend_type Michael Paquier 00:08
Re: Copy data to DSA area 📎 Thomas Munro 00:43
RE: [Proposal] Add accumulated statistics Yotsunaga, Naoki 00:47
Re: [HACKERS] Decimal64 and Decimal128 Pavel Stehule 01:16
Re: Restore CurrentUserId only if 'prevUser' is valid when abort transaction Tom Lane 01:17
Re: move PartitionBoundInfo creation code Amit Langote 01:34
Re: Making all nbtree entries unique by having heap TIDs participate in comparisons 📎 Peter Geoghegan 01:47
Possible buffer overrun in src/backend/libpq/hba.c gethba_options() Julian Hsiao 02:02
RE: [Proposal] Add accumulated statistics for wait event Yotsunaga, Naoki 02:04
Re: Pull up sublink of type 'NOT NOT (expr)' Tom Lane 02:05
Re: move PartitionBoundInfo creation code 📎 Michael Paquier 02:34
Re: Possible buffer overrun in src/backend/libpq/hba.c gethba_options() Thomas Munro 02:42
Re: move PartitionBoundInfo creation code Amit Langote 03:40
Re: Possible buffer overrun in src/backend/libpq/hba.c gethba_options() Thomas Munro 03:41
Re: move PartitionBoundInfo creation code Amit Langote 04:04
Re: doc fix for pg_stat_activity.backend_type Amit Kapila 04:05
Re: Resetting PGPROC atomics in ProcessInit() Amit Kapila 05:48
Re: New function pg_stat_statements_reset_query() to reset statistics of a specific query 📎 Haribabu Kommi 06:02
Re: Restore CurrentUserId only if 'prevUser' is valid when abort transaction 📎 Michael Paquier 06:13
Re: doc fix for pg_stat_activity.backend_type 📎 John Naylor 06:34
Re: PostgreSQL Limits and lack of documentation about them. John Naylor 06:46
Re: Libpq support to connect to standby server as priority Haribabu Kommi 06:54
Re: libpq debug log Haribabu Kommi 07:16
Re: PostgreSQL Limits and lack of documentation about them. David Rowley 08:21
Re: Undo logs Amit Kapila 08:36
Control your disk usage in PG: Introduction to Disk Quota Extension Hubert Zhang 08:47
Re: doc fix for pg_stat_activity.backend_type Amit Kapila 09:36
Re: BUG #15449: file_fdw using program cause exit code error when using LIMIT 📎 Etsuro Fujita 09:50
RE: Copy data to DSA area Ideriha, Takeshi 09:59
Re: doc fix for pg_stat_activity.backend_type 📎 John Naylor 10:07
proposal: simple query profile and tracing API Pavel Stehule 10:29
[PATCH] Pass COPT and PROFILE to CXXFLAGS as well 📎 Christoph Berg 10:40
Re: doc fix for pg_stat_activity.backend_type Amit Kapila 11:33
RE: Copy data to DSA area Ideriha, Takeshi 11:40
Re: proposal: simple query profile and tracing API legrand legrand 12:12
Re: Race condition in WaitForBackgroundWorkerStartup Amit Kapila 12:17
Re: BUG #15212: Default values in partition tables don't work as expected and allow NOT NULL violation Jürgen Strobel 12:44
Re: using index or check in ALTER TABLE SET NOT NULL Dmitry Dolgov 12:47
Re: Usage of pg_waldump Peter Eisentraut 12:52
Re: proposal: simple query profile and tracing API Pavel Stehule 12:55
Re: doc fix for pg_stat_activity.backend_type John Naylor 12:56
Re: move PartitionBoundInfo creation code Alvaro Herrera 12:58
Re: using index or check in ALTER TABLE SET NOT NULL Alvaro Herrera 12:59
Re: dsa_allocate() faliure Jakub Glapa 13:08
Re: New function pg_stat_statements_reset_query() to reset statistics of a specific query Amit Kapila 13:26
Re: move PartitionBoundInfo creation code Michael Paquier 13:35
proposal - plpgsql unique statement id 📎 Pavel Stehule 13:35
Re: Race condition in WaitForBackgroundWorkerStartup Jeremy Finzel 13:57
Re: move PartitionBoundInfo creation code Alvaro Herrera 13:59
Re: Continue work on changes to recovery.conf API 📎 Sergei Kornilov 14:57
Re: Speeding up INSERTs and UPDATEs to partitioned tables Jesper Pedersen 15:32
spurious(?) warnings in archive recovery Andrew Gierth 15:34
Re: shared-memory based stats collector Tomas Vondra 15:35
Re: Make description of heap records more talkative for flags Bossart, Nathan 16:04
Re: Changing SQL Inlining Behaviour (or...?) Paul Ramsey 16:31
Re: Refactoring the checkpointer's fsync request queue Robert Haas 17:04
Re: BUG #15212: Default values in partition tables don't work as expected and allow NOT NULL violation Tomas Vondra 17:11
Re: BUG #15212: Default values in partition tables don't work as expected and allow NOT NULL violation Tomas Vondra 17:39
Re: wal_dump output on CREATE DATABASE Jean-Christophe Arnu 17:53
Re: Refactoring the checkpointer's fsync request queue Andres Freund 18:01
Re: Refactoring the checkpointer's fsync request queue Andres Freund 18:07
Re: Race condition in WaitForBackgroundWorkerStartup Tomas Vondra 18:18
Re: Sync ECPG scanner with core Tom Lane 18:21
Re: Refactoring the checkpointer's fsync request queue Robert Haas 18:43
Re: Sync ECPG scanner with core Alvaro Herrera 18:56
Re: Sync ECPG scanner with core Tom Lane 19:01
Minor fail in realfailN scanner rules 📎 Tom Lane 19:20
Re: proposal: simple query profile and tracing API Tomas Vondra 19:38
Re: wal_dump output on CREATE DATABASE Peter Eisentraut 19:54
Re: Control your disk usage in PG: Introduction to Disk Quota Extension Tomas Vondra 19:54
Re: wal_dump output on CREATE DATABASE Alvaro Herrera 20:18
Re: wal_dump output on CREATE DATABASE Andres Freund 20:24
Re: wal_dump output on CREATE DATABASE Tomas Vondra 20:31
Re: wal_dump output on CREATE DATABASE Tomas Vondra 20:39
Re: Restore CurrentUserId only if 'prevUser' is valid when abort transaction Tom Lane 21:08
Re: Fixing findDependentObjects()'s dependency on scan order (regressions in DROP diagnostic messages) Peter Geoghegan 21:29
Re: [PATCH] Pass COPT and PROFILE to CXXFLAGS as well Andres Freund 21:57
add the source of param misconfigurations to error messages Jordan Deitch 22:02
Re: [PATCH] Pass COPT and PROFILE to CXXFLAGS as well Tom Lane 22:27
Re: add the source of param misconfigurations to error messages Tom Lane 22:33
Re: [PATCH] Pass COPT and PROFILE to CXXFLAGS as well Andres Freund 22:33
Re: add the source of param misconfigurations to error messages Andres Freund 22:42

Browse Archives

Prev | Next