pg.ddx.io  pgsql-performance@postgresql.org mailing list archive  
help / color / mirror / Atom feed
Memory size
  2018-03-11 12:48 UTC  dangal <danielito.gallo@gmail.com>
` Re: Memory size
  2018-03-11 16:59 UTC  Jeff Janes <jeff.janes@gmail.com>
` Re: Memory size
  2018-03-11 17:33 UTC  dangal <danielito.gallo@gmail.com>
` Re: Memory size
  2018-03-11 18:12 UTC  Tomas Vondra <tomas.vondra@2ndquadrant.com>
` Re: Memory size
  2018-03-11 19:11 UTC  dangal <danielito.gallo@gmail.com>
` Re: Memory size
  2018-03-11 23:16 UTC  Jeff Janes <jeff.janes@gmail.com>
` Re: Memory size
  2018-03-12 01:43 UTC  dangal <danielito.gallo@gmail.com>
` Re: Memory size
  2018-03-12 15:08 UTC  dangal <danielito.gallo@gmail.com>
  [8+ messages in thread]

Sv: Re: Sv: Memory size
  2018-03-11 21:45 UTC  Andreas Joseph Krogh <andreas@visena.com>

Sv: Memory size
  2018-03-11 13:49 UTC  Andreas Joseph Krogh <andreas@visena.com>
` Re: Sv: Memory size
  2018-03-11 13:57 UTC  dangal <danielito.gallo@gmail.com>
  [2+ messages in thread]

Updating large tables without dead tuples
  2018-02-23 23:27 UTC  ldh@laurent-hasson.com <ldh@laurent-hasson.com>
` Re: Updating large tables without dead tuples
  2018-02-24 00:09 UTC  Stephen Frost <sfrost@snowman.net>
` RE: Updating large tables without dead tuples
  2018-02-24 17:19 UTC  ldh@laurent-hasson.com <ldh@laurent-hasson.com>
` Re: Updating large tables without dead tuples
  2018-02-24 20:56 UTC  Stephen Frost <sfrost@snowman.net>
` Re: Updating large tables without dead tuples
  2018-03-03 01:55 UTC  Vik Fearing <vik.fearing@2ndquadrant.com>
` RE: Updating large tables without dead tuples
  2018-03-10 23:42 UTC  ldh@laurent-hasson.com <ldh@laurent-hasson.com>
  [6+ messages in thread]

by mistake dropped physical file dropped for one table.
  2018-03-06 11:35 UTC  Rambabu V <ram.wissen@gmail.com>
` Re: by mistake dropped physical file dropped for one table.
  2018-03-06 13:21 UTC  Stephen Frost <sfrost@snowman.net>
` Re: by mistake dropped physical file dropped for one table.
  2018-03-06 13:27 UTC  Rambabu V <ram.wissen@gmail.com>
  [3+ messages in thread]

need meta data table/command to find query log
  2018-03-06 11:38 UTC  Rambabu V <ram.wissen@gmail.com>
` Re: need meta data table/command to find query log
  2018-03-06 13:24 UTC  Stephen Frost <sfrost@snowman.net>
  [2+ messages in thread]

Please help
  2018-02-23 19:31 UTC  Daulat Ram <Daulat.Ram@exponential.com>
` Re: Please help
  2018-02-23 21:23 UTC  Andreas Kretschmer <andreas@a-kretschmer.de>
` Re: Please help
  2018-02-24 20:58 UTC  PropAAS DBA <dba@propaas.com>
` Please help
  2018-03-06 08:01 UTC  Daulat Ram <Daulat.Ram@exponential.com>
` Re: Please help
  2018-03-06 11:46 UTC  Tomas Vondra <tomas.vondra@2ndquadrant.com>
  [5+ messages in thread]

GIST index (polygon, point)
  2018-03-05 16:18 UTC  ghiureai <isabella.ghiurea@nrc-cnrc.gc.ca>
` Re: GIST index (polygon, point)
  2018-03-06 09:59 UTC  Laurenz Albe <laurenz.albe@cybertec.at>
  [2+ messages in thread]

Slow index scan backward.
  2018-03-05 15:45 UTC  John van Breda <john.vanbreda@biodiverseit.co.uk>

why does this query not use a parallel query
  2018-03-02 16:29 UTC  Dave Cramer <davecramer@gmail.com>
` Re: why does this query not use a parallel query
  2018-03-02 16:44 UTC  Tom Lane <tgl@sss.pgh.pa.us>
  [2+ messages in thread]

