pgsql-performance since 2005-12-09 00:00

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

Dec. 9, 2005

Thread Author Time
Query not using index Kaloyan Iliev 09:36
Re: opinion on disk speed Jeremy Haile 14:15
Re: Query not using index Jaime Casanova 15:06
Re: Joining 2 tables with 300 million rows Jeff Trout 15:32
Re: opinion on disk speed Frank Wiles 15:47
Re: opinion on disk speed Andreas Pflug 15:50
Re: opinion on disk speed Frank Wiles 15:50
Re: opinion on disk speed Frank Wiles 15:58
Re: Query not using index Kaloyan Iliev 16:38
Re: Query not using index Kaloyan Iliev 16:39

Dec. 10, 2005

Thread Author Time
Is RAID10 the best choice? Carlos Benkendorf 11:34
Clustered tables and seqscan disabled Henrique Engelmann 15:29
Executing a shell command from a PG function 📎 Yves Vindevogel 15:55
Re: Executing a shell command from a PG function Jaime Casanova 16:14
Re: Executing a shell command from a PG function Michael Fuhr 16:22
Re: Executing a shell command from a PG function 📎 Yves Vindevogel 16:53
Re: Clustered tables and seqscan disabled Tom Lane 16:53
Bitmasks Ivan Voras 17:12
Re: Queries taking ages in PG 8.1, have been much faster in PG<=8.0 Manfred Koizar 17:14

Dec. 11, 2005

Thread Author Time
Re: Bitmasks Greg Stark 06:12
How much expensive are row level statistics? Carlos Benkendorf 11:53
Re: How much expensive are row level statistics? Michael Fuhr 19:44
Re: Join the same row Tom Lane 20:36
Re: Should Oracle outperform PostgreSQL on a complex multidimensional query? Tom Lane 20:38
Re: Should Oracle outperform PostgreSQL on a complex Luke Lonergan 21:15

Dec. 12, 2005

Thread Author Time
Table Partitions / Partial Indexes Mike C 02:07
Re: Table Partitions / Partial Indexes Tom Lane 02:39
Re: Table Partitions / Partial Indexes Mike C 02:49
Re: Is RAID10 the best choice? Alex Turner 04:45
7.4.7 vs. 8.1 Szabolcs BALLA 08:54
2 phase commit: performance implications? Andy Ballingall 09:13
Re: 7.4.7 vs. 8.1 Steinar H. Gunderson 12:04
Re: How much expensive are row level statistics? Alvaro Herrera 13:23
Re: Very slow queries - please help Bealach-na Bo 16:24
Re: Should Oracle outperform PostgreSQL on a complex Luke Lonergan 18:30
Re: How much expensive are row level statistics? Merlin Moncure 18:33
Re: opinion on disk speed Vivek Khera 18:42
Re: How much expensive are row level statistics? Michael Fuhr 18:50
Re: Memory Leakage Problem Will Glynn 20:19
Re: How much expensive are row level statistics? Michael Fuhr 20:37
Re: Memory Leakage Problem Mike Rylander 20:48
Re: opinion on disk speed Vivek Khera 21:59
Re: opinion on disk speed J. Andrew Rogers 22:16
Re: opinion on disk speed Vivek Khera 22:19
Re: Small table or partial index? Jim C. Nasby 22:24
Re: Joining 2 tables with 300 million rows Manfred Koizar 22:34
Re: How much expensive are row level statistics? Tom Lane 23:01
Re: opinion on disk speed Scott Marlowe 23:12
Re: opinion on disk speed J. Andrew Rogers 23:17

Dec. 13, 2005

Thread Author Time
Re: How much expensive are row level statistics? Michael Fuhr 01:07
Re: How much expensive are row level statistics? Tom Lane 03:20
Re: Memory Leakage Problem Tom Lane 04:17
Re: Memory Leakage Problem Joshua D. Drake 04:31
Re: Memory Leakage Problem John Sidney-Woollett 07:42
Re: Memory Leakage Problem Tom Lane 07:47
Re: Memory Leakage Problem John Sidney-Woollett 08:05
partitioning 📎 Marc Cousin 08:20
Re: Memory Leakage Problem Jim C. Nasby 08:22
Re: partitioning Pandurangan R S 11:40
Re: partitioning Pandurangan R S 11:50
Re: partitioning Marc Cousin 13:11
Re: Memory Leakage Problem Tom Lane 15:13
query from partitions Ключников А.С. 15:18
Re: query from partitions Richard Huxton 15:59
Re: query from partitions Steinar H. Gunderson 16:08
Re: Small table or partial index? Francisco Reyes 16:08
Re: Memory Leakage Problem John Sidney-Woollett 16:37
Re: query from partitions Ключников А.С. 16:57
Lots of postmaster processes (fwd) Ameet Kini 17:25
Re: Memory Leakage Problem Scott Marlowe 17:40
Re: Memory Leakage Problem Tom Lane 17:58
Re: query from partitions Simon Riggs 22:48
Re: Table Partitions / Partial Indexes Simon Riggs 23:17
Re: Should Oracle outperform PostgreSQL on a complex Tomeh, Husam 23:18
Re: Should Oracle outperform PostgreSQL on a complex Simon Riggs 23:28
Re: Table Partitions / Partial Indexes Mike C 23:54

