pgsql-performance since 2018-06-01 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

June 5, 2018

Thread	Author	Time
Simple Query Elapsed Time ~ 3 hrs Using Bitmap Index/Heap Scan	Fred Habash	14:17
Re: Simple Query Elapsed Time ~ 3 hrs Using Bitmap Index/Heap Scan	Sergei Kornilov	14:26
Re: Simple Query Elapsed Time ~ 3 hrs Using Bitmap Index/Heap Scan	Matthew Hall	14:42
Re: Simple Query Elapsed Time ~ 3 hrs Using Bitmap Index/Heap Scan	Tom Lane	14:42
RE: Simple Query Elapsed Time ~ 3 hrs Using Bitmap Index/Heap Scan	Fd Habash	17:18

June 7, 2018

Thread	Author	Time
Re: Client Server performance & UDS	e-blokos	09:40

June 12, 2018

Thread	Author	Time
pg_upgrade 10.2	Murthy Nunna	20:34
Re: pg_upgrade 10.2	Adrian Klaver	20:47
RE: pg_upgrade 10.2	Murthy Nunna	20:58
Re: pg_upgrade 10.2	Adrian Klaver	21:13
RE: pg_upgrade 10.2	Murthy Nunna	21:18
Re: pg_upgrade 10.2	Adrian Klaver	21:34
RE: pg_upgrade 10.2	Murthy Nunna	21:49
Re: pg_upgrade 10.2	Jerry Sievers	23:24
RE: pg_upgrade 10.2	Murthy Nunna	23:41
Re: pg_upgrade 10.2	Adrian Klaver	23:50
Re: pg_upgrade 10.2	Jerry Sievers	23:56
Re: pg_upgrade 10.2	Jerry Sievers	23:59

June 13, 2018

Thread	Author	Time
Re: [PERFORM] Dissuade the use of exclusion constraint index	Adam Brusselback	15:59

June 14, 2018

Thread	Author	Time
Small query plan change, big performance difference	Michael Sacket	18:02
Re: Small query plan change, big performance difference	Adam Brusselback	18:24
Re: Small query plan change, big performance difference	Michael Sacket	18:49

June 19, 2018

Thread	Author	Time
Re: [PERFORM] Dissuade the use of exclusion constraint index	Adam Brusselback	19:50

June 20, 2018

Thread	Author	Time
Slow query when pg_trgm is in inner lopp	Sasa Vilic	13:21
Re: Slow query when pg_trgm is in inner lopp	Matthew Hall	13:29
Re: Slow query when pg_trgm is in inner lopp	Sasa Vilic	14:13
Re: Slow query when pg_trgm is in inner lopp	Jeff Janes	14:53
Re: add default parallel query to v10 release notes? (Re: [PERFORM] performance drop after upgrade (9.6 > 10)) 📎	Bruce Momjian	15:13
Re: Slow query when pg_trgm is in inner lopp	Sasa Vilic	15:38

June 22, 2018

Thread	Author	Time
Re: add default parallel query to v10 release notes? (Re: [PERFORM] performance drop after upgrade (9.6 > 10))	Amit Kapila	09:23

June 25, 2018

Thread	Author	Time
Slow join	Roman Kushnir	15:55
Re: Slow join	Justin Pryzby	16:45
Re: Slow join	Roman Kushnir	19:39

June 26, 2018

Thread	Author	Time
"set primary keys..." is missing when using hight values for transactions / scaling factor with pgbench	Elvir Kurić	12:21
Re: "set primary keys..." is missing when using hight values for transactions / scaling factor with pgbench	David Rowley	12:41
Re: "set primary keys..." is missing when using hight values for transactions / scaling factor with pgbench	Elvir Kurić	12:51

June 27, 2018

Thread	Author	Time
Queue table that quickly grows causes query planner to choose poor plan	David Wheeler	03:45
Re: Slow join	Laurenz Albe	08:19
Re: Slow join	Roman Kushnir	09:02
Re: [HACKERS] proposal: schema variables	Gilles Darold	10:21
Re: [HACKERS] proposal: schema variables	Pavel Stehule	11:22
Bug in PostgreSQL	Rambabu V	15:30
Re: Bug in PostgreSQL	Steve Crawford	15:50
Re: Bug in PostgreSQL	Joseph Curtin	15:53
Re: [HACKERS] proposal: schema variables	Gilles Darold	17:15
Re: [HACKERS] proposal: schema variables	Pavel Stehule	17:17
Re: Queue table that quickly grows causes query planner to choose poor plan	Justin Pryzby	18:05
Re: Queue table that quickly grows causes query planner to choose poor plan	Tom Lane	18:27

