pgsql-hackers since 2024-12-06 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

Dec. 6, 2024

Thread	Author	Time
Re: 64 bit numbers vs format strings	Melanie Plageman	00:15
Re: Count and log pages set all-frozen by vacuum 📎	Melanie Plageman	00:32
Re: 64 bit numbers vs format strings	Thomas Munro	00:39
Re: Remove dependence on integer wrapping	Joseph Koshakow	01:00
Re: Assert failure on running a completed portal again 📎	Tom Lane	01:09
Re: attndims, typndims still not enforced, but make the value within a sane threshold 📎	jian he	02:22
Re: MinGW compiler warnings in ecpg tests	Thomas Munro	02:44
Re: Sort functions with specialized comparators	John Naylor	03:49
Re: Remove dependence on integer wrapping 📎	Nathan Bossart	03:58
Re: Why we need to check for local buffers in BufferIsExclusiveLocked and BufferIsDirty? 📎	Srinath Reddy Sadipiralla	04:03
Re: Introduce XID age and inactive timeout based replication slot invalidation	vignesh C	05:34
Re: Use streaming read API in pgstattuple. 📎	Kirill Reshke	05:40
Re: Disallow UPDATE/DELETE on table with unpublished generated column as REPLICA IDENTITY 📎	Shlok Kyal	05:40
Popcount optimization using SVE for ARM 📎	Devanga.Susmitha@fujitsu.com	05:54
Re: Windows pg_basebackup unable to create >2GB pg_wal.tar tarballs ("could not close file: Invalid argument" when creating pg_wal.tar of size ~ 2^31 bytes) 📎	Thomas Munro	06:01
Re: Parallel heap vacuum	Peter Smith	06:16
Re: Considering fractional paths in Append node	Andrei Lepikhov	06:48
Re: confusing / inefficient "need_transcoding" handling in copy	Sutou Kouhei	07:20
Re: Popcount optimization using SVE for ARM	Kirill Reshke	07:22
Re: Use streaming read API in pgstattuple.	Kirill Reshke	07:30
RE: Conflict detection for update_deleted in logical replication 📎	Zhijie Hou (Fujitsu)	07:58
Re: Considering fractional paths in Append node 📎	Andrei Lepikhov	08:13
Re: generic plans and "initial" pruning 📎	Amit Langote	08:18
RE: Memory leak in WAL sender with pgoutput (v10~) 📎	Zhijie Hou (Fujitsu)	08:23
RE: Memory leak in WAL sender with pgoutput (v10~)	Zhijie Hou (Fujitsu)	08:23
Re: generic plans and "initial" pruning	Amit Langote	08:26
refactor AlterDomainAddConstraint (alter domain add constraint) 📎	jian he	08:31
Fix tiny memory leaks 📎	Tofig Aliev	08:38
Re: Pass ParseState as down to utility functions. 📎	jian he	08:41
Re: Fix tiny memory leaks	Daniel Gustafsson	08:49
Re: NOT ENFORCED constraint feature	Amul Sul	09:13
logical replication: patch to ensure timely cleanup of aborted transactions in ReorderBuffer 📎	Vaijayanti Bharadwaj	09:20
Re: Popcount optimization using SVE for ARM	Devanga.Susmitha@fujitsu.com	09:29
Re: Track the amount of time waiting due to cost_delay 📎	Bertrand Drouvot	09:31
Re: Popcount optimization using SVE for ARM	Kirill Reshke	09:41
Re: Make pg_stat_io view count IOs as bytes instead of blocks 📎	Nazir Bilal Yavuz	09:41
[BUG] temp_table_max_size parameter may entail an error within ReadBuffer function 📎	Daniil Davydov	09:54
Re: postgres_fdw: Provide better emulation of READ COMMITTED behavior	Andy Fan	10:50
Re: Why we need to check for local buffers in BufferIsExclusiveLocked and BufferIsDirty?	Nazir Bilal Yavuz	11:10
Re: 64 bit numbers vs format strings	Alvaro Herrera	12:13
Re: logical replication: patch to ensure timely cleanup of aborted transactions in ReorderBuffer	Ashutosh Bapat	12:49
Re: Proposal to add a new URL data type.	Alexander Borisov	12:59
Re: why there is not VACUUM FULL CONCURRENTLY? 📎	Alvaro Herrera	13:46
Re: Proposal to add a new URL data type.	Daniel Gustafsson	13:46
Re: Pass ParseState as down to utility functions.	Alvaro Herrera	14:01
Re: refactor AlterDomainAddConstraint (alter domain add constraint)	Alvaro Herrera	14:48
Re: Popcount optimization using SVE for ARM	Nathan Bossart	15:39
Re: Potential null pointer dereference in postgres.c 📎	Maxim Orlov	15:52
Re: refactor AlterDomainAddConstraint (alter domain add constraint) 📎	jian he	16:01
Re: Remove dependence on integer wrapping 📎	Nathan Bossart	16:22
Re: Proposal to Enable/Disable Index using ALTER INDEX (with patch) 📎	Shayon Mukherjee	16:24
Re: meson missing test dependencies	Peter Eisentraut	17:54
Re: Proposal to add a new URL data type.	Alexander Borisov	17:55
Re: Proposal to add a new URL data type.	Matthias van de Meent	18:04
Unable to Recover a Deleted Database Using PITR	Scott Taylor	18:26
Support for unsigned integer types	Jack Bay	18:45
Re: Giving the shared catalogues a defined encoding	Tom Lane	18:51
Re: Remove dependence on integer wrapping 📎	Nathan Bossart	20:12