Dec. 14, 2005

Thread Author Time
Re: Should Oracle outperform PostgreSQL on a complex Luke Lonergan 01:54
SAN/NAS options Charles Sprickman 06:43
SAN/NAS options Charles Sprickman 06:56
Re: SAN/NAS options Luke Lonergan 07:10
Re: SAN/NAS options Mark Kirkwood 07:28
Re: Memory Leakage Problem Martijn van Oosterhout 09:21
Convert IN sublink to join francisco.santos 13:27
Re: Memory Leakage Problem John Sidney-Woollett 13:52
Re: Convert IN sublink to join Tom Lane 15:26
Re: SAN/NAS options Andrew Rawnsley 16:53
Re: SAN/NAS options Michael Stone 18:32
effizient query with jdbc 21:28
Auto-tuning a VIEW? Zoltan Boszormenyi 21:30
Re: Auto-tuning a VIEW? PFC 21:38
Simple Join Kevin Brown 22:03
Re: Auto-tuning a VIEW? PFC 22:18
Re: Auto-tuning a VIEW? Zoltan Boszormenyi 22:39
Re: Simple Join Tom Lane 22:47
Re: Simple Join Kevin Brown 23:12
Re: Simple Join Jaime Casanova 23:23
Re: Simple Join Mark Kirkwood 23:30
Re: Simple Join Kevin Brown 23:44
Re: Simple Join Steinar H. Gunderson 23:47
Re: Simple Join Kevin Brown 23:52

Dec. 15, 2005

Thread Author Time
Re: [postgis-users] Is my query planner failing me, or vice versa? Gregory S. Williamson 00:23
Re: Simple Join Mark Kirkwood 00:36
PostgreSQL performance question. Harry Jackson 01:51
Re: PostgreSQL performance question. Christopher Kings-Lynne 02:02
Re: PostgreSQL performance question. Gavin Sherry 02:29
Re: [postgis-users] Is my query planner failing me, or vice versa? Tom Lane 05:36
effizient query with jdbc 06:22
Re: Simple Join Mitchell Skinner 06:52
effizient query with jdbc Johannes Bühler 07:07
Re: Simple Join Kevin Brown 07:46
Re: Simple Join Kevin Brown 07:48
Re: Simple Join Mark Kirkwood 08:15
Re: Simple Join Mitch Skinner 11:02
Re: [postgis-users] Is my query planner failing me, or vice versa? Markus Schaber 11:03
Re: [postgis-users] Is my query planner failing me, or vice versa? Gregory S. Williamson 12:03
Re: [postgis-users] Is my query planner failing me,or vice versa? Mark Cave-Ayland 14:20
effizient query with jdbc johannesbuehler 14:44
Re: Simple Join Mark Kirkwood 19:29
Re: SAN/NAS options Anjan Dave 21:13
Re: SAN/NAS options Luke Lonergan 21:40
Overriding the optimizer Craig A. James 23:06
Re: How much expensive are row level statistics? Michael Fuhr 23:44

Dec. 16, 2005

