pgsql-performance since 2018-09-13 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

Browse Archives

Prev | Next

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

Oct. 1, 2018

Thread	Author	Time
Re: Why could different data in a table be processed with different performance?	Fabio Pardi	07:35

Oct. 2, 2018

Thread	Author	Time
Re: [HACKERS] proposal: schema variables	Thomas Munro	23:01

Oct. 5, 2018

Thread	Author	Time
Re: [HACKERS] proposal: schema variables 📎	Pavel Stehule	01:34
Re: dsa_allocate() faliure	Thomas Munro	02:16

Oct. 6, 2018

Thread	Author	Time
Why the index is not used ?	ROS Didier	09:57
Re: Why the index is not used ?	Pavel Stehule	10:13
Re: Why the index is not used ?	Vladimir Ryabtsev	16:51

Oct. 7, 2018

Thread	Author	Time
Re: Why the index is not used ?	Paul McGarry	02:20
RE: Why the index is not used ?	ROS Didier	13:13
RE: Why the index is not used ?	ROS Didier	13:20
Re: Why the index is not used ?	Francisco Olarte	15:58
Re: [HACKERS] proposal: schema variables 📎	Pavel Stehule	17:13
RE: Why the index is not used ?	ROS Didier	18:32
RE: Why the index is not used ?	Kumar, Virendra	18:41
Re: Why the index is not used ?	Vladimir Ryabtsev	18:48
Re: Why the index is not used ?	Vladimir Ryabtsev	19:32
Re: Why the index is not used ?	Tomas Vondra	20:07
Re: Why the index is not used ?	Paul McGarry	22:10

Oct. 8, 2018

Thread	Author	Time
RE: Why the index is not used ?	ROS Didier	06:29
RE: Why the index is not used ?	ROS Didier	08:32
Re: Why the index is not used ?	Jean-Paul Argudo	08:44
RE: Why the index is not used ?	ROS Didier	11:47
RE: Why the index is not used ?	ROS Didier	12:02
RE: Why the index is not used ?	ROS Didier	12:07
RE: Why the index is not used ?	Phil Endecott	13:14
RE: Why the index is not used ?	ROS Didier	14:10
RE: Why the index is not used ?	ROS Didier	14:29
RE: Why the index is not used ?	ROS Didier	15:32
Re: Why the index is not used ?	Tomas Vondra	20:00
Re: Why the index is not used ?	Paul McGarry	21:34
Re: Partial index plan/cardinality costing	James Coleman	22:05

Oct. 9, 2018

Thread	Author	Time
Re: Partial index plan/cardinality costing	Justin Pryzby	00:49
understand query on partition table	Mariel Cherkassky	09:19
Re: understand query on partition table 📎	Samed YILDIRIM	13:12

Oct. 10, 2018

Thread	Author	Time
Re: Why could different data in a table be processed with different performance?	Vladimir Ryabtsev	10:59

Oct. 11, 2018

Thread	Author	Time
does work_mem is used on temp tables?	Mariel Cherkassky	06:56
Re: does work_mem is used on temp tables?	Andrew Gierth	07:41
Re: does work_mem is used on temp tables?	Mariel Cherkassky	07:58

Oct. 12, 2018

Thread	Author	Time
One big table or split data? Writing data. From disk point of view. With a good storage (GBs/s, writing speed)	Sam R.	16:27

Oct. 15, 2018

Thread	Author	Time
Import csv in PostgreSQL	Dinesh Chandra 12108	05:42
Re: Import csv in PostgreSQL	Gabi D	06:09

Oct. 16, 2018

Thread	Author	Time
Re: One big table or split data? Writing data. From disk point of view. With a good storage (GBs/s, writing speed)	Sam R.	03:47

Oct. 19, 2018

Thread	Author	Time
Gained %20 performance after disabling bitmapscan	Yavuz Selim Sertoglu	07:19
Re: Gained %20 performance after disabling bitmapscan	Justin Pryzby	13:44
Re: Gained %20 performance after disabling bitmapscan	Tom Lane	13:52
Re: Gained %20 performance after disabling bitmapscan	Vladimir Ryabtsev	18:09
Re: Gained %20 performance after disabling bitmapscan	Jeff Janes	19:40

Oct. 22, 2018

Thread	Author	Time
Ynt: Gained %20 performance after disabling bitmapscan	Yavuz Selim Sertoglu	06:52
Ynt: Gained %20 performance after disabling bitmapscan	Yavuz Selim Sertoglu	06:55
Ynt: Gained %20 performance after disabling bitmapscan	Yavuz Selim Sertoglu	07:20
High CPU Usage of "SET ROLE" 📎	Ulf Lohbrügge	13:44
Re: High CPU Usage of "SET ROLE"	Tom Lane	13:57

Oct. 23, 2018

Thread	Author	Time
Re: [HACKERS] proposal: schema variables	Erik Rijkers	12:50
Re: [HACKERS] proposal: schema variables 📎	Pavel Stehule	18:05

Oct. 25, 2018

Thread	Author	Time
DELETE / UPDATE from partition not optimized (11.0)	Dave E Martin	16:43

Oct. 26, 2018

Thread	Author	Time
Re: DELETE / UPDATE from partition not optimized (11.0)	Justin Pryzby	15:45
Re: Gained %20 performance after disabling bitmapscan	Jeff Janes	17:54

Oct. 28, 2018

Thread	Author	Time
Re: DELETE / UPDATE from partition not optimized (11.0)	Justin Pryzby	21:49

Oct. 29, 2018

Thread	Author	Time
Indexes on UUID - Fragmentation Issue	Uday Bhaskar V	13:29
Re: Indexes on UUID - Fragmentation Issue	Merlin Moncure	14:28
Re: Indexes on UUID - Fragmentation Issue	Andreas Karlsson	14:52
Re: Indexes on UUID - Fragmentation Issue	Uday Bhaskar V	14:56
Re: Indexes on UUID - Fragmentation Issue	MichaelDBA	19:12

Oct. 30, 2018

Thread	Author	Time
SCRAM question	MichaelDBA	17:51
Re: SCRAM question	Joshua D. Drake	18:03
Re: High CPU Usage of "SET ROLE"	Ulf Lohbrügge	19:49
Re: High CPU Usage of "SET ROLE"	Tom Lane	20:27
Re: High CPU Usage of "SET ROLE"	Jeff Janes	22:34

Oct. 31, 2018

Thread	Author	Time
Re: SCRAM question	Michael Paquier	09:55

Nov. 2, 2018

Thread	Author	Time
Fwd: Query with high planning time compared to execution time 📎	Richard Lee	09:36
Re: Fwd: Query with high planning time compared to execution time	Tomas Vondra	13:55
Re: Fwd: Query with high planning time compared to execution time	legrand legrand	22:51

Nov. 5, 2018

Thread	Author	Time
Re: Fwd: Query with high planning time compared to execution time	Richard Lee	03:36
Re: Fwd: Query with high planning time compared to execution time	Justin Pryzby	04:10
Re: Fwd: Query with high planning time compared to execution time 📎	Richard Lee	07:04
Re: Fwd: Query with high planning time compared to execution time	Justin Pryzby	13:55

Nov. 6, 2018

Thread	Author	Time
Re: Fwd: Query with high planning time compared to execution time	Richard Lee	11:40

Browse Archives

Prev | Next