pg.ddx.io  pgsql-performance@postgresql.org mailing list archive  
help / color / mirror / Atom feed
Why the index is not used ?
  2018-10-06 09:57 UTC  ROS Didier <didier.ros@edf.fr>
` Re: Why the index is not used ?
  2018-10-06 10:13 UTC  Pavel Stehule <pavel.stehule@gmail.com>
` Re: Why the index is not used ?
  2018-10-06 16:51 UTC  Vladimir Ryabtsev <greatvovan@gmail.com>
` Re: Why the index is not used ?
  2018-10-07 02:20 UTC  Paul McGarry <paul@paulmcgarry.com>
` RE: Why the index is not used ?
  2018-10-07 13:13 UTC  ROS Didier <didier.ros@edf.fr>
` RE: Why the index is not used ?
  2018-10-07 13:20 UTC  ROS Didier <didier.ros@edf.fr>
` Re: Why the index is not used ?
  2018-10-07 15:58 UTC  Francisco Olarte <folarte@peoplecall.com>
` RE: Why the index is not used ?
  2018-10-07 18:32 UTC  ROS Didier <didier.ros@edf.fr>
` RE: Why the index is not used ?
  2018-10-07 18:41 UTC  Kumar, Virendra <Virendra.Kumar@guycarp.com>
` Re: Why the index is not used ?
  2018-10-07 18:48 UTC  Vladimir Ryabtsev <greatvovan@gmail.com>
` Re: Why the index is not used ?
  2018-10-07 19:32 UTC  Vladimir Ryabtsev <greatvovan@gmail.com>
` Re: Why the index is not used ?
  2018-10-07 20:07 UTC  Tomas Vondra <tomas.vondra@2ndquadrant.com>
` Re: Why the index is not used ?
  2018-10-07 22:10 UTC  Paul McGarry <paul@paulmcgarry.com>
` RE: Why the index is not used ?
  2018-10-08 06:29 UTC  ROS Didier <didier.ros@edf.fr>
` RE: Why the index is not used ?
  2018-10-08 08:32 UTC  ROS Didier <didier.ros@edf.fr>
` Re: Why the index is not used ?
  2018-10-08 08:44 UTC  Jean-Paul Argudo <jpa@argudo.org>
` RE: Why the index is not used ?
  2018-10-08 11:47 UTC  ROS Didier <didier.ros@edf.fr>
` RE: Why the index is not used ?
  2018-10-08 12:02 UTC  ROS Didier <didier.ros@edf.fr>
` RE: Why the index is not used ?
  2018-10-08 12:07 UTC  ROS Didier <didier.ros@edf.fr>
` RE: Why the index is not used ?
  2018-10-08 13:14 UTC  Phil Endecott <spam_from_pgsql_lists@chezphil.org>
` RE: Why the index is not used ?
  2018-10-08 14:10 UTC  ROS Didier <didier.ros@edf.fr>
` RE: Why the index is not used ?
  2018-10-08 14:29 UTC  ROS Didier <didier.ros@edf.fr>
` RE: Why the index is not used ?
  2018-10-08 15:32 UTC  ROS Didier <didier.ros@edf.fr>
` Re: Why the index is not used ?
  2018-10-08 20:00 UTC  Tomas Vondra <tomas.vondra@2ndquadrant.com>
` Re: Why the index is not used ?
  2018-10-08 21:34 UTC  Paul McGarry <paul@paulmcgarry.com>
  [25+ messages in thread]

psql: fe_sendauth: no password supplied
  2018-09-30 23:36 UTC  Daulat Ram <Daulat.Ram@exponential.com>
` Re: psql: fe_sendauth: no password supplied
  2018-09-30 23:49 UTC  Justin Pryzby <pryzby@telsasoft.com>
  [2+ messages in thread]

To keep indexes in memory, is large enough effective_cache_size enough?
  2018-09-19 08:35 UTC  Sam R. <samruohola@yahoo.com>
` Re: To keep indexes in memory, is large enough effective_cache_size enough?
  2018-09-19 09:10 UTC  Sergei Kornilov <sk@zsrv.org>