Performance degrade in Planning Time to find appropriate Partial Index
  2018-03-01 11:09 UTC  Meenatchi Sandanam <meen.opm@gmail.com>
` Re: Performance degrade in Planning Time to find appropriate Partial Index
  2018-03-01 13:03 UTC  Laurenz Albe <laurenz.albe@cybertec.at>
` Re: Performance degrade in Planning Time to find appropriate Partial Index
  2018-03-01 14:16 UTC  Michael Loftis <mloftis@wgops.com>
` Re: Performance degrade in Planning Time to find appropriate Partial Index
  2018-03-01 14:39 UTC  Moreno Andreo <moreno.andreo@evolu-s.it>
` Re: Performance degrade in Planning Time to find appropriate Partial Index
  2018-03-02 13:49 UTC  Nandakumar M <m.nanda92@gmail.com>
` Re: Performance degrade in Planning Time to find appropriate Partial Index
  2018-03-02 14:29 UTC  Pavel Stehule <pavel.stehule@gmail.com>
` Re: Performance degrade in Planning Time to find appropriate Partial Index
  2018-03-02 14:32 UTC  Pavel Stehule <pavel.stehule@gmail.com>
  [7+ messages in thread]

check_postgres via Nagios
  2018-02-26 05:27 UTC  daulat sagar <daulat.dba@gmail.com>

Bitmap scan is undercosted?
  2017-12-01 17:40 UTC  Vitaliy Garnashevich <vgarnashevich@gmail.com>
` Re: Bitmap scan is undercosted?
  2017-12-01 18:34 UTC  Justin Pryzby <pryzby@telsasoft.com>
` Re: Bitmap scan is undercosted?
  2017-12-01 23:08 UTC  Vitaliy Garnashevich <vgarnashevich@gmail.com>
` Re: Bitmap scan is undercosted?
  2017-12-01 23:11 UTC  Justin Pryzby <pryzby@telsasoft.com>
` Re: Bitmap scan is undercosted?
  2017-12-01 23:54 UTC  Vitaliy Garnashevich <vgarnashevich@gmail.com>
` Re: Bitmap scan is undercosted?
  2017-12-02 02:06 UTC  Justin Pryzby <pryzby@telsasoft.com>
` Re: Bitmap scan is undercosted?
  2017-12-02 05:51 UTC  Jeff Janes <jeff.janes@gmail.com>
` Re: Bitmap scan is undercosted?
  2017-12-02 06:41 UTC  Justin Pryzby <pryzby@telsasoft.com>
` Re: Bitmap scan is undercosted?
  2017-12-02 07:08 UTC  Vitaliy Garnashevich <vgarnashevich@gmail.com>
` Re: Bitmap scan is undercosted?
  2017-12-02 21:17 UTC  Jeff Janes <jeff.janes@gmail.com>
` Re: Bitmap scan is undercosted?
  2017-12-02 23:44 UTC  Tom Lane <tgl@sss.pgh.pa.us>
` Re: Bitmap scan is undercosted?
  2017-12-03 01:27 UTC  Jeff Janes <jeff.janes@gmail.com>
` Re: Bitmap scan is undercosted?
  2017-12-03 21:15 UTC  Vitaliy Garnashevich <vgarnashevich@gmail.com>
` Re: Bitmap scan is undercosted?
  2017-12-03 21:22 UTC  Vitaliy Garnashevich <vgarnashevich@gmail.com>
` Re: Bitmap scan is undercosted?
  2017-12-03 22:11 UTC  Vitaliy Garnashevich <vgarnashevich@gmail.com>
` Re: Bitmap scan is undercosted?
  2017-12-03 23:08 UTC  Tom Lane <tgl@sss.pgh.pa.us>
` Re: Bitmap scan is undercosted?
  2017-12-06 07:06 UTC  Vitaliy Garnashevich <vgarnashevich@gmail.com>
` Re: Bitmap scan is undercosted?
  2017-12-07 00:17 UTC  Vitaliy Garnashevich <vgarnashevich@gmail.com>
` Re: Bitmap scan is undercosted?
  2017-12-07 03:48 UTC  Jeff Janes <jeff.janes@gmail.com>
