Mailing lists [pgsql-performance]

3 September 2018

• 12:27   trying to delete most of the table by range of date col Mariel Cherkassky
• 12:27   trying to delete most of the table by range of date col Mariel Cherkassky
• 13:06   Re: trying to delete most of the table by range of date col Justin Pryzby
• 13:35   Re: trying to delete most of the table by range of date col Andreas Kretschmer
• 14:17   Re: trying to delete most of the table by range of date col Mariel Cherkassky
• 14:35   Re: trying to delete most of the table by range of date col Sergei Kornilov
• 14:35   Re: trying to delete most of the table by range of date col Sergei Kornilov
• 14:50   Re: trying to delete most of the table by range of date col Mariel Cherkassky
• 14:50   Re: trying to delete most of the table by range of date col Mariel Cherkassky
• 15:23   Re: trying to delete most of the table by range of date col Justin Pryzby
• 16:25   Re: trying to delete most of the table by range of date col Mariel Cherkassky
• 17:09   Re: trying to delete most of the table by range of date col Carrie Berlin
• 17:09   Re: trying to delete most of the table by range of date col Carrie Berlin
• 17:19   Re: trying to delete most of the table by range of date col Mariel Cherkassky
• 17:19   Re: trying to delete most of the table by range of date col Mariel Cherkassky
• 20:03   Re: trying to delete most of the table by range of date col Carrie Berlin
• 20:03   Re: trying to delete most of the table by range of date col Carrie Berlin
• 21:25   Re: trying to delete most of the table by range of date col Jeff Janes
• 22:27   Re: trying to delete most of the table by range of date col Mariel Cherkassky

4 September 2018

• 13:16   RE: Query is slow when run for first time; subsequent execution isfast jimmy

5 September 2018

• 00:09   Inconsistent query times and spiky CPU with GIN tsvector search Scott Rankin
• 01:15   Re: Inconsistent query times and spiky CPU with GIN tsvector search Laurenz Albe
• 06:35   Re: Query is slow when run for first time; subsequent execution is fast Jeff Janes
• 10:21   Re: Performance difference in accessing differrent columns in aPostgres Table Dinesh Kumar
• 22:00   Re: Performance difference in accessing differrent columns in aPostgres Table Jeff Janes
• 22:07   Re: Performance difference in accessing differrent columns in aPostgres Table Jeff Janes

6 September 2018

• 21:16   Re: Guideline To Resolve LWLock:SubtransControlLock Jeremy Schneider

7 September 2018

• 05:51   query gets very slow when :jsonb ?& operator is used 
• 07:39   Re: query gets very slow when :jsonb ?& operator is used Jeff Janes
• 09:28   Re: Performance difference in accessing differrent columns in aPostgres Table Dinesh Kumar
• 17:56   Multi-second pauses blocking even trivial activity Patrick Molgaard
• 20:32   Re: Multi-second pauses blocking even trivial activity Jeff Janes
• 21:56   GIN Index has O(N^2) complexity for array overlap operator? Felix Geisendörfer
• 22:17   Partial index plan/cardinality costing James Coleman
• 23:04   Performance of INSERT into temporary tables using psqlODBC driver padusuma

8 September 2018

• 00:03   Re: Multi-second pauses blocking even trivial activity Patrick Molgaard
• 00:12   Re: Multi-second pauses blocking even trivial activity Andreas Kretschmer
• 00:22   Re: Multi-second pauses blocking even trivial activity Joshua D. Drake
• 01:20   Re: Multi-second pauses blocking even trivial activity Jeff Janes
• 06:05   Re: Performance of INSERT into temporary tables using psqlODBC driver Tim Cross
• 06:32   Re: Multi-second pauses blocking even trivial activity Patrick Molgaard
• 06:34   Re: Multi-second pauses blocking even trivial activity Patrick Molgaard
• 11:41   Re: Performance of INSERT into temporary tables using psqlODBCdriver padusuma

9 September 2018

• 13:45   Re: Performance of INSERT into temporary tables using psqlODBC driver Sergei Kornilov
• 15:39   Re: Performance of INSERT into temporary tables using psqlODBCdriver padusuma

10 September 2018

• 04:26   Re: Performance of INSERT into temporary tables using psqlODBC driver Tim Cross
• 10:47   Re: Performance of INSERT into temporary tables using psqlODBCdriver padusuma

13 September 2018

• 18:57   Re: Performance of INSERT into temporary tables using psqlODBCdriver padusuma
• 23:33   Select count(*) on a 2B Rows Tables Takes ~20 Hours Fd Habash

14 September 2018

