pgsql-performance - November 2012

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 16 18 20 21 22 23 24 25 26 27 28 29 30

Nov. 1, 2012

Thread Author Time
Re: Re: Increasing work_mem and shared_buffers on Postgres 9.2 significantly slows down queries Petr Praus 19:53
Re: Re: Increasing work_mem and shared_buffers on Postgres 9.2 significantly slows down queries Marcos Ortiz 20:40
Re: pg_buffercache Merlin Moncure 21:26
Re: Re: Increasing work_mem and shared_buffers on Postgres 9.2 significantly slows down queries Gunnar "Nick" Bluth 23:25

Nov. 2, 2012

Thread Author Time
Re: Increasing work_mem and shared_buffers on Postgres 9.2 significantly slows down queries Scott Marlowe 05:39
Re: High %SYS CPU usage Cesar Martin 07:47
Re: dbt2 performance regresses from 9.1.6 to 9.2.1 Ants Aasma 11:27
help with too slow query Pedro Jiménez Pérez 12:13
Re: Increasing work_mem and shared_buffers on Postgres 9.2 significantly slows down queries Petr Praus 14:09
freebsd or linux list, mailing 14:39
Re: Re: Increasing work_mem and shared_buffers on Postgres 9.2 significantly slows down queries Petr Praus 16:12
Constraint exclusion in views Claudio Freire 18:17

Nov. 3, 2012

Thread Author Time
Re: Re: Increasing work_mem and shared_buffers on Postgres 9.2 significantly slows down queries Gunnar "Nick" Bluth 10:31
Re: Re: Increasing work_mem and shared_buffers on Postgres 9.2 significantly slows down queries Petr Praus 15:20
Re: Re: Increasing work_mem and shared_buffers on Postgres 9.2 significantly slows down queries Gunnar "Nick" Bluth 17:09
Re: Re: Increasing work_mem and shared_buffers on Postgres 9.2 significantly slows down queries Petr Praus 17:19
Re: Constraint exclusion in views Josh Berkus 19:37
Re: Constraint exclusion in views Tom Lane 21:23
Re: How to keep queries low latency as concurrency increases Jeff Janes 23:53

Nov. 4, 2012

Thread Author Time
Re: Re: Increasing work_mem and shared_buffers on Postgres 9.2 significantly slows down queries Gunnar "Nick" Bluth 08:48
Re: Constraint exclusion in views Claudio Freire 17:32
Re: dbt2 performance regresses from 9.1.6 to 9.2.1 Dong Ye 22:23
Suggested test points for a performance tool? Christoffer Lernö 23:54

Nov. 5, 2012

Thread Author Time
Re: Suggested test points for a performance tool? Claudio Freire 00:08
DBT-1 Samrat 06:43
DBT-1 Revagade, Samrat 06:44
Re: help with too slow query Виктор Егоров 09:54
Re: help with too slow query Albe Laurenz 10:52
Re: dbt2 performance regresses from 9.1.6 to 9.2.1 Claudio Freire 14:32
Re: Re: Increasing work_mem and shared_buffers on Postgres 9.2 significantly slows down queries Jeff Janes 16:44
Re: Re: Increasing work_mem and shared_buffers on Postgres 9.2 significantly slows down queries Claudio Freire 16:48
Re: Re: Increasing work_mem and shared_buffers on Postgres 9.2 significantly slows down queries Jeff Janes 17:09
Re: [HACKERS] out of memory Robert Haas 17:27
Re: [PERFORM] out of memory John R Pierce 17:30
Re: Re: Increasing work_mem and shared_buffers on Postgres 9.2 significantly slows down queries Claudio Freire 17:40
Re: Re: Increasing work_mem and shared_buffers on Postgres 9.2 significantly slows down queries Claudio Freire 17:59
Re: Constraint exclusion in views Claudio Freire 20:28
Re: How to keep queries low latency as concurrency increases Merlin Moncure 22:51
Re: How to keep queries low latency as concurrency increases Marko Kreen 22:58
Re: How to keep queries low latency as concurrency increases Jeff Janes 23:31
Re: How to keep queries low latency as concurrency increases Marko Kreen 23:58

Nov. 6, 2012

