pgsql-hackers since 2014-09-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)

Browse Archives

Prev | Next

Sept. 6, 2014

Thread Author Time
Adding a nullable DOMAIN column w/ CHECK 📎 Marko Tiikkaja 00:01
Re: A mechanism securing web applications in DBMS Stephen Frost 01:52
Re: PL/pgSQL 1.2 Marko Tiikkaja 02:25
Re: PL/pgSQL 2 Marko Tiikkaja 02:32
Re: B-Tree support function number 3 (strxfrm() optimization) 📎 Peter Geoghegan 02:45
Re: PL/pgSQL 1.2 Pavel Stehule 04:59
Re: Re: [PATCH] parser: optionally warn about missing AS for column and table aliases Pavel Stehule 05:22
Re: proposal: plpgsql - Assert statement Pavel Stehule 05:27
plpgsql defensive mode Pavel Stehule 05:51
Re: RLS Design 📎 Brightwell, Adam 06:54
Re: Audit of logout Amit Kapila 07:10
Re: PL/pgSQL 1.2 Marko Tiikkaja 08:21
Re: A mechanism securing web applications in DBMS Zhaomo Yang 08:24
Re: PL/pgSQL 1.2 Marko Tiikkaja 09:12
Re: SKIP LOCKED DATA (work in progress) Thomas Munro 10:40
Re: PL/pgSQL 1.2 Joel Jacobson 13:12
Re: PL/pgSQL 1.2 Pavel Stehule 13:24
Re: pg_upgrade and epoch Bruce Momjian 13:30
Re: plpgsql defensive mode Joel Jacobson 13:32
Re: plpgsql defensive mode Marko Tiikkaja 14:31
Re: plpgsql defensive mode Joel Jacobson 14:41
Re: pg_dump warnings in MinGW build Bruce Momjian 14:45
Re: plpgsql defensive mode Marko Tiikkaja 14:53
Re: A mechanism securing web applications in DBMS Stephen Frost 15:16
Re: pgcrypto: PGP signatures Marko Tiikkaja 15:18
Re: btree_gist macaddr valgrind woes Bruce Momjian 15:31
Re: PL/pgSQL 2 Jan Wieck 16:06
Re: PL/pgSQL 1.2 Jan Wieck 16:12
Re: PL/pgSQL 2 Marko Tiikkaja 16:17
Re: PL/pgSQL 1.2 Marko Tiikkaja 16:19
Re: PL/pgSQL 2 Jan Wieck 16:31
Re: PL/pgSQL 2 Marko Tiikkaja 16:33
Re: PL/pgSQL 2 Jan Wieck 16:37
Re: pg_isready --username seems an empty promise Bruce Momjian 16:43
Re: PL/pgSQL 2 David G Johnston 16:47
Re: PL/pgSQL 2 Jan Wieck 17:11
Re: proposal: plpgsql - Assert statement Petr Jelinek 17:16
Re: proposal: plpgsql - Assert statement Marko Tiikkaja 17:26
Re: PL/pgSQL 1.2 Oskari Saarenmaa 17:34
Re: PL/pgSQL 1.2 Marko Tiikkaja 17:41
Re: proposal: plpgsql - Assert statement Pavel Stehule 17:49
Re: plpgsql defensive mode Pavel Stehule 17:50
Re: plpgsql defensive mode Marko Tiikkaja 17:54
Re: plpgsql defensive mode Pavel Stehule 17:56
Re: proposal: plpgsql - Assert statement Marko Tiikkaja 17:59
Re: proposal: plpgsql - Assert statement Pavel Stehule 18:01
Improving PL/PgSQL (was: Re: plpgsql defensive mode) Marko Tiikkaja 18:08
Re: Allowing implicit 'text' -> xml|json|jsonb Tom Lane 18:24
Re: Improving PL/PgSQL Jan Wieck 18:57
Re: Improving PL/PgSQL (was: Re: plpgsql defensive mode) Pavel Stehule 19:47
Re: Final Patch for GROUPING SETS - unrecognized node type: 347 Tomas Vondra 20:04
Re: Final Patch for GROUPING SETS - unrecognized node type: 347 Andrew Gierth 21:34
Re: Patch for psql History Display on MacOSX Tom Lane 21:39
Re: B-Tree support function number 3 (strxfrm() optimization) 📎 Peter Geoghegan 22:01