• 00:05   Re: Select count(*) on a 2B Rows Tables Takes ~20 Hours Justin Pryzby
• 00:12   Re: Select count(*) on a 2B Rows Tables Takes ~20 Hours Tom Lane
• 01:35   RE: Select count(*) on a 2B Rows Tables Takes ~20 Hours Fd Habash
• 01:43   Re: Select count(*) on a 2B Rows Tables Takes ~20 Hours Andres Freund
• 01:49   How Do You Associate a Query With its Invoking Procedure?  Fd Habash
• 04:41   Re: Performance of INSERT into temporary tables using psqlODBC driver Tim Cross
• 21:38   Re: How Do You Associate a Query With its Invoking Procedure? Fred Habash
• 22:33   Re: How Do You Associate a Query With its Invoking Procedure? David G. Johnston
• 23:14   Re: How Do You Associate a Query With its Invoking Procedure? Rick Otten

15 September 2018

• 00:18   Re: How Do You Associate a Query With its Invoking Procedure? Roman Konoval
• 15:24   Re: How Do You Associate a Query With its Invoking Procedure? Patrick Molgaard
• 23:00   Re: Performance of INSERT into temporary tables using psqlODBCdriver padusuma

16 September 2018

• 08:19   Re: Performance of INSERT into temporary tables using psqlODBC driver Tim Cross
• 11:29   Re: Performance of INSERT into temporary tables using psqlODBCdriver padusuma
• 18:23   Advice on machine specs for growth Rory Campbell-Lange

17 September 2018

• 03:53   Re: How Do You Associate a Query With its Invoking Procedure? Fred Habash
• 22:22   Re: Select count(*) on a 2B Rows Tables Takes ~20 Hours Fred Habash

18 September 2018

• 01:04   Re: Select count(*) on a 2B Rows Tables Takes ~20 Hours Laurenz Albe
• 13:06   LEFT JOIN LATERAL optimisation at plan time Nicolas Paris
• 13:31   Performance problems with Thai language Andrey Zhidenkov
• 20:28   pg_pub_decrypt: 10x performance hit with gpg v2 Felix A. Kater

19 September 2018

• 04:21   Re: LEFT JOIN LATERAL optimisation at plan time Tom Lane
• 07:25   Re: Select count(*) on a 2B Rows Tables Takes ~20 Hours Schneider, Jeremy
• 14:30   How to see/calculate size of index in memory? Sam R.
• 14:35   To keep indexes in memory, is large enough effective_cache_sizeenough? Sam R.
• 14:42   Re: How to see/calculate size of index in memory? Sergei Kornilov
• 15:10   Re: To keep indexes in memory, is large enough effective_cache_size enough? Sergei Kornilov
• 15:15   Re: To keep indexes in memory, is large enough effective_cache_sizeenough? Sam R.
• 15:18   Re: To keep indexes in memory, is large enough effective_cache_sizeenough? Sam R.
• 16:11   Re: To keep indexes in memory, is large enough effective_cache_size enough? David Rowley
• 16:12   Re: To keep indexes in memory, is large enough effective_cache_size enough? Kaixi Luo
• 16:23   Re: To keep indexes in memory, is large enough effective_cache_size enough? David Rowley
• 17:01   Re: To keep indexes in memory, is large enough effective_cache_sizeenough? Sam R.
• 17:06   Re: To keep indexes in memory, is large enough effective_cache_sizeenough? Sam R.
• 19:42   Re: To keep indexes in memory, is large enough effective_cache_size enough? Jeff Janes
• 20:45   Re: To keep indexes in memory, is large enough effective_cache_sizeenough? Sam R.

20 September 2018

• 09:19   Re: To keep indexes in memory, is large enough effective_cache_size enough? Wei Shan
• 11:17   Re: To keep indexes in memory, is large enough effective_cache_size enough? David Rowley

21 September 2018

• 06:07   Why could different data in a table be processed with different performance? Vladimir Ryabtsev
• 06:42   Re: Why could different data in a table be processed with differentperformance? Justin Pryzby
• 07:54   Re: Why could different data in a table be processed with different performance? Vladimir Ryabtsev
• 08:29   Re: Why could different data in a table be processed with differentperformance? Justin Pryzby
• 09:17   Re: Why could different data in a table be processed with differentperformance? Laurenz Albe
• 12:28   Re: Why could different data in a table be processed with different performance? Vladimir Ryabtsev
• 19:08   Re: Why could different data in a table be processed with differentperformance? Fabio Pardi
• 19:12   Re: Why could different data in a table be processed with differentperformance? Fabio Pardi

22 September 2018

• 01:07   Re: Multi-second pauses blocking even trivial activity Patrick Molgaard
• 15:19   Re: Why could different data in a table be processed with different performance? Vladimir Ryabtsev
• 16:32   Re: Why could different data in a table be processed with different performance? Vladimir Ryabtsev
• 16:58   Re: Multi-second pauses blocking even trivial activity Andreas Kretschmer
• 20:49   Re: Why could different data in a table be processed with different performance? didier

24 September 2018

