public inbox for [email protected]  
help / color / mirror / Atom feed
Unable to start the slave instance
  2017-07-05 09:14 UTC  Daulat Ram <[email protected]>

Simple SQL too slow
  2017-06-30 19:14 UTC  Daviramos Roussenq Fortunato <[email protected]>
` Re: Simple SQL too slow
  2017-06-30 19:50 UTC  Andreas Kretschmer <[email protected]>
` Re: Simple SQL too slow
  2017-07-01 16:56 UTC  Daviramos Roussenq Fortunato <[email protected]>
` Re: Simple SQL too slow
  2017-07-01 19:44 UTC  Andreas Kretschmer <[email protected]>
` Re: Simple SQL too slow
  2017-07-01 20:39 UTC  Daviramos Roussenq Fortunato <[email protected]>
` Re: Simple SQL too slow
  2017-07-01 20:58 UTC  Tomas Vondra <[email protected]>
` Re: Simple SQL too slow
  2017-07-01 21:17 UTC  Julien Rouhaud <[email protected]>
` Re: Simple SQL too slow
  2017-07-02 01:26 UTC  Daviramos Roussenq Fortunato <[email protected]>
` Re: Simple SQL too slow
  2017-07-02 04:25 UTC  Andreas Kretschmer <[email protected]>
` Re: Simple SQL too slow
  2017-07-02 08:39 UTC  Tomas Vondra <[email protected]>
` Re: Simple SQL too slow
  2017-07-02 10:01 UTC  Nicolas CHARLES <[email protected]>
` Re: Simple SQL too slow
  2017-07-02 13:57 UTC  Daviramos Roussenq Fortunato <[email protected]>
  [12+ messages in thread]

(no subject)
  2017-06-28 06:47 UTC  Yevhenii Kurtov <[email protected]>
` Re:
  2017-06-28 07:12 UTC  Pavel Stehule <[email protected]>
` Re:
  2017-06-28 07:28 UTC  Yevhenii Kurtov <[email protected]>
` Re:
  2017-06-28 07:43 UTC  Pavel Stehule <[email protected]>
` Re:
  2017-06-28 13:08 UTC  Gerardo Herzig <[email protected]>
` Re:
  2017-06-28 13:10 UTC  Brad DeJong <[email protected]>
` Re:
  2017-06-29 05:17 UTC  Yevhenii Kurtov <[email protected]>
` Re:
  2017-06-29 15:50 UTC  Pavel Stehule <[email protected]>
` Re:
  2017-06-29 18:11 UTC  Jeff Janes <[email protected]>
` Re:
  2017-06-29 19:11 UTC  Yevhenii Kurtov <[email protected]>
` Re:
  2017-06-29 21:28 UTC  Alvaro Herrera <[email protected]>
` Re:
  2017-06-30 03:09 UTC  Scott Marlowe <[email protected]>
` Re:
  2017-06-30 17:46 UTC  Jeff Janes <[email protected]>
  [13+ messages in thread]

Performance of information_schema with many schemata and tables
  2017-06-27 23:57 UTC  Ulf Lohbrügge <[email protected]>
` Re: Performance of information_schema with many schemata and tables
  2017-06-28 01:31 UTC  Pritam Baral <[email protected]>
` Re: Performance of information_schema with many schemata and tables
  2017-06-28 09:38 UTC  Ulf Lohbrügge <[email protected]>
` Re: Performance of information_schema with many schemata and tables
  2017-06-28 14:25 UTC  Ulf Lohbrügge <[email protected]>
  [4+ messages in thread]

Efficiently merging and sorting collections of sorted rows
  2017-06-23 22:58 UTC  Clint Miller <[email protected]>
` Re: Efficiently merging and sorting collections of sorted rows
  2017-06-23 23:32 UTC  Peter Geoghegan <[email protected]>
` Re: Efficiently merging and sorting collections of sorted rows
  2017-06-23 23:33 UTC  Tom Lane <[email protected]>
