pgsql-hackers since 2017-02-03 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

Feb. 3, 2017

Thread Author Time
Re: [PATCH] Rename pg_switch_xlog to pg_switch_wal Michael Paquier 00:03
Re: logical decoding of two-phase transactions Craig Ringer 00:14
Re: Deadlock in XLogInsert at AIX Noah Misch 00:26
Re: pageinspect: Hash index support Michael Paquier 00:41
Re: Logical Replication and Character encoding Craig Ringer 01:16
Re: \if, \elseif, \else, \endif (was Re: PSQL commands: \quit_if, \quit_unless) Tom Lane 01:32
Re: Constraint exclusion failed to prune partition in case of partition expression involves function call Amit Langote 01:51
Re: Cannot shutdown subscriber after DROP SUBSCRIPTION 📎 Kyotaro HORIGUCHI 01:56
Re: \if, \elseif, \else, \endif (was Re: PSQL commands: \quit_if, \quit_unless) Corey Huinker 02:06
Re: Declarative partitioning - another take Amit Langote 02:31
Re: Logical Replication and Character encoding Kyotaro HORIGUCHI 02:47
Re: [BUGS] Bug in Physical Replication Slots (at least 9.5)? 📎 Kyotaro HORIGUCHI 03:16
pgsql: pageinspect: Try to fix some bugs in previous commit. Robert Haas 03:32
Re: pgsql: pageinspect: Try to fix some bugs in previous commit. Tom Lane 03:40
Re: pgsql: pageinspect: Try to fix some bugs in previous commit. Robert Haas 03:49
Re: pgsql: pageinspect: Try to fix some bugs in previous commit. Tom Lane 04:00
Re: pageinspect: Hash index support Ashutosh Sharma 04:00
Re: pgsql: pageinspect: Try to fix some bugs in previous commit. 📎 Robert Haas 04:03
Re: pgsql: pageinspect: Try to fix some bugs in previous commit. Tom Lane 04:16
Re: Radix tree for character conversion 📎 Kyotaro HORIGUCHI 04:18
Re: Logical Replication and Character encoding Craig Ringer 05:47
Re: proposal: session server side variables Pavel Stehule 05:56
Re: \if, \elseif, \else, \endif (was Re: PSQL commands: \quit_if, \quit_unless) Fabien COELHO 05:57
Re: proposal: session server side variables Pavel Stehule 06:16
Re: proposal: session server side variables Michael Paquier 06:23
Re: proposal: session server side variables Fabien COELHO 06:25
Re: Packages: Again Pavel Stehule 06:27
Re: Packages: Again Craig Ringer 06:34
Re: proposal: session server side variables Pavel Stehule 06:49
Re: Packages: Again Pavel Stehule 06:59
Re: \if, \elseif, \else, \endif (was Re: PSQL commands: \quit_if, \quit_unless) 📎 Corey Huinker 07:16
Re: Index corruption with CREATE INDEX CONCURRENTLY Pavan Deolasee 07:39
Harmonization of json functions (SQLITE) Tobias Schönit 07:52
Re: Non-deterministic behavior with floating point in parallel mode Thomas Munro 08:05
Re: IF (NOT) EXISTS in psql-completion 📎 Kyotaro HORIGUCHI 08:17
Re: Logical Replication and Character encoding Kyotaro HORIGUCHI 08:34
Postgres_fdw behaves oddly vinayak 09:12
Documentation improvements for partitioning 📎 Amit Langote 09:15
Re: Index corruption with CREATE INDEX CONCURRENTLY 📎 Pavan Deolasee 09:19
Re: [WIP]Vertical Clustered Index (columnar store extension) Konstantin Knizhnik 09:28
Re: asynchronous execution Antonin Houska 10:04
Re: proposal: session server side variables Fabien COELHO 10:18
Re: proposal: session server side variables Pavel Stehule 10:19
Re: [PATCH] Rename pg_switch_xlog to pg_switch_wal Stephen Frost 10:21
Re: proposal: session server side variables Pavel Stehule 10:36
Re: Harmonization of json functions (SQLITE) Pavel Stehule 10:52
Re: \if, \elseif, \else, \endif (was Re: PSQL commands: \quit_if, \quit_unless) Erik Rijkers 11:00
Re: pgsql: pageinspect: Try to fix some bugs in previous commit. Amit Kapila 11:06
Redundant comment in ExecutePlan 📎 Rafia Sabih 11:07
Re: \h tab-completion 📎 Andreas Karlsson 12:12
Re: Checksums by default? 📎 Tomas Vondra 12:15
Re: \if, \elseif, \else, \endif (was Re: PSQL commands: \quit_if, \quit_unless) Fabien COELHO 12:24
Re: Gather Merge 📎 Neha Sharma 12:26
Re: patch: optimize information_schema.constraint_column_usage Ashutosh Bapat 12:40
Re: pgsql: pageinspect: Try to fix some bugs in previous commit. 📎 Ashutosh Sharma 12:41
Re: pageinspect: Hash index support Jesper Pedersen 12:45
Re: Password identifiers, protocol aging and SCRAM protocol Heikki Linnakangas 12:52
Re: Parallel tuplesort (for parallel B-Tree index creation) 📎 Thomas Munro 13:04
Re: \if, \elseif, \else, \endif (was Re: PSQL commands: \quit_if, \quit_unless) Fabien COELHO 13:24
Re: patch: optimize information_schema.constraint_column_usage Ashutosh Bapat 14:26
Re: pgsql: pageinspect: Try to fix some bugs in previous commit. Tom Lane 14:43
Re: pgsql: pageinspect: Try to fix some bugs in previous commit. Robert Haas 14:49
Re: pgsql: pageinspect: Try to fix some bugs in previous commit. Amit Kapila 14:50
Re: [COMMITTERS] pgsql: pageinspect: Try to fix some bugs in previous commit. Robert Haas 14:59
Re: pageinspect: Hash index support Tom Lane 15:11
Re: pgsql: pageinspect: Try to fix some bugs in previous commit. Tom Lane 15:28
Re: Cannot shutdown subscriber after DROP SUBSCRIPTION Fujii Masao 15:49
Re: [COMMITTERS] pgsql: pageinspect: Try to fix some bugs in previous commit. Robert Haas 15:54
Re: \if, \elseif, \else, \endif (was Re: PSQL commands: \quit_if, \quit_unless) Corey Huinker 16:08
Re: [COMMITTERS] pgsql: pageinspect: Try to fix some bugs in previous commit. Robert Haas 16:18
Re: [COMMITTERS] pgsql: pageinspect: Try to fix some bugs in previous commit. 📎 Robert Haas 16:35
Re: pageinspect: Hash index support Robert Haas 16:36
Re: [COMMITTERS] pgsql: pageinspect: Try to fix some bugs in previous commit. Tom Lane 16:36
Re: \if, \elseif, \else, \endif (was Re: PSQL commands: \quit_if, \quit_unless) Fabien COELHO 16:38
Re: pageinspect: Hash index support 📎 Jesper Pedersen 16:41
Re: pageinspect: Hash index support Jesper Pedersen 16:49
Re: \if, \elseif, \else, \endif (was Re: PSQL commands: \quit_if, \quit_unless) Corey Huinker 16:49
LWLock optimization for multicore Power machines 📎 Alexander Korotkov 17:01
Re: [COMMITTERS] pgsql: pageinspect: Try to fix some bugs in previous commit. Tom Lane 17:04
Re: \if, \elseif, \else, \endif (was Re: PSQL commands: \quit_if, \quit_unless) Tom Lane 17:10
Re: LWLock optimization for multicore Power machines Alexander Korotkov 17:11
Re: \if, \elseif, \else, \endif (was Re: PSQL commands: \quit_if, \quit_unless) Daniel Verite 17:20
Re: Packages: Again Serge Rielau 17:30
Re: Cannot shutdown subscriber after DROP SUBSCRIPTION Fujii Masao 18:38
Re: Index corruption with CREATE INDEX CONCURRENTLY 📎 Alvaro Herrera 18:42
Re: new autovacuum criterion for visible pages Jeff Janes 18:55
Re: Packages: Again Pavel Stehule 19:09
Re: Parallel tuplesort (for parallel B-Tree index creation) Peter Geoghegan 19:12
Re: Add pgstathashindex() to get hash index table statistics. Robert Haas 19:42
Re: Possible issue with expanded object infrastructure on Postgres 9.6.1 Peter Geoghegan 19:58
Re: \if, \elseif, \else, \endif (was Re: PSQL commands: \quit_if, \quit_unless) Corey Huinker 20:03
Re: LWLock optimization for multicore Power machines Bernd Helmle 20:31
Re: LWLock optimization for multicore Power machines Robert Haas 20:34
Re: \if, \elseif, \else, \endif (was Re: PSQL commands: \quit_if, \quit_unless) Robert Haas 20:49
Re: new autovacuum criterion for visible pages Alvaro Herrera 21:17
Re: \if, \elseif, \else, \endif (was Re: PSQL commands: \quit_if, \quit_unless) Corey Huinker 21:24
Re: [COMMITTERS] pgsql: pageinspect: Try to fix some bugs in previous commit. Robert Haas 21:35
Re: \if, \elseif, \else, \endif (was Re: PSQL commands: \quit_if, \quit_unless) Robert Haas 21:37
Re: [PATCH] Rename pg_switch_xlog to pg_switch_wal Robert Haas 21:39
libpq Alternate Row Processor Kyle Gearhart 21:53
Re: pageinspect: Hash index support Robert Haas 21:55
Re: Speedup twophase transactions Robert Haas 22:17
Re: Packages: Again Serge Rielau 22:24
Re: Enabling replication connections by default in pg_hba.conf Michael Paquier 22:47
Re: logical decoding of two-phase transactions Robert Haas 22:47
Re: Parallel tuplesort (for parallel B-Tree index creation) Peter Geoghegan 22:58
Re: logical decoding of two-phase transactions Andres Freund 23:00
Re: Password identifiers, protocol aging and SCRAM protocol Michael Paquier 23:01
Re: [PATCH] Rename pg_switch_xlog to pg_switch_wal Kevin Grittner 23:01
Re: Write Ahead Logging for Hash Indexes Jeff Janes 23:07
Re: Checksums by default? Jim Nasby 23:23
Re: Checksums by default? Andres Freund 23:31
Re: Checksums by default? Robert Haas 23:44
Re: ParallelFinish-hook of FDW/CSP (Re: Steps inside ExecEndGather) Claudio Freire 23:46
Re: logical decoding of two-phase transactions Robert Haas 23:47
Re: Declarative partitioning - another take Robert Haas 23:49
Re: Superowners Robert Haas 23:54

