pg.ddx.io pgsql-performance@postgresql.org mailing list archive
help / color / mirror / Atom feedfunctions: VOLATILE performs better than STABLE
2018-03-24 01:27 UTC Peter <pmc@citylink.dinoex.sub.org>
` Re: functions: VOLATILE performs better than STABLE
2018-03-25 05:00 UTC Laurenz Albe <laurenz.albe@cybertec.at>
` Re: functions: VOLATILE performs better than STABLE
2018-03-25 12:24 UTC David Rowley <david.rowley@2ndquadrant.com>
` Re: functions: VOLATILE performs better than STABLE
2018-04-05 14:18 UTC Merlin Moncure <mmoncure@gmail.com>
[4+ messages in thread]
Slow query on partitioned table.
2018-03-27 14:14 UTC Glenn Pierce <glennpierce@gmail.com>
` Re: Slow query on partitioned table.
2018-03-27 14:43 UTC Justin Pryzby <pryzby@telsasoft.com>
` Re: Slow query on partitioned table.
2018-03-27 21:00 UTC Justin Pryzby <pryzby@telsasoft.com>
[3+ messages in thread]
Should from_collapse be switched off? (queries 10 times faster)
2018-03-23 10:03 UTC Peter <pmc@citylink.dinoex.sub.org>
` Re: Should from_collapse be switched off? (queries 10 times faster)
2018-03-23 11:39 UTC Thomas Kellerer <spam_eater@gmx.net>
` Re: Should from_collapse be switched off? (queries 10 times faster)
2018-03-23 11:41 UTC Laurenz Albe <laurenz.albe@cybertec.at>
` Re: Should from_collapse be switched off? (queries 10 times faster)
2018-03-23 14:14 UTC Tom Lane <tgl@sss.pgh.pa.us>
` Re: Should from_collapse be switched off? (queries 10 times faster)
2018-03-23 14:30 UTC Peter <pmc@citylink.dinoex.sub.org>
` Re: Should from_collapse be switched off? (queries 10 times faster)
2018-03-23 14:30 UTC Peter <pmc@citylink.dinoex.sub.org>
` Re: Should from_collapse be switched off? (queries 10 times faster)
2018-03-23 17:36 UTC Peter <pmc@citylink.dinoex.sub.org>
` Re: Should from_collapse be switched off? (queries 10 times faster)
2018-03-25 05:12 UTC Laurenz Albe <laurenz.albe@cybertec.at>
` Re: Should from_collapse be switched off? (queries 10 times faster)
2018-03-26 10:36 UTC Peter <pmc@citylink.dinoex.sub.org>
` Re: Should from_collapse be switched off? (queries 10 times faster)
2018-03-26 17:13 UTC Laurenz Albe <laurenz.albe@cybertec.at>
[10+ messages in thread]
Slow planning time for custom function
2018-03-23 20:28 UTC bk@e8s.de
` Re: Slow planning time for custom function
2018-03-24 01:35 UTC Andres Freund <andres@anarazel.de>
` Re: Slow planning time for custom function
2018-03-24 01:52 UTC David Rowley <david.rowley@2ndquadrant.com>
` Re: Slow planning time for custom function
2018-03-25 18:18 UTC bk@e8s.de
[4+ messages in thread]
DB corruption
2018-03-23 07:59 UTC Akshay Ballarpure <akshay.ballarpure@tcs.com>
` Re: DB corruption
2018-03-23 08:04 UTC Michael Paquier <michael@paquier.xyz>
` Re: DB corruption
2018-03-23 15:08 UTC Tom Lane <tgl@sss.pgh.pa.us>
[3+ messages in thread]
badly scaling performance with appending to bytea
2018-03-21 12:03 UTC Gary Cowell <gary.cowell@gmail.com>
` Re: badly scaling performance with appending to bytea
2018-03-21 12:12 UTC Rick Otten <rottenwindfish@gmail.com>
` Re: badly scaling performance with appending to bytea
2018-03-21 12:56 UTC Pavel Stehule <pavel.stehule@gmail.com>
` Re: badly scaling performance with appending to bytea
2018-03-21 12:59 UTC Pavel Stehule <pavel.stehule@gmail.com>
` Re: badly scaling performance with appending to bytea
2018-03-21 13:04 UTC Gary Cowell <gary.cowell@gmail.com>
` Re: badly scaling performance with appending to bytea
2018-03-21 13:09 UTC Pavel Stehule <pavel.stehule@gmail.com>
[6+ messages in thread]
PG 9.6 Slow inserts with long-lasting LWLocks
2018-01-22 18:43 UTC Pavel Suderevsky <psuderevsky@gmail.com>
` RE: PG 9.6 Slow inserts with long-lasting LWLocks
2018-03-15 10:29 UTC Pavel Suderevsky <psuderevsky@gmail.com>
` Re: PG 9.6 Slow inserts with long-lasting LWLocks
2018-03-16 13:42 UTC MichaelDBA <MichaelDBA@sqlexec.com>
` RE: PG 9.6 Slow inserts with long-lasting LWLocks
2018-03-19 17:26 UTC Pavel Suderevsky <psuderevsky@gmail.com>
[4+ messages in thread]
Slow performance after restoring a dump
2018-03-19 15:13 UTC David Osborne <david@qcode.co.uk>
` Re: Slow performance after restoring a dump
2018-03-19 15:35 UTC Tom Lane <tgl@sss.pgh.pa.us>
` Re: Slow performance after restoring a dump
2018-03-19 15:43 UTC David Osborne <david@qcode.co.uk>
` Re: Slow performance after restoring a dump
2018-03-19 16:22 UTC Tom Lane <tgl@sss.pgh.pa.us>
` Re: Slow performance after restoring a dump
2018-03-19 16:33 UTC David Osborne <david@qcode.co.uk>
[5+ messages in thread]
Irrelevant columns cause massive performance change
2018-03-16 20:37 UTC Craig James <cjames@emolecules.com>
` Re: Irrelevant columns cause massive performance change
2018-03-16 20:50 UTC Andres Freund <andres@anarazel.de>
` Re: Irrelevant columns cause massive performance change
2018-03-16 21:06 UTC Craig James <cjames@emolecules.com>
[3+ messages in thread]
Too many .history file in pg_xlog takes lots of space
2018-03-14 02:31 UTC 彭昱傑 <k872892@gmail.com>
` Re: Too many .history file in pg_xlog takes lots of space
2018-03-14 05:56 UTC Laurenz Albe <laurenz.albe@cybertec.at>
` Re: Too many .history file in pg_xlog takes lots of space
2018-03-14 06:12 UTC 彭昱傑 <k872892@gmail.com>
` Re: Too many .history file in pg_xlog takes lots of space
2018-03-14 07:04 UTC Michael Paquier <michael@paquier.xyz>
` Re: Too many .history file in pg_xlog takes lots of space
2018-03-14 13:49 UTC Alvaro Herrera <alvherre@alvh.no-ip.org>
` Re: Too many .history file in pg_xlog takes lots of space
2018-03-14 15:29 UTC Tom Lane <tgl@sss.pgh.pa.us>
` Re: Too many .history file in pg_xlog takes lots of space
2018-03-15 10:22 UTC 彭昱傑 <k872892@gmail.com>
[7+ messages in thread]
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]
[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