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

April 4, 2017

Thread	Author	Time
Delete, foreign key, index usage	Johann Spies	12:07

April 5, 2017

Thread	Author	Time
Re: Delete, foreign key, index usage	Johann Spies	10:40
Re: Delete, foreign key, index usage	Rick Otten	11:15
How to send content of log file in official mailid.	Dinesh Chandra 12108	16:53
Table not using tsvector gin index and performance much worse than when it uses it.	rverghese	22:51
Re: Table not using tsvector gin index and performance much worse than when it uses it.	Tom Lane	23:19
Re: Table not using tsvector gin index and performance much worse than when it uses it.	rverghese	23:54

April 6, 2017

Thread	Author	Time
Re: -EXT-Re: Table not using tsvector gin index and performance much worse than when it uses it.	Sfiligoi, Igor	00:09
Re: -EXT-Re: Table not using tsvector gin index and performance much worse than when it uses it.	rverghese	00:26
Re: -EXT-Re: Table not using tsvector gin index and performance much worse than when it uses it.	Tom Lane	01:08
Re: -EXT-Re: Table not using tsvector gin index and performance much worse than when it uses it.	rverghese	01:10

April 7, 2017

Thread	Author	Time
Filter certain range of IP address.	Dinesh Chandra 12108	14:13
Re: Filter certain range of IP address.	vinny	14:22
Understanding PostgreSQL query execution time	Haider Ali	14:56
Re: Understanding PostgreSQL query execution time	[email protected]	15:03
Re: Understanding PostgreSQL query execution time	Gerardo Herzig	15:15
Re: Filter certain range of IP address.	Dinesh Chandra 12108	15:18
Re: Filter certain range of IP address.	David G. Johnston	15:29
Re: Filter certain range of IP address.	Rick Otten	15:56
Re: Filter certain range of IP address.	Dinesh Chandra 12108	16:09
Re: Filter certain range of IP address. 📎	Moreno Andreo	16:20

April 10, 2017

Thread	Author	Time
Re: Filter certain range of IP address.	vinny	11:33
Re: Understanding PostgreSQL query execution time	vinny	12:18

April 13, 2017

Thread	Author	Time
Hi	Daulat Ram	06:25
Re: Hi	Glyn Astill	08:21
Postgresql, and ODBC handles	Reza Taheri	19:30
Impact of track_activity_query_size on high traffic OLTP system	Jeremy Finzel	20:45
Re: Impact of track_activity_query_size on high traffic OLTP system	Rick Otten	21:17

April 14, 2017

Thread	Author	Time
Postgres 9.5 / 9.6: Restoring PG 9.4 dump is very very slow	Hans Braxmeier	23:30
Re: Postgres 9.5 / 9.6: Restoring PG 9.4 dump is very very slow	Tom Lane	23:40

April 15, 2017

Thread	Author	Time
self join estimate and constraint exclusion	Justin Pryzby	00:23
Restoring Postgres Dump is very slow with Ubuntu 16.04	Hans Braxmeier	08:11
Re: Restoring Postgres Dump is very slow with Ubuntu 16.04	Andreas Kretschmer	13:59

April 17, 2017

Thread	Author	Time
Create a materialized view in PostgreSQL which can be access by all the user account	Dinesh Chandra 12108	17:00
Re: Create a materialized view in PostgreSQL which can be access by all the user account	David G. Johnston	17:12

April 18, 2017

Thread	Author	Time
Insert Concurrency	ROBERT PRICE	02:55
Re: Insert Concurrency	David Rowley	05:41
Re: Insert Concurrency	Daniel Blanch Bataller	05:45
Re: Insert Concurrency	Claudio Freire	15:29
Re: Insert Concurrency	Scott Marlowe	15:41
Re: Insert Concurrency	David McKelvie	15:49
Re: Insert Concurrency	ROBERT PRICE	16:29
update from performance question	Armand Pirvu (home)	21:46

April 19, 2017

Thread	Author	Time
Re: update from performance question	Albe Laurenz	08:06
Re: update from performance question	Armand Pirvu (home)	23:11

April 20, 2017

