pg.ddx.io pgsql-performance@postgresql.org mailing list archive
help / color / mirror / Atom feedGeneral slowness when retrieving a relatively small number of rows
2013-11-15 22:24 UTC Patrick Krecker <patrick@judicata.com>
Bad plan choices & statistic targets with a GIN index
2013-11-14 14:36 UTC Dieter Komendera <dieter@komendera.com>
` Re: Bad plan choices & statistic targets with a GIN index
2013-11-14 15:00 UTC Tom Lane <tgl@sss.pgh.pa.us>
[2+ messages in thread]
Horrific time for getting 1 record from an index?
2013-11-11 21:48 UTC Jim Nasby <jnasby@enova.com>
` Re: Horrific time for getting 1 record from an index?
2013-11-11 21:51 UTC Daniel Farina <daniel@heroku.com>
` Re: Horrific time for getting 1 record from an index?
2013-11-11 21:57 UTC Jim Nasby <jnasby@enova.com>
` Re: Horrific time for getting 1 record from an index?
2013-11-11 21:59 UTC Daniel Farina <daniel@heroku.com>
` Re: Horrific time for getting 1 record from an index?
2013-11-11 22:57 UTC Jeff Janes <jeff.janes@gmail.com>
` Re: Horrific time for getting 1 record from an index?
2013-11-11 23:28 UTC Jim Nasby <jnasby@enova.com>
` Re: Horrific time for getting 1 record from an index?
2013-11-12 00:30 UTC Jeff Janes <jeff.janes@gmail.com>
` Re: Horrific time for getting 1 record from an index?
2013-11-13 00:17 UTC Jeff Janes <jeff.janes@gmail.com>
` Re: Horrific time for getting 1 record from an index?
2013-11-13 00:22 UTC Jim Nasby <jnasby@enova.com>
` Re: Horrific time for getting 1 record from an index?
2013-11-13 15:03 UTC Merlin Moncure <mmoncure@gmail.com>
[10+ messages in thread]
CREATE TABLE AS WITH FREEZE ?
2013-11-13 10:29 UTC Marc Mamin <M.Mamin@intershop.de>
BitMap Heap Scan & BitMap Index Scan
2013-11-10 07:32 UTC monalee_dba <monalee@sungraceinfotech.co.in>
` Re: BitMap Heap Scan & BitMap Index Scan
2013-11-13 01:25 UTC Michael Paquier <michael.paquier@gmail.com>
` Re: BitMap Heap Scan & BitMap Index Scan
2013-11-13 09:37 UTC Torsten Förtsch <torsten.foertsch@gmx.net>
[3+ messages in thread]
Order By Clause, Slows Query Performance?
2013-11-10 07:40 UTC monalee_dba <monalee@sungraceinfotech.co.in>
` Re: Order By Clause, Slows Query Performance?
2013-11-13 01:31 UTC Michael Paquier <michael.paquier@gmail.com>
` Re: Order By Clause, Slows Query Performance?
2013-11-13 09:07 UTC Albe Laurenz <laurenz.albe@wien.gv.at>
[3+ messages in thread]
postgresql recommendation memory
2013-11-02 18:54 UTC Евгений Селявка <evg.selyavka@gmail.com>
` Re: postgresql recommendation memory
2013-11-05 08:37 UTC Евгений Селявка <evg.selyavka@gmail.com>
` Re: postgresql recommendation memory
2013-11-05 19:59 UTC Josh Berkus <josh@agliodbs.com>
` Re: postgresql recommendation memory
2013-11-05 23:00 UTC Michael Paquier <michael.paquier@gmail.com>
` Re: postgresql recommendation memory
2013-11-05 23:22 UTC Scott Marlowe <scott.marlowe@gmail.com>
` Re: postgresql recommendation memory
2013-11-06 08:53 UTC Евгений Селявка <evg.selyavka@gmail.com>
` Re: postgresql recommendation memory
2013-11-06 16:35 UTC Scott Marlowe <scott.marlowe@gmail.com>
` Re: postgresql recommendation memory
2013-11-06 16:46 UTC Scott Marlowe <scott.marlowe@gmail.com>
` Re: postgresql recommendation memory
2013-11-06 17:04 UTC Scott Marlowe <scott.marlowe@gmail.com>
` Re: postgresql recommendation memory
2013-11-06 23:18 UTC Merlin Moncure <mmoncure@gmail.com>
` Re: postgresql recommendation memory
2013-11-07 08:51 UTC David Rees <drees76@gmail.com>
` Re: postgresql recommendation memory
2013-11-07 09:33 UTC Евгений Селявка <evg.selyavka@gmail.com>
` Re: postgresql recommendation memory
2013-11-07 10:13 UTC Евгений Селявка <evg.selyavka@gmail.com>
` Re: postgresql recommendation memory
2013-11-11 00:20 UTC Sergey Konoplev <gray.ru@gmail.com>
` Re: postgresql recommendation memory
2013-11-11 08:09 UTC Евгений Селявка <evg.selyavka@gmail.com>
` Re: postgresql recommendation memory
2013-11-11 16:14 UTC Scott Marlowe <scott.marlowe@gmail.com>
` Re: postgresql recommendation memory
2013-11-11 16:26 UTC ktm@rice.edu <ktm@rice.edu>
` Re: postgresql recommendation memory
2013-11-11 20:02 UTC Sergey Konoplev <gray.ru@gmail.com>
` Re: postgresql recommendation memory
2013-11-11 20:10 UTC Sergey Konoplev <gray.ru@gmail.com>
` Re: postgresql recommendation memory
2013-11-11 20:58 UTC Jeff Janes <jeff.janes@gmail.com>
` Re: postgresql recommendation memory
2013-11-12 08:41 UTC Евгений Селявка <evg.selyavka@gmail.com>
[21+ messages in thread]
Unexpected slow query time when joining small table with large table
2013-11-12 04:22 UTC Ryan LeCompte <lecompte@gmail.com>
Size of IN list affects query plan
2013-11-08 14:04 UTC Jan Walter <john@commontongue.com>
` Re: Size of IN list affects query plan
2013-11-08 14:31 UTC Tom Lane <tgl@sss.pgh.pa.us>
` Re: Size of IN list affects query plan
2013-11-08 14:31 UTC bricklen <bricklen@gmail.com>
` Re: Size of IN list affects query plan
2013-11-11 13:56 UTC Jan Walter <john@commontongue.com>
[4+ messages in thread]
Slow index scan on B-Tree index over timestamp field
2013-11-03 22:05 UTC Caio Casimiro <casimiro.listas@gmail.com>
` Re: Slow index scan on B-Tree index over timestamp field
2013-11-04 18:56 UTC Kevin Grittner <kgrittn@ymail.com>
` Re: Slow index scan on B-Tree index over timestamp field
2013-11-04 19:03 UTC Elliot <yields.falsehood@gmail.com>
` Re: Slow index scan on B-Tree index over timestamp field
2013-11-04 19:15 UTC Jeff Janes <jeff.janes@gmail.com>
` Re: Slow index scan on B-Tree index over timestamp field
2013-11-04 20:44 UTC Caio Casimiro <casimiro.listas@gmail.com>
` Re: Slow index scan on B-Tree index over timestamp field
2013-11-04 20:50 UTC Caio Casimiro <casimiro.listas@gmail.com>
` Re: Slow index scan on B-Tree index over timestamp field
2013-11-04 20:52 UTC Igor Neyman <ineyman@perceptron.com>
` Re: Slow index scan on B-Tree index over timestamp field
2013-11-04 21:10 UTC Caio Casimiro <casimiro.listas@gmail.com>
` Re: Slow index scan on B-Tree index over timestamp field
2013-11-04 21:22 UTC Elliot <yields.falsehood@gmail.com>
` Re: Slow index scan on B-Tree index over timestamp field
2013-11-04 21:26 UTC Igor Neyman <ineyman@perceptron.com>
` Re: Slow index scan on B-Tree index over timestamp field
2013-11-04 21:32 UTC Caio Casimiro <casimiro.listas@gmail.com>
` Re: Slow index scan on B-Tree index over timestamp field
2013-11-04 22:10 UTC Caio Casimiro <casimiro.listas@gmail.com>
` Re: Slow index scan on B-Tree index over timestamp field
2013-11-04 22:59 UTC desmodemone <desmodemone@gmail.com>
` Re: Slow index scan on B-Tree index over timestamp field
2013-11-04 23:24 UTC Caio Casimiro <casimiro.listas@gmail.com>
` Re: Slow index scan on B-Tree index over timestamp field
2013-11-05 13:17 UTC Igor Neyman <ineyman@perceptron.com>
` Re: Slow index scan on B-Tree index over timestamp field
2013-11-05 16:10 UTC Jeff Janes <jeff.janes@gmail.com>
` Re: Slow index scan on B-Tree index over timestamp field
2013-11-06 16:44 UTC Merlin Moncure <mmoncure@gmail.com>
` Re: Slow index scan on B-Tree index over timestamp field
2013-11-06 19:00 UTC Jeff Janes <jeff.janes@gmail.com>
` Re: Slow index scan on B-Tree index over timestamp field
2013-11-06 19:24 UTC Caio Casimiro <casimiro.listas@gmail.com>
[19+ messages in thread]
Trees: integer[] outperformed by ltree
2013-11-05 12:25 UTC Jan Walter <john@commontongue.com>
` Re: Trees: integer[] outperformed by ltree
2013-11-05 17:30 UTC Merlin Moncure <mmoncure@gmail.com>
` Re: Trees: integer[] outperformed by ltree
2013-11-05 19:51 UTC Merlin Moncure <mmoncure@gmail.com>
` Re: Trees: integer[] outperformed by ltree
2013-11-05 21:52 UTC Jan Walter <john@commontongue.com>
` Re: Trees: integer[] outperformed by ltree
2013-11-05 22:19 UTC Merlin Moncure <mmoncure@gmail.com>
` Re: Trees: integer[] outperformed by ltree
2013-11-06 00:27 UTC Jan Walter <john@commontongue.com>
` Re: Trees: integer[] outperformed by ltree
2013-11-06 14:36 UTC Merlin Moncure <mmoncure@gmail.com>
[7+ messages in thread]
ORDER BY performance deteriorates very quickly as dataset grows
2013-11-05 08:36 UTC Standa K. <standa.kurik@gmail.com>
` Re: ORDER BY performance deteriorates very quickly as dataset grows
2013-11-05 09:22 UTC aasat <satriani@veranet.pl>
` Re: ORDER BY performance deteriorates very quickly as dataset grows
2013-11-05 09:24 UTC aasat <satriani@veranet.pl>
[3+ messages in thread]
Hot Standby performance issue
2013-10-15 20:40 UTC sparikh <sparikh@ecotality.com>
` Re: Hot Standby performance issue
2013-10-18 21:49 UTC sparikh <sparikh@ecotality.com>
` Re: Hot Standby performance issue
2013-10-18 23:15 UTC Sethu Prasad <sethuprasad.in@gmail.com>
` Re: Hot Standby performance issue
2013-10-18 23:19 UTC Tomas Vondra <tv@fuzzy.cz>
` Re: Hot Standby performance issue
2013-10-18 23:23 UTC Tomas Vondra <tv@fuzzy.cz>
` Re: Hot Standby performance issue
2013-10-19 00:53 UTC sparikh <sparikh@ecotality.com>
` Re: Hot Standby performance issue
2013-10-20 00:20 UTC Tomas Vondra <tv@fuzzy.cz>
` Re: Hot Standby performance issue
2013-10-20 16:03 UTC Kevin Grittner <kgrittn@ymail.com>
` Re: Hot Standby performance issue
2013-10-20 17:58 UTC sparikh <sparikh@ecotality.com>
` Re: Hot Standby performance issue
2013-10-20 23:01 UTC Tomas Vondra <tv@fuzzy.cz>
` Re: Hot Standby performance issue
2013-10-21 15:05 UTC sparikh <sparikh@ecotality.com>
` Re: Hot Standby performance issue
2013-10-21 19:58 UTC Tomas Vondra <tv@fuzzy.cz>
` Re: Hot Standby performance issue
2013-10-21 21:18 UTC sparikh <sparikh@ecotality.com>
` Re: Hot Standby performance issue
2013-10-21 21:54 UTC Tomas Vondra <tv@fuzzy.cz>
` Re: Hot Standby performance issue
2013-10-21 22:59 UTC sparikh <sparikh@ecotality.com>
` Re: Hot Standby performance issue
2013-10-21 23:14 UTC Tomas Vondra <tv@fuzzy.cz>
` Re: Hot Standby performance issue
2013-10-22 00:00 UTC sparikh <sparikh@ecotality.com>
` Re: Hot Standby performance issue
2013-10-22 04:49 UTC Magnus Hagander <magnus@hagander.net>
` Re: Hot Standby performance issue
2013-10-22 17:54 UTC Tomas Vondra <tv@fuzzy.cz>
` Re: Hot Standby performance issue
2013-10-22 18:00 UTC Tomas Vondra <tv@fuzzy.cz>
` Re: Hot Standby performance issue
2013-10-22 21:41 UTC sparikh <sparikh@ecotality.com>
` Re: Hot Standby performance issue
2013-10-22 21:50 UTC sparikh <sparikh@ecotality.com>
` Re: Hot Standby performance issue
2013-10-22 23:09 UTC Tomas Vondra <tv@fuzzy.cz>
` Re: Hot Standby performance issue
2013-10-22 23:15 UTC Tomas Vondra <tv@fuzzy.cz>
` Re: Hot Standby performance issue
2013-10-23 01:23 UTC sparikh <sparikh@ecotality.com>
` Re: Hot Standby performance issue
2013-10-25 21:22 UTC ramistuni <ramistuni@yahoo.com>
` Re: Hot Standby performance issue
2013-10-26 14:16 UTC Tomas Vondra <tv@fuzzy.cz>
` Re: Hot Standby performance issue
2013-10-28 20:23 UTC sparikh <sparikh@ecotality.com>
` Re: Hot Standby performance issue
2013-10-28 20:57 UTC sparikh <sparikh@ecotality.com>
` Re: Hot Standby performance issue
2013-11-02 19:33 UTC Tomas Vondra <tv@fuzzy.cz>
` Re: Hot Standby performance issue
2013-11-02 19:40 UTC Tomas Vondra <tv@fuzzy.cz>
[31+ messages in thread]
how are you?
2013-11-01 15:50 UTC Ioana Danes <ioanasoftware@yahoo.ca>
Adding foreign key constraint holds exclusive lock for too long (on production database)
2013-10-29 21:27 UTC Ben Hoyt <benhoyt@gmail.com>
` Re: Adding foreign key constraint holds exclusive lock for too long (on production database)
2013-10-30 00:18 UTC David Johnston <polobo@yahoo.com>
` Re: Re: Adding foreign key constraint holds exclusive lock for too long (on production database)
2013-10-30 00:30 UTC Tom Lane <tgl@sss.pgh.pa.us>
` Re: Adding foreign key constraint holds exclusive lock for too long (on production database)
2013-10-30 18:20 UTC Josh Berkus <josh@agliodbs.com>
` Re: Re: Adding foreign key constraint holds exclusive lock for too long (on production database)
2013-10-31 08:01 UTC Ben Hoyt <benhoyt@gmail.com>
` Re: Re: Adding foreign key constraint holds exclusive lock for too long (on production database)
2013-10-31 14:19 UTC Tom Lane <tgl@sss.pgh.pa.us>
` Re: Re: Adding foreign key constraint holds exclusive lock for too long (on production database)
2013-10-31 23:32 UTC Ben Hoyt <benhoyt@gmail.com>
[7+ messages in thread]
Update Trigger latency utilizing the IS DISTINCT FROM syntax
2013-10-31 22:27 UTC fburgess@radiantblue.com
Problems with hash join over nested loop
2013-10-28 21:58 UTC Jim Nasby <jnasby@enova.com>
` Re: Problems with hash join over nested loop
2013-10-28 23:13 UTC Tom Lane <tgl@sss.pgh.pa.us>
` Re: Problems with hash join over nested loop
2013-10-28 23:53 UTC Jim Nasby <jnasby@enova.com>
` Re: Problems with hash join over nested loop
2013-10-29 14:10 UTC Merlin Moncure <mmoncure@gmail.com>
` Re: Problems with hash join over nested loop
2013-10-29 16:21 UTC Jim Nasby <jnasby@enova.com>
` Re: Problems with hash join over nested loop
2013-10-29 16:45 UTC Tom Lane <tgl@sss.pgh.pa.us>
` Re: Problems with hash join over nested loop
2013-10-29 16:52 UTC Jim Nasby <jnasby@enova.com>
` Re: Problems with hash join over nested loop
2013-10-29 18:20 UTC Tom Lane <tgl@sss.pgh.pa.us>
` Re: Problems with hash join over nested loop
2013-10-29 20:08 UTC Jim Nasby <jnasby@enova.com>
` Re: Problems with hash join over nested loop
2013-10-29 20:36 UTC Tom Lane <tgl@sss.pgh.pa.us>
` Re: Problems with hash join over nested loop
2013-10-30 22:27 UTC Jim Nasby <jnasby@enova.com>
` Re: Problems with hash join over nested loop
2013-10-30 22:32 UTC Jim Nasby <jnasby@enova.com>
` Re: Problems with hash join over nested loop
2013-10-30 23:06 UTC Tom Lane <tgl@sss.pgh.pa.us>
[13+ messages in thread]
Re: postgres connections
2013-10-30 14:16 UTC si24 <smrcoutts24@gmail.com>
Logic of lowering seq_page_cost for SSD?
2013-10-22 18:56 UTC Josh Berkus <josh@agliodbs.com>
BASH script for collecting analyze-related info
2013-09-29 09:09 UTC Ken Tanzer <ken.tanzer@gmail.com>
` Re: BASH script for collecting analyze-related info
2013-09-29 16:57 UTC Craig James <cjames@emolecules.com>
` Re: BASH script for collecting analyze-related info
2013-09-29 21:24 UTC Ken Tanzer <ken.tanzer@gmail.com>
` Re: BASH script for collecting analyze-related info
2013-09-29 23:59 UTC Craig James <cjames@emolecules.com>
` Re: BASH script for collecting analyze-related info
2013-09-30 07:05 UTC hubert depesz lubaczewski <depesz@depesz.com>
` Re: BASH script for collecting analyze-related info
2013-10-01 02:40 UTC Ken Tanzer <ken.tanzer@gmail.com>
` Re: BASH script for collecting analyze-related info
2013-10-16 07:20 UTC Ken Tanzer <ken.tanzer@gmail.com>
` Re: BASH script for collecting analyze-related info
2013-10-17 04:50 UTC Ken Tanzer <ken.tanzer@gmail.com>
[8+ messages in thread]
Planner Conceptual Error when Joining a Subquery -- Outer Query Condition not Pulled Into Subquery
2013-10-16 06:33 UTC Gavin Wahl <gavinwahl@gmail.com>
` Re: Planner Conceptual Error when Joining a Subquery -- Outer Query Condition not Pulled Into Subquery
2013-10-16 08:28 UTC Tom Lane <tgl@sss.pgh.pa.us>
` Re: Planner Conceptual Error when Joining a Subquery -- Outer Query Condition not Pulled Into Subquery
2013-10-17 02:45 UTC Gavin Wahl <gavinwahl@gmail.com>
[3+ messages in thread]
limit connections pgpool
2013-10-10 15:00 UTC Jeison Bedoya Delgado <jeisonb@audifarma.com.co>
` Re: limit connections pgpool
2013-10-11 03:10 UTC Michael Paquier <michael.paquier@gmail.com>
` Re: limit connections pgpool
2013-10-11 03:38 UTC Tatsuo Ishii <ishii@postgresql.org>
[3+ messages in thread]
postgreSQL query via JDBC in different OS taking different running time?
2013-10-08 01:48 UTC Aftab Ahmed Chandio <aftabac@siat.ac.cn>
` Re: postgreSQL query via JDBC in different OS taking different running time?
2013-10-08 03:35 UTC Kevin Grittner <kgrittn@ymail.com>
` Re: postgreSQL query via JDBC in different OS taking different running time?
2013-10-08 03:37 UTC John R Pierce <pierce@hogranch.com>
` Re: postgreSQL query via JDBC in different OS taking different running time?
2013-10-08 03:44 UTC David Johnston <polobo@yahoo.com>
` Re: [GENERAL] postgreSQL query via JDBC in different OS taking different running time?
2013-10-08 11:02 UTC Luca Ferrari <fluca1978@infinito.it>
` Re: postgreSQL query via JDBC in different OS taking different running time?
2013-10-10 21:44 UTC Merlin Moncure <mmoncure@gmail.com>
[6+ messages in thread]
Is there a Maximum number of partitions in which constraint_exclusion works?
2013-10-08 15:31 UTC Marcelo Vega <mavegaf@gmail.com>
Help on ṕerformance
2013-09-30 15:03 UTC Carlos Eduardo Sotelo Pinto <carlos.sotelo.pinto@gmail.com>
` Fwd: Help on ṕerformance
2013-09-30 15:12 UTC Carlos Eduardo Sotelo Pinto <carlos.sotelo.pinto@gmail.com>
` Re: [pgsql-es-ayuda] Fwd: Help on ṕerformance
2013-09-30 15:33 UTC Carlos Eduardo Sotelo Pinto <carlos.sotelo.pinto@gmail.com>
` Re: [pgsql-es-ayuda] Re: [pgsql-es-ayuda] Fwd: Help on ṕerformance
2013-09-30 15:36 UTC Hellmuth Vargas <hivs77@gmail.com>
` Re: Fwd: Help on ṕerformance
2013-09-30 16:12 UTC Alvaro Herrera <alvherre@2ndquadrant.com>
` Re: [pgsql-es-ayuda] Fwd: Help on ṕerformance
2013-09-30 16:16 UTC Carlos Eduardo Sotelo Pinto <carlos.sotelo.pinto@gmail.com>
` Re: [pgsql-es-ayuda] Fwd: Help on ṕerformance
2013-09-30 16:25 UTC Gilberto Castillo <gilberto.castillo@etecsa.cu>
` Re: [pgsql-es-ayuda] Re: [pgsql-es-ayuda] Fwd: Help on ṕerformance
2013-09-30 16:31 UTC Rodriguez Fernando <rodriguez@ort.edu.uy>
` Re: [pgsql-es-ayuda] Re: [pgsql-es-ayuda] Re: [pgsql-es-ayuda] Fwd: Help on ṕerformance
2013-09-30 16:35 UTC Carlos Eduardo Sotelo Pinto <carlos.sotelo.pinto@gmail.com>
` Re: [GENERAL] Help on ṕerformance
2013-10-02 13:57 UTC Merlin Moncure <mmoncure@gmail.com>
` Re: [GENERAL] Help on ṕerformance
2013-10-02 16:22 UTC Carlos Eduardo Sotelo Pinto <carlos.sotelo.pinto@gmail.com>
` Re: [GENERAL] Re: [GENERAL] Help on ṕerformance
2013-10-04 08:46 UTC Rémi Cura <remi.cura@gmail.com>
[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