` Re: Bitmap scan is undercosted?
  2017-12-12 07:29 UTC  Jeff Janes <jeff.janes@gmail.com>
` Re: Bitmap scan is undercosted?
  2018-02-24 08:45 UTC  Vitaliy Garnashevich <vgarnashevich@gmail.com>
  [21+ messages in thread]

effective_io_concurrency on EBS/gp2
  2018-01-31 12:03 UTC  Vitaliy Garnashevich <vgarnashevich@gmail.com>
` Re: effective_io_concurrency on EBS/gp2
  2018-01-31 13:01 UTC  Rick Otten <rottenwindfish@gmail.com>
` Re: effective_io_concurrency on EBS/gp2
  2018-01-31 13:15 UTC  Vitaliy Garnashevich <vgarnashevich@gmail.com>
` Re: effective_io_concurrency on EBS/gp2
  2018-01-31 13:24 UTC  Pavel Stehule <pavel.stehule@gmail.com>
` RE: effective_io_concurrency on EBS/gp2
  2018-01-31 13:46 UTC  Gary Doades <gpd@gpdnet.co.uk>
` Re: effective_io_concurrency on EBS/gp2
  2018-01-31 16:57 UTC  Vitaliy Garnashevich <vgarnashevich@gmail.com>
` Re: effective_io_concurrency on EBS/gp2
  2018-01-31 19:34 UTC  Claudio Freire <klaussfreire@gmail.com>
` Re: effective_io_concurrency on EBS/gp2
  2018-01-31 20:29 UTC  Vitaliy Garnashevich <vgarnashevich@gmail.com>
` Re: effective_io_concurrency on EBS/gp2
  2018-01-31 21:00 UTC  Jeff Janes <jeff.janes@gmail.com>
` Re: effective_io_concurrency on EBS/gp2
  2018-02-01 02:21 UTC  hzzhangjiazhi <hzzhangjiazhi@corp.netease.com>
` Re: effective_io_concurrency on EBS/gp2
  2018-02-01 18:39 UTC  Claudio Freire <klaussfreire@gmail.com>
` Re: effective_io_concurrency on EBS/gp2
  2018-02-02 11:46 UTC  Vitaliy Garnashevich <vgarnashevich@gmail.com>
` Re: effective_io_concurrency on EBS/gp2
  2018-02-03 23:05 UTC  Vitaliy Garnashevich <vgarnashevich@gmail.com>
` Re: effective_io_concurrency on EBS/gp2
  2018-02-05 02:27 UTC  Claudio Freire <klaussfreire@gmail.com>
` Re: effective_io_concurrency on EBS/gp2
  2018-02-05 11:26 UTC  Vitaliy Garnashevich <vgarnashevich@gmail.com>
` Re: effective_io_concurrency on EBS/gp2
  2018-02-05 20:14 UTC  Claudio Freire <klaussfreire@gmail.com>
` Re: effective_io_concurrency on EBS/gp2
  2018-02-07 05:42 UTC  Justin Pryzby <pryzby@telsasoft.com>
` Re: effective_io_concurrency on EBS/gp2
  2018-02-08 16:05 UTC  Vitaliy Garnashevich <vgarnashevich@gmail.com>
` Re: effective_io_concurrency on EBS/gp2
  2018-02-08 16:40 UTC  Vitaliy Garnashevich <vgarnashevich@gmail.com>
` Re: effective_io_concurrency on EBS/gp2
  2018-02-23 15:23 UTC  Rick Otten <rottenwindfish@gmail.com>
` Re: effective_io_concurrency on EBS/gp2
  2018-02-23 15:35 UTC  Vitaliy Garnashevich <vgarnashevich@gmail.com>
  [21+ messages in thread]

need advice to tune postgresql
  2018-02-23 14:42 UTC  Darius Pėža <darius@onrails.lt>
` Re: need advice to tune postgresql
  2018-02-23 15:03 UTC  MichaelDBA <MichaelDBA@sqlexec.com>
` Re: need advice to tune postgresql
  2018-02-23 15:26 UTC  Laurenz Albe <laurenz.albe@cybertec.at>
  [3+ messages in thread]

blending 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]


[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