June 28, 2018

Thread	Author	Time
Re: Queue table that quickly grows causes query planner to choose poor plan	David Wheeler	00:00
Re: Bug in PostgreSQL	Laurenz Albe	06:55
Re: Bug in PostgreSQL	Andres Freund	16:13

July 1, 2018

Thread	Author	Time
Trigger overhead/performance and alternatives?	AJG	09:31

July 4, 2018

Thread	Author	Time
tcp_keepalives	José Mello Júnior	13:19

July 5, 2018

Thread	Author	Time
Re: tcp_keepalives	Justin Pryzby	03:56

July 7, 2018

Thread	Author	Time
Re: Trigger overhead/performance and alternatives?	Peter Eisentraut	07:47
Re: Faster str to int conversion (was Table with large number of int columns, very slow COPY FROM) 📎	Andres Freund	20:01

July 8, 2018

Thread	Author	Time
where can I download the binaries of plpython extension	Mariel Cherkassky	13:06
Re: where can I download the binaries of plpython extension	Justin Pryzby	13:20
Re: where can I download the binaries of plpython extension	Mariel Cherkassky	13:24
Re: where can I download the binaries of plpython extension	Justin Pryzby	13:33
Re: where can I download the binaries of plpython extension	Mariel Cherkassky	13:38
Re: where can I download the binaries of plpython extension	Tom Lane	13:43
Re: where can I download the binaries of plpython extension	Justin Pryzby	13:43
Re: where can I download the binaries of plpython extension	Mariel Cherkassky	13:46
Re: where can I download the binaries of plpython extension	Justin Pryzby	14:18
Problems with installing pgwatch2 without docker	Mariel Cherkassky	14:22
Re: where can I download the binaries of plpython extension	Mariel Cherkassky	14:36
Re: Problems with installing pgwatch2 without docker	Andrew Dunstan	16:35
Re: where can I download the binaries of plpython extension	Justin Pryzby	17:25

July 9, 2018

Thread	Author	Time
Re: where can I download the binaries of plpython extension	Mariel Cherkassky	06:18
Need help with optimising simple query	Nandakumar M	11:47
Re: Need help with optimising simple query	Tom Lane	14:23
Re: add default parallel query to v10 release notes? (Re: [PERFORM] performance drop after upgrade (9.6 > 10))	Bruce Momjian	15:19

July 10, 2018

Thread	Author	Time
Re: Need help with optimising simple query	Nandakumar M	05:36
Improving Performance of Query ~ Filter by A, Sort by B	Lincoln Swaine-Moore	15:07
performance statistics monitoring without spamming logs	Patrick Hemmer	17:54
Re: performance statistics monitoring without spamming logs	Justin Pryzby	18:38

July 11, 2018

Thread	Author	Time
Special bloom index of INT, BIGINT, BIT, VARBIT for bitwise operation	Takao Magoori	06:02
High concurrency but simple updating causes deadlock	枫	14:16
Re: Improving Performance of Query ~ Filter by A, Sort by B	legrand legrand	21:41
Re: Improving Performance of Query ~ Filter by A, Sort by B	Lincoln Swaine-Moore	23:31

July 12, 2018

Thread	Author	Time
Re: Improving Performance of Query ~ Filter by A, Sort by B	Tom Lane	03:10
Suggestion to optimize performance of the PLSQL procedure. 📎	Dinesh Chandra 12108	03:18
Re: High concurrency but simple updating causes deadlock	Roman Konoval	10:55
Re: performance statistics monitoring without spamming logs	Lukas Fittl	22:25

July 13, 2018

Thread	Author	Time
Re: performance statistics monitoring without spamming logs	Adrien NAYRAT	07:23
Re: performance statistics monitoring without spamming logs	Adrien NAYRAT	07:24
Re: performance statistics monitoring without spamming logs	Julien Rouhaud	07:55

