pg.ddx.io pgsql-performance@postgresql.org mailing list archive
help / color / mirror / Atom feedDo work_mem and shared buffers have 1g or 2g limit on 64 bit linux?
2015-06-13 17:27 UTC Kaijiang Chen <chenkaijiang@gmail.com>
` Re: Do work_mem and shared buffers have 1g or 2g limit on 64 bit linux?
2015-06-13 17:43 UTC Joshua D. Drake <jd@commandprompt.com>
` Re: Do work_mem and shared buffers have 1g or 2g limit on 64 bit linux?
2015-06-13 18:10 UTC Joe Conway <mail@joeconway.com>
` Re: Do work_mem and shared buffers have 1g or 2g limit on 64 bit linux?
2015-06-15 03:44 UTC Kaijiang Chen <chenkaijiang@gmail.com>
` Re: Do work_mem and shared buffers have 1g or 2g limit on 64 bit linux?
2015-06-15 14:57 UTC Tomas Vondra <tomas.vondra@2ndquadrant.com>
[5+ messages in thread]
Slow query: Postgres chooses nested loop over hash join, whery by hash join is much faster, wrong number of rows estimated
2015-06-12 00:18 UTC Sasa Vilic <sasavilic@gmail.com>
` Re: Slow query: Postgres chooses nested loop over hash join, whery by hash join is much faster, wrong number of rows estimated
2015-06-15 14:25 UTC Merlin Moncure <mmoncure@gmail.com>
[2+ messages in thread]
pg bouncer issue what does sv_used column means
2015-06-12 17:57 UTC Sheena, Prabhjot <Prabhjot.Singh@classmates.com>
` Re: pg bouncer issue what does sv_used column means
2015-06-12 19:01 UTC Glyn Astill <glynastill@yahoo.co.uk>
` Re: pg bouncer issue what does sv_used column means
2015-06-12 20:26 UTC Xenofon Papadopoulos <xpapad@gmail.com>
` Re: pg bouncer issue what does sv_used column means
2015-06-12 21:37 UTC Sheena, Prabhjot <Prabhjot.Singh@classmates.com>
` Re: pg bouncer issue what does sv_used column means
2015-06-12 21:49 UTC Andrew Dunstan <andrew@dunslane.net>
` Re: pg bouncer issue what does sv_used column means
2015-06-12 21:57 UTC ktm@rice.edu <ktm@rice.edu>
[6+ messages in thread]
Are there tuning parameters that don't take effect immediately?
2015-06-12 20:37 UTC Michael Nolan <htfoot@gmail.com>
` Re: Are there tuning parameters that don't take effect immediately?
2015-06-12 20:52 UTC David G. Johnston <david.g.johnston@gmail.com>
` Re: Are there tuning parameters that don't take effect immediately?
2015-06-12 21:00 UTC Joshua D. Drake <jd@commandprompt.com>
` Re: Are there tuning parameters that don't take effect immediately?
2015-06-12 21:13 UTC Michael Nolan <htfoot@gmail.com>
[4+ messages in thread]
Slow query - lots of temporary files.
2015-06-10 12:39 UTC Johann Spies <johann.spies@gmail.com>
` Re: Slow query - lots of temporary files.
2015-06-10 13:02 UTC Claudio Freire <klaussfreire@gmail.com>
` Re: Slow query - lots of temporary files.
2015-06-10 13:42 UTC Johann Spies <johann.spies@gmail.com>
` Re: Slow query - lots of temporary files.
2015-06-10 14:50 UTC Tomas Vondra <tomas.vondra@2ndquadrant.com>
` Re: Slow query - lots of temporary files.
2015-06-12 15:04 UTC Johann Spies <johann.spies@gmail.com>
[5+ messages in thread]
How to reduce writing on disk ? (90 gb on pgsql_tmp)
2015-06-03 12:21 UTC ben.play <benjamin.cohen@playrion.com>
` Re: How to reduce writing on disk ? (90 gb on pgsql_tmp)
2015-06-03 12:44 UTC David G. Johnston <david.g.johnston@gmail.com>
` Re: How to reduce writing on disk ? (90 gb on pgsql_tmp)
2015-06-03 13:11 UTC amulsul <sul_amul@yahoo.co.in>
` Re: How to reduce writing on disk ? (90 gb on pgsql_tmp)
2015-06-03 13:27 UTC chiru r <chirupg@gmail.com>
` Re: How to reduce writing on disk ? (90 gb on pgsql_tmp)
2015-06-03 13:51 UTC Tomas Vondra <tomas.vondra@2ndquadrant.com>
` Re: How to reduce writing on disk ? (90 gb on pgsql_tmp)
2015-06-03 14:06 UTC ben.play <benjamin.cohen@playrion.com>
` Re: How to reduce writing on disk ? (90 gb on pgsql_tmp)
2015-06-03 14:56 UTC Tomas Vondra <tomas.vondra@2ndquadrant.com>
` Re: How to reduce writing on disk ? (90 gb on pgsql_tmp)
2015-06-03 15:09 UTC Scott Marlowe <scott.marlowe@gmail.com>
` Re: How to reduce writing on disk ? (90 gb on pgsql_tmp)
2015-06-03 17:06 UTC Claudio Freire <klaussfreire@gmail.com>
` Re: How to reduce writing on disk ? (90 gb on pgsql_tmp)
2015-06-03 19:24 UTC Tomas Vondra <tomas.vondra@2ndquadrant.com>
` Re: How to reduce writing on disk ? (90 gb on pgsql_tmp)
2015-06-03 21:18 UTC Scott Marlowe <scott.marlowe@gmail.com>
` Re: How to reduce writing on disk ? (90 gb on pgsql_tmp)
2015-06-03 21:58 UTC Claudio Freire <klaussfreire@gmail.com>
` Re: How to reduce writing on disk ? (90 gb on pgsql_tmp)
2015-06-03 22:16 UTC Tomas Vondra <tomas.vondra@2ndquadrant.com>
` Re: How to reduce writing on disk ? (90 gb on pgsql_tmp)
2015-06-03 22:29 UTC Joshua D. Drake <jd@commandprompt.com>
` Re: How to reduce writing on disk ? (90 gb on pgsql_tmp)
2015-06-03 23:54 UTC Yves Dorfsman <yves@zioup.com>
` Re: How to reduce writing on disk ? (90 gb on pgsql_tmp)
2015-06-04 00:22 UTC Tomas Vondra <tomas.vondra@2ndquadrant.com>
` Re: How to reduce writing on disk ? (90 gb on pgsql_tmp)
2015-06-04 00:53 UTC Scott Marlowe <scott.marlowe@gmail.com>
` Re: How to reduce writing on disk ? (90 gb on pgsql_tmp)
2015-06-04 00:58 UTC Scott Marlowe <scott.marlowe@gmail.com>
` Re: How to reduce writing on disk ? (90 gb on pgsql_tmp)
2015-06-04 01:19 UTC Mark Kirkwood <mark.kirkwood@catalyst.net.nz>
` Re: How to reduce writing on disk ? (90 gb on pgsql_tmp)
2015-06-04 14:43 UTC Tomas Vondra <tomas.vondra@2ndquadrant.com>
` Re: How to reduce writing on disk ? (90 gb on pgsql_tmp)
2015-06-09 15:58 UTC ben.play <benjamin.cohen@playrion.com>
` Re: How to reduce writing on disk ? (90 gb on pgsql_tmp)
2015-06-09 16:04 UTC Claudio Freire <klaussfreire@gmail.com>
` Re: How to reduce writing on disk ? (90 gb on pgsql_tmp)
2015-06-11 08:56 UTC ben.play <benjamin.cohen@playrion.com>
` Re: How to reduce writing on disk ? (90 gb on pgsql_tmp)
2015-06-11 12:48 UTC Claudio Freire <klaussfreire@gmail.com>
[24+ messages in thread]
Row estimates off by two orders of magnitude with hstore
2015-06-10 17:32 UTC Patrick Krecker <patrick@judicata.com>
` Re: Row estimates off by two orders of magnitude with hstore
2015-06-10 18:32 UTC Merlin Moncure <mmoncure@gmail.com>
` Re: Row estimates off by two orders of magnitude with hstore
2015-06-10 19:40 UTC Josh Berkus <josh@agliodbs.com>
` Re: Row estimates off by two orders of magnitude with hstore
2015-06-10 20:01 UTC Merlin Moncure <mmoncure@gmail.com>
` Re: Row estimates off by two orders of magnitude with hstore
2015-06-10 20:55 UTC Patrick Krecker <patrick@judicata.com>
` Re: Row estimates off by two orders of magnitude with hstore
2015-06-10 21:08 UTC Merlin Moncure <mmoncure@gmail.com>
` Re: Row estimates off by two orders of magnitude with hstore
2015-06-10 21:37 UTC Patrick Krecker <patrick@judicata.com>
` Re: Row estimates off by two orders of magnitude with hstore
2015-06-10 22:08 UTC Merlin Moncure <mmoncure@gmail.com>
[8+ messages in thread]
Query running slow for only one specific id. (Postgres 9.3) version
2015-06-05 17:54 UTC Sheena, Prabhjot <Prabhjot.Singh@classmates.com>
` Re: Query running slow for only one specific id. (Postgres 9.3) version
2015-06-05 18:05 UTC Igor Neyman <ineyman@perceptron.com>
` Re: Query running slow for only one specific id. (Postgres 9.3) version
2015-06-05 18:24 UTC Steve Crawford <scrawford@pinpointresearch.com>
` Re: Query running slow for only one specific id. (Postgres 9.3) version
2015-06-05 18:38 UTC Sheena, Prabhjot <Prabhjot.Singh@classmates.com>
` Re: Query running slow for only one specific id. (Postgres 9.3) version
2015-06-05 18:46 UTC Igor Neyman <ineyman@perceptron.com>
` Re: Re: Query running slow for only one specific id. (Postgres 9.3) version
2015-06-05 19:28 UTC Steve Crawford <scrawford@pinpointresearch.com>
` Re: Re: [GENERAL] Re: Query running slow for only one specific id. (Postgres 9.3) version
2015-06-05 19:34 UTC Steve Crawford <scrawford@pinpointresearch.com>
` Re: [PERFORM] Query running slow for only one specific id. (Postgres 9.3) version
2015-06-05 22:34 UTC Matheus de Oliveira <matioli.matheus@gmail.com>
[8+ messages in thread]
Need more IOPS? This should get you drooling... (5xnvme drives)
2015-06-04 11:07 UTC Graeme B. Bell <grb@skogoglandskap.no>
` Re: Need more IOPS? This should get you drooling... (5xnvme drives)
2015-06-04 11:23 UTC Graeme B. Bell <grb@skogoglandskap.no>
` Re: Need more IOPS? This should get you drooling... (5xnvme drives)
2015-06-04 11:29 UTC Dorian Hoxha <dorian.hoxha@gmail.com>
` Re: Need more IOPS? This should get you drooling... (5xnvme drives)
2015-06-04 11:35 UTC Graeme B. Bell <grb@skogoglandskap.no>
[4+ messages in thread]
Postgres is using 100% CPU
2015-05-29 16:40 UTC Ashik S L <ashiksl178@gmail.com>
` Re: Postgres is using 100% CPU
2015-05-29 17:17 UTC Tomas Vondra <tomas.vondra@2ndquadrant.com>
` Re: Postgres is using 100% CPU
2015-05-29 17:18 UTC Tomas Vondra <tomas.vondra@2ndquadrant.com>
` Fwd: Postgres is using 100% CPU
2015-05-29 17:57 UTC Ashik S L <ashiksl178@gmail.com>
` Postgres is using 100% CPU
2015-05-29 18:10 UTC Ashik S L <ashiksl178@gmail.com>
` Re: Postgres is using 100% CPU
2015-05-29 18:30 UTC Yves Dorfsman <yves@zioup.com>
` Re: Postgres is using 100% CPU
2015-05-29 19:20 UTC Tomas Vondra <tomas.vondra@2ndquadrant.com>
` Re: Postgres is using 100% CPU
2015-05-30 13:46 UTC Ashik S L <ashiksl178@gmail.com>
` Re: Postgres is using 100% CPU
2015-05-30 14:20 UTC Tomas Vondra <tomas.vondra@2ndquadrant.com>
` Re: Postgres is using 100% CPU
2015-05-31 13:04 UTC Jean-David Beyer <jeandavid8@verizon.net>
` Re: Postgres is using 100% CPU
2015-05-31 14:23 UTC Yves Dorfsman <yves@zioup.com>
` Re: Postgres is using 100% CPU
2015-06-01 05:38 UTC Ashik S L <ashiksl178@gmail.com>
` Re: Postgres is using 100% CPU
2015-06-01 13:20 UTC Merlin Moncure <mmoncure@gmail.com>
` Re: Postgres is using 100% CPU
2015-06-01 19:35 UTC Scott Marlowe <scott.marlowe@gmail.com>
` Re: Postgres is using 100% CPU
2015-06-02 07:47 UTC Graeme B. Bell <grb@skogoglandskap.no>
` Re: Postgres is using 100% CPU
2015-06-02 07:58 UTC Graeme B. Bell <grb@skogoglandskap.no>
` Re: Postgres is using 100% CPU
2015-06-02 08:20 UTC Ashik S L <ashiksl178@gmail.com>
[17+ messages in thread]
Connection time when using SSL
2015-06-01 20:51 UTC Marco Di Cesare <Marco.DiCesare@pointclickcare.com>
` Re: Connection time when using SSL
2015-06-01 21:21 UTC Tomas Vondra <tomas.vondra@2ndquadrant.com>
[2+ messages in thread]
Fastest way / best practice to calculate "next birthdays"
2008-05-04 12:29 UTC Hannes Dorbath <light@theendofthetunnel.de>
` Re: Fastest way / best practice to calculate "next birthdays"
2008-05-04 16:11 UTC Joshua D. Drake <jd@commandprompt.com>
` Re: Fastest way / best practice to calculate "next birthdays"
2008-05-04 17:50 UTC Hannes Dorbath <light@theendofthetunnel.de>
` Re: Fastest way / best practice to calculate "next birthdays"
2008-05-04 19:05 UTC Zoltan Boszormenyi <zb@cybertec.at>
` Re: Fastest way / best practice to calculate "next birthdays"
2008-05-05 05:41 UTC Shane Ambler <pgsql@Sheeky.Biz>
` Re: Fastest way / best practice to calculate "next birthdays"
2015-05-18 09:30 UTC er.tejaspatel88@gmail.com <er.tejaspatel88@gmail.com>
` Re: Fastest way / best practice to calculate "next birthdays"
2015-05-21 03:22 UTC David G. Johnston <david.g.johnston@gmail.com>
` Re: Fastest way / best practice to calculate "next birthdays"
2015-05-21 16:15 UTC Bosco Rama <postgres@boscorama.com>
` Re: Fastest way / best practice to calculate "next birthdays"
2015-05-21 16:50 UTC David G. Johnston <david.g.johnston@gmail.com>
` Re: Fastest way / best practice to calculate "next birthdays"
2015-05-22 21:23 UTC Jim Nasby <Jim.Nasby@BlueTreble.com>
` Re: Fastest way / best practice to calculate "next birthdays"
2015-06-01 19:11 UTC Kevin Grittner <kgrittn@ymail.com>
[11+ messages in thread]
Slow hash join performance with many batches
2015-06-01 16:03 UTC Alex Adriaanse <alex@oseberg.io>
` Re: Slow hash join performance with many batches
2015-06-01 17:58 UTC Tom Lane <tgl@sss.pgh.pa.us>
[2+ messages in thread]
Postmaster eating up all my cpu
2015-05-28 11:25 UTC birimblongas <bianca.stephani@gmail.com>
` Re: Postmaster eating up all my cpu
2015-05-30 20:45 UTC Tomas Vondra <tomas.vondra@2ndquadrant.com>
[2+ messages in thread]
Partitioning and performance
2015-05-28 14:31 UTC Ravi Krishna <sravikrishna3@gmail.com>
` Re: Partitioning and performance
2015-05-28 14:41 UTC Ravi Krishna <sravikrishna3@gmail.com>
` Re: Partitioning and performance
2015-05-28 18:05 UTC Jim Nasby <Jim.Nasby@BlueTreble.com>
[3+ messages in thread]
Fastest Backup & Restore for perf testing
2015-05-27 20:24 UTC Wes Vaske (wvaske) <wvaske@micron.com>
` Re: Fastest Backup & Restore for perf testing
2015-05-27 20:37 UTC Andrew Dunstan <andrew@dunslane.net>
` Re: Fastest Backup & Restore for perf testing
2015-05-27 20:39 UTC Steve Atkins <steve@blighty.com>
` Re: Fastest Backup & Restore for perf testing
2015-05-28 17:40 UTC Jim Nasby <Jim.Nasby@BlueTreble.com>
[4+ messages in thread]
ERROR: missing chunk number 0 for toast value 1821556134 in pg_toast_17881
2015-05-27 07:50 UTC Tory M Blue <tmblue@gmail.com>
` Re: ERROR: missing chunk number 0 for toast value 1821556134 in pg_toast_17881
2015-05-27 22:02 UTC Josh Berkus <josh@agliodbs.com>
[2+ messages in thread]
MAX() and multi-column index on a partitioned table?
2015-05-22 22:27 UTC Dave Johansen <davejohansen@gmail.com>
` Re: MAX() and multi-column index on a partitioned table?
2015-05-22 22:42 UTC Tom Lane <tgl@sss.pgh.pa.us>
` Re: MAX() and multi-column index on a partitioned table?
2015-05-22 23:53 UTC Dave Johansen <davejohansen@gmail.com>
` Re: MAX() and multi-column index on a partitioned table?
2015-05-23 01:13 UTC Tom Lane <tgl@sss.pgh.pa.us>
[4+ messages in thread]
How to clean/truncate / VACUUM FULL pg_largeobject without (much) downtime?
2015-05-11 09:55 UTC Muthusamy, Sivaraman <sivaraman.muthusamy@in.verizon.com>
` Re: How to clean/truncate / VACUUM FULL pg_largeobject without (much) downtime?
2015-05-22 21:17 UTC Jim Nasby <Jim.Nasby@BlueTreble.com>
[2+ messages in thread]
PostgreSQL disk fragmentation causes performance problems on Windows
2015-04-23 19:47 UTC Jan Gunnar Dyrset <jan.g.dyrset@cybernetica.no>
` Re: PostgreSQL disk fragmentation causes performance problems on Windows
2015-04-29 08:06 UTC Andres Freund <andres@anarazel.de>
` Re: PostgreSQL disk fragmentation causes performance problems on Windows
2015-04-29 08:08 UTC Andres Freund <andres@anarazel.de>
` Re: PostgreSQL disk fragmentation causes performance problems on Windows
2015-04-29 14:07 UTC Joshua D. Drake <jd@commandprompt.com>
` Re: PostgreSQL disk fragmentation causes performance problems on Windows
2015-04-29 14:35 UTC ktm@rice.edu <ktm@rice.edu>
` Re: PostgreSQL disk fragmentation causes performance problems on Windows
2015-04-29 14:56 UTC Andrew Dunstan <andrew@dunslane.net>
` Re: PostgreSQL disk fragmentation causes performance problems on Windows
2015-05-21 18:54 UTC Josh Berkus <josh@agliodbs.com>
` Re: PostgreSQL disk fragmentation causes performance problems on Windows
2015-05-21 20:39 UTC Andres Freund <andres@anarazel.de>
` Re: PostgreSQL disk fragmentation causes performance problems on Windows
2015-05-21 23:16 UTC Vitalii Tymchyshyn <vit@tym.im>
` Re: PostgreSQL disk fragmentation causes performance problems on Windows
2015-05-22 17:34 UTC Josh Berkus <josh@agliodbs.com>
[10+ messages in thread]
union all and filter / index scan -> seq scan
2015-05-21 10:41 UTC Florian Lohoff <f@zz.de>
` Re: union all and filter / index scan -> seq scan
2015-05-21 15:09 UTC Vitalii Tymchyshyn <vit@tym.im>
` Re: union all and filter / index scan -> seq scan
2015-05-21 15:28 UTC Tom Lane <tgl@sss.pgh.pa.us>
[3+ messages in thread]
optimization join on random value
2015-05-03 21:23 UTC Anton Bushmelev <djeday84@gmail.com>
` Re: optimization join on random value
2015-05-03 21:28 UTC Heikki Linnakangas <hlinnaka@iki.fi>
[2+ messages in thread]
Index Scan Backward Slow
2015-05-01 10:54 UTC David Osborne <david@qcode.co.uk>
` Re: Index Scan Backward Slow
2015-05-01 10:59 UTC Evgeniy Shishkin <itparanoia@gmail.com>
` Re: Index Scan Backward Slow
2015-05-01 11:06 UTC David Osborne <david@qcode.co.uk>
` Re: Index Scan Backward Slow
2015-05-02 08:48 UTC Robert Klemme <shortcutter@googlemail.com>
[4+ messages in thread]
Query plan with missing timespans
2015-04-22 17:37 UTC Andomar <andomar@aule.net>
` Re: Query plan with missing timespans
2015-04-22 19:47 UTC Kevin Grittner <kgrittn@ymail.com>
` Re: Query plan with missing timespans
2015-04-22 19:59 UTC Andomar <andomar@aule.net>
` Re: Query plan with missing timespans
2015-04-22 20:18 UTC Jason Petersen <jason@citusdata.com>
` Re: Query plan with missing timespans
2015-04-23 04:40 UTC Kyotaro HORIGUCHI <horiguchi.kyotaro@lab.ntt.co.jp>
[5+ messages in thread]
Postgresql Host Swapping Hard With Abundant Free Memory
2015-04-17 18:25 UTC Christian Gough <brukshut@gmail.com>
` Re: Postgresql Host Swapping Hard With Abundant Free Memory
2015-04-22 23:33 UTC Jim Nasby <Jim.Nasby@BlueTreble.com>
[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