pgsql-performance since 2008-01-20 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

Jan. 20, 2008

Thread Author Time
Slow set-returning functions Dean Rasheed 11:40
Re: Slow set-returning functions Heikki Linnakangas 14:34
Re: Slow set-returning functions Merlin Moncure 15:25
Re: Slow set-returning functions Dean Rasheed 17:32
Re: Slow set-returning functions Tom Lane 18:30

Jan. 21, 2008

Thread Author Time
Re: strange pauses Adrian Moisey 07:58
Slow performance with left outer join Marten Verhoeven 15:00
Re: Slow performance with left outer join Pavel Stehule 15:17
Re: Slow performance with left outer join Tom Lane 16:55
Re: Slow performance with left outer join Pavel Stehule 18:04
Re: strange pauses Decibel! 19:29
8.3 synchronous_commit Hannes Dorbath 21:55
Re: 8.3 synchronous_commit Pavel Stehule 22:11
Re: 8.3 synchronous_commit Jeff Davis 22:25
Re: 8.3 synchronous_commit Greg Smith 23:31
Re: 8.3 synchronous_commit Jeff Davis 23:45

Jan. 22, 2008

Thread Author Time
Re: 8.3 synchronous_commit Greg Smith 00:26
Re: 8.3 synchronous_commit Fernando Ike 00:48
scheduler Adrian Moisey 07:00
Re: scheduler Claus Guttesen 08:10
Re: scheduler Adrian Moisey 08:27
Re: 8.3 synchronous_commit Florian Weimer 08:32
Re: scheduler david 08:37
Re: scheduler Luke Lonergan 08:45
Re: 8.3 synchronous_commit Guillaume Smet 08:49
Re: 8.3 synchronous_commit Florian Weimer 08:56
Re: 8.3 synchronous_commit Hannes Dorbath 11:56
Re: 8.3 synchronous_commit Hannes Dorbath 12:13
Optimizing queries that use temporary tables Luiz K. Matsumura 19:32
Re: SELECT * FROM table is too slow Luiz K. Matsumura 19:44
Re: SELECT * FROM table is too slow Joshua D. Drake 20:19
Re: Optimizing queries that use temporary tables Scott Marlowe 20:34

Jan. 23, 2008

Thread Author Time
Workaround for cross column stats dependency Guillaume Smet 00:57
Re: Workaround for cross column stats dependency Tom Lane 01:43
Re: Workaround for cross column stats dependency Guillaume Smet 02:02
Making the most of memory? Joshua Fielek 04:11
Re: Making the most of memory? Scott Marlowe 05:20
Re: SELECT * FROM table is too slow Guillaume Cottenceau 08:47
Re: Workaround for cross column stats dependency Guillaume Smet 09:05
*_cost recommendation with 8.3 and a fully cached db Guillaume Smet 12:36
planner chooses unoptimal plan on joins with complex key Dmitry Potapov 13:48
Re: planner chooses unoptimal plan on joins with complex key Guillaume Smet 13:58
Re: Making the most of memory? Bill Moran 14:59
Re: planner chooses unoptimal plan on joins with complex key Tom Lane 17:17
Postgres 8.2 memory weirdness Tory M Blue 18:23
Vacuum and FSM page size Thomas Lozza 18:29
Re: Making the most of memory? Scott Marlowe 18:44
Re: Vacuum and FSM page size Decibel! 19:02
Re: Making the most of memory? Rich 19:06
Re: Vacuum and FSM page size Vivek Khera 19:22
Re: Making the most of memory? Guy Rouillier 19:57
Re: Vacuum and FSM page size Tom Lane 20:25
Re: Making the most of memory? A.M. 20:40
Re: Making the most of memory? Brian Hurt 20:50
Re: Making the most of memory? Craig James 21:06

Jan. 24, 2008

Thread Author Time
Re: Postgres 8.2 memory weirdness Greg Smith 00:31
Re: Making the most of memory? Greg Smith 00:54
Re: Making the most of memory? Scott Marlowe 01:45
Re: Making the most of memory? Steinar H. Gunderson 08:05
Re: Making the most of memory? Heikki Linnakangas 09:19
Re: Making the most of memory? Merlin Moncure 14:01
Re: Making the most of memory? Matthew 14:15
Re: Making the most of memory? Florian Weimer 14:26
Re: Vacuum and FSM page size Scott Marlowe 15:48
Re: Making the most of memory? Chris Browne 16:09
Re: Making the most of memory? Chris Browne 16:23
Re: Postgres 8.2 memory weirdness Tory M Blue 17:46
Configuration settings (shared_buffers, etc) in Linux: puzzled Rick Schumeyer 18:00
Re: Making the most of memory? Merlin Moncure 18:01
Re: Making the most of memory? Merlin Moncure 18:21
Re: Postgres 8.2 memory weirdness Greg Smith 18:49
Re: Configuration settings (shared_buffers, etc) in Linux: puzzled Greg Smith 18:52
8.3rc1 Out of memory when performing update Stephen Denne 23:46