July 15, 2018

Thread	Author	Time
Re: Improving Performance of Query ~ Filter by A, Sort by B	Jeff Janes	03:25

July 16, 2018

Thread	Author	Time
Re: Improving Performance of Query ~ Filter by A, Sort by B	Lincoln Swaine-Moore	21:29

July 17, 2018

Thread	Author	Time
Why HDD performance is better than SSD in this case	Neto pr	05:00
Re: Why HDD performance is better than SSD in this case	Benjamin Scherrey	05:17
Re: Why HDD performance is better than SSD in this case	winston cheung	05:43
Re: Why HDD performance is better than SSD in this case	Mark Kirkwood	06:07
Re: Why HDD performance is better than SSD in this case	Robert Zenz	07:40
Re: Why HDD performance is better than SSD in this case	Fabio Pardi	08:08
Re: HDD vs SSD without explanation	Neto pr	12:47
Re: Why HDD performance is better than SSD in this case	Neto pr	13:04
Re: Why HDD performance is better than SSD in this case	Neto pr	13:19
Re: Why HDD performance is better than SSD in this case	Jeff Janes	13:28
Re: Why HDD performance is better than SSD in this case	Nicolas Charles	13:44
Re: Why HDD performance is better than SSD in this case	Robert Zenz	13:50
Re: Why HDD performance is better than SSD in this case	Fabio Pardi	13:55
Re: Why HDD performance is better than SSD in this case	Neto pr	14:00
Re: Why HDD performance is better than SSD in this case	Neto pr	14:05
Re: Why HDD performance is better than SSD in this case	Nicolas Charles	14:08
Re: Why HDD performance is better than SSD in this case	Nicolas Charles	14:16
Re: Why HDD performance is better than SSD in this case	Fabio Pardi	14:43
Re: Special bloom index of INT, BIGINT, BIT, VARBIT for bitwise operation	Tomas Vondra	14:57
Re: Improving Performance of Query ~ Filter by A, Sort by B	Jeff Janes	15:59
Re: Why HDD performance is better than SSD in this case	Mark Kirkwood	23:04
Re: Why HDD performance is better than SSD in this case	Mark Kirkwood	23:28

July 18, 2018

Thread	Author	Time
Re: Why HDD performance is better than SSD in this case	Neto pr	01:13
Re: Why HDD performance is better than SSD in this case	Neto pr	01:16
Re: Why HDD performance is better than SSD in this case	Neto pr	01:24
Re: Why HDD performance is better than SSD in this case	Fabio Pardi	07:46
Re: Why HDD performance is better than SSD in this case	Nicolas Charles	09:33
Re: Why HDD performance is better than SSD in this case	Mark Kirkwood	09:35
Re: Why HDD performance is better than SSD in this case	George Neuner	16:44
Re: Why HDD performance is better than SSD in this case	Imre Samu	17:35
Re: Faster str to int conversion (was Table with large number of int columns, very slow COPY FROM)	Robert Haas	18:34

July 19, 2018

Thread	Author	Time
Re: Faster str to int conversion (was Table with large number of int columns, very slow COPY FROM)	Andres Freund	20:32
Re: Why HDD performance is better than SSD in this case	Mark Kirkwood	23:30

July 20, 2018

Thread	Author	Time
Re: Why HDD performance is better than SSD in this case	Mark Kirkwood	00:33
Re: Why HDD performance is better than SSD in this case 📎	Neto pr	00:52
Re: Why HDD performance is better than SSD in this case	Mark Kirkwood	01:49
Re: Faster str to int conversion (was Table with large number of int columns, very slow COPY FROM)	Robert Haas	12:27
Re: Faster str to int conversion (was Table with large number of int columns, very slow COPY FROM)	Andres Freund	16:45

July 23, 2018

Thread	Author	Time
Re: Why HDD performance is better than SSD in this case	Mark Kirkwood	00:07
Profile what the production server is doing	Thomas Güttler	11:18
Re: Profile what the production server is doing	Julien Rouhaud	11:38
Re: Profile what the production server is doing	Baron Schwartz	14:01
Re: Profile what the production server is doing	Flo Rance	15:16

July 25, 2018

