pgsql-performance - September 2018

Discussion of PostgreSQL's performance issues. Please see Guide to reporting problems and Slow Query Questions for some tips on how to write your performance question.

Search the Archives

(enter a message-id to go directly to that message)
Advanced Search

Browse Archives

Prev | Next
Jump to day: 1 2 3 4 5 6 7 8 9 10 13 14 15 16 17 18 19 20 21 22 24 25 26 27 28 29 30

Sept. 3, 2018

Thread Author Time
trying to delete most of the table by range of date col Mariel Cherkassky 06:27
Re: trying to delete most of the table by range of date col Justin Pryzby 07:06
Re: trying to delete most of the table by range of date col Andreas Kretschmer 07:35
Re: trying to delete most of the table by range of date col Mariel Cherkassky 08:17
Re: trying to delete most of the table by range of date col Sergei Kornilov 08:35
Re: trying to delete most of the table by range of date col Mariel Cherkassky 08:50
Re: trying to delete most of the table by range of date col Justin Pryzby 09:23
Re: trying to delete most of the table by range of date col Mariel Cherkassky 10:25
Re: trying to delete most of the table by range of date col Carrie Berlin 11:09
Re: trying to delete most of the table by range of date col Mariel Cherkassky 11:19
Re: trying to delete most of the table by range of date col Carrie Berlin 14:03
Re: trying to delete most of the table by range of date col Jeff Janes 15:25
Re: trying to delete most of the table by range of date col Mariel Cherkassky 16:27

Sept. 4, 2018

Thread Author Time
RE: Query is slow when run for first time; subsequent execution is fast jimmy 07:16
Re: [HACKERS] proposal: schema variables Dean Rasheed 07:21
Re: [HACKERS] proposal: schema variables Pavel Stehule 13:00
Inconsistent query times and spiky CPU with GIN tsvector search Scott Rankin 18:09
Re: Inconsistent query times and spiky CPU with GIN tsvector search Laurenz Albe 19:15

Sept. 5, 2018

Thread Author Time
Re: Query is slow when run for first time; subsequent execution is fast Jeff Janes 00:35
Re: Performance difference in accessing differrent columns in a Postgres Table Dinesh Kumar 04:21
Re: Performance difference in accessing differrent columns in a Postgres Table Jeff Janes 16:00
Re: Performance difference in accessing differrent columns in a Postgres Table Jeff Janes 16:07

Sept. 6, 2018

Thread Author Time
Re: [HACKERS] proposal: schema variables 📎 Pavel Stehule 08:30
Re: Guideline To Resolve LWLock:SubtransControlLock Jeremy Schneider 15:16
query gets very slow when :jsonb ?& operator is used davidjesse091 23:51

Sept. 7, 2018

Thread Author Time
Re: query gets very slow when :jsonb ?& operator is used Jeff Janes 01:39
Re: Performance difference in accessing differrent columns in a Postgres Table Dinesh Kumar 03:28
Multi-second pauses blocking even trivial activity Patrick Molgaard 11:56
Re: [HACKERS] proposal: schema variables Fabien COELHO 12:34
Re: [HACKERS] proposal: schema variables Pavel Stehule 14:28
Re: Multi-second pauses blocking even trivial activity Jeff Janes 14:32
GIN Index has O(N^2) complexity for array overlap operator? Felix Geisendörfer 15:56
Partial index plan/cardinality costing 📎 James Coleman 16:17
Performance of INSERT into temporary tables using psqlODBC driver padusuma 17:04
Re: Multi-second pauses blocking even trivial activity Patrick Molgaard 18:03
Re: Multi-second pauses blocking even trivial activity Andreas Kretschmer 18:12
Re: Multi-second pauses blocking even trivial activity Joshua D. Drake 18:22
Re: Multi-second pauses blocking even trivial activity Jeff Janes 19:20

Sept. 8, 2018

Thread Author Time
Re: Performance of INSERT into temporary tables using psqlODBC driver Tim Cross 00:05
Re: Multi-second pauses blocking even trivial activity Patrick Molgaard 00:32
Re: Multi-second pauses blocking even trivial activity Patrick Molgaard 00:34
link to Slow_Query_Questions from wiki/Main Page Justin Pryzby 01:29
Re: Performance of INSERT into temporary tables using psqlODBC driver padusuma 05:41