Dec. 7, 2024

Thread	Author	Time
inconsistent use of SearchSysCacheCopy	Jeff Davis	00:31
Re: Statistics Import and Export 📎	Jeff Davis	00:44
Re: Using Expanded Objects other than Arrays from plpgsql	Michel Pelletier	00:51
Re: proposal: schema variables	jian he	02:13
Re: Windows pg_basebackup unable to create >2GB pg_wal.tar tarballs ("could not close file: Invalid argument" when creating pg_wal.tar of size ~ 2^31 bytes) 📎	Davinder Singh	07:42
Re: Why we need to check for local buffers in BufferIsExclusiveLocked and BufferIsDirty?	Srinath Reddy Sadipiralla	08:17
RE: Proposal for Updating CRC32C with AVX-512 Algorithm. 📎	Devulapalli, Raghuveer	08:42
Re: postgres_fdw: Provide better emulation of READ COMMITTED behavior	Etsuro Fujita	09:02
Re: postgres_fdw: Provide better emulation of READ COMMITTED behavior	Etsuro Fujita	09:12
Re: shared-memory based stats collector - v70 📎	Anton A. Melnikov	09:31
Re: clean up create|alter domain stmt incompatiable constraint error case and add regression test	Kirill Reshke	10:14
Error with DEFAULT VALUE in temp table	Антуан Виолин	11:38
Re: doc: Remove LC_COLLATE and LC_CTYPE from SHOW command	Peter Eisentraut	12:07
Add a warning message when using unencrypted passwords 📎	Guillaume Lelarge	14:39
RE: Proposal for Updating CRC32C with AVX-512 Algorithm.	Devulapalli, Raghuveer	15:16
Re: Support for unsigned integer types	Tom Lane	16:24
Re: Support for unsigned integer types	Jack Bay	16:51
Do not scan index in right table if condition for left join evaluates to false using columns in left table	Илья Жарков	18:30
Re: Statistics Import and Export	Jeff Davis	19:27
Re: SQL:2011 application time 📎	Paul Jungwirth	19:29
Re: Statistics Import and Export	Corey Huinker	19:56
Re: meson missing test dependencies 📎	Andres Freund	20:45
Re: Statistics Import and Export	Jeff Davis	21:27
Re: Do not scan index in right table if condition for left join evaluates to false using columns in left table	Andres Freund	21:37
Re: [PATCH] Fixed creation of empty .log files during log rotation	Tomas Vondra	22:06
Re: Do not scan index in right table if condition for left join evaluates to false using columns in left table	Tom Lane	22:06
Re: Do not scan index in right table if condition for left join evaluates to false using columns in left table	Andres Freund	22:21
Re: Add missing tab completion for ALTER TABLE ADD COLUMN IF NOT EXISTS	Tomas Vondra	22:35
Re: [PATCH] immediately kill psql process if server is not running.	Tomas Vondra	23:01
Re: Do not scan index in right table if condition for left join evaluates to false using columns in left table	Илья Жарков	23:04
Re: Improved psql tab completion for joins	Tomas Vondra	23:06
Re: Do not scan index in right table if condition for left join evaluates to false using columns in left table	Andres Freund	23:07
Re: Do not scan index in right table if condition for left join evaluates to false using columns in left table	Tom Lane	23:13
Re: CREATE SUBSCRIPTION - add missing test case	Tomas Vondra	23:57

Dec. 8, 2024

