pgsql-performance - January 2017

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

Jan. 2, 2017

Thread	Author	Time
Performance issue with castings args of the function	Андрей Хозов	14:34
Re: Performance issue with castings args of the function	Pavel Stehule	15:17
Re: Performance issue with castings args of the function	Tom Lane	16:36
Re: Performance issue with castings args of the function	Андрей Хозов	16:52

Jan. 3, 2017

Thread	Author	Time
Unable to connect to server	Vucomir Ianculov	10:00

Jan. 4, 2017

Thread	Author	Time
Re: Unable to connect to server	Andreas Kretschmer	09:12
Re: Unable to connect to server	Vucomir Ianculov	11:03
Re: Unable to connect to server	Andreas Kretschmer	11:12
Re: Slow query after 9.3 to 9.6 migration	Kevin Grittner	14:25

Jan. 5, 2017

Thread	Author	Time
Re: Slow query after 9.3 to 9.6 migration	Merlin Moncure	14:40
Re: Slow query after 9.3 to 9.6 migration	Flávio Henrique	16:51
Re: Slow query after 9.3 to 9.6 migration	Kevin Grittner	17:10
Re: Slow query after 9.3 to 9.6 migration	Daniel Blanch Bataller	17:51
Re: Slow query after 9.3 to 9.6 migration	Merlin Moncure	19:01
Re: Slow query after 9.3 to 9.6 migration	Filipe Oliveira	21:14

Jan. 6, 2017

Thread	Author	Time
Re: Slow query after 9.3 to 9.6 migration	Michael Paquier	12:51
Re: Slow query after 9.3 to 9.6 migration	Filipe Oliveira	18:25
Sort-of replication for reporting purposes	Ivan Voras	19:24
Re: Sort-of replication for reporting purposes	Scott Marlowe	19:30
Re: Sort-of replication for reporting purposes	Ivan Voras	19:33
Re: Sort-of replication for reporting purposes	Rick Otten	19:33
Re: Sort-of replication for reporting purposes	Stephen Frost	19:43

Jan. 12, 2017

Thread	Author	Time
How can I find the source of postgresql per-connection memory leaks?	Eric Jensen	17:08
Re: How can I find the source of postgresql per-connection memory leaks?	Joshua D. Drake	17:18
Re: Sort-of replication for reporting purposes	ProPAAS DBA	17:48

Jan. 13, 2017

Thread	Author	Time
Re: Sort-of replication for reporting purposes	Stuart Bishop	11:00
Re: Sort-of replication for reporting purposes	Ivan Voras	11:17
Re: Sort-of replication for reporting purposes 📎	Phillip Couto	11:47
Re: Sort-of replication for reporting purposes	Stuart Bishop	11:48

Jan. 16, 2017

Thread	Author	Time
out of range error while restore using pgdump	Samir Magar	09:20
Re: out of range error while restore using pgdump	Tom Lane	15:30

Jan. 18, 2017

Thread	Author	Time
optimizing immutable vs. stable function calls?	Karl Czajkowski	22:36
Re: optimizing immutable vs. stable function calls?	Tom Lane	22:54
Re: optimizing immutable vs. stable function calls?	Karl Czajkowski	23:06
Re: optimizing immutable vs. stable function calls?	David G. Johnston	23:06
Re: optimizing immutable vs. stable function calls?	Tom Lane	23:23
Re: optimizing immutable vs. stable function calls?	Tom Lane	23:25

Jan. 19, 2017

Thread	Author	Time
Re: optimizing immutable vs. stable function calls?	David G. Johnston	00:09
Re: optimizing immutable vs. stable function calls?	Karl Czajkowski	02:45
Optimization inner join	Clailson	10:08
Re: Optimization inner join	Phillip Couto	12:34
Re: Optimization inner join	Clailson	13:04
Re: Optimization inner join	Phillip Couto	13:18
Re: Optimization inner join	Gustavo Rezende Montesino	13:23
Re: Optimization inner join	Vitalii Tymchyshyn	13:30
Re: Optimization inner join	Phillip Couto	13:46
Re: Optimization inner join	Tom Lane	14:13
Re: Optimization inner join	Phillip Couto	14:15
Chaotic query planning ?	Philippe Ivaldi	14:37
Re: Optimization inner join	Gustavo Rezende Montesino	14:45
Re: Chaotic query planning ?	Albe Laurenz	16:05