Sept. 9, 2018

Thread Author Time
Re: Performance of INSERT into temporary tables using psqlODBC driver Sergei Kornilov 07:45
Re: Performance of INSERT into temporary tables using psqlODBC driver padusuma 09:39
Re: Performance of INSERT into temporary tables using psqlODBC driver Tim Cross 22:26

Sept. 10, 2018

Thread Author Time
Re: Performance of INSERT into temporary tables using psqlODBC driver padusuma 04:47

Sept. 13, 2018

Thread Author Time
Re: Performance of INSERT into temporary tables using psqlODBC driver padusuma 12:57
Select count(*) on a 2B Rows Tables Takes ~20 Hours Fd Habash 17:33
Re: Select count(*) on a 2B Rows Tables Takes ~20 Hours Justin Pryzby 18:05
Re: Select count(*) on a 2B Rows Tables Takes ~20 Hours Tom Lane 18:12
RE: Select count(*) on a 2B Rows Tables Takes ~20 Hours Fd Habash 19:35
Re: Select count(*) on a 2B Rows Tables Takes ~20 Hours Andres Freund 19:43
How Do You Associate a Query With its Invoking Procedure? Fd Habash 19:49
Re: Performance of INSERT into temporary tables using psqlODBC driver Tim Cross 22:41

Sept. 14, 2018

Thread Author Time
Re: How Do You Associate a Query With its Invoking Procedure? Fred Habash 15:38
Re: How Do You Associate a Query With its Invoking Procedure? David G. Johnston 16:33
Re: How Do You Associate a Query With its Invoking Procedure? Rick Otten 17:14
Re: How Do You Associate a Query With its Invoking Procedure? Roman Konoval 18:18
Re: [HACKERS] proposal: schema variables 📎 Pavel Stehule 21:31

Sept. 15, 2018

Thread Author Time
Re: How Do You Associate a Query With its Invoking Procedure? Patrick Molgaard 09:24
Re: [HACKERS] proposal: schema variables 📎 Pavel Stehule 16:06
Re: Performance of INSERT into temporary tables using psqlODBC driver padusuma 17:00

Sept. 16, 2018

Thread Author Time
Re: Performance of INSERT into temporary tables using psqlODBC driver Tim Cross 02:19
Re: Performance of INSERT into temporary tables using psqlODBC driver padusuma 05:29
Advice on machine specs for growth Rory Campbell-Lange 12:23
Re: How Do You Associate a Query With its Invoking Procedure? Fred Habash 21:53

Sept. 17, 2018

Thread Author Time
Big image tables maintenance still Learner 12:38
Re: Big image tables maintenance Ron 13:45
Re: Big image tables maintenance Stephen Frost 13:58
Re: Big image tables maintenance Scott Ribe 13:59
Re: Big image tables maintenance Stephen Frost 14:01
Re: Big image tables maintenance Stephen Frost 14:03
Re: Select count(*) on a 2B Rows Tables Takes ~20 Hours Fred Habash 16:22
Re: Select count(*) on a 2B Rows Tables Takes ~20 Hours Laurenz Albe 19:04
Re: Big image tables maintenance still Learner 19:12
Re: Big image tables maintenance Stephen Frost 19:34
Re: [HACKERS] proposal: schema variables 📎 Pavel Stehule 19:46

Sept. 18, 2018

Thread Author Time
LEFT JOIN LATERAL optimisation at plan time Nicolas Paris 07:06
Performance problems with Thai language 📎 Andrey Zhidenkov 07:31
pg_pub_decrypt: 10x performance hit with gpg v2 Felix A. Kater 14:28
Re: LEFT JOIN LATERAL optimisation at plan time Tom Lane 22:21

Sept. 19, 2018