Thread	Author	Time
Re: [PATCH] Add roman support for to_number function	Tomas Vondra	00:36
Re: Do not scan index in right table if condition for left join evaluates to false using columns in left table 📎	Andrei Lepikhov	02:23
Re: Do not scan index in right table if condition for left join evaluates to false using columns in left table	Andres Freund	02:52
Re: Do not scan index in right table if condition for left join evaluates to false using columns in left table	Tom Lane	03:11
Re: postgres_fdw: Provide better emulation of READ COMMITTED behavior	Andy Fan	03:23
Fix early elog(FATAL) 📎	Noah Misch	03:46
Re: Add missing tab completion for ALTER TABLE ADD COLUMN IF NOT EXISTS 📎	Kirill Reshke	04:22
Re: Trim the heap free memory	Tomas Vondra	04:23
Re: Using Expanded Objects other than Arrays from plpgsql	Michel Pelletier	07:05
Re: Do not scan index in right table if condition for left join evaluates to false using columns in left table	Andrei Lepikhov	08:44
Exposing index AM properties at SQL level	Egor Rogov	12:51
Re: Why we need to check for local buffers in BufferIsExclusiveLocked and BufferIsDirty?	Nazir Bilal Yavuz	12:53
Re: [PATCH] Support Int64 GUCs	Evgeny	14:11
Re: [PATCH] Support Int64 GUCs 📎	Evgeny Voropaev	14:16
Re: Logical Replication of sequences 📎	vignesh C	14:27
Re: [PATCH] Fix jsonb comparison for raw scalar pseudo arrays 📎	Andrew Dunstan	14:57
Re: Do not scan index in right table if condition for left join evaluates to false using columns in left table	Илья Жарков	15:24
Re: Do not scan index in right table if condition for left join evaluates to false using columns in left table	Andres Freund	16:37
Re: Add 64-bit XIDs into PostgreSQL 15 📎	Evgeny	17:17
Re: proposal: schema variables 📎	Pavel Stehule	18:32
Re: Trim the heap free memory	Tomas Vondra	18:48
Re: Assert failure on running a completed portal again 📎	Tom Lane	19:25
Re: Add a warning message when using unencrypted passwords	Jelte Fennema-Nio	22:08
Re: Giving the shared catalogues a defined encoding	Thomas Munro	22:09
Re: Refactoring postmaster's code to cleanup after child exit	Tomas Vondra	23:12

Dec. 9, 2024

