pgsql-hackers since 2019-02-04 04:50

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

Feb. 4, 2019

Thread	Author	Time
Re: has_table_privilege for a table in unprivileged schema causes an error	Michael Paquier	04:50
Re: [HACKERS] PATCH: multivariate histograms and MCV lists	Michael Paquier	04:53
Re: Undo logs	Michael Paquier	04:54
Re: [HACKERS] Transactions involving multiple postgres foreign servers, take 2	Michael Paquier	04:56
Re: jsonpath	Michael Paquier	04:57
RE: Protect syscache from bloating with negative cache entries	Tsunakawa, Takayuki	04:57
Re: Ordered Partitioned Table Scans	Michael Paquier	04:58
Re: WIP: Avoid creation of the free space map for small tables	Amit Kapila	04:59
Re: ATTACH/DETACH PARTITION CONCURRENTLY	David Rowley	05:02
Re: Reduce amount of WAL generated by CREATE INDEX for gist, gin and sp-gist	Michael Paquier	05:04
Re: [HACKERS] Two pass CheckDeadlock in contentent case	Michael Paquier	05:05
Re: proposal: plpgsql pragma statement	Michael Paquier	05:10
Re: [HACKERS] Support for Secure Transport SSL library on macOS as OpenSSL alternative	Michael Paquier	05:12
Re: Undo logs	Thomas Munro	05:14
Re: [HACKERS] logical decoding of two-phase transactions	Michael Paquier	05:15
Re: amcheck verification for GiST	Michael Paquier	05:16
Re: Undo logs	Dilip Kumar	05:17
Re: [HACKERS] Custom compression methods	Michael Paquier	05:26
Re: FETCH FIRST clause WITH TIES option	Michael Paquier	05:28
Re: [HACKERS] advanced partition matching algorithm for partition-wise join 📎	amul sul	05:35
Re: [PATCH] kNN for btree	Michael Paquier	05:35
What happens if checkpoint haven't completed until the next checkpoint interval or max_wal_size?	Mohammad Sherafat	05:36
Re: Tid scan improvements 📎	Edmund Horner	05:37
Re: Usage of epoch in txid_current	Michael Paquier	05:43
Re: Synchronous replay take III	Michael Paquier	05:46
Re: Usage of epoch in txid_current	Tom Lane	05:48
Re: PATCH: logical_work_mem and logical streaming of large in-progress transactions	Michael Paquier	05:51
Re: WIP: BRIN multi-range indexes	Michael Paquier	05:54
Re: [HACKERS] WIP: Aggregation push-down	Michael Paquier	06:03
Re: Conflict handling for COPY FROM	Michael Paquier	06:06
Re: Feature: temporary materialized views	Michael Paquier	06:09
Re: Statement-level rollback	Michael Paquier	06:13
Re: Flexible configuration for full-text search	Michael Paquier	06:15
Re: partitioned tables referenced by FKs	Michael Paquier	06:17
Re: [HACKERS] SERIALIZABLE on standby servers	Michael Paquier	06:19
Re: [HACKERS] Can ICU be used for a database's default sort order?	Michael Paquier	06:21
Re: Usage of epoch in txid_current	Andres Freund	06:21
Commit Fest 2019-01 is now closed	Michael Paquier	06:28
Re: Synchronous replay take III 📎	Thomas Munro	06:34
RE: Commit Fest 2019-01 is now closed	Tsunakawa, Takayuki	06:34
Re: WIP: Avoid creation of the free space map for small tables	Amit Kapila	07:40
Re: Usage of epoch in txid_current	Andres Freund	07:41
Re: dsa_allocate() faliure	Jakub Glapa	07:52
Re: Online verification of checksums 📎	Michael Banck	07:57
Re: dsa_allocate() faliure	Thomas Munro	08:22
RE: Protect syscache from bloating with negative cache entries	Tsunakawa, Takayuki	08:23
Re: WIP: Avoid creation of the free space map for small tables	John Naylor	08:57
Re: What happens if checkpoint haven't completed until the next checkpoint interval or max_wal_size?	Laurenz Albe	09:19
Re: pg_dump multi VALUES INSERT 📎	Surafel Temesgen	09:25
Re: Using POPCNT and other advanced bit manipulation instructions 📎	David Rowley	09:40
Re: [HACKERS] PATCH: multivariate histograms and MCV lists	Tomas Vondra	10:02
Re: WIP: BRIN multi-range indexes	Tomas Vondra	10:05
Re: WIP: BRIN multi-range indexes	Alvaro Herrera	10:13
Re: FETCH FIRST clause WITH TIES option 📎	Surafel Temesgen	10:37
Tighten up a few overly lax regexes in pg_dump's tap tests 📎	David Rowley	10:54
Allow some recovery parameters to be changed with reload 📎	Peter Eisentraut	10:58
Re: Prevent extension creation in temporary schemas	Chris Travers	11:54
Re: draft patch for strtof() 📎	Andrew Gierth	12:07
Re: Tighten up a few overly lax regexes in pg_dump's tap tests	Daniel Gustafsson	12:12
Re: ATTACH/DETACH PARTITION CONCURRENTLY	Robert Haas	12:54
Re: PATCH: logical_work_mem and logical streaming of large in-progress transactions	Alexey Kondratov	13:49
Re: Feature: temporary materialized views	Andreas Karlsson	15:10
Re: Log a sample of transactions	Adrien NAYRAT	15:32
Re: Too rigorous assert in reorderbuffer.c	Alexey Kondratov	16:15
propagating replica identity to partitions	Alvaro Herrera	16:30
Memory contexts reset for trigger invocations	Andres Freund	16:44
Re: propagating replica identity to partitions 📎	Alvaro Herrera	17:20
Re: proposal: plpgsql pragma statement 📎	Pavel Stehule	18:12
Re: propagating replica identity to partitions 📎	Alvaro Herrera	18:41
RE: dsa_allocate() faliure	Arne Roland	20:31
Re: New vacuum option to do only freezing	Bossart, Nathan	21:22
Re: dsa_allocate() faliure	Justin Pryzby	21:47
Re: Pre-v11 appearances of the word "procedure" in v11 docs 📎	Peter Eisentraut	22:02
Re: Protect syscache from bloating with negative cache entries	[email protected]	22:43
Re: [HACKERS] Removing [Merge]Append nodes which contain a single subpath 📎	David Rowley	23:05
Re: BUG #15572: Misleading message reported by "Drop function operation" on DB with functions having same name	David Rowley	23:14
Re: propagating replica identity to partitions 📎	Alvaro Herrera	23:53

