pgsql-performance - February 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 4 5 6 7 8 9 10 11 12 13 14 15 16 18 19 20 21 22 23 24 25 26 27 28

Feb. 1, 2013

Thread Author Time
Fighting the planner >:-( Casey Allen Shobe 17:11
Re: Fighting the planner >:-( Casey Allen Shobe 17:54
Re: Fighting the planner >:-( Richard Huxton 18:50
Re: Fighting the planner >:-( Casey Allen Shobe 19:18
Re: Fighting the planner >:-( Casey Allen Shobe 21:02
Re: Fighting the planner >:-( Виктор Егоров 21:12
Re: Fighting the planner >:-( Casey Allen Shobe 21:18
Re: Fighting the planner >:-( Виктор Егоров 21:55
Re: Fighting the planner >:-( Casey Allen Shobe 22:03
Re: Fighting the planner >:-( Виктор Егоров 22:17

Feb. 2, 2013

Thread Author Time
Re: Simple join doesn't use index Jeff Janes 16:39

Feb. 4, 2013

Thread Author Time
Re: Simple join doesn't use index Dan Fairs 21:14
numerical primary key vs alphanumerical primary key Anne Rosset 21:52
Re: numerical primary key vs alphanumerical primary key Виктор Егоров 21:57

Feb. 5, 2013

Thread Author Time
Slow Query Help Will Platnick 03:45
Re: Slow Query Help Heikki Linnakangas 13:58
postgresql.conf recommendations Johnny Tan 22:02
Re: postgresql.conf recommendations Josh Krupka 22:37
Re: postgresql.conf recommendations Johnny Tan 23:46

Feb. 6, 2013

Thread Author Time
Re: postgresql.conf recommendations Josh Krupka 04:23
Re: postgresql.conf recommendations Pavan Deolasee 06:00
Re: postgresql.conf recommendations ac@hsk.hk 06:18
Re: Slow Query Help Pavan Deolasee 08:51
Re: postgresql.conf recommendations Kevin Grittner 12:49
Re: Slow Query Help Will Platnick 13:17
Re: postgresql.conf recommendations David Whittaker 15:42
Re: Slow Query Help Kevin Grittner 16:22
Re: Slow Query Help Will Platnick 16:24
Re: Slow Query Help Pavan Deolasee 16:27
Re: postgresql.conf recommendations Josh Krupka 18:20
Re: postgresql.conf recommendations David Whittaker 19:13
Re: postgresql.conf recommendations Johnny Tan 19:33
Re: postgresql.conf recommendations Johnny Tan 19:45
Re: postgresql.conf recommendations Johnny Tan 19:47
Re: postgresql.conf recommendations Jeff Janes 20:12
Re: postgresql.conf recommendations Josh Krupka 20:27
Re: postgresql.conf recommendations Kevin Grittner 21:12

Feb. 7, 2013

Thread Author Time
Re: postgresql.conf recommendations Strahinja Kustudić 12:06
Re: postgresql.conf recommendations Charles Gomes 14:41
Re: postgresql.conf recommendations Johnny Tan 17:29
Re: postgresql.conf recommendations Josh Krupka 17:49

Feb. 8, 2013

Thread Author Time
FTS performance issue probably due to wrong planner estimate of detoasting Stefan Keller 00:52
Re: FTS performance issue probably due to wrong planner estimate of detoasting Pavel Stehule 05:45
Re: FTS performance issue probably due to wrong planner estimate of detoasting Jesper Krogh 06:56
Slow query even with aggressive auto analyze Karolis Pocius 12:36
Re: FTS performance issue probably due to wrong planner estimate of detoasting Stefan Keller 17:30
temp tablespaces and SSDs, etc.. Jon Nelson 20:52
Query Time is Slow Foster, Kristian B (HSC) 22:13
Re: Query Time is Slow Kevin Grittner 22:45

Feb. 9, 2013

Thread Author Time
Re: postgresql.conf recommendations Johnny Tan 13:19
Re: postgresql.conf recommendations Johnny Tan 13:24
Re: postgresql.conf recommendations Scott Marlowe 14:51
Re: postgresql.conf recommendations Josh Krupka 19:37
Re: postgresql.conf recommendations Jeff Janes 20:16
Re: postgresql.conf recommendations Scott Marlowe 21:03

Feb. 10, 2013

Thread Author Time
Re: postgresql.conf recommendations Jeff Janes 04:02
Re: Slow query even with aggressive auto analyze Amit kapila 06:52

Feb. 11, 2013

Thread Author Time
Is it correct to optimize a query with subselect in the "where"? Alexandre Riveira 12:52
Re: postgresql.conf recommendations Charles Gomes 14:57
Re: Partition insert trigger using C language Ali Pouya 15:24
Re: postgresql.conf recommendations Johnny Tan 22:10
Re: postgresql.conf recommendations Scott Marlowe 22:57
Re: postgresql.conf recommendations Will Platnick 23:29

Feb. 12, 2013

Thread Author Time
Re: postgresql.conf recommendations Scott Marlowe 02:54
Re: numerical primary key vs alphanumerical primary key Julien Cigar 13:06
Re: numerical primary key vs alphanumerical primary key Grant Johnson 15:05
Re: numerical primary key vs alphanumerical primary key Florent Guillaume 15:14
Re: numerical primary key vs alphanumerical primary key Claudio Freire 16:26
High CPU usage / load average after upgrading to Ubuntu 12.04 Dan Kogan 17:25
Re: High CPU usage / load average after upgrading to Ubuntu 12.04 Dan Kogan 19:59

Feb. 13, 2013

Thread Author Time
Re: High CPU usage / load average after upgrading to Ubuntu 12.04 Dan Kogan 01:28
Re: Partition insert trigger using C language Matheus de Oliveira 11:00
connection poolers' db connections Yetkin Öztürk 13:47
Re: connection poolers' db connections Kevin Grittner 14:56
Re: connection poolers' db connections Yetkin Öztürk 15:35
Re: High CPU usage / load average after upgrading to Ubuntu 12.04 Josh Berkus 19:24

Feb. 14, 2013

Thread Author Time
Re: High CPU usage / load average after upgrading to Ubuntu 12.04 Josh Berkus 00:25
Re: High CPU usage / load average after upgrading to Ubuntu 12.04 Dan Kogan 01:30
700K Inserts in transaction Asmir Mustafic 10:28
PG_XLOG 27028 files running out of space Tory M Blue 10:49
Re: PG_XLOG 27028 files running out of space Ian Lawrence Barwick 11:01
Re: PG_XLOG 27028 files running out of space Tory M Blue 11:06
Re: PG_XLOG 27028 files running out of space Heikki Linnakangas 11:08
Re: PG_XLOG 27028 files running out of space Albe Laurenz 11:09
Re: PG_XLOG 27028 files running out of space Tory M Blue 11:11
Re: 700K Inserts in transaction nik9000 11:51
Re: High CPU usage / load average after upgrading to Ubuntu 12.04 Merlin Moncure 14:07
Surprising no use of indexes - low performance Nicolas Charles 15:35
Re: High CPU usage / load average after upgrading to Ubuntu 12.04 Dan Kogan 17:27
Re: Surprising no use of indexes - low performance Ireneusz Pluta 18:25
Re: High CPU usage / load average after upgrading to Ubuntu 12.04 Josh Berkus 18:38
Re: Surprising no use of indexes - low performance Jeff Janes 19:27
Re: High CPU usage / load average after upgrading to Ubuntu 12.04 Dan Kogan 20:41
Re: High CPU usage / load average after upgrading to Ubuntu 12.04 Josh Berkus 23:57

Feb. 15, 2013

Thread Author Time
Re: High CPU usage / load average after upgrading to Ubuntu 12.04 Dan Kogan 04:32
Re: High CPU usage / load average after upgrading to Ubuntu 12.04 Scott Marlowe 04:47
Re: Partition insert trigger using C language Ali Pouya 08:47
Re: Surprising no use of indexes - low performance Nicolas Charles 09:00
Very slow update statement on 40mio rows Florian Schröck 14:30
Re: Very slow update statement on 40mio rows Kevin Grittner 14:59
Re: Very slow update statement on 40mio rows Florian Schröck 15:32
Re: Surprising no use of indexes - low performance Jeff Janes 18:04
Re: High CPU usage / load average after upgrading to Ubuntu 12.04 Josh Berkus 18:26
Re: High CPU usage / load average after upgrading to Ubuntu 12.04 Scott Marlowe 18:52
Re: Surprising no use of indexes - low performance Merlin Moncure 21:27

Feb. 16, 2013

Thread Author Time
Re: temp tablespaces and SSDs, etc.. Bruce Momjian 00:32
Re: Surprising no use of indexes - low performance Nicolas Charles 09:25

Feb. 18, 2013

Thread Author Time
slow query plans caused by under-estimation of CTE cardinality John Lumby 16:45
Re: slow query plans caused by under-estimation of CTE cardinality Vitalii Tymchyshyn 20:40
Re: slow query plans caused by under-estimation of CTE cardinality John Lumby 23:26

Feb. 19, 2013

Thread Author Time
Re: High CPU usage / load average after upgrading to Ubuntu 12.04 Josh Berkus 00:19
Re: High CPU usage / load average after upgrading to Ubuntu 12.04 Josh Berkus 00:39
Re: High CPU usage / load average after upgrading to Ubuntu 12.04 Jon Nelson 00:46
Re: High CPU usage / load average after upgrading to Ubuntu 12.04 Josh Berkus 00:51
Re: High CPU usage / load average after upgrading to Ubuntu 12.04 Scott Marlowe 03:41
Re: High CPU usage / load average after upgrading to Ubuntu 12.04 Mark Kirkwood 04:28
Speed of exist Bastiaan Olij 06:34
Re: Speed of exist Andy 07:31
Re: Speed of exist Bastiaan Olij 07:36
Re: Speed of exist Pavel Stehule 07:39
Re: slow query plans caused by under-estimation of CTE cardinality Tom Lane 10:09
Re: Speed of exist Bastiaan Olij 10:18
Re: High CPU usage / load average after upgrading to Ubuntu 12.04 Josh Berkus 17:51
Re: Very slow update statement on 40mio rows Merlin Moncure 20:04
Re: High CPU usage / load average after upgrading to Ubuntu 12.04 Mark Kirkwood 23:17
Re: High CPU usage / load average after upgrading to Ubuntu 12.04 Josh Berkus 23:24
Re: High CPU usage / load average after upgrading to Ubuntu 12.04 Mark Kirkwood 23:37

Feb. 20, 2013

Thread Author Time
Re: High CPU usage / load average after upgrading to Ubuntu 12.04 Scott Marlowe 03:15
Re: High CPU usage / load average after upgrading to Ubuntu 12.04 Josh Berkus 22:44

Feb. 21, 2013

Thread Author Time
Re: High CPU usage / load average after upgrading to Ubuntu 12.04 Scott Marlowe 01:15
Re: High CPU usage / load average after upgrading to Ubuntu 12.04 Josh Berkus 03:14
Wrong actual number of rows in the Query Plan Vahe Evoyan 07:24
Poor performance after update from SLES11 SP1 to SP2 Mark Smith 09:59
Re: Poor performance after update from SLES11 SP1 to SP2 Vasilis Ventirozos 10:25
Re: Poor performance after update from SLES11 SP1 to SP2 Scott Marlowe 10:36
Re: High CPU usage / load average after upgrading to Ubuntu 12.04 Glyn Astill 11:24
Re: Poor performance after update from SLES11 SP1 to SP2 Sergey Konoplev 16:23
Are bitmap index scans slow to start? Carlo Stonebanks 16:57
Re: Are bitmap index scans slow to start? Jeff Janes 18:19
Re: Are bitmap index scans slow to start? Marc Mamin 19:40
Bad query plan with high-cardinality column Alexander Staubo 19:44
Using a window function in a view Chris Hanks 23:37

Feb. 22, 2013

Thread Author Time
BUG: endless lseek(.., SEEK_END) from select queries on x64 builds Markus Schulz 08:25
xmlconcat performance Davide Berra 09:21
Re: BUG: endless lseek(.., SEEK_END) from select queries on x64 builds Heikki Linnakangas 13:35
Re: BUG: endless lseek(.., SEEK_END) from select queries on x64 builds Stephen Frost 13:37
Avoiding Recheck Cond when using Select Distinct jackrg 16:36
Re: Avoiding Recheck Cond when using Select Distinct Jeff Janes 17:19
Re: Are bitmap index scans slow to start? Carlo Stonebanks 17:50
Re: Are bitmap index scans slow to start? Carlo Stonebanks 17:50
Re: Avoiding Recheck Cond when using Select Distinct Vitalii Tymchyshyn 17:59
Re: BUG: endless lseek(.., SEEK_END) from select queries on x64 builds Markus Schulz 18:10
Bad query plan with high-cardinality column Alexander Staubo 18:22
Re: Are bitmap index scans slow to start? Nikolas Everett 19:05
Re: Avoiding Recheck Cond when using Select Distinct Maciek Sakrejda 19:06
Re: Are bitmap index scans slow to start? Carlo Stonebanks 20:05
Re: Are bitmap index scans slow to start? Gavin Flower 20:07
Re: Bad query plan with high-cardinality column Tom Lane 20:33
Re: Bad query plan with high-cardinality column Kevin Grittner 20:47
Re: Bad query plan with high-cardinality column Alexander Staubo 21:31
Re: Bad query plan with high-cardinality column Alexander Staubo 21:34
Re: Bad query plan with high-cardinality column Kevin Grittner 22:17

Feb. 23, 2013

Thread Author Time
Re: Bad query plan with high-cardinality column Tom Lane 10:10
Re: BUG: endless lseek(.., SEEK_END) from select queries on x64 builds Heikki Linnakangas 15:54
Re: BUG: endless lseek(.., SEEK_END) from select queries on x64 builds Tom Lane 16:14
Are bitmap index scans slow to start? Jeff Janes 16:15
Re: Are bitmap index scans slow to start? Jeff Janes 17:45
Re: Avoiding Recheck Cond when using Select Distinct Jeff Janes 23:53

Feb. 24, 2013

Thread Author Time
Server stalls, all CPU 100% system time Andre 14:08
Re: Server stalls, all CPU 100% system time Bèrto ëd Sèra 14:13
Re: Server stalls, all CPU 100% system time Andre 14:39
Re: Server stalls, all CPU 100% system time Tom Lane 14:45
Re: Server stalls, all CPU 100% system time Scott Marlowe 16:43

Feb. 25, 2013

Thread Author Time
Re: Are bitmap index scans slow to start? Carlo Stonebanks 17:04
Re: Avoiding Recheck Cond when using Select Distinct Maciek Sakrejda 18:11
Re: Avoiding Recheck Cond when using Select Distinct Jeff Janes 18:48
Re: High CPU usage / load average after upgrading to Ubuntu 12.04 Jeff Frost 22:30

Feb. 26, 2013

Thread Author Time
Re: Very slow update statement on 40mio rows Florian Schröck 08:01
Re: Server stalls, all CPU 100% system time Andre 12:53
Re: Are bitmap index scans slow to start? Jeff Janes 18:11
Estimation question... Matt Daw 19:35
Re: High CPU usage / load average after upgrading to Ubuntu 12.04 Jeff Janes 21:30
pgbench intriguing results: better tps figures for larger scale factor Costin Oproiu 21:45
Re: High CPU usage / load average after upgrading to Ubuntu 12.04 Scott Marlowe 21:46
Re: Server stalls, all CPU 100% system time Josh Berkus 23:29

Feb. 27, 2013

Thread Author Time
Re: Are bitmap index scans slow to start? Carlo Stonebanks 00:33
Re: Server stalls, all CPU 100% system time Scott Marlowe 01:02
seqscan on UNION'ed views 📎 Dmitry Karasik 10:03
Re: Server stalls, all CPU 100% system time Andre 10:52
Re: seqscan on UNION'ed views Tom Lane 14:21
Re: Estimation question... Matt Daw 17:08
Re: Are bitmap index scans slow to start? Jeff Janes 18:03
Re: Are bitmap index scans slow to start? Carlo Stonebanks 21:38
Re: Server stalls, all CPU 100% system time Josh Berkus 23:07

Feb. 28, 2013

Thread Author Time
Re: Are bitmap index scans slow to start? Carlo Stonebanks 05:12
SELECT is slow on smaller table? Ao Jianwang 15:11
Re: SELECT is slow on smaller table? Julien Cigar 15:19
Re: Estimation question... Matt Daw 16:31
Re: pgbench intriguing results: better tps figures for larger scale factor Pavan Deolasee 17:20
Re: xmlconcat performance Merlin Moncure 17:48

Browse Archives

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