Thread	Author	Time
Query with no result set, really really slow adding ORBDER BY / LIMIT clause	Marco Renzi	07:19
Re: Query with no result set, really really slow adding ORBDER BY / LIMIT clause	Marco Renzi	11:16
Re: Query with no result set, really really slow adding ORBDER BY / LIMIT clause	vinny	11:54
Re: Query with no result set, really really slow adding ORBDER BY / LIMIT clause	Marco Renzi	12:16
Re: Query with no result set, really really slow adding ORBDER BY / LIMIT clause	Pavel Stehule	15:57
Re: Query with no result set, really really slow adding ORBDER BY / LIMIT clause	Pavel Stehule	16:05

April 21, 2017

Thread	Author	Time
Re: Query with no result set, really really slow adding ORBDER BY / LIMIT clause	Marco Renzi	06:49
Re: Query with no result set, really really slow adding ORBDER BY / LIMIT clause	Pavel Stehule	06:56
Re: Query with no result set, really really slow adding ORBDER BY / LIMIT clause	Marco Renzi	07:05
Re: Query with no result set, really really slow adding ORBDER BY / LIMIT clause	Pavel Stehule	07:12

April 24, 2017

Thread	Author	Time
Re: Delete, foreign key, index usage	Johann Spies	06:48
Re: Delete, foreign key, index usage	Tomas Vondra	13:17

April 25, 2017

Thread	Author	Time
Questionaire: Common WAL write rates on busy servers.	Andres Freund	04:17
Re: Delete, foreign key, index usage	Johann Spies	06:28
Re: Delete, foreign key, index usage	David Rowley	07:34
Re: Questionaire: Common WAL write rates on busy servers.	Vladimir Borodin	07:56
Re: [GENERAL] Questionaire: Common WAL write rates on busy servers.	bricklen	14:19
Re: Questionaire: Common WAL write rates on busy servers.	Claudio Freire	16:07
Re: Questionaire: Common WAL write rates on busy servers.	Jerry Sievers	18:56
Re: Delete, foreign key, index usage	Tomas Vondra	23:35

April 26, 2017

Thread	Author	Time
Re: Slow query with 3 table joins	Alessandro Ferrucci	03:19
Re: Slow query with 3 table joins	David Rowley	04:12
Re: Slow query with 3 table joins	Johan Fredriksson	06:24
Re: Slow query with 3 table joins	Alessandro Ferrucci	11:04
Re: Slow query with 3 table joins	Alessandro Ferrucci	11:35
Re: Slow query with 3 table joins	Johan Fredriksson	11:35
Re: Slow query with 3 table joins	Gerardo Herzig	12:27
Re: Slow query with 3 table joins	Gerardo Herzig	15:00
Re: Slow query with 3 table joins	Alessandro Ferrucci	15:22
Re: Slow query with 3 table joins	Matthew Bellew	15:30

April 27, 2017

Thread	Author	Time
EXCLUDE CONSTRAINT with intarray	Alexey Vasiliev	10:38
Re: [PERFORM] Questionaire: Common WAL write rates on busy servers.	Andres Freund	15:59
Re: [PERFORM] Questionaire: Common WAL write rates on busy servers.	Joshua D. Drake	16:31
Re: Questionaire: Common WAL write rates on busy servers.	Andres Freund	16:34
Re: Questionaire: Common WAL write rates on busy servers.	Joshua D. Drake	17:29
Re: Questionaire: Common WAL write rates on busy servers.	Andres Freund	17:35
Re: Performance issue in PostgreSQL server...	Justin Pryzby	18:47
Re: Questionaire: Common WAL write rates on busy servers.	Tomas Vondra	22:53
Re: [PERFORM] Questionaire: Common WAL write rates on busy servers.	Tomas Vondra	23:18
Re: [PERFORM] Questionaire: Common WAL write rates on busy servers.	Tomas Vondra	23:29
Re: Questionaire: Common WAL write rates on busy servers.	Andres Freund	23:34

April 29, 2017

Thread	Author	Time
Re: Questionaire: Common WAL write rates on busy servers.	Tomas Vondra	00:41

Browse Archives

Prev | Next