pg.ddx.io  pgsql-performance@postgresql.org mailing list archive  
help / color / mirror / Atom feed
optimizing immutable vs. stable function calls?
  2017-01-18 22:36 UTC  Karl Czajkowski <karlcz@isi.edu>
` Re: optimizing immutable vs. stable function calls?
  2017-01-18 22:54 UTC  Tom Lane <tgl@sss.pgh.pa.us>
` Re: optimizing immutable vs. stable function calls?
  2017-01-18 23:06 UTC  Karl Czajkowski <karlcz@isi.edu>
` Re: optimizing immutable vs. stable function calls?
  2017-01-18 23:06 UTC  David G. Johnston <david.g.johnston@gmail.com>
` Re: optimizing immutable vs. stable function calls?
  2017-01-18 23:23 UTC  Tom Lane <tgl@sss.pgh.pa.us>
` Re: optimizing immutable vs. stable function calls?
  2017-01-18 23:25 UTC  Tom Lane <tgl@sss.pgh.pa.us>
` Re: optimizing immutable vs. stable function calls?
  2017-01-19 00:09 UTC  David G. Johnston <david.g.johnston@gmail.com>
` Re: optimizing immutable vs. stable function calls?
  2017-01-19 02:45 UTC  Karl Czajkowski <karlcz@isi.edu>
` Re: optimizing immutable vs. stable function calls?
  2017-01-23 15:10 UTC  Jim Nasby <Jim.Nasby@BlueTreble.com>
` Re: optimizing immutable vs. stable function calls?
  2017-01-24 00:08 UTC  Merlin Moncure <mmoncure@gmail.com>
  [10+ messages in thread]

Optimization inner join
  2017-01-19 10:08 UTC  Clailson <clailson.dba@gmail.com>
` Re: Optimization inner join
  2017-01-19 12:34 UTC  Phillip Couto <phillip@couto.in>
` Re: Optimization inner join
  2017-01-19 13:04 UTC  Clailson <clailson.dba@gmail.com>
` Re: Optimization inner join
  2017-01-19 13:18 UTC  Phillip Couto <phillip@couto.in>
` Re: Optimization inner join
  2017-01-19 13:23 UTC  Gustavo Rezende Montesino <gustavo.montesino@trtsp.jus.br>
` Re: Optimization inner join
  2017-01-19 13:30 UTC  Vitalii Tymchyshyn <vit@tym.im>
` Re: Optimization inner join
  2017-01-19 13:46 UTC  Phillip Couto <phillip@couto.in>
` Re: Optimization inner join
  2017-01-19 14:13 UTC  Tom Lane <tgl@sss.pgh.pa.us>
` Re: Optimization inner join
  2017-01-19 14:15 UTC  Phillip Couto <phillip@couto.in>
` Re: Optimization inner join
  2017-01-19 14:45 UTC  Gustavo Rezende Montesino <gustavo.montesino@trtsp.jus.br>
  [10+ messages in thread]

out of range error while restore using pgdump
  2017-01-16 09:20 UTC  Samir Magar <samirmagar8@gmail.com>
` Re: out of range error while restore using pgdump
  2017-01-16 15:30 UTC  Tom Lane <tgl@sss.pgh.pa.us>
  [2+ messages in thread]

Sort-of replication for reporting purposes
  2017-01-06 19:24 UTC  Ivan Voras <ivoras@gmail.com>
` Re: Sort-of replication for reporting purposes
  2017-01-06 19:30 UTC  Scott Marlowe <scott.marlowe@gmail.com>
` Re: Sort-of replication for reporting purposes
  2017-01-06 19:33 UTC  Ivan Voras <ivoras@gmail.com>
` Re: Sort-of replication for reporting purposes
  2017-01-06 19:33 UTC  Rick Otten <rottenwindfish@gmail.com>
` Re: Sort-of replication for reporting purposes
  2017-01-06 19:43 UTC  Stephen Frost <sfrost@snowman.net>
` Re: Sort-of replication for reporting purposes
  2017-01-12 17:48 UTC  ProPAAS DBA <dba@propaas.com>
` Re: Sort-of replication for reporting purposes
  2017-01-13 11:00 UTC  Stuart Bishop <stuart@stuartbishop.net>
` Re: Sort-of replication for reporting purposes
  2017-01-13 11:17 UTC  Ivan Voras <ivoras@gmail.com>
