pg.ddx.io pgsql-performance@postgresql.org mailing list archive
help / color / mirror / Atom feedMemory 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