` Re: Efficiently merging and sorting collections of sorted rows
  2017-06-28 13:13 UTC  Merlin Moncure <[email protected]>
  [4+ messages in thread]

Fwd: Stalled post to pgsql-performance
  2017-06-27 13:15 UTC  Chris Wilson <[email protected]>

Fwd: Slow query from ~7M rows, joined to two tables of ~100 rows each
  2017-06-23 20:09 UTC  Chris Wilson <[email protected]>
` Re: Fwd: Slow query from ~7M rows, joined to two tables of ~100 rows each
  2017-06-24 02:01 UTC  Karl Czajkowski <[email protected]>
` Re: Fwd: Slow query from ~7M rows, joined to two tables of ~100 rows each
  2017-06-26 21:22 UTC  Jeff Janes <[email protected]>
  [3+ messages in thread]

Re: Fwd: Slow query from ~7M rows, joined to two tables of ~100 rows each
  2017-06-26 15:43 UTC  Chris Wilson <[email protected]>
` Re: Fwd: Slow query from ~7M rows, joined to two tables of ~100 rows each
  2017-06-26 17:01 UTC  Karl Czajkowski <[email protected]>
` Re: Fwd: Slow query from ~7M rows, joined to two tables of ~100 rows each
  2017-06-26 20:32 UTC  Karl Czajkowski <[email protected]>
  [3+ messages in thread]

Inappropriate inner table for nested loop join
  2017-06-23 10:31 UTC  Akihiko Odaki <[email protected]>
` Re: Inappropriate inner table for nested loop join
  2017-06-23 11:20 UTC  Albe Laurenz <[email protected]>
` Re: Inappropriate inner table for nested loop join
  2017-06-23 11:36 UTC  Akihiko Odaki <[email protected]>
` Re: Inappropriate inner table for nested loop join
  2017-06-23 11:54 UTC  Akihiko Odaki <[email protected]>
` Re: Inappropriate inner table for nested loop join
  2017-06-23 13:05 UTC  Albe Laurenz <[email protected]>
` Re: Inappropriate inner table for nested loop join
  2017-06-26 08:55 UTC  Albe Laurenz <[email protected]>
  [6+ messages in thread]

slow delete due to reference
  2017-06-24 07:28 UTC  Rikard Pavelic <[email protected]>
` Re: slow delete due to reference
  2017-06-24 16:14 UTC  Tom Lane <[email protected]>
  [2+ messages in thread]

Dataset is fetched from cache but still takes same time to fetch records as first run
  2017-06-23 00:40 UTC  Sumeet Shukla <[email protected]>
` Re: Dataset is fetched from cache but still takes same time to fetch records as first run
  2017-06-23 00:54 UTC  Dave Stibrany <[email protected]>
` Re: Dataset is fetched from cache but still takes same time to fetch records as first run
  2017-06-23 04:35 UTC  Sumeet Shukla <[email protected]>
` Re: Dataset is fetched from cache but still takes same time to fetch records as first run
  2017-06-23 04:50 UTC  Tom Lane <[email protected]>
` Re: Dataset is fetched from cache but still takes same time to fetch records as first run
  2017-06-23 12:09 UTC  Adam Brusselback <[email protected]>
` Re: Dataset is fetched from cache but still takes same time to fetch records as first run
  2017-06-23 16:55 UTC  [email protected] <[email protected]>
  [6+ messages in thread]

Re: Dataset is fetched from cache but still takes same time to fetch records as first run
  2017-06-23 07:52 UTC  Glyn Astill <[email protected]>

substring index what is better way to query
  2017-06-20 11:51 UTC  Tieson Molly <[email protected]>
` Re: substring index what is better way to query
  2017-06-20 14:19 UTC  Tom Lane <[email protected]>
` Re: substring index what is better way to query
  2017-06-20 14:40 UTC  Tieson Molly <[email protected]>
` Re: substring index what is better way to query
  2017-06-20 14:45 UTC  Tom Lane <[email protected]>
  [4+ messages in thread]

Using array instead of sub table (storage and speed)
  2017-06-15 08:06 UTC  Lutz Fischer <[email protected]>
` Re: Using array instead of sub table (storage and speed)
  2017-06-15 13:37 UTC  Stephen Frost <[email protected]>
