pgsql-performance - January 2013

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 3 4 5 6 7 8 9 10 11 12 13 14 15 17 18 21 22 23 24 25 27 28 29

Jan. 2, 2013

Thread Author Time
Two Necessary Kernel Tweaks for Linux Systems Shaun Thomas 21:46

Jan. 3, 2013

Thread Author Time
Re: Two Necessary Kernel Tweaks for Linux Systems Richard Neill 00:47
FW: performance issue with a 2.5gb joinded table Daniel Westermann 13:30
Re: FW: performance issue with a 2.5gb joinded table Heikki Linnakangas 17:02
Re: FW: performance issue with a 2.5gb joinded table Daniel Westermann 18:34
Simple join doesn't use index Alex Vinnik 22:54
Re: Simple join doesn't use index Jeremy Harris 23:11
SMP on a heavy loaded database nobody nowhere 23:45

Jan. 4, 2013

Thread Author Time
Re: Simple join doesn't use index Stefan Andreatta 04:33
Re: serious under-estimation of n_distinct for clustered distributions Stefan Andreatta 05:14
Re: SMP on a heavy loaded database Scott Marlowe 07:42
Re[2]: [PERFORM] SMP on a heavy loaded database nobody nowhere 14:41
Re: Re[2]: [PERFORM] SMP on a heavy loaded database Charles Gomes 14:47
Re: Re[2]: [PERFORM] SMP on a heavy loaded database Claudio Freire 14:52
Re[2]: [PERFORM] Re[2]: [PERFORM] SMP on a heavy loaded database nobody nowhere 15:56
Re[2]: [PERFORM] Re[2]: [PERFORM] SMP on a heavy loaded database nobody nowhere 16:23
Re: Re[2]: [PERFORM] SMP on a heavy loaded database Claudio Freire 16:43
Re: Postgres delete performance problem dankogan 17:49
Re: Postgres delete performance problem Vitalii Tymchyshyn 18:05
Re: Re[2]: [PERFORM] SMP on a heavy loaded database Claudio Freire 19:04
Re: FW: performance issue with a 2.5gb joinded table Tom Lane 20:40
Re[4]: [PERFORM] Re[2]: [PERFORM] SMP on a heavy loaded database nobody nowhere 21:07
Re: Re[2]: [PERFORM] SMP on a heavy loaded database Claudio Freire 21:20
Re: FW: performance issue with a 2.5gb joinded table Daniel Westermann 21:29
Partition table in 9.0.x? AJ Weber 21:31
Re[6]: [PERFORM] Re[2]: [PERFORM] SMP on a heavy loaded database nobody nowhere 21:38
Re: Re[2]: [PERFORM] SMP on a heavy loaded database Claudio Freire 21:53
Re: Re[4]: [PERFORM] Re[2]: [PERFORM] SMP on a heavy loaded database Tom Lane 23:01

Jan. 5, 2013

Thread Author Time
Re: Partition table in 9.0.x? Jeff Janes 04:03
Re[2]: [PERFORM] Re[2]: [PERFORM] SMP on a heavy loaded database nobody nowhere 08:37
Re[2]: [PERFORM] Re[4]: [PERFORM] Re[2]: [PERFORM] SMP on a heavy loaded database nobody nowhere 08:53
Re: [PERFORM] Slow query: bitmap scan troubles Tom Lane 22:18

Jan. 6, 2013

Thread Author Time
Re: Partition table in 9.0.x? AJ Weber 15:27
Re: [PERFORM] Slow query: bitmap scan troubles Jeff Janes 16:29
Re: [PERFORM] Slow query: bitmap scan troubles 📎 Tom Lane 18:18
Re: [PERFORM] Slow query: bitmap scan troubles Simon Riggs 18:19
Re: [PERFORM] Slow query: bitmap scan troubles Simon Riggs 18:22
Re: [PERFORM] Slow query: bitmap scan troubles Tom Lane 18:58
Re: [PERFORM] Slow query: bitmap scan troubles Simon Riggs 19:47
Re: [PERFORM] Slow query: bitmap scan troubles 📎 Tom Lane 23:03
Re: [PERFORM] Slow query: bitmap scan troubles 📎 Tom Lane 23:17