Feb. 5, 2019

Thread	Author	Time
Re: Tighten up a few overly lax regexes in pg_dump's tap tests	Michael Paquier	00:15
Re: Tighten up a few overly lax regexes in pg_dump's tap tests	David Rowley	00:50
Re: Tighten up a few overly lax regexes in pg_dump's tap tests	Michael Paquier	01:41
RE: Protect syscache from bloating with negative cache entries	Tsunakawa, Takayuki	02:40
RE: Protect syscache from bloating with negative cache entries	Ideriha, Takeshi	02:43
Re: WIP: Avoid creation of the free space map for small tables	Amit Kapila	03:04
Re: [HACKERS] Block level parallel vacuum	Haribabu Kommi	03:14
Re: Reduce amount of WAL generated by CREATE INDEX for gist, gin and sp-gist 📎	Andrey Lepikhov	03:21
Re: Allow some recovery parameters to be changed with reload	Michael Paquier	03:35
Re: Log a sample of transactions	Michael Paquier	03:49
Re: Feature: temporary materialized views	Michael Paquier	03:59
Re: Inadequate executor locking of indexes 📎	David Rowley	04:15
Re: Tighten up a few overly lax regexes in pg_dump's tap tests 📎	David Rowley	04:46
Re: Tighten up a few overly lax regexes in pg_dump's tap tests	David Rowley	04:53
Re: Tighten up a few overly lax regexes in pg_dump's tap tests	David G. Johnston	05:55
Re: Online verification of checksums	Fabien COELHO	05:57
Re: Online verification of checksums	Andres Freund	07:01
Re: Memory contexts reset for trigger invocations	Haribabu Kommi	07:19
Re: Tighten up a few overly lax regexes in pg_dump's tap tests	Michael Paquier	07:26
Documentation and code don't agree about partitioned table UPDATEs 📎	David Rowley	08:44
Re: [HACKERS] WIP: Aggregation push-down 📎	Antonin Houska	09:40
Re: Performance issue in foreign-key-aware join estimation	David Rowley	09:43
Re: Performance issue in foreign-key-aware join estimation 📎	David Rowley	09:47
Re: WIP: Avoid creation of the free space map for small tables 📎	John Naylor	09:55
Re: Tighten up a few overly lax regexes in pg_dump's tap tests	Daniel Gustafsson	10:09
Re: Online verification of checksums	Tomas Vondra	10:30
Re: What happens if checkpoint haven't completed until the next checkpoint interval or max_wal_size?	Robert Haas	10:41
Re: Online verification of checksums	Michael Banck	11:29
Re: Feature: temporary materialized views	Michael Paquier	11:36
Re: What happens if checkpoint haven't completed until the next checkpoint interval or max_wal_size?	Michael Paquier	11:42
Internal error while setting reloption on system catalogs. 📎	Kyotaro HORIGUCHI	11:58
Re: What happens if checkpoint haven't completed until the next checkpoint interval or max_wal_size?	Kyotaro HORIGUCHI	12:30
Re: Ltree syntax improvement	Nikolay Shaplov	13:26
Re: Memory contexts reset for trigger invocations	Tom Lane	14:25
Re: Memory contexts reset for trigger invocations	Andres Freund	14:55
Re: Internal error while setting reloption on system catalogs.	Tom Lane	15:01
Re: fast defaults in heap_getattr vs heap_deform_tuple	Andrew Dunstan	15:14
Fix optimization of foreign-key on update actions 📎	Peter Eisentraut	15:36
Re: Fix optimization of foreign-key on update actions	Andrew Gierth	16:02
Re: Fix optimization of foreign-key on update actions	Tom Lane	16:20
Re: pg11.1: dsa_area could not attach to segment	Justin Pryzby	16:35
Re: Commit Fest 2019-01 is now closed	Bruce Momjian	16:35
Re: Commit Fest 2019-01 is now closed	Tom Lane	16:55
Re: fast defaults in heap_getattr vs heap_deform_tuple 📎	Andres Freund	16:57
Re: Commit Fest 2019-01 is now closed	Bruce Momjian	16:59
Re: Commit Fest 2019-01 is now closed	Tom Lane	17:02
Re: Commit Fest 2019-01 is now closed	Bruce Momjian	17:04
Re: Commit Fest 2019-01 is now closed	Andres Freund	17:08
Re: Commit Fest 2019-01 is now closed	Andres Freund	17:09
Re: Protect syscache from bloating with negative cache entries	Tomas Vondra	17:27
Re: Feature: temporary materialized views	Andreas Karlsson	17:56
Re: [HACKERS] Macros bundling RELKIND_* conditions 📎	Alvaro Herrera	18:12
Re: Protect syscache from bloating with negative cache entries	Tomas Vondra	18:20
Re: pg11.1: dsa_area could not attach to segment	Justin Pryzby	18:34
Re: Commit Fest 2019-01 is now closed	Peter Geoghegan	18:43
Re: Changing SQL Inlining Behaviour (or...?)	Paul Ramsey	18:49
Re: patch to allow disable of WAL recycling 📎	Jerry Jelinek	19:05
Re: Changing SQL Inlining Behaviour (or...?)	Tom Lane	19:07
Re: Changing SQL Inlining Behaviour (or...?)	Paul Ramsey	19:25
Re: Is zheap on track for PostgreSQL 12.0?	AJG	20:30
Re: Too rigorous assert in reorderbuffer.c	Alvaro Herrera	21:11
Re: Changing SQL Inlining Behaviour (or...?)	Tom Lane	21:20
Re: Fixing findDependentObjects()'s dependency on scan order (regressions in DROP diagnostic messages)	Alvaro Herrera	21:28
Bogus lateral-reference-propagation logic in create_lateral_join_info 📎	Tom Lane	21:56
Re: Protect syscache from bloating with negative cache entries	Alvaro Herrera	22:05
Re: Fixing findDependentObjects()'s dependency on scan order (regressions in DROP diagnostic messages)	Tom Lane	22:08
Re: Protect syscache from bloating with negative cache entries	Tomas Vondra	22:32
Re: Fixing findDependentObjects()'s dependency on scan order (regressions in DROP diagnostic messages)	Peter Geoghegan	22:50
Re: Synchronize with imath upstream	Alvaro Herrera	23:47