Feb. 4, 2017

Thread Author Time
Re: multivariate statistics (v19) Robert Haas 00:03
Re: Redundant comment in ExecutePlan Robert Haas 00:07
Re: logical decoding of two-phase transactions Andres Freund 00:08
Re: logical decoding of two-phase transactions Robert Haas 00:09
Re: logical decoding of two-phase transactions Andres Freund 00:11
Re: Time to up bgwriter_lru_maxpages? Jim Nasby 00:12
Re: Parallel tuplesort (for parallel B-Tree index creation) Thomas Munro 00:15
Re: Time to up bgwriter_lru_maxpages? Andres Freund 00:20
Re: Parallel Index Scans Robert Haas 00:24
PinBuffer() no longer makes use of strategy Jim Nasby 00:32
Re: PinBuffer() no longer makes use of strategy Andres Freund 00:39
Re: \if, \elseif, \else, \endif (was Re: PSQL commands: \quit_if, \quit_unless) Jim Nasby 00:42
Re: libpq Alternate Row Processor Jim Nasby 00:46
Re: Checksums by default? Jim Nasby 00:53
Re: PinBuffer() no longer makes use of strategy Jim Nasby 01:13
Re: \if, \elseif, \else, \endif (was Re: PSQL commands: \quit_if, \quit_unless) Corey Huinker 01:21
Re: Time to up bgwriter_lru_maxpages? Jim Nasby 01:26
Re: PinBuffer() no longer makes use of strategy Andres Freund 01:33
Re: Time to up bgwriter_lru_maxpages? Andres Freund 01:34
Re: Parallel Index Scans Amit Kapila 01:44
Re: Parallel tuplesort (for parallel B-Tree index creation) Peter Geoghegan 01:45
Re: [COMMITTERS] pgsql: pageinspect: Try to fix some bugs in previous commit. Ashutosh Sharma 02:14
Re: Write Ahead Logging for Hash Indexes Amit Kapila 02:16
Re: Packages: Again Pavel Stehule 05:14
Re: libpq Alternate Row Processor Tom Lane 05:31
pg_sequences bug ? Shinoda, Noriyoshi 05:50
Re: Index corruption with CREATE INDEX CONCURRENTLY Amit Kapila 06:40
Re: logical decoding of two-phase transactions Konstantin Knizhnik 07:19
Re: \if, \elseif, \else, \endif (was Re: PSQL commands: \quit_if, \quit_unless) 📎 Fabien COELHO 07:26
3D Z-curve spatial index 📎 Boris Muratshin 08:41
Re: pgbench more operators & functions 📎 Fabien COELHO 09:51
Re: pageinspect: Hash index support Ashutosh Sharma 10:38
pg_restore foreign keys NOT VALID, or [assume] VALID; VALIDATE CONSTRAINT CONCURRENTLY Tomasz Ostrowski 10:49
Re: \if, \elseif, \else, \endif (was Re: PSQL commands: \quit_if, \quit_unless) Daniel Verite 11:37
Re: Provide list of subscriptions and publications in psql's completion 📎 Michael Paquier 12:01
Re: pageinspect: Hash index support Ashutosh Sharma 12:06
Re: pg_sequences bug ? 📎 Michael Paquier 12:30
Re: Constraint exclusion failed to prune partition in case of partition expression involves function call amul sul 13:06
Re: Index corruption with CREATE INDEX CONCURRENTLY Pavan Deolasee 14:11
Re: Vacuum: allow usage of more than 1GB of work mem Masahiko Sawada 15:43
Re: \if, \elseif, \else, \endif (was Re: PSQL commands: \quit_if, \quit_unless) Corey Huinker 16:47
Re: \if, \elseif, \else, \endif (was Re: PSQL commands: \quit_if, \quit_unless) Corey Huinker 16:53
Draft release notes for next week's releases are up for review Tom Lane 17:57
Ancient row-ordering instability in regression tests Tom Lane 18:11
Re: Index corruption with CREATE INDEX CONCURRENTLY Tom Lane 18:24
Re: PinBuffer() no longer makes use of strategy 📎 Alexander Korotkov 19:47
Re: Provide list of subscriptions and publications in psql's completion Fujii Masao 19:54
Re: Provide list of subscriptions and publications in psql's completion Fujii Masao 20:04
Re: Cannot shutdown subscriber after DROP SUBSCRIPTION Petr Jelinek 20:11
Re: Logical Replication and Character encoding Petr Jelinek 20:27
Re: \if, \elseif, \else, \endif (was Re: PSQL commands: \quit_if, \quit_unless) 📎 Corey Huinker 21:00
Re: Review: GIN non-intrusive vacuum of posting tree Jeff Davis 22:45
Variable name typo in launcher.c 📎 Masahiko Sawada 23:05