Jan. 7, 2013

Thread Author Time
Re: [PERFORM] Slow query: bitmap scan troubles Simon Riggs 00:03
Re: Sub optimal performance with default setting of Postgresql with FreeBSD 9.1 on ZFS Patrick Dung 17:18
Re: [PERFORM] Slow query: bitmap scan troubles 📎 Tom Lane 17:35
Re: [PERFORM] Slow query: bitmap scan troubles Simon Riggs 18:03
Re: SMP on a heavy loaded database FIXED !!!! nobody nowhere 18:10
Re: [PERFORM] Slow query: bitmap scan troubles Tom Lane 18:27
Re: Sub optimal performance with default setting of Postgresql with FreeBSD 9.1 on ZFS [email protected] 18:28
Re: [PERFORM] Slow query: bitmap scan troubles Claudio Freire 18:48
Re: Two Necessary Kernel Tweaks for Linux Systems Merlin Moncure 19:22
Forcing WAL flush james 21:49
Re: Forcing WAL flush François Beausoleil 21:55
Re: Forcing WAL flush james 22:05
Re: Forcing WAL flush Jeff Janes 23:56

Jan. 8, 2013

Thread Author Time
Re: Simple join doesn't use index Merlin Moncure 00:13
Re: Two Necessary Kernel Tweaks for Linux Systems Andrea Suisani 08:29
Re: Two Necessary Kernel Tweaks for Linux Systems Andrea Suisani 15:16
Re: Partition table in 9.0.x? Jeff Janes 15:26
Re: Sub optimal performance with default setting of Postgresql with FreeBSD 9.1 on ZFS Patrick Dung 16:26
Re: Partition table in 9.0.x? AJ Weber 16:45
Re: Partition table in 9.0.x? Jeff Janes 17:21
Re: Partition table in 9.0.x? Tom Lane 17:51
Re: Partition table in 9.0.x? AJ Weber 18:04
Re: Two Necessary Kernel Tweaks for Linux Systems Midge Brown 18:25
Re: Two Necessary Kernel Tweaks for Linux Systems Shaun Thomas 18:28
Re: Two Necessary Kernel Tweaks for Linux Systems Scott Marlowe 18:31
Re: Two Necessary Kernel Tweaks for Linux Systems Shaun Thomas 18:36
Re: Two Necessary Kernel Tweaks for Linux Systems Scott Marlowe 19:04
Re: Two Necessary Kernel Tweaks for Linux Systems Shaun Thomas 19:32
Re: Two Necessary Kernel Tweaks for Linux Systems AJ Weber 20:05
Re: Two Necessary Kernel Tweaks for Linux Systems Shaun Thomas 21:48
Re: Two Necessary Kernel Tweaks for Linux Systems Alan Hodgson 23:24

Jan. 9, 2013

Thread Author Time
Re: Simple join doesn't use index Jeff Janes 04:34
Re: FW: performance issue with a 2.5gb joinded table Vladimir Sitnikov 09:30
Re: Simple join doesn't use index Alex Vinnik 15:49
Re: Simple join doesn't use index Merlin Moncure 15:53

Jan. 10, 2013

Thread Author Time
Re: Two Necessary Kernel Tweaks for Linux Systems Henri Philipps 08:51
Slow query after upgrade from 9.0 to 9.2 Andrzej Zawadzki 13:32
Re: Two Necessary Kernel Tweaks for Linux Systems Shaun Thomas 15:53
Updates on one row causing ExclusiveLock on PostgreSQL 8.3.5 PostgreSQL 18:01
Updates on one row causing ExclusiveLock on PostgreSQL 8.3.5 PostgreSQL 18:04
Re: Slow query after upgrade from 9.0 to 9.2 Jeff Janes 18:17
Partition insert trigger using C language Matheus de Oliveira 18:45
Re: Slow query after upgrade from 9.0 to 9.2 Matheus de Oliveira 18:48
Re: Partition insert trigger using C language Heikki Linnakangas 18:54
Re: Partition insert trigger using C language Matheus de Oliveira 19:11
Re: Partition insert trigger using C language Pavel Stehule 19:14
Re: Partition insert trigger using C language Heikki Linnakangas 19:22
Re: Partition insert trigger using C language Matheus de Oliveira 19:48
Re: Partition insert trigger using C language Charles Gomes 19:57