` Re: Using array instead of sub table (storage and speed)
  2017-06-16 10:37 UTC  Lutz Fischer <[email protected]>
` Re: Using array instead of sub table (storage and speed)
  2017-06-16 12:05 UTC  Stephen Frost <[email protected]>
  [4+ messages in thread]

self join estimate and constraint exclusion
  2017-04-15 00:23 UTC  Justin Pryzby <[email protected]>
` join estimate of subqueries with range conditions and constraint exclusion
  2017-05-24 21:17 UTC  Justin Pryzby <[email protected]>
` Re: join estimate of subqueries with range conditions and constraint exclusion
  2017-05-30 10:52 UTC  Justin Pryzby <[email protected]>
` Re: join estimate of subqueries with range conditions and constraint exclusion
  2017-06-03 19:23 UTC  David G. Johnston <[email protected]>
` Re: Re: join estimate of subqueries with range conditions and constraint exclusion
  2017-06-05 21:02 UTC  Tom Lane <[email protected]>
` Re: Re: join under-estimates with ineq conditions
  2017-06-08 16:05 UTC  Justin Pryzby <[email protected]>
` Re: Re: join under-estimates with ineq conditions
  2017-06-16 02:53 UTC  Justin Pryzby <[email protected]>
  [7+ messages in thread]

Sudden drastic change in performance
  2017-06-15 14:53 UTC  [email protected] <[email protected]>
` Re: Sudden drastic change in performance
  2017-06-15 15:09 UTC  Tom Lane <[email protected]>
` Re: Sudden drastic change in performance
  2017-06-15 15:14 UTC  Andreas Kretschmer <[email protected]>
  [3+ messages in thread]

Invalid WAL segment size. Allowed values are 1,2,4,8,16,32,64
  2017-06-09 13:55 UTC  Cocco Gianfranco <[email protected]>
` Re: Invalid WAL segment size. Allowed values are 1,2,4,8,16,32,64
  2017-06-09 22:43 UTC  Michael Paquier <[email protected]>
` Re: Invalid WAL segment size. Allowed values are 1,2,4,8,16,32,64
  2017-06-12 17:27 UTC  Jeff Janes <[email protected]>
` Re: Invalid WAL segment size. Allowed values are 1,2,4,8,16,32,64
  2017-06-12 21:25 UTC  Michael Paquier <[email protected]>
` R: Invalid WAL segment size. Allowed values are 1,2,4,8,16,32,64
  2017-06-13 09:10 UTC  Cocco Gianfranco <[email protected]>
` Re: [BUGS] Invalid WAL segment size. Allowed values are 1,2,4,8,16,32,64
  2017-06-13 09:34 UTC  Michael Paquier <[email protected]>
` Re: [BUGS] Invalid WAL segment size. Allowed values are 1,2,4,8,16,32,64
  2017-06-13 20:38 UTC  Michael Paquier <[email protected]>
  [7+ messages in thread]

Rollback table data.
  2017-06-07 11:33 UTC  Dinesh Chandra 12108 <[email protected]>
` Re: Rollback table data.
  2017-06-07 12:42 UTC  Moreno Andreo <[email protected]>
` Re: Rollback table data.
  2017-06-07 12:48 UTC  Andreas Kretschmer <[email protected]>
` Re: Rollback table data.
  2017-06-07 13:23 UTC  Anthony Sotolongo <[email protected]>
` Re: Rollback table data.
  2017-06-08 00:15 UTC  Scott Marlowe <[email protected]>
` Re: Rollback table data.
  2017-06-10 07:04 UTC  phb07 <[email protected]>
  [6+ messages in thread]

index of only not null, use function index?
  2017-05-22 15:17 UTC  Ariel <[email protected]>
` Re: index of only not null, use function index?
  2017-06-08 14:47 UTC  Merlin Moncure <[email protected]>
` Re: index of only not null, use function index?
  2017-06-08 14:58 UTC  Tom Lane <[email protected]>
` Re: index of only not null, use function index?
  2017-06-08 16:05 UTC  Jeremy Finzel <[email protected]>