` Re: To keep indexes in memory, is large enough effective_cache_size enough?
  2018-09-19 09:15 UTC  Sam R. <samruohola@yahoo.com>
` Re: To keep indexes in memory, is large enough effective_cache_size enough?
  2018-09-19 09:18 UTC  Sam R. <samruohola@yahoo.com>
` Re: To keep indexes in memory, is large enough effective_cache_size enough?
  2018-09-19 10:11 UTC  David Rowley <david.rowley@2ndquadrant.com>
` Re: To keep indexes in memory, is large enough effective_cache_size enough?
  2018-09-19 10:12 UTC  Kaixi Luo <kaixiluo@gmail.com>
` Re: To keep indexes in memory, is large enough effective_cache_size enough?
  2018-09-19 10:23 UTC  David Rowley <david.rowley@2ndquadrant.com>
` Re: To keep indexes in memory, is large enough effective_cache_size enough?
  2018-09-19 11:01 UTC  Sam R. <samruohola@yahoo.com>
` Re: To keep indexes in memory, is large enough effective_cache_size enough?
  2018-09-19 11:06 UTC  Sam R. <samruohola@yahoo.com>
` Re: To keep indexes in memory, is large enough effective_cache_size enough?
  2018-09-19 13:42 UTC  Jeff Janes <jeff.janes@gmail.com>
` Re: To keep indexes in memory, is large enough effective_cache_size enough?
  2018-09-19 14:45 UTC  Sam R. <samruohola@yahoo.com>
` Re: To keep indexes in memory, is large enough effective_cache_size enough?
  2018-09-20 03:19 UTC  Wei Shan <weishan.ang@gmail.com>
` Re: To keep indexes in memory, is large enough effective_cache_size enough?
  2018-09-20 05:17 UTC  David Rowley <david.rowley@2ndquadrant.com>
` Re: To keep indexes in memory, is large enough effective_cache_size enough?
  2018-09-25 06:36 UTC  Sam R. <samruohola@yahoo.com>
` Re: To keep indexes in memory, is large enough effective_cache_size enough?
  2018-09-25 20:55 UTC  David Rowley <david.rowley@2ndquadrant.com>
` Re: To keep indexes in memory, is large enough effective_cache_size enough?
  2018-09-28 04:45 UTC  Sam R. <samruohola@yahoo.com>
` Re: To keep indexes in memory, is large enough effective_cache_size enough?
  2018-09-28 10:32 UTC  David Rowley <david.rowley@2ndquadrant.com>
  [17+ messages in thread]

SELECT statement returns in 10seconds, but INSERT/CREATE TABLE AS with same SELECT takes 7 minutes
  2018-09-27 17:08 UTC  Arjun Ranade <ranade@nodalexchange.com>
` Re: SELECT statement returns in 10seconds, but INSERT/CREATE TABLE AS with same SELECT takes 7 minutes
  2018-09-27 17:21 UTC  Tom Lane <tgl@sss.pgh.pa.us>
` Re: SELECT statement returns in 10seconds, but INSERT/CREATE TABLE AS with same SELECT takes 7 minutes
  2018-09-27 18:52 UTC  Justin Pryzby <pryzby@telsasoft.com>
` Re: SELECT statement returns in 10seconds, but INSERT/CREATE TABLE AS with same SELECT takes 7 minutes
  2018-09-27 18:58 UTC  Arjun Ranade <ranade@nodalexchange.com>
` Re: SELECT statement returns in 10seconds, but INSERT/CREATE TABLE AS with same SELECT takes 7 minutes
  2018-09-27 19:33 UTC  Justin Pryzby <pryzby@telsasoft.com>
` Re: SELECT statement returns in 10seconds, but INSERT/CREATE TABLE AS with same SELECT takes 7 minutes
  2018-09-27 19:37 UTC  Arjun Ranade <ranade@nodalexchange.com>
