pgsql-performance - August 2004

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 28 29 30 31

Aug. 1, 2004

Thread Author Time
SSD Drives Greg Stark 11:42
Re: my boss want to migrate to ORACLE Mischa Sandberg 19:13

Aug. 2, 2004

Thread Author Time
Page Miss Hits Ioannis Theoharis 08:11
No index usage with "left join" mailing 12:08
Re: No index usage with "left join" Leeuw van der, Tim 12:16
What kind of performace can I expect and how to measure? Joost Kraaijeveld 12:21
Re: What kind of performace can I expect and how to measure? Merlin Moncure 12:33
Re: No index usage with G u i d o B a r o s i o 12:38
Re: No index usage with "left join" Rod Taylor 12:45
Re: No index usage with Bruce Momjian 12:47
Re: What kind of performace can I expect and how to measure? Joost Kraaijeveld 12:47
Re: No index usage with "left join" Tom Lane 14:03
Re: What kind of performace can I expect and how to measure? Merlin Moncure 14:14
Re: SSD Drives jason.servetar 15:02
Re: No index usage with "left join" Scott Marlowe 16:08
Re: What kind of performace can I expect and how to Scott Marlowe 16:11
Re: Page Miss Hits Scott Marlowe 16:19
Re: Page Miss Hits Gaetano Mendola 16:43
Re: Page Miss Hits Gaetano Mendola 20:50
Re: my boss want to migrate to ORACLE Stephane Tessier 21:18
Re: Page Miss Hits Rod Taylor 21:26
Re: my boss want to migrate to ORACLE Stephane Tessier 21:30
Re: my boss want to migrate to ORACLE James Thornton 21:32
Re: Page Miss Hits Gaetano Mendola 22:13
Re: my boss want to migrate to ORACLE markir 22:47

Aug. 3, 2004

Thread Author Time
Re: my boss want to migrate to ORACLE Scott Marlowe 00:17
NOT IN query takes forever Marius Andreiana 08:49
pg_autovacuum parameters Lending, Rune 09:09
Re: NOT IN query takes forever Merlin Moncure 12:05
Re: NOT IN query takes forever Stephan Szabo 14:03
Re: pg_autovacuum parameters Matthew T. O'Connor 14:19
Re: NOT IN query takes forever Tom Lane 14:59
Re: pg_autovacuum parameters Gaetano Mendola 15:54
Re: NOT IN query takes forever Marius Andreiana 16:02
Re: NOT IN query takes forever Merlin Moncure 16:10
Re: NOT IN query takes forever Gaetano Mendola 17:28
Performance Bottleneck Martin Foster 18:05
Re: NOT IN query takes forever Scott Marlowe 18:26
Re: Performance Bottleneck Dennis Bjorklund 18:35
Re: Performance Bottleneck Gaetano Mendola 18:41
Re: Performance Bottleneck 📎 Joshua D. Drake 18:52

Aug. 4, 2004

Thread Author Time
Re: NOT IN query takes forever Christopher Kings-Lynne 01:32
Re: Performance Bottleneck 📎 Martin Foster 03:49
Re: [PERFORM] NOT IN query takes forever Marius Andreiana 05:40
Re: Performance Bottleneck Pierre-Frédéric Caillaud 06:40
How to know which queries are to be optimised? Ulrich Wisser 12:00
Tuning queries on large database Valerie Schneider DSI/DEV 12:44
The black art of postgresql.conf tweaking Paul Serby 12:45
Re: The black art of postgresql.conf tweaking Jeff 13:02
Re: The black art of postgresql.conf tweaking Michal Taborsky 13:10
Re: [PERFORM] Tuning queries on large database Christopher Kings-Lynne 13:21
Re: The black art of postgresql.conf tweaking Janning Vygen 13:26
Re: Tuning queries on large database Rod Taylor 13:26
Re: The black art of postgresql.conf tweaking Paul Thomas 13:44
Re: Tuning queries on large database Valerie Schneider DSI/DEV 14:12
Re: The black art of postgresql.conf tweaking Thomas Swan 14:51
Re: Performance Bottleneck Gaetano Mendola 15:25
Re: The black art of postgresql.conf tweaking Gaetano Mendola 15:29
Re: Tuning queries on large database Gaetano Mendola 15:34
Re: Performance Bottleneck Michael Adler 15:36
Re: Tuning queries on large database Pierre-Frédéric Caillaud 15:50
Re: Tuning queries on large database Pierre-Frédéric Caillaud 15:53
FW: Tuning queries on large database Merlin Moncure 15:56
Re: Performance Bottleneck Martin Foster 16:21
Re: Performance Bottleneck Martin Foster 16:36

Aug. 5, 2004