` Re: Sort-of replication for reporting purposes
  2017-01-13 11:47 UTC  Phillip Couto <phillip@couto.in>
` Re: Sort-of replication for reporting purposes
  2017-01-13 11:48 UTC  Stuart Bishop <stuart@stuartbishop.net>
  [10+ messages in thread]

How can I find the source of postgresql per-connection memory leaks?
  2017-01-12 17:08 UTC  Eric Jensen <ericcj@gmail.com>
` Re: How can I find the source of postgresql per-connection memory leaks?
  2017-01-12 17:18 UTC  Joshua D. Drake <jd@commandprompt.com>
  [2+ messages in thread]

Unable to connect to server
  2017-01-03 10:00 UTC  Vucomir Ianculov <vukomir@os-ux.com>
` Re: Unable to connect to server
  2017-01-04 09:12 UTC  Andreas Kretschmer <akretschmer@spamfence.net>
` Re: Unable to connect to server
  2017-01-04 11:03 UTC  Vucomir Ianculov <vukomir@os-ux.com>
` Re: Unable to connect to server
  2017-01-04 11:12 UTC  Andreas Kretschmer <akretschmer@spamfence.net>
  [4+ messages in thread]

Performance issue with castings args of the function
  2017-01-02 14:34 UTC  Андрей Хозов <avkhozov@gmail.com>
` Re: Performance issue with castings args of the function
  2017-01-02 15:17 UTC  Pavel Stehule <pavel.stehule@gmail.com>
` Re: Performance issue with castings args of the function
  2017-01-02 16:36 UTC  Tom Lane <tgl@sss.pgh.pa.us>
` Re: Performance issue with castings args of the function
  2017-01-02 16:52 UTC  Андрей Хозов <avkhozov@gmail.com>
  [4+ messages in thread]

copy vs. C function
  2011-12-11 01:27 UTC  Jon Nelson <jnelson+pgsql@jamponi.net>
` Re: copy vs. C function
  2011-12-11 02:32 UTC  Craig Ringer <ringerc@ringerc.id.au>
` Re: copy vs. C function
  2011-12-11 02:35 UTC  Sam Gendler <sgendler@ideasculptor.com>
` Re: copy vs. C function
  2011-12-11 03:08 UTC  Jon Nelson <jnelson+pgsql@jamponi.net>
` Re: copy vs. C function
  2011-12-12 16:38 UTC  Merlin Moncure <mmoncure@gmail.com>
` Re: copy vs. C function
  2011-12-13 14:29 UTC  Jon Nelson <jnelson+pgsql@jamponi.net>
` Re: copy vs. C function
  2011-12-14 06:18 UTC  Tom Lane <tgl@sss.pgh.pa.us>
` Re: copy vs. C function
  2011-12-14 07:02 UTC  idc danny <idcdanny@yahoo.com>
` Re: copy vs. C function
  2011-12-14 13:14 UTC  Kevin Martyn <kevin.martyn@enterprisedb.com>
` Re: copy vs. C function
  2011-12-14 14:06 UTC  Jon Nelson <jnelson+pgsql@jamponi.net>
` Re: copy vs. C function
  2011-12-14 14:32 UTC  idc danny <idcdanny@yahoo.com>
` Re: copy vs. C function
  2011-12-14 15:25 UTC  Tom Lane <tgl@sss.pgh.pa.us>
` Re: copy vs. C function
  2011-12-14 15:40 UTC  Jon Nelson <jnelson+pgsql@jamponi.net>
` Re: copy vs. C function
  2011-12-14 15:51 UTC  Jon Nelson <jnelson+pgsql@jamponi.net>
` Re: copy vs. C function
  2011-12-15 03:18 UTC  Jon Nelson <jnelson+pgsql@jamponi.net>
` Re: copy vs. C function
  2016-12-30 11:35 UTC  rajmhn <rajmhn.ram@gmail.com>
  [16+ messages in thread]

why we do not create indexes on master
  2016-12-27 15:22 UTC  Valerii Valeev <valerii.valeev@mail.ru>
` Re: why we do not create indexes on master
  2016-12-27 16:04 UTC  Andreas Kretschmer <akretschmer@spamfence.net>
` Re: why we do not create indexes on master
  2016-12-27 16:19 UTC  David G. Johnston <david.g.johnston@gmail.com>
` Re: why we do not create indexes on master
  2016-12-27 17:38 UTC  Valerii Valeev <valerii.valeev@mail.ru>
` Re: why we do not create indexes on master
  2016-12-27 17:43 UTC  ProPAAS DBA <dba@propaas.com>
