pgsql-hackers - April 2017

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)

Advanced Search

Browse Archives

Prev | Next

April 1, 2017

Thread	Author	Time
Re: [PATCH] SortSupport for macaddr type	Robert Haas	00:19
Re: partitioned tables and contrib/sepgsql	Robert Haas	00:23
Re: Somebody has not thought through subscription locking considerations 📎	Petr Jelinek	00:25
Re: [sqlsmith] Failed assertion in _hash_kill_items/MarkBufferDirtyHint	Robert Haas	00:30
Re: logical replication launcher crash on buildfarm 📎	Petr Jelinek	00:32
Re: logical replication launcher crash on buildfarm	Robert Haas	00:53
Re: TPC-H Q20 from 1 hour to 19 hours!	Robert Haas	00:57
pgsql: Avoid GatherMerge crash when there are no workers.	Robert Haas	01:22
Re: crashes due to setting max_parallel_workers=0	Robert Haas	01:22
Re: logical replication launcher crash on buildfarm	Petr Jelinek	01:26
Re: logical replication launcher crash on buildfarm	Robert Haas	01:30
Re: [POC] A better way to expand hash indexes.	Robert Haas	01:35
Re: [sqlsmith] Failed assertion in _hash_kill_items/MarkBufferDirtyHint	Ashutosh Sharma	01:36
Re: logical replication launcher crash on buildfarm	Andres Freund	01:44
Re: logical replication launcher crash on buildfarm	Petr Jelinek	01:57
Re: [sqlsmith] Failed assertion in _hash_kill_items/MarkBufferDirtyHint 📎	Ashutosh Sharma	02:02
Re: logical replication launcher crash on buildfarm	Andres Freund	02:14
Re: logical replication launcher crash on buildfarm	Andres Freund	02:19
Re: [COMMITTERS] pgsql: Avoid GatherMerge crash when there are no workers.	Andres Freund	02:26
Re: TPC-H Q20 from 1 hour to 19 hours!	Tomas Vondra	02:29
Re: logical replication launcher crash on buildfarm	Petr Jelinek	02:46
Re: Table collision in join.sql and aggregates.sql	Douglas Doole	03:07
Re: Making clausesel.c Smarter	Claudio Freire	03:42
Re: Multiple false-positive warnings from Valgrind	Noah Misch	05:51
Re: Patch: Write Amplification Reduction Method (WARM)	Amit Kapila	06:55
Re: [POC] A better way to expand hash indexes. 📎	Mithun Cy	07:01
Re: Page Scan Mode in Hash Index 📎	Ashutosh Sharma	07:07
Re: make check-world output	Noah Misch	07:28
Re: [POC] A better way to expand hash indexes. 📎	Mithun Cy	07:29
Re: PATCH: pageinspect / add page_checksum and bt_page_items(bytea)	Ashutosh Sharma	09:40
Re: [sqlsmith] Failed assertion in _hash_kill_items/MarkBufferDirtyHint	Andreas Seltenreich	10:45
Re: [sqlsmith] Failed assertion in _hash_kill_items/MarkBufferDirtyHint	Ashutosh Sharma	10:54
Re: parallel bitmapscan isn't exercised in regression tests 📎	Dilip Kumar	11:53
Re: Page Scan Mode in Hash Index	Amit Kapila	12:23
Re: Partitioning vs ON CONFLICT	Rukh Meski	12:35
Re: [sqlsmith] Failed assertion in _hash_kill_items/MarkBufferDirtyHint	Amit Kapila	12:41
Re: [sqlsmith] Failed assertion in _hash_kill_items/MarkBufferDirtyHint	Ashutosh Sharma	12:47
GSoC 2017 Proposal for "Explicitly support predicate locks in index access methods besides btree"	anant khandelwal	14:03
Re: Multiple false-positive warnings from Valgrind	Michael Paquier	14:19
Re: [COMMITTERS] pgsql: Avoid GatherMerge crash when there are no workers.	Robert Haas	14:28
Re: gitlab post-mortem: pg_basebackup waiting for checkpoint	Magnus Hagander	15:12
Re: gitlab post-mortem: pg_basebackup waiting for checkpoint	Magnus Hagander	15:29
Re: brin autosummarization -- autovacuum "work items"	Alvaro Herrera	17:06
Re: brin autosummarization -- autovacuum "work items"	Alvaro Herrera	17:09
Re: GSoC 2017 Proposal for "Explicitly support predicate locks in index access methods besides btree"	anant khandelwal	17:13
Re: BRIN de-summarize ranges 📎	Alvaro Herrera	17:42
Re: New CORRESPONDING clause design	Tom Lane	17:54
Re: brin autosummarization -- autovacuum "work items" 📎	Jeff Janes	18:57
Re: BRIN de-summarize ranges	Alvaro Herrera	19:16
Re: [PATCH] Generic type subscripting	Arthur Zakirov	19:26
Re: [PATCH] few fts functions for jsonb	Andrew Dunstan	20:20
Re: [GSoC] Push-based query executor discussion	Arseny Sher	21:13
Re: GSoC 2017 Proposal for "Explicitly support predicate locks in index access methods besides btree"	Kevin Grittner	22:00
Re: Page Scan Mode in Hash Index 📎	Ashutosh Sharma	22:44

