pgsql-hackers since 2019-02-20 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)

Advanced Search

Browse Archives

Prev | Next

Feb. 20, 2019

Thread	Author	Time
RE: Protect syscache from bloating with negative cache entries	Ideriha, Takeshi	00:02
ZRE: Protect syscache from bloating with negative cache entries	Tsunakawa, Takayuki	00:22
Using old master as new replica after clean switchover	RSR999GMAILCOM	00:27
RE: Protect syscache from bloating with negative cache entries	Tsunakawa, Takayuki	00:27
Re: Prepared transaction releasing locks before deregistering its GID	Michael Paquier	00:39
Re: Using old master as new replica after clean switchover	Michael Paquier	00:44
Re: CPU costs of random_zipfian in pgbench	Peter Geoghegan	00:48
Re: [PATCH] kNN for btree 📎	Nikita Glukhov	01:18
RE: SQL statement PREPARE does not work in ECPG	Takahashi, Ryohei	01:53
Re: Another way to fix inherited UPDATE/DELETE	Amit Langote	01:55
Re: Another way to fix inherited UPDATE/DELETE	Amit Langote	01:57
Re: BUG #15641: Autoprewarm worker fails to start on Windows with huge pages in use Old PostgreSQL community/pgsql-bugs x	Thomas Munro	02:21
Re: Reaping Temp tables to avoid XID wraparound	Michael Paquier	02:41
Re: Delay locking partitions during INSERT and UPDATE	Robert Haas	03:17
Re: Copy function for logical replication slots	Michael Paquier	03:26
Re: Compressed TOAST Slicing	Юрий Соколов	03:30
Re: Incorrect visibility test function assigned to snapshot	Michael Paquier	03:38
Re: Pluggable Storage - Andres's take 📎	Haribabu Kommi	03:39
Re: Pluggable Storage - Andres's take	Haribabu Kommi	03:44
Re: libpq debug log	Robert Haas	03:55
Re: Copy function for logical replication slots	Masahiko Sawada	04:00
Re: Protect syscache from bloating with negative cache entries 📎	Kyotaro HORIGUCHI	04:14
Re: pg_basebackup ignores the existing data directory permissions	Haribabu Kommi	04:16
Re: [PATCH] kNN for btree	Thomas Munro	04:35
Re: pg_basebackup ignores the existing data directory permissions	Michael Paquier	04:48
Re: Another way to fix inherited UPDATE/DELETE	Tom Lane	04:54
Re: Another way to fix inherited UPDATE/DELETE	Pavan Deolasee	05:11
Re: Another way to fix inherited UPDATE/DELETE	Tom Lane	05:21
RE: Speed up transaction completion faster after many relations are accessed in a transaction	Tsunakawa, Takayuki	05:42
Re: speeding up planning with partitions	Amit Langote	05:47
Re: BUG #15572: Misleading message reported by "Drop function operation" on DB with functions having same name	Michael Paquier	05:56
RE: Timeout parameters	Jamison, Kirk	06:04
Re: [PATCH][PROPOSAL] Add enum releation option type	Michael Paquier	06:08
RE: Speeding up creating UPDATE/DELETE generic plan for partitioned table into a lot	Kato, Sho	06:11
Re: Prepared transaction releasing locks before deregistering its GID	Masahiko Sawada	06:14
RE: Speed up transaction completion faster after many relations are accessed in a transaction 📎	Tsunakawa, Takayuki	06:20
Re: [PATCH][PROPOSAL] Add enum releation option type	Nikolay Shaplov	06:38
Re: shared-memory based stats collector	Kyotaro HORIGUCHI	06:45
Re: Row Level Security − leakproof-ness and performance implications	Pierre Ducroquet	07:14
Re: Another way to fix inherited UPDATE/DELETE	Amit Langote	07:37
Re: Prepared transaction releasing locks before deregistering its GID 📎	Michael Paquier	08:22
Re: BUG #15572: Misleading message reported by "Drop function operation" on DB with functions having same name 📎	David Rowley	08:34
Re: Compressed TOAST Slicing	Simon Riggs	08:39
Re: pg_basebackup ignores the existing data directory permissions	Magnus Hagander	08:40
Re: Ltree syntax improvement	Nikolay Shaplov	09:28
Re: [PATCH v20] GSSAPI encryption support	Peter Eisentraut	10:15
Re: [HACKERS] Time to change pg_regress diffs to unified by default?	Peter Eisentraut	10:20
Re: [HACKERS] Time to change pg_regress diffs to unified by default?	Peter Eisentraut	10:22
RE: SQL statement PREPARE does not work in ECPG	Matsumura, Ryo	10:40
Re: Prepared transaction releasing locks before deregistering its GID	Oleksii Kliukin	10:50
Re: Another way to fix inherited UPDATE/DELETE	Etsuro Fujita	10:50
Re: restrict pg_stat_ssl to superuser? 📎	Peter Eisentraut	10:51
bgwriter_lru_maxpages limits in PG 10 sample conf 📎	Sergei Kornilov	10:53
Re: WIP: Avoid creation of the free space map for small tables 📎	Amit Kapila	11:09
Re: WIP: Avoid creation of the free space map for small tables	John Naylor	11:34
Re: Referential Integrity Checks with Statement-level Triggers	Antonin Houska	11:38
Re: SQL statement PREPARE does not work in ECPG	Michael Meskes	11:41
Re: SQL statement PREPARE does not work in ECPG 📎	Michael Meskes	11:47
Re: [HACKERS] Time to change pg_regress diffs to unified by default?	Christoph Berg	11:47
Re: [Patch] pg_rewind: options to use restore_command from recovery.conf or command line 📎	Alexey Kondratov	12:06
Re: SQL statement PREPARE does not work in ECPG	Michael Meskes	12:17
Re: Problems with plan estimates in postgres_fdw 📎	Etsuro Fujita	12:25
Re: 2019-03 CF Summary / Review - Tranche #2	Etsuro Fujita	12:30
Re: [PATCH] kNN for btree 📎	Nikita Glukhov	12:44
Re: WIP: Avoid creation of the free space map for small tables 📎	Amit Kapila	12:55
Re: Conflict handling for COPY FROM 📎	Surafel Temesgen	13:01
Re: 2019-03 CF Summary / Review - Tranche #2	Alexey Kondratov	13:23
Re: Conflict handling for COPY FROM	Andrew Dunstan	14:05
Re: crash in pg_identify_object_as_address	Alvaro Herrera	14:27
Unnecessary checks for new rows by some RI trigger functions?	Antonin Houska	14:29
Re: [PROPOSAL] Shared Ispell dictionaries 📎	Arthur Zakirov	14:33
Re: WIP: Avoid creation of the free space map for small tables	Alvaro Herrera	14:38
Remove unnecessary use of PROCEDURAL 📎	Peter Eisentraut	14:39
Re: Row Level Security − leakproof-ness and performance implications	Joe Conway	14:46
Re: [PATCH] kNN for btree 📎	Nikita Glukhov	14:46
Re: Another way to fix inherited UPDATE/DELETE	Tom Lane	15:06
Re: Another way to fix inherited UPDATE/DELETE	Tom Lane	15:14
list append syntax for postgresql.conf	Peter Eisentraut	15:15
Re: list append syntax for postgresql.conf	Euler Taveira	15:35
Re: list append syntax for postgresql.conf	Christoph Berg	15:37
Re: Delay locking partitions during INSERT and UPDATE	Robert Haas	15:42
Re: speeding up planning with partitions	Tom Lane	15:50
Re: list append syntax for postgresql.conf	Joe Conway	15:54
Re: list append syntax for postgresql.conf	David G. Johnston	15:59
Re: Delay locking partitions during INSERT and UPDATE	Tom Lane	16:03
Re: Conflict handling for COPY FROM	Andres Freund	16:03
Re: propagating replica identity to partitions	Robert Haas	16:09
BUG #15646: Inconsistent behavior for current_setting/set_config	PG Bug reporting form	16:10
Re: list append syntax for postgresql.conf	Chapman Flack	16:16
AW: BUG #15641: Autoprewarm worker fails to start on Windows with huge pages in use Old PostgreSQL community/pgsql-bugs x	Hans Buschmann	16:17
Re: Row Level Security − leakproof-ness and performance implications	Tom Lane	16:24
Re: Delay locking partitions during INSERT and UPDATE	Robert Haas	16:24
Re: Compressed TOAST Slicing	Andres Freund	16:27
Re: Index Skip Scan 📎	Dmitry Dolgov	16:35
Re: list append syntax for postgresql.conf	Tom Lane	16:42
Re: BUG #15646: Inconsistent behavior for current_setting/set_config	Joe Conway	17:01
Re: BUG #15646: Inconsistent behavior for current_setting/set_config	Tom Lane	17:11
Re: BUG #15646: Inconsistent behavior for current_setting/set_config	David G. Johnston	17:32
Re: propagating replica identity to partitions	Alvaro Herrera	17:38
Re: BUG #15646: Inconsistent behavior for current_setting/set_config	Jerry Sievert	18:06
Re: Protect syscache from bloating with negative cache entries	Robert Haas	18:09
Re: Compressed TOAST Slicing	Robert Haas	18:15
Re: propagating replica identity to partitions	Simon Riggs	18:31
Re: Compressed TOAST Slicing	Simon Riggs	18:37
Re: Compressed TOAST Slicing	Paul Ramsey	18:45
Re: Compressed TOAST Slicing	Daniel Verite	18:50
Re: Compressed TOAST Slicing	Robert Haas	18:50
Re: propagating replica identity to partitions	Robert Haas	18:51
Re: BUG #15646: Inconsistent behavior for current_setting/set_config	Joe Conway	18:51
Re: Compressed TOAST Slicing	Paul Ramsey	18:55
BRIN summarize autovac_report_workitem passes datname as relname	Justin Pryzby	18:55
Re: Compressed TOAST Slicing	Daniel Verite	19:12
Re: bgwriter_lru_maxpages limits in PG 10 sample conf	Robert Haas	19:35
Re: Proving IS NOT NULL inference for ScalarArrayOpExpr's	Tom Lane	19:41
Re: Compressed TOAST Slicing	Tom Lane	19:50
Re: Compressed TOAST Slicing	Tomas Vondra	19:52
Re: BUG #15572: Misleading message reported by "Drop function operation" on DB with functions having same name	Tom Lane	20:36
Re: bgwriter_lru_maxpages limits in PG 10 sample conf	Sergei Kornilov	20:54
Re: Delay locking partitions during INSERT and UPDATE	Tom Lane	20:57
Re: Compressed TOAST Slicing	Stephen Frost	21:12
Re: Problems with plan estimates in postgres_fdw 📎	Jeff Janes	21:19
Re: BRIN summarize autovac_report_workitem passes datname as relname	Euler Taveira	21:19
Re: libpq host/hostaddr/conninfo inconsistencies 📎	Robert Haas	21:27
Re: Delay locking partitions during INSERT and UPDATE	Robert Haas	21:32
Re: BUG #15641: Autoprewarm worker fails to start on Windows with huge pages in use Old PostgreSQL community/pgsql-bugs x	Thomas Munro	21:41
Re: WAL insert delay settings	Stephen Frost	21:43
Re: Delay locking partitions during INSERT and UPDATE 📎	David Rowley	21:56
[patch] Add schema total size to psql \dn+ 📎	Gilles Darold	22:26
Re: Pluggable Storage - Andres's take	Robert Haas	22:46
Journal based VACUUM FULL	Ryan David Sheasby	23:16
Re: Refactoring the checkpointer's fsync request queue 📎	Shawn Debnath	23:27
Re: WAL insert delay settings	Tomas Vondra	23:35
NOT IN subquery optimization	Jim Finnerty	23:44
Re: WAL insert delay settings	Stephen Frost	23:46
Re: Refactoring the checkpointer's fsync request queue	Andres Freund	23:50
Re: WAL insert delay settings	Andres Freund	23:54
Re: ToDo: show size of partitioned table 📎	Justin Pryzby	23:56