` Re: SELECT statement returns in 10seconds, but INSERT/CREATE TABLE AS with same SELECT takes 7 minutes
  2018-09-27 19:51 UTC  Arjun Ranade <ranade@nodalexchange.com>
` Re: SELECT statement returns in 10seconds, but INSERT/CREATE TABLE AS with same SELECT takes 7 minutes
  2018-09-27 20:39 UTC  Vladimir Ryabtsev <greatvovan@gmail.com>
` Re: SELECT statement returns in 10seconds, but INSERT/CREATE TABLE AS with same SELECT takes 7 minutes
  2018-09-27 20:41 UTC  Tom Lane <tgl@sss.pgh.pa.us>
` Re: SELECT statement returns in 10seconds, but INSERT/CREATE TABLE AS with same SELECT takes 7 minutes
  2018-09-27 23:50 UTC  Vladimir Ryabtsev <greatvovan@gmail.com>
` Re: SELECT statement returns in 10seconds, but INSERT/CREATE TABLE AS with same SELECT takes 7 minutes
  2018-09-28 00:12 UTC  Justin Pryzby <pryzby@telsasoft.com>
  [11+ messages in thread]

reference regarding write load during different stages of checkpoint
  2018-09-26 20:05 UTC  Justin Pryzby <pryzby@telsasoft.com>

Why the sql is not executed in parallel mode
  2018-09-19 01:53 UTC  jimmy <mpokky@126.com>
` Re: Why the sql is not executed in parallel mode
  2018-09-19 03:21 UTC  Thomas Munro <thomas.munro@enterprisedb.com>
` Re: Why the sql is not executed in parallel mode
  2018-09-26 16:47 UTC  pinker <pinker@onet.eu>
  [3+ messages in thread]

link to Slow_Query_Questions from wiki/Main Page
  2018-09-08 01:29 UTC  Justin Pryzby <pryzby@telsasoft.com>
` Re: link to Slow_Query_Questions from wiki/Main Page
  2018-09-25 19:35 UTC  Justin Pryzby <pryzby@telsasoft.com>
` Re: link to Slow_Query_Questions from wiki/Main Page
  2018-09-25 19:38 UTC  Alvaro Herrera <alvherre@2ndquadrant.com>
  [3+ messages in thread]

Explain is slow with tables having many columns
  2018-09-24 19:22 UTC  legrand legrand <legrand_legrand@hotmail.com>
` Re: Explain is slow with tables having many columns
  2018-09-24 19:30 UTC  Justin Pryzby <pryzby@telsasoft.com>
` Re: Explain is slow with tables having many columns
  2018-09-24 19:43 UTC  legrand legrand <legrand_legrand@hotmail.com>
` Re: Explain is slow with tables having many columns
  2018-09-24 19:50 UTC  Andres Freund <andres@anarazel.de>
` Re: Explain is slow with tables having many columns
  2018-09-24 19:51 UTC  Andres Freund <andres@anarazel.de>
  [5+ messages in thread]

Multi-second pauses blocking even trivial activity
  2018-09-07 11:56 UTC  Patrick Molgaard <draaglom@gmail.com>
` Re: Multi-second pauses blocking even trivial activity
  2018-09-07 14:32 UTC  Jeff Janes <jeff.janes@gmail.com>
` Re: Multi-second pauses blocking even trivial activity
  2018-09-07 18:03 UTC  Patrick Molgaard <draaglom@gmail.com>
` Re: Multi-second pauses blocking even trivial activity
  2018-09-07 18:12 UTC  Andreas Kretschmer <andreas@a-kretschmer.de>
` Re: Multi-second pauses blocking even trivial activity
  2018-09-07 18:22 UTC  Joshua D. Drake <jd@commandprompt.com>
` Re: Multi-second pauses blocking even trivial activity
  2018-09-07 19:20 UTC  Jeff Janes <jeff.janes@gmail.com>
` Re: Multi-second pauses blocking even trivial activity
  2018-09-08 00:32 UTC  Patrick Molgaard <draaglom@gmail.com>
` Re: Multi-second pauses blocking even trivial activity
  2018-09-08 00:34 UTC  Patrick Molgaard <draaglom@gmail.com>
