pgsql-hackers since 2014-09-05 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. 5, 2014

Thread Author Time
Re: B-Tree support function number 3 (strxfrm() optimization) Peter Geoghegan 00:07
Re: B-Tree support function number 3 (strxfrm() optimization) Peter Geoghegan 00:18
Re: A mechanism securing web applications in DBMS Stephen Frost 01:53
Re: jsonb format is pessimal for toast compression Jan Wieck 02:04
Re: jsonb format is pessimal for toast compression Jan Wieck 02:24
Re: jsonb format is pessimal for toast compression Jan Wieck 02:26
Re: pg_receivexlog --status-interval add fsync feedback Fujii Masao 03:10
Re: Scaling shared buffer eviction Mark Kirkwood 03:12
Re: A mechanism securing web applications in DBMS Laurence Rowe 04:21
Re: pg_receivexlog --status-interval add fsync feedback 📎 furuyao 05:51
ODBC Driver performance comparison Vladimir Romanov 05:54
proposal: plpgsql - Assert statement Pavel Stehule 06:16
Re: Re: proposal: ignore null fields in not relation type composite type based constructors Jeevan Chalke 06:29
Re: Re: proposal: ignore null fields in not relation type composite type based constructors Pavel Stehule 06:33
Re: ODBC Driver performance comparison Heikki Linnakangas 06:41
Re: Escaping from blocked send() reprised. Kyotaro HORIGUCHI 06:42
Re: PL/PgSQL: EXIT USING ROLLBACK Joel Jacobson 06:47
Re: Patch for psql History Display on MacOSX Noah Misch 07:01
Re: Allowing implicit 'text' -> xml|json|jsonb (was: PL/pgSQL 2) Craig Ringer 07:04
Re: Patch for psql History Display on MacOSX Noah Misch 07:09
Re: proposal: plpgsql - Assert statement Marko Tiikkaja 07:52
Re: proposal: plpgsql - Assert statement Pavel Stehule 08:09
Re: postgresql latency & bgwriter not doing its job didier 08:17
Re: Escaping from blocked send() reprised. 📎 Kyotaro HORIGUCHI 08:30
Re: proposal: plpgsql - Assert statement Marko Tiikkaja 08:33
Re: Escaping from blocked send() reprised. 📎 Kyotaro HORIGUCHI 08:39
Re: proposal: plpgsql - Assert statement Pavel Stehule 08:40
Re: proposal: plpgsql - Assert statement Marko Tiikkaja 08:57
Re: Allowing implicit 'text' -> xml|json|jsonb Marko Tiikkaja 09:04
Re: Allowing implicit 'text' -> xml|json|jsonb Craig Ringer 09:08
Re: proposal: plpgsql - Assert statement Pavel Stehule 09:08
Re: proposal: plpgsql - Assert statement Marko Tiikkaja 09:17
Re: Join push-down support for foreign tables Atri Sharma 09:18
Re: pg_dump refactor patch to remove global variables 📎 Joachim Wieland 09:19
Re: Allowing implicit 'text' -> xml|json|jsonb Marko Tiikkaja 09:20
Re: proposal: plpgsql - Assert statement Pavel Stehule 09:21
Re: pgcrypto: PGP signatures 📎 Marko Tiikkaja 11:38
Re: Scaling shared buffer eviction 📎 Amit Kapila 11:47
Re: Scaling shared buffer eviction Amit Kapila 11:50
Re: proposal: plpgsql - Assert statement Jan Wieck 12:35
Re: A mechanism securing web applications in DBMS Geoff Montee 12:54
Re: pgbench throttling latency limit Jan Wieck 12:59
Re: Scaling shared buffer eviction 📎 Amit Kapila 13:19
Re: pgbench throttling latency limit Fabien COELHO 14:12
Re: pgbench throttling latency limit Jan Wieck 15:38
Re: implement subject alternative names support for SSL connections 📎 Alexey Klyukin 16:30
Re: PL/pgSQL 2 Merlin Moncure 16:37
Re: postgresql latency & bgwriter not doing its job Robert Haas 18:09
Re: postgresql latency & bgwriter not doing its job Claudio Freire 19:18
Re: bad estimation together with large work_mem generates terrible slow hash joins Tomas Vondra 19:23
VIP: explain of running query 📎 Pavel Stehule 19:54
Re: Allowing implicit 'text' -> xml|json|jsonb (was: PL/pgSQL 2) Merlin Moncure 20:07
[PATCH] parser: optionally warn about missing AS for column and table aliases 📎 Oskari Saarenmaa 20:38
Re: [PATCH] parser: optionally warn about missing AS for column and table aliases Marko Tiikkaja 20:45
Re: [PATCH] parser: optionally warn about missing AS for column and table aliases Oskari Saarenmaa 20:56
Re: [PATCH] parser: optionally warn about missing AS for column and table aliases Marko Tiikkaja 21:06
Re: [PATCH] parser: optionally warn about missing AS for column and table aliases Pavel Stehule 21:11
Re: [PATCH] Filter error log statements by sqlstate Oskari Saarenmaa 21:12
Re: [PATCH] parser: optionally warn about missing AS for column and table aliases David G Johnston 21:19
Re: [PATCH] parser: optionally warn about missing AS for column and table aliases David G Johnston 21:33
Re: Re: [PATCH] parser: optionally warn about missing AS for column and table aliases Bruce Momjian 21:54
Re: Re: [PATCH] parser: optionally warn about missing AS for column and table aliases Marko Tiikkaja 22:27
Re: Re: [PATCH] parser: optionally warn about missing AS for column and table aliases David Johnston 22:35
Re: A mechanism securing web applications in DBMS Zhaomo Yang 22:43
Re: Re: [PATCH] parser: optionally warn about missing AS for column and table aliases Marko Tiikkaja 22:53
Re: Re: [BUGS] Re: BUG #9555: pg_dump for tables with inheritance recreates the table with the wrong order of columns Bruce Momjian 23:02
Re: PL/pgSQL 2 Andrew Dunstan 23:18
Re: pg_upgrade and epoch Bruce Momjian 23:19
Re: Display of timestamp in pg_dump custom format Bruce Momjian 23:22
Re: pg_upgrade and epoch Greg Stark 23:26
Re: pg_upgrade and epoch Bruce Momjian 23:35
Re: Need Multixact Freezing Docs 📎 Bruce Momjian 23:39

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

Browse Archives

Prev | Next