Thread Author Time
Re: Performance Bottleneck Pierre-Frédéric Caillaud 06:40
pg_dump performance? Jesper Krogh 07:08
Re: [GENERAL] Tuning queries on large database Valerie Schneider DSI/DEV 08:16
Re: [GENERAL] Tuning queries on large database Gaetano Mendola 09:53
Re: [GENERAL] Tuning queries on large database Mark Kirkwood 10:09
Re: [GENERAL] Tuning queries on large database Gaetano Mendola 13:07
Re: [GENERAL] Tuning queries on large database Rod Taylor 13:18
Re: [GENERAL] Tuning queries on large database Merlin Moncure 13:20
Re: [GENERAL] Tuning queries on large database Merlin Moncure 13:26
Temporary tables G u i d o B a r o s i o 14:33
Re: Performance Bottleneck Steinar H. Gunderson 15:04
Re: Temporary tables Gaetano Mendola 15:37
Re: Temporary tables Gaetano Mendola 15:41
performance with column orders Jim Thomason 18:10

Aug. 6, 2004

Thread Author Time
Re: pg_dump performance? Christopher Kings-Lynne 04:46
Re: pg_dump performance? Jesper Krogh 05:05
Re: The black art of postgresql.conf tweaking Josh Berkus 16:29
Re: Performance Bottleneck Mike Benoit 17:06
Re: The black art of postgresql.conf tweaking Gaetano Mendola 18:27
Re: Performance Bottleneck Martin Foster 22:58
Re: The black art of postgresql.conf tweaking Josh Berkus 23:18
Re: Performance Bottleneck Martin Foster 23:18
Re: Performance Bottleneck Gaetano Mendola 23:24
Re: The black art of postgresql.conf tweaking Gaetano Mendola 23:41

Aug. 7, 2004

Thread Author Time
Re: Performance Bottleneck Tom Lane 00:00
Question about Generating Possible Plans by the planner/optimizer sandra ruiz 00:28
Re: Performance Bottleneck Scott Marlowe 00:56
Re: Question about Generating Possible Plans by the planner/optimizer Steinar H. Gunderson 01:11
Re: Performance Bottleneck Martin Foster 04:02
Re: Performance Bottleneck Scott Marlowe 04:36
Re: Performance Bottleneck Martin Foster 04:39
Re: Performance Bottleneck Gaetano Mendola 10:03
Re: Performance Bottleneck Gaetano Mendola 10:11
Re: Performance Bottleneck Christopher Kings-Lynne 10:49
Re: Performance Bottleneck Jan Wieck 14:21

Aug. 8, 2004

Thread Author Time
Re: Performance Bottleneck Martin Foster 05:14
Re: Performance Bottleneck Martin Foster 05:29
Re: Performance Bottleneck Mike Benoit 08:21
Re: Performance Bottleneck Jeff 12:10
Re: Performance Bottleneck Jan Wieck 13:52
Re: Performance Bottleneck Matt Clark 14:29
Re: Performance Bottleneck Martin Foster 15:49
Re: Performance Bottleneck Arjen van der Meijden 16:02
Re: Performance Bottleneck Martin Foster 18:18

Aug. 9, 2004

Thread Author Time
Re: Performance Bottleneck Tatsuo Ishii 01:09
Re: Performance Bottleneck Tatsuo Ishii 01:12
Re: The black art of postgresql.conf tweaking CoL 11:16
Re: The black art of postgresql.conf tweaking Paul Serby 14:28
Re: The black art of postgresql.conf tweaking Shridhar Daithankar 14:46
tablespaces and ramdisks Merlin Moncure 15:29
Re: tablespaces and ramdisks Tom Lane 16:35
Slow select, insert, update Paul Langard 16:54
Help specifying new machine Rory Campbell-Lange 16:56
Re: Help specifying new machine Bill Montgomery 20:08

Aug. 10, 2004

Thread Author Time
insert waits for delete with trigger Litao Wu 00:05
Re: insert waits for delete with trigger Tom Lane 00:31
Re: insert waits for delete with trigger Litao Wu 04:35
Re: insert waits for delete with trigger Tom Lane 04:41
Column order performance Bill Montgomery 13:39
Re: Performance Bottleneck Alex Hayward 14:35
Re: insert waits for delete with trigger Litao Wu 14:48
Re: [HACKERS] fsync vs open_sync Merlin Moncure 15:25
Re: [HACKERS] fsync vs open_sync pgsql 15:54
Re: insert waits for delete with trigger Tom Lane 16:53
Re: [HACKERS] fsync vs open_sync Josh Berkus 17:18
Re: Column order performance Josh Berkus 17:23
Re: [HACKERS] fsync vs open_sync pgsql 18:04
Re: Slow select, insert, update Tom Lane 18:18
Re: Column order performance Bill Montgomery 18:49
Re: Slow select, insert, update Bill Montgomery 18:56
Hardware upgrade for a high-traffic database Jason Coene 19:17
Re: Performance Bottleneck matt 20:04
Re: Slow select, insert, update Doug McNaught 20:48
Re: Slow select, insert, update Litao Wu 21:44
Bulk Insert and Index use Rudi Starcevic 23:04
Re: Hardware upgrade for a high-traffic database Rod Taylor 23:06

