pgsql-performance - September 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

Sept. 4, 2017

Thread	Author	Time
Handling small inserts from many connections. 📎	우성민	08:14
Re: Handling small inserts from many connections. 📎	Michael Vitale	11:57
Re: Handling small inserts from many connections.	Scott Marlowe	18:15
Re: Handling small inserts from many connections.	Michaeldba@sqlexec.com	22:06
Re: Handling small inserts from many connections.	Jeff Janes	22:27
Re: Handling small inserts from many connections.	우성민	22:54

Sept. 5, 2017

Thread	Author	Time
Re: printing results of query to file in different times	Mariel Cherkassky	11:28
slow index scan performance	Soni M	13:24
Re: slow index scan performance	Soni M	13:46
Re: slow index scan performance	Soni M	13:58
Re: printing results of query to file in different times	George Neuner	14:23
Re: printing results of query to file in different times	George Neuner	17:12

Sept. 6, 2017

Thread	Author	Time
OS cache management	Soni M	08:12
Slow vacuum of GIST indexes, because of random reads on PostgreSQL 9.6	Marcin Barczynski	11:57
Re: OS cache management	Gerardo Herzig	14:13
Re: [SPAM] OS cache management	Moreno Andreo	14:45
Re: printing results of query to file in different times	George Neuner	16:55

Sept. 7, 2017

Thread	Author	Time
Poor perfomance of update (and select) on partitioned tables	Konstantin Kivi	15:13
Re: printing results of query to file in different times	George Neuner	17:26

Sept. 8, 2017

Thread	Author	Time
Explain Analyze - actual time in loops	Neto pr	03:17
Re: Explain Analyze - actual time in loops	Igor Neyman	12:46
Re: Explain Analyze - actual time in loops	Neto pr	13:08
Re: Explain Analyze - actual time in loops	Tom Lane	13:44
Re: Explain Analyze - actual time in loops	Neto pr	14:02
Re: Explain Analyze - actual time in loops	Tom Lane	14:07

Sept. 10, 2017

Thread	Author	Time
Re: OS cache management	Soni M	05:48
Re: [SPAM] OS cache management	Soni M	05:49

Sept. 11, 2017

Thread	Author	Time
postgresql 9.6 data directory fs becomes full	Mariel Cherkassky	09:42
Re: postgresql 9.6 data directory fs becomes full	Tom Lane	12:02
Re: postgresql 9.6 data directory fs becomes full	Jerry Sievers	17:07

Sept. 13, 2017

Thread	Author	Time
query of partitioned object doesnt use index in qa	Mike Broers	20:28
Re: query of partitioned object doesnt use index in qa	David Rowley	21:57

Sept. 14, 2017

Thread	Author	Time
Store/Retrieve time series data from PostgreSQL	Subramaniam C	11:51
Re: Store/Retrieve time series data from PostgreSQL	vinny	12:03
Re: Store/Retrieve time series data from PostgreSQL	Subramaniam C	12:33
Re: Store/Retrieve time series data from PostgreSQL	Subramaniam C	12:38
Re: query of partitioned object doesnt use index in qa	Mike Broers	13:25

Sept. 15, 2017

Thread	Author	Time
Re: query of partitioned object doesnt use index in qa	Mike Broers	20:18
Re: query of partitioned object doesnt use index in qa	Tom Lane	20:42
Indexing an array of two separate columns	Jeremy Finzel	20:51
Re: query of partitioned object doesnt use index in qa	Mike Broers	20:59
Re: query of partitioned object doesnt use index in qa	Andres Freund	21:03
Re: query of partitioned object doesnt use index in qa	Tom Lane	22:05
Re: query of partitioned object doesnt use index in qa	Tomas Vondra	22:26

Sept. 17, 2017

Thread	Author	Time
Partitioning perfomance issue	Konstantin Kivi	08:34
Pageinspect bt_metap help	Neto pr	21:52
Re: Pageinspect bt_metap help	Peter Geoghegan	21:59

Sept. 18, 2017

Thread	Author	Time
max partitions behind a view?	Rick Otten	11:25
Re: max partitions behind a view?	Tom Lane	13:55
Re: Pageinspect bt_metap help	Neto pr	14:31

Sept. 19, 2017

Thread	Author	Time
https://stackoverflow.com/questions/28844170/how-to-limit-the-memory-that-is-available-for-postgressql-server	園田祥平	00:49
Re: Pageinspect bt_metap help	Peter Geoghegan	01:07
Re: https://stackoverflow.com/questions/28844170/how-to-limit-the-memory-that-is-available-for-postgressql-server	George Neuner	02:44
Re: Pageinspect bt_metap help	Tom Lane	03:28
Re: https://stackoverflow.com/questions/28844170/how-to-limit-the-memory-that-is-available-for-postgressql-server	Jonathan Rogers	03:30
Re: https://stackoverflow.com/questions/28844170/how-to-limit-the-memory-that-is-available-for-postgressql-server	Tomas Vondra	13:08
repeated subplan execution	Jeff Janes	23:30

Sept. 20, 2017

Thread	Author	Time
Re: repeated subplan execution	monika yadav	02:31
Re: query of partitioned object doesnt use index in qa	Mike Broers	16:15
Re: repeated subplan execution	Jeff Janes	16:46
Re: query of partitioned object doesnt use index in qa	David Rowley	23:05

Sept. 21, 2017

Thread	Author	Time
Re: repeated subplan execution	monika yadav	10:35
Query regarding EXPLAIN (ANALYZE,BUFFERS)	Subramaniam C	10:52
Re: Query regarding EXPLAIN (ANALYZE,BUFFERS)	Pavel Stehule	18:37

Sept. 25, 2017

Thread	Author	Time
Parallel sequential scan not supported for stored procedure with RETURN QUERY EXECUTE ?	Tobias Gierke	11:10
Re: query of partitioned object doesnt use index in qa	Mike Broers	16:21

Sept. 28, 2017

Thread	Author	Time
Slow query in JDBC	Subramaniam C	08:19
Re: Slow query in JDBC	Julien Rouhaud	08:48
Re: Slow query in JDBC	Subramaniam C	08:58
Re: Slow query in JDBC	Julien Rouhaud	09:20
Re: Slow query in JDBC	Pavy Philippe	09:26
Re: Slow query in JDBC	Subramaniam C	09:59
Re: Slow query in JDBC	Dave Cramer	13:59
Re: Slow query in JDBC	Subramaniam C	16:32
Re: Slow query in JDBC	Dave Cramer	19:04

Sept. 29, 2017

Thread	Author	Time
Re: Slow query in JDBC	Subramaniam C	05:57
Re: Slow query in JDBC	Jeff Janes	06:49
Re: Slow query in JDBC	Subramaniam C	10:44
Re: Slow query in JDBC	Dave Cramer	13:04
BDR, wal sender, high system cpu, mutex_lock_common	milist ujang	23:07

Browse Archives

Prev | Next