pgsql-hackers since 2018-12-26 22:09

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

Dec. 26, 2018

Thread Author Time
Re: [HACKERS] PATCH: multivariate histograms and MCV lists 📎 Tomas Vondra 22:09
Re: pgsql: Fix failure to check for open() or fsync() failures. Michael Paquier 22:43
Re: Move regression.diffs of pg_upgrade test suite Noah Misch 22:44
Re: pgsql: Fix failure to check for open() or fsync() failures. Tom Lane 22:55
RE: removal of dangling temp tables Tsunakawa, Takayuki 23:45
Re: removal of dangling temp tables 📎 Alvaro Herrera 23:51
Re: Shared Memory: How to use SYSV rather than MMAP ? 📎 Thomas Munro 23:53

Dec. 27, 2018

Thread Author Time
RE: removal of dangling temp tables Tsunakawa, Takayuki 00:26
Re: pgsql: Fix failure to check for open() or fsync() failures. Michael Paquier 01:09
Re: Offline enabling/disabling of data checksums Michael Paquier 01:15
Re: random() (was Re: New GUC to sample log queries) Michael Paquier 01:34
Re: pgsql: Fix failure to check for open() or fsync() failures. Tom Lane 01:35
Re: random() (was Re: New GUC to sample log queries) Tom Lane 01:46
[information] Winter vacation Nagaura, Ryohei 01:46
Re: Allow CLUSTER, VACUUM FULL and REINDEX to change tablespace on the fly Michael Paquier 01:57
Re: GIN predicate locking slows down valgrind isolationtests tremendously Alexander Korotkov 01:59
Re: random() (was Re: New GUC to sample log queries) Michael Paquier 02:04
Re: pgsql: Fix failure to check for open() or fsync() failures. 📎 Michael Paquier 02:10
Re: random() (was Re: New GUC to sample log queries) Peter Geoghegan 02:20
Re: pgsql: Fix failure to check for open() or fsync() failures. Tom Lane 02:30
Re: random() (was Re: New GUC to sample log queries) Tom Lane 02:39
Re: [PATCH] kNN for btree Alexander Korotkov 02:46
Re: random() (was Re: New GUC to sample log queries) Peter Geoghegan 02:55
Re: removal of dangling temp tables Michael Paquier 04:32
RE: DECLARE STATEMENT Syntax support 📎 Kuroda, Hayato 04:46
Re: random() (was Re: New GUC to sample log queries) Thomas Munro 04:55
PostgreSQL partition tables use more private memory 📎 大松 06:44
Re: BUG #15548: Unaccent does not remove combining diacritical characters Michael Paquier 06:49
RE: Cache relation sizes? Jamison, Kirk 06:59
RE: Speeding up creating UPDATE/DELETE generic plan for partitioned table into a lot Kato, Sho 07:53
Re: [WIP] CREATE SUBSCRIPTION with FOR TABLES clause (table filter) 📎 Evgeniy Efimkin 07:54
RE: Timeout parameters Tsunakawa, Takayuki 08:25
Re: Speeding up creating UPDATE/DELETE generic plan for partitioned table into a lot Amit Langote 08:29
Re: random() (was Re: New GUC to sample log queries) Fabien COELHO 08:36
Re: Offline enabling/disabling of data checksums Fabien COELHO 08:52
Re: Feature: temporary materialized views 📎 Mitar 09:01
Re: [HACKERS] REINDEX CONCURRENTLY 2.0 Peter Eisentraut 10:04
Re: [HACKERS] [PATCH] Generic type subscripting 📎 Dmitry Dolgov 10:31
Re: Offline enabling/disabling of data checksums Magnus Hagander 10:39
Re: Offline enabling/disabling of data checksums Magnus Hagander 10:43
Re: tickling the lesser contributor's withering ego Magnus Hagander 10:53
Re: PostgreSQL partition tables use more private memory Pavel Stehule 11:01
Re: could recovery_target_timeline=latest be the default in standby mode? 📎 Peter Eisentraut 11:02
Re: [PATCH] pg_hba.conf : new auth option : clientcert=verify-full Magnus Hagander 11:14
Re: speeding up planning with partitions 📎 Amit Langote 11:25
Re: Offline enabling/disabling of data checksums Fabien COELHO 11:26
Re: PostgreSQL partition tables use more private memory Amit Langote 11:28
Re: PostgreSQL partition tables use more private memory Marcus Mao 11:58
Re: Allow CLUSTER, VACUUM FULL and REINDEX to change tablespace on the fly Alexey Kondratov 12:06
Re: global / super barriers (for checksums) Magnus Hagander 12:54
Implementing Incremental View Maintenance Yugo Nagata 12:57
Re: Feature: temporary materialized views Alvaro Herrera 13:15
Re: reducing the footprint of ScanKeyword (was Re: Large writable variables) Andres Freund 13:19
Re: global / super barriers (for checksums) Andres Freund 13:22
Re: Allow CLUSTER, VACUUM FULL and REINDEX to change tablespace on the fly Alvaro Herrera 13:24
Re: global / super barriers (for checksums) Magnus Hagander 13:42
Re: tickling the lesser contributor's withering ego Jonathan S. Katz 14:38
Re: Offline enabling/disabling of data checksums Tomas Vondra 14:46
Re: Offline enabling/disabling of data checksums Tomas Vondra 14:53
Re: Offline enabling/disabling of data checksums Magnus Hagander 14:55
Re: reducing the footprint of ScanKeyword (was Re: Large writable variables) 📎 John Naylor 16:19
Re: BUG #15548: Unaccent does not remove combining diacritical characters Hugh Ranalli 16:21
Re: Alternative to \copy in psql modelled after \g Daniel Verite 16:24
Re: could recovery_target_timeline=latest be the default in standby mode? David Steele 16:36
Re: Remove Deprecated Exclusive Backup Mode David Steele 16:47
Re: Remove Deprecated Exclusive Backup Mode Magnus Hagander 16:53
Re: Alternative to \copy in psql modelled after \g Fabien COELHO 16:57
Re: GIN predicate locking slows down valgrind isolationtests tremendously Andrew Dunstan 16:58
Re: Remove Deprecated Exclusive Backup Mode David Steele 17:03
Re: reducing the footprint of ScanKeyword (was Re: Large writable variables) Tom Lane 17:12
Re: Alternative to \copy in psql modelled after \g Daniel Verite 17:43
Re: Alternative to \copy in psql modelled after \g Alvaro Herrera 18:15
Re: Feature: temporary materialized views 📎 Mitar 18:35
Re: reducing the footprint of ScanKeyword (was Re: Large writable variables) Andrew Dunstan 18:54
Re: reducing the footprint of ScanKeyword (was Re: Large writable variables) Tom Lane 18:57
Re: row filtering for logical replication Stephen Frost 19:05
Re: row filtering for logical replication Stephen Frost 19:19
Re: reducing the footprint of ScanKeyword (was Re: Large writable variables) Tom Lane 19:22
Re: removal of dangling temp tables Alvaro Herrera 19:30
Re: random() (was Re: New GUC to sample log queries) Tom Lane 19:33
Re: random() (was Re: New GUC to sample log queries) Tom Lane 19:36
Re: random() (was Re: New GUC to sample log queries) Tom Lane 20:00
Re: reducing the footprint of ScanKeyword (was Re: Large writable variables) John Naylor 20:00
Re: using index or check in ALTER TABLE SET NOT NULL Dmitry Dolgov 20:03
Re: reducing the footprint of ScanKeyword (was Re: Large writable variables) Tom Lane 20:19
Re: reducing the footprint of ScanKeyword (was Re: Large writable variables) Andrew Dunstan 20:20
Re: reducing the footprint of ScanKeyword (was Re: Large writable variables) Tom Lane 20:34
Re: reducing the footprint of ScanKeyword (was Re: Large writable variables) Andrew Dunstan 20:48
Poor buildfarm coverage of strong-random alternatives Tom Lane 20:56
Re: pg_dumpall --exclude-database option Andrew Dunstan 20:56
Re: reducing the footprint of ScanKeyword (was Re: Large writable variables) Tom Lane 21:26
Re: Cache relation sizes? Thomas Munro 21:42
Re: pg_dumpall --exclude-database option 📎 Fabien COELHO 21:55
Re: reducing the footprint of ScanKeyword (was Re: Large writable variables) Alvaro Herrera 22:04
Re: reducing the footprint of ScanKeyword (was Re: Large writable variables) David Fetter 22:15
Re: removal of dangling temp tables Michael Paquier 22:56
Re: random() (was Re: New GUC to sample log queries) Tom Lane 23:00
Re: Poor buildfarm coverage of strong-random alternatives Michael Paquier 23:00
Re: Poor buildfarm coverage of strong-random alternatives Tom Lane 23:14
Re: row filtering for logical replication Petr Jelinek 23:15
Re: could recovery_target_timeline=latest be the default in standby mode? Michael Paquier 23:15
Re: Offline enabling/disabling of data checksums Michael Paquier 23:25
Re: [HACKERS] REINDEX CONCURRENTLY 2.0 Michael Paquier 23:32
Re: row filtering for logical replication Petr Jelinek 23:36