Jan. 20, 2017

Thread	Author	Time
Backup taking long time !!!	Dinesh Chandra 12108	11:24
Re: Backup taking long time !!!	Madusudanan.B.N	11:34
Re: Backup taking long time !!!	Dinesh Chandra 12108	11:43
Re: Backup taking long time !!!	Pavel Stehule	11:48
Re: Backup taking long time !!!	Madusudanan.B.N	11:52
Re: Backup taking long time !!!	Dinesh Chandra 12108	11:53
Re: Backup taking long time !!!	Pavel Stehule	11:55
Re: Backup taking long time !!!	Stephen Frost	12:22
Re: Backup taking long time !!!	Vladimir Borodin	12:57
Re: Backup taking long time !!!	Stephen Frost	13:40
Re: Backup taking long time !!!	Vladimir Borodin	14:45
Re: Backup taking long time !!!	Stephen Frost	15:06
Re: Backup taking long time !!!	Vladimir Borodin	16:44
Re: Backup taking long time !!!	Stephen Frost	16:59

Jan. 22, 2017

Thread	Author	Time
Re: Backup taking long time !!!	julyanto SUTANDANG	13:20
Re: Backup taking long time !!!	julyanto SUTANDANG	13:36
Re: Backup taking long time !!!	Stephen Frost	14:55
Re: Backup taking long time !!!	Stephen Frost	14:57
Re: Backup taking long time !!!	julyanto SUTANDANG	16:04
Re: Backup taking long time !!!	Stephen Frost	16:37
Re: Backup taking long time !!!	julyanto SUTANDANG	17:03
Re: Backup taking long time !!!	Stephen Frost	17:32
Re: Backup taking long time !!!	julyanto SUTANDANG	17:56

Jan. 23, 2017

Thread	Author	Time
Re: Backup taking long time !!!	Vladimir Borodin	06:44
Re: Backup taking long time !!!	Stephen Frost	06:48
Re: Backup taking long time !!!	Torsten Zuehlsdorff	08:31
Re: optimizing immutable vs. stable function calls?	Jim Nasby	15:10
Re: Backup taking long time !!!	Jim Nasby	15:16
Re: Backup taking long time !!!	Stephen Frost	15:27
Re: Backup taking long time !!!	Jim Nasby	15:28
Re: Backup taking long time !!!	Jim Nasby	15:31
performance contradiction	Gabriel Dodan	16:55
Re: Backup taking long time !!!	Jeff Janes	17:12
Re: Backup taking long time !!!	Stephen Frost	17:20
Re: Backup taking long time !!!	Stephen Frost	17:23
Re: Backup taking long time !!!	Jeff Janes	17:32
Re: Backup taking long time !!!	Simon Riggs	17:43
Re: Backup taking long time !!!	Stephen Frost	17:47
Re: Backup taking long time !!!	Stephen Frost	17:49

Jan. 24, 2017

Thread	Author	Time
Re: Backup taking long time !!!	julyanto SUTANDANG	00:08
Re: optimizing immutable vs. stable function calls?	Merlin Moncure	00:08
Re: Backup taking long time !!!	Jeff Janes	15:55
Re: Backup taking long time !!!	Rick Otten	16:15
Re: Backup taking long time !!!	Stephen Frost	16:39

Jan. 25, 2017

Thread	Author	Time
pgsql connection timeone	Vucomir Ianculov	09:23
Re: pgsql connection timeone	Vucomir Ianculov	09:44
Re: pgsql connection timeone	Tom Lane	13:15

Jan. 28, 2017

Thread	Author	Time
Re: pgsql connection timeone	Vucomir Ianculov	10:03

Jan. 30, 2017

Thread	Author	Time
Re: Chaotic query planning ?	Philippe Ivaldi	08:24

Jan. 31, 2017

Thread	Author	Time
Re: Backup taking long time !!!	David Steele	15:20

Browse Archives

Prev | Next