pgsql-hackers before 2018-12-25 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

Dec. 20, 2018

Thread Author Time
Re: slow queries over information schema.tables Pavel Stehule 03:31
Switching to 64-bit Bitmapsets 📎 David Rowley 03:44
RE: Protect syscache from bloating with negative cache entries Ideriha, Takeshi 04:26
Re: slow queries over information schema.tables Tom Lane 04:29
Re: Switching to 64-bit Bitmapsets Tom Lane 04:50
Re: Ordered Partitioned Table Scans Julien Rouhaud 05:20
Re: slow queries over information schema.tables Pavel Stehule 05:21
Re: slow queries over information schema.tables Tom Lane 05:24
Re: [PATCH] Improve tab completion for CREATE TABLE Michael Paquier 05:33
Using POPCNT and other advanced bit manipulation instructions 📎 David Rowley 05:53
Re: [HACKERS] Block level parallel vacuum Amit Kapila 06:37
Re: Switching to 64-bit Bitmapsets 📎 David Rowley 06:44
Re: Using POPCNT and other advanced bit manipulation instructions Gavin Flower 07:17
Re: [HACKERS] Restricting maximum keep segments by repslots 📎 Kyotaro HORIGUCHI 07:24
RE: Protect syscache from bloating with negative cache entries Ideriha, Takeshi 07:56
Re: Using POPCNT and other advanced bit manipulation instructions David Rowley 08:10
RE: Localization tools for Postgres Ideriha, Takeshi 08:17
Improve selectivity estimate for range queries 📎 Yuzuko Hosoya 08:21
Re: [HACKERS] WAL logging problem in 9.4.3? 📎 Kyotaro HORIGUCHI 08:32
Re: Remove Deprecated Exclusive Backup Mode David Steele 10:29
[patch] de.po REINDEX error Christoph Berg 10:42
Re: Using POPCNT and other advanced bit manipulation instructions Dmitry Dolgov 10:57
Re: Using POPCNT and other advanced bit manipulation instructions Jose Luis Tallon 10:58
Re: Tid scan improvements David Rowley 11:49
Re: Change pgarch_readyXlog() to return .history files first 📎 David Steele 11:57
Re: Add timeline to partial WAL segments David Steele 12:13
START/END line number for COPY FROM 📎 Surafel Temesgen 13:02
Re: Index Skip Scan Dmitry Dolgov 13:46
Re: lock level for DETACH PARTITION looks sketchy Alvaro Herrera 14:29
Re: insensitive collations Daniel Verite 14:39
Re: Online verification of checksums 📎 Michael Banck 15:19
Re: A few new options for vacuumdb Bossart, Nathan 16:48
Re: A case for UPDATE DISTINCT attribute Alexey Bashtanov 16:59
Re: Switching to 64-bit Bitmapsets Tom Lane 17:26
Re: lock level for DETACH PARTITION looks sketchy Robert Haas 17:28
Performance issue in foreign-key-aware join estimation 📎 Tom Lane 17:44
Re: lock level for DETACH PARTITION looks sketchy Alvaro Herrera 18:13
Re: Switching to 64-bit Bitmapsets David Rowley 19:33
Re: lock level for DETACH PARTITION looks sketchy Alvaro Herrera 19:45
Re: ATTACH/DETACH PARTITION CONCURRENTLY 📎 Robert Haas 20:43
Re: lock level for DETACH PARTITION looks sketchy Robert Haas 20:44
Re: Add timeline to partial WAL segments Robert Haas 20:56
Re: ATTACH/DETACH PARTITION CONCURRENTLY Alvaro Herrera 20:58
Re: lock level for DETACH PARTITION looks sketchy Alvaro Herrera 20:58
Re: lock level for DETACH PARTITION looks sketchy Robert Haas 20:59
Re: ATTACH/DETACH PARTITION CONCURRENTLY Robert Haas 21:05
Re: lock level for DETACH PARTITION looks sketchy Alvaro Herrera 21:07
Re: ATTACH/DETACH PARTITION CONCURRENTLY Alvaro Herrera 21:11
Re: ATTACH/DETACH PARTITION CONCURRENTLY Robert Haas 21:38
monitoring CREATE INDEX [CONCURRENTLY] Alvaro Herrera 22:00
Re: Tid scan improvements Tom Lane 22:21
Re: Tid scan improvements Andres Freund 22:33
Re: BUG #15548: Unaccent does not remove combining diacritical characters 📎 Hugh Ranalli 22:39
Re: GIN predicate locking slows down valgrind isolationtests tremendously Alexander Korotkov 22:50
Re: reducing the footprint of ScanKeyword (was Re: Large writable variables) Tom Lane 23:00
Re: Why are we PageInit'ing buffers in RelationAddExtraBlocks()? 📎 Andres Freund 23:04
Re: Tid scan improvements Tom Lane 23:06
Re: Tid scan improvements Andres Freund 23:10
pgsql: Check for conflicting queries during replay of gistvacuumpage() Alexander Korotkov 23:38
Re: gist microvacuum doesn't appear to care about hot standby? Alexander Korotkov 23:40

