pgsql-performance since 2004-08-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

Aug. 20, 2004

Thread Author Time
Re: using an index worst performances Christopher Kings-Lynne 01:39
Re: using an index worst performances Gaetano Mendola 09:37
Re: using an index worst performances Rod Taylor 12:55
pg_restore very slow in 8.0.0beta1 Bonnin S. 12:59
Re: I could not get postgres to utilizy indexes Manfred Koizar 13:37
Re: I could not get postgres to utilizy indexes Leeuw van der, Tim 13:45
Re: using an index worst performances Gaetano Mendola 15:52
Re: using an index worst performances Tom Lane 16:19
Query performance problem Danilo Mota 16:25
Re: Query performance problem Tom Lane 16:34
Re: Query performance problem Bruno Wolff III 16:48
Re: Query performance problem Tom Lane 16:50
Re: using an index worst performances Gaetano Mendola 19:43
Re: using an index worst performances Tom Lane 20:04

Aug. 21, 2004

Thread Author Time
Query Performance Danilo Mota 00:03
Re: Query Performance Brad Bulger 01:02

Aug. 22, 2004

Thread Author Time
Re: using an index worst performances Gaetano Mendola 10:08

Aug. 23, 2004

Thread Author Time
postgresql 8.0 beta - fail to collect statsistic my thi ho 14:33
Re: postgresql 8.0 beta - fail to collect statsistic Tom Lane 19:01
Re: postgresql 8.0 beta - fail to collect statsistic Steve Bergman 21:52
Re: postgresql 8.0 beta - fail to collect statsistic Tom Lane 22:30

Aug. 24, 2004

Thread Author Time
How do I see what triggers are called on cascade? andrew 00:02
Re: How do I see what triggers are called on cascade? Tom Lane 02:50
Re: postgresql performance with multimedia my ho 05:08
Query kills machine. 📎 Stef 08:32
Re: Query kills machine. Christopher Kings-Lynne 09:08
Re: postgresql performance with multimedia Jan Wieck 12:00
Re: Query kills machine. Stef 13:30
Re: Query kills machine. Magnus Naeslund(t) 14:08
Re: Query kills machine. Magnus Naeslund(pg) 14:15
Re: Query kills machine. Tom Lane 15:23
[FUN] Performance increase? Gaetano Mendola 16:17
Re: What is the best way to do attribute/values? Josh Berkus 20:30
Re: What is the best way to do attribute/values? Richard Huxton 21:00

Aug. 25, 2004

Thread Author Time
Equivalent praxis to CLUSTERED INDEX? Mischa Sandberg 05:28
Re: postgresql performance with multimedia my ho 06:54
Re: postgresql performance with multimedia Gregory S. Williamson 07:14
Re: What is the best way to do attribute/values? Mark Kirkwood 08:22
Re: postgresql performance with multimedia Jan Wieck 11:03
OT: Network config (WAS: RE: postgresql performance with multimedia) Leeuw van der, Tim 11:26
Re: What is the best way to do attribute/values? Jeff 12:36
Re: What is the best way to do attribute/values? Leeuw van der, Tim 13:05
Re: Query kills machine. Stef 14:30
Optimizer Selecting Incorrect Index David Price 15:07
Re: Optimizer Selecting Incorrect Index Richard Huxton 15:47
Re: What is the best way to do attribute/values? Josh Berkus 16:59
Re: Optimizer Selecting Incorrect Index Tom Lane 19:08
Anyone familiar with Apple Xserve RAID Robert Treat 21:09
Re: Anyone familiar with Apple Xserve RAID Josh Berkus 21:22
TSearch2 and optimisation ... Hervé Piedvache 22:48
Re: Anyone familiar with Apple Xserve RAID Doug McNaught 22:52
Re: Anyone familiar with Apple Xserve RAID Ralf Schramm 22:58
Re: Anyone familiar with Apple Xserve RAID Ralf Schramm 23:03
Re: Anyone familiar with Apple Xserve RAID Josh Berkus 23:49
Re: TSearch2 and optimisation ... Josh Berkus 23:50

Aug. 26, 2004

Thread Author Time
Re: What is the best way to do attribute/values? Simon Riggs 00:38
Re: Equivalent praxis to CLUSTERED INDEX? Christopher Kings-Lynne 01:16
Re: What is the best way to do attribute/values? Mark Kirkwood 04:51
Re: Optimizer Selecting Incorrect Index Dennis Bjorklund 06:15
Re: TSearch2 and optimisation ... Hervé Piedvache 07:22
Re: Optimizer Selecting Incorrect Index Richard Huxton 10:17
Re: Optimizer Selecting Incorrect Index David Price 11:05
Re: Anyone familiar with Apple Xserve RAID Andrew Rawnsley 12:07
Query performance problem in 8.0.0beta1 Stefano Bonnin 13:36
Re: Anyone familiar with Apple Xserve RAID Tore Halset 15:13
Re: Anyone familiar with Apple Xserve RAID Andrew Rawnsley 17:40
Re: TSearch2 and optimisation ... Josh Berkus 17:48
Re: TSearch2 and optimisation ... George Essig 17:58
Disabling transaction/outdated-tuple behaviour Neil Cooper 18:02
Re: Equivalent praxis to CLUSTERED INDEX? J. Andrew Rogers 18:14
Re: Disabling transaction/outdated-tuple behaviour Matt Clark 18:18
Re: Equivalent praxis to CLUSTERED INDEX? Bruce Momjian 18:18
Re: Disabling transaction/outdated-tuple behaviour Josh Berkus 18:20
Re: Equivalent praxis to CLUSTERED INDEX? Josh Berkus 18:32
Re: Equivalent praxis to CLUSTERED INDEX? J. Andrew Rogers 19:04
Re: Anyone familiar with Apple Xserve RAID Kevin Barnard 19:06
Re: Equivalent praxis to CLUSTERED INDEX? Magnus Hagander 19:30
Re: TSearch2 and optimisation ... Hervé Piedvache 19:30
Re: Equivalent praxis to CLUSTERED INDEX? Josh Berkus 19:48
Re: Anyone familiar with Apple Xserve RAID Doug McNaught 19:54
Re: Anyone familiar with Apple Xserve RAID Alan Stange 20:01
Re: Anyone familiar with Apple Xserve RAID Andrew Rawnsley 20:12
Re: Equivalent praxis to CLUSTERED INDEX? J. Andrew Rogers 20:44
Re: Equivalent praxis to CLUSTERED INDEX? Mischa Sandberg 21:00
Re: Equivalent praxis to CLUSTERED INDEX? Gaetano Mendola 21:09
Re: Equivalent praxis to CLUSTERED INDEX? Mischa Sandberg 21:41
Re: Equivalent praxis to CLUSTERED INDEX? Mischa Sandberg 21:46
Re: Equivalent praxis to CLUSTERED INDEX? Gregory S. Williamson 22:36

Aug. 27, 2004

Thread Author Time
Re: Equivalent praxis to CLUSTERED INDEX? Bruce Momjian 01:45
Re: Equivalent praxis to CLUSTERED INDEX? Greg Stark 03:39
Re: Equivalent praxis to CLUSTERED INDEX? Bruce Momjian 04:35
Re: postgresql performance with multimedia my ho 06:27
Query performance issue with 8.0.0beta1 Stefano Bonnin 06:57
Re: Equivalent praxis to CLUSTERED INDEX? Gaetano Mendola 08:26
Re: Query performance issue with 8.0.0beta1 Russell Smith 08:48
Re: Equivalent praxis to CLUSTERED INDEX? Bruce Momjian 16:23
Re: Equivalent praxis to CLUSTERED INDEX? Josh Berkus 16:31
Re: Equivalent praxis to CLUSTERED INDEX? Bruce Momjian 16:32
Re: Equivalent praxis to CLUSTERED INDEX? Adi Alurkar 16:51
Re: Query performance issue with 8.0.0beta1 andrew 16:52
Why does a simple query not use an obvious index? Jack Kerkhof 17:12
Re: Query performance issue with 8.0.0beta1 Josh Berkus 17:14
Re: Equivalent praxis to CLUSTERED INDEX? Bruce Momjian 17:27
Re: Equivalent praxis to CLUSTERED INDEX? Jeremy Dunn 17:39
Re: Equivalent praxis to CLUSTERED INDEX? Adi Alurkar 17:39
Re: Equivalent praxis to CLUSTERED INDEX? Bruce Momjian 17:48
Re: Equivalent praxis to CLUSTERED INDEX? Tom Lane 18:19
Re: Equivalent praxis to CLUSTERED INDEX? Mischa Sandberg 18:26
Why those queries do not utilize indexes? Artimenko Igor 19:29
Re: Equivalent praxis to CLUSTERED INDEX? Greg Stark 19:31
Re: Equivalent praxis to CLUSTERED INDEX? Greg Stark 19:34
Re: Equivalent praxis to CLUSTERED INDEX? Bruce Momjian 19:42
Re: Why those queries do not utilize indexes? Dennis Bjorklund 19:49
Re: Equivalent praxis to CLUSTERED INDEX? Mischa Sandberg 19:50
Re: Anyone familiar with Apple Xserve RAID Vivek Khera 20:34
Re: Why those queries do not utilize indexes? Artimenko Igor 21:08

Aug. 28, 2004

Thread Author Time
Re: Equivalent praxis to CLUSTERED INDEX? Gaetano Mendola 01:02
Re: Equivalent praxis to CLUSTERED INDEX? Gaetano Mendola 02:08
Re: Equivalent praxis to CLUSTERED INDEX? Bruce Momjian 03:54
Re: Equivalent praxis to CLUSTERED INDEX? Greg Stark 08:15
Re: Why those queries do not utilize indexes? Christopher Kings-Lynne 08:50
ill-planned queries inside a stored procedure Gaetano Mendola 11:14
Re: Equivalent praxis to CLUSTERED INDEX? Gaetano Mendola 11:39
Re: ill-planned queries inside a stored procedure andrew 15:13
Re: ill-planned queries inside a stored procedure Gaetano Mendola 16:35
Performance hit on loading from HD Vitaly Belman 17:41
Re: Performance hit on loading from HD Josh Berkus 21:34

Aug. 29, 2004

Thread Author Time
Re: Why does a simple query not use an obvious index? Mr Pink 18:04
Re: Why does a simple query not use an obvious index? Scott Marlowe 18:28
Re: Why does a simple query not use an obvious index? Steinar H. Gunderson 18:57
Re: Equivalent praxis to CLUSTERED INDEX? Josh Berkus 18:59
Re: Why does a simple query not use an obvious index? Greg Stark 21:10
Re: Why does a simple query not use an obvious index? Greg Stark 21:12
Re: Why does a simple query not use an obvious index? Scott Marlowe 21:38
Re: Why does a simple query not use an obvious index? Scott Marlowe 21:44
Re: Why does a simple query not use an obvious index? Tom Lane 22:03
Re: Why does a simple query not use an obvious index? Steinar H. Gunderson 22:04
Re: Why does a simple query not use an obvious index? Greg Stark 22:10
Re: Why does a simple query not use an obvious index? Rod Taylor 22:18
Re: Query performance problem in 8.0.0beta1 Russell Smith 22:31

Aug. 30, 2004

Thread Author Time
Re: Why does a simple query not use an obvious index? Mr Pink 02:09
Re: Why does a simple query not use an obvious index? Tom Lane 02:23
Re: Why does a simple query not use an obvious index? Mr Pink 07:38
Re: Why does a simple query not use an obvious index? Guy Thornley 08:19
Re: Why does a simple query not use an obvious index? Tom Lane 15:41
Re: Why does a simple query not use an obvious index? Greg Stark 15:41
Re: Why does a simple query not use an obvious index? Steinar H. Gunderson 16:02
Re: Why does a simple query not use an obvious index? Tom Lane 16:47
seqscan instead of index scan Martin Sarsale 17:46
Re: seqscan instead of index scan Bruno Wolff III 18:02
Re: seqscan instead of index scan Merlin Moncure 18:06
Re: seqscan instead of index scan Martin Sarsale 18:07
Re: seqscan instead of index scan Martin Sarsale 18:17
Re: seqscan instead of index scan Merlin Moncure 18:29
Re: Why does a simple query not use an obvious index? Pierre-Frédéric Caillaud 19:17
Re: seqscan instead of index scan Bruno Wolff III 19:18
Re: Why does a simple query not use an obvious index? Pierre-Frédéric Caillaud 19:21
Re: Why does a simple query not use an obvious index? Pierre-Frédéric Caillaud 19:32
Re: seqscan instead of index scan Pierre-Frédéric Caillaud 19:39
Re: Why does a simple query not use an obvious index? Bruno Wolff III 19:40
Re: seqscan instead of index scan Stephan Szabo 20:04
Re: Why does a simple query not use an obvious index? Greg Stark 20:18
Re: seqscan instead of index scan Greg Stark 20:36
Re: seqscan instead of index scan Tom Lane 20:48
Re: Why does a simple query not use an obvious index? Tom Lane 21:00

Aug. 31, 2004

Thread Author Time
Re: Why does a simple query not use an obvious index? Greg Stark 06:00
Re: seqscan instead of index scan Martin Sarsale 15:14
Performance with Intel Compiler Jean-Max Reymond 15:27
odbc/ado problems Kroh István 17:26
Re: odbc/ado problems Merlin Moncure 17:33
Table UPDATE is too slow Ron St-Pierre 18:11
Re: Table UPDATE is too slow Thomas F.O'Connell 18:16
Re: Table UPDATE is too slow Steinar H. Gunderson 18:18
Re: Table UPDATE is too slow Ron St-Pierre 18:23
Re: Table UPDATE is too slow Ron St-Pierre 18:35
Re: Table UPDATE is too slow Frank Wiles 18:46
Re: Table UPDATE is too slow Steinar H. Gunderson 18:48
Optimizing a request Jean-Max Reymond 18:59
Re: Table UPDATE is too slow Matt Clark 18:59
Re: odbc/ado problems Merlin Moncure 19:00
Re: Table UPDATE is too slow William Yu 19:15
Re: Optimizing a request Josh Berkus 19:15
Re: Optimizing a request Jean-Max Reymond 19:19
Re: Optimizing a request Gary Doades 19:21
Re: Optimizing a request Jean-Max Reymond 19:42
Re: Optimizing a request Tom Lane 20:13
Re: Optimizing a request Gary Doades 20:16
Re: Optimizing a request Jean-Max Reymond 20:24
Re: Optimizing a request Jean-Max Reymond 20:26
Re: Optimizing a request Gary Doades 20:31
Re: Optimizing a request Hervé Piedvache 20:41
Re: Context Switching issue: Spinlock doesn't fix. jelle 21:20
Re: Equivalent praxis to CLUSTERED INDEX? Jim C. Nasby 21:50
Re: Context Switching issue: Spinlock doesn't fix. Josh Berkus 22:03
Re: Equivalent praxis to CLUSTERED INDEX? Jim C. Nasby 22:05

Sept. 1, 2004

Thread Author Time
Re: Table UPDATE is too slow Ron St-Pierre 00:18
Re: Table UPDATE is too slow Tom Lane 05:32
Changing the column length Michael Ryan S. Puncia 06:42
Fw: Query performance issue with 8.0.0beta1 Stefano Bonnin 07:56
Re: odbc/ado problems Markus Donath 08:19

Browse Archives

Prev | Next