Jan. 25, 2008

Thread Author Time
Re: 8.3rc1 Out of memory when performing update Fernando Ike 01:14
Re: Configuration settings (shared_buffers, etc) in Linux: puzzled Fernando Ike 01:53
Re: planner chooses unoptimal plan on joins with complex key Tom Lane 02:27
Re: 8.3rc1 Out of memory when performing update Tom Lane 02:31
Re: 8.3rc1 Out of memory when performing update Stephen Denne 03:20
Re: 8.3rc1 Out of memory when performing update 📎 Tom Lane 04:50
Re: Making the most of memory? Florian Weimer 08:18
Re: 8.3rc1 Out of memory when performing update Stephen Denne 10:14
1 or 2 servers for large DB scenario. David Brain 16:36
Re: 1 or 2 servers for large DB scenario. Greg Smith 16:55
Re: 1 or 2 servers for large DB scenario. Matthew 16:56
Re: 1 or 2 servers for large DB scenario. Matthew 17:00
Re: Postgres 8.2 memory weirdness Tory M Blue 17:36
Re: 8.3rc1 Out of memory when performing update cgallant 18:32
Re: 8.3rc1 Out of memory when performing update Roberts, Jon 18:36
Re: 8.3rc1 Out of memory when performing update Magnus Hagander 18:45
How do I bulk insert to a table without affecting read performance on that table? growse 23:27
Re: Linux/PostgreSQL scalability issue - problem with 8 cores Simon Riggs 23:27

Jan. 26, 2008

Thread Author Time
Re: How do I bulk insert to a table without affecting read performance on that table? Scott Marlowe 02:06
Re: How do I bulk insert to a table without affecting read performance on that table? growse 11:42
Re: How do I bulk insert to a table without affecting read performance on that table? Scott Marlowe 13:39

Jan. 27, 2008

Thread Author Time
Re: 1 or 2 servers for large DB scenario. Heikki Linnakangas 10:47
Re: Slow set-returning functions Dean Rasheed 17:29
Re: Slow set-returning functions Marcin Stępnicki 19:16
Re: 8.3rc1 Out of memory when performing update Stephen Denne 21:55
Re: Slow set-returning functions Merlin Moncure 23:01
Re: Vacuum and FSM page size Thomas Lozza 23:01
Re: Vacuum and FSM page size Scott Marlowe 23:54

Jan. 28, 2008

Thread Author Time
Re: Postgres 8.2 memory weirdness Greg Smith 00:08
Re: 1 or 2 servers for large DB scenario. Jignesh K. Shah 00:53
Re: 8.3rc1 Out of memory when performing update Tom Lane 04:16
Re: 1 or 2 servers for large DB scenario. Merlin Moncure 04:25
Re: 8.3rc1 Out of memory when performing update Stephen Denne 05:04
Re: Postgres 8.2 memory weirdness Tory M Blue 06:09
Re: 8.3rc1 Out of memory when performing update Guillaume Smet 08:18
Performance issues migrating from 743 to 826 Matthew Lunnon 11:41
Performance problems inside a stored procedure. Matthew Lunnon 12:02
Re: Performance problems inside a stored procedure. Heikki Linnakangas 12:06
Re: Performance problems inside a stored procedure. Matthew Lunnon 12:10
Re: Slow set-returning functions Dean Rasheed 12:38
Re: Performance issues migrating from 743 to 826 Gregory Stark 12:41
Hard Drive Usage for Speeding up Big Queries Alex Hochberger 13:54
Re: Linux/PostgreSQL scalability issue - problem with 8 cores Matthew 14:27
Re: Performance issues migrating from 743 to 826 Scott Marlowe 15:14
Re: Hard Drive Usage for Speeding up Big Queries Scott Marlowe 15:19
Re: Performance issues migrating from 743 to 826 Matthew Lunnon 15:27
Re: Performance issues migrating from 743 to 826 Scott Marlowe 15:39
Re: Performance issues migrating from 743 to 826 Matthew Lunnon 15:49
Re: Performance issues migrating from 743 to 826 Matthew Lunnon 15:54
JDBC/Stored procedure performance issue Claire McLister 17:59
8x2.5" or 6x3.5" disks Christian Nicolaisen 19:25
Re: 8x2.5" or 6x3.5" disks Arjen van der Meijden 20:28
Re: JDBC/Stored procedure performance issue Tom Lane 20:51

Jan. 29, 2008

