pg.ddx.io pgsql-performance@postgresql.org mailing list archive
help / color / mirror / Atom feedblending fast and temp space volumes
2018-02-21 15:53 UTC Rick Otten <rottenwindfish@gmail.com>
` Re: blending fast and temp space volumes
2018-02-21 16:04 UTC Tom Lane <tgl@sss.pgh.pa.us>
` Re: blending fast and temp space volumes
2018-02-21 19:22 UTC Craig James <cjames@emolecules.com>
` Re: blending fast and temp space volumes
2018-02-21 19:50 UTC Peter Geoghegan <pg@bowt.ie>
` Re: blending fast and temp space volumes
2018-02-21 20:07 UTC Claudio Freire <klaussfreire@gmail.com>
` Re: blending fast and temp space volumes
2018-02-21 20:09 UTC Peter Geoghegan <pg@bowt.ie>
` Re: blending fast and temp space volumes
2018-02-22 11:30 UTC Claudio Freire <klaussfreire@gmail.com>
[7+ messages in thread]
Efficiently searching for the most recent rows where a column matches any result from a different query
2018-02-13 13:28 UTC mkslaf@keemail.me
` Re: Efficiently searching for the most recent rows where a column matches any result from a different query
2018-02-13 21:13 UTC Hellmuth Vargas <hivs77@gmail.com>
` Re: Efficiently searching for the most recent rows where a column matches any result from a different query
2018-02-15 12:18 UTC mkslaf@keemail.me
` Re: Efficiently searching for the most recent rows where a column matches any result from a different query
2018-02-19 10:04 UTC Nandakumar M <m.nanda92@gmail.com>
` Re: Efficiently searching for the most recent rows where a column matches any result from a different query
2018-02-19 10:10 UTC Nandakumar M <m.nanda92@gmail.com>
[5+ messages in thread]
pgpool 2 rotate logs
2018-02-18 15:19 UTC Mariel Cherkassky <mariel.cherkassky@gmail.com>
` Re: pgpool 2 rotate logs
2018-02-19 01:03 UTC Tatsuo Ishii <ishii@sraoss.co.jp>
[2+ messages in thread]
OT: Performance of VM
2018-02-05 13:14 UTC Thomas Güttler <guettliml@thomas-guettler.de>
` Re: OT: Performance of VM
2018-02-05 13:26 UTC Andreas Kretschmer <andreas@a-kretschmer.de>
` Re: OT: Performance of VM
2018-02-05 16:22 UTC Andrew Kerber <andrew.kerber@gmail.com>
` Re: OT: Performance of VM
2018-02-05 16:33 UTC Andreas Kretschmer <andreas@a-kretschmer.de>
` Re: OT: Performance of VM
2018-02-10 11:20 UTC Robert Klemme <shortcutter@googlemail.com>
` Re: OT: Performance of VM
2018-02-10 14:58 UTC Andrew Kerber <andrew.kerber@gmail.com>
` Re: OT: Performance of VM
2018-02-14 03:43 UTC Mark Kirkwood <mark.kirkwood@catalyst.net.nz>
[7+ messages in thread]
Details after Load Peak was: OT: Performance of VM
2018-02-06 14:31 UTC Thomas Güttler <guettliml@thomas-guettler.de>
` Re: Details after Load Peak was: OT: Performance of VM
2018-02-06 15:30 UTC Alan Hodgson <ahodgson@lists.simkin.ca>
` Re: Details after Load Peak was: OT: Performance of VM
2018-02-13 21:15 UTC Gunnar "Nick" Bluth <gunnar.bluth@pro-open.de>
` Re: Details after Load Peak was: OT: Performance of VM
2018-02-13 21:55 UTC Micky Gough <mgough@squiz.net>
[4+ messages in thread]
Same plans different performance?
2018-02-09 11:56 UTC Elias Panagiotidis <eliaspanagiotidis@yahoo.gr>
Re: failing to use index on UNION of matviews (Re: postgresql 10.1 wrong plan in when using partitions bug)
2018-02-06 18:18 UTC Justin Pryzby <pryzby@telsasoft.com>
` Re: failing to use index on UNION of matviews (Re: postgresql 10.1 wrong plan in when using partitions bug)
2018-02-06 20:02 UTC Rick Otten <rottenwindfish@gmail.com>
` Re: failing to use index on UNION of matviews (Re: postgresql 10.1 wrong plan in when using partitions bug)
2018-02-06 20:03 UTC Rick Otten <rottenwindfish@gmail.com>
` Re: failing to use index on UNION of matviews (Re: postgresql 10.1 wrong plan in when using partitions bug)
2018-02-08 11:04 UTC Rick Otten <rottenwindfish@gmail.com>
[4+ messages in thread]
pg_xlog unbounded growth
2018-01-24 11:48 UTC Stefan Petrea <Stefan.Petrea@tangoe.com>
` Re: pg_xlog unbounded growth
2018-01-25 16:57 UTC Laurenz Albe <laurenz.albe@cybertec.at>
` Re: pg_xlog unbounded growth
2018-01-25 21:36 UTC Tomas Vondra <tomas.vondra@2ndquadrant.com>
` Re: pg_xlog unbounded growth
2018-01-26 08:18 UTC Andreas Kretschmer <andreas@a-kretschmer.de>
` RE: pg_xlog unbounded growth
2018-02-07 17:11 UTC Alex Ignatov <a.ignatov@postgrespro.ru>
[5+ messages in thread]
postgresql 10.1 wrong plan in when using partitions bug
2018-02-04 10:14 UTC Mariel Cherkassky <mariel.cherkassky@gmail.com>
` Re: postgresql 10.1 wrong plan in when using partitions bug
2018-02-04 12:03 UTC Tomas Vondra <tomas.vondra@2ndquadrant.com>
` Re: postgresql 10.1 wrong plan in when using partitions bug
2018-02-04 12:15 UTC Rick Otten <rottenwindfish@gmail.com>
` Re: postgresql 10.1 wrong plan in when using partitions bug
2018-02-04 12:19 UTC Mariel Cherkassky <mariel.cherkassky@gmail.com>
` Re: postgresql 10.1 wrong plan in when using partitions bug
2018-02-04 13:19 UTC legrand legrand <legrand_legrand@hotmail.com>
` Re: postgresql 10.1 wrong plan in when using partitions bug
2018-02-04 13:22 UTC Mariel Cherkassky <mariel.cherkassky@gmail.com>
` Re: postgresql 10.1 wrong plan in when using partitions bug
2018-02-04 13:29 UTC legrand legrand <legrand_legrand@hotmail.com>
` Re: postgresql 10.1 wrong plan in when using partitions bug
2018-02-04 13:38 UTC Rick Otten <rottenwindfish@gmail.com>
` Re: postgresql 10.1 wrong plan in when using partitions bug
2018-02-04 13:43 UTC Mariel Cherkassky <mariel.cherkassky@gmail.com>
` Re: postgresql 10.1 wrong plan in when using partitions bug
2018-02-04 14:41 UTC Mariel Cherkassky <mariel.cherkassky@gmail.com>
` Re: postgresql 10.1 wrong plan in when using partitions bug
2018-02-04 14:54 UTC Andreas Kretschmer <andreas@a-kretschmer.de>
` Re: postgresql 10.1 wrong plan in when using partitions bug
2018-02-04 15:06 UTC Mariel Cherkassky <mariel.cherkassky@gmail.com>
` Re: postgresql 10.1 wrong plan in when using partitions bug
2018-02-04 15:25 UTC Justin Pryzby <pryzby@telsasoft.com>
` Re: postgresql 10.1 wrong plan in when using partitions bug
2018-02-04 15:28 UTC Mariel Cherkassky <mariel.cherkassky@gmail.com>
` Re: postgresql 10.1 wrong plan in when using partitions bug
2018-02-04 15:35 UTC Tom Lane <tgl@sss.pgh.pa.us>
` Re: postgresql 10.1 wrong plan in when using partitions bug
2018-02-04 15:39 UTC Tom Lane <tgl@sss.pgh.pa.us>
` Re: postgresql 10.1 wrong plan in when using partitions bug
2018-02-04 15:42 UTC Mariel Cherkassky <mariel.cherkassky@gmail.com>
` Re: postgresql 10.1 wrong plan in when using partitions bug
2018-02-04 16:04 UTC Rick Otten <rottenwindfish@gmail.com>
` Re: postgresql 10.1 wrong plan in when using partitions bug
2018-02-05 19:19 UTC Justin Pryzby <pryzby@telsasoft.com>
[19+ messages in thread]
SV: bad plan using nested loops
2018-02-01 20:34 UTC Johan Fredriksson <eskil@kth.se>
` Re: SV: bad plan using nested loops
2018-02-02 09:02 UTC Johan Fredriksson <eskil@kth.se>
` Re: SV: bad plan using nested loops
2018-02-05 19:15 UTC Tomas Vondra <tomas.vondra@2ndquadrant.com>
[3+ messages in thread]
postgresql 10.1 scanning all partitions instead of 1
2018-02-04 09:23 UTC Mariel Cherkassky <mariel.cherkassky@gmail.com>
` Re: postgresql 10.1 scanning all partitions instead of 1
2018-02-04 09:28 UTC Mariel Cherkassky <mariel.cherkassky@gmail.com>
[2+ messages in thread]
Query optimiser is not using 'not null' constraint when 'order by nulls last' clause is used
2018-02-01 14:30 UTC Nandakumar M <m.nanda92@gmail.com>
` Re: Query optimiser is not using 'not null' constraint when 'order by nulls last' clause is used
2018-02-02 09:36 UTC Laurenz Albe <laurenz.albe@cybertec.at>
` Re: Query optimiser is not using 'not null' constraint when 'order by nulls last' clause is used
2018-02-02 14:04 UTC Nandakumar M <m.nanda92@gmail.com>
` Re: Query optimiser is not using 'not null' constraint when 'order by nulls last' clause is used
2018-02-02 15:00 UTC Tom Lane <tgl@sss.pgh.pa.us>
` Re: Query optimiser is not using 'not null' constraint when 'order by nulls last' clause is used
2018-02-02 15:49 UTC Nandakumar M <m.nanda92@gmail.com>
` Re: Query optimiser is not using 'not null' constraint when 'order by nulls last' clause is used
2018-02-02 15:58 UTC David G. Johnston <david.g.johnston@gmail.com>
` Re: Query optimiser is not using 'not null' constraint when 'order by nulls last' clause is used
2018-02-02 17:01 UTC Nandakumar M <m.nanda92@gmail.com>
[7+ messages in thread]
bad plan using nested loops
2018-02-01 10:42 UTC Johan Fredriksson <eskil@kth.se>
` Re: bad plan using nested loops
2018-02-01 15:00 UTC Tom Lane <tgl@sss.pgh.pa.us>
[2+ messages in thread]
8.2 Autovacuum BUG ?
2007-08-31 15:30 UTC Pallav Kalva <pkalva@livedatagroup.com>
` Re: 8.2 Autovacuum BUG ?
2007-08-31 15:39 UTC Tom Lane <tgl@sss.pgh.pa.us>
` Re: 8.2 Autovacuum BUG ?
2007-08-31 16:05 UTC Pallav Kalva <pkalva@livedatagroup.com>
` Re: 8.2 Autovacuum BUG ?
2007-08-31 16:11 UTC Alvaro Herrera <alvherre@commandprompt.com>
` Re: 8.2 Autovacuum BUG ?
2007-08-31 16:25 UTC Pallav Kalva <pkalva@livedatagroup.com>
` Re: 8.2 Autovacuum BUG ?
2007-08-31 16:29 UTC Mark Lewis <mark.lewis@mir3.com>
` Re: 8.2 Autovacuum BUG ?
2007-08-31 17:46 UTC Chris Browne <cbbrowne@acm.org>
` Re: 8.2 Autovacuum BUG ?
2007-08-31 18:31 UTC Mikko Partio <mpartio@gmail.com>
` Re: 8.2 Autovacuum BUG ?
2007-08-31 18:42 UTC Pallav Kalva <pkalva@livedatagroup.com>
` Re: 8.2 Autovacuum BUG ?
2007-08-31 18:47 UTC Alvaro Herrera <alvherre@commandprompt.com>
` Re: 8.2 Autovacuum BUG ?
2007-08-31 18:51 UTC Alvaro Herrera <alvherre@commandprompt.com>
` Re: 8.2 Autovacuum BUG ?
2007-08-31 19:08 UTC Tom Lane <tgl@sss.pgh.pa.us>
` Re: 8.2 Autovacuum BUG ?
2007-08-31 19:13 UTC Chris Browne <cbbrowne@acm.org>
` Re: 8.2 Autovacuum BUG ?
2007-08-31 19:35 UTC Erik Jones <erik@myemma.com>
` Re: 8.2 Autovacuum BUG ?
2007-08-31 19:48 UTC Tom Lane <tgl@sss.pgh.pa.us>
` Re: 8.2 Autovacuum BUG ?
2007-08-31 23:24 UTC Greg Smith <gsmith@gregsmith.com>
` Re: 8.2 Autovacuum BUG ?
2007-08-31 23:43 UTC Tom Lane <tgl@sss.pgh.pa.us>
` Re: 8.2 Autovacuum BUG ?
2018-01-22 06:09 UTC pavan95 <pavan.postgresdba@gmail.com>
` Re: 8.2 Autovacuum BUG ?
2018-01-22 09:41 UTC Sergei Kornilov <sk@zsrv.org>
` Re: 8.2 Autovacuum BUG ?
2018-01-22 10:21 UTC pavan95 <pavan.postgresdba@gmail.com>
` Re: 8.2 Autovacuum BUG ?
2018-01-22 11:47 UTC Andreas Kretschmer <andreas@a-kretschmer.de>
` Re: 8.2 Autovacuum BUG ?
2018-01-23 07:04 UTC pavan95 <pavan.postgresdba@gmail.com>
` Re: 8.2 Autovacuum BUG ?
2018-01-23 11:51 UTC pavan95 <pavan.postgresdba@gmail.com>
` Re: 8.2 Autovacuum BUG ?
2018-01-23 14:17 UTC Andreas Kretschmer <andreas@a-kretschmer.de>
` Re: 8.2 Autovacuum BUG ?
2018-01-23 14:39 UTC Pavan Teja <pavan.postgresdba@gmail.com>
` Re: 8.2 Autovacuum BUG ?
2018-01-23 14:45 UTC David G. Johnston <david.g.johnston@gmail.com>
` Re: 8.2 Autovacuum BUG ?
2018-01-23 14:57 UTC Andreas Kretschmer <andreas@a-kretschmer.de>
` Re: 8.2 Autovacuum BUG ?
2018-01-23 15:20 UTC Pavan Teja <pavan.postgresdba@gmail.com>
` Re: 8.2 Autovacuum BUG ?
2018-01-23 15:26 UTC Andreas Kretschmer <andreas@a-kretschmer.de>
` Re: 8.2 Autovacuum BUG ?
2018-01-23 16:07 UTC Claudio Freire <klaussfreire@gmail.com>
` Re: 8.2 Autovacuum BUG ?
2018-01-23 16:16 UTC Pavan Teja <pavan.postgresdba@gmail.com>
` Re: 8.2 Autovacuum BUG ?
2018-01-23 22:59 UTC Claudio Freire <klaussfreire@gmail.com>
` Re: 8.2 Autovacuum BUG ?
2018-01-24 06:54 UTC pavan95 <pavan.postgresdba@gmail.com>
` Re: 8.2 Autovacuum BUG ?
2018-01-24 07:42 UTC Claudio Freire <klaussfreire@gmail.com>
` Re: 8.2 Autovacuum BUG ?
2018-01-24 11:50 UTC pavan95 <pavan.postgresdba@gmail.com>
` Re: 8.2 Autovacuum BUG ?
2018-01-24 14:27 UTC Claudio Freire <klaussfreire@gmail.com>
` Re: 8.2 Autovacuum BUG ?
2018-01-24 14:48 UTC Pavan Teja <pavan.postgresdba@gmail.com>
` Re: 8.2 Autovacuum BUG ?
2018-01-24 14:57 UTC David G. Johnston <david.g.johnston@gmail.com>
` Re: 8.2 Autovacuum BUG ?
2018-01-24 15:19 UTC Alvaro Herrera <alvherre@alvh.no-ip.org>
` Re: 8.2 Autovacuum BUG ?
2018-01-25 03:47 UTC pavan95 <pavan.postgresdba@gmail.com>
` Re: 8.2 Autovacuum BUG ?
2018-01-25 21:30 UTC Alvaro Herrera <alvherre@alvh.no-ip.org>
` Re: 8.2 Autovacuum BUG ?
2018-01-26 00:32 UTC Pavan Teja <pavan.postgresdba@gmail.com>
` Re: 8.2 Autovacuum BUG ?
2018-01-29 04:46 UTC Pavan Teja <pavan.postgresdba@gmail.com>
` Re: 8.2 Autovacuum BUG ?
2018-01-30 13:55 UTC pavan95 <pavan.postgresdba@gmail.com>
` Re: 8.2 Autovacuum BUG ?
2018-01-30 16:13 UTC Claudio Freire <klaussfreire@gmail.com>
` Re: 8.2 Autovacuum BUG ?
2018-02-01 06:18 UTC pavan95 <pavan.postgresdba@gmail.com>
[46+ messages in thread]
Nested Loops
2018-01-31 06:37 UTC Kumar, Virendra <Virendra.Kumar@guycarp.com>
` Re: Nested Loops
2018-01-31 08:42 UTC Laurenz Albe <laurenz.albe@cybertec.at>
[2+ messages in thread]
SV: pgaudit and create postgis extension logs a lot inserts
2018-01-19 11:03 UTC Svensson Peter <peter.svensson@smhi.se>
` SV: pgaudit and create postgis extension logs a lot inserts
2018-01-22 08:20 UTC Svensson Peter <peter.svensson@smhi.se>
` Re: SV: pgaudit and create postgis extension logs a lot inserts
2018-01-30 15:26 UTC Bruce Momjian <bruce@momjian.us>
[3+ messages in thread]
PostgreSQL 10.1 partitions and indexes
2018-01-29 10:30 UTC Mariel Cherkassky <mariel.cherkassky@gmail.com>
performance drop after upgrade (9.6 > 10)
2017-10-11 11:06 UTC johannes graën <johannes@selfnet.de>
` Re: performance drop after upgrade (9.6 > 10)
2017-10-11 11:11 UTC Pavel Stehule <pavel.stehule@gmail.com>
` Re: performance drop after upgrade (9.6 > 10)
2017-10-11 12:19 UTC johannes graën <johannes@selfnet.de>
` Re: performance drop after upgrade (9.6 > 10)
2017-10-24 14:15 UTC johannes graën <johannes@selfnet.de>
` Re: performance drop after upgrade (9.6 > 10)
2017-10-24 15:18 UTC Justin Pryzby <pryzby@telsasoft.com>
` Re: performance drop after upgrade (9.6 > 10)
2017-10-24 15:57 UTC Johannes Graën <johannes@selfnet.de>
` Re: performance drop after upgrade (9.6 > 10)
2017-10-24 16:17 UTC Alvaro Herrera <alvherre@alvh.no-ip.org>
` Re: performance drop after upgrade (9.6 > 10)
2017-10-26 19:45 UTC Justin Pryzby <pryzby@telsasoft.com>
` Re: [PERFORM] performance drop after upgrade (9.6 > 10)
2018-01-28 23:53 UTC Bruce Momjian <bruce@momjian.us>
[9+ messages in thread]
Query Slow After 2018
2018-01-28 17:32 UTC Nur Agus <nuragus.linux@gmail.com>
` Re: Query Slow After 2018
2018-01-28 17:51 UTC Justin Pryzby <pryzby@telsasoft.com>
` Re: Query Slow After 2018
2018-01-28 21:40 UTC David G. Johnston <david.g.johnston@gmail.com>
[3+ messages in thread]
SV: copy csv into partitioned table with unique index
2018-01-28 11:57 UTC Lars Aksel Opsahl <Lars.Opsahl@nibio.no>
` SV: copy csv into partitioned table with unique index
2018-01-28 12:04 UTC Lars Aksel Opsahl <Lars.Opsahl@nibio.no>
[2+ messages in thread]
copy csv into partitioned table with unique index
2018-01-28 09:11 UTC Mariel Cherkassky <mariel.cherkassky@gmail.com>
` Re: copy csv into partitioned table with unique index
2018-01-28 10:55 UTC legrand legrand <legrand_legrand@hotmail.com>
[2+ messages in thread]
PG 10 hash index create times
2018-01-26 10:58 UTC Rick Otten <rottenwindfish@gmail.com>
need help on memory allocation
2018-01-18 15:25 UTC Rambabu V <ram.wissen@gmail.com>
` Re: need help on memory allocation
2018-01-19 10:07 UTC Laurenz Albe <laurenz.albe@cybertec.at>
` Re: need help on memory allocation
2018-01-23 13:59 UTC Rambabu V <ram.wissen@gmail.com>
` Re: need help on memory allocation
2018-01-23 14:08 UTC Andreas Kretschmer <andreas@a-kretschmer.de>
` Re: need help on memory allocation
2018-01-23 18:36 UTC Laurenz Albe <laurenz.albe@cybertec.at>
` Re: need help on memory allocation
2018-01-23 22:36 UTC Jeff Janes <jeff.janes@gmail.com>
` Re: need help on memory allocation
2018-01-24 05:54 UTC pavan95 <pavan.postgresdba@gmail.com>
` Re: need help on memory allocation
2018-01-24 07:15 UTC Michael Paquier <michael.paquier@gmail.com>
` Re: need help on memory allocation
2018-01-24 07:34 UTC pavan95 <pavan.postgresdba@gmail.com>
` Re: need help on memory allocation
2018-01-24 08:03 UTC Vitaliy Garnashevich <vgarnashevich@gmail.com>
[10+ messages in thread]
Performance impact of lowering max_files_per_process
2018-01-19 16:48 UTC Thomas Kellerer <spam_eater@gmx.net>
` Re: Performance impact of lowering max_files_per_process
2018-01-24 07:09 UTC Thomas Kellerer <spam_eater@gmx.net>
[2+ messages in thread]
bad plan
2005-03-08 10:32 UTC Gaetano Mendola <mendola@bigfoot.com>
` Re: bad plan
2005-03-08 11:39 UTC Richard Huxton <dev@archonet.com>
` Re: bad plan
2005-03-08 12:22 UTC Gaetano Mendola <mendola@bigfoot.com>
` Re: bad plan
2005-03-08 13:20 UTC Richard Huxton <dev@archonet.com>
` Re: bad plan
2005-03-08 18:35 UTC Gaetano Mendola <mendola@bigfoot.com>
` Re: bad plan
2005-03-08 19:20 UTC Richard Huxton <dev@archonet.com>
` Re: bad plan
2005-03-08 20:01 UTC Tom Lane <tgl@sss.pgh.pa.us>
` Re: bad plan
2005-03-08 20:25 UTC Richard Huxton <dev@archonet.com>
` Re: bad plan
2005-03-08 20:42 UTC Tom Lane <tgl@sss.pgh.pa.us>
` Re: bad plan
2005-03-09 00:47 UTC Gaetano Mendola <mendola@bigfoot.com>
` bad plan
2012-04-05 11:47 UTC Julien Cigar <jcigar@ulb.ac.be>
` Re: bad plan
2012-04-05 14:26 UTC Kevin Grittner <Kevin.Grittner@wicourts.gov>
` Re: bad plan
2012-04-05 19:47 UTC Ants Aasma <ants@cybertec.at>
` Re: bad plan
2012-04-06 11:16 UTC Julien Cigar <jcigar@ulb.ac.be>
` Bad plan
2018-01-23 12:03 UTC Laurent Martelli <martellilaurent@gmail.com>
` Re: Bad plan
2018-01-23 15:18 UTC Justin Pryzby <pryzby@telsasoft.com>
` Re: Bad plan
2018-01-23 15:38 UTC Laurent Martelli <martellilaurent@gmail.com>
` Re: Bad plan
2018-01-23 15:59 UTC Laurent Martelli <martellilaurent@gmail.com>
` Re: Bad plan
2018-01-23 17:18 UTC Matthew Bellew <matthewb@labkey.com>
[19+ 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