Thread Author Time
Re: How to keep queries low latency as concurrency increases Jeff Janes 01:30
Re: help with too slow query Pedro Jiménez Pérez 09:06
Re: help with too slow query Виктор Егоров 12:17
Re: [HACKERS] pg_dump and thousands of schemas Denis 14:16
Re: help with too slow query Willem Leenen 14:20
Re: help with too slow query Виктор Егоров 14:52
Re: [HACKERS] pg_dump and thousands of schemas Tom Lane 15:07
Re: help with too slow query Willem Leenen 15:12
Re: [HACKERS] pg_dump and thousands of schemas Denis 15:40
Query completed in < 1s in PG 9.1 and ~ 700s in PG 9.2 Rodrigo Rosenfeld Rosas 17:11
Re: Query completed in < 1s in PG 9.1 and ~ 700s in PG 9.2 Merlin Moncure 17:22
Re: Query completed in < 1s in PG 9.1 and ~ 700s in PG 9.2 Tom Lane 17:36
Re: Re: Increasing work_mem and shared_buffers on Postgres 9.2 significantly slows down queries Petr Praus 17:38
Re: [HACKERS] pg_dump and thousands of schemas Tom Lane 17:51
Re: Query completed in < 1s in PG 9.1 and ~ 700s in PG 9.2 ktm@rice.edu 18:08
Re: Query completed in < 1s in PG 9.1 and ~ 700s in PG 9.2 Rodrigo Rosenfeld Rosas 18:09
Re: Query completed in < 1s in PG 9.1 and ~ 700s in PG 9.2 Rodrigo Rosenfeld Rosas 18:22
Re: Query completed in < 1s in PG 9.1 and ~ 700s in PG 9.2 Rodrigo Rosenfeld Rosas 18:30
Re: Query completed in < 1s in PG 9.1 and ~ 700s in PG 9.2 Merlin Moncure 18:42
Re: Query completed in < 1s in PG 9.1 and ~ 700s in PG 9.2 Rodrigo Rosenfeld Rosas 18:57
Re: Re: Increasing work_mem and shared_buffers on Postgres 9.2 significantly slows down queries Gunnar "Nick" Bluth 19:08
Re: Query completed in < 1s in PG 9.1 and ~ 700s in PG 9.2 Tom Lane 19:24
Re: Query completed in < 1s in PG 9.1 and ~ 700s in PG 9.2 Rodrigo Rosenfeld Rosas 19:31
Re: Re: Increasing work_mem and shared_buffers on Postgres 9.2 significantly slows down queries Gunnar "Nick" Bluth 19:38
Re: Query completed in < 1s in PG 9.1 and ~ 700s in PG 9.2 Tom Lane 19:45
Re: Re: Increasing work_mem and shared_buffers on Postgres 9.2 significantly slows down queries Petr Praus 20:08
Re: Re: Increasing work_mem and shared_buffers on Postgres 9.2 significantly slows down queries Gunnar "Nick" Bluth 20:17
Re: Re: Increasing work_mem and shared_buffers on Postgres 9.2 significantly slows down queries Petr Praus 20:24
Re: Re: Increasing work_mem and shared_buffers on Postgres 9.2 significantly slows down queries Gunnar "Nick" Bluth 20:50
Re: Query completed in < 1s in PG 9.1 and ~ 700s in PG 9.2 Merlin Moncure 21:11
Re: Query completed in < 1s in PG 9.1 and ~ 700s in PG 9.2 Tom Lane 21:18
Re: Query completed in < 1s in PG 9.1 and ~ 700s in PG 9.2 Merlin Moncure 21:48

Nov. 7, 2012

Thread Author Time
HT on or off for E5-26xx ? David Boreham 03:31
Re: HT on or off for E5-26xx ? Mark Kirkwood 04:16
Re: [HACKERS] pg_dump and thousands of schemas Denis 10:42
Re: Query completed in < 1s in PG 9.1 and ~ 700s in PG 9.2 Rodrigo Rosenfeld Rosas 11:16
Re: Query completed in < 1s in PG 9.1 and ~ 700s in PG 9.2 Rodrigo Rosenfeld Rosas 11:42
Re: dbt2 performance regresses from 9.1.6 to 9.2.1 Heikki Linnakangas 11:43
Re: HT on or off for E5-26xx ? David Boreham 13:33
Re: HT on or off for E5-26xx ? Devrim GÜNDÜZ 13:37
Re: HT on or off for E5-26xx ? David Boreham 13:45
Re: [HACKERS] pg_dump and thousands of schemas Tom Lane 15:02
Unique values across a table of arrays - documents and tags Ivan Voras 15:21
Re: Query completed in < 1s in PG 9.1 and ~ 700s in PG 9.2 aasat 15:23
Re: Unique values across a table of arrays - documents and tags François Beausoleil 15:34
Re: Unique values across a table of arrays - documents and tags Ivan Voras 15:38
Re: Unique values across a table of arrays - documents and tags Florent Guillaume 15:54
Re: Unique values across a table of arrays - documents and tags Ivan Voras 16:00
Re: Query completed in < 1s in PG 9.1 and ~ 700s in PG 9.2 Merlin Moncure 16:34
Re: Unique values across a table of arrays - documents and tags Florent Guillaume 16:48
Re: Query completed in < 1s in PG 9.1 and ~ 700s in PG 9.2 Tom Lane 16:58
Re: How to upgrade from 9.1 to 9.2 with replication? 📎 Bruce Momjian 18:36
Re: How to upgrade from 9.1 to 9.2 with replication? Claudio Freire 18:44
Re: Query completed in < 1s in PG 9.1 and ~ 700s in PG 9.2 Rodrigo Rosenfeld Rosas 20:29
Re: How to upgrade from 9.1 to 9.2 with replication? Bruce Momjian 20:59
Re: How to upgrade from 9.1 to 9.2 with replication? Claudio Freire 21:18
Re: HT on or off for E5-26xx ? Mark Kirkwood 21:20
Re: Query completed in < 1s in PG 9.1 and ~ 700s in PG 9.2 📎 Rodrigo Rosenfeld Rosas 21:38