Dec. 28, 2018

Thread Author Time
Re: Offline enabling/disabling of data checksums Tomas Vondra 00:14
Re: GIN predicate locking slows down valgrind isolationtests tremendously Alexander Korotkov 00:46
Re: Alter table documentation page (again) Michael Paquier 01:20
Re: [HACKERS] SERIALIZABLE on standby servers Thomas Munro 01:21
Re: Offline enabling/disabling of data checksums Michael Paquier 01:30
Re: Minor comment fix for pg_config_manual.h Michael Paquier 01:41
Re: plpgsql plugin - stmt_beg/end is not called for top level block of statements Michael Paquier 02:26
Re: [HACKERS] Block level parallel vacuum 📎 Masahiko Sawada 02:43
Re: removal of dangling temp tables Alvaro Herrera 03:05
Re: Synchronous replay take III 📎 Thomas Munro 03:34
Re: Alter table documentation page (again) Alvaro Herrera 03:36
Re: Minor comment fix for pg_config_manual.h Alvaro Herrera 03:37
add_partial_path() may remove dominated path but still in use Kohei KaiGai 04:21
Re: removal of dangling temp tables Michael Paquier 04:43
Re: Compiling on Termux Thomas Munro 05:45
Re: Problems with plan estimates in postgres_fdw 📎 Etsuro Fujita 06:50
Re: plpgsql plugin - stmt_beg/end is not called for top level block of statements 📎 Pavel Stehule 06:57
RE: Speeding up creating UPDATE/DELETE generic plan for partitioned table into a lot Tsunakawa, Takayuki 07:35
Re: Feature: triggers on materialized views 📎 Mitar 07:43
Re: Feature: temporary materialized views 📎 Mitar 07:48
Re: plpgsql plugin - stmt_beg/end is not called for top level block of statements Michael Paquier 07:50
Re: Feature: triggers on materialized views 📎 Mitar 07:51
Re: Feature: triggers on materialized views Mitar 08:11
Re: [HACKERS] CLUSTER command progress monitor 📎 Tatsuro Yamada 08:17
Re: random() (was Re: New GUC to sample log queries) Fabien COELHO 08:18
Re: postgres_fdw: oddity in costing aggregate pushdown paths 📎 Etsuro Fujita 08:28
Re: Allow CLUSTER, VACUUM FULL and REINDEX to change tablespace on the fly Masahiko Sawada 08:31
Re: random() (was Re: New GUC to sample log queries) Fabien COELHO 08:44
Re: Feature: triggers on materialized views Mitar 08:48
Re: reducing the footprint of ScanKeyword (was Re: Large writable variables) Andres Freund 08:54
Re: insensitive collations 📎 Peter Eisentraut 08:55
Re: Offline enabling/disabling of data checksums Magnus Hagander 09:12
Re: random() (was Re: New GUC to sample log queries) 📎 Fabien COELHO 11:07
Re: could recovery_target_timeline=latest be the default in standby mode? 📎 Peter Eisentraut 11:08
Prepare Transaction support for ON COMMIT DROP temporary tables 📎 Dimitri Fontaine 11:46
Re: Prepare Transaction support for ON COMMIT DROP temporary tables Vik Fearing 11:57
Re: random() (was Re: New GUC to sample log queries) Adrien NAYRAT 12:10
Re: removal of dangling temp tables Alvaro Herrera 13:25
Re: Poor buildfarm coverage of strong-random alternatives Heikki Linnakangas 13:27
Re: random() (was Re: New GUC to sample log queries) Fabien COELHO 14:27
Re: Offline enabling/disabling of data checksums Fabien COELHO 14:50
Re: pg_dump multi VALUES INSERT 📎 Surafel Temesgen 14:57
Re: Poor buildfarm coverage of strong-random alternatives Tom Lane 15:16
Re: pg_dump multi VALUES INSERT Fabien COELHO 15:46
Re: removal of dangling temp tables Alvaro Herrera 16:23
Re: removal of dangling temp tables Tom Lane 16:35
Re: add_partial_path() may remove dominated path but still in use Tom Lane 16:44
Re: removal of dangling temp tables Tom Lane 16:47
Re: random() (was Re: New GUC to sample log queries) Tom Lane 17:29
Re: removal of dangling temp tables Alvaro Herrera 17:34
Re: rewrite ExecPartitionCheckEmitError Alvaro Herrera 17:52
Re: Making all nbtree entries unique by having heap TIDs participate in comparisons Heikki Linnakangas 18:04
Re: Prepare Transaction support for ON COMMIT DROP temporary tables Alvaro Herrera 18:06
Re: [Patch] Create a new session in postmaster by calling setsid() Heikki Linnakangas 18:33
Re: Prepare Transaction support for ON COMMIT DROP temporary tables 📎 Dimitri Fontaine 19:32
Re: [Patch] Create a new session in postmaster by calling setsid() Tom Lane 20:13
Regression tests using multiple sessions Mitar 20:49
Re: Regression tests using multiple sessions Alvaro Herrera 21:01
Re: Regression tests using multiple sessions Mitar 21:05
Re: Regression tests using multiple sessions Alvaro Herrera 21:21
Re: random() (was Re: New GUC to sample log queries) 📎 Tom Lane 21:42
Re: Making all nbtree entries unique by having heap TIDs participate in comparisons Peter Geoghegan 23:04
Re: random() (was Re: New GUC to sample log queries) 📎 Tom Lane 23:15
Re: Making all nbtree entries unique by having heap TIDs participate in comparisons Heikki Linnakangas 23:20
Re: Offline enabling/disabling of data checksums Michael Paquier 23:26
Re: Minor comment fix for pg_config_manual.h Michael Paquier 23:27
Re: Making all nbtree entries unique by having heap TIDs participate in comparisons Peter Geoghegan 23:32
Re: Prepare Transaction support for ON COMMIT DROP temporary tables Michael Paquier 23:32

