pg.ddx.io  pgsql-performance@postgresql.org mailing list archive  
help / color / mirror / Atom feed
Bulk persistence strategy
  2017-05-21 06:25 UTC  Riaan Stander <rstander@exa.co.za>
` Re: Bulk persistence strategy
  2017-05-21 14:33 UTC  Tom Lane <tgl@sss.pgh.pa.us>
` Re: Bulk persistence strategy
  2017-05-21 19:29 UTC  Riaan Stander <rstander@exa.co.za>
` Re: Bulk persistence strategy
  2017-05-21 22:37 UTC  Tom Lane <tgl@sss.pgh.pa.us>
` Re: Bulk persistence strategy
  2017-05-22 02:14 UTC  Riaan Stander <rstander@exa.co.za>
` Re: Bulk persistence strategy
  2017-05-22 05:15 UTC  Simon Riggs <simon@2ndquadrant.com>
` Re: Bulk persistence strategy
  2017-05-22 08:06 UTC  Riaan Stander <rstander@exa.co.za>
` Re: Bulk persistence strategy
  2017-05-22 08:27 UTC  Simon Riggs <simon@2ndquadrant.com>
` Re: Bulk persistence strategy
  2017-05-22 09:36 UTC  Riaan Stander <rstander@exa.co.za>
` Re: Bulk persistence strategy
  2017-05-22 11:50 UTC  Tom Lane <tgl@sss.pgh.pa.us>
` Re: Bulk persistence strategy
  2017-05-22 15:37 UTC  Merlin Moncure <mmoncure@gmail.com>
  [11+ messages in thread]

pg_stat_statements with fetch
  2017-05-19 23:04 UTC  Jeff Janes <jeff.janes@gmail.com>
` Re: pg_stat_statements with fetch
  2017-05-21 13:53 UTC  Rick Otten <rottenwindfish@gmail.com>
  [2+ messages in thread]

Index not being used on composite type for particular query
  2017-05-20 23:33 UTC  Zac Goldstein <goldzz@gmail.com>
` Re: Index not being used on composite type for particular query
  2017-05-21 00:00 UTC  Tom Lane <tgl@sss.pgh.pa.us>
` Re: Index not being used on composite type for particular query
  2017-05-21 02:51 UTC  Zac Goldstein <goldzz@gmail.com>
  [3+ messages in thread]

GIN index not used if created in the same transaction as query
  2017-05-19 15:14 UTC  Adam Brusselback <adambrusselback@gmail.com>
` Re: GIN index not used if created in the same transaction as query
  2017-05-19 15:33 UTC  Tom Lane <tgl@sss.pgh.pa.us>
` Re: GIN index not used if created in the same transaction as query
  2017-05-19 15:49 UTC  Adam Brusselback <adambrusselback@gmail.com>
` Re: GIN index not used if created in the same transaction as query
  2017-05-19 16:09 UTC  Tom Lane <tgl@sss.pgh.pa.us>
  [4+ messages in thread]

postgres_fdw and column casting shippability
  2017-05-15 21:42 UTC  Jeff Janes <jeff.janes@gmail.com>
` Re: postgres_fdw and column casting shippability
  2017-05-15 22:22 UTC  Tom Lane <tgl@sss.pgh.pa.us>
` Re: postgres_fdw and column casting shippability
  2017-05-16 16:54 UTC  Jeff Janes <jeff.janes@gmail.com>
  [3+ messages in thread]

Speed differences between in executing the same query
  2017-05-11 13:54 UTC  plukovic <petar@sobot.biz>
` Re: Speed differences between in executing the same query
  2017-05-11 14:06 UTC  Tom Lane <tgl@sss.pgh.pa.us>
` Re: Speed differences between in executing the same query
  2017-05-11 17:11 UTC  plukovic <petar@sobot.biz>
  [3+ messages in thread]