Thread Author Time
Re: Select count(*) on a 2B Rows Tables Takes ~20 Hours Schneider, Jeremy 01:25
Why the sql is not executed in parallel mode jimmy 01:53
Re: Why the sql is not executed in parallel mode Thomas Munro 03:21
Re: [HACKERS] proposal: schema variables 📎 Pavel Stehule 08:30
How to see/calculate size of index in memory? Sam R. 08:30
To keep indexes in memory, is large enough effective_cache_size enough? Sam R. 08:35
Re: How to see/calculate size of index in memory? Sergei Kornilov 08:42
Re: To keep indexes in memory, is large enough effective_cache_size enough? Sergei Kornilov 09:10
Re: To keep indexes in memory, is large enough effective_cache_size enough? Sam R. 09:15
Re: To keep indexes in memory, is large enough effective_cache_size enough? Sam R. 09:18
Re: To keep indexes in memory, is large enough effective_cache_size enough? David Rowley 10:11
Re: To keep indexes in memory, is large enough effective_cache_size enough? Kaixi Luo 10:12
Re: To keep indexes in memory, is large enough effective_cache_size enough? David Rowley 10:23
Re: To keep indexes in memory, is large enough effective_cache_size enough? Sam R. 11:01
Re: To keep indexes in memory, is large enough effective_cache_size enough? Sam R. 11:06
Re: [HACKERS] proposal: schema variables Arthur Zakirov 11:23
Re: [HACKERS] proposal: schema variables Pavel Stehule 12:08
Re: [HACKERS] proposal: schema variables Arthur Zakirov 12:53
Re: To keep indexes in memory, is large enough effective_cache_size enough? Jeff Janes 13:42
Re: [HACKERS] proposal: schema variables Pavel Stehule 14:36
Re: To keep indexes in memory, is large enough effective_cache_size enough? Sam R. 14:45

Sept. 20, 2018

Thread Author Time
Re: To keep indexes in memory, is large enough effective_cache_size enough? Wei Shan 03:19
Re: To keep indexes in memory, is large enough effective_cache_size enough? David Rowley 05:17
Re: [HACKERS] proposal: schema variables 📎 Pavel Stehule 09:08

Sept. 21, 2018

Thread Author Time
Why could different data in a table be processed with different performance? Vladimir Ryabtsev 00:07
Re: Why could different data in a table be processed with different performance? Justin Pryzby 00:42
Re: Why could different data in a table be processed with different performance? Vladimir Ryabtsev 01:54
Re: Why could different data in a table be processed with different performance? Justin Pryzby 02:29
Re: Why could different data in a table be processed with different performance? Laurenz Albe 03:17
Re: Why could different data in a table be processed with different performance? Vladimir Ryabtsev 06:28
Re: Why could different data in a table be processed with different performance? Fabio Pardi 13:08
Re: Why could different data in a table be processed with different performance? Fabio Pardi 13:12
Re: Multi-second pauses blocking even trivial activity Patrick Molgaard 19:07
Re: [HACKERS] proposal: schema variables Arthur Zakirov 19:46

Sept. 22, 2018

Thread Author Time
Re: [HACKERS] proposal: schema variables Pavel Stehule 03:35
Re: [HACKERS] proposal: schema variables 📎 Pavel Stehule 06:00
Re: Why could different data in a table be processed with different performance? Vladimir Ryabtsev 09:19
Re: Why could different data in a table be processed with different performance? Vladimir Ryabtsev 10:32
Re: Multi-second pauses blocking even trivial activity Andreas Kretschmer 10:58
Re: Why could different data in a table be processed with different performance? didier 14:49

Sept. 24, 2018

Thread Author Time
Re: Why could different data in a table be processed with different performance? Vladimir Ryabtsev 07:44
Re: Why could different data in a table be processed with different performance? Fabio Pardi 14:47
Explain is slow with tables having many columns legrand legrand 19:22
Re: Explain is slow with tables having many columns Justin Pryzby 19:30
Re: Explain is slow with tables having many columns legrand legrand 19:43
Re: Explain is slow with tables having many columns Andres Freund 19:50
Re: Explain is slow with tables having many columns Andres Freund 19:51
Re: Why could different data in a table be processed with different performance? Vladimir Ryabtsev 22:28
Re: Why could different data in a table be processed with different performance? Justin Pryzby 23:34

Sept. 25, 2018