` Re: Multi-second pauses blocking even trivial activity
  2018-09-21 19:07 UTC  Patrick Molgaard <draaglom@gmail.com>
` Re: Multi-second pauses blocking even trivial activity
  2018-09-22 10:58 UTC  Andreas Kretschmer <andreas@a-kretschmer.de>
  [10+ messages in thread]

How to see/calculate size of index in memory?
  2018-09-19 08:30 UTC  Sam R. <samruohola@yahoo.com>
` Re: How to see/calculate size of index in memory?
  2018-09-19 08:42 UTC  Sergei Kornilov <sk@zsrv.org>
  [2+ messages in thread]

Select count(*) on a 2B Rows Tables Takes ~20 Hours
  2018-09-13 17:33 UTC  Fd Habash <fmhabash@gmail.com>
` Re: Select count(*) on a 2B Rows Tables Takes ~20 Hours
  2018-09-13 18:05 UTC  Justin Pryzby <pryzby@telsasoft.com>
` Re: Select count(*) on a 2B Rows Tables Takes ~20 Hours
  2018-09-13 18:12 UTC  Tom Lane <tgl@sss.pgh.pa.us>
` RE: Select count(*) on a 2B Rows Tables Takes ~20 Hours
  2018-09-13 19:35 UTC  Fd Habash <fmhabash@gmail.com>
` Re: Select count(*) on a 2B Rows Tables Takes ~20 Hours
  2018-09-13 19:43 UTC  Andres Freund <andres@anarazel.de>
` Re: Select count(*) on a 2B Rows Tables Takes ~20 Hours
  2018-09-17 16:22 UTC  Fred Habash <fmhabash@gmail.com>
` Re: Select count(*) on a 2B Rows Tables Takes ~20 Hours
  2018-09-17 19:04 UTC  Laurenz Albe <laurenz.albe@cybertec.at>
` Re: Select count(*) on a 2B Rows Tables Takes ~20 Hours
  2018-09-19 01:25 UTC  Schneider, Jeremy <schnjere@amazon.com>
  [8+ messages in thread]

LEFT JOIN LATERAL optimisation at plan time
  2018-09-18 07:06 UTC  Nicolas Paris <nicolas.paris@riseup.net>
` Re: LEFT JOIN LATERAL optimisation at plan time
  2018-09-18 22:21 UTC  Tom Lane <tgl@sss.pgh.pa.us>
  [2+ messages in thread]

pg_pub_decrypt: 10x performance hit with gpg v2
  2018-09-18 14:28 UTC  Felix A. Kater <fkater@posteo.net>

Performance problems with Thai language
  2018-09-18 07:31 UTC  Andrey Zhidenkov <andrey.zhidenkov@gmail.com>

Big image tables maintenance
  2018-09-17 12:38 UTC  still Learner <stilllearner23@gmail.com>
` Re: Big image tables maintenance
  2018-09-17 13:45 UTC  Ron <ronljohnsonjr@gmail.com>
` Re: Big image tables maintenance
  2018-09-17 13:58 UTC  Stephen Frost <sfrost@snowman.net>
` Re: Big image tables maintenance
  2018-09-17 13:59 UTC  Scott Ribe <scott_ribe@elevated-dev.com>
` Re: Big image tables maintenance
  2018-09-17 14:01 UTC  Stephen Frost <sfrost@snowman.net>
` Re: Big image tables maintenance
  2018-09-17 14:03 UTC  Stephen Frost <sfrost@snowman.net>
` Re: Big image tables maintenance
  2018-09-17 19:12 UTC  still Learner <stilllearner23@gmail.com>
` Re: Big image tables maintenance
  2018-09-17 19:34 UTC  Stephen Frost <sfrost@snowman.net>
  [8+ messages in thread]

How Do You Associate a Query With its Invoking Procedure?
  2018-09-13 19:49 UTC  Fd Habash <fmhabash@gmail.com>
` Re: How Do You Associate a Query With its Invoking Procedure?
  2018-09-14 15:38 UTC  Fred Habash <fmhabash@gmail.com>
` Re: How Do You Associate a Query With its Invoking Procedure?
  2018-09-14 16:33 UTC  David G. Johnston <david.g.johnston@gmail.com>