• 13:44   Re: Why could different data in a table be processed with different performance? Vladimir Ryabtsev
• 20:47   Re: Why could different data in a table be processed with differentperformance? Fabio Pardi

25 September 2018

• 01:22   Explain is slow with tables having many columns legrand legrand
• 01:30   Re: Explain is slow with tables having many columns Justin Pryzby
• 01:43   Re: Explain is slow with tables having many columns legrand legrand
• 01:50   Re: Explain is slow with tables having many columns Andres Freund
• 01:50   Re: Explain is slow with tables having many columns Andres Freund
• 01:51   Re: Explain is slow with tables having many columns Andres Freund
• 04:28   Re: Why could different data in a table be processed with different performance? Vladimir Ryabtsev
• 05:34   Re: Why could different data in a table be processed with differentperformance? Justin Pryzby
• 06:21   Re: Why could different data in a table be processed with different performance? Vladimir Ryabtsev
• 06:59   Re: Why could different data in a table be processed with different performance? Vladimir Ryabtsev
• 07:11   Re: Why could different data in a table be processed with different performance? Vladimir Ryabtsev
• 08:19   Re: Why could different data in a table be processed with differentperformance? Justin Pryzby
• 08:31   Re: Why could different data in a table be processed with different performance? Vladimir Ryabtsev
• 08:38   Re: Why could different data in a table be processed with differentperformance? Justin Pryzby
• 09:40   Re: Why could different data in a table be processed with different performance? Vladimir Ryabtsev
• 12:32   Re: Why could different data in a table be processed with differentperformance? Gasper Zejn
• 12:36   Re: To keep indexes in memory, is large enough effective_cache_sizeenough? Sam R.
• 15:14   Re: Why could different data in a table be processed with differentperformance? Fabio Pardi

26 September 2018

• 01:35   Re: link to Slow_Query_Questions from wiki/Main Page Justin Pryzby
• 01:38   Re: link to Slow_Query_Questions from wiki/Main Page Alvaro Herrera
• 02:28   Re: Why could different data in a table be processed with different performance? Vladimir Ryabtsev
• 02:55   Re: To keep indexes in memory, is large enough effective_cache_size enough? David Rowley
• 23:15   Re: Why could different data in a table be processed with different performance? Vladimir Ryabtsev

27 September 2018

• 02:05   reference regarding write load during different stages of checkpoint Justin Pryzby
• 15:25   Re: Why could different data in a table be processed with differentperformance? Fabio Pardi
• 23:08   SELECT statement returns in 10seconds, but INSERT/CREATE TABLE ASwith same SELECT takes 7 minutes Arjun Ranade
• 23:21   Re: SELECT statement returns in 10seconds, but INSERT/CREATE TABLE AS with same SELECT takes 7 minutes Tom Lane

28 September 2018

• 00:52   Re: SELECT statement returns in 10seconds, but INSERT/CREATE TABLEAS with same SELECT takes 7 minutes Justin Pryzby
• 00:58   Re: SELECT statement returns in 10seconds, but INSERT/CREATE TABLE ASwith same SELECT takes 7 minutes Arjun Ranade
• 01:33   Re: SELECT statement returns in 10seconds, but INSERT/CREATE TABLEAS with same SELECT takes 7 minutes Justin Pryzby
• 01:37   Re: SELECT statement returns in 10seconds, but INSERT/CREATE TABLE ASwith same SELECT takes 7 minutes Arjun Ranade
• 01:51   Re: SELECT statement returns in 10seconds, but INSERT/CREATE TABLE ASwith same SELECT takes 7 minutes Arjun Ranade
• 02:39   Re: SELECT statement returns in 10seconds, but INSERT/CREATE TABLE ASwith same SELECT takes 7 minutes Vladimir Ryabtsev
• 02:41   Re: SELECT statement returns in 10seconds, but INSERT/CREATE TABLE AS with same SELECT takes 7 minutes Tom Lane
• 05:50   Re: SELECT statement returns in 10seconds, but INSERT/CREATE TABLE ASwith same SELECT takes 7 minutes Vladimir Ryabtsev
• 06:12   Re: SELECT statement returns in 10seconds, but INSERT/CREATE TABLEAS with same SELECT takes 7 minutes Justin Pryzby
• 10:45   Re: To keep indexes in memory, is large enough effective_cache_sizeenough? Sam R.
• 15:16   Re: Why could different data in a table be processed with different performance? Vladimir Ryabtsev
• 15:56   Re: Why could different data in a table be processed with different performance? Vladimir Ryabtsev
• 16:32   Re: To keep indexes in memory, is large enough effective_cache_size enough? David Rowley
• 20:15   Re: Why could different data in a table be processed with differentperformance? Fabio Pardi

29 September 2018

• 01:51   Re: Why could different data in a table be processed with different performance? Vladimir Ryabtsev