pgsql-hackers before 2018-09-01 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

Aug. 30, 2018

Thread	Author	Time
Fix comments of IndexInfo 📎	Yugo Nagata	04:48
Re: Use C99 designated initializers for some structs	Andres Freund	04:55
Re: Use C99 designated initializers for some structs	Andres Freund	04:57
Re: A strange GiST error message or fillfactor of GiST build 📎	Kyotaro HORIGUCHI	05:42
Re: pg_verify_checksums failure with hash indexes	Kyotaro HORIGUCHI	06:01
Re: Fix comments of IndexInfo	Heikki Linnakangas	06:14
Re: Fix comments of IndexInfo	Yugo Nagata	06:18
Re: pg_verify_checksums failure with hash indexes	Yugo Nagata	06:28
Re: "Write amplification" is made worse by "getting tired" while inserting into nbtree secondary indexes (Was: Why B-Tree suffix truncation matters)	Simon Riggs	06:28
Re: some more error location support	Peter Eisentraut	06:36
Re: Removing useless \. at the end of copy in pgbench	Peter Eisentraut	06:39
Re: Facility for detecting insecure object naming	Noah Misch	07:06
Re[2]: doc - improve description of default privileges 📎	Fabien COELHO	07:33
Bug in slot.c and are replication slots ever used at Window?	Konstantin Knizhnik	08:00
Re: pg_verify_checksums -d option (was: Re: pg_verify_checksums -r option)	Michael Banck	08:13
Re: pg_verify_checksums -d option (was: Re: pg_verify_checksums -r option)	Michael Banck	08:34
pg_verify_checksums and -fno-strict-aliasing	Michael Banck	08:35
Re: pg_verify_checksums -d option (was: Re: pg_verify_checksums -r option) 📎	Yugo Nagata	08:35
Re: pg_verify_checksums -d option (was: Re: pg_verify_checksums -r option) 📎	Yugo Nagata	08:48
Re: [HACKERS] advanced partition matching algorithm for partition-wise join	Dmitry Dolgov	08:53
Re: pg_verify_checksums -d option (was: Re: pg_verify_checksums -r option)	Michael Banck	08:54
Re: BUG #15346: Replica fails to start after the crash	Alexander Kukushkin	08:55
Re: pg_verify_checksums -d option (was: Re: pg_verify_checksums -r option) 📎	Yugo Nagata	09:10
Re: [HACKERS] [PATCH] kNN for SP-GiST	Alexander Korotkov	09:17
Re: pg_upgrade fails saying function unaccent(text) doesn't exist	Gunnlaugur Thor Briem	09:24
Re: speeding up planning with partitions 📎	Amit Langote	09:29
Re: [HACKERS] [PATCH] kNN for SP-GiST	Alexander Korotkov	09:30
Re: [HACKERS] [PATCH] kNN for SP-GiST 📎	Alexander Korotkov	09:41
Re: pg_verify_checksums -d option (was: Re: pg_verify_checksums -r option)	Alvaro Herrera	09:52
Re: pg_verify_checksums -d option (was: Re: pg_verify_checksums -r option)	Yugo Nagata	10:14
Re: pg_verify_checksums -d option (was: Re: pg_verify_checksums -r option)	Alvaro Herrera	10:18
Re: [HACKERS] Proposal to add work_mem option to postgres_fdw module	Kyotaro HORIGUCHI	10:24
Re: Reopen logfile on SIGHUP 📎	Alexander Korotkov	10:42
Re: pg_verify_checksums -d option (was: Re: pg_verify_checksums -r option)	Yugo Nagata	11:19
Re: Expression errors with "FOR UPDATE" and postgres_fdw with partition wise join enabled.	Etsuro Fujita	11:25
Re: pg_verify_checksums and -fno-strict-aliasing	Fabien COELHO	11:25
Re: pg_verify_checksums failure with hash indexes	Amit Kapila	11:27
Extra word in src/backend/optimizer/README 📎	Etsuro Fujita	11:27
Re: Dimension limit in contrib/cube (dump/restore hazard?) 📎	Alexander Korotkov	11:28
Re: pg_verify_checksums vs windows	Amit Kapila	11:32
Re: pg_verify_checksums vs windows	Magnus Hagander	11:34
Re: Problem while updating a foreign table pointing to a partitioned table on foreign server	Kyotaro HORIGUCHI	11:37
Re: Catalog corruption	Mariel Cherkassky	11:39
Re: Reopen logfile on SIGHUP	Kyotaro HORIGUCHI	11:43
Re: Catalog corruption	Andrew Gierth	11:49
Re: A strange GiST error message or fillfactor of GiST build	Andrey Borodin	12:39
Re: rare crash - FailedAssertion snapbuild.c Line: 580	Erik Rijkers	12:51
Re: [HACKERS] [PATCH] kNN for SP-GiST	Alexander Korotkov	12:57
Re: Problem while updating a foreign table pointing to a partitioned table on foreign server	Etsuro Fujita	12:58
Re: BUG #15346: Replica fails to start after the crash 📎	Michael Paquier	13:39
Re: pg_upgrade fails saying function unaccent(text) doesn't exist	Adrian Klaver	13:48
Startup cost of sequential scan 📎	Alexander Korotkov	13:56
Proposal for disk quota feature	Hubert Zhang	13:57
Re: Dimension limit in contrib/cube (dump/restore hazard?)	Tom Lane	13:59
Re: BUG #15346: Replica fails to start after the crash	Alexander Kukushkin	14:03
Re: Startup cost of sequential scan	Tom Lane	14:04
Re: Dimension limit in contrib/cube (dump/restore hazard?) 📎	Alexander Korotkov	14:09
Re: Proposal for disk quota feature	Chapman Flack	14:22
Re: Startup cost of sequential scan 📎	Alexander Korotkov	14:31
Re: pg_verify_checksums and -fno-strict-aliasing	Tom Lane	14:39
Re: rare crash - FailedAssertion snapbuild.c Line: 580	Alvaro Herrera	14:44
Re: pg_verify_checksums and -fno-strict-aliasing	Alvaro Herrera	14:45
Re: rare crash - FailedAssertion snapbuild.c Line: 580 📎	Erik Rijkers	14:57
Re: Startup cost of sequential scan	Tom Lane	14:58
Re: Startup cost of sequential scan	Konstantin Knizhnik	15:08
Re: Startup cost of sequential scan	Alexander Korotkov	15:23
Re: Startup cost of sequential scan	Andrew Gierth	15:23
Re: Startup cost of sequential scan	Tom Lane	15:33
Re: Startup cost of sequential scan	Alexander Korotkov	15:38
Re: Startup cost of sequential scan	Tom Lane	15:55
Re: Use C99 designated initializers for some structs	Mark Dilger	15:59
Re: pg_upgrade fails saying function unaccent(text) doesn't exist	Gunnlaugur Thor Briem	16:03
Re: "Write amplification" is made worse by "getting tired" while inserting into nbtree secondary indexes (Was: Why B-Tree suffix truncation matters)	Peter Geoghegan	16:15
[PATCH] Tab completion for ALTER DATABASE … SET TABLESPACE 📎	Dagfinn Ilmari =?utf-8?Q?Manns=C3=A5ker?=	16:44
Re: Hint to set owner for tablespace directory	Peter Eisentraut	16:52
Re: [PATCH] Tab completion for ALTER DATABASE … SET TABLESPACE 📎	Dagfinn Ilmari =?utf-8?Q?Manns=C3=A5ker?=	16:54
Re: Use C99 designated initializers for some structs	Alvaro Herrera	16:54
Re: Add a semicolon to query related to search_path	Peter Eisentraut	17:28
Re: TupleTableSlot abstraction	Alvaro Herrera	17:31
Re: BUG #15346: Replica fails to start after the crash 📎	Michael Paquier	17:34
Re: [HACKERS] Proposal to add work_mem option to postgres_fdw module	Peter Eisentraut	17:45
B-tree cache prefetches	Andrey Borodin	17:53
Re: pg_verify_checksums and -fno-strict-aliasing	Michael Paquier	17:56
Re: B-tree cache prefetches	Peter Geoghegan	18:04
Re: Dimension limit in contrib/cube (dump/restore hazard?)	Michael Paquier	18:04
Re: Online verification of checksums	Peter Eisentraut	18:06
Re: Bug in slot.c and are replication slots ever used at Window?	Michael Paquier	18:27
Re: BUG #15346: Replica fails to start after the crash	Alexander Kukushkin	18:31
Re: BUG #15346: Replica fails to start after the crash	Michael Paquier	18:57
Re: Online verification of checksums	Magnus Hagander	19:17
Re: Proposal for disk quota feature	Pavel Stehule	19:32
Re: pg_verify_checksums and -fno-strict-aliasing 📎	Magnus Hagander	19:35
Re: Stored procedures and out parameters	Robert Haas	19:35
Re: Extra word in src/backend/optimizer/README	Magnus Hagander	19:37
Re: Startup cost of sequential scan	Robert Haas	19:43
Re: Use C99 designated initializers for some structs	Robert Haas	19:55
Re: 10.5 but not 10.4: backend startup during reindex system: could not read block 0 in file "base/16400/..": read only 0 of 8192 bytes	Justin Pryzby	20:00
Re: pg_verify_checksums and -fno-strict-aliasing 📎	Magnus Hagander	20:02
Re: pg_verify_checksums and -fno-strict-aliasing 📎	Michael Paquier	20:02
Re: pg_verify_checksums and -fno-strict-aliasing	Magnus Hagander	20:07
Re: pg_verify_checksums and -fno-strict-aliasing	Andres Freund	20:11
Re: Use C99 designated initializers for some structs	Andres Freund	20:14
Re: Stored procedures and out parameters	Dave Cramer	20:14
Re: 10.5 but not 10.4: backend startup during reindex system: could not read block 0 in file "base/16400/..": read only 0 of 8192 bytes	Andres Freund	20:18
Re: pg_verify_checksums and -fno-strict-aliasing	Michael Banck	20:22
Re: pg_verify_checksums and -fno-strict-aliasing	Michael Banck	20:28
Re: pg_verify_checksums and -fno-strict-aliasing	Tom Lane	21:19
Re: 10.5 but not 10.4: backend startup during reindex system: could not read block 0 in file "base/16400/..": read only 0 of 8192 bytes	Tom Lane	21:30
Re: Startup cost of sequential scan	Tom Lane	21:38
Re: B-tree cache prefetches	Thomas Munro	21:40
Re: pg_verify_checksums and -fno-strict-aliasing	Andres Freund	21:46
Re: pg_verify_checksums and -fno-strict-aliasing	Tom Lane	21:49
Re: Use C99 designated initializers for some structs	Tom Lane	21:53
Re: 10.5 but not 10.4: backend startup during reindex system: could not read block 0 in file "base/16400/..": read only 0 of 8192 bytes	Justin Pryzby	21:57
Re: 10.5 but not 10.4: backend startup during reindex system: could not read block 0 in file "base/16400/..": read only 0 of 8192 bytes	Tom Lane	22:03
Re: pg_verify_checksums and -fno-strict-aliasing 📎	Andres Freund	22:04
Re: pg_verify_checksums and -fno-strict-aliasing	Tom Lane	22:11
Re: B-tree cache prefetches	Peter Geoghegan	22:14
psql \dC incorrectly shows casts "with inout" as "binary coercible" on 9.5.14 and 11beta3	jean.pierre.pelletier0	22:30
Re: pg_verify_checksums and -fno-strict-aliasing	Andres Freund	22:33
Re: pg_verify_checksums and -fno-strict-aliasing	Michael Paquier	22:44
Re: pg_verify_checksums and -fno-strict-aliasing 📎	Tom Lane	23:02
Re: pg_verify_checksums and -fno-strict-aliasing	Andres Freund	23:12
Re: some pg_dump query code simplification	Stephen Frost	23:23
Re: some pg_dump query code simplification	Stephen Frost	23:25
Re: pg_verify_checksums and -fno-strict-aliasing	Tom Lane	23:37
Re: Stored procedures and out parameters	Chapman Flack	23:45