Speed differences between two servers
  2017-05-08 17:49 UTC  Vincent Veyron <vv.lists@wanadoo.fr>
` Re: Speed differences between two servers
  2017-05-08 18:48 UTC  Scott Marlowe <scott.marlowe@gmail.com>
` Re: Speed differences between two servers
  2017-05-08 22:24 UTC  Vincent Veyron <vv.lists@wanadoo.fr>
` Re: Speed differences between two servers
  2017-05-08 23:06 UTC  Scott Marlowe <scott.marlowe@gmail.com>
` Re: Speed differences between two servers
  2017-05-08 23:35 UTC  Scott Marlowe <scott.marlowe@gmail.com>
` Re: Speed differences between two servers
  2017-05-09 12:02 UTC  Vincent Veyron <vv.lists@wanadoo.fr>
` Re: Speed differences between two servers
  2017-05-09 13:08 UTC  Vincent Veyron <vv.lists@wanadoo.fr>
` Re: Speed differences between two servers
  2017-05-09 16:24 UTC  Scott Marlowe <scott.marlowe@gmail.com>
` Re: Speed differences between two servers
  2017-05-10 08:27 UTC  Vincent Veyron <vv.lists@wanadoo.fr>
  [9+ messages in thread]

Postgres uses too much RAM
  2017-05-08 20:23 UTC  Hans Braxmeier <hans.braxmeier@outlook.com>
` Re: Postgres uses too much RAM
  2017-05-08 23:12 UTC  Merlin Moncure <mmoncure@gmail.com>
  [2+ messages in thread]

Postgres performance issue
  2017-05-04 14:10 UTC  Junaid Malik <junaid.malik@confiz.com>
` Re: Postgres performance issue
  2017-05-04 14:36 UTC  Scott Marlowe <scott.marlowe@gmail.com>
` Re: Postgres performance issue
  2017-05-04 14:57 UTC  Scott Marlowe <scott.marlowe@gmail.com>
` Re: Postgres performance issue
  2017-05-08 18:50 UTC  Scott Marlowe <scott.marlowe@gmail.com>
  [4+ messages in thread]

Inefficient max query when using group by
  2017-05-04 10:52 UTC  jesse.hietanen@vaisala.com
` Re: Inefficient max query when using group by
  2017-05-04 13:21 UTC  bricklen <bricklen@gmail.com>
` Re: Inefficient max query when using group by
  2017-05-04 13:51 UTC  David Rowley <david.rowley@2ndquadrant.com>
  [3+ messages in thread]

Questionaire: Common WAL write rates on busy servers.
  2017-04-25 04:17 UTC  Andres Freund <andres@anarazel.de>
` Re: Questionaire: Common WAL write rates on busy servers.
  2017-04-25 07:56 UTC  Vladimir Borodin <root@simply.name>
` Re: [GENERAL] Questionaire: Common WAL write rates on busy servers.
  2017-04-25 14:19 UTC  bricklen <bricklen@gmail.com>
` Re: Questionaire: Common WAL write rates on busy servers.
  2017-04-25 16:07 UTC  Claudio Freire <klaussfreire@gmail.com>
` Re: Questionaire: Common WAL write rates on busy servers.
  2017-04-25 18:56 UTC  Jerry Sievers <gsievers19@comcast.net>
` Re: [PERFORM] Questionaire: Common WAL write rates on busy servers.
  2017-04-27 15:59 UTC  Andres Freund <andres@anarazel.de>
` Re: [PERFORM] Questionaire: Common WAL write rates on busy servers.
  2017-04-27 16:31 UTC  Joshua D. Drake <jd@commandprompt.com>
` Re: Questionaire: Common WAL write rates on busy servers.
  2017-04-27 16:34 UTC  Andres Freund <andres@anarazel.de>
` Re: Questionaire: Common WAL write rates on busy servers.
  2017-04-27 17:29 UTC  Joshua D. Drake <jd@commandprompt.com>
