pgsql-hackers since 2018-04-02 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

April 2, 2018

Thread Author Time
Re: [HACKERS] path toward faster partition pruning Amit Langote 01:42
Re: Commit 4dba331cb3 broke ATTACH PARTITION behaviour. Jeevan Ladhe 04:10
Re: Add default role 'pg_access_server_files' Michael Paquier 04:42
Re: [HACKERS] path toward faster partition pruning 📎 Amit Langote 05:18
Re: Commit 4dba331cb3 broke ATTACH PARTITION behaviour. 📎 Amit Langote 05:29
Re: PATCH: Configurable file mode mask Michael Paquier 06:28
Re: [PATCH] Logical decoding of TRUNCATE Simon Riggs 06:39
Re: json(b)_to_tsvector with numeric values Arthur Zakirov 06:45
check_ssl_key_file_permissions should be in be-secure-common.c 📎 Michael Paquier 06:51
Re: [HACKERS] logical decoding of two-phase transactions 📎 Nikhil Sontakke 07:49
Re: [HACKERS] logical decoding of two-phase transactions Simon Riggs 08:23
Re: [HACKERS] logical decoding of two-phase transactions Simon Riggs 08:28
Re: json(b)_to_tsvector with numeric values Oleg Bartunov 08:41
make installcheck-world in a clean environment 📎 Alexander Lakhin 09:12
Re: json(b)_to_tsvector with numeric values Arthur Zakirov 09:27
Re: [HACKERS] [PATCH] Lockable views 📎 Yugo Nagata 09:32
Re: [HACKERS] Add support for tuple routing to foreign partitions Amit Langote 09:49
Re: json(b)_to_tsvector with numeric values 📎 Dmitry Dolgov 10:29
Re: Diagonal storage model Ashutosh Bapat 11:57
Re: [HACKERS] path toward faster partition pruning David Rowley 12:03
Re: Diagonal storage model Andrey Borodin 12:21
Re: [HACKERS] Add support for tuple routing to foreign partitions Etsuro Fujita 12:26
Re: [HACKERS] Add support for tuple routing to foreign partitions Etsuro Fujita 12:29
Re: Foreign keys and partitioned tables Peter Eisentraut 12:35
Re: [PATCH] Verify Checksums during Basebackups 📎 Michael Banck 12:48
Re: hot_standby_feedback vs excludeVacuum and snapshots Amit Kapila 12:57
Re: Foreign keys and partitioned tables Peter Eisentraut 14:16
Re: disable SSL compression? Robert Haas 14:25
Re: Rewriting the test of pg_upgrade as a TAP test - take two Peter Eisentraut 14:35
Re: disable SSL compression? Peter Eisentraut 14:52
Re: [HACKERS] Partition-wise aggregation/grouping Robert Haas 14:57
Re: PostgreSQL's handling of fsync() errors is unsafe and risks data loss at least on XFS Craig Ringer 15:03
Re: Change RangeVarGetRelidExtended() to take flags argument? Bossart, Nathan 15:04
Re: disable SSL compression? Robert Haas 15:05
Re: Feature Request - DDL deployment with logical replication Craig Ringer 15:07
Re: [HACKERS] Restrict concurrent update/delete with UPDATE of partition key Robert Haas 15:26
Re: check_ssl_key_file_permissions should be in be-secure-common.c Peter Eisentraut 15:39
Re: disable SSL compression? Peter Eisentraut 15:49
Re: Commit 4dba331cb3 broke ATTACH PARTITION behaviour. Alvaro Herrera 16:00
Re: new function for tsquery creartion 📎 Dmitry Ivanov 16:41
Re: disable SSL compression? Tom Lane 16:46
Re: tab complete for procedures for \sf and \ef commands Peter Eisentraut 16:49
Re: disable SSL compression? Peter Eisentraut 17:04
Re: disable SSL compression? Garick Hamlin 17:48
Re: [HACKERS] logical decoding of two-phase transactions Andres Freund 18:04
Re: PostgreSQL's handling of fsync() errors is unsafe and risks data loss at least on XFS Andres Freund 18:13
Re: disable SSL compression? Andres Freund 18:28
Re: [PATCH] Logical decoding of TRUNCATE Peter Eisentraut 18:30
Re: disable SSL compression? Andres Freund 18:35
Re: [PATCH] Logical decoding of TRUNCATE Simon Riggs 18:40
Re: [PATCH] Logical decoding of TRUNCATE Andres Freund 18:43
Re: [PATCH] Logical decoding of TRUNCATE Andres Freund 18:50
Re: Feature Request - DDL deployment with logical replication Andres Freund 18:53
Re: PostgreSQL's handling of fsync() errors is unsafe and risks data loss at least on XFS Anthony Iliopoulos 18:53
Re: Commit 4dba331cb3 broke ATTACH PARTITION behaviour. 📎 Alvaro Herrera 19:11
Re: Passing current_database to BackgroundWorkerInitializeConnection Jeremy Finzel 19:24
Re: Passing current_database to BackgroundWorkerInitializeConnection Andres Freund 19:27
Re: PostgreSQL's handling of fsync() errors is unsafe and risks data loss at least on XFS Andres Freund 19:32
Re: Passing current_database to BackgroundWorkerInitializeConnection Jeremy Finzel 19:33
Re: Passing current_database to BackgroundWorkerInitializeConnection Andres Freund 19:35
fdw_startup/tuple_cost vs. parallel_startup/tuple_cost Robert Haas 20:02
Re: BUG #15112: Unable to run pg_upgrade with earthdistance extension 📎 Bruce Momjian 20:24
Re: BRIN FSM vacuuming questions Alvaro Herrera 20:32
Re: PostgreSQL's handling of fsync() errors is unsafe and risks data loss at least on XFS Anthony Iliopoulos 20:38
Disabling memory display in EXPLAIN ANALYZE Andres Freund 20:51
Re: BRIN FSM vacuuming questions Tom Lane 20:52
Re: PostgreSQL's handling of fsync() errors is unsafe and risks data loss at least on XFS Stephen Frost 20:58
Re: Disabling memory display in EXPLAIN ANALYZE Stephen Frost 21:01
Re: [PATCH] Logical decoding of TRUNCATE Christophe Pettus 21:04
Re: Add default role 'pg_access_server_files' 📎 Stephen Frost 21:09
Re: Rethinking -L switch handling and construction of LDFLAGS 📎 Tom Lane 21:43
Re: Disabling memory display in EXPLAIN ANALYZE Andres Freund 22:03
Re: PostgreSQL's handling of fsync() errors is unsafe and risks data loss at least on XFS Anthony Iliopoulos 23:05
Re: Creating streaming replication standby Tatsuo Ishii 23:09
Re: PostgreSQL's handling of fsync() errors is unsafe and risks data loss at least on XFS Andres Freund 23:23
Re: WIP: Covering + unique indexes. 📎 Alexander Korotkov 23:27
Re: PostgreSQL's handling of fsync() errors is unsafe and risks data loss at least on XFS Craig Ringer 23:27
Re: BUG #14999: pg_rewind corrupts control file global/pg_control Tom Lane 23:27