Nov. 8, 2012

Thread Author Time
Re: Query completed in < 1s in PG 9.1 and ~ 700s in PG 9.2 Tom Lane 00:58
Re: HT on or off for E5-26xx ? David Boreham 03:16
Re: [HACKERS] pg_dump and thousands of schemas Denis 09:04
Thousands databases or schemas Denis 09:36
Re: Thousands databases or schemas Samuel Gendler 10:31
parallel query evaluation Oliver Seidel 11:55
Re: Thousands databases or schemas Denis 13:29
Re: Thousands databases or schemas Pavel Stehule 13:48
Re: Thousands databases or schemas Mark Thornton 13:50
Re: HT on or off for E5-26xx ? Shaun Thomas 13:58
Re: HT on or off for E5-26xx ? David Boreham 14:18
Re: Query completed in < 1s in PG 9.1 and ~ 700s in PG 9.2 Rodrigo Rosenfeld Rosas 15:30
Re: Query completed in < 1s in PG 9.1 and ~ 700s in PG 9.2 Alvaro Herrera 15:38
Re: Query completed in < 1s in PG 9.1 and ~ 700s in PG 9.2 Rodrigo Rosenfeld Rosas 15:43
Re: Re: Increasing work_mem and shared_buffers on Postgres 9.2 significantly slows down queries Petr Praus 18:23

Nov. 9, 2012

Thread Author Time
Re: Thousands databases or schemas Craig Ringer 06:15
Re: Thousands databases or schemas Magnus Hagander 06:38
Re: HT on or off for E5-26xx ? David Boreham 14:34
Re: Thousands databases or schemas Merlin Moncure 15:04
Re: Increasing work_mem and shared_buffers on Postgres 9.2 significantly slows down queries Andres Freund 17:53
Re: [HACKERS] pg_dump and thousands of schemas Jeff Janes 20:47

Nov. 10, 2012

Thread Author Time
Re: parallel query evaluation Tom Lane 15:32

Nov. 11, 2012

Thread Author Time
Planner sometimes doesn't use a relevant index with IN (subquery) condition Rafał Rzepecki 03:18

Nov. 12, 2012

Thread Author Time
Index is not using K P Manoj 07:31
Re: Index is not using Albe Laurenz 08:31
Re: Index is not using K P Manoj 08:42
Re: Planner sometimes doesn't use a relevant index with IN (subquery) condition Rafał Rzepecki 09:06
Re: Index is not using Albe Laurenz 09:44
fast read of binary data Eildert Groeneveld 10:45
Re: fast read of binary data Albe Laurenz 11:18
Re: fast read of binary data Arjen van der Meijden 11:38
PostreSQL v9.2 uses a lot of memory in Windows XP Wu Ming 14:17
Re: PostreSQL v9.2 uses a lot of memory in Windows XP Albe Laurenz 14:29
Re: PostreSQL v9.2 uses a lot of memory in Windows XP Merlin Moncure 14:52
Re: fast read of binary data Merlin Moncure 16:57
performance regression with 9.2 Dave Cramer 19:49
Re: performance regression with 9.2 Tom Lane 20:43
Re: Planner sometimes doesn't use a relevant index with IN (subquery) condition Gavin Flower 20:49
Re: performance regression with 9.2 Dave Cramer 20:53
Re: performance regression with 9.2 Willem Leenen 21:13
Re: performance regression with 9.2 Tom Lane 21:26

Nov. 13, 2012