Thread	Author	Time
Re: Profile what the production server is doing	Thomas Güttler	09:14
Re: Profile what the production server is doing	Thomas Güttler	09:17
Re: Profile what the production server is doing	Thomas Güttler	09:39
Re: Profile what the production server is doing	Flo Rance	09:49
Re: Profile what the production server is doing	Julien Rouhaud	10:25

July 26, 2018

Thread	Author	Time
Automated bottleneck detection	Thomas Güttler	11:27
Re: Automated bottleneck detection	MichaelDBA	12:05
Query with "ILIKE ALL" does not use the index	Nicolas Even	15:53
Re: Query with "ILIKE ALL" does not use the index	Tom Lane	16:44
Re: Query with "ILIKE ALL" does not use the index	Matthew Hall	17:22
Re: Query with "ILIKE ALL" does not use the index	Nicolas Even	19:17
Re: Query with "ILIKE ALL" does not use the index	Nicolas Even	19:32

July 29, 2018

Thread	Author	Time
Performance difference in accessing differrent columns in a Postgres Table	Dinesh Kumar	05:38
Re: Performance difference in accessing differrent columns in a Postgres Table	David Rowley	21:53
Re: Performance difference in accessing differrent columns in a Postgres Table	Tom Lane	23:00

July 30, 2018

Thread	Author	Time
Re: Performance difference in accessing differrent columns in a Postgres Table	Pavel Stehule	04:11
Re: Performance difference in accessing differrent columns in a Postgres Table 📎	Jeff Janes	11:19
Re: Performance difference in accessing differrent columns in a Postgres Table	Pavel Stehule	16:01
Re: Performance difference in accessing differrent columns in a Postgres Table	Andres Freund	17:23
Re: Performance difference in accessing differrent columns in a Postgres Table	Jeff Janes	17:31
Re: Performance difference in accessing differrent columns in a Postgres Table	Andres Freund	17:45
Re: Performance difference in accessing differrent columns in a Postgres Table	Andres Freund	19:02

July 31, 2018

Thread	Author	Time
Re: Performance difference in accessing differrent columns in a Postgres Table	Jeff Janes	16:56
Re: Performance difference in accessing differrent columns in a Postgres Table	Andres Freund	17:35

Aug. 1, 2018

Thread	Author	Time
Re: Performance difference in accessing differrent columns in a Postgres Table 📎	Jeff Janes	15:21

Aug. 8, 2018

Thread	Author	Time
Re: [HACKERS] proposal: schema variables 📎	Pavel Stehule	20:29
Re: [HACKERS] proposal: schema variables 📎	Pavel Stehule	20:35

Aug. 11, 2018

Thread	Author	Time
Re: [HACKERS] proposal: schema variables 📎	Pavel Stehule	05:39
Re: [HACKERS] proposal: schema variables 📎	Pavel Stehule	18:46

Aug. 12, 2018

Thread	Author	Time
Re: [HACKERS] proposal: schema variables 📎	Pavel Stehule	05:35

Aug. 13, 2018

Thread	Author	Time
increase insert into local table from remote oracle table preformance	Mariel Cherkassky	20:34
Fwd: increase insert into local table from remote oracle table preformance	Mariel Cherkassky	20:35
Re: Fwd: increase insert into local table from remote oracle table preformance	legrand legrand	21:03

Aug. 14, 2018

Thread	Author	Time
Re: increase insert into local table from remote oracle table preformance	Mark Kirkwood	05:21
Re: increase insert into local table from remote oracle table preformance	Laurenz Albe	07:12
Re: Fwd: increase insert into local table from remote oracle table preformance	Mariel Cherkassky	11:33
Bi-modal streaming replication throughput 📎	Alexis Lê-Quôc	13:18
Re: [HACKERS] proposal: schema variables 📎	Pavel Stehule	14:38
Re: Bi-modal streaming replication throughput	Jeff Janes	14:51
Re: Bi-modal streaming replication throughput	Andres Freund	17:46
Re: Bi-modal streaming replication throughput	Andres Freund	17:50
Calculating how much redo log space has been used	Reza Taheri	18:51
Re: Calculating how much redo log space has been used	Andres Freund	19:31
Re: Fwd: increase insert into local table from remote oracle table preformance	legrand legrand	22:28

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

Browse Archives

Prev | Next