April 2, 2017

Thread	Author	Time
New expression evaluator and indirect jumps	Jeff Davis	00:36
Re: New expression evaluator and indirect jumps	Andres Freund	00:54
Re: Variable substitution in psql backtick expansion	Fabien COELHO	06:53
Re: Variable substitution in psql backtick expansion	Pavel Stehule	06:58
Re: Variable substitution in psql backtick expansion 📎	Fabien COELHO	07:45
Re: Variable substitution in psql backtick expansion	Fabien COELHO	07:52
Re: Performance improvement for joins where outer side is unique	David Rowley	09:21
Moving GiST index constant to parameter	Thomas Mercieca	09:27
Re: Variable substitution in psql backtick expansion	Pavel Stehule	10:08
Re: Variable substitution in psql backtick expansion	Pavel Stehule	10:13
Re: Variable substitution in psql backtick expansion	Fabien COELHO	11:13
Re: Performance improvement for joins where outer side is unique	Robert Haas	11:19
Re: Performance improvement for joins where outer side is unique 📎	David Rowley	11:23
Re: BRIN cost estimate 📎	David Rowley	12:41
Re: Variable substitution in psql backtick expansion 📎	Fabien COELHO	12:53
Re: Variable substitution in psql backtick expansion 📎	Fabien COELHO	13:14
Suggested fix for \p and \r in psql 📎	Daniel Verite	13:22
FDW and parallel execution	Konstantin Knizhnik	13:30
Re: Variable substitution in psql backtick expansion	Daniel Verite	13:31
Re: Variable substitution in psql backtick expansion	Fabien COELHO	14:38
[GSoC] Question about "Explicitly support predicate locks in index access methods besides btree"	Dong Yuan	14:54
Re: Suggested fix for \p and \r in psql	Fabien COELHO	14:58
Re: Performance improvement for joins where outer side is unique	Tom Lane	14:59
Re: BRIN cost estimate	Emre Hasegeli	15:05
Re: Moving GiST index constant to parameter	Tom Lane	15:10
Re: Variable substitution in psql backtick expansion	Pavel Stehule	15:16
Re: Suggested fix for \p and \r in psql	Tom Lane	15:18
Re: Suggested fix for \p and \r in psql	Tom Lane	15:41
Re: Suggested fix for \p and \r in psql	Fabien COELHO	15:44
Re: Undefined psql variables	Corey Huinker	15:58
Re: Variable substitution in psql backtick expansion	Corey Huinker	15:59
Re: asynchronous execution	Corey Huinker	16:21
Re: Undefined psql variables	Tom Lane	16:29
Re: Variable substitution in psql backtick expansion	Fabien COELHO	16:29
Re: Suggested fix for \p and \r in psql	Daniel Verite	16:31
Re: Suggested fix for \p and \r in psql	Tom Lane	16:54
Re: Undefined psql variables	Fabien COELHO	16:56
Re: Undefined psql variables	Pavel Stehule	17:00
Re: Undefined psql variables	Pavel Stehule	17:02
Re: Variable substitution in psql backtick expansion	Corey Huinker	17:36
Re: Suggested fix for \p and \r in psql	Daniel Verite	17:41
Re: walsender.c comments	Magnus Hagander	17:56
Re: Variable substitution in psql backtick expansion	Tom Lane	18:54
Re: Undefined psql variables	Fabien COELHO	19:43
Re: Variable substitution in psql backtick expansion	Fabien COELHO	19:50
Re: Undefined psql variables	Tom Lane	19:56
Re: Variable substitution in psql backtick expansion 📎	Fabien COELHO	19:57
Re: Undefined psql variables	Tom Lane	20:00
Re: Suggested fix for \p and \r in psql	Tom Lane	20:02
Re: Undefined psql variables	Fabien COELHO	20:21
Re: Other formats in pset like markdown, rst, mediawiki 📎	Jan Michálek	20:28
Re: Undefined psql variables	Fabien COELHO	20:33
Re: Undefined psql variables	Fabien COELHO	20:57
Re: [BUGS] Bug in Physical Replication Slots (at least 9.5)?	Venkata B Nagothi	22:19
Re: PATCH: two slab-like memory allocators	Petr Jelinek	22:42
Re: [BUGS] Bug in Physical Replication Slots (at least 9.5)?	Michael Paquier	23:38
Re: WIP: Covering + unique indexes.	Peter Geoghegan	23:40
Re: WIP: Covering + unique indexes.	Peter Geoghegan	23:44
Re: Variable substitution in psql backtick expansion	Tom Lane	23:55