April 3, 2018

Thread Author Time
Re: PostgreSQL's handling of fsync() errors is unsafe and risks data loss at least on XFS Christophe Pettus 00:03
Re: PostgreSQL's handling of fsync() errors is unsafe and risks data loss at least on XFS Andres Freund 00:05
Re: PostgreSQL's handling of fsync() errors is unsafe and risks data loss at least on XFS Christophe Pettus 00:07
Re: check_ssl_key_file_permissions should be in be-secure-common.c Michael Paquier 00:27
Re: PostgreSQL's handling of fsync() errors is unsafe and risks data loss at least on XFS Peter Geoghegan 00:48
Re: 2018-03 Commitfest Summary (Andres #1) Bruce Momjian 00:57
Re: PostgreSQL's handling of fsync() errors is unsafe and risks data loss at least on XFS Thomas Munro 01:29
Re: [HACKERS] MERGE SQL Statement for PG11 Andres Freund 02:18
Re: [HACKERS] MERGE SQL Statement for PG11 Peter Geoghegan 02:40
Re: BUG #14999: pg_rewind corrupts control file global/pg_control Michael Paquier 02:41
Re: Diagonal storage model Michael Paquier 02:49
RE: Speedup of relation deletes during recovery Tsunakawa, Takayuki 02:51
Re: PostgreSQL's handling of fsync() errors is unsafe and risks data loss at least on XFS Robert Haas 02:54
Re: [HACKERS] MERGE SQL Statement for PG11 Robert Haas 03:01
Re: [HACKERS] MERGE SQL Statement for PG11 Pavan Deolasee 03:11
Re: [HACKERS] MERGE SQL Statement for PG11 Peter Geoghegan 03:18
Re: [HACKERS] MERGE SQL Statement for PG11 Andres Freund 03:22
Re: PostgreSQL's handling of fsync() errors is unsafe and risks data loss at least on XFS Peter Geoghegan 03:45
Re: WIP: Covering + unique indexes. Peter Geoghegan 04:02
Re: [HACKERS] Add support for tuple routing to foreign partitions Amit Langote 04:32
Re: [HACKERS] [PATCH] Lockable views 📎 Yugo Nagata 04:49
Re: Add default role 'pg_access_server_files' Michael Paquier 04:53
Re: [HACKERS] Add support for tuple routing to foreign partitions Amit Langote 04:59
Re: BUG #14941: Vacuum crashes Michael Paquier 05:11
Re: Optimizing nested ConvertRowtypeExpr execution 📎 Ashutosh Bapat 05:18
Re: Commit 4dba331cb3 broke ATTACH PARTITION behaviour. Kyotaro HORIGUCHI 05:45
Re: Rewriting the test of pg_upgrade as a TAP test - take two Michael Paquier 06:04
Re: ALTER TABLE ADD COLUMN fast default Andrew Dunstan 06:14
Re: Changing WAL Header to reduce contention during ReserveXLogInsertLocation() Heikki Linnakangas 07:23
Missing parse_merge.h? Satoshi Nagayasu 09:07
Re: [HACKERS] [PATCH] Incremental sort Alexander Korotkov 09:09
Re: Missing parse_merge.h? Pavan Deolasee 09:11
Re: Missing parse_merge.h? Satoshi Nagayasu 09:14
Re: Commit 4dba331cb3 broke ATTACH PARTITION behaviour. Amit Langote 09:22
pgsql: New files for MERGE Simon Riggs 09:24
Re: PostgreSQL's handling of fsync() errors is unsafe and risks data loss at least on XFS Anthony Iliopoulos 10:35
Re: [HACKERS] logical decoding of two-phase transactions 📎 Nikhil Sontakke 10:40
Re: new function for tsquery creartion 📎 Dmitry Ivanov 10:47
Re: [HACKERS] [PATCH] Incremental sort Tomas Vondra 11:10
Re: PostgreSQL's handling of fsync() errors is unsafe and risks data loss at least on XFS Greg Stark 11:26
Re: new function for tsquery creartion 📎 Dmitry Ivanov 11:28
Re: [PATCH] Verify Checksums during Basebackups Magnus Hagander 11:52
pgsql: Validate page level checksums in base backups Magnus Hagander 11:52
Re: [PROPOSAL] Shared Ispell dictionaries 📎 Arthur Zakirov 11:57
Re: [PATCH] Verify Checksums during Basebackups Magnus Hagander 11:59
Re: [HACKERS] path toward faster partition pruning 📎 Amit Langote 12:02
Re: Online enabling of checksums 📎 Magnus Hagander 12:05
Re: [HACKERS] Add support for tuple routing to foreign partitions 📎 Etsuro Fujita 13:01
Re: [HACKERS] Add support for tuple routing to foreign partitions Etsuro Fujita 13:04
Re: [HACKERS] [PATCH] Vacuum: Update FSM more frequently Claudio Freire 13:17
Re: [HACKERS] [PATCH] Vacuum: Update FSM more frequently Claudio Freire 13:19
Re: Changing WAL Header to reduce contention during ReserveXLogInsertLocation() Robert Haas 13:33
Re: [HACKERS] advanced partition matching algorithm for partition-wise join 📎 Ashutosh Bapat 13:34
Re: PostgreSQL's handling of fsync() errors is unsafe and risks data loss at least on XFS Anthony Iliopoulos 13:36
Re: [HACKERS] [PATCH] Vacuum: Update FSM more frequently Claudio Freire 13:37
Re: Changing WAL Header to reduce contention during ReserveXLogInsertLocation() Tom Lane 13:56
Re: [HACKERS] logical decoding of two-phase transactions 📎 Tomas Vondra 13:56
Re: Transform for pl/perl Peter Eisentraut 13:58
Re: [PATCH] Verify Checksums during Basebackups 📎 Michael Banck 14:00
Re: WIP: Covering + unique indexes. Alexander Korotkov 14:02
Re: [PATCH] Verify Checksums during Basebackups Magnus Hagander 14:04
Re: Vacuum: allow usage of more than 1GB of work mem Claudio Freire 14:06
Re: [HACKERS] logical decoding of two-phase transactions Stas Kelvich 14:07
Re: Vacuum: allow usage of more than 1GB of work mem Claudio Freire 14:09
Re: new function for tsquery creartion Aleksandr Parfenov 14:13
Re: Vacuum: allow usage of more than 1GB of work mem 📎 Claudio Freire 14:20
Re: [PATCH] Verify Checksums during Basebackups Tom Lane 14:25
Re: [PATCH] Verify Checksums during Basebackups Magnus Hagander 14:28
Re: PostgreSQL's handling of fsync() errors is unsafe and risks data loss at least on XFS Craig Ringer 14:29
Re: [PATCH] Verify Checksums during Basebackups Tom Lane 14:29
Re: [PATCH] Verify Checksums during Basebackups Tom Lane 14:32
Re: [HACKERS] logical decoding of two-phase transactions Tomas Vondra 14:34
Re: PostgreSQL's handling of fsync() errors is unsafe and risks data loss at least on XFS Greg Stark 14:37
Re: [HACKERS] logical decoding of two-phase transactions Alvaro Herrera 14:37
Re: [HACKERS] logical decoding of two-phase transactions Tomas Vondra 14:38
Re: jsonb nesting level edge case Bruce Momjian 14:40
Re: [PATCH] Verify Checksums during Basebackups Magnus Hagander 14:42
Re: [HACKERS] logical decoding of two-phase transactions Tom Lane 14:55
Re: [HACKERS] logical decoding of two-phase transactions Tomas Vondra 14:59
Re: [HACKERS] logical decoding of two-phase transactions Nikhil Sontakke 15:15
Re: pgsql: New files for MERGE Andres Freund 15:32
Re: [HACKERS] GUC for cleanup indexes threshold. Masahiko Sawada 15:42
Re: Optimize Arm64 crc32c implementation in Postgresql Heikki Linnakangas 16:05
Re: Optimize Arm64 crc32c implementation in Postgresql Andres Freund 16:09
Re: Running Installcheck remotely Kapil Sharma 16:12
Re: Changing WAL Header to reduce contention during ReserveXLogInsertLocation() Andres Freund 16:20
Re: Optimize Arm64 crc32c implementation in Postgresql 📎 Heikki Linnakangas 16:38
Re: Optimize Arm64 crc32c implementation in Postgresql Andres Freund 16:43
Re: Prefix operator for text and spgist support Teodor Sigaev 16:50
Re: PostgreSQL's handling of fsync() errors is unsafe and risks data loss at least on XFS Anthony Iliopoulos 16:52
Re: pgsql: Validate page level checksums in base backups Andres Freund 17:13
Re: pgsql: Validate page level checksums in base backups Magnus Hagander 17:17
Re: BUG #15122: can't import data if table has a constraint with a function calling another function Bruce Momjian 17:23
Re: BRIN FSM vacuuming questions 📎 Tom Lane 17:39
Re: [HACKERS] Runtime Partition Pruning 📎 Jesper Pedersen 17:44
Re: Optimize Arm64 crc32c implementation in Postgresql Tom Lane 17:47
Re: [HACKERS] Runtime Partition Pruning Beena Emerson 17:50
Re: Comment update in BuildTupleFromCStrings() Bruce Momjian 18:01
Re: pgsql: Validate page level checksums in base backups Tom Lane 18:29
Re: pgsql: Validate page level checksums in base backups Peter Geoghegan 18:45
Re: pgsql: Validate page level checksums in base backups Magnus Hagander 18:48
Re: pgsql: Validate page level checksums in base backups Tom Lane 18:55
Re: Optimize Arm64 crc32c implementation in Postgresql Daniel Gustafsson 18:56
Re: Foreign keys and partitioned tables 📎 Alvaro Herrera 19:11
open/lseek overhead with many partitions (including with "faster partitioning pruning") Justin Pryzby 19:46
Re: WIP: BRIN multi-range indexes 📎 Tomas Vondra 19:50
Re: BUG #14999: pg_rewind corrupts control file global/pg_control TipTop Labs 20:13
Re: Foreign keys and partitioned tables Alvaro Herrera 20:47
Re: pgsql: Validate page level checksums in base backups 📎 Michael Banck 20:48
Re: pgsql: Validate page level checksums in base backups David Steele 21:17
Re: PostgreSQL's handling of fsync() errors is unsafe and risks data loss at least on XFS Robert Haas 21:47
Re: [HACKERS] path toward faster partition pruning David Rowley 21:47
Re: Foreign keys and partitioned tables Alvaro Herrera 21:49
Re: [HACKERS] logical decoding of two-phase transactions Andrew Dunstan 22:05
Re: Optimize Arm64 crc32c implementation in Postgresql Thomas Munro 22:07
Re: Online enabling of checksums 📎 Tomas Vondra 22:11
Re: [HACKERS] Restrict concurrent update/delete with UPDATE of partition key Andres Freund 23:01
Re: [HACKERS] path toward faster partition pruning David Rowley 23:22
Re: PostgreSQL's handling of fsync() errors is unsafe and risks data loss at least on XFS Thomas Munro 23:59

April 4, 2018

Thread Author Time
Re: open/lseek overhead with many partitions (including with "faster partitioning pruning") Amit Langote 00:26
Re: open/lseek overhead with many partitions (including with "faster partitioning pruning") David Rowley 00:27
Re: open/lseek overhead with many partitions (including with "faster partitioning pruning") Amit Langote 00:31

Browse Archives

Prev | Next