pgsql-performance - February 2005

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 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28

Feb. 1, 2005

Thread Author Time
Very important choice Lago, Bruno Almeida do 01:59
Re: Automagic tuning Jim C. Nasby 04:52
Re: High end server and storage for a PostgreSQL OLTP system Jim C. Nasby 04:56
Re: Automagic tuning Tom Lane 05:06
Re: Index Slowing Insert >50x Tom Lane 05:29
Re: Automagic tuning Jim C. Nasby 06:06
Re: High end server and storage for a PostgreSQL OLTP system Cosimo Streppone 06:26
Re: High end server and storage for a PostgreSQL OLTP system Cosimo Streppone 06:35
Re: Very important choice Richard Huxton 08:50
Re: [SQL] OFFSET impact on Performance??? PFC 09:16
Very important choice Bruno Almeida do Lago 10:02
Re: High end server and storage for a PostgreSQL OLTP system Jim C. Nasby 11:27
Re: [SQL] OFFSET impact on Performance??? Sean Davis 11:38
Performance of count(*) on large tables vs SQL Server Andrew Mayo 12:41
Re: Performance of count(*) on large tables vs SQL Server Shridhar Daithankar 13:02
Re: Performance of count(*) on large tables vs SQL Server Stef 13:22
Re: Performance of count(*) on large tables vs SQL Server PFC 13:36
Re: High end server and storage for a PostgreSQL OLTP system Alex Turner 13:58
Re: High end server and storage for a PostgreSQL OLTP system Merlin Moncure 15:30
Effect of database encoding on performance Igor Postelnik 16:38
Why the difference in query plan and performance pg 7.4.6? Joost Kraaijeveld 18:55
Re: Why the difference in query plan and performance pg John Arbash Meinel 20:06
Re: High end server and storage for a PostgreSQL OLTP system Cosimo Streppone 21:00
Re: Ideal disk setup for Postgresql 7.4? Bruce Momjian 21:11
Re: High end server and storage for a PostgreSQL OLTP system Cosimo Streppone 21:11

Feb. 2, 2005

Thread Author Time
horizontal partition Gaetano Mendola 00:16
Re: High end server and storage for a PostgreSQL OLTP system William Yu 04:25
Re: High end server and storage for a PostgreSQL OLTP system Alex Turner 04:47
Accessing insert values in triggers Hasnul Fadhly bin Hasan 10:02
Re: Swapping on Solaris Bruce Momjian 15:54
Re: Bitmap indexes Bruce Momjian 16:08
Bad query optimizer misestimation because of TOAST tables Markus Schaber 17:21
Re: High end server and storage for a PostgreSQL OLTP system Bruce Momjian 17:37
Re: Bad query optimizer misestimation because of TOAST tables Tom Lane 17:44
Re: High end server and storage for a PostgreSQL OLTP system William Yu 18:18
Re: Bad query optimizer misestimation because of TOAST Markus Schaber 18:25
Re: High end server and storage for a PostgreSQL OLTP system Bruce Momjian 18:35
Re: High end server and storage for a PostgreSQL OLTP system William Yu 18:49
Re: High end server and storage for a PostgreSQL OLTP system Merlin Moncure 18:50
Re: horizontal partition Josh Berkus 20:09
Re: High end server and storage for a PostgreSQL OLTP system Cosimo Streppone 21:10
Re: Bitmap indexes Daniel Ceregatti 23:18
Re: Bad query optimizer misestimation because of TOAST Tom Lane 23:49

Feb. 3, 2005

Thread Author Time
Re: horizontal partition Gaetano Mendola 01:10
Re: horizontal partition Josh Berkus 03:16
Re: horizontal partition Klint Gore 03:31
Re: High end server and storage for a PostgreSQL OLTP system Christopher Browne 03:35
GiST indexes and concurrency (tsearch2) Marinos J. Yannikos 04:55
Re: GiST indexes and concurrency (tsearch2) Tom Lane 05:26
Re: horizontal partition Josh Berkus 06:41
Re: horizontal partition Tom Lane 06:55
Re: [PERFORM] Accessing insert values in triggers Michael Fuhr 08:01
Re: GiST indexes and concurrency (tsearch2) Christopher Kings-Lynne 09:28
Tunning postgresql on linux (fedora core 3) Din Adrian 09:55
Re: GiST indexes and concurrency (tsearch2) Oleg Bartunov 09:57
Re: Bad query optimizer misestimation because of TOAST Markus Schaber 10:30
Re: horizontal partition Gaetano Mendola 10:40
Re: Tunning postgresql on linux (fedora core 3) Richard Huxton 10:54
Re: GiST indexes and concurrency (tsearch2) Marinos J. Yannikos 11:04
Planner really hates nested loops David Brown 11:10
Re: GiST indexes and concurrency (tsearch2) PFC 12:11
Re: GiST indexes and concurrency (tsearch2) Oleg Bartunov 12:16
Re: GiST indexes and concurrency (tsearch2) Marinos J. Yannikos 13:15
Re: Tunning postgresql on linux (fedora core 3) Richard Huxton 13:56
Re: [postgis-users] Bad query optimizer misestimation because of Markus Schaber 13:59
Re: Tunning postgresql on linux (fedora core 3) Richard Huxton 14:52
Re: [PERFORM] Tunning postgresql on linux (fedora core 3) Richard Huxton 15:15
Re: Planner really hates nested loops Tom Lane 16:25
Re: GiST indexes and concurrency (tsearch2) Tom Lane 16:27
Re: Planner really hates nested loops Magnus Hagander 16:41
Re: [PERFORM] Tunning postgresql on linux (fedora core 3) Din Adrian 16:59
Re: Planner really hates nested loops Merlin Moncure 17:10
Re: GiST indexes and concurrency (tsearch2) Marinos J. Yannikos 19:06
Re: GiST indexes and concurrency (tsearch2) Oleg Bartunov 19:50
Re: Planner really hates nested loops David Brown 23:22