` Re: Questionaire: Common WAL write rates on busy servers.
  2017-04-27 17:35 UTC  Andres Freund <andres@anarazel.de>
` Re: Questionaire: Common WAL write rates on busy servers.
  2017-04-27 22:53 UTC  Tomas Vondra <tomas.vondra@2ndquadrant.com>
` Re: [PERFORM] Questionaire: Common WAL write rates on busy servers.
  2017-04-27 23:18 UTC  Tomas Vondra <tomas.vondra@2ndquadrant.com>
` Re: [PERFORM] Questionaire: Common WAL write rates on busy servers.
  2017-04-27 23:29 UTC  Tomas Vondra <tomas.vondra@2ndquadrant.com>
` Re: Questionaire: Common WAL write rates on busy servers.
  2017-04-27 23:34 UTC  Andres Freund <andres@anarazel.de>
` Re: Questionaire: Common WAL write rates on busy servers.
  2017-04-29 00:41 UTC  Tomas Vondra <tomas.vondra@2ndquadrant.com>
  [15+ messages in thread]

Performance issue in PostgreSQL server...
  2017-03-03 10:29 UTC  Dinesh Chandra 12108 <Dinesh.Chandra@cyient.com>
` Re: Performance issue in PostgreSQL server...
  2017-03-03 12:23 UTC  Nur Agus <nuragus.linux@gmail.com>
` Re: Performance issue in PostgreSQL server...
  2017-03-03 12:44 UTC  Dinesh Chandra 12108 <Dinesh.Chandra@cyient.com>
` Re: Performance issue in PostgreSQL server...
  2017-03-03 15:19 UTC  Tom Lane <tgl@sss.pgh.pa.us>
` Re: Performance issue in PostgreSQL server...
  2017-03-06 04:23 UTC  Jeff Janes <jeff.janes@gmail.com>
` Re: Performance issue in PostgreSQL server...
  2017-03-06 05:24 UTC  Justin Pryzby <pryzby@telsasoft.com>
` Re: Performance issue in PostgreSQL server...
  2017-03-06 12:17 UTC  Dinesh Chandra 12108 <Dinesh.Chandra@cyient.com>
` Re: Performance issue in PostgreSQL server...
  2017-04-27 18:47 UTC  Justin Pryzby <pryzby@telsasoft.com>
  [8+ messages in thread]

Re:
  2006-02-23 14:38 UTC  Vivek Khera <vivek@khera.org>
` Re:
  2006-02-23 20:29 UTC  Jim C. Nasby <jnasby@pervasive.com>
` Re:
  2006-02-25 03:42 UTC  Bruce Momjian <pgman@candle.pha.pa.us>
` EXCLUDE CONSTRAINT with intarray
  2017-04-27 10:38 UTC  Alexey Vasiliev <leopard_ne@inbox.ru>
  [4+ messages in thread]

(no subject)
  2006-02-22 10:38 UTC  Chethana, Rao (IE10) <Chethana.Rao@Honeywell.com>
` Re:
  2006-02-22 10:47 UTC  Richard Huxton <dev@archonet.com>
` Re:
  2006-02-22 10:51 UTC  Gourish Singbal <gourish@gmail.com>
` Re:
  2006-02-22 16:32 UTC  Vivek Khera <vivek@khera.org>
` Re: Slow query with 3 table joins
  2017-04-26 03:19 UTC  Alessandro Ferrucci <alessandroferrucci@gmail.com>
` Re: Slow query with 3 table joins
  2017-04-26 04:12 UTC  David Rowley <david.rowley@2ndquadrant.com>
` Re: Slow query with 3 table joins
  2017-04-26 06:24 UTC  Johan Fredriksson <eskil@kth.se>
` Re: Slow query with 3 table joins
  2017-04-26 11:04 UTC  Alessandro Ferrucci <alessandroferrucci@gmail.com>
` Re: Slow query with 3 table joins
  2017-04-26 11:35 UTC  Alessandro Ferrucci <alessandroferrucci@gmail.com>
