pgsql-performance - July 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
Jump to day: 1 2 5 6 7 8 10 11 12 14 15 16 17 18 19 20 21 25 26 27

July 1, 2017

Thread Author Time
Re: Simple SQL too slow Daviramos Roussenq Fortunato 16:56
Re: Simple SQL too slow Andreas Kretschmer 19:44
Re: Simple SQL too slow Daviramos Roussenq Fortunato 20:39
Re: Simple SQL too slow Tomas Vondra 20:58
Re: Simple SQL too slow Julien Rouhaud 21:17

July 2, 2017

Thread Author Time
Re: Simple SQL too slow Daviramos Roussenq Fortunato 01:26
Re: Simple SQL too slow Andreas Kretschmer 04:25
Re: Simple SQL too slow Tomas Vondra 08:39
Re: Simple SQL too slow Nicolas CHARLES 10:01
Re: Simple SQL too slow Daviramos Roussenq Fortunato 13:57

July 5, 2017

Thread Author Time
Unable to start the slave instance Daulat Ram 09:14
Unable to start the slave instance Daulat Ram 09:26
Re: Unable to start the slave instance Scott Marlowe 13:10

July 6, 2017

Thread Author Time
Re: Unable to start the slave instance Daulat Ram 05:02
Re: Unable to start the slave instance Michael Paquier 05:10
partitioning materialized views Rick Otten 15:03
Re: partitioning materialized views Shaun Thomas 15:25
Re: partitioning materialized views Rick Otten 16:05
Re: partitioning materialized views Rick Otten 16:27

July 7, 2017

Thread Author Time
Re: partitioning materialized views Shaun Thomas 13:12
estimate correlation of index separately from table (Re: index fragmentation on insert-only table with non-unique column) 📎 Justin Pryzby 23:41

July 8, 2017

Thread Author Time
Re: estimate correlation of index separately from table (Re: index fragmentation on insert-only table with non-unique column) Peter Geoghegan 03:27

July 10, 2017

Thread Author Time
Very poor read performance, query independent Charles Nadeau 14:03
Re: Very poor read performance, query independent Rick Otten 15:25
Re: Very poor read performance, query independent Andreas Kretschmer 15:35
Re: Very poor read performance, query independent Charles Nadeau 15:48
vacuum analyze affecting query performance rverghese 17:25
Re: Very poor read performance, query independent Igor Neyman 18:35
Re: Very poor read performance, query independent Jeff Janes 19:24

July 11, 2017

Thread Author Time
Re: vacuum analyze affecting query performance Albe Laurenz 07:15
Re: Very poor read performance, query independent Charles Nadeau 10:39
Re: Very poor read performance, query independent Charles Nadeau 10:42
Re: Very poor read performance, query independent Charles Nadeau 11:02
Re: Very poor read performance, query independent Charles Nadeau 12:46
Re: Very poor read performance, query independent Igor Neyman 14:34
Re: Very poor read performance, query independent Igor Neyman 15:16
Re: Very poor read performance, query independent Charles Nadeau 15:25
Re: Very poor read performance, query independent Igor Neyman 15:46
Re: vacuum analyze affecting query performance rverghese 15:57
Re: Very poor read performance, query independent Merlin Moncure 23:15
Re: Very poor read performance, query independent Joshua D. Drake 23:42

July 12, 2017

Thread Author Time
Re: Very poor read performance, query independent Jeff Janes 00:39
Re: Very poor read performance, query independent Jeff Janes 01:03
Re: Very poor read performance, query independent Mark Kirkwood 02:11
Re: Very poor read performance, query independent Charles Nadeau 07:21
Re: Very poor read performance, query independent Charles Nadeau 07:30
Re: Very poor read performance, query independent Charles Nadeau 10:04
Re: Very poor read performance, query independent Charles Nadeau 13:38
Re: Very poor read performance, query independent Igor Neyman 13:57
Re: Very poor read performance, query independent Rick Otten 14:10
Re: Very poor read performance, query independent bricklen 14:11
Re: Very poor read performance, query independent Igor Neyman 14:31
Re: Very poor read performance, query independent Igor Neyman 16:39
Postgres Dump - Creating index never stops Hans Braxmeier 19:00
Re: Postgres Dump - Creating index never stops Tom Lane 19:41
Re: Very poor read performance, query independent Jeff Janes 22:27

July 14, 2017

Thread Author Time
Re: Very poor read performance, query independent Charles Nadeau 14:34
Re: Very poor read performance, query independent Charles Nadeau 15:34
Re: Very poor read performance, query independent Igor Neyman 19:13
Re: Very poor read performance, query independent Igor Neyman 20:18
Re: Very poor read performance, query independent Mark Kirkwood 23:09
Re: Very poor read performance, query independent Mark Kirkwood 23:57

July 15, 2017

Thread Author Time
Re: Very poor read performance, query independent Charles Nadeau 16:12
Re: Very poor read performance, query independent Charles Nadeau 17:53
Re: Very poor read performance, query independent Scott Marlowe 17:58
Re: Very poor read performance, query independent Mark Kirkwood 23:48

July 16, 2017

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

July 17, 2017

Thread Author Time
Re: Very poor read performance, query independent Charles Nadeau 11:22
Re: Very poor read performance, query independent Claudio Freire 20:56

July 18, 2017

Thread Author Time
Re: Very poor read performance, query independent 📎 Charles Nadeau 09:20
Re: Very poor read performance, query independent Claudio Freire 16:01
Re: Very poor read performance, query independent Claudio Freire 17:13
Re: Very poor read performance, query independent Justin Pryzby 18:01

July 19, 2017

Thread Author Time
Re: Very poor read performance, query independent Scott Marlowe 01:08
Performance degradation from PostgreSQL 8.2.21 to PostgreSQL 9.3.2 fx TATEISHI KOJI 01:54
Re: Performance degradation from PostgreSQL 8.2.21 to PostgreSQL 9.3.2 Albe Laurenz 06:46
Re: Very poor read performance, query independent Charles Nadeau 11:48
How to grant only create schemas and create database objects permission to user. Dinesh Chandra 12108 12:23
Re: How to grant only create schemas and create database objects permission to user. vinny 13:43

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

Browse Archives

Prev | Next
Jump to day: 1 2 5 6 7 8 10 11 12 14 15 16 17 18 19 20 21 25 26 27