Sept. 7, 2014

Thread Author Time
Re: jsonb format is pessimal for toast compression David E. Wheeler 01:23
Re: Stating the significance of Lehman & Yao in the nbtree README 📎 Peter Geoghegan 02:58
Re: Patch for psql History Display on MacOSX 📎 Tom Lane 03:40
Re: Improving PL/PgSQL (was: Re: plpgsql defensive mode) Pavel Stehule 04:41
Re: Adding a nullable DOMAIN column w/ CHECK Noah Misch 04:55
Re: B-Tree support function number 3 (strxfrm() optimization) 📎 Peter Geoghegan 04:57
Re: Patch for psql History Display on MacOSX Noah Misch 05:02
Re: ALTER TABLESPACE MOVE command tag tweak Stephen Frost 12:10
Re: Built-in binning functions 📎 Petr Jelinek 12:29
Re: Final Patch for GROUPING SETS - unrecognized node type: 347 Tomas Vondra 12:33
Re: Final Patch for GROUPING SETS - unrecognized node type: 347 Andrew Gierth 13:11
Re: Allowing implicit 'text' -> xml|json|jsonb Craig Ringer 13:14
gist vacuum gist access 📎 Костя Кузнецов 14:11
Re: Final Patch for GROUPING SETS - unrecognized node type: 347 Tomas Vondra 14:14
Re: Improving PL/PgSQL Marko Tiikkaja 15:43
Re: Selectivity estimation for inet operators 📎 Emre Hasegeli 16:09
Re: Final Patch for GROUPING SETS - unrecognized node type: 347 Andrew Gierth 16:52
Re: Adding a nullable DOMAIN column w/ CHECK Tom Lane 17:06
Re: pgcrypto: PGP signatures Jeff Janes 17:28
Re: pgcrypto: PGP signatures Marko Tiikkaja 17:36
Re: Patch for psql History Display on MacOSX Tom Lane 18:07
Re: Final Patch for GROUPING SETS - unrecognized node type: 347 Tomas Vondra 18:27
Re: Built-in binning functions Pavel Stehule 18:45
Re: Built-in binning functions Andres Freund 18:59
Re: Built-in binning functions Tom Lane 19:05
Re: Built-in binning functions Andres Freund 19:09
Re: Adding a nullable DOMAIN column w/ CHECK Noah Misch 19:23
Re: Adding a nullable DOMAIN column w/ CHECK Tom Lane 19:31
Re: Built-in binning functions Petr Jelinek 19:47
Re: Join push-down support for foreign tables Shigeru HANADA 23:07
Re: Join push-down support for foreign tables Shigeru HANADA 23:27

Sept. 8, 2014