Feb. 6, 2019

Thread	Author	Time
Re: Internal error while setting reloption on system catalogs.	Kyotaro HORIGUCHI	00:09
Re: Libpq support to connect to standby server as priority	Haribabu Kommi	00:33
Re: Making all nbtree entries unique by having heap TIDs participate in comparisons	Peter Geoghegan	00:50
Re: [HACKERS] PATCH: multivariate histograms and MCV lists	Alvaro Herrera	01:21
Re: Bogus lateral-reference-propagation logic in create_lateral_join_info	David Rowley	01:26
Re: Refactoring IndexPath representation of index conditions	Alvaro Herrera	01:35
Re: fast defaults in heap_getattr vs heap_deform_tuple	Alvaro Herrera	01:44
Re: Don't deform column-by-column in composite_to_json	Alvaro Herrera	01:53
Re: bug tracking system	Alvaro Herrera	02:02
RE: speeding up planning with partitions 📎	Tsunakawa, Takayuki	02:03
Re: Undo logs	Alvaro Herrera	02:10
Re: pg11.1: dsa_area could not attach to segment	Justin Pryzby	02:10
Re: Feature: temporary materialized views	Andreas Karlsson	02:11
Add missing CREATE TABLE IF NOT EXISTS table_name AS EXECUTE query; 📎	Andreas Karlsson	02:20
Re: Bogus lateral-reference-propagation logic in create_lateral_join_info	Tom Lane	03:11
Re: Documentation and code don't agree about partitioned table UPDATEs 📎	Amit Kapila	03:20
Re: Fixing findDependentObjects()'s dependency on scan order (regressions in DROP diagnostic messages)	Tom Lane	03:21
Re: Non-deterministic IndexTuple toast compression from index_form_tuple() + amcheck false positives	Peter Geoghegan	03:49
Re: PostgreSQL vs SQL/XML Standards	Chapman Flack	04:16
Re: add_partial_path() may remove dominated path but still in use 📎	Kohei KaiGai	05:05
Re: pg11.1: dsa_area could not attach to segment	Thomas Munro	05:22
RE: Cache relation sizes?	Ideriha, Takeshi	05:32
Re: Protect syscache from bloating with negative cache entries 📎	Kyotaro HORIGUCHI	05:43
Re: Protect syscache from bloating with negative cache entries 📎	Kyotaro HORIGUCHI	06:17
RE: Cache relation sizes?	Tsunakawa, Takayuki	06:29
A separate table level option to control compression 📎	Pavan Deolasee	07:32
Re: Cache relation sizes?	Kyotaro HORIGUCHI	08:24
Re: Add pg_partition_root to get top-most parent of a partition tree	Amit Langote	08:26
RE: Cache relation sizes?	Tsunakawa, Takayuki	08:29
Re: Protect syscache from bloating with negative cache entries 📎	Kyotaro HORIGUCHI	08:37
Re: Tighten up a few overly lax regexes in pg_dump's tap tests	Michael Paquier	08:39
Re: Protect syscache from bloating with negative cache entries	Andres Freund	08:47
RE: Cache relation sizes?	Jamison, Kirk	08:50
Re: Cache relation sizes?	[email protected]	08:56
Re: Early WIP/PoC for inlining CTEs	Bruce Momjian	09:00
Re: Fix optimization of foreign-key on update actions	Laurenz Albe	09:11
Re: fast defaults in heap_getattr vs heap_deform_tuple	Andres Freund	09:17
Re: Feature: temporary materialized views 📎	Michael Paquier	09:18
Re: Too rigorous assert in reorderbuffer.c 📎	Arseny Sher	09:21
Re: pg11.1: dsa_area could not attach to segment	Thomas Munro	09:40
Re: Tighten up a few overly lax regexes in pg_dump's tap tests 📎	Daniel Gustafsson	09:50
Re: Bogus lateral-reference-propagation logic in create_lateral_join_info	Amit Langote	09:59
Re: Reduce amount of WAL generated by CREATE INDEX for gist, gin and sp-gist 📎	Andrey Lepikhov	10:08
Re: Add pg_partition_root to get top-most parent of a partition tree 📎	Michael Paquier	10:14
Re: fast defaults in heap_getattr vs heap_deform_tuple	Andrew Gierth	10:25
Re: Fix optimization of foreign-key on update actions	Andrew Gierth	11:23
Re: Documentation and code don't agree about partitioned table UPDATEs	David Rowley	11:26
Re: Tighten up a few overly lax regexes in pg_dump's tap tests	David Rowley	11:29
Re: Tighten up a few overly lax regexes in pg_dump's tap tests	Michael Paquier	11:37
Re: fast defaults in heap_getattr vs heap_deform_tuple	Andres Freund	11:39
Re: Add missing CREATE TABLE IF NOT EXISTS table_name AS EXECUTE query;	Michael Paquier	11:49
Re: BUG #15572: Misleading message reported by "Drop function operation" on DB with functions having same name 📎	David Rowley	12:17
Re: fast defaults in heap_getattr vs heap_deform_tuple	Christoph Berg	12:22
Re: Pluggable Storage - Andres's take 📎	Amit Khandekar	13:00

Browse Archives

Prev | Next