Feb. 4, 2005

Thread Author Time
Re: Planner really hates nested loops Bruce Momjian 04:39
Re: Flattening a kind of 'dynamic' table Merlin Moncure 17:48
Postgres odbc performance on windows Sanketh Indarapu 19:29
Re: Flattening a kind of 'dynamic' table Alexandre Leclerc 20:08

Feb. 5, 2005

Thread Author Time
Re: GiST indexes and concurrency (tsearch2) Marinos Yannikos 13:01
query produces 1 GB temp file Dirk Lutzebaeck 17:25
query produces 1 GB temp file Dirk Lutzebaeck 18:21
Re: GiST indexes and concurrency (tsearch2) Tom Lane 19:01
Re: query produces 1 GB temp file John A Meinel 19:26
Re: GiST indexes and concurrency (tsearch2) Tom Lane 19:42
Re: query produces 1 GB temp file Dirk Lutzebaeck 19:46
Re: query produces 1 GB temp file Greg Stark 20:22
Re: query produces 1 GB temp file Tom Lane 22:41
Re: query produces 1 GB temp file Greg Stark 22:50
Re: query produces 1 GB temp file Tom Lane 23:01

Feb. 6, 2005

Thread Author Time
Re: query produces 1 GB temp file Dirk Lutzebaeck 13:27
Re: query produces 1 GB temp file John A Meinel 15:19
Re: horizontal partition Gaetano Mendola 15:50
Re: query produces 1 GB temp file Greg Stark 15:57
Re: query produces 1 GB temp file Dirk Lutzebaeck 16:04
Re: query produces 1 GB temp file Dirk Lutzebaeck 16:12
Re: PostgreSQL clustering VS MySQL clustering Jan Wieck 16:42
Re: query produces 1 GB temp file John A Meinel 16:46
Are JOINs allowed with DELETE FROM Steven Rosenstein 17:16
Re: query produces 1 GB temp file Tom Lane 17:16
Re: query produces 1 GB temp file Dirk Lutzebaeck 17:18
Re: query produces 1 GB temp file Dirk Lutzebaeck 17:26
Re: Are JOINs allowed with DELETE FROM Gaetano Mendola 17:36
Re: Are JOINs allowed with DELETE FROM Michael Fuhr 17:50
Re: Are JOINs allowed with DELETE FROM John Arbash Meinel 17:58
Re: Are JOINs allowed with DELETE FROM Steven Rosenstein 19:33
Re: Are JOINs allowed with DELETE FROM Tom Lane 19:49
Can the V7.3 EXPLAIN ANALYZE be trusted? Steven Rosenstein 19:50
Re: Are JOINs allowed with DELETE FROM Steven Rosenstein 21:57
Re: Can the V7.3 EXPLAIN ANALYZE be trusted? Leeuw van der, Tim 22:09
Re: Can the V7.3 EXPLAIN ANALYZE be trusted? Greg Stark 22:34
Re: Can the V7.3 EXPLAIN ANALYZE be trusted? Tom Lane 22:46
Re: PostgreSQL clustering VS MySQL clustering Jan Wieck 23:06

Feb. 7, 2005

Thread Author Time
Re: Can the V7.3 EXPLAIN ANALYZE be trusted? Steven Rosenstein 02:43
Index not used with or condition Antony Paul 09:07
Re: Index not used with or condition Antony Paul 11:14
Is this possible / slow performance? Joost Kraaijeveld 11:36
Re: Index not used with or condition Steinar H. Gunderson 11:46
Re: Index not used with or condition Jan Poslusny 11:53
Re: Index not used with or condition Antony Paul 11:57
Re: Index not used with or condition Antony Paul 11:58
Re: Bad query optimizer misestimation because of TOAST Markus Schaber 14:07
Re: Can the V7.3 EXPLAIN ANALYZE be trusted? Markus Schaber 14:39
Retry: Is this possible / slow performance? Joost Kraaijeveld 16:37
Re: Retry: Is this possible / slow performance? Tom Lane 17:03
Re: Are JOINs allowed with DELETE FROM Gaetano Mendola 17:22
Re: Retry: Is this possible / slow performance? PFC 18:16
Re: Retry: Is this possible / slow performance? Joost Kraaijeveld 19:27
Re: Retry: Is this possible / slow performance? Merlin Moncure 19:52
Solaris 9 tuning Paul Johnson 22:25

