pgsql-hackers since 2018-11-09 00:00

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: Connection slots reserved for replication Masahiko Sawada 00:58
ALTER DEFAULT PRIVILEGES is buggy, and so is its testing Tom Lane 01:01
Re: ON COMMIT actions and inheritance Michael Paquier 01:10
Re: fix psql \conninfo & \connect when using hostaddr Michael Paquier 01:14
Strange corruption in psql output on mereswine Thomas Munro 01:16
RE: Copy data to DSA area Ideriha, Takeshi 01:19
Re: Cache relation sizes? Edmund Horner 01:23
Re: Adding a TAP test checking data consistency on standby with minRecoveryPoint Michael Paquier 01:27
Re: Tid scan improvements Edmund Horner 02:01
Re: Copy data to DSA area Thomas Munro 02:04
Re: Performance improvements of INSERTs to a partitioned table David Rowley 02:19
Removal of unnecessary CommandCounterIncrement() when doing ON COMMIT DELETE ROWS 📎 Michael Paquier 02:47
Re: New function pg_stat_statements_reset_query() to reset statistics of a specific query Amit Kapila 03:11
Re: Strange corruption in psql output on mereswine Tom Lane 03:36
Re: Cache relation sizes? David Rowley 03:42
Re: PostgreSQL vs SQL/XML Standards 📎 Pavel Stehule 04:07
Re: notice processors for isolationtester Haribabu Kommi 04:17
Re: Strange corruption in psql output on mereswine Clarence Ho 04:51
Re: BUG #15212: Default values in partition tables don't work as expected and allow NOT NULL violation Amit Langote 04:56
Re: Resetting PGPROC atomics in ProcessInit() 📎 Amit Kapila 04:58
Re: BUG #15212: Default values in partition tables don't work as expected and allow NOT NULL violation Amit Langote 05:04
Re: BUG #15212: Default values in partition tables don't work as expected and allow NOT NULL violation Amit Langote 05:11
Re: using expression syntax for partition bounds 📎 Amit Langote 05:38
Re: BUG #15449: file_fdw using program cause exit code error when using LIMIT Kyotaro HORIGUCHI 05:39
Re: Performance improvements of INSERTs to a partitioned table Amit Langote 05:45
Re: csv format for psql 📎 Michael Paquier 05:56
Re: Speeding up INSERTs and UPDATEs to partitioned tables Amit Langote 06:18
Re: csv format for psql Pavel Stehule 06:41
Re: BUG #15449: file_fdw using program cause exit code error when using LIMIT Thomas Munro 07:32
Re: speeding up planning with partitions Amit Langote 08:04
Re: speeding up planning with partitions Amit Langote 08:26
Re: shared-memory based stats collector 📎 Kyotaro HORIGUCHI 08:33
Re: speeding up planning with partitions 📎 Amit Langote 08:55
FIXED: backend crash on DELETE, reproducible locally Karsten Hilbert 09:25
Re: BUG #15449: file_fdw using program cause exit code error when using LIMIT Etsuro Fujita 09:27
RE: Performance improvements of INSERTs to a partitioned table Kato, Sho 09:36
Re: csv format for psql Daniel Verite 10:40
Alternative to \copy in psql modelled after \g 📎 Daniel Verite 11:18
Re: Libpq support to connect to standby server as priority 📎 Haribabu Kommi 11:48
Re: Libpq support to connect to standby server as priority Laurenz Albe 11:53
Re: csv format for psql Michael Paquier 12:11
Re: Special role for subscriptions Evgeniy Efimkin 12:24
Re: Adding a TAP test checking data consistency on standby with minRecoveryPoint Andrew Gierth 12:42
Re: [HACKERS] [PATCH] Generic type subscripting 📎 Dmitry Dolgov 12:55
Re: shared-memory based stats collector Tomas Vondra 13:16
Re: ATTACH/DETACH PARTITION CONCURRENTLY Robert Haas 14:50
Uninterruptible long planning of a query with too many WHERE clauses 📎 Alexander Kuzmenkov 15:00
Re: Add extension options to control TAP and isolation tests Adam Berlin 15:14
Re: Make description of heap records more talkative for flags Dmitry Dolgov 15:23
Re: jsonpath 📎 Nikita Glukhov 15:50
Re: COPY FROM WHEN condition Adam Berlin 15:51
Re: BUG #15212: Default values in partition tables don't work as expected and allow NOT NULL violation Alvaro Herrera 15:59
Re: [HACKERS] Surjective functional indexes Konstantin Knizhnik 16:08
Re: Alternative to \copy in psql modelled after \g David G. Johnston 16:16
Re: notice processors for isolationtester Alvaro Herrera 16:16
Re: csv format for psql Daniel Verite 16:28
Re: Alternative to \copy in psql modelled after \g Daniel Verite 16:35
BUG #15212: Default values in partition tables don't work as expected and allow NOT NULL violation Jürgen Strobel 16:46
Re: Alternative to \copy in psql modelled after \g David G. Johnston 16:49
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

Browse Archives

Prev | Next