Jan. 11, 2013

Thread Author Time
Re: [PERFORM] Slow query: bitmap scan troubles 📎 Tom Lane 01:07
Re: Slow query after upgrade from 9.0 to 9.2 Andrzej Zawadzki 08:13
Re: Slow query after upgrade from 9.0 to 9.2 Andrzej Zawadzki 08:23
Re: Partition insert trigger using C language Heikki Linnakangas 10:19
Re: Partition insert trigger using C language Matheus de Oliveira 10:36
Re: Partition insert trigger using C language Matheus de Oliveira 10:57
Re: Partition insert trigger using C language Heikki Linnakangas 11:02
Re: Partition insert trigger using C language Matheus de Oliveira 11:55
Re: Slow query after upgrade from 9.0 to 9.2 Jeff Janes 17:12
Insert performance for large transaction with multiple COPY FROM Horst Dehmer 23:55

Jan. 12, 2013

Thread Author Time
Insert performance for large transaction with multiple COPY FROM Jeff Janes 01:17
Re: Insert performance for large transaction with multiple COPY FROM Claudio Freire 01:17
Re: Insert performance for large transaction with multiple COPY FROM Horst Dehmer 20:16
Re: Insert performance for large transaction with multiple COPY FROM Jeff Janes 21:23
Re: Insert performance for large transaction with multiple COPY FROM Claudio Freire 22:18
Re: Insert performance for large transaction with multiple COPY FROM Tom Lane 22:26
Re: Insert performance for large transaction with multiple COPY FROM Horst Dehmer 22:41

Jan. 13, 2013

Thread Author Time
Re: Insert performance for large transaction with multiple COPY FROM Claudio Freire 01:52
From TODO: Simplify creation of partitioned tables Alexandre de Arruda Paes 21:49

Jan. 14, 2013

Thread Author Time
Re: serious under-estimation of n_distinct for clustered distributions Stefan Andreatta 07:35
Re: serious under-estimation of n_distinct for clustered distributions Peter Geoghegan 11:34
Re: Two Necessary Kernel Tweaks for Linux Systems Boszormenyi Zoltan 14:28
Re: [PERFORM] Slow query: bitmap scan troubles Robert Haas 16:45
Re: [PERFORM] Slow query: bitmap scan troubles Tom Lane 17:23
Re: [PERFORM] Slow query: bitmap scan troubles Robert Haas 17:50
Re: [PERFORM] Slow query: bitmap scan troubles Tom Lane 17:56
Re: Partition table in 9.0.x? Jeff Janes 18:24

Jan. 15, 2013

Thread Author Time
Re: [PERFORM] Slow query: bitmap scan troubles Bruce Momjian 19:46
Re: [PERFORM] Slow query: bitmap scan troubles Tom Lane 20:11
Re: Insert performance for large transaction with multiple COPY FROM Horst Dehmer 23:44

Jan. 17, 2013

Thread Author Time
Re: Performance on Bulk Insert to Partitioned Table Ali Pouya 14:38
Re: Performance on Bulk Insert to Partitioned Table Charles Gomes 15:01
Re: Performance on Bulk Insert to Partitioned Table Ali Pouya 16:03
Re: Insert performance for large transaction with multiple COPY FROM Jeff Janes 18:12

Jan. 18, 2013

Thread Author Time
Re: Insert performance for large transaction with multiple COPY FROM Horst Dehmer 23:15

Jan. 21, 2013