` Re: Slow query with 3 table joins
  2017-04-26 11:35 UTC  Johan Fredriksson <eskil@kth.se>
` Re: Slow query with 3 table joins
  2017-04-26 12:27 UTC  Gerardo Herzig <gherzig@fmed.uba.ar>
` Re: Slow query with 3 table joins
  2017-04-26 15:00 UTC  Gerardo Herzig <gherzig@fmed.uba.ar>
` Re: Slow query with 3 table joins
  2017-04-26 15:22 UTC  Alessandro Ferrucci <alessandroferrucci@gmail.com>
` Re: Slow query with 3 table joins
  2017-04-26 15:30 UTC  Matthew Bellew <matthewb@labkey.com>
  [14+ messages in thread]

Query with no result set, really really slow adding ORBDER BY / LIMIT clause
  2017-04-20 07:19 UTC  Marco Renzi <renzi.mrc@gmail.com>
` Re: Query with no result set, really really slow adding ORBDER BY / LIMIT clause
  2017-04-20 11:16 UTC  Marco Renzi <renzi.mrc@gmail.com>
` Re: Query with no result set, really really slow adding ORBDER BY / LIMIT clause
  2017-04-20 11:54 UTC  vinny <vinny@xs4all.nl>
` Re: Query with no result set, really really slow adding ORBDER BY / LIMIT clause
  2017-04-20 12:16 UTC  Marco Renzi <renzi.mrc@gmail.com>
` Re: Query with no result set, really really slow adding ORBDER BY / LIMIT clause
  2017-04-20 15:57 UTC  Pavel Stehule <pavel.stehule@gmail.com>
` Re: Query with no result set, really really slow adding ORBDER BY / LIMIT clause
  2017-04-20 16:05 UTC  Pavel Stehule <pavel.stehule@gmail.com>
` Re: Query with no result set, really really slow adding ORBDER BY / LIMIT clause
  2017-04-21 06:49 UTC  Marco Renzi <renzi.mrc@gmail.com>
` Re: Query with no result set, really really slow adding ORBDER BY / LIMIT clause
  2017-04-21 06:56 UTC  Pavel Stehule <pavel.stehule@gmail.com>
` Re: Query with no result set, really really slow adding ORBDER BY / LIMIT clause
  2017-04-21 07:05 UTC  Marco Renzi <renzi.mrc@gmail.com>
` Re: Query with no result set, really really slow adding ORBDER BY / LIMIT clause
  2017-04-21 07:12 UTC  Pavel Stehule <pavel.stehule@gmail.com>
  [10+ messages in thread]

update from performance question
  2017-04-18 21:46 UTC  Armand Pirvu (home) <armand.pirvu@gmail.com>
` Re: update from performance question
  2017-04-19 08:06 UTC  Albe Laurenz <laurenz.albe@wien.gv.at>
` Re: update from performance question
  2017-04-19 23:11 UTC  Armand Pirvu (home) <armand.pirvu@gmail.com>
  [3+ messages in thread]

Insert Concurrency
  2017-04-18 02:55 UTC  ROBERT PRICE <rprice504@hotmail.com>
` Re: Insert Concurrency
  2017-04-18 05:41 UTC  David Rowley <david.rowley@2ndquadrant.com>
` Re: Insert Concurrency
  2017-04-18 05:45 UTC  Daniel Blanch Bataller <daniel.blanch.bataller@gmail.com>
` Re: Insert Concurrency
  2017-04-18 15:29 UTC  Claudio Freire <klaussfreire@gmail.com>
` Re: Insert Concurrency
  2017-04-18 15:41 UTC  Scott Marlowe <scott.marlowe@gmail.com>