Dec. 29, 2018

Thread Author Time
Re: random() (was Re: New GUC to sample log queries) Tom Lane 00:36
Re: random() (was Re: New GUC to sample log queries) Thomas Munro 00:45
Re: random() (was Re: New GUC to sample log queries) Tom Lane 00:57
Re: add_partial_path() may remove dominated path but still in use Kohei KaiGai 01:05
Augment every test postgresql.conf Noah Misch 02:19
Re: Offline enabling/disabling of data checksums Michael Banck 10:55
Re: WIP: Avoid creation of the free space map for small tables Mithun Cy 11:15
Garbage contents after running autoconf 2.69 Michael Paquier 14:08
Re: pg_upgrade: Pass -j down to vacuumdb Peter Eisentraut 15:03
Use atexit() in initdb and pg_basebackup 📎 Peter Eisentraut 15:12
Re: Clean up some elog messages and comments for do_pg_stop_backup and do_pg_start_backup Peter Eisentraut 15:29
Re: Clean up some elog messages and comments for do_pg_stop_backup and do_pg_start_backup Peter Eisentraut 15:31
Re: Garbage contents after running autoconf 2.69 Tom Lane 15:36
Re: Poor buildfarm coverage of strong-random alternatives Tom Lane 16:39
Re: add_partial_path() may remove dominated path but still in use Tom Lane 19:12
Re: random() (was Re: New GUC to sample log queries) Tom Lane 21:07
Optimize constant MinMax expressions 📎 Vik Fearing 21:40
Re: reducing the footprint of ScanKeyword (was Re: Large writable variables) 📎 John Naylor 21:59
Re: [PATCH] kNN for btree Alexander Korotkov 22:19
Re: WIP: Avoid creation of the free space map for small tables John Naylor 22:19
pgsql: Use a separate random seed for SQL random()/setseed() functions. Tom Lane 22:33
Re: Mutability of domain CHECK constraints Vik Fearing 23:03
Re: Mutability of domain CHECK constraints Tom Lane 23:14
Planning counters in pg_stat_statements (using pgss_store) 📎 legrand legrand 23:27
Re: Optimize constant MinMax expressions Tom Lane 23:36
Re: Poor buildfarm coverage of strong-random alternatives Tom Lane 23:56

Dec. 30, 2018

Thread Author Time
Using Btree to Provide Sorting on Suffix Keys with LIMIT James Coleman 00:00
Re: Performance issue in foreign-key-aware join estimation David Rowley 00:36

Browse Archives

Prev | Next