Aug. 31, 2018

Thread	Author	Time
Re: pg_verify_checksums and -fno-strict-aliasing	Michael Paquier	00:06
Re: BUG #15346: Replica fails to start after the crash	Kyotaro HORIGUCHI	00:48
Re: BUG #15346: Replica fails to start after the crash	Michael Paquier	01:48
Re: Add a semicolon to query related to search_path	Tatsuro Yamada	01:57
Re: TupleTableSlot abstraction	Amit Khandekar	04:35
Re: Copy function for logical replication slots 📎	Masahiko Sawada	05:03
Re: BUG #15346: Replica fails to start after the crash 📎	Kyotaro HORIGUCHI	05:52
Re: BUG #15346: Replica fails to start after the crash	Michael Paquier	06:23
Re: [HACKERS] advanced partition matching algorithm for partition-wise join	Ashutosh Bapat	06:23
Re: Extra word in src/backend/optimizer/README	Etsuro Fujita	07:58
Re: 10.5 but not 10.4: backend startup during reindex system: could not read block 0 in file "base/16400/..": read only 0 of 8192 bytes	Justin Pryzby	08:08
Re: pg_verify_checksums and -fno-strict-aliasing	Michael Banck	08:11
RE: automatic restore point 📎	Yotsunaga, Naoki	08:14
Re: CREATE ROUTINE MAPPING 📎	Masahiko Sawada	08:18
TR: pgadmin not displaying data from postgresql_fdw	Olivier Leprêtre	08:22
Re: [HACKERS] Proposal to add work_mem option to postgres_fdw module	Masahiko Sawada	08:35
Re: remove ancient pre-dlopen dynloader code 📎	Peter Eisentraut	08:52
Re: Hint to set owner for tablespace directory	Rafia Sabih	08:55
Re: Undo logs 📎	Dilip Kumar	09:38
Re: automatic restore point	Pavel Stehule	09:49
Re: Hint to set owner for tablespace directory	Maksim Milyutin	10:00
Re: Hint to set owner for tablespace directory	Rafia Sabih	10:12
Re: Negotiating the SCRAM channel binding type	Peter Eisentraut	10:18
Re: pg_verify_checksums vs windows	Amit Kapila	10:19
Re: Undo logs	Dilip Kumar	10:24
Re: Hint to set owner for tablespace directory	Maksim Milyutin	10:41
RE: speeding up planning with partitions	Kato, Sho	10:48
Re: Startup cost of sequential scan	Alexander Korotkov	10:50
Re: pg_verify_checksums -d option (was: Re: pg_verify_checksums -r option) 📎	Yugo Nagata	10:52
Re: pg_verify_checksums and -fno-strict-aliasing	Peter Eisentraut	11:10
Re: [HACKERS] GnuTLS support 📎	Peter Eisentraut	11:28
Re: FETCH FIRST clause PERCENT option 📎	Surafel Temesgen	11:42
Re: Expression errors with "FOR UPDATE" and postgres_fdw with partition wise join enabled.	Etsuro Fujita	11:54
Re: Expression errors with "FOR UPDATE" and postgres_fdw with partition wise join enabled.	Jonathan S. Katz	12:30
Re: Hint to set owner for tablespace directory	Maksim Milyutin	12:37
Re: Expression errors with "FOR UPDATE" and postgres_fdw with partition wise join enabled.	Etsuro Fujita	12:40
Progress reporting for pg_verify_checksums 📎	Michael Banck	12:50
TR: redundant constraint_schema	Olivier Leprêtre	12:52
PostgreSQL logical decoder output plugin - unchanged toast data	Georgy Buranov	13:36
Re: Hint to set owner for tablespace directory	Tom Lane	13:59
Re: pg_upgrade fails saying function unaccent(text) doesn't exist	Adrian Klaver	14:14
Re: pg_upgrade fails saying function unaccent(text) doesn't exist	Adrian Klaver	14:17
Re: psql \dC incorrectly shows casts "with inout" as "binary coercible" on 9.5.14 and 11beta3	Tom Lane	14:33
Re: PostgreSQL logical decoder output plugin - unchanged toast data	Andres Freund	14:36
Re: psql \dC incorrectly shows casts "with inout" as "binary coercible" on 9.5.14 and 11beta3	Jean-Pierre Pelletier	14:50
Re: pg_verify_checksums and -fno-strict-aliasing	Tom Lane	14:55
Re: PostgreSQL logical decoder output plugin - unchanged toast data	Georgy Buranov	14:55
Re: remove ancient pre-dlopen dynloader code	Tom Lane	15:05
Re: [HACKERS] WIP: Aggregation push-down 📎	Antonin Houska	15:05
Re: PostgreSQL logical decoder output plugin - unchanged toast data	Andres Freund	15:07
Re: remove ancient pre-dlopen dynloader code	Andres Freund	15:15
Re: Dimension limit in contrib/cube (dump/restore hazard?)	Alvaro Herrera	15:18
Re: TupleTableSlot abstraction	Andres Freund	15:20
Re: PostgreSQL logical decoder output plugin - unchanged toast data	Georgy Buranov	15:34
Re: PostgreSQL logical decoder output plugin - unchanged toast data	Andres Freund	15:39
Re: pg_verify_checksums and -fno-strict-aliasing	Tom Lane	16:02
Re: PostgreSQL logical decoder output plugin - unchanged toast data	Georgy Buranov	16:30
Re: FailedAssertion on partprune	Jaime Casanova	16:48
Re: FailedAssertion on partprune	Jonathan S. Katz	17:24
Re: Negotiating the SCRAM channel binding type	Michael Paquier	17:27
Re: BUG #15346: Replica fails to start after the crash	Michael Paquier	18:10
Re: Bug in slot.c and are replication slots ever used at Window? 📎	Michael Paquier	18:46
Re: pg_verify_checksums and -fno-strict-aliasing 📎	Tom Lane	19:55
Re: psql \dC incorrectly shows casts "with inout" as "binary coercible" on 9.5.14 and 11beta3	Tom Lane	20:46
Re: WIP: Covering + unique indexes.	Alvaro Herrera	20:50
Re: psql \dC incorrectly shows casts "with inout" as "binary coercible" on 9.5.14 and 11beta3	Jean-Pierre Pelletier	20:56
Re: Dimension limit in contrib/cube (dump/restore hazard?)	Alexander Korotkov	22:10
Re: buildfarm: could not read block 3 in file "base/16384/2662": read only 0 of 8192 bytes	Andres Freund	22:13
Re: pg_verify_checksums and -fno-strict-aliasing	Michael Paquier	22:21
Re: patch to allow disable of WAL recycling 📎	Tomas Vondra	22:49
Re: Some pgq table rewrite incompatibility with logical decoding? 📎	Tomas Vondra	23:45
Re: buildfarm: could not read block 3 in file "base/16384/2662": read only 0 of 8192 bytes	Tom Lane	23:53
Re: pg_verify_checksums and -fno-strict-aliasing	Tom Lane	23:59

Browse Archives

Prev | Next