` Re: index of only not null, use function index?
  2017-06-08 19:57 UTC  Merlin Moncure <[email protected]>
  [5+ messages in thread]

Monitoring tool for Postgres Database
  2017-05-25 19:48 UTC  Ravi Tammineni <[email protected]>
` Re: Monitoring tool for Postgres Database
  2017-05-25 20:48 UTC  Thomas Kellerer <[email protected]>
` Re: [PERFORM] Monitoring tool for Postgres Database
  2017-05-25 23:05 UTC  Gary Evans <[email protected]>
` Re: Monitoring tool for Postgres Database
  2017-05-26 10:19 UTC  Rick Otten <[email protected]>
` Re: [ADMIN] Monitoring tool for Postgres Database
  2017-05-26 14:28 UTC  Ashish Tiwari <[email protected]>
` Re: Monitoring tool for Postgres Database
  2017-05-26 14:31 UTC  gevans <[email protected]>
` Re: [PERFORM] Monitoring tool for Postgres Database
  2017-05-26 14:32 UTC  Sunkara, Amrutha <[email protected]>
` Re: [PERFORM] Monitoring tool for Postgres Database
  2017-05-27 04:58 UTC  Dave Stibrany <[email protected]>
` Re: Monitoring tool for Postgres Database
  2017-05-27 15:42 UTC  phb07 <[email protected]>
` Re: Monitoring tool for Postgres Database
  2017-06-03 08:37 UTC  Nikolay Samokhvalov <[email protected]>
  [10+ messages in thread]

Seeing execution plan of foreign key constraint check?
  2016-07-05 12:14 UTC  Robert Klemme <[email protected]>
` Re: Seeing execution plan of foreign key constraint check?
  2016-07-19 14:47 UTC  Jim Nasby <[email protected]>
` Re: Seeing execution plan of foreign key constraint check?
  2016-07-19 20:10 UTC  Tom Lane <[email protected]>
` Re: Seeing execution plan of foreign key constraint check?
  2016-07-21 21:42 UTC  Jim Nasby <[email protected]>
` Re: Seeing execution plan of foreign key constraint check?
  2016-07-21 21:59 UTC  Tom Lane <[email protected]>
` Re: Seeing execution plan of foreign key constraint check?
  2016-07-21 22:14 UTC  Jim Nasby <[email protected]>
` Re: Seeing execution plan of foreign key constraint check?
  2016-07-22 08:37 UTC  Robert Klemme <[email protected]>
` Re: Seeing execution plan of foreign key constraint check?
  2016-07-23 01:57 UTC  Jim Nasby <[email protected]>
  [8+ messages in thread]

Performance problems with 9.2.15
  2016-05-27 12:10 UTC  Johan Fredriksson <[email protected]>
` Re: Performance problems with 9.2.15
  2016-05-27 13:46 UTC  Tom Lane <[email protected]>
` Re: Performance problems with 9.2.15
  2016-05-27 14:13 UTC  Johan Fredriksson <[email protected]>
` Re: Performance problems with 9.2.15
  2016-05-27 14:45 UTC  Steve Crawford <[email protected]>
` Re: Performance problems with 9.2.15
  2016-05-30 07:35 UTC  Johan Fredriksson <[email protected]>
` Re: Performance problems with 9.2.15
  2016-05-30 13:56 UTC  Johan Fredriksson <[email protected]>
` Re: Performance problems with 9.2.15
  2016-07-21 14:48 UTC  Johan Fredriksson <[email protected]>
` Re: Performance problems with 9.2.15
  2016-07-21 18:24 UTC  Claudio Freire <[email protected]>
` Re: Performance problems with 9.2.15
  2016-07-21 18:29 UTC  David G. Johnston <[email protected]>
` Re: Performance problems with 9.2.15
  2016-07-21 21:12 UTC  Claudio Freire <[email protected]>
` Re: Performance problems with 9.2.15
  2016-07-22 00:59 UTC  Johan Fredriksson <[email protected]>
` Re: Performance problems with 9.2.15
  2016-07-22 01:07 UTC  Johan Fredriksson <[email protected]>
` Re: Performance problems with 9.2.15
  2016-07-22 07:08 UTC  Mark Kirkwood <[email protected]>
` Re: Performance problems with 9.2.15
  2016-07-22 07:20 UTC  Johan Fredriksson <[email protected]>
  [14+ messages in thread]

