pgsql-hackers since 2018-03-06 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)

Advanced Search

Browse Archives

Prev | Next

March 6, 2018

Thread	Author	Time
Re: 2018-03 CFM	David Steele	00:00
Re: [COMMITTERS] pgsql: Fix inadequate locking during get_rel_oids().	Andres Freund	00:11
Re: Faster inserts with mostly-monotonically increasing values	Peter Geoghegan	00:12
Re: [COMMITTERS] pgsql: Fix inadequate locking during get_rel_oids().	Andres Freund	00:34
Re: Faster inserts with mostly-monotonically increasing values	Claudio Freire	00:37
Re: Cache lookup errors with functions manipulation object addresses 📎	Michael Paquier	00:47
Re: Faster inserts with mostly-monotonically increasing values	Claudio Freire	00:48
Re: [COMMITTERS] pgsql: Fix inadequate locking during get_rel_oids().	Tom Lane	00:49
Re: Faster inserts with mostly-monotonically increasing values	Peter Geoghegan	00:52
Re: [COMMITTERS] pgsql: Fix inadequate locking during get_rel_oids().	Tom Lane	00:53
Change RangeVarGetRelidExtended() to take flags argument?	Andres Freund	00:53
Re: Change RangeVarGetRelidExtended() to take flags argument?	Tom Lane	00:57
Re: [COMMITTERS] pgsql: Fix inadequate locking during get_rel_oids().	Michael Paquier	00:57
Re: [COMMITTERS] pgsql: Fix inadequate locking during get_rel_oids().	Andres Freund	00:58
Re: PATCH: Configurable file mode mask	Michael Paquier	01:03
Re: Change RangeVarGetRelidExtended() to take flags argument?	Andres Freund	01:06
Re: Change RangeVarGetRelidExtended() to take flags argument?	Michael Paquier	01:17
Re: Change RangeVarGetRelidExtended() to take flags argument?	Andres Freund	01:21
Re: pg_get_functiondef forgets about most GUC_LIST_INPUT GUCs	Michael Paquier	01:32
Re: 2018-03 CFM	Thomas Munro	01:33
Re: Change RangeVarGetRelidExtended() to take flags argument?	Michael Paquier	01:35
Re: User defined data types in Logical Replication	Masahiko Sawada	01:39
Re: BUG #14999: pg_rewind corrupts control file global/pg_control	Masahiko Sawada	01:39
Re: PATCH: Configurable file mode mask	David Steele	01:43
Re: Faster inserts with mostly-monotonically increasing values	Claudio Freire	01:48
Re: 2018-03 CFM	David Steele	01:49
Re: 2018-03 CFM	Andres Freund	01:53
Re: All Taxi Services need Index Clustered Heap Append	Craig Ringer	01:57
Re: Re: BUGFIX: standby disconnect can corrupt serialized reorder buffers	Craig Ringer	01:58
Re: BUG #14941: Vacuum crashes	Andres Freund	01:58
Re: Faster inserts with mostly-monotonically increasing values	Peter Geoghegan	01:59
Re: pgsql: Clone extended stats in CREATE TABLE (LIKE INCLUDING ALL)	Thomas Munro	02:08
Re: Kerberos test suite	Michael Paquier	02:08
Re: pgsql: Clone extended stats in CREATE TABLE (LIKE INCLUDING ALL)	Alvaro Herrera	02:53
Re: [PATCH] GET DIAGNOSTICS FUNCTION_NAME	Yugo Nagata	03:09
Re: Faster inserts with mostly-monotonically increasing values	Claudio Freire	03:10
Re: PATCH: Configurable file mode mask	Michael Paquier	03:46
Re: [HACKERS] MERGE SQL Statement for PG11	Peter Geoghegan	04:25
Re: Faster inserts with mostly-monotonically increasing values	Pavan Deolasee	04:40
Re: constraint exclusion and nulls in IN (..) clause 📎	Amit Langote	04:43
Re: Faster inserts with mostly-monotonically increasing values	Peter Geoghegan	04:45
Re: [HACKERS] Lazy hash table for XidInMVCCSnapshot (helps Zipfian a bit)	Yura Sokolov	05:23
Re: [HACKERS] GSoC 2017: weekly progress reports (week 4) and patch for hash index	Amit Kapila	05:56
Re: pg_get_functiondef forgets about most GUC_LIST_INPUT GUCs	Pavel Stehule	06:14
Re: inserts into partitioned table may cause crash 📎	Amit Langote	06:28
Re: STATISTICS retained in CREATE TABLE ... LIKE (INCLUDING ALL)?	David Rowley	07:21
Re: PATCH: psql tab completion for SELECT 📎	Edmund Horner	07:31
Re: public schema default ACL	Noah Misch	07:44
Re: using index or check in ALTER TABLE SET NOT NULL	Ildar Musin	07:57
Re: Re: BUGFIX: standby disconnect can corrupt serialized reorder buffers 📎	Craig Ringer	08:07
Re: INOUT parameters in procedures	Pavel Stehule	08:35
Re: Re: BUGFIX: standby disconnect can corrupt serialized reorder buffers	Craig Ringer	08:37
Re: MCV lists for highly skewed distributions	John Naylor	08:51
Re: WIP: Covering + unique indexes.	Thomas Munro	08:52
Re: INOUT parameters in procedures	Pavel Stehule	09:22
Re: [HACKERS] PoC: full merge join on comparison clause	Alexander Kuzmenkov	09:27
Re: JIT compiling with LLVM v11	Andres Freund	09:39
Re: ALTER TABLE ADD COLUMN fast default 📎	David Rowley	09:40
Re: WIP Patch: Pgbench Serialization and deadlock errors	Marina Polyakova	09:45
Re: ALTER TABLE ADD COLUMN fast default 📎	David Rowley	09:45
Re: constraint exclusion and nulls in IN (..) clause	Emre Hasegeli	09:46
Re: constraint exclusion and nulls in IN (..) clause	Amit Langote	10:10
Re: constraint exclusion and nulls in IN (..) clause	Emre Hasegeli	10:16
Re: constraint exclusion and nulls in IN (..) clause	Amit Langote	10:20
Re: [HACKERS] Partition-wise aggregation/grouping	Jeevan Chalke	10:31
Re: IndexJoin memory problem using spgist and boxes	Anton Dignös	10:41
Re: [HACKERS] Another oddity in handling of WCO constraints in postgres_fdw 📎	Etsuro Fujita	11:09
Re: [HACKERS] make async slave to wait for lsn to be replayed	Ivan Kartyshov	11:24
Re: [HACKERS] make async slave to wait for lsn to be replayed	Dmitry Ivanov	11:24
Re: [HACKERS] Partition-wise aggregation/grouping 📎	Ashutosh Bapat	11:29
Re: Faster inserts with mostly-monotonically increasing values	Claudio Freire	11:43
Re: [HACKERS] make async slave to wait for lsn to be replayed	Simon Riggs	11:50
Re: Fwd: [BUGS] pg_trgm word_similarity inconsistencies or bug	Teodor Sigaev	12:04
Re: Faster inserts with mostly-monotonically increasing values	Simon Riggs	12:06
Re: inserts into partitioned table may cause crash	Etsuro Fujita	12:26
Re: committing inside cursor loop	Ildus Kurbangaliev	12:48
Re: Faster inserts with mostly-monotonically increasing values	Claudio Freire	12:52
Re: General purpose hashing func in pgbench	Teodor Sigaev	12:53
Re: All Taxi Services need Index Clustered Heap Append	Darafei Komяpa Praliaskouski	13:07
Re: BUGFIX: standby disconnect can corrupt serialized reorder buffers	Petr Jelinek	13:12
Re: using index or check in ALTER TABLE SET NOT NULL 📎	Sergei Kornilov	13:12
Re: pgbench - allow to specify scale as a size	Peter Eisentraut	13:18
cannot drop replication slot if server is running in single-user mode	tushar	13:29
Re: All Taxi Services need Index Clustered Heap Append	Darafei Komяpa Praliaskouski	13:39
Re: General purpose hashing func in pgbench	Ildar Musin	13:47
Re: [HACKERS] Another oddity in handling of WCO constraints in postgres_fdw	Arthur Zakirov	14:00
Re: Re: [PATCH] Atomic pgrename on Windows	David Steele	14:04
Re: Contention preventing locking	Amit Kapila	14:05
Re: Re: [PATCH] Atomic pgrename on Windows	Alexander Korotkov	14:06
Re: JIT compiling with LLVM v11	Peter Eisentraut	14:10
Re: [PATCH] Atomic pgrename on Windows	David Steele	14:11
Re: [PATCH] Atomic pgrename on Windows	Alexander Korotkov	14:14
Re: Re: [HACKERS] Subscription code improvements	David Steele	14:17
Re: Flexible configuration for full-text search 📎	Aleksandr Parfenov	14:18
Re: [HACKERS] Partition-wise aggregation/grouping	Jeevan Chalke	14:22
Re: Re: [HACKERS] Support to COMMENT ON DATABASE CURRENT_DATABASE	David Steele	14:25
Re: Changing the autovacuum launcher scheduling; oldest table first algorithm	Alvaro Herrera	14:27
Re: [HACKERS] Restrict concurrent update/delete with UPDATE of partition key	Amit Kapila	14:27
Re: Re: [HACKERS] [PATCH] kNN for SP-GiST	David Steele	14:30
Re: using index or check in ALTER TABLE SET NOT NULL	Ildar Musin	14:37
Re: Re: Boolean partitions syntax	David Steele	14:44
Re: Re: [PATCH] Add support for ON UPDATE/DELETE actions on ALTER CONSTRAINT	David Steele	14:50
Re: Re: [HACKERS] Can ICU be used for a database's default sort order?	David Steele	14:54
Re: BUG #14941: Vacuum crashes	Bossart, Nathan	14:56
Re: Add default role 'pg_access_server_files' 📎	Stephen Frost	15:00
Re: WIP Patch: Pgbench Serialization and deadlock errors	David Steele	15:02
Re: Re: Re: [HACKERS] Cached plans and statement generalization	David Steele	15:07
Re: Re: [HACKERS] Support to COMMENT ON DATABASE CURRENT_DATABASE	Alvaro Herrera	15:25
Re: JIT compiling with LLVM v11	Peter Eisentraut	15:29
Re: [HACKERS] pg_upgrade to clusters with a different WAL segment size	Bossart, Nathan	15:35
Re: [HACKERS] Support to COMMENT ON DATABASE CURRENT_DATABASE	David Steele	15:46
Re: using index or check in ALTER TABLE SET NOT NULL 📎	Sergei Kornilov	15:52
Re: Speed up the removal of WAL files	Fujii Masao	15:55
Re: Kerberos test suite	Peter Eisentraut	15:58
Re: Kerberos test suite	Peter Eisentraut	16:00
Re: [patch] BUG #15005: ANALYZE can make pg_class.reltuples inaccurate.	Tom Lane	16:16
Re: [PROPOSAL] Shared Ispell dictionaries 📎	Arthur Zakirov	16:17
Re: STATISTICS retained in CREATE TABLE ... LIKE (INCLUDING ALL)?	Alvaro Herrera	16:22
Re: pgsql: Clone extended stats in CREATE TABLE (LIKE INCLUDING ALL)	Alvaro Herrera	16:23
Re: Kerberos test suite	Robbie Harwood	16:25
Re: [HACKERS] Support to COMMENT ON DATABASE CURRENT_DATABASE	Tom Lane	16:25
Re: Prefix operator for text and spgist support	Arthur Zakirov	16:27
Re: Kerberos test suite	Alvaro Herrera	16:29
Re: 2018-03 Commitfest Summary (Andres #1)	Fabien COELHO	16:41
Re: MCV lists for highly skewed distributions	Dean Rasheed	16:48
Re: Rewrite of pg_dump TAP tests 📎	Stephen Frost	16:53
Re: Fwd: [BUGS] pg_trgm word_similarity inconsistencies or bug	David Steele	16:59
Re: Rewrite of pg_dump TAP tests	Alvaro Herrera	17:07
Re: [HACKERS] [PATCH] Generic type subscripting 📎	Dmitry Dolgov	17:21
Re: using index or check in ALTER TABLE SET NOT NULL	Alvaro Herrera	17:25
Re: [patch] BUG #15005: ANALYZE can make pg_class.reltuples inaccurate.	Tom Lane	17:36
Re: User defined data types in Logical Replication	Alvaro Herrera	17:52
Re: using index or check in ALTER TABLE SET NOT NULL	Sergei Kornilov	18:32
Re: PATCH: Configurable file mode mask 📎	David Steele	18:32
Re: All Taxi Services need Index Clustered Heap Append	Evgeniy Shishkin	18:34
Re: using index or check in ALTER TABLE SET NOT NULL	Tom Lane	18:51
Re: using index or check in ALTER TABLE SET NOT NULL	Sergei Kornilov	19:27
Re: constraint exclusion and nulls in IN (..) clause	Tom Lane	19:37
Re: [COMMITTERS] pgsql: Add much-more-extensive TAP tests for pgbench.	Peter Eisentraut	19:44
Re: check error messages in SSL tests 📎	Peter Eisentraut	19:54
Re: [HACKERS] [Patch] Log SSL certificate verification errors	Peter Eisentraut	19:56
Re: [HACKERS] Support for Secure Transport SSL library on macOS as OpenSSL alternative	Peter Eisentraut	20:11
Re: Rewriting the test of pg_upgrade as a TAP test - take two	Peter Eisentraut	20:13
Re: [HACKERS] Partition-wise aggregation/grouping 📎	Robert Haas	20:15
Re: JIT compiling with LLVM v11	Andres Freund	20:16
Re: public schema default ACL	Robert Haas	20:20
Re: JIT compiling with LLVM v11	Andres Freund	20:29
Re: BUG #14999: pg_rewind corrupts control file global/pg_control	Dmitry Dolgov	20:37
Re: [WIP PATCH] Index scan offset optimisation using visibility map 📎	Michail Nikolaev	21:03
Re: [HACKERS] Support for Secure Transport SSL library on macOS as OpenSSL alternative	Tom Lane	21:08
Re: Rewriting the test of pg_upgrade as a TAP test - take two	Tom Lane	21:12
Re: [HACKERS] path toward faster partition pruning	Robert Haas	21:15
Re: JIT compiling with LLVM v11	Tom Lane	21:20
Re: public schema default ACL	Tom Lane	21:31
Re: Re: BUGFIX: standby disconnect can corrupt serialized reorder buffers	Alvaro Herrera	21:42
Re: [HACKERS] Support for Secure Transport SSL library on macOS as OpenSSL alternative	Daniel Gustafsson	22:18
Re: [WIP PATCH] Index scan offset optimisation using visibility map	Tels	22:25
Re: Server won't start with fallback setting by initdb.	Peter Eisentraut	22:42
Re: Server won't start with fallback setting by initdb. 📎	Tom Lane	22:53
Re: Server won't start with fallback setting by initdb.	Tom Lane	22:58
Re: Temporary tables prevent autovacuum, leading to XID wraparound	Tom Lane	23:39

March 7, 2018

Thread	Author	Time
Re: line_perp() (?-|) is broken.	Kyotaro HORIGUCHI	00:20
Re: TAP test module - PostgresClient	Kyotaro HORIGUCHI	00:22
Re: Index-only scan returns incorrect results when using a composite GIST index with a gist_trgm_ops column.	Kyotaro HORIGUCHI	00:26
Re: Hash Joins vs. Bloom Filters / take 2	Patrick Krecker	00:27
Re: [HACKERS] [Patch] Log SSL certificate verification errors	Michael Paquier	01:31
Re: [HACKERS] path toward faster partition pruning	David Rowley	01:34
Re: check error messages in SSL tests	Michael Paquier	01:38
Re: BUG #14999: pg_rewind corrupts control file global/pg_control	Michael Paquier	01:46
Re: Speed up the removal of WAL files	Michael Paquier	02:13
Re: [HACKERS] make async slave to wait for lsn to be replayed	Michael Paquier	02:25
Re: public schema default ACL	Stephen Frost	02:28
Re: [doc fix] Correct calculation of vm.nr_hugepages	Peter Eisentraut	02:48
Re: [doc fix] Correct calculation of vm.nr_hugepages	Peter Eisentraut	02:49
Re: JIT compiling with LLVM v11	Thomas Munro	02:49
Re: Suspicious call of initial_cost_hashjoin()	Peter Eisentraut	02:56
Re: PATCH: Configurable file mode mask	Michael Paquier	03:04
Re: [HACKERS] Another oddity in handling of WCO constraints in postgres_fdw	Stephen Frost	03:25
Re: Server won't start with fallback setting by initdb.	Stephen Frost	03:51
Comment on top of RangeVarGetRelidExtended in namespace.c mentioning RangeVarGetRelid 📎	Michael Paquier	03:52
Re: GSOC 2018 ideas	Charles Cui	03:55
Re: [HACKERS] path toward faster partition pruning	Robert Haas	04:10
Re: [HACKERS] Partition-wise aggregation/grouping	Ashutosh Bapat	04:34
Re: Comment on top of RangeVarGetRelidExtended in namespace.c mentioning RangeVarGetRelid	Stephen Frost	04:37
Re: BUG #14941: Vacuum crashes	Michael Paquier	05:03
Re: Comment on top of RangeVarGetRelidExtended in namespace.c mentioning RangeVarGetRelid	Michael Paquier	05:05
Missing break statement after transformCallStmt in transformStmt 📎	Ashutosh Bapat	06:00
Re: [WIP PATCH] Index scan offset optimisation using visibility map	Andrey Borodin	06:11
RE: Speed up the removal of WAL files	Tsunakawa, Takayuki	06:15
Re: Add default role 'pg_access_server_files'	Michael Paquier	06:31
Re: Missing break statement after transformCallStmt in transformStmt	Michael Paquier	06:39
Re: Rewrite of pg_dump TAP tests	Michael Paquier	06:49
GiST VACUUM 📎	Andrey Borodin	06:50
Re: 2018-03 CFM	Andrey Borodin	06:56
Re: 2018-03 CFM	Michael Paquier	07:00
Re: Protect syscache from bloating with negative cache entries 📎	Kyotaro HORIGUCHI	07:19
Re: public schema default ACL	Noah Misch	07:23
Some message fixes 📎	Kyotaro HORIGUCHI	07:34
Re: 2018-03 CFM	Andrey Borodin	07:47
parse callback allows inserting cursorpos when hide_stmt. 📎	Kyotaro HORIGUCHI	08:10

Browse Archives

Prev | Next