Thread Author Time
what data type should be returned by sum(float4) Kouhei Kaigai 00:10
Re: what data type should be returned by sum(float4) Tom Lane 02:20
Re: proposal (9.5) : psql unicode border line styles Stephen Frost 02:44
Re: proposal: ignore null fields in not relation type composite type based constructors 📎 Stephen Frost 03:48
Re: pgcrypto: PGP signatures Jeff Janes 04:15
Re: proposal: ignore null fields in not relation type composite type based constructors Pavel Stehule 04:16
Re: [BUGS] BUG #10823: Better REINDEX syntax. Stephen Frost 04:17
Re: proposal: ignore null fields in not relation type composite type based constructors Stephen Frost 04:27
Re: pg_background (and more parallelism infrastructure patches) Amit Kapila 05:09
Re: pg_background (and more parallelism infrastructure patches) Amit Kapila 06:05
Re: proposal: ignore null fields in not relation type composite type based constructors Pavel Stehule 07:02
Re: gist vacuum gist access Heikki Linnakangas 07:13
Re: Optimization for updating foreign tables in Postgres FDW Albe Laurenz 07:18
Re: gist vacuum gist access Alexander Korotkov 08:08
Re: gist vacuum gist access Alexander Korotkov 08:19
Re: gist vacuum gist access Heikki Linnakangas 08:46
Re: gist vacuum gist access Heikki Linnakangas 08:51
Re: add modulo (%) operator to pgbench Mitsumasa KONDO 10:24
Re: Optimization for updating foreign tables in Postgres FDW 📎 Etsuro Fujita 11:15
Re: pg_receivexlog and replication slots Michael Paquier 11:50
Re: Spinlocks and compiler/memory barriers Andres Freund 12:07
Re: gist vacuum gist access Alexander Korotkov 12:26
Re: postgres_fdw behaves oddly 📎 Etsuro Fujita 12:30
Re: Spinlocks and compiler/memory barriers Tom Lane 14:07
Re: add modulo (%) operator to pgbench 📎 Fabien COELHO 14:08
Re: Spinlocks and compiler/memory barriers Robert Haas 14:08
Re: Spinlocks and compiler/memory barriers Robert Haas 14:09
Re: PL/pgSQL 2 Merlin Moncure 14:10
Re: Spinlocks and compiler/memory barriers Bruce Momjian 14:18
Re: add modulo (%) operator to pgbench 📎 Mitsumasa KONDO 14:22
Re: Spinlocks and compiler/memory barriers Tom Lane 14:29
Re: add modulo (%) operator to pgbench Fabien COELHO 15:04
Re: 9.5: Memory-bounded HashAgg Robert Haas 15:24
Re: proposal (9.5) : psql unicode border line styles 📎 Pavel Stehule 15:32
Re: PQputCopyEnd doesn't adhere to its API contract Robert Haas 15:44
Re: gist vacuum gist access Heikki Linnakangas 15:47
BRIN indexes (was Re: Minmax indexes) 📎 Alvaro Herrera 16:02
Re: PENDING_LIST_CLEANUP_SIZE - maximum size of GIN pending list Re: HEAD seems to generate larger WAL regarding GIN index Jeff Janes 16:28
Re: [v9.5] Custom Plan API Robert Haas 16:39
Re: Scaling shared buffer eviction Merlin Moncure 16:42
Re: pgcrypto: PGP signatures Jeff Janes 17:30
Re: BRIN indexes - TRAP: BadArgument Erik Rijkers 18:03
Re: implement subject alternative names support for SSL connections 📎 Heikki Linnakangas 18:04
Re: pgcrypto: PGP signatures Marko Tiikkaja 18:21
Re: BRIN indexes - TRAP: BadArgument 📎 Alvaro Herrera 18:30
Re: Scaling shared buffer eviction Robert Haas 18:46
Re: ALTER TABLESPACE MOVE command tag tweak 📎 Alvaro Herrera 20:42
Re: bad estimation together with large work_mem generates terrible slow hash joins Robert Haas 20:44
Re: pg_background (and more parallelism infrastructure patches) Robert Haas 21:01
Re: pg_background (and more parallelism infrastructure patches) Robert Haas 21:02
Re: proposal: plpgsql - Assert statement Robert Haas 21:20
Re: ALTER TABLESPACE MOVE command tag tweak Stephen Frost 21:23
Problems with config.php and non default ports (postgresql - sugarcrm) Bianca Santana Espichicoquez 21:27
Re: Scaling shared buffer eviction Thom Brown 21:41
Re: bad estimation together with large work_mem generates terrible slow hash joins Tomas Vondra 21:53
Re: PQputCopyEnd doesn't adhere to its API contract David G Johnston 22:20
Re: PQputCopyEnd doesn't adhere to its API contract David G Johnston 22:24
Re: Spinlocks and compiler/memory barriers Andres Freund 23:10

Sept. 9, 2014