Feb. 21, 2019

Thread	Author	Time
Re: Ryu floating point output patch	Andrew Gierth	00:10
Re: WAL insert delay settings	Stephen Frost	00:20
Re: Set fallback_application_name for a walreceiver to cluster_name	Euler Taveira	00:36
Re: propagating replica identity to partitions	Simon Riggs	00:37
Re: NOT IN subquery optimization	Tom Lane	00:40
Re: amcheck verification for GiST	Peter Geoghegan	00:56
Re: libpq host/hostaddr/conninfo inconsistencies	Tom Lane	01:12
Re: Delay locking partitions during INSERT and UPDATE	Tom Lane	01:18
Re: BUG #15572: Misleading message reported by "Drop function operation" on DB with functions having same name	David Rowley	01:29
Re: NOT IN subquery optimization	Jim Finnerty	01:53
Re: Performance issue in foreign-key-aware join estimation 📎	Tom Lane	02:00
Re: Performance issue in foreign-key-aware join estimation	David Rowley	02:05
Re: NOT IN subquery optimization	Tom Lane	02:11
Re: insensitive collations	Peter Geoghegan	02:17
Re: proposal: variadic argument support for least, greatest function	Chapman Flack	02:19
Re: speeding up planning with partitions	Amit Langote	02:31
Re: NOT IN subquery optimization	Jim Finnerty	03:27
Re: Refactoring the checkpointer's fsync request queue	Thomas Munro	03:28
Re: Another way to fix inherited UPDATE/DELETE	Etsuro Fujita	03:50
Re: WIP: Avoid creation of the free space map for small tables	Amit Kapila	03:55
Re: WIP: Avoid creation of the free space map for small tables	Alvaro Herrera	04:35
Vectors instead of lists, specialised qsort(), binary_search(), unique() 📎	Thomas Munro	05:02
RE: SQL statement PREPARE does not work in ECPG	Takahashi, Ryohei	05:41
RE: Protect syscache from bloating with negative cache entries	Ideriha, Takeshi	05:41
Re: Prepared transaction releasing locks before deregistering its GID 📎	Michael Paquier	05:54
RE: Timeout parameters	Tsunakawa, Takayuki	05:55
COPY FREEZE and setting PD_ALL_VISIBLE/visibility map bits 📎	Pavan Deolasee	06:05
Re: [HACKERS] COPY FREEZE and PD_ALL_VISIBLE	Pavan Deolasee	06:07
RE: Protect syscache from bloating with negative cache entries	Tsunakawa, Takayuki	06:11
Re: Vectors instead of lists, specialised qsort(), binary_search(), unique()	David Rowley	06:26
RE: Protect syscache from bloating with negative cache entries	Tsunakawa, Takayuki	06:37
RE: Timeout parameters	Nagaura, Ryohei	06:51
Re: WIP: Avoid creation of the free space map for small tables 📎	Amit Kapila	06:58
Re: shared-memory based stats collector 📎	Kyotaro HORIGUCHI	07:05
RE: Timeout parameters	Tsunakawa, Takayuki	07:09
Re: WIP: Avoid creation of the free space map for small tables	John Naylor	07:26
Re: Cache lookup errors with functions manipulation object addresses 📎	Michael Paquier	07:40
RE: Timeout parameters	Nagaura, Ryohei	07:43
Re: libpq host/hostaddr/conninfo inconsistencies	Michael Paquier	07:47
RE: Timeout parameters	Tsunakawa, Takayuki	07:56
RE: libpq debug log 📎	Iwata, Aya	07:56
RE: libpq debug log	Iwata, Aya	08:11
Re: restrict pg_stat_ssl to superuser?	Michael Paquier	08:11
RE: Timeout parameters	Jamison, Kirk	08:20
Re: insensitive collations	Peter Eisentraut	08:36
[PATCH] Allow transaction to partition table using FDW 📎	mitani	08:44
Re: SQL statement PREPARE does not work in ECPG	Michael Meskes	09:02
Re: WAL insert delay settings	Ants Aasma	09:06
Inappropriate scope of local variable	Antonin Houska	09:08
AW: BUG #15641: Autoprewarm worker fails to start on Windows with huge pages in use Old PostgreSQL community/pgsql-bugs x	Hans Buschmann	09:21
Solaris 10 (sparc) and unixODBC problem	Nariman Ibadullaev	09:30
Re: Reporting script runtimes in pg_regress 📎	Christoph Berg	09:37
Re: [patch] Add schema total size to psql \dn+ 📎	Gilles Darold	10:49
Re: WAL insert delay settings	Stephen Frost	10:50
Re: [patch] Add schema total size to psql \dn+	Julien Rouhaud	11:01
Re: Pluggable Storage - Andres's take	Amit Khandekar	11:43
Re: Pluggable Storage - Andres's take	Robert Haas	12:35
Re: [PROPOSAL] Shared Ispell dictionaries	Robert Haas	12:45
Re: BUG #15641: Autoprewarm worker fails to start on Windows with huge pages in use Old PostgreSQL community/pgsql-bugs x	Mithun Cy	12:53
Re: BUG #15641: Autoprewarm worker fails to start on Windows with huge pages in use Old PostgreSQL community/pgsql-bugs x	Mithun Cy	12:58
Re: Unnecessary checks for new rows by some RI trigger functions?	Robert Haas	13:00
Re: WAL insert delay settings	Ants Aasma	13:06
Re: [PROPOSAL] Shared Ispell dictionaries	Arthur Zakirov	13:28

Browse Archives

Prev | Next