Thread	Author	Time
Re: Proper object locking for GRANT/REVOKE	Noah Misch	01:25
Re: [Bug] Heap Use After Free in Window Aggregate Execution	David Rowley	01:28
Re: Missing LWLock protection in pgstat_reset_replslot()	Michael Paquier	01:48
Re: Do not scan index in right table if condition for left join evaluates to false using columns in left table	Andrei Lepikhov	02:35
Re: Parallel heap vacuum	Peter Smith	03:19
Re: Why we need to check for local buffers in BufferIsExclusiveLocked and BufferIsDirty?	Srinath Reddy Sadipiralla	04:44
Re: Disallow UPDATE/DELETE on table with unpublished generated column as REPLICA IDENTITY	Amit Kapila	04:50
Re: Why we need to check for local buffers in BufferIsExclusiveLocked and BufferIsDirty?	Srinath Reddy Sadipiralla	05:09
Fwd: Re: Why we need to check for local buffers in BufferIsExclusiveLocked and BufferIsDirty?	Srinath Reddy Sadipiralla	05:10
Re: Add a warning message when using unencrypted passwords	Andrei Lepikhov	05:29
Re: Popcount optimization using SVE for ARM	Devanga.Susmitha@fujitsu.com	05:34
Re: shared-memory based stats collector - v70	Michael Paquier	05:39
Re: Removing unneeded self joins	Alexander Korotkov	06:03
Re: [PATCH] Add roman support for to_number function	Hunaid Sohail	06:09
Re: proposal: schema variables	jian he	06:16
Re: [PATCH] SVE popcount support 📎	Devanga.Susmitha@fujitsu.com	06:21
Re: BitmapHeapScan streaming read user and prelim refactoring	Dilip Kumar	06:22
Re: add support for the old naming libs convention on windows (ssleay32.lib and libeay32.lib)	Darek Ślusarczyk	06:25
Re: Add SPLIT PARTITION/MERGE PARTITIONS commands	Alexander Korotkov	06:36
Re: generic plans and "initial" pruning 📎	Amit Langote	07:10
remove pgrminclude? 📎	Peter Eisentraut	07:14
Re: Assert failure on running a completed portal again	Yugo NAGATA	07:20
FileFallocate misbehaving on XFS	Michael Harris	07:34
Re: Memory leak in WAL sender with pgoutput (v10~)	Michael Paquier	07:43
Re: Pass ParseState as down to utility functions. 📎	Kirill Reshke	07:50
Incorrect EXPLAIN ANALYZE output in bloom index docs 📎	David Rowley	07:53
Re: shared-memory based stats collector - v70	Bertrand Drouvot	08:03
Re: refactor AlterDomainAddConstraint (alter domain add constraint) 📎	jian he	08:41
Re: [PATCH] Fix jsonb comparison for raw scalar pseudo arrays	jian he	08:56
Re: Track the amount of time waiting due to cost_delay	Masahiro Ikeda	09:21
Re: FileFallocate misbehaving on XFS	Andrea Gelmini	09:47
Re: Conflict detection for update_deleted in logical replication 📎	Nisha Moond	09:50
Re: FileFallocate misbehaving on XFS	Tomas Vondra	10:06
Re: Memory leak in WAL sender with pgoutput (v10~)	Amit Kapila	10:06
Re: NOT ENFORCED constraint feature 📎	Amul Sul	10:11
Re: fixing tsearch locale support 📎	Peter Eisentraut	10:11
Re: FileFallocate misbehaving on XFS	Tomas Vondra	10:14
WARNING: missing lock on database "postgres" (OID 5) @ TID (0,4)	Alexander Kukushkin	10:27
Re: FileFallocate misbehaving on XFS	Jakub Wartak	10:27
Re: Conflict detection for update_deleted in logical replication	Amit Kapila	10:32
Re: doc: Mention clock synchronization recommendation for hot_standby_feedback	Jakub Wartak	10:52
Adding a '--two-phase' option to 'pg_createsubscriber' utility. 📎	Shubham Khanna	10:54
Re: Proposal for Updating CRC32C with AVX-512 Algorithm.	John Naylor	11:39
Re: Track the amount of time waiting due to cost_delay	Dilip Kumar	11:48
Re: WARNING: missing lock on database "postgres" (OID 5) @ TID (0,4) 📎	Kirill Reshke	11:50
Re: Wrong results with right-semi-joins	Richard Guo	12:17
Re: An inefficient query caused by unnecessary PlaceHolderVar	Richard Guo	12:20
Re: Replace current implementations in crypt() and gen_salt() to OpenSSL 📎	Daniel Gustafsson	12:23
Re: Refactoring postmaster's code to cleanup after child exit	Heikki Linnakangas	12:30
Re: Refactoring postmaster's code to cleanup after child exit 📎	Tomas Vondra	12:47
Re: Sort functions with specialized comparators 📎	Andrey M. Borodin	13:02
Define STATS_MIN_ROWS for minimum rows of stats in ANALYZE 📎	Ilia Evdokimov	13:10
Subscription sometimes loses txns after initial table sync 📎	Pritam Baral	13:20
Re: [PATCH] Fix jsonb comparison for raw scalar pseudo arrays 📎	Yan Chengpeng	13:22
Re: Track the amount of time waiting due to cost_delay	Bertrand Drouvot	13:25
Re: Add a warning message when using unencrypted passwords	Greg Sabino Mullane	13:26
Re: [PATCH] Fix jsonb comparison for raw scalar pseudo arrays 📎	Yan Chengpeng	13:27
Re: Giving the shared catalogues a defined encoding	Thomas Munro	13:29
Re: Converting README documentation to Markdown 📎	Daniel Gustafsson	13:35
Re: Proposal to add a new URL data type.	Alexander Borisov	13:39
Re: Add a warning message when using unencrypted passwords	Daniel Gustafsson	13:40
Re: Wrong results with right-semi-joins	Melanie Plageman	14:01
Re: Replace current implementations in crypt() and gen_salt() to OpenSSL	Joe Conway	14:11
Re: Adding a '--two-phase' option to 'pg_createsubscriber' utility.	vignesh C	14:13
IWYU annotations 📎	Peter Eisentraut	14:35
Re: FileFallocate misbehaving on XFS	Tomas Vondra	14:47
Re: Add a warning message when using unencrypted passwords	Guillaume Lelarge	14:58
Re: Track the amount of time waiting due to cost_delay	Dilip Kumar	15:04
Re: meson missing test dependencies	Peter Eisentraut	15:06
Re: meson missing test dependencies	Andres Freund	15:42
some Page/PageData const stuff 📎	Peter Eisentraut	15:44
Re: Document NULL	David G. Johnston	15:56
Re: Document NULL	David G. Johnston	16:01
Re: NOT ENFORCED constraint feature	jian he	16:10
Re: FileFallocate misbehaving on XFS	Andres Freund	16:15
Re: [PATCH] Fix jsonb comparison for raw scalar pseudo arrays 📎	jian he	16:16
Re: Document NULL	David G. Johnston	16:31
Re: FileFallocate misbehaving on XFS	Andres Freund	16:31
Re: [PATCH] SVE popcount support 📎	Malladi, Rama	16:36
Re: IWYU annotations	Tom Lane	16:37
Re: Track the amount of time waiting due to cost_delay 📎	Bertrand Drouvot	16:41
Re: proposal: schema variables	Pavel Stehule	16:54
Re: [PATCH] Add sortsupport for range types and btree_gist 📎	Bernd Helmle	17:10

Browse Archives

Prev | Next