Thread Author Time
Re: Scaling shared buffer eviction Amit Kapila 03:48
Re: proposal: plpgsql - Assert statement Craig Ringer 05:54
Re: proposal: plpgsql - Assert statement Craig Ringer 05:55
Re: Stating the significance of Lehman & Yao in the nbtree README Heikki Linnakangas 07:01
Re: proposal: plpgsql - Assert statement Marko Tiikkaja 07:49
Re: pgcrypto: PGP armor headers Heikki Linnakangas 08:54
Re: pgcrypto: PGP armor headers Marko Tiikkaja 09:01
Re: LIMIT for UPDATE and DELETE Heikki Linnakangas 09:57
Re: pg_background (and more parallelism infrastructure patches) Amit Kapila 10:00
Re: Scaling shared buffer eviction Amit Kapila 10:24
Re: Escaping from blocked send() reprised. 📎 Kyotaro HORIGUCHI 10:31
Re: LIMIT for UPDATE and DELETE Marko Tiikkaja 10:37
Re: LIMIT for UPDATE and DELETE Marko Tiikkaja 10:46
Re: pgbench throttling latency limit Heikki Linnakangas 10:49
Re: pgbench throttling latency limit 📎 Heikki Linnakangas 11:12
Re: LIMIT for UPDATE and DELETE Heikki Linnakangas 11:13
Re: BRIN indexes (was Re: Minmax indexes) Heikki Linnakangas 11:49
Re: [TODO] Process pg_hba.conf keywords as case-insensitive Kyotaro HORIGUCHI 11:49
Re: posix_fadvise() and pg_receivexlog didier 12:07
Re: [TODO] Process pg_hba.conf keywords as case-insensitive Kyotaro HORIGUCHI 12:09
Re: pgbench throttling latency limit Fabien COELHO 12:35
Re: PENDING_LIST_CLEANUP_SIZE - maximum size of GIN pending list Re: HEAD seems to generate larger WAL regarding GIN index 📎 Fujii Masao 13:17
Re: posix_fadvise() and pg_receivexlog Fujii Masao 13:48
Re: WIP Patch for GROUPING SETS phase 1 Robert Haas 14:01
Memory Alignment in Postgres Arthur Silva 14:08
Re: bad estimation together with large work_mem generates terrible slow hash joins Robert Haas 14:09
Re: Optimization for updating foreign tables in Postgres FDW Albe Laurenz 14:16
Re: Join push-down support for foreign tables Robert Haas 14:34
Re: add modulo (%) operator to pgbench Robert Haas 14:45
Re: Memory Alignment in Postgres Bruce Momjian 14:45
Re: pg_upgrade and epoch Bruce Momjian 15:05
Re: ALTER TABLESPACE MOVE command tag tweak Stephen Frost 15:07
Re: add modulo (%) operator to pgbench Fabien COELHO 15:07
Re: WIP Patch for GROUPING SETS phase 1 Pavel Stehule 15:19
Re: WIP Patch for GROUPING SETS phase 1 Robert Haas 15:25
Re: proposal: plpgsql - Assert statement 📎 Pavel Stehule 15:37
Re: [PATCH] empty xml values Peter Eisentraut 15:39
Re: add modulo (%) operator to pgbench Robert Haas 15:54
Re: WIP Patch for GROUPING SETS phase 1 Andrew Gierth 16:01
Re: PQputCopyEnd doesn't adhere to its API contract Robert Haas 16:03
Re: [HACKERS] Problems with config.php and non default ports (postgresql - sugarcrm) Andrew Dunstan 16:03
Re: WIP Patch for GROUPING SETS phase 1 Robert Haas 16:11
Re: WIP Patch for GROUPING SETS phase 1 Tom Lane 16:21
Re: [Fwd: Re: proposal: new long psql parameter --on-error-stop] Andres Freund 16:25
Re: LIMIT for UPDATE and DELETE Jeff Janes 16:28
Re: pg_background (and more parallelism infrastructure patches) Petr Jelinek 16:33
Re: WIP Patch for GROUPING SETS phase 1 Andrew Gierth 16:43
Add shutdown_at_recovery_target option to recovery.conf 📎 Petr Jelinek 16:45
Re: PQputCopyEnd doesn't adhere to its API contract David Johnston 16:47
Re: pg_background (and more parallelism infrastructure patches) Robert Haas 16:49
Re: tracking commit timestamps 📎 Petr Jelinek 17:05
Re: pg_background (and more parallelism infrastructure patches) Petr Jelinek 17:18
Re: Spinlocks and compiler/memory barriers 📎 Robert Haas 17:52
Re: posix_fadvise() and pg_receivexlog Robert Haas 18:19
Re: [9.3] Should we mention "set_config(...)" in 18.1.3 in Server Configuration? 📎 Bruce Momjian 19:13
Re: Built-in binning functions Tom Lane 19:36
Re: [9.3] Should we mention "set_config(...)" in 18.1.3 in Server Configuration? David Johnston 19:40

Browse Archives

Prev | Next