Thread Author Time
Re: Hard Drive Usage for Speeding up Big Queries Merlin Moncure 02:56
Re: 8x2.5" or 6x3.5" disks Claus Guttesen 08:06
Re: 8x2.5" or 6x3.5" disks david 08:32
Re: JDBC/Stored procedure performance issue Matthew Lunnon 10:12
Re: 8x2.5" or 6x3.5" disks Arjen van der Meijden 10:29
Re: 8x2.5" or 6x3.5" disks Mike Smith 11:43
Re: Performance problems inside a stored procedure. Euler Taveira de Oliveira 13:59
analyze Adrian Moisey 14:28
Re: RAID arrays and performance Gregory Stark 14:55
Re: 8x2.5" or 6x3.5" disks Scott Marlowe 15:00
Re: 8x2.5" or 6x3.5" disks Craig James 15:06
Re: RAID arrays and performance Matthew 15:09
Re: planner chooses unoptimal plan on joins with complex key Dmitry Potapov 15:25
Re: RAID arrays and performance Gregory Stark 15:52
Re: RAID arrays and performance Kevin Grittner 16:23
Re: RAID arrays and performance Gregory Stark 16:45
Re: RAID arrays and performance Kevin Grittner 17:13
Re: Performance problems inside a stored procedure. Matthew Lunnon 17:38
Re: JDBC/Stored procedure performance issue Tom Lane 18:08
Re: analyze Andrew Sullivan 18:09
Re: analyze Scott Marlowe 18:36
Re: 8x2.5" or 6x3.5" disks Mike Smith 18:40
Re: planner chooses unoptimal plan on joins with complex key Tom Lane 21:59

Jan. 31, 2008

Thread Author Time
Re: planner chooses unoptimal plan on joins with complex key Dmitry Potapov 11:40
Re: JDBC/Stored procedure performance issue Claire McLister 19:29
Re: How do I bulk insert to a table without affecting read performance on that table? Kevin Grittner 23:06

Feb. 1, 2008

Thread Author Time
Storage space usage Gangadharan S.A. 08:44

Feb. 2, 2008

Thread Author Time
Re: Storage space usage Decibel! 06:37

Feb. 3, 2008

Thread Author Time
slow 8.2.6 with 50 connections Pavel Stehule 16:02
Re: slow 8.2.6 with 50 connections Scott Marlowe 18:58
Re: slow 8.2.6 with 50 connections Pavel Stehule 19:35
Re: slow 8.2.6 with 50 connections Greg Smith 21:17

Feb. 4, 2008

Thread Author Time
Benchmark Data requested Simon Riggs 18:37
Re: Benchmark Data requested Luke Lonergan 18:47
Re: Benchmark Data requested Claus Guttesen 18:50
Re: Benchmark Data requested Simon Riggs 19:07
Re: Benchmark Data requested Greg Smith 20:09
Re: Benchmark Data requested Simon Riggs 20:21
Re: Benchmark Data requested Luke Lonergan 22:32
Re: Benchmark Data requested Jignesh K. Shah 22:33
Re: Benchmark Data requested Luke Lonergan 22:34
Re: Benchmark Data requested Jignesh K. Shah 22:55
Re: Benchmark Data requested Greg Smith 22:56
Re: Benchmark Data requested Greg Smith 23:37

Feb. 5, 2008

Thread Author Time
Re: Benchmark Data requested Gregory Stark 00:10
Re: Benchmark Data requested Gregory Stark 00:17
Re: Benchmark Data requested Jignesh K. Shah 00:49
Re: Benchmark Data requested Jignesh K. Shah 00:57
Re: Benchmark Data requested Simon Riggs 08:45
Re: Benchmark Data requested Simon Riggs 09:08
Re: Performance problems inside a stored procedure. Matthew Lunnon 09:32
Performance issue using Tsearch2 Viviane Lestic 11:47
Re: Performance issue using Tsearch2 Ansgar -59cobalt- Wiechers 13:36
Re: Performance issue using Tsearch2 Guillaume Smet 13:48
Re: Benchmark Data requested Dimitri Fontaine 14:06
Re: Benchmark Data requested Simon Riggs 14:24
Re: Benchmark Data requested Matthew 14:29
Re: Benchmark Data requested Richard Huxton 14:43
Re: Benchmark Data requested Matthew 14:51
Re: Benchmark Data requested Matthew 14:53
Re: Benchmark Data requested Simon Riggs 14:54
Re: Benchmark Data requested Richard Huxton 15:05
Re: Performance issue using Tsearch2 Viviane Lestic 15:08
Re: Benchmark Data requested Matthew 15:25
Re: Benchmark Data requested Simon Riggs 15:26
Re: Benchmark Data requested Richard Huxton 15:52
Re: Benchmark Data requested Matthew 15:57
Re: Benchmark Data requested Richard Huxton 15:59
Re: Benchmark Data requested Richard Huxton 16:09
Re: Benchmark Data requested Jignesh K. Shah 16:14
Re: Benchmark Data requested Matthew 16:18
Re: Benchmark Data requested Dimitri Fontaine 17:01
Re: Benchmark Data requested Dimitri Fontaine 17:15
Re: Benchmark Data requested Simon Riggs 17:32

Browse Archives

Prev | Next