pg.ddx.io pgsql-performance@postgresql.org mailing list archive
help / color / mirror / Atom feedquery partitioned table is very slow
2015-10-16 22:02 UTC Vladimir Yavoskiy <vovka@krevedko.su>
` Re: query partitioned table is very slow
2015-10-16 23:02 UTC Tom Lane <tgl@sss.pgh.pa.us>
[2+ messages in thread]
Having some problems with concurrent COPY commands
2015-10-12 18:17 UTC Shaun Thomas <bonesmoses@gmail.com>
` Re: Having some problems with concurrent COPY commands
2015-10-12 18:28 UTC Andres Freund <andres@anarazel.de>
` Re: Having some problems with concurrent COPY commands
2015-10-12 18:56 UTC Jeff Janes <jeff.janes@gmail.com>
` Re: Having some problems with concurrent COPY commands
2015-10-12 20:14 UTC Shaun Thomas <bonesmoses@gmail.com>
` Re: Having some problems with concurrent COPY commands
2015-10-13 09:32 UTC Heikki Linnakangas <hlinnaka@iki.fi>
` Re: Having some problems with concurrent COPY commands
2015-10-13 14:14 UTC Shaun Thomas <bonesmoses@gmail.com>
` Re: Having some problems with concurrent COPY commands
2015-10-13 14:23 UTC Andres Freund <andres@anarazel.de>
` Re: Having some problems with concurrent COPY commands
2015-10-13 19:33 UTC Shaun Thomas <bonesmoses@gmail.com>
` Re: Having some problems with concurrent COPY commands
2015-10-13 21:44 UTC David Rowley <david.rowley@2ndquadrant.com>
[9+ messages in thread]
V8 optimisation (if you're using javascript in postgres)
2015-10-13 08:47 UTC Graeme B. Bell <graeme.bell@nibio.no>
3000x Slower query when using Foreign Data Wrapper vs. local
2015-10-11 08:05 UTC Mohammad Habbab <moh.habbab@gmail.com>
` Re: 3000x Slower query when using Foreign Data Wrapper vs. local
2015-10-11 09:42 UTC desmodemone <desmodemone@gmail.com>
` Re: 3000x Slower query when using Foreign Data Wrapper vs. local
2015-10-11 10:10 UTC Mohammad Habbab <moh.habbab@gmail.com>
` Re: 3000x Slower query when using Foreign Data Wrapper vs. local
2015-10-11 10:48 UTC desmodemone <desmodemone@gmail.com>
` Re: 3000x Slower query when using Foreign Data Wrapper vs. local
2015-10-11 10:58 UTC Mohammad Habbab <moh.habbab@gmail.com>
[5+ messages in thread]
LIMIT 1 poor query plan
2015-10-10 08:52 UTC Marcio Ribeiro <mribeiro@gmail.com>
` Re: LIMIT 1 poor query plan
2015-10-10 15:45 UTC Tom Lane <tgl@sss.pgh.pa.us>
` Re: LIMIT 1 poor query plan
2015-10-10 17:45 UTC Marcio Ribeiro <mribeiro@gmail.com>
[3+ messages in thread]
Multi processor server overloads occationally with system process while running postgresql-9.4
2015-10-03 08:39 UTC ajaykbs <ajayakumarbs@gmail.com>
` Re: Multi processor server overloads occationally with system process while running postgresql-9.4
2015-10-03 09:03 UTC Gavin Flower <GavinFlower@archidevsys.co.nz>
` Re: Multi processor server overloads occationally with system process while running postgresql-9.4
2015-10-03 09:15 UTC Wei Shan <weishan.ang@gmail.com>
` Re: Multi processor server overloads occationally with system process while running postgresql-9.4
2015-10-03 09:26 UTC Andres Freund <andres@anarazel.de>
` Re: Multi processor server overloads occationally with system process while running postgresql-9.4
2015-10-03 09:34 UTC ajaykbs <ajayakumarbs@gmail.com>
` Re: Multi processor server overloads occationally with system process while running postgresql-9.4
2015-10-07 05:08 UTC ajaykbs <ajayakumarbs@gmail.com>
` Re: Re: Multi processor server overloads occationally with system process while running postgresql-9.4
2015-10-07 08:31 UTC Scott Marlowe <scott.marlowe@gmail.com>
` Re: Re: Multi processor server overloads occationally with system process while running postgresql-9.4
2015-10-09 13:01 UTC Kevin Grittner <kgrittn@ymail.com>
[8+ messages in thread]
large object write performance
2015-10-08 09:17 UTC Bram Van Steenlandt <bram@diomedia.be>
` Re: large object write performance
2015-10-08 09:45 UTC Graeme B. Bell <graeme.bell@nibio.no>
` Re: large object write performance
2015-10-08 10:25 UTC Graeme B. Bell <graeme.bell@nibio.no>
` Re: large object write performance
2015-10-08 11:21 UTC Graeme B. Bell <graeme.bell@nibio.no>
` Re: large object write performance
2015-10-08 11:33 UTC Bram Van Steenlandt <bram@diomedia.be>
` Re: large object write performance
2015-10-08 11:37 UTC Graeme B. Bell <graeme.bell@nibio.no>
` Re: large object write performance
2015-10-08 11:50 UTC Bram Van Steenlandt <bram@diomedia.be>
` Re: large object write performance
2015-10-08 12:09 UTC Bram Van Steenlandt <bram@diomedia.be>
` Re: large object write performance
2015-10-08 12:10 UTC Graeme B. Bell <graeme.bell@nibio.no>
` Re: large object write performance
2015-10-08 12:29 UTC Bram Van Steenlandt <bram@diomedia.be>
` Re: large object write performance
2015-10-08 13:10 UTC Graeme B. Bell <graeme.bell@nibio.no>
` Re: large object write performance
2015-10-08 14:13 UTC Bram Van Steenlandt <bram@diomedia.be>
[12+ messages in thread]
shared-buffers set to 24GB but the RAM only use 4-5 GB average
2015-10-05 14:51 UTC FattahRozzaq <ssoorruu@gmail.com>
` Re: shared-buffers set to 24GB but the RAM only use 4-5 GB average
2015-10-05 16:29 UTC Merlin Moncure <mmoncure@gmail.com>
` Re: shared-buffers set to 24GB but the RAM only use 4-5 GB average
2015-10-05 18:24 UTC Igor Neyman <ineyman@perceptron.com>
` Re: shared-buffers set to 24GB but the RAM only use 4-5 GB average
2015-10-05 18:29 UTC Igor Neyman <ineyman@perceptron.com>
` Re: shared-buffers set to 24GB but the RAM only use 4-5 GB average
2015-10-06 09:33 UTC FattahRozzaq <ssoorruu@gmail.com>
` Re: shared-buffers set to 24GB but the RAM only use 4-5 GB average
2015-10-06 15:10 UTC Scott Marlowe <scott.marlowe@gmail.com>
` Re: shared-buffers set to 24GB but the RAM only use 4-5 GB average
2015-10-06 20:35 UTC Merlin Moncure <mmoncure@gmail.com>
` Re: shared-buffers set to 24GB but the RAM only use 4-5 GB average
2015-10-07 05:35 UTC Josh Berkus <josh@agliodbs.com>
` Re: shared-buffers set to 24GB but the RAM only use 4-5 GB average
2015-10-07 10:29 UTC FattahRozzaq <ssoorruu@gmail.com>
` Re: shared-buffers set to 24GB but the RAM only use 4-5 GB average
2015-10-07 13:01 UTC Scott Marlowe <scott.marlowe@gmail.com>
` Re: shared-buffers set to 24GB but the RAM only use 4-5 GB average
2015-10-07 13:59 UTC Merlin Moncure <mmoncure@gmail.com>
[11+ messages in thread]
Queries Per Second (QPS)
2015-09-26 16:24 UTC Adam Scott <adam.c.scott@gmail.com>
` Re: Queries Per Second (QPS)
2015-09-27 06:02 UTC Guillaume Lelarge <guillaume@lelarge.info>
` Re: Queries Per Second (QPS)
2015-09-27 06:06 UTC Guillaume Lelarge <guillaume@lelarge.info>
` Re: Queries Per Second (QPS)
2015-09-27 17:34 UTC Jeff Janes <jeff.janes@gmail.com>
` Re: Queries Per Second (QPS)
2015-09-30 17:06 UTC Josh Berkus <josh@agliodbs.com>
[5+ messages in thread]
dump restoration performance
2015-09-25 13:43 UTC rlemaroi <remi.le-marois@capgemini.com>
` Re: dump restoration performance
2015-09-30 02:38 UTC Michael Paquier <michael.paquier@gmail.com>
[2+ messages in thread]
Performance problem with gin index
2015-09-29 15:45 UTC Bertrand Paquet <bertrand.paquet@doctolib.fr>
` Re: Performance problem with gin index
2015-09-29 16:12 UTC ktm@rice.edu <ktm@rice.edu>
` Re: Performance problem with gin index
2015-09-29 17:17 UTC Jeff Janes <jeff.janes@gmail.com>
` Re: Performance problem with gin index
2015-09-29 20:51 UTC Bertrand Paquet <bertrand.paquet@doctolib.fr>
[4+ messages in thread]
Another parallel postgres project...
2015-09-29 08:41 UTC Graeme B. Bell <graeme.bell@nibio.no>
` Re: Another parallel postgres project...
2015-09-29 16:25 UTC Corey Huinker <corey.huinker@gmail.com>
[2+ messages in thread]
Occasional Really Slow Running Updates/Inserts
2015-09-17 19:14 UTC Dave Stibrany <dstibrany@gmail.com>
` Re: Occasional Really Slow Running Updates/Inserts
2015-09-17 20:12 UTC ktm@rice.edu <ktm@rice.edu>
` Re: Occasional Really Slow Running Updates/Inserts
2015-09-17 22:14 UTC Dave Stibrany <dstibrany@gmail.com>
[3+ messages in thread]
degrading inser performance
2015-09-17 11:32 UTC Eildert Groeneveld <eildert.groeneveld@fli.bund.de>
` Re: degrading inser performance
2015-09-17 12:11 UTC Ladislav Lenart <lenartlad@volny.cz>
` Re: degrading inser performance
2015-09-17 12:19 UTC Eildert Groeneveld <eildert.groeneveld@fli.bund.de>
` Re: degrading inser performance
2015-09-17 14:21 UTC Matheus de Oliveira <matioli.matheus@gmail.com>
` Re: degrading inser performance
2015-09-17 14:41 UTC Eildert Groeneveld <eildert.groeneveld@fli.bund.de>
` Re: degrading inser performance
2015-09-17 20:13 UTC Dave Cramer <pg@fastcrypt.com>
[6+ messages in thread]
VACUUM VERBOSE ANALYZE taking long time to process.
2015-09-09 10:43 UTC anil7385 <anilnk7385@gmail.com>
` Re: VACUUM VERBOSE ANALYZE taking long time to process.
2015-09-15 23:52 UTC Ben Chobot <bench@silentmedia.com>
[2+ messages in thread]
Server slowing down over time
2015-08-27 17:21 UTC Jean Cavallo <jean.cavallo@coopengo.com>
` Re: Server slowing down over time
2015-09-03 13:07 UTC Igor Neyman <ineyman@perceptron.com>
` Re: Server slowing down over time
2015-09-04 06:13 UTC Wei Shan <weishan.ang@gmail.com>
` Re: Server slowing down over time
2015-09-04 11:59 UTC Tomas Vondra <tomas.vondra@2ndquadrant.com>
` Re: Server slowing down over time
2015-09-14 22:08 UTC Jim Nasby <Jim.Nasby@BlueTreble.com>
[5+ messages in thread]
Announcing the public availability of the TPCx-V prototype
2015-09-10 18:59 UTC Reza Taheri <rtaheri@vmware.com>
pg_stat_all_indexes understand
2015-07-09 12:20 UTC Nicolas Paris <niparisco@gmail.com>
` Re: pg_stat_all_indexes understand
2015-07-09 16:45 UTC Jeff Janes <jeff.janes@gmail.com>
` Re: pg_stat_all_indexes understand
2015-09-09 21:51 UTC Bruce Momjian <bruce@momjian.us>
[3+ messages in thread]
query with pg_trgm sometimes very slow
2015-09-02 14:00 UTC Volker Böhm <volker@vboehm.de>
` Re: query with pg_trgm sometimes very slow
2015-09-02 19:29 UTC Jeff Janes <jeff.janes@gmail.com>
` Re: query with pg_trgm sometimes very slow
2015-09-03 23:19 UTC Claudio Freire <klaussfreire@gmail.com>
` Re: query with pg_trgm sometimes very slow
2015-09-08 19:15 UTC Merlin Moncure <mmoncure@gmail.com>
` Re: query with pg_trgm sometimes very slow
2015-09-08 21:21 UTC Tomas Vondra <tomas.vondra@2ndquadrant.com>
` Re: query with pg_trgm sometimes very slow
2015-09-08 21:24 UTC Merlin Moncure <mmoncure@gmail.com>
[6+ messages in thread]
Re: Allow a per-tablespace effective_io_concurrency setting
2015-09-02 13:53 UTC Andres Freund <andres@anarazel.de>
` Re: Allow a per-tablespace effective_io_concurrency setting
2015-09-02 16:06 UTC Tomas Vondra <tomas.vondra@2ndquadrant.com>
` Re: Allow a per-tablespace effective_io_concurrency setting
2015-09-02 16:45 UTC Andres Freund <andres@anarazel.de>
` Re: Allow a per-tablespace effective_io_concurrency setting
2015-09-02 18:49 UTC Greg Stark <stark@mit.edu>
` Re: Allow a per-tablespace effective_io_concurrency setting
2015-09-02 19:12 UTC Julien Rouhaud <julien.rouhaud@dalibo.com>
` Re: Allow a per-tablespace effective_io_concurrency setting
2015-09-02 20:21 UTC Julien Rouhaud <julien.rouhaud@dalibo.com>
` Re: Allow a per-tablespace effective_io_concurrency setting
2015-09-02 21:25 UTC Tomas Vondra <tomas.vondra@2ndquadrant.com>
` Re: Allow a per-tablespace effective_io_concurrency setting
2015-09-02 21:31 UTC Josh Berkus <josh@agliodbs.com>
` Re: Allow a per-tablespace effective_io_concurrency setting
2015-09-02 21:58 UTC Merlin Moncure <mmoncure@gmail.com>
` Re: Allow a per-tablespace effective_io_concurrency setting
2015-09-02 22:10 UTC Jeff Janes <jeff.janes@gmail.com>
` Re: Allow a per-tablespace effective_io_concurrency setting
2015-09-02 22:23 UTC Andres Freund <andres@anarazel.de>
` Re: Allow a per-tablespace effective_io_concurrency setting
2015-09-02 22:38 UTC Andres Freund <andres@anarazel.de>
` Re: Allow a per-tablespace effective_io_concurrency setting
2015-09-02 23:59 UTC Tomas Vondra <tomas.vondra@2ndquadrant.com>
` Re: Allow a per-tablespace effective_io_concurrency setting
2015-09-03 00:24 UTC Andres Freund <andres@anarazel.de>
` Re: Allow a per-tablespace effective_io_concurrency setting
2015-09-03 01:44 UTC Greg Stark <stark@mit.edu>
` Re: Allow a per-tablespace effective_io_concurrency setting
2015-09-03 13:13 UTC Merlin Moncure <mmoncure@gmail.com>
` Re: Allow a per-tablespace effective_io_concurrency setting
2015-09-04 16:21 UTC Greg Stark <stark@mit.edu>
` Re: Allow a per-tablespace effective_io_concurrency setting
2015-09-04 16:23 UTC Bruce Momjian <bruce@momjian.us>
` Re: Allow a per-tablespace effective_io_concurrency setting
2015-09-04 16:37 UTC Andres Freund <andres@anarazel.de>
` Re: Allow a per-tablespace effective_io_concurrency setting
2015-09-05 18:12 UTC Merlin Moncure <mmoncure@gmail.com>
` Re: Allow a per-tablespace effective_io_concurrency setting
2015-09-06 13:49 UTC Julien Rouhaud <julien.rouhaud@dalibo.com>
` Re: Allow a per-tablespace effective_io_concurrency setting
2015-09-08 16:00 UTC Alvaro Herrera <alvherre@2ndquadrant.com>
` Re: Allow a per-tablespace effective_io_concurrency setting
2015-09-08 18:26 UTC Julien Rouhaud <julien.rouhaud@dalibo.com>
[23+ messages in thread]
PostgreSQL Tuning for Messaging/Messenger/Chatting Application
2015-09-02 12:16 UTC FattahRozzaq <ssoorruu@gmail.com>
` Re: PostgreSQL Tuning for Messaging/Messenger/Chatting Application
2015-09-03 13:40 UTC Sridhar N Bamandlapally <sridhar.bn1@gmail.com>
[2+ messages in thread]
Query > 1000× slowdown after adding datetime comparison
2015-08-31 16:09 UTC twoflower <standa.kurik@gmail.com>
` Re: [PERFORM] Query > 1000× slowdown after adding datetime comparison
2015-08-31 16:35 UTC David G. Johnston <david.g.johnston@gmail.com>
` Re: Query > 1000× slowdown after adding datetime comparison
2015-08-31 19:03 UTC twoflower <standa.kurik@gmail.com>
` Re: Query > 1000× slowdown after adding datetime comparison
2015-08-31 19:19 UTC twoflower <standa.kurik@gmail.com>
` Re: [PERFORM] Re: Query > 1000× slowdown after adding datetime comparison
2015-08-31 19:22 UTC David G. Johnston <david.g.johnston@gmail.com>
` Re: [PERFORM] Re: Query > 1000× slowdown after adding datetime comparison
2015-08-31 19:29 UTC David G. Johnston <david.g.johnston@gmail.com>
` Re: Re: Query > 1000× slowdown after adding datetime comparison
2015-08-31 19:46 UTC twoflower <standa.kurik@gmail.com>
` Re: [PERFORM] Re: Query > 1000× slowdown after adding datetime comparison
2015-08-31 20:24 UTC Stefan Keller <sfkeller@gmail.com>
` Re: Re: Query > 1000× slowdown after adding datetime comparison
2015-08-31 20:30 UTC twoflower <standa.kurik@gmail.com>
` Re: [PERFORM] Re: Query > 1000× slowdown after adding datetime comparison
2015-08-31 21:00 UTC Stefan Keller <sfkeller@gmail.com>
` Re: Re: Query > 1000× slowdown after adding datetime comparison
2015-09-01 07:53 UTC twoflower <standa.kurik@gmail.com>
` Re: [PERFORM] Re: Query > 1000× slowdown after adding datetime comparison
2015-09-01 09:45 UTC 林士博 <lin@repica.co.jp>
` Re: Re: Query > 1000× slowdown after adding datetime comparison
2015-09-01 09:51 UTC twoflower <standa.kurik@gmail.com>
` Re: [PERFORM] Re: Query > 1000× slowdown after adding datetime comparison
2015-09-01 10:15 UTC 林士博 <lin@repica.co.jp>
` Re: [PERFORM] Re: Query > 1000× slowdown after adding datetime comparison
2015-09-01 10:25 UTC 林士博 <lin@repica.co.jp>
[15+ messages in thread]
Re: Query > 1000× slowdown after adding datetime comparison
2015-08-31 16:19 UTC Tomas Vondra <tomas.vondra@2ndquadrant.com>
is there any way we can push join predicate into inner table
2015-08-31 13:51 UTC 挨踢人 <2363541664@qq.com>
` Re: is there any way we can push join predicate into inner table
2015-08-31 14:36 UTC Tom Lane <tgl@sss.pgh.pa.us>
[2+ messages in thread]
Gist indexing performance with cidr types
2015-08-25 13:11 UTC Henrik Thostrup Jensen <htj@nordu.net>
` Re: Gist indexing performance with cidr types
2015-08-25 14:25 UTC Emre Hasegeli <emre@hasegeli.com>
` Re: Gist indexing performance with cidr types
2015-08-26 07:58 UTC Henrik Thostrup Jensen <htj@nordu.net>
` Re: Gist indexing performance with cidr types
2015-08-26 09:00 UTC Henrik Thostrup Jensen <htj@nordu.net>
` Re: Gist indexing performance with cidr types
2015-08-26 09:47 UTC Emre Hasegeli <emre@hasegeli.com>
` Re: Gist indexing performance with cidr types
2015-08-26 11:29 UTC Henrik Thostrup Jensen <htj@nordu.net>
` Re: Gist indexing performance with cidr types
2015-08-26 13:46 UTC Emre Hasegeli <emre@hasegeli.com>
` Re: Gist indexing performance with cidr types
2015-08-26 16:08 UTC Jeff Janes <jeff.janes@gmail.com>
` Re: Gist indexing performance with cidr types
2015-08-27 09:21 UTC Henrik Thostrup Jensen <htj@nordu.net>
` Re: Gist indexing performance with cidr types
2015-08-27 09:35 UTC Henrik Thostrup Jensen <htj@nordu.net>
` Re: Gist indexing performance with cidr types
2015-08-27 16:05 UTC Emre Hasegeli <emre@hasegeli.com>
` Re: Gist indexing performance with cidr types
2015-08-28 14:05 UTC Henrik Thostrup Jensen <htj@nordu.net>
[12+ 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