Dec. 21, 2018

Thread Author Time
Re: Remove Deprecated Exclusive Backup Mode Michael Paquier 00:01
Re: Tid scan improvements Edmund Horner 00:09
Re: Add timeline to partial WAL segments Michael Paquier 00:10
Re: Tid scan improvements David Rowley 00:25
Re: lock level for DETACH PARTITION looks sketchy Amit Langote 00:59
Re: A few new options for vacuumdb Michael Paquier 01:05
RE: [Proposal] Add accumulated statistics Yotsunaga, Naoki 01:47
Re: [HACKERS] Macros bundling RELKIND_* conditions Ashutosh Bapat 02:20
Re: Change pgarch_readyXlog() to return .history files first 📎 Michael Paquier 03:19
Re: Tid scan improvements Edmund Horner 03:19
Re: [HACKERS] Macros bundling RELKIND_* conditions Kyotaro HORIGUCHI 03:20
Re: Improve selectivity estimate for range queries Kyotaro HORIGUCHI 03:24
Re: Tid scan improvements Tom Lane 03:31
Clean up some elog messages and comments for do_pg_stop_backup and do_pg_start_backup 📎 Michael Paquier 04:05
Re: Change pgarch_readyXlog() to return .history files first Kyotaro HORIGUCHI 04:49
Re: Change pgarch_readyXlog() to return .history files first Michael Paquier 05:17
Re: Change pgarch_readyXlog() to return .history files first Kyotaro HORIGUCHI 05:23
Re: Tab completion for ALTER INDEX|TABLE ALTER COLUMN SET STATISTICS 📎 Tatsuro Yamada 05:51
Re: Add timeline to partial WAL segments David Steele 06:12
Re: Change pgarch_readyXlog() to return .history files first David Steele 06:17
Re: Remove Deprecated Exclusive Backup Mode David Steele 06:18
Speeding up creating UPDATE/DELETE generic plan for partitioned table into a lot Kato, Sho 06:36
RE: Timeout parameters Nagaura, Ryohei 06:36
Re: "repliation" as database name 📎 Kyotaro HORIGUCHI 06:56
Re: Tab completion for ALTER INDEX|TABLE ALTER COLUMN SET STATISTICS 📎 Michael Paquier 07:13
Re: Tid scan improvements Edmund Horner 08:04
RE: Improve selectivity estimate for range queries 📎 Yuzuko Hosoya 08:21
RE: [suggestion]support UNICODE host variables in ECPG Nagaura, Ryohei 08:34
Performance of SELECT in a table partitioned into a lot Kato, Sho 08:43
Re: Speeding up creating UPDATE/DELETE generic plan for partitioned table into a lot Amit Langote 08:45
could recovery_target_timeline=latest be the default in standby mode? Peter Eisentraut 09:53
Re: Online verification of checksums Michael Banck 10:08
Re: Progress reporting for pg_verify_checksums 📎 Michael Banck 10:09
pg_upgrade: Pass -j down to vacuumdb 📎 Jesper Pedersen 10:12
Re: could recovery_target_timeline=latest be the default in standby mode? Sergei Kornilov 10:54
Re: Clean up some elog messages and comments for do_pg_stop_backup and do_pg_start_backup Alvaro Herrera 13:43
Re: [PATCH] Improve tab completion for CREATE TABLE Dagfinn Ilmari =?utf-8?Q?Manns=C3=A5ker?= 13:57
Re: tickling the lesser contributor's withering ego 📎 Alvaro Herrera 14:38
Re: tickling the lesser contributor's withering ego Tom Lane 14:45
Re: [PATCH] Improve tab completion for CREATE TABLE 📎 Dagfinn Ilmari =?utf-8?Q?Manns=C3=A5ker?= 15:14
Changes to pg_dump/psql following collation "C" in the catalog Daniel Verite 15:15
Re: tickling the lesser contributor's withering ego Alvaro Herrera 15:17
Re: tickling the lesser contributor's withering ego Erik Rijkers 15:25
Re: pgsql: Check for conflicting queries during replay of gistvacuumpage() Alvaro Herrera 15:49
Re: Changes to pg_dump/psql following collation "C" in the catalog Tom Lane 15:57
Re: pgsql: Check for conflicting queries during replay of gistvacuumpage() Tom Lane 16:00
Re: pgsql: Check for conflicting queries during replay of gistvacuumpage() Tom Lane 16:09
Re: pgsql: Check for conflicting queries during replay of gistvacuumpage() Alvaro Herrera 16:16
Re: START/END line number for COPY FROM Tom Lane 16:21
Re: ATTACH/DETACH PARTITION CONCURRENTLY Robert Haas 16:35
Query planner / Analyse statistics bad estimate rows=1 with maximum statistics 10000 on PostgreSQL 10.2 Mark 16:39
Re: Remove Deprecated Exclusive Backup Mode Robert Haas 16:43
Re: A few new options for vacuumdb Robert Haas 16:49
Re: Improve selectivity estimate for range queries Tom Lane 16:50
Re: A few new options for vacuumdb Robert Haas 16:50
Re: Tid scan improvements Tom Lane 16:57
Re: [suggestion]support UNICODE host variables in ECPG Tom Lane 17:07
Re: A few new options for vacuumdb Bossart, Nathan 17:12
Re: Tid scan improvements Tom Lane 18:10
RE: Query planner / Analyse statistics bad estimate rows=1 with maximum statistics 10000 on PostgreSQL 10.2 Kumar, Virendra 18:39
Re: slow queries over information schema.tables Greg Stark 18:46
Compiling on Termux 📎 David Fetter 18:56
Re: Compiling on Termux Thomas Munro 20:03
Offline enabling/disabling of data checksums 📎 Michael Banck 20:16
Re: Performance issue in foreign-key-aware join estimation 📎 David Rowley 20:28
Re: Compiling on Termux David Fetter 20:32
Re: Compiling on Termux Thomas Munro 21:04
Re: Compiling on Termux Andrew Dunstan 21:24
Re: Performance issue in foreign-key-aware join estimation David Rowley 21:53
Re: [HACKERS] ArrayLists instead of List (for some things) David Rowley 21:57
Re: Use an enum for RELKIND_*? Greg Stark 22:16
Re: Compiling on Termux David Fetter 22:19
Re: Compiling on Termux Thomas Munro 22:29
Re: Compiling on Termux Tom Lane 22:51
Re: ATTACH/DETACH PARTITION CONCURRENTLY David Rowley 23:04
Re: ATTACH/DETACH PARTITION CONCURRENTLY David Rowley 23:06
Re: Offline enabling/disabling of data checksums Michael Paquier 23:28
Joins on TID 📎 Tom Lane 23:34
Re: [PATCH] Improve tab completion for CREATE TABLE Michael Paquier 23:36
Re: could recovery_target_timeline=latest be the default in standby mode? Michael Paquier 23:38
Re: reducing the footprint of ScanKeyword (was Re: Large writable variables) 📎 John Naylor 23:38
Re: Clean up some elog messages and comments for do_pg_stop_backup and do_pg_start_backup Michael Paquier 23:42
Re: [PATCH] Improve tab completion for CREATE TABLE Michael Paquier 23:48
Re: Change pgarch_readyXlog() to return .history files first Michael Paquier 23:55

