pgsql-performance before 2018-09-29 00:00

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

Aug. 15, 2018

Thread Author Time
Re: Fwd: increase insert into local table from remote oracle table preformance Mariel Cherkassky 08:43
Re: increase insert into local table from remote oracle table preformance Andrew Kerber 11:42
Re: increase insert into local table from remote oracle table preformance Daniel Blanch Bataller 15:52
RE: Calculating how much redo log space has been used Reza Taheri 20:03
Re: Fwd: increase insert into local table from remote oracle table preformance legrand legrand 20:26
Re: dsa_allocate() faliure Sand Stone 20:32
Re: dsa_allocate() faliure Thomas Munro 22:42

Aug. 16, 2018

Thread Author Time
Guideline To Resolve LWLock:SubtransControlLock Fred Habash 18:19
Re: Guideline To Resolve LWLock:SubtransControlLock Alvaro Herrera 18:36

Aug. 17, 2018

Thread Author Time
Re: Bi-modal streaming replication throughput Alexis Lê-Quôc 13:21
Re: Bi-modal streaming replication throughput Andres Freund 13:46
Re: Guideline To Resolve LWLock:SubtransControlLock Fred Habash 18:07
Re: Guideline To Resolve LWLock:SubtransControlLock Alvaro Herrera 18:26

Aug. 20, 2018

Thread Author Time
Re: Guideline To Resolve LWLock:SubtransControlLock Fred Habash 20:52
Re: Guideline To Resolve LWLock:SubtransControlLock Alvaro Herrera 21:00
Re: Guideline To Resolve LWLock:SubtransControlLock Jeremy Schneider 22:14

Aug. 21, 2018

Thread Author Time
Re: [HACKERS] proposal: schema variables Fabien COELHO 17:55
Re: [HACKERS] proposal: schema variables Pavel Stehule 18:48

Aug. 22, 2018

Thread Author Time
Re: [HACKERS] proposal: schema variables Fabien COELHO 07:00
RE: Guideline To Resolve LWLock:SubtransControlLock Fd Habash 15:48
RE: Guideline To Resolve LWLock:SubtransControlLock Fd Habash 20:07

Aug. 23, 2018

Thread Author Time
Re: [HACKERS] proposal: schema variables Pavel Stehule 05:35
Re: [HACKERS] proposal: schema variables Fabien COELHO 08:17
Re: [HACKERS] proposal: schema variables Pavel Stehule 08:44
Re: [HACKERS] proposal: schema variables Fabien COELHO 09:46
Re: [HACKERS] proposal: schema variables Pavel Luzanov 12:39

Aug. 25, 2018

Thread Author Time
Re: dsa_allocate() faliure Sand Stone 14:46

Aug. 29, 2018

Thread Author Time
Extremely slow when query uses GIST exclusion index David 03:31
Re: dsa_allocate() faliure 📎 Sand Stone 04:44
Re: Extremely slow when query uses GIST exclusion index Andreas Kretschmer 10:50
Re: Extremely slow when query uses GIST exclusion index Andreas Kretschmer 11:25
Re: [HACKERS] proposal: schema variables Fabien COELHO 18:10
Re: Extremely slow when query uses GIST exclusion index David 18:10
Re: Extremely slow when query uses GIST exclusion index Andreas Kretschmer 18:48

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

Browse Archives

Prev | Next