pgsql-hackers since 2018-10-02 00:57

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

Oct. 2, 2018

Thread Author Time
Re: snprintf.c hammering memset() Tom Lane 00:57
Re: [HACKERS] Re: Improve OR conditions on joined columns (common star schema problem) Michael Paquier 01:11
Re: GiST VACUUM Michael Paquier 01:14
Re: patch to allow disable of WAL recycling Michael Paquier 01:16
Re: speeding up planning with partitions Michael Paquier 01:20
Re: speeding up planning with partitions Amit Langote 01:24
Re: SerializeParamList vs machines with strict alignment Amit Kapila 01:26
Re: [FEATURE PATCH] pg_stat_statements with plans (v02) Michael Paquier 01:29
Re: [HACKERS] Re: Improve OR conditions on joined columns (common star schema problem) Tom Lane 01:32
Re: [PATCH v18] GSSAPI encryption support Michael Paquier 01:32
Re: SerializeParamList vs machines with strict alignment Tom Lane 01:38
Re: TupleTableSlot abstraction Kyotaro HORIGUCHI 01:41
Re: Vacuum: allow usage of more than 1GB of work mem Michael Paquier 01:43
Re: pg_dumpall --exclude-database option Michael Paquier 01:51
Re: [HACKERS] Removing [Merge]Append nodes which contain a single subpath Michael Paquier 01:55
Re: cost_sort() improvements Michael Paquier 01:58
Re: Push down Aggregates below joins Michael Paquier 02:00
Re: Subplan result caching Michael Paquier 02:11
Re: POC: GROUP BY optimization Michael Paquier 02:16
Re: Subplan result caching David Rowley 02:21
Re: TupleTableSlot abstraction Tom Lane 02:21
Re: Add SKIP LOCKED to VACUUM and ANALYZE 📎 Bossart, Nathan 02:22
Re: WIP Patch: Precalculate stable functions, infrastructure v1 Michael Paquier 02:22
Re: [HACKERS] Small improvement to compactify_tuples Michael Paquier 02:27
Re: jsonpath Michael Paquier 02:33
Re: Changing the autovacuum launcher scheduling; oldest table first algorithm Michael Paquier 02:42
Re: WIP: BRIN multi-range indexes Michael Paquier 02:49
Re: [HACKERS][PATCH] Applying PMDK to WAL operations for persistent memory Michael Paquier 02:53
Re: inconsistency and inefficiency in setup_conversion() Michael Paquier 02:56
Re: [HACKERS] [PATCH] Overestimated filter cost and its mitigation Michael Paquier 02:58
Re: [HACKERS] Client Connection redirection support for PostgreSQL Michael Paquier 03:00
Re: SerializeParamList vs machines with strict alignment Amit Kapila 03:42
Re: SerializeParamList vs machines with strict alignment Tom Lane 03:52
Re: [HACKERS] SERIALIZABLE with parallel query 📎 Thomas Munro 03:53
Re: SerializeParamList vs machines with strict alignment Amit Kapila 04:03
Re: SerializeParamList vs machines with strict alignment Tom Lane 04:08
Re: pgsql: Improve autovacuum logging for aggressive and anti-wraparound ru Masahiko Sawada 04:18
Re: SerializeParamList vs machines with strict alignment Amit Kapila 04:26
Re: [HACKERS] Secondary index access optimizations Michael Paquier 04:31
Re: [WIP PATCH] Index scan offset optimisation using visibility map Michael Paquier 04:35
Re: SerializeParamList vs machines with strict alignment Tom Lane 04:37
Re: [PATCH] Add missing type conversion functions for PL/Python Michael Paquier 04:42
Re: [PATCH] get rid of StdRdOptions, use individual binary reloptions representation for each relation kind instead Michael Paquier 04:46
Re: Upper limit arguments of pg_logical_slot_xxx_changes functions accept invalid values Michael Paquier 04:49
Re: de-deduplicate code in DML execution hooks in postgres_fdw Etsuro Fujita 04:50
Re: PATCH: logical_work_mem and logical streaming of large in-progress transactions Michael Paquier 04:59
Re: row filtering for logical replication Michael Paquier 05:03
Re: Allow COPY's 'text' format to output a header Michael Paquier 05:06
Re: [HACKERS] GSoC 2017: Foreign Key Arrays Michael Paquier 05:13
Re: de-deduplicate code in DML execution hooks in postgres_fdw Michael Paquier 05:15
Re: Allow to specify a index name as ANALYZE parameter Michael Paquier 05:27
Re: chained transactions Michael Paquier 05:38
Re: [HACKERS] [PATCH] WIP Add ALWAYS DEFERRED option for constraints Michael Paquier 05:43
Re: Postgres, fsync, and OSs (specifically linux) 📎 Thomas Munro 05:50
Re: SerializeParamList vs machines with strict alignment 📎 Amit Kapila 05:51
Re: [HACKERS] Transactions involving multiple postgres foreign servers, take 2 Michael Paquier 06:10
Tuple conversion naming Andres Freund 06:11
Re: [HACKERS] Transactions involving multiple postgres foreign servers, take 2 📎 Masahiko Sawada 06:25
Re: [HACKERS] Can ICU be used for a database's default sort order? Michael Paquier 06:37
Re: [PATCH] Add support for ON UPDATE/DELETE actions on ALTER CONSTRAINT Michael Paquier 06:40
Re: [HACKERS] pgbench - allow to store select results into variables 📎 Fabien COELHO 06:43
Re: Commit fest 2018-09 Michael Paquier 06:52
Re: pgsql: Improve autovacuum logging for aggressive and anti-wraparound ru Michael Paquier 06:55
Re: [WIP PATCH] Index scan offset optimisation using visibility map Michail Nikolaev 06:55
Re: inconsistency and inefficiency in setup_conversion() 📎 John Naylor 07:06
Re: shared-memory based stats collector 📎 Kyotaro HORIGUCHI 07:06
Re: Expression errors with "FOR UPDATE" and postgres_fdw with partition wise join enabled. Amit Langote 07:11
Re: Tuple conversion naming Amit Langote 07:18
Re: Slotification of partition tuple conversion 📎 Andres Freund 07:35
Re: Tuple conversion naming Andres Freund 07:40
Re: Sync ECPG scanner with core 📎 John Naylor 07:41
Re: Expression errors with "FOR UPDATE" and postgres_fdw with partition wise join enabled. Michael Paquier 07:45
Re: Expression errors with "FOR UPDATE" and postgres_fdw with partition wise join enabled. Etsuro Fujita 08:20
Re: Tuple conversion naming Amit Langote 08:28
Re: transction_timestamp() inside of procedures Peter Eisentraut 08:55
Re: Slotification of partition tuple conversion Amit Langote 09:35
Re: Early WIP/PoC for inlining CTEs 📎 Andreas Karlsson 10:03
Re: pg_ls_tmpdir() Christoph Berg 10:31
Re: has_column_privilege behavior (was Re: Assert failed in snprintf.c) Stephen Frost 10:46
Re: pg_ls_tmpdir() Laurenz Albe 12:00
Re: Problem while updating a foreign table pointing to a partitioned table on foreign server 📎 Etsuro Fujita 12:16
Re: [HACKERS] Support for Secure Transport SSL library on macOS as OpenSSL alternative Peter Eisentraut 12:19
Re: pg_ls_tmpdir() Andrew Dunstan 12:21
Re: settings to control SSL/TLS protocol version Peter Eisentraut 12:23
Re: settings to control SSL/TLS protocol version Daniel Gustafsson 12:29
Re: file cloning in pg_upgrade and CREATE DATABASE Peter Eisentraut 12:31
Re: [HACKERS] Support for Secure Transport SSL library on macOS as OpenSSL alternative Tom Lane 13:40
PostgreSQL 11 RC1 + GA Dates Jonathan S. Katz 13:58
Re: Commit fest 2018-09 Tom Lane 14:13
Re: pgsql: Improve autovacuum logging for aggressive and anti-wraparound ru Tom Lane 14:15
Re: Commit fest 2018-09 Joe Conway 14:16
Re: transction_timestamp() inside of procedures Bruce Momjian 14:16
Re: SerializeParamList vs machines with strict alignment Amit Kapila 14:18
Regarding Google Code-In mentorship KIRTIKA SINGHAL 14:22
Re: [HACKERS] Re: Improve OR conditions on joined columns (common star schema problem) Noah Misch 14:39
Re: transction_timestamp() inside of procedures Andres Freund 14:49
Re: [HACKERS] Re: Improve OR conditions on joined columns (common star schema problem) Tom Lane 14:53
Re: transction_timestamp() inside of procedures Andres Freund 14:58
Re: Tuple conversion naming Andres Freund 15:02
Re: has_column_privilege behavior (was Re: Assert failed in snprintf.c) Tom Lane 15:58
Re: has_column_privilege behavior (was Re: Assert failed in snprintf.c) Stephen Frost 16:10
Re: pg_ls_tmpdir() Bossart, Nathan 16:32
Re: has_column_privilege behavior (was Re: Assert failed in snprintf.c) Tom Lane 16:45
Re: pg_ls_tmpdir() Tom Lane 16:46
Re: transction_timestamp() inside of procedures Merlin Moncure 16:58
Re: Cygwin linking rules Tom Lane 17:07
NOTIFY and pg_notify performance when deduplicating notifications 📎 julien 17:19
Re: Cygwin linking rules Tom Lane 17:20
Re: Slotification of partition tuple conversion Andres Freund 18:02
Re: Commit fest 2018-09 David Fetter 18:05
Regarding Google Code In mentorship Roshni Ram 18:19
Re: Slotification of partition tuple conversion Andres Freund 18:40
Re: SerializeParamList vs machines with strict alignment Tom Lane 18:55
Re: pg_ls_tmpdir() 📎 Bossart, Nathan 19:01
Re: Cygwin linking rules Marco Atzeri 19:20
Re: Performance improvements for src/port/snprintf.c Andres Freund 20:13
Re: SerializeParamList vs machines with strict alignment Thomas Munro 20:59
Re: [PATCH v19] GSSAPI encryption support 📎 Robbie Harwood 21:11
Re: Performance improvements for src/port/snprintf.c 📎 Tom Lane 21:54
Re: Performance improvements for src/port/snprintf.c Tom Lane 22:04
Re: Obtaining a more consistent view definition when a UNION subquery contains undecorated constants Jacob Champion 22:24
Re: Progress reporting for pg_verify_checksums Thomas Munro 22:50
Re: [HACKERS] proposal: schema variables Thomas Munro 23:01
Re: [HACKERS] Optional message to user when terminating/cancelling backend Thomas Munro 23:09
Re: speeding up planning with partitions Thomas Munro 23:31
Re: file cloning in pg_upgrade and CREATE DATABASE Michael Paquier 23:32