April 3, 2017

Thread	Author	Time
Re: Fix obsolete comment in GetSnapshotData	Craig Ringer	01:29
Re: delta relations in AFTER triggers	Craig Ringer	01:34
Re: Partitioned tables and relfilenode	Amit Langote	02:39
Re: delta relations in AFTER triggers	Corey Huinker	03:32
Re: delta relations in AFTER triggers 📎	Thomas Munro	03:50
Re: delta relations in AFTER triggers	Thomas Munro	04:09
Re: PATCH: Batch/pipelining support for libpq 📎	Vaishnavi Prabakaran	04:10
Re: Supporting huge pages on Windows 📎	Tsunakawa, Takayuki	04:12
Re: [bug fix] Savepoint-related statements terminates connection	Tsunakawa, Takayuki	04:23
Re: Supporting huge pages on Windows	Michael Paquier	04:49
Re: Documentation improvements for partitioning 📎	Amit Langote	04:52
Re: parallel explain analyze support not exercised 📎	Rafia Sabih	04:56
Re: Supporting huge pages on Windows 📎	Tsunakawa, Takayuki	04:56
Re: [COMMITTERS] pgsql: Avoid GatherMerge crash when there are no workers.	Rushabh Lathia	05:26
Re: Logical decoding on standby 📎	Craig Ringer	05:46
Re: Allow interrupts on waiting standby	Michael Paquier	05:53
Re: REINDEX CONCURRENTLY 2.0	Michael Paquier	05:57
Re: make check-world output	Michael Paquier	06:03
Comment typo in logical/worker.c 📎	Masahiko Sawada	06:11
Re: postgres_fdw bug in 9.6	Etsuro Fujita	06:12
Re: UPDATE of partition key 📎	Amit Khandekar	06:13
Unable to build doc on latest head	Ashutosh Bapat	06:44
dropping a partition may cause deadlock 📎	Amit Langote	06:48
Re: Foreign tables don't enforce the partition constraint 📎	Ashutosh Bapat	06:49
Re: Statement timeout behavior in extended queries	Tsunakawa, Takayuki	07:00
Re: gitlab post-mortem: pg_basebackup waiting for checkpoint	Michael Banck	07:17
Re: [COMMITTERS] pgsql: Avoid GatherMerge crash when there are no workers. 📎	Rushabh Lathia	07:26
Re: Logical decoding on standby 📎	Craig Ringer	07:27
Re: Logical decoding on standby 📎	Craig Ringer	07:41
Re: Variable substitution in psql backtick expansion	Fabien COELHO	07:43
Re: Foreign tables don't enforce the partition constraint 📎	Amit Langote	07:44
Re: Statement timeout behavior in extended queries 📎	Tatsuo Ishii	08:24
Re: Making clausesel.c Smarter 📎	David Rowley	08:59
Re: pg_partman 3.0.0 - real-world usage of native partitioning and a case for native default	Ashutosh Bapat	09:13
Re: [BUGS] BUG #14600: Passwords in user mappings leaked by psql \deu+ command	Ashutosh Bapat	09:47
Refactoring identifier checks to consistently use strcmp 📎	Daniel Gustafsson	09:58
Re: strange parallel query behavior after OOM crashes 📎	Kuntal Ghosh	10:08
Re: Partitioning vs ON CONFLICT 📎	Amit Langote	10:28
Re: UPDATE of partition key	Amit Langote	11:43
Re: Variable substitution in psql backtick expansion	Daniel Verite	12:12
Re: REINDEX CONCURRENTLY 2.0	Andreas Karlsson	12:25
Rewriting the test of pg_upgrade as a TAP test 📎	Michael Paquier	13:07
Re: Rewriting the test of pg_upgrade as a TAP test	Craig Ringer	13:12
wait event documentation	Robert Haas	13:32
Re: delta relations in AFTER triggers	Tom Lane	13:59
Re: Statement timeout behavior in extended queries	Tom Lane	14:05
Re: Variable substitution in psql backtick expansion	Tom Lane	14:16
Re: Statement timeout behavior in extended queries	Tatsuo Ishii	14:31
Re: [HACKERS] Questionable tag usage	Peter Eisentraut	14:52
Re: bug/oversight in TestLib.pm and PostgresNode.pm	Peter Eisentraut	14:56
Re: Unable to build doc on latest head	Tom Lane	15:06
Re: Rewriting the test of pg_upgrade as a TAP test	Stephen Frost	15:12
Re: Fix slot name change handling for subscriptions	Peter Eisentraut	15:18
Re: Rewriting the test of pg_upgrade as a TAP test	Peter Eisentraut	15:22
Re: Rewriting the test of pg_upgrade as a TAP test	Andres Freund	15:32
Re: Rewriting the test of pg_upgrade as a TAP test	Stephen Frost	15:34
Re: partitioned tables and contrib/sepgsql	Mike Palmiotto	15:38
Re: delta relations in AFTER triggers	Kevin Grittner	15:41
Re: Unable to build doc on latest head	Peter Eisentraut	15:53
GSoC 2017 Proposal 📎	Mark Rofail	16:00
Re: partitioned tables and contrib/sepgsql	Joe Conway	16:02
Re: bumping HASH_VERSION to 3	Joe Conway	16:29
Can't compile with profiling after BRIN autosummarization	Jeff Janes	16:31
Re: Variable substitution in psql backtick expansion	Daniel Verite	16:33
Re: GSoC 2017 Proposal for "Explicitly support predicate locks in index access methods besides btree"	Kevin Grittner	16:33
Re: Can't compile with profiling after BRIN autosummarization	Jeff Janes	16:59
Re: pg_partman 3.0.0 - real-world usage of native partitioning and a case for native default	Keith Fiske	17:15
Re: Rewriting the test of pg_upgrade as a TAP test	Andres Freund	17:43
Fwd: GSoC 2017 Proposal for "Explicitly support predicate locks in index access methods besides btree"	anant khandelwal	17:48
Re: parallel bitmapscan isn't exercised in regression tests	Andres Freund	17:52
Re: parallel explain analyze support not exercised	Andres Freund	17:53
Re: [BUGS] BUG #14600: Passwords in user mappings leaked by psql \deu+ command	Jeff Janes	17:54
Re: Rewriting the test of pg_upgrade as a TAP test	Stephen Frost	17:55
Re: identity columns	Andres Freund	18:19
Re: postgres_fdw: evaluate placeholdervars on remote server	Andres Freund	18:21
Re: [PATCH] few fts functions for jsonb	Andres Freund	18:22
Re: Statement timeout behavior in extended queries	Andres Freund	18:25
Re: [PATCH v.7] Move all am-related reloption code into src/backend/access/[am-name] and get rid of relopt_kind for custom AM	Andres Freund	18:31
Re: [PATCH] Incremental sort	Andres Freund	18:34
Re: SERIALIZABLE with parallel query	Andres Freund	18:41
Re: [PATCH] few fts functions for jsonb	Sven R. Kunze	18:44
Re: Improve OR conditions on joined columns (common star schema problem)	Andres Freund	18:44
Re: Improve OR conditions on joined columns (common star schema problem)	Tom Lane	18:49
Re: LWLock optimization for multicore Power machines	Andres Freund	18:56
Re: Should we cacheline align PGXACT?	Andres Freund	18:58
Re: [PATCH] Incremental sort 📎	Alexander Korotkov	19:03
Re: [PATCH] Incremental sort	Andres Freund	19:05

Browse Archives

Prev | Next