Dec. 22, 2018

Thread Author Time
Re: pgsql: Check for conflicting queries during replay of gistvacuumpage() Alexander Korotkov 00:21
Re: Joins on TID 📎 Tom Lane 04:31
Re: Joins on TID Simon Riggs 08:18
Re: Query planner / Analyse statistics bad estimate rows=1 with maximum statistics 10000 on PostgreSQL 10.2 Mark 09:14
Re: [PATCH] Improve tab completion for CREATE TABLE 📎 Dagfinn Ilmari =?utf-8?Q?Manns=C3=A5ker?= 13:33
Re: Offline enabling/disabling of data checksums Michael Banck 13:42
Re: Referential Integrity Checks with Statement-level Triggers Emre Hasegeli 16:28
Re: Joins on TID Tom Lane 16:31
Re: reducing the footprint of ScanKeyword (was Re: Large writable variables) Tom Lane 17:20
Re: reducing the footprint of ScanKeyword (was Re: Large writable variables) Andres Freund 18:14
Re: reducing the footprint of ScanKeyword (was Re: Large writable variables) Tom Lane 18:28
Re: Joins on TID Simon Riggs 19:15

Dec. 23, 2018

Thread Author Time
Re: Speeding up text_position_next with multibyte encodings 📎 Heikki Linnakangas 00:26
Re: Speeding up text_position_next with multibyte encodings Heikki Linnakangas 00:28
Re: Speeding up text_position_next with multibyte encodings Heikki Linnakangas 00:32
Re: [PATCH] Improve tab completion for CREATE TABLE Michael Paquier 00:35
Re: Offline enabling/disabling of data checksums Michael Paquier 00:41
Re: Speeding up text_position_next with multibyte encodings 📎 Heikki Linnakangas 00:45
Make relcache init write errors not be fatal 📎 Jeff Janes 01:49
Re: Make relcache init write errors not be fatal Andres Freund 01:54
Re: Make relcache init write errors not be fatal Jeff Janes 02:26
Re: Query planner / Analyse statistics bad estimate rows=1 with maximum statistics 10000 on PostgreSQL 10.2 Jeff Janes 02:56
Re: pgsql: Update ssl test certificates and keys Michael Paquier 08:04
Re: Undo logs 📎 Dilip Kumar 10:18
Re: CF app feature request Magnus Hagander 11:50
Re: CF app feature request Magnus Hagander 12:09
Re: Speeding up text_position_next with multibyte encodings Tomas Vondra 14:33
Re: CF app feature request Alvaro Herrera 14:59
Re: Query planner / Analyse statistics bad estimate rows=1 with maximum statistics 10000 on PostgreSQL 10.2 Maxim Boguk 15:28
Re: [PATCH] Improve tab completion for CREATE TABLE Dagfinn Ilmari =?utf-8?Q?Manns=C3=A5ker?= 15:33
Re: Joins on TID Darafei Komяpa Praliaskouski 16:23
Re: reducing the footprint of ScanKeyword (was Re: Large writable variables) 📎 John Naylor 17:51
Re: Function to track shmem reinit time Alexander Korotkov 20:14
Re: Performance issue in foreign-key-aware join estimation 📎 David Rowley 20:38