Thread Author Time
Re: Why could different data in a table be processed with different performance? Vladimir Ryabtsev 00:21
Re: Why could different data in a table be processed with different performance? Vladimir Ryabtsev 00:59
Re: Why could different data in a table be processed with different performance? Vladimir Ryabtsev 01:11
Re: Why could different data in a table be processed with different performance? Justin Pryzby 02:19
Re: Why could different data in a table be processed with different performance? Vladimir Ryabtsev 02:31
Re: Why could different data in a table be processed with different performance? Justin Pryzby 02:38
Re: Why could different data in a table be processed with different performance? Vladimir Ryabtsev 03:40
Re: Why could different data in a table be processed with different performance? Gasper Zejn 06:32
Re: To keep indexes in memory, is large enough effective_cache_size enough? Sam R. 06:36
Re: Why could different data in a table be processed with different performance? Fabio Pardi 09:14
Re: link to Slow_Query_Questions from wiki/Main Page Justin Pryzby 19:35
Re: link to Slow_Query_Questions from wiki/Main Page Alvaro Herrera 19:38
Re: Why could different data in a table be processed with different performance? Vladimir Ryabtsev 20:28
Re: To keep indexes in memory, is large enough effective_cache_size enough? David Rowley 20:55

Sept. 26, 2018

Thread Author Time
Re: Why the sql is not executed in parallel mode pinker 16:47
Re: Why could different data in a table be processed with different performance? Vladimir Ryabtsev 17:15
reference regarding write load during different stages of checkpoint Justin Pryzby 20:05

Sept. 27, 2018

Thread Author Time
Re: Why could different data in a table be processed with different performance? Fabio Pardi 09:25
SELECT statement returns in 10seconds, but INSERT/CREATE TABLE AS with same SELECT takes 7 minutes Arjun Ranade 17:08
Re: SELECT statement returns in 10seconds, but INSERT/CREATE TABLE AS with same SELECT takes 7 minutes Tom Lane 17:21
Re: SELECT statement returns in 10seconds, but INSERT/CREATE TABLE AS with same SELECT takes 7 minutes Justin Pryzby 18:52
Re: SELECT statement returns in 10seconds, but INSERT/CREATE TABLE AS with same SELECT takes 7 minutes Arjun Ranade 18:58
Re: SELECT statement returns in 10seconds, but INSERT/CREATE TABLE AS with same SELECT takes 7 minutes Justin Pryzby 19:33
Re: SELECT statement returns in 10seconds, but INSERT/CREATE TABLE AS with same SELECT takes 7 minutes Arjun Ranade 19:37
Re: SELECT statement returns in 10seconds, but INSERT/CREATE TABLE AS with same SELECT takes 7 minutes Arjun Ranade 19:51
Re: SELECT statement returns in 10seconds, but INSERT/CREATE TABLE AS with same SELECT takes 7 minutes Vladimir Ryabtsev 20:39
Re: SELECT statement returns in 10seconds, but INSERT/CREATE TABLE AS with same SELECT takes 7 minutes Tom Lane 20:41
Re: SELECT statement returns in 10seconds, but INSERT/CREATE TABLE AS with same SELECT takes 7 minutes Vladimir Ryabtsev 23:50

Sept. 28, 2018

Thread Author Time
Re: SELECT statement returns in 10seconds, but INSERT/CREATE TABLE AS with same SELECT takes 7 minutes Justin Pryzby 00:12
Re: To keep indexes in memory, is large enough effective_cache_size enough? Sam R. 04:45
Re: Why could different data in a table be processed with different performance? Vladimir Ryabtsev 09:16
Re: Why could different data in a table be processed with different performance? Vladimir Ryabtsev 09:56
Re: To keep indexes in memory, is large enough effective_cache_size enough? David Rowley 10:32
Re: Why could different data in a table be processed with different performance? Fabio Pardi 14:15
Re: Why could different data in a table be processed with different performance? Vladimir Ryabtsev 19:51

Sept. 29, 2018

Thread Author Time
Re: [HACKERS] proposal: schema variables 📎 Pavel Stehule 08:34
Re: [HACKERS] proposal: schema variables 📎 Pavel Stehule 22:19

Sept. 30, 2018

Thread Author Time
psql: fe_sendauth: no password supplied Daulat Ram 23:36
Re: psql: fe_sendauth: no password supplied Justin Pryzby 23:49

Browse Archives

Prev | Next
Jump to day: 1 2 3 4 5 6 7 8 9 10 13 14 15 16 17 18 19 20 21 22 24 25 26 27 28 29 30