Aug. 11, 2004

Thread Author Time
Re: Hardware upgrade for a high-traffic database Scott Marlowe 00:00
Re: Hardware upgrade for a high-traffic database Jason Coene 01:06
Re: Bulk Insert and Index use Christopher Browne 02:24
Re: Bulk Insert and Index use Gregory S. Williamson 02:27
Re: Bulk Insert and Index use Jim J 02:31
Re: Bulk Insert and Index use Rudi Starcevic 03:33
Re: Bulk Insert and Index use Gregory S. Williamson 03:53
Re: Bulk Insert and Index use Rudi Starcevic 04:10
NUMERIC x VARCHAR 📎 Er Galvão Abbott 05:42
Re: NUMERIC x VARCHAR Scott Marlowe 06:21
Re: Hardware upgrade for a high-traffic database Pierre-Frédéric Caillaud 06:43
Re: NUMERIC x VARCHAR Pierre-Frédéric Caillaud 06:47
Re: NUMERIC x VARCHAR 📎 Er Galvão Abbott 07:27
Re: NUMERIC x VARCHAR Michael Glaesemann 07:41
Re: Hardware upgrade for a high-traffic database Merlin Moncure 12:21
Storing binary data. Jesper Krogh 14:29
Re: Storing binary data. Shridhar Daithankar 15:12
Re: Hardware upgrade for a high-traffic database Sanjay Arora 15:47
Re: Storing binary data. Tom Lane 16:06
Re: How to know which queries are to be optimised? Bruno Wolff III 16:27
Re: Storing binary data. Jesper Krogh 16:29
Re: fsync vs open_sync Merlin Moncure 16:37
Re: Hardware upgrade for a high-traffic database Merlin Moncure 17:04
Re: NUMERIC x VARCHAR 📎 Er Galvão Abbott 17:13
Re: fsync vs open_sync pgsql 17:14
My admin left the job and I am stuck Karam Chand 18:41
Re: Hardware upgrade for a high-traffic database Jason Coene 19:08
Re: NUMERIC x VARCHAR Jan Wieck 19:19
Re: Hardware upgrade for a high-traffic database Brian Hirt 19:39
Re: Hardware upgrade for a high-traffic database Merlin Moncure 19:49
Re: [HACKERS] fsync vs open_sync Steve Bergman 20:51
Re: Hardware upgrade for a high-traffic database Jason Coene 21:18
Re: Hardware upgrade for a high-traffic database Brian Hirt 21:31
Re: Hardware upgrade for a high-traffic database Rod Taylor 21:46
Re: Hardware upgrade for a high-traffic database Rod Taylor 21:50
Re: Hardware upgrade for a high-traffic database Jason Coene 22:03
Re: Hardware upgrade for a high-traffic database Rod Taylor 22:26
Re: Hardware upgrade for a high-traffic database Jason Coene 22:53
Re: Hardware upgrade for a high-traffic database Tom Lane 23:20
Re: Storing binary data. Russell Smith 23:44
Re: Hardware upgrade for a high-traffic database Russell Smith 23:52

Aug. 12, 2004

Thread Author Time
Buld Insert and Index use. Rudi Starcevic 00:00
Re: [HACKERS] fsync vs open_sync Gaetano Mendola 00:06
Re: Buld Insert and Index use. Josh Berkus 00:25
Re: Hardware upgrade for a high-traffic database Jason Coene 00:29
Re: Hardware upgrade for a high-traffic database Tom Lane 02:09
Re: Hardware upgrade for a high-traffic database Pierre-Frédéric Caillaud 06:49
Re: [GENERAL] How to know which queries are to be optimised? Ulrich Wisser 10:37
Re: [GENERAL] How to know which queries are to be optimised? Richard Huxton 11:16
Re: Hardware upgrade for a high-traffic database Merlin Moncure 13:39
Re: [GENERAL] How to know which queries are to be optimised? Christopher Kings-Lynne 14:07
Re: [GENERAL] How to know which queries are to be optimised? Christopher Kings-Lynne 14:09
Re: Hardware upgrade for a high-traffic database Merlin Moncure 16:58
Re: Hardware upgrade for a high-traffic database Tom Lane 17:09
Re: Hardware upgrade for a high-traffic database Merlin Moncure 17:48
Re: My admin left the job and I am stuck Laura Vance 18:02
Re: Hardware upgrade for a high-traffic database gnari 18:59
Re: Hardware upgrade for a high-traffic database Merlin Moncure 19:27
Performance Problem With Postgresql! Arash Zaryoun 20:09

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 28 29 30 31