Dec. 24, 2018

Thread Author Time
Move regression.diffs of pg_upgrade test suite 📎 Noah Misch 03:44
Minor comment fix for pg_config_manual.h 📎 Ian Barwick 04:05
Small doc tweak for array/string functions 📎 Ian Barwick 06:28
Re: Minor comment fix for pg_config_manual.h Michael Paquier 08:57
Re: [WIP] CREATE SUBSCRIPTION with FOR TABLES clause (table filter) Andrey Borodin 10:03
Allow CLUSTER, VACUUM FULL and REINDEX to change tablespace on the fly 📎 Alexey Kondratov 11:08
Re: Change pgarch_readyXlog() to return .history files first Michael Paquier 11:31
Re: Performance issue in foreign-key-aware join estimation 📎 David Rowley 12:07
Re: Removing unneeded self joins 📎 Alexander Kuzmenkov 16:28
Re: [Patch] pg_rewind: options to use restore_command from recovery.conf or command line 📎 Alexey Kondratov 16:31
Re: ATTACH/DETACH PARTITION CONCURRENTLY Robert Haas 19:15
Re: ATTACH/DETACH PARTITION CONCURRENTLY Robert Haas 19:19
Re: pg_dumpall --exclude-database option Andrew Dunstan 19:46
Re: Move regression.diffs of pg_upgrade test suite Andrew Dunstan 20:11
Feature: triggers on materialized views 📎 Mitar 20:59
Re: GIN predicate locking slows down valgrind isolationtests tremendously Alexander Korotkov 21:19
Re: Race to build pg_isolation_regress in "make -j check-world" 📎 Noah Misch 22:16
Re: Feature: triggers on materialized views David Fetter 22:20
Re: GIN predicate locking slows down valgrind isolationtests tremendously 📎 Alexander Korotkov 22:25
Re: GIN predicate locking slows down valgrind isolationtests tremendously Andrew Dunstan 22:47
Re: ATTACH/DETACH PARTITION CONCURRENTLY David Rowley 22:58
Re: Statement-level Triggers For Uniqueness Checks 📎 Corey Huinker 23:56

Browse Archives

Prev | Next