` Re: How Do You Associate a Query With its Invoking Procedure?
  2018-09-14 17:14 UTC  Rick Otten <rottenwindfish@gmail.com>
` Re: How Do You Associate a Query With its Invoking Procedure?
  2018-09-14 18:18 UTC  Roman Konoval <rkonoval@gmail.com>
` Re: How Do You Associate a Query With its Invoking Procedure?
  2018-09-15 09:24 UTC  Patrick Molgaard <draaglom@gmail.com>
` Re: How Do You Associate a Query With its Invoking Procedure?
  2018-09-16 21:53 UTC  Fred Habash <fmhabash@gmail.com>
  [7+ messages in thread]

Advice on machine specs for growth
  2018-09-16 12:23 UTC  Rory Campbell-Lange <rory@campbell-lange.net>

Performance of INSERT into temporary tables using psqlODBC driver
  2018-09-07 17:04 UTC  padusuma <venkata.adusumalli@gmail.com>
` Re: Performance of INSERT into temporary tables using psqlODBC driver
  2018-09-08 00:05 UTC  Tim Cross <theophilusx@gmail.com>
` Re: Performance of INSERT into temporary tables using psqlODBC driver
  2018-09-08 05:41 UTC  padusuma <venkata.adusumalli@gmail.com>
` Re: Performance of INSERT into temporary tables using psqlODBC driver
  2018-09-09 07:45 UTC  Sergei Kornilov <sk@zsrv.org>
` Re: Performance of INSERT into temporary tables using psqlODBC driver
  2018-09-09 09:39 UTC  padusuma <venkata.adusumalli@gmail.com>
` Re: Performance of INSERT into temporary tables using psqlODBC driver
  2018-09-09 22:26 UTC  Tim Cross <theophilusx@gmail.com>
` Re: Performance of INSERT into temporary tables using psqlODBC driver
  2018-09-10 04:47 UTC  padusuma <venkata.adusumalli@gmail.com>
` Re: Performance of INSERT into temporary tables using psqlODBC driver
  2018-09-13 12:57 UTC  padusuma <venkata.adusumalli@gmail.com>
` Re: Performance of INSERT into temporary tables using psqlODBC driver
  2018-09-13 22:41 UTC  Tim Cross <theophilusx@gmail.com>
` Re: Performance of INSERT into temporary tables using psqlODBC driver
  2018-09-15 17:00 UTC  padusuma <venkata.adusumalli@gmail.com>
` Re: Performance of INSERT into temporary tables using psqlODBC driver
  2018-09-16 02:19 UTC  Tim Cross <theophilusx@gmail.com>
` Re: Performance of INSERT into temporary tables using psqlODBC driver
  2018-09-16 05:29 UTC  padusuma <venkata.adusumalli@gmail.com>
  [12+ messages in thread]

GIN Index has O(N^2) complexity for array overlap operator?
  2018-09-07 15:56 UTC  Felix Geisendörfer <felix@felixge.de>

Performance difference in accessing differrent columns in a Postgres Table
  2018-07-29 05:38 UTC  Dinesh Kumar <dns98944@gmail.com>
` Re: Performance difference in accessing differrent columns in a Postgres Table
  2018-07-29 21:53 UTC  David Rowley <david.rowley@2ndquadrant.com>
` Re: Performance difference in accessing differrent columns in a Postgres Table
  2018-07-29 23:00 UTC  Tom Lane <tgl@sss.pgh.pa.us>
` Re: Performance difference in accessing differrent columns in a Postgres Table
  2018-07-30 04:11 UTC  Pavel Stehule <pavel.stehule@gmail.com>
` Re: Performance difference in accessing differrent columns in a Postgres Table
  2018-07-30 11:19 UTC  Jeff Janes <jeff.janes@gmail.com>
` Re: Performance difference in accessing differrent columns in a Postgres Table
  2018-07-30 16:01 UTC  Pavel Stehule <pavel.stehule@gmail.com>