less than 2 sec for response - possible?
  2016-07-02 00:54 UTC  trafdev <[email protected]>
` Re: less than 2 sec for response - possible?
  2016-07-02 01:23 UTC  Tom Lane <[email protected]>
` Re: less than 2 sec for response - possible?
  2016-07-02 02:48 UTC  trafdev <[email protected]>
` Re: less than 2 sec for response - possible?
  2016-07-05 10:10 UTC  Pujol Mathieu <[email protected]>
` Re: less than 2 sec for response - possible?
  2016-07-05 11:39 UTC  Torsten Zuehlsdorff <[email protected]>
` Re: less than 2 sec for response - possible?
  2016-07-05 15:35 UTC  trafdev <[email protected]>
` Re: less than 2 sec for response - possible?
  2016-07-06 08:35 UTC  Torsten Zuehlsdorff <[email protected]>
` Re: less than 2 sec for response - possible?
  2016-07-06 15:06 UTC  trafdev <[email protected]>
` Re: less than 2 sec for response - possible?
  2016-07-06 15:27 UTC  Torsten Zuehlsdorff <[email protected]>
` Re: less than 2 sec for response - possible?
  2016-07-06 16:46 UTC  trafdev <[email protected]>
` Re: less than 2 sec for response - possible?
  2016-07-09 17:26 UTC  trafdev <[email protected]>
` Re: less than 2 sec for response - possible?
  2016-07-19 14:10 UTC  Jim Nasby <[email protected]>
` Re: less than 2 sec for response - possible?
  2016-07-19 14:28 UTC  trafdev <[email protected]>
` Re: less than 2 sec for response - possible?
  2016-07-19 14:41 UTC  Jim Nasby <[email protected]>
` Re: less than 2 sec for response - possible?
  2016-07-19 14:56 UTC  trafdev <[email protected]>
` Re: less than 2 sec for response - possible?
  2016-07-21 22:20 UTC  Jim Nasby <[email protected]>
  [16+ messages in thread]

Random slow queries
  2016-06-29 01:24 UTC  [email protected]
` Re: Random slow queries
  2016-06-29 12:45 UTC  Kevin Grittner <[email protected]>
` Re: Random slow queries
  2016-06-29 14:32 UTC  Igor Neyman <[email protected]>
` Re: Random slow queries
  2016-06-29 18:01 UTC  [email protected]
` Re: Random slow queries
  2016-06-29 18:04 UTC  [email protected]
` Re: Random slow queries
  2016-06-29 20:20 UTC  Tom Lane <[email protected]>
` Re: Random slow queries
  2016-06-29 21:30 UTC  Jeff Janes <[email protected]>
` Re: Random slow queries
  2016-06-29 21:44 UTC  Tom Lane <[email protected]>
` Re: Random slow queries
  2016-07-04 12:19 UTC  [email protected]
` Re: Random slow queries
  2016-07-19 14:51 UTC  Jim Nasby <[email protected]>
  [10+ messages in thread]

DELETE takes too much memory
  2016-07-04 16:35 UTC  Kouber Saparev <[email protected]>
` Re: DELETE takes too much memory
  2016-07-04 17:04 UTC  Alvaro Herrera <[email protected]>
` Re: DELETE takes too much memory
  2016-07-04 17:10 UTC  Kouber Saparev <[email protected]>
` Re: DELETE takes too much memory
  2016-07-05 18:51 UTC  Josh Berkus <[email protected]>
` Re: DELETE takes too much memory
  2016-07-05 21:03 UTC  Kouber Saparev <[email protected]>
` Re: DELETE takes too much memory
  2016-07-06 16:12 UTC  Merlin Moncure <[email protected]>
` Re: DELETE takes too much memory
  2016-07-07 07:39 UTC  Kouber Saparev <[email protected]>
` Re: DELETE takes too much memory
  2016-07-19 14:28 UTC  Jim Nasby <[email protected]>
  [8+ messages in thread]


[next (older)]

This inbox is served by agora; see mirroring instructions
for how to clone and mirror all data and code used for this inbox