pgsql-performance since 2017-07-20 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)

Browse Archives

Prev | Next

July 20, 2017

Thread Author Time
Re: partitioning materialized views Claudio Freire 01:23
CREATE EXTENSION postgis; Daulat Ram 09:05
Re: CREATE EXTENSION postgis; Florent Guillaume 10:51
Re: Very poor read performance, query independent Charles Nadeau 12:50

July 21, 2017

Thread Author Time
Unable to find PostgreSQL 9.5.6 software in PostgreSQL site. Dinesh Chandra 12108 10:12
Re: Unable to find PostgreSQL 9.5.6 software in PostgreSQL site. Florent Guillaume 12:47

July 25, 2017

Thread Author Time
Re: Very poor read performance, query independent Charles Nadeau 09:36

July 26, 2017

Thread Author Time
Re: Slow query after 9.3 to 9.6 migration Peter Geoghegan 21:44

July 27, 2017

Thread Author Time
Re: Slow query after 9.3 to 9.6 migration Scott Marlowe 20:49

Aug. 1, 2017

Thread Author Time
How to access data of SQL server database from PostgreSQL Daulat Ram 04:25
Re: How to access data of SQL server database from PostgreSQL Anthony Sotolongo 13:06
2 server with same configuration but huge difference in performance Sumeet Shukla 13:41
Re: 2 server with same configuration but huge difference in performance Keith 14:16
Re: [PERFORM] 2 server with same configuration but huge difference in performance Anthony Sotolongo 14:21
Re: How to access data of SQL server database from PostgreSQL Joshua D. Drake 14:43
Re: [PERFORM] 2 server with same configuration but huge difference in performance Scott Marlowe 15:35
Re: [PERFORM] 2 server with same configuration but huge difference in performance Sumeet Shukla 15:45
Re: 2 server with same configuration but huge difference in performance Scott Marlowe 16:13
Re: [PERFORM] 2 server with same configuration but huge difference in performance Naveen Kumar 22:14

Aug. 3, 2017

Thread Author Time
Create view Daulat Ram 07:18
Re: Create view Pavel Stehule 07:25

Aug. 4, 2017

Thread Author Time
Slow queries after db upgrade to 9.6 Bhaskar Annamalai 06:09

Aug. 9, 2017

Thread Author Time
Unlogged tables [email protected] 03:20
Re: Unlogged tables Michael Paquier 10:39
Re: Unlogged tables David G. Johnston 14:37
Re: Unlogged tables Stephen Frost 15:12
Re: Unlogged tables Jeff Janes 16:14
Re: Unlogged tables George Neuner 18:15
Re: Unlogged tables [email protected] 18:30
Re: Unlogged tables George Neuner 19:52

Aug. 10, 2017

Thread Author Time
Re: Unlogged tables [email protected] 05:29
Re: Unlogged tables George Neuner 22:28
Re: Unlogged tables George Neuner 22:52

Aug. 11, 2017

Thread Author Time