Thread Author Time
Re: How much expensive are row level statistics? Tom Lane 00:06
Re: Overriding the optimizer Tom Lane 00:23
Re: Overriding the optimizer Christopher Kings-Lynne 01:50
Re: Overriding the optimizer Jaime Casanova 02:00
Re: Overriding the optimizer Christopher Kings-Lynne 02:02
Re: Overriding the optimizer Craig A. James 02:16
Re: Overriding the optimizer Craig A. James 02:18
Re: Overriding the optimizer Craig A. James 02:23
Re: Overriding the optimizer Christopher Kings-Lynne 02:25
Re: Overriding the optimizer Mark Kirkwood 02:31
Re: Overriding the optimizer Christopher Kings-Lynne 02:34
Re: Overriding the optimizer Craig A. James 02:44
Re: Overriding the optimizer Craig A. James 02:52
Re: Overriding the optimizer Craig A. James 03:04
Re: Overriding the optimizer Craig A. James 03:11
Re: Overriding the optimizer Mark Kirkwood 03:16
Re: Overriding the optimizer Christopher Kings-Lynne 03:20
Re: Overriding the optimizer Craig A. James 03:38
Re: Overriding the optimizer Craig A. James 03:57
Re: Overriding the optimizer David Lang 04:02
Re: Simple Join David Lang 04:05
Re: Overriding the optimizer David Lang 04:22
Re: Overriding the optimizer Jaime Casanova 04:23
Re: Overriding the optimizer Jaime Casanova 04:25
Re: Overriding the optimizer Kevin Brown 05:08
Re: Overriding the optimizer Kevin Brown 05:20
Re: Overriding the optimizer Craig A. James 05:41
Re: How much expensive are row level statistics? Kevin Brown 05:44
Re: Overriding the optimizer Kevin Brown 05:48
Re: Overriding the optimizer Bruno Wolff III 05:55
Crashing DB or Server? Moritz Bayer 13:15
Re: How much expensive are row level statistics? Simon Riggs 13:17
Re: Crashing DB or Server? Harry Jackson 13:38
Re: Crashing DB or Server? Moritz Bayer 14:10
Re: Overriding the optimizer Kyle Cordes 14:19
ALTER TABLE SET TABLESPACE and pg_toast PostgreSQL 14:25
Re: Crashing DB or Server? Csaba Nagy 14:32
Re: How much expensive are row level statistics? Merlin Moncure 14:40
Re: Overriding the optimizer Jaime Casanova 14:45
Re: Overriding the optimizer Tomasz Rybak 14:47
Re: ALTER TABLE SET TABLESPACE and pg_toast Tom Lane 15:23
Re: Overriding the optimizer Craig A. James 16:49
Re: Overriding the optimizer Mitch Skinner 19:13
8.1 - pg_autovacuum question Chris Hoover 19:40
Re: 8.1 - pg_autovacuum question Alvaro Herrera 20:26
Re: Simple Join Mark Kirkwood 21:11
Re: Lots of postmaster processes (fwd) Jim C. Nasby 21:56
Re: SAN/NAS options Jim C. Nasby 22:18
Re: SAN/NAS options Jim C. Nasby 22:19
Re: Overriding the optimizer Jim C. Nasby 22:38
Re: Overriding the optimizer Jim C. Nasby 22:41
Re: Overriding the optimizer Jim C. Nasby 22:45
Re: SAN/NAS options Mark Kirkwood 22:49
Re: SAN/NAS options Michael Stone 22:51

Dec. 17, 2005

Thread Author Time
Re: SAN/NAS options Jim C. Nasby 00:25
Re: SAN/NAS options Michael Stone 00:48
Re: Overriding the optimizer Kyle Cordes 01:42
Re: How much expensive are row level statistics? Bruce Momjian 02:44
Re: Should Oracle outperform PostgreSQL on a complex Bruce Momjian 04:28
Re: Should Oracle outperform PostgreSQL on a complex Mark Kirkwood 05:21
Re: Overriding the optimizer Tom Lane 07:28
Re: Overriding the optimizer David Lang 08:40
Re: Should Oracle outperform PostgreSQL on a complex Simon Riggs 09:15
Re: Overriding the optimizer Jaime Casanova 12:31
Re: Simple Join Bruce Momjian 14:56
Re: Should Oracle outperform PostgreSQL on a complex Bruce Momjian 16:43
Re: Should Oracle outperform PostgreSQL on a complex Tom Lane 18:13
Re: Should Oracle outperform PostgreSQL on a complex Tom Lane 18:35
Re: Should Oracle outperform PostgreSQL on a complex Tom Lane 18:47
Re: Should Oracle outperform PostgreSQL on a complex Bruce Momjian 19:03
Re: Should Oracle outperform PostgreSQL on a complex Luke Lonergan 19:05

Dec. 18, 2005

Thread Author Time
Speed of different procedural language Ben Trewern 01:10
Re: Should Oracle outperform PostgreSQL on a complex Mark Kirkwood 02:02
Re: PostgreSQL performance question. Harry Jackson 02:11
Re: PostgreSQL performance question. [OT] Steinar H. Gunderson 02:18
Re: Should Oracle outperform PostgreSQL on a complex Mark Kirkwood 04:07
make bulk deletes faster? James Klo 05:10
Re: Should Oracle outperform PostgreSQL on a complex Greg Stark 06:50

Browse Archives

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