Oct. 3, 2018

Thread Author Time
Re: SSL tests failing with "ee key too small" error on Debian SID Michael Paquier 00:32
Re: speeding up planning with partitions Amit Langote 00:47
Relax transactional restrictions on ALTER ENUM ... ADD TYPE (redux) 📎 Thomas Munro 01:24
Re: file cloning in pg_upgrade and CREATE DATABASE Alvaro Herrera 01:35
Re: file cloning in pg_upgrade and CREATE DATABASE Michael Paquier 01:44
Re: file cloning in pg_upgrade and CREATE DATABASE Alvaro Herrera 02:07
Re: SerializeParamList vs machines with strict alignment Amit Kapila 02:59
Re: partition tree inspection functions 📎 Michael Paquier 03:37
Re: Relax transactional restrictions on ALTER ENUM ... ADD TYPE (redux) Thomas Munro 03:42
Re: Relax transactional restrictions on ALTER ENUM ... ADD TYPE (redux) 📎 Thomas Munro 04:02
Re: SerializeParamList vs machines with strict alignment Amit Kapila 04:32
Re: Tid scan improvements David Rowley 04:36
Re: Pluggable Storage - Andres's take Andres Freund 05:16
Re: Add SKIP LOCKED to VACUUM and ANALYZE Michael Paquier 05:52
Re: [WIP PATCH] Index scan offset optimisation using visibility map Andrey Borodin 05:54
Re: Performance improvements for src/port/snprintf.c Andres Freund 06:09
RE: Global shared meta cache 📎 Ideriha, Takeshi 06:17
Re: [WIP PATCH] Index scan offset optimisation using visibility map Michael Paquier 06:40
Re: file cloning in pg_upgrade and CREATE DATABASE Michael Paquier 07:20
Re: pgsql: Improve autovacuum logging for aggressive and anti-wraparound ru 📎 Masahiko Sawada 07:37
Re: [HACKERS] Transactions involving multiple postgres foreign servers, take 2 Chris Travers 07:40
Re: Segfault when creating partition with a primary key and sql_drop trigger exists 📎 Michael Paquier 07:53
Re: pgsql: Improve autovacuum logging for aggressive and anti-wraparound ru Michael Paquier 07:55
Re: [HACKERS] Transactions involving multiple postgres foreign servers, take 2 Chris Travers 07:56
Re: [HACKERS] Transactions involving multiple postgres foreign servers, take 2 Chris Travers 08:03
Re: [HACKERS] Transactions involving multiple postgres foreign servers, take 2 Chris Travers 09:02
shared buffer manager problems and redesign Jamison, Kirk 09:46
Re[2]: Alter index rename concurrently to Andrey Klychkov 11:51
Re: partition tree inspection functions Jesper Pedersen 12:12
Re: Performance improvements for src/port/snprintf.c Tom Lane 12:20
Re: [RFC] Removing "magic" oids Andreas Karlsson 12:34
Re: BUG #15307: Low numerical precision of (Co-) Variance 📎 Dean Rasheed 13:04
Re: BUG #15307: Low numerical precision of (Co-) Variance Tom Lane 14:21
Re: BUG #15307: Low numerical precision of (Co-) Variance Madeleine Thompson 14:58
Re: Performance improvements for src/port/snprintf.c Andres Freund 15:52
Re: Early WIP/PoC for inlining CTEs David Fetter 15:57
Re: Performance improvements for src/port/snprintf.c 📎 Tom Lane 15:59
Re: Performance improvements for src/port/snprintf.c Tom Lane 16:07
Re: Performance improvements for src/port/snprintf.c Andres Freund 16:14
Re: Add SKIP LOCKED to VACUUM and ANALYZE 📎 Bossart, Nathan 16:20
Re: Performance improvements for src/port/snprintf.c Tom Lane 16:22
Re: libpq host/hostaddr/conninfo inconsistencies Arthur Zakirov 16:24
Re: Performance improvements for src/port/snprintf.c Andres Freund 16:32
Re: Performance improvements for src/port/snprintf.c Andres Freund 16:37
Re: Performance improvements for src/port/snprintf.c Tom Lane 16:43
Re: Performance improvements for src/port/snprintf.c Tom Lane 16:54
Re: Performance improvements for src/port/snprintf.c Andres Freund 17:00
Re: Performance improvements for src/port/snprintf.c Tom Lane 17:18
Re: Performance improvements for src/port/snprintf.c Tom Lane 17:31
Re: Performance improvements for src/port/snprintf.c Andres Freund 17:36
Re: Performance improvements for src/port/snprintf.c Andres Freund 17:39
Re: Performance improvements for src/port/snprintf.c Tom Lane 17:40
Re: Performance improvements for src/port/snprintf.c Andres Freund 17:45
Re: Performance improvements for src/port/snprintf.c Tom Lane 17:51
Re: Performance improvements for src/port/snprintf.c 📎 Tom Lane 18:01
Re: Performance improvements for src/port/snprintf.c Alvaro Herrera 18:11
Re: Performance improvements for src/port/snprintf.c Andres Freund 18:35
Re: Performance improvements for src/port/snprintf.c Tom Lane 18:36
Re: Performance improvements for src/port/snprintf.c Tom Lane 18:48
pg_upgrade failed with ERROR: null relpartbound for relation 18159 error. Rajkumar Raghuwanshi 18:58
Shouldn't ExecShutdownNode() be called from standard_ExecutorFinish()? Andres Freund 19:03
Re: Query is over 2x slower with jit=on Andres Freund 19:56
Re: executor relation handling Tom Lane 20:16
Skylake-S warning Daniel Wood 21:29
DROP DATABASE doesn't force other backends to close FDs Andres Freund 22:37
Re: Skylake-S warning Andres Freund 22:55
Re: Making all nbtree entries unique by having heap TIDs participate in comparisons 📎 Peter Geoghegan 23:39

Oct. 4, 2018

Thread Author Time
Re: Skylake-S warning Daniel Wood 00:01
Re: Add SKIP LOCKED to VACUUM and ANALYZE Michael Paquier 00:09
Re: [RFC] Removing "magic" oids Vik Fearing 00:22
Re: partition tree inspection functions Michael Paquier 00:27
Re: Skylake-S warning Daniel Wood 00:28
Re: Skylake-S warning Andres Freund 00:30
RE: Function for listing archive_status directory Iwata, Aya 01:03

Browse Archives

Prev | Next