` Re: why we do not create indexes on master
  2016-12-27 17:48 UTC  David G. Johnston <david.g.johnston@gmail.com>
` Re: why we do not create indexes on master
  2016-12-28 00:02 UTC  Valerii Valeev <valerii.valeev@mail.ru>
  [7+ messages in thread]

Fwd: [pgsql-performance] Daily digest v1.4804 (8 messages)
  2016-12-27 23:57 UTC  Valerii Valeev <valerii.valeev@mail.ru>

Invalid page header in block 25561983 of relation pg_tblspc
  2016-12-27 09:24 UTC  Dinesh Chandra 12108 <Dinesh.Chandra@cyient.com>
` Re: Invalid page header in block 25561983 of relation pg_tblspc
  2016-12-27 11:01 UTC  Michael Paquier <michael.paquier@gmail.com>
  [2+ messages in thread]

bad performance
  2016-12-17 22:25 UTC  Gabliver Faluker <gabliver@gmail.com>
` Re: bad performance
  2016-12-17 23:04 UTC  Tom Lane <tgl@sss.pgh.pa.us>
` Re: bad performance
  2016-12-25 13:33 UTC  Jeremy Harris <jgh@wizmail.org>
  [3+ messages in thread]

How to vacuum entire database excluding some tables in PostgreSQL9.1.
  2016-12-21 17:49 UTC  Dinesh Chandra 12108 <Dinesh.Chandra@cyient.com>
` Re: How to vacuum entire database excluding some tables in PostgreSQL9.1.
  2016-12-21 18:16 UTC  ProPAAS DBA <dba@propaas.com>
  [2+ messages in thread]

Size of Temporary tablespace is increasing very much in postgresql 9.1.
  2016-12-15 10:28 UTC  Dinesh Chandra 12108 <Dinesh.Chandra@cyient.com>
` Re: Size of Temporary tablespace is increasing very much in postgresql 9.1.
  2016-12-17 01:57 UTC  Mark Kirkwood <mark.kirkwood@catalyst.net.nz>
` Re: Size of Temporary tablespace is increasing very much in postgresql 9.1.
  2016-12-19 09:19 UTC  Dinesh Chandra 12108 <Dinesh.Chandra@cyient.com>
  [3+ messages in thread]

Ordering on GIN Index
  2016-12-14 02:18 UTC  Rory <roryv@grindinggear.com>

Querying with multicolumn index
  2016-12-09 17:00 UTC  Eric Jiang <eric@doublemap.com>
` Re: Querying with multicolumn index
  2016-12-09 17:56 UTC  Andreas Joseph Krogh <andreas@visena.com>
` Re: Querying with multicolumn index
  2016-12-09 18:58 UTC  Eric Jiang <eric@doublemap.com>
` Re: Querying with multicolumn index
  2016-12-09 23:51 UTC  Tom Lane <tgl@sss.pgh.pa.us>
` Re: Querying with multicolumn index
  2016-12-10 08:06 UTC  Daniel Blanch Bataller <daniel.blanch.bataller@gmail.com>
` Re: Querying with multicolumn index
  2016-12-10 20:15 UTC  Eric Jiang <eric@doublemap.com>
` Re: Querying with multicolumn index
  2016-12-10 20:34 UTC  Tomas Vondra <tomas.vondra@2ndquadrant.com>
` Re: Querying with multicolumn index
  2016-12-11 00:49 UTC  Tom Lane <tgl@sss.pgh.pa.us>
` Re: Querying with multicolumn index
  2016-12-11 00:51 UTC  Tom Lane <tgl@sss.pgh.pa.us>
` Re: Querying with multicolumn index
  2016-12-11 02:08 UTC  Eric Jiang <eric@doublemap.com>
` Re: Querying with multicolumn index
  2016-12-11 06:04 UTC  Daniel Blanch Bataller <daniel.blanch.bataller@gmail.com>
` Re: Querying with multicolumn index
  2016-12-13 21:14 UTC  Daniel Blanch Bataller <daniel.blanch.bataller@gmail.com>
  [12+ messages in thread]

Isolation of tx logs on VMware
  2016-12-13 20:16 UTC  ProPAAS DBA <dba@propaas.com>
` Re: Isolation of tx logs on VMware
  2016-12-13 20:22 UTC  Joshua D. Drake <jd@commandprompt.com>
  [2+ messages in thread]

performance issue with bitmap index scans on huge amounts of big jsonb documents
  2016-11-30 12:26 UTC  Marc-Olaf Jaschke <marc-olaf.jaschke@s24.com>