Thread Author Time
High CPU usage after partitioning rudi 15:05
Analyze and default_statistics_target AJ Weber 15:29
Re: Analyze and default_statistics_target Heikki Linnakangas 15:47
Re: Analyze and default_statistics_target Albe Laurenz 16:00
Re: High CPU usage after partitioning Merlin Moncure 17:13
Re: High CPU usage after partitioning Kevin Grittner 21:12

Jan. 22, 2013

Thread Author Time
Re: High CPU usage after partitioning Andrew Dunstan 00:41
Re: High CPU usage after partitioning rudi 13:34
Re: High CPU usage after partitioning Merlin Moncure 14:04
Re: High CPU usage after partitioning rudi 14:21
Re: High CPU usage after partitioning Andrew Dunstan 14:46
Re: High CPU usage after partitioning rudi 15:08
Re: High CPU usage after partitioning Igor Neyman 15:42
Re: High CPU usage after partitioning Tom Lane 18:38
Effect of the WindowAgg on the Nested Loop Виктор Егоров 20:57

Jan. 23, 2013

Thread Author Time
autovacuum fringe case? AJ Weber 16:53
Re: autovacuum fringe case? Evgeniy Shishkin 19:03
Re: autovacuum fringe case? Jeff Janes 19:13
Re: autovacuum fringe case? Kevin Grittner 22:17
Re: autovacuum fringe case? AJ Weber 22:48

Jan. 24, 2013

Thread Author Time
Re: autovacuum fringe case? Alvaro Herrera 02:03
Re: autovacuum fringe case? Jeff Janes 03:06

Jan. 25, 2013

Thread Author Time
DML's to tpcw benchmark for postgresql Sachin D. Kotwal 06:38
Nested loop and simple join query - slow after upgrade to 9.2 alexandre - aldeia digital 15:34
Re: Nested loop and simple join query - slow after upgrade to 9.2 Jeff Janes 18:29
Re: Nested loop and simple join query - slow after upgrade to 9.2 alexandre - aldeia digital 19:30

Jan. 27, 2013

Thread Author Time
PostgreSQL over internet belal hamed 00:15
Re: PostgreSQL over internet [email protected] 02:45
Re: [PERFORM] pgbench to the MAXINT 📎 Satoshi Nagayasu 04:24
Re: PostgreSQL over internet Richard Neill 06:13
Re: PostgreSQL over internet belal hamed 12:09
Re: PostgreSQL over internet [email protected] 17:33
Re: PostgreSQL over internet David Rowley 20:23

Jan. 28, 2013

Thread Author Time
Re: PostgreSQL over internet belal hamed 11:15
Triggers and transactions Craig James 18:54
Re: Triggers and transactions Richard Huxton 19:10
Re: Triggers and transactions Rosser Schwarz 19:25
Re: [PERFORM] pgbench to the MAXINT Gurjeet Singh 21:30
Re: Simple join doesn't use index Alex Vinnik 23:43

Jan. 29, 2013

Thread Author Time
Re: Simple join doesn't use index Filip Rembiałkowski 00:55
Re: Simple join doesn't use index Merlin Moncure 02:31
Re: [PERFORM] pgbench to the MAXINT Heikki Linnakangas 10:12
Re: Simple join doesn't use index Alex Vinnik 14:24
Re: Simple join doesn't use index Alex Vinnik 14:41
Re: Simple join doesn't use index Filip Rembiałkowski 16:19
Re: Simple join doesn't use index Merlin Moncure 16:41
Re: Simple join doesn't use index Ben Chobot 17:39
Re: Simple join doesn't use index Alex Vinnik 18:59
Re: Simple join doesn't use index Merlin Moncure 19:35
Re: Simple join doesn't use index Jeff Janes 20:06
Re: Simple join doesn't use index Alex Vinnik 20:43
Re: Simple join doesn't use index Alex Vinnik 20:48
Re: Simple join doesn't use index Jeff Janes 23:15

Browse Archives

Prev | Next
Jump to day: 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 17 18 21 22 23 24 25 27 28 29