Feb. 5, 2017

Thread Author Time
Ignore tablespace ACLs when ignoring schema ACLs 📎 Noah Misch 00:06
Re: PoC: Make it possible to disallow WHERE-less UPDATE and DELETE Rod Taylor 01:08
Re: PoC: Make it possible to disallow WHERE-less UPDATE and DELETE Michael Paquier 01:33
Re: Index corruption with CREATE INDEX CONCURRENTLY Pavan Deolasee 06:54
Re: \if, \elseif, \else, \endif (was Re: PSQL commands: \quit_if, \quit_unless) Fabien COELHO 07:55
Re: Index corruption with CREATE INDEX CONCURRENTLY Pavel Stehule 09:53
Re: [PATCH] Generic type subscription Dmitry Dolgov 10:28
Re: Draft release notes for next week's releases are up for review Amit Kapila 10:35
Re: Index corruption with CREATE INDEX CONCURRENTLY Michael Paquier 13:03
Re: Parallel bitmap heap scan 📎 Dilip Kumar 14:48
Re: Review: GIN non-intrusive vacuum of posting tree Andrew Borodin 16:04
Re: Ignore tablespace ACLs when ignoring schema ACLs Tom Lane 17:46
Re: Index corruption with CREATE INDEX CONCURRENTLY Tom Lane 17:51
Re: Draft release notes for next week's releases are up for review Tom Lane 18:04
Re: Index corruption with CREATE INDEX CONCURRENTLY Pavel Stehule 18:09
Re: Index corruption with CREATE INDEX CONCURRENTLY Martín Marqués 18:34
Re: Ignore tablespace ACLs when ignoring schema ACLs Noah Misch 18:38
Re: Ignore tablespace ACLs when ignoring schema ACLs Tom Lane 18:48
Re: Ignore tablespace ACLs when ignoring schema ACLs Noah Misch 18:56
Re: Index corruption with CREATE INDEX CONCURRENTLY 📎 Tom Lane 20:14
Re: [PATCH] SortSupport for macaddr type 📎 Brandur Leach 21:56
Re: 3D Z-curve spatial index David Fetter 22:08
Re: [COMMITTERS] pgsql: pageinspect: Try to fix some bugs in previous commit. Robert Haas 23:50

Feb. 6, 2017

Thread Author Time
Re: Index corruption with CREATE INDEX CONCURRENTLY Robert Haas 00:09
Re: Index corruption with CREATE INDEX CONCURRENTLY Peter Geoghegan 00:11
Re: Index corruption with CREATE INDEX CONCURRENTLY Andres Freund 00:14
Re: ParallelFinish-hook of FDW/CSP (Re: Steps inside ExecEndGather) Kouhei Kaigai 00:19
Re: Index corruption with CREATE INDEX CONCURRENTLY Andres Freund 00:37
Re: Index corruption with CREATE INDEX CONCURRENTLY Tomas Vondra 00:57
Re: Index corruption with CREATE INDEX CONCURRENTLY 📎 Andres Freund 00:57

Browse Archives

Prev | Next