` Re: Performance difference in accessing differrent columns in a Postgres Table
  2018-07-30 17:23 UTC  Andres Freund <andres@anarazel.de>
` Re: Performance difference in accessing differrent columns in a Postgres Table
  2018-07-30 17:31 UTC  Jeff Janes <jeff.janes@gmail.com>
` Re: Performance difference in accessing differrent columns in a Postgres Table
  2018-07-30 17:45 UTC  Andres Freund <andres@anarazel.de>
` Re: Performance difference in accessing differrent columns in a Postgres Table
  2018-07-30 19:02 UTC  Andres Freund <andres@anarazel.de>
` Re: Performance difference in accessing differrent columns in a Postgres Table
  2018-07-31 16:56 UTC  Jeff Janes <jeff.janes@gmail.com>
` Re: Performance difference in accessing differrent columns in a Postgres Table
  2018-07-31 17:35 UTC  Andres Freund <andres@anarazel.de>
` Re: Performance difference in accessing differrent columns in a Postgres Table
  2018-08-01 15:21 UTC  Jeff Janes <jeff.janes@gmail.com>
` Re: Performance difference in accessing differrent columns in a Postgres Table
  2018-09-05 04:21 UTC  Dinesh Kumar <dns98944@gmail.com>
` Re: Performance difference in accessing differrent columns in a Postgres Table
  2018-09-05 16:00 UTC  Jeff Janes <jeff.janes@gmail.com>
` Re: Performance difference in accessing differrent columns in a Postgres Table
  2018-09-05 16:07 UTC  Jeff Janes <jeff.janes@gmail.com>
` Re: Performance difference in accessing differrent columns in a Postgres Table
  2018-09-07 03:28 UTC  Dinesh Kumar <dns98944@gmail.com>
  [17+ messages in thread]

query gets very slow when :jsonb ?& operator is used
  2018-09-06 23:51 UTC  davidjesse091@aol.com
` Re: query gets very slow when :jsonb ?& operator is used
  2018-09-07 01:39 UTC  Jeff Janes <jeff.janes@gmail.com>
  [2+ messages in thread]

Guideline To Resolve LWLock:SubtransControlLock
  2018-08-16 18:19 UTC  Fred Habash <fmhabash@gmail.com>
` Re: Guideline To Resolve LWLock:SubtransControlLock
  2018-08-16 18:36 UTC  Alvaro Herrera <alvherre@2ndquadrant.com>
` Re: Guideline To Resolve LWLock:SubtransControlLock
  2018-08-17 18:07 UTC  Fred Habash <fmhabash@gmail.com>
` Re: Guideline To Resolve LWLock:SubtransControlLock
  2018-08-17 18:26 UTC  Alvaro Herrera <alvherre@2ndquadrant.com>
` Re: Guideline To Resolve LWLock:SubtransControlLock
  2018-08-20 20:52 UTC  Fred Habash <fmhabash@gmail.com>
` Re: Guideline To Resolve LWLock:SubtransControlLock
  2018-08-20 21:00 UTC  Alvaro Herrera <alvherre@2ndquadrant.com>
` Re: Guideline To Resolve LWLock:SubtransControlLock
  2018-08-20 22:14 UTC  Jeremy Schneider <schnjere@amazon.com>
` RE: Guideline To Resolve LWLock:SubtransControlLock
  2018-08-22 15:48 UTC  Fd Habash <fmhabash@gmail.com>
` RE: Guideline To Resolve LWLock:SubtransControlLock
  2018-08-22 20:07 UTC  Fd Habash <fmhabash@gmail.com>
` Re: Guideline To Resolve LWLock:SubtransControlLock
  2018-09-06 15:16 UTC  Jeremy Schneider <schnjere@amazon.com>
  [10+ messages in thread]

Query is slow when run for first time; subsequent execution is fast
  2018-01-10 11:59 UTC  Nandakumar M <m.nanda92@gmail.com>
` Re: Query is slow when run for first time; subsequent execution is fast
  2018-01-10 19:34 UTC  Jeff Janes <jeff.janes@gmail.com>
