Skip site navigation (1) Skip section navigation (2)

Peripheral Links

Text Size: Normal / Large
Donate
Contact

PostgreSQL

The world's most advanced open source database.

pgsql-performance - February 2005

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

2005-02-01

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)

2005-02-02

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)

2005-02-03

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)

2005-02-04

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)

2005-02-05

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)

2005-02-06

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)

2005-02-07

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)

2005-02-08

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)

2005-02-09

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)

2005-02-10

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)

2005-02-11

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)

2005-02-13

Re: Benchmark Christopher Browne (01:34)
Re: Benchmark Ron Mayer (09:21)

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

Privacy Policy | About PostgreSQL
Copyright © 1996-2013 The PostgreSQL Global Development Group