Thread Author Time
Re: PostreSQL v9.2 uses a lot of memory in Windows XP Craig Ringer 02:08
postgres 8.4, COPY, and high concurrency Jon Nelson 19:13
Re: postgres 8.4, COPY, and high concurrency Heikki Linnakangas 19:27
Re: postgres 8.4, COPY, and high concurrency Jeff Janes 19:30
Re: postgres 8.4, COPY, and high concurrency Jon Nelson 20:03
Re: postgres 8.4, COPY, and high concurrency Jeff Janes 20:43
Poor performance using CTE David Greco 20:57
Re: PostreSQL v9.2 uses a lot of memory in Windows XP Craig Ringer 23:07

Nov. 14, 2012

Thread Author Time
Re: postgres 8.4, COPY, and high concurrency Jon Nelson 01:10
Re: [HACKERS] pg_dump and thousands of schemas Denis 03:12
Re: [HACKERS] pg_dump and thousands of schemas Jeff Janes 03:40
Re: [HACKERS] pg_dump and thousands of schemas Andrew Dunstan 03:56
Re: PostreSQL v9.2 uses a lot of memory in Windows XP Wu Ming 05:56
Re: PostreSQL v9.2 uses a lot of memory in Windows XP Craig Ringer 06:47
Re: PostreSQL v9.2 uses a lot of memory in Windows XP Peter Geoghegan 12:04
Re: postgres 8.4, COPY, and high concurrency Jon Nelson 14:41
Poor performance using CTE David Greco 15:23
Re: Poor performance using CTE Andrew Dunstan 15:50
Re: Poor performance using CTE David Greco 15:56
Re: Poor performance using CTE Andrew Dunstan 16:07
SOLVED - RE: Poor performance using CTE David Greco 16:18
Re: SOLVED - RE: Poor performance using CTE Tom Lane 16:29
Re: postgres 8.4, COPY, and high concurrency Jeff Janes 19:01
Re: postgres 8.4, COPY, and high concurrency Jon Nelson 20:04
Re: Setting Statistics on Functional Indexes Robert Haas 20:36
Re: Setting Statistics on Functional Indexes Claudio Freire 20:55
Re: Setting Statistics on Functional Indexes Tom Lane 21:00
Re: postgres 8.4, COPY, and high concurrency Jeff Janes 21:25
Re: postgres 8.4, COPY, and high concurrency Strange, John W 22:06

Nov. 15, 2012

Thread Author Time
Re: SOLVED - RE: Poor performance using CTE Craig Ringer 01:17
Re: SOLVED - RE: Poor performance using CTE Tom Lane 01:31
Re: SOLVED - RE: Poor performance using CTE Andrew Dunstan 01:46
Re: SOLVED - RE: Poor performance using CTE Peter Geoghegan 02:03
PQconnectStart/PQconnectPoll Sergio Mayoral 09:02
help on slow query using postgres 8.4 Maria L. Wilson 15:03
Re: Thousands databases or schemas Bruce Momjian 15:49
slow query on postgres 8.4 Maria L. Wilson 15:59
Re: SOLVED - RE: Poor performance using CTE Gavin Flower 18:26
Query that uses lots of memory in PostgreSQL 9.2.1 in Windows 7 Antti Jokipii 19:20
Re: performance regression with 9.2 Tom Lane 19:21

Nov. 16, 2012

Thread Author Time
PostgreSQL strange query plan for my query David Popiashvili 11:32
PostgreSQL strange query plan for my query David Popiashvili 11:40
Re: PostgreSQL strange query plan for my query Albe Laurenz 12:55
Re: PostgreSQL strange query plan for my query David Popiashvili 13:04
Re: PostgreSQL strange query plan for my query 📎 Julien Cigar 13:18
intercepting where clause on a view or other performance tweak Russell Keane 14:28
Re: intercepting where clause on a view or other performance tweak Tom Lane 15:05
Re: intercepting where clause on a view or other performance tweak Russell Keane 15:17
Re: intercepting where clause on a view or other performance tweak Russell Keane 15:22
Re: intercepting where clause on a view or other performance tweak Tom Lane 15:41
Re: PostgreSQL strange query plan for my query Craig James 16:32
Re: PostgreSQL strange query plan for my query David Popiashvili 16:35
Re: PostgreSQL strange query plan for my query Julien Cigar 16:53

Nov. 18, 2012

Thread Author Time
partitioning versus clustering Andrew W. Gibbs 17:14

Nov. 20, 2012

Thread Author Time
Re: Query that uses lots of memory in PostgreSQL 9.2.1 in Windows 7 Pavel Stehule 07:27
FW: slow query on postgres 8.4 Russell Keane 11:16
Re: PQconnectStart/PQconnectPoll Kevin Grittner 12:57
Re: help on slow query using postgres 8.4 Kevin Grittner 13:06
Re: Poor performance using CTE Merlin Moncure 15:04
Re: Poor performance using CTE Claudio Freire 15:10

Browse Archives

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