` Re: Query is slow when run for first time; subsequent execution is fast
  2018-01-12 08:03 UTC  Nandakumar M <m.nanda92@gmail.com>
` Re: Query is slow when run for first time; subsequent execution is fast
  2018-01-12 10:04 UTC  Pavel Stehule <pavel.stehule@gmail.com>
` Fwd: Re: Query is slow when run for first time; subsequent execution is fast
  2018-01-16 11:46 UTC  Nandakumar M <m.nanda92@gmail.com>
` Re: Query is slow when run for first time; subsequent execution is fast
  2018-01-16 12:20 UTC  Thomas Kellerer <spam_eater@gmx.net>
` Re: Query is slow when run for first time; subsequent execution is fast
  2018-01-17 05:18 UTC  Jeff Janes <jeff.janes@gmail.com>
` RE: Query is slow when run for first time; subsequent execution is fast
  2018-01-17 07:25 UTC  POUSSEL, Guillaume <guillaume.poussel@sogeti.com>
` RE: Query is slow when run for first time; subsequent execution is fast
  2018-01-17 10:09 UTC  Nandakumar M <m.nanda92@gmail.com>
` Re: Query is slow when run for first time; subsequent execution is fast
  2018-01-18 01:55 UTC  Michael Paquier <michael.paquier@gmail.com>
` Re: Query is slow when run for first time; subsequent execution is fast
  2018-01-26 07:43 UTC  Nandakumar M <m.nanda92@gmail.com>
` RE: Query is slow when run for first time; subsequent execution is fast
  2018-09-04 07:16 UTC  jimmy <mpokky@126.com>
` Re: Query is slow when run for first time; subsequent execution is fast
  2018-09-05 00:35 UTC  Jeff Janes <jeff.janes@gmail.com>
  [13+ messages in thread]

Inconsistent query times and spiky CPU with GIN tsvector search
  2018-09-04 18:09 UTC  Scott Rankin <srankin@motus.com>
` Re: Inconsistent query times and spiky CPU with GIN tsvector search
  2018-09-04 19:15 UTC  Laurenz Albe <laurenz.albe@cybertec.at>
  [2+ messages in thread]

(no subject)
  2007-11-02 20:03 UTC  Mark F <enigma_3319@hotmail.com>
` trying to delete most of the table by range of date col
  2018-09-03 06:27 UTC  Mariel Cherkassky <mariel.cherkassky@gmail.com>
` Re: trying to delete most of the table by range of date col
  2018-09-03 07:06 UTC  Justin Pryzby <pryzby@telsasoft.com>
` Re: trying to delete most of the table by range of date col
  2018-09-03 07:35 UTC  Andreas Kretschmer <andreas@a-kretschmer.de>
` Re: trying to delete most of the table by range of date col
  2018-09-03 08:17 UTC  Mariel Cherkassky <mariel.cherkassky@gmail.com>
` Re: trying to delete most of the table by range of date col
  2018-09-03 08:35 UTC  Sergei Kornilov <sk@zsrv.org>
` Re: trying to delete most of the table by range of date col
  2018-09-03 08:50 UTC  Mariel Cherkassky <mariel.cherkassky@gmail.com>
` Re: trying to delete most of the table by range of date col
  2018-09-03 09:23 UTC  Justin Pryzby <pryzby@telsasoft.com>
` Re: trying to delete most of the table by range of date col
  2018-09-03 10:25 UTC  Mariel Cherkassky <mariel.cherkassky@gmail.com>
` Re: trying to delete most of the table by range of date col
  2018-09-03 11:09 UTC  Carrie Berlin <berlincarrie@gmail.com>
` Re: trying to delete most of the table by range of date col
  2018-09-03 11:19 UTC  Mariel Cherkassky <mariel.cherkassky@gmail.com>
` Re: trying to delete most of the table by range of date col
  2018-09-03 14:03 UTC  Carrie Berlin <berlincarrie@gmail.com>
` Re: trying to delete most of the table by range of date col
  2018-09-03 15:25 UTC  Jeff Janes <jeff.janes@gmail.com>
` Re: trying to delete most of the table by range of date col
  2018-09-03 16:27 UTC  Mariel Cherkassky <mariel.cherkassky@gmail.com>
  [14+ 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