` Re: Insert Concurrency
  2017-04-18 15:49 UTC  David McKelvie <dmck@interactive.co.uk>
` Re: Insert Concurrency
  2017-04-18 16:29 UTC  ROBERT PRICE <rprice504@hotmail.com>
  [7+ messages in thread]

Create a materialized view in PostgreSQL which can be access by all the user account
  2017-04-17 17:00 UTC  Dinesh Chandra 12108 <Dinesh.Chandra@cyient.com>
` Re: Create a materialized view in PostgreSQL which can be access by all the user account
  2017-04-17 17:12 UTC  David G. Johnston <david.g.johnston@gmail.com>
  [2+ messages in thread]

Restoring Postgres Dump is very slow with Ubuntu 16.04
  2017-04-15 08:11 UTC  Hans Braxmeier <hans.braxmeier@outlook.com>
` Re: Restoring Postgres Dump is very slow with Ubuntu 16.04
  2017-04-15 13:59 UTC  Andreas Kretschmer <andreas@a-kretschmer.de>
  [2+ messages in thread]

self join estimate and constraint exclusion
  2017-03-26 19:33 UTC  Justin Pryzby <pryzby@telsasoft.com>
` self join estimate and constraint exclusion
  2017-04-15 00:23 UTC  Justin Pryzby <pryzby@telsasoft.com>
  [2+ messages in thread]

Postgres 9.5 / 9.6: Restoring PG 9.4 dump is very very slow
  2017-04-14 23:30 UTC  Hans Braxmeier <hans.braxmeier@outlook.com>
` Re: Postgres 9.5 / 9.6: Restoring PG 9.4 dump is very very slow
  2017-04-14 23:40 UTC  Tom Lane <tgl@sss.pgh.pa.us>
  [2+ messages in thread]

Impact of track_activity_query_size on high traffic OLTP system
  2017-04-13 20:45 UTC  Jeremy Finzel <finzelj@gmail.com>
` Re: Impact of track_activity_query_size on high traffic OLTP system
  2017-04-13 21:17 UTC  Rick Otten <rottenwindfish@gmail.com>
  [2+ messages in thread]

Postgresql, and ODBC handles
  2017-04-13 19:30 UTC  Reza Taheri <rtaheri@vmware.com>

Understanding PostgreSQL query execution time
  2017-04-07 14:56 UTC  Haider Ali <alihaider907@gmail.com>
` Re: Understanding PostgreSQL query execution time
  2017-04-07 15:03 UTC  ldh@laurent-hasson.com <ldh@laurent-hasson.com>
` Re: Understanding PostgreSQL query execution time
  2017-04-07 15:15 UTC  Gerardo Herzig <gherzig@fmed.uba.ar>
` Re: Understanding PostgreSQL query execution time
  2017-04-10 12:18 UTC  vinny <vinny@xs4all.nl>
  [4+ messages in thread]

Filter certain range of IP address.
  2017-04-07 14:13 UTC  Dinesh Chandra 12108 <Dinesh.Chandra@cyient.com>
` Re: Filter certain range of IP address.
  2017-04-07 14:22 UTC  vinny <vinny@xs4all.nl>
` Re: Filter certain range of IP address.
  2017-04-07 15:18 UTC  Dinesh Chandra 12108 <Dinesh.Chandra@cyient.com>
` Re: Filter certain range of IP address.
  2017-04-07 15:29 UTC  David G. Johnston <david.g.johnston@gmail.com>
` Re: Filter certain range of IP address.
  2017-04-07 15:56 UTC  Rick Otten <rottenwindfish@gmail.com>
` Re: Filter certain range of IP address.
  2017-04-07 16:09 UTC  Dinesh Chandra 12108 <Dinesh.Chandra@cyient.com>
` Re: Filter certain range of IP address.
  2017-04-07 16:20 UTC  Moreno Andreo <moreno.andreo@evolu-s.it>
` Re: Filter certain range of IP address.
  2017-04-10 11:33 UTC  vinny <vinny@xs4all.nl>
  [8+ 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