Feb. 8, 2005

Thread Author Time
Re: Solaris 9 tuning Josh Berkus 02:22
Slow Restoration of a template1 Database (ALTER GROUP) Ben Young 18:23
Re: Slow Restoration of a template1 Database (ALTER GROUP) Tom Lane 18:57
Re: Slow Restoration of a template1 Database (ALTER GROUP) Tom Lane 19:59
Re: Slow Restoration of a template1 Database (ALTER GROUP) Ben Young 20:08
Re: Slow Restoration of a template1 Database (ALTER GROUP) Tom Lane 20:32

Feb. 9, 2005

Thread Author Time
Re: query produces 1 GB temp file Christopher Kings-Lynne 09:14
How can I make use of both CPUs in a dual processor machine Alex 14:26
Re: How can I make use of both CPUs in a dual processor John A Meinel 14:49
Re: How can I make use of both CPUs in a dual processor Alex 15:00
Re: How can I make use of both CPUs in a dual processor Merlin Moncure 15:14
Re: How can I make use of both CPUs in a dual processor John A Meinel 15:16
Tell postgres which index to use? Silke Trissl 15:58
Re: Tell postgres which index to use? Josh Berkus 17:41
Re: Tell postgres which index to use? Silke Trissl 17:58
Re: Tell postgres which index to use? John Arbash Meinel 18:36
Re: Solaris 9 tuning Paul Johnson 19:02
Re: Solaris 9 tuning Tom Arthurs 19:23
Re: GiST indexes and concurrency (tsearch2) Marinos J. Yannikos 19:25
Re: Solaris 9 tuning Tom Arthurs 19:31
Performance Tuning Chris Kratz 20:01
Re: Performance Tuning Rod Taylor 20:27
Re: Performance Tuning John Arbash Meinel 20:38
Re: Solaris 9 tuning Paul Johnson 20:49
Re: Tell postgres which index to use? Greg Stark 20:50
Re: Performance Tuning Greg Stark 20:59
Re: Performance Tuning Chris Kratz 21:25
annotated PostgreSQL.conf now up Josh Berkus 21:50
Re: Solaris 9 tuning Tom Arthurs 22:08
Re: Performance Tuning Merlin Moncure 22:08
Re: Performance Tuning Chris Kratz 22:15
Re: Performance Tuning Chris Kratz 22:17
Re: Performance Tuning Chris Kratz 22:30
Re: annotated PostgreSQL.conf now up Jon Asher 23:18
Re: Performance Tuning PFC 23:58

Feb. 10, 2005

Thread Author Time
Re: GiST indexes and concurrency (tsearch2) Marinos J. Yannikos 00:55
Re: GiST indexes and concurrency (tsearch2) Neil Conway 01:13
Re: Performance Tuning Mike Rylander 01:27
Re: How can I make use of both CPUs in a dual processor Iain 01:50
Re: Performance Tuning Christopher Browne 03:09
Re: Performance Tuning PFC 03:38
Benchmark Jaime Casanova 05:49
Re: How can I make use of both CPUs in a dual processor Alex 13:18
Re: Benchmark Jeff 13:21
Large time difference between explain analyze and normal run Chris Kratz 18:34
Re: Large time difference between explain analyze and normal run Tom Lane 18:58
Re: Large time difference between explain analyze and normal run Chris Kratz 19:05
Re: Large time difference between explain analyze and normal run Darcy Buskermolen 20:09
Re: Large time difference between explain analyze and normal run Chris Kratz 20:25

Feb. 11, 2005

Thread Author Time
Re: Benchmark Mitch Pirtle 05:22
Re: Benchmark Tom Lane 06:38
Re: Benchmark Mitch Pirtle 07:04
Re: Benchmark Jaime Casanova 07:22
How to interpret this explain analyse? Joost Kraaijeveld 09:18
Re: How to interpret this explain analyse? Richard Huxton 10:20
Re: Benchmark Bruno Wolff III 13:08
Re: Benchmark Richard Huxton 13:16
Re: Benchmark Jeff 13:20
Re: Benchmark Greg Stark 15:04
Re: How to interpret this explain analyse? Tom Lane 16:18
Re: Benchmark Mike Benoit 18:09
Re: Benchmark (slightly off topic but oh well) PFC 18:22
Re: Benchmark PFC 18:32
Re: Benchmark Tom Lane 18:41
Re: How to interpret this explain analyse? Joost Kraaijeveld 19:25
Re: How to interpret this explain analyse? Tom Lane 19:40
Re: Benchmark Merlin Moncure 20:41
Re: How to interpret this explain analyse? Joost Kraaijeveld 23:12

Feb. 13, 2005

Thread Author Time
Re: Benchmark Christopher Browne 01:34
Re: Benchmark Ron Mayer 09:21

Browse Archives

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