` Re: performance issue with bitmap index scans on huge amounts of big jsonb documents
  2016-12-05 02:28 UTC  Jeff Janes <jeff.janes@gmail.com>
` Re: performance issue with bitmap index scans on huge amounts of big jsonb documents
  2016-12-05 14:51 UTC  Marc-Olaf Jaschke <marc-olaf.jaschke@s24.com>
` Re: performance issue with bitmap index scans on huge amounts of big jsonb documents
  2016-12-09 17:03 UTC  Merlin Moncure <mmoncure@gmail.com>
  [4+ messages in thread]

Slow query question
  2016-12-06 14:35 UTC  Andrey Povazhnyi <w0rse.t@gmail.com>
` Re: Slow query question
  2016-12-06 15:33 UTC  Tom Lane <tgl@sss.pgh.pa.us>
` Re: Slow query question
  2016-12-07 09:51 UTC  Andrey Povazhnyi <w0rse.t@gmail.com>
  [3+ messages in thread]

Substantial different index use between 9.5 and 9.6
  2016-12-01 23:38 UTC  Bill Measday <bill@measday.com>
` Re: Substantial different index use between 9.5 and 9.6
  2016-12-01 23:48 UTC  Tom Lane <tgl@sss.pgh.pa.us>
` Re: Substantial different index use between 9.5 and 9.6
  2016-12-02 00:26 UTC  Bill Measday <bill@measday.com>
` Re: Substantial different index use between 9.5 and 9.6
  2016-12-02 15:41 UTC  Daniel Blanch Bataller <daniel.blanch.bataller@gmail.com>
` Re: Substantial different index use between 9.5 and 9.6
  2016-12-03 20:42 UTC  Bill Measday <bill@measday.com>
  [5+ messages in thread]

can trigger monitor two tables?
  2016-11-28 08:59 UTC  zhangkai.gis <zhangkai.gis@163.com>
` Re: can trigger monitor two tables?
  2016-11-28 10:49 UTC  Andreas Kretschmer <akretschmer@spamfence.net>
  [2+ messages in thread]

Slow UPDATE in logs that's usually fast
  2016-11-26 05:13 UTC  Aldo Sarmiento <aldo@bigpurpledot.com>

Millions of tables
  2016-09-26 02:50 UTC  Greg Spiegelberg <gspiegelberg@gmail.com>
` Re: Millions of tables
  2016-09-26 03:04 UTC  julyanto SUTANDANG <julyanto@equnix.co.id>
` Re: Millions of tables
  2016-09-26 03:23 UTC  Mike Sofen <msofen@runbox.com>
` Re: Millions of tables
  2016-09-26 04:05 UTC  Greg Spiegelberg <gspiegelberg@gmail.com>
` Re: Millions of tables
  2016-09-26 04:19 UTC  Greg Spiegelberg <gspiegelberg@gmail.com>
` Re: Millions of tables
  2016-09-26 05:04 UTC  Gavin Flower <GavinFlower@archidevsys.co.nz>
` Re: Millions of tables
  2016-09-26 06:07 UTC  Jeff Janes <jeff.janes@gmail.com>
` Re: Millions of tables
  2016-09-26 06:28 UTC  julyanto SUTANDANG <julyanto@equnix.co.id>
` Re: Millions of tables
  2016-09-26 08:28 UTC  Álvaro Hernández Tortosa <aht@8kdata.com>
` Re: Millions of tables
  2016-09-26 09:43 UTC  Stuart Bishop <stuart@stuartbishop.net>
` Re: Millions of tables
  2016-09-26 10:23 UTC  Rick Otten <rottenwindfish@gmail.com>
` Re: Millions of tables
  2016-09-26 12:53 UTC  Greg Spiegelberg <gspiegelberg@gmail.com>
` Re: Millions of tables
  2016-09-26 12:54 UTC  Yves Dorfsman <yves@zioup.com>
` Re: Millions of tables
  2016-09-26 13:05 UTC  Mike Sofen <msofen@runbox.com>
` Re: Millions of tables
  2016-09-26 13:51 UTC  Greg Spiegelberg <gspiegelberg@gmail.com>
` Re: Millions of tables
  2016-09-26 13:53 UTC  Greg Spiegelberg <gspiegelberg@gmail.com>
` Re: Millions of tables
  2016-09-26 13:57 UTC  Greg Spiegelberg <gspiegelberg@gmail.com>
` Re: Millions of tables
  2016-09-26 14:09 UTC  Greg Spiegelberg <gspiegelberg@gmail.com>
` Re: Millions of tables
  2016-09-26 14:21 UTC  Stuart Bishop <stuart@stuartbishop.net>
` Re: Millions of tables
  2016-09-26 14:24 UTC  Greg Spiegelberg <gspiegelberg@gmail.com>
` Re: Millions of tables
  2016-09-26 16:29 UTC  Jeff Janes <jeff.janes@gmail.com>
` Re: Millions of tables
  2016-09-26 16:52 UTC  Tom Lane <tgl@sss.pgh.pa.us>
` Re: Millions of tables
  2016-09-27 14:30 UTC  Craig James <cjames@emolecules.com>
` Re: Millions of tables
  2016-09-27 15:10 UTC  Mike Sofen <msofen@runbox.com>
` Re: Millions of tables
  2016-09-27 15:42 UTC  Mike Sofen <msofen@runbox.com>
` Re: Millions of tables
  2016-09-27 15:46 UTC  Greg Spiegelberg <gspiegelberg@gmail.com>
` Re: Millions of tables
  2016-09-27 15:49 UTC  Greg Spiegelberg <gspiegelberg@gmail.com>
` Re: Millions of tables
  2016-09-27 16:15 UTC  Terry Schmitt <tschmitt@schmittworks.com>
` Re: Millions of tables
  2016-09-27 16:27 UTC  Greg Spiegelberg <gspiegelberg@gmail.com>
` Re: Millions of tables
  2016-09-28 15:39 UTC  Vitalii Tymchyshyn <vit@tym.im>
` Re: Millions of tables
  2016-09-28 16:05 UTC  Richard Albright <rla3rd@gmail.com>
` Re: Millions of tables
  2016-09-28 16:27 UTC  Greg Spiegelberg <gspiegelberg@gmail.com>
` Re: Millions of tables
  2016-09-28 17:27 UTC  Stephen Frost <sfrost@snowman.net>
` Re: Millions of tables
  2016-09-28 17:38 UTC  Greg Spiegelberg <gspiegelberg@gmail.com>
` Re: Millions of tables
  2016-09-28 18:00 UTC  Stephen Frost <sfrost@snowman.net>
` Re: Millions of tables
  2016-09-29 08:21 UTC  Simon Riggs <simon@2ndquadrant.com>
` Re: Millions of tables
  2016-09-29 11:11 UTC  Alex Ignatov (postgrespro) <a.ignatov@postgrespro.ru>
` Re: Millions of tables
  2016-09-30 22:49 UTC  Jim Nasby <Jim.Nasby@BlueTreble.com>
` Re: Millions of tables
  2016-10-01 17:54 UTC  Jeff Janes <jeff.janes@gmail.com>
` Re: Millions of tables
  2016-10-05 12:34 UTC  Greg Spiegelberg <gspiegelberg@gmail.com>
` Re: Millions of tables
  2016-10-08 21:42 UTC  Jim Nasby <Jim.Nasby@BlueTreble.com>
` Re: Millions of tables
  2016-11-25 17:14 UTC  Robert Klemme <shortcutter@googlemail.com>
  [42+ messages in thread]

How to tune Postgres to take advantage of 256GB RAM hardware
  2016-11-23 22:15 UTC  Carmen Mardiros <bluecorr@gmail.com>
` Re: How to tune Postgres to take advantage of 256GB RAM hardware
  2016-11-24 04:19 UTC  Andreas Kretschmer <andreas@a-kretschmer.de>
` Re: How to tune Postgres to take advantage of 256GB RAM hardware
  2016-11-24 08:17 UTC  Carmen Mardiros <bluecorr@gmail.com>
` Re: How to tune Postgres to take advantage of 256GB RAM hardware
  2016-11-24 11:46 UTC  Imre Samu <pella.samu@gmail.com>
` Re: How to tune Postgres to take advantage of 256GB RAM hardware
  2016-11-24 15:31 UTC  Carmen Mardiros <bluecorr@gmail.com>
` Re: How to tune Postgres to take advantage of 256GB RAM hardware
  2016-11-24 18:40 UTC  Tom Lane <tgl@sss.pgh.pa.us>
  [6+ messages in thread]

DO I miss something ?
  2016-11-18 13:52 UTC  Metatrader EA <metatraderea@gmail.com>
` Re: DO I miss something ?
  2016-11-18 14:04 UTC  vinny <vinny@xs4all.nl>
  [2+ messages in thread]


[next (older)]

This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox