pgsql-performance - November 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 29 30

Nov. 1, 2004

Thread Author Time
Re: Speeding up Gist Index creations Josh Berkus 00:01
Re: [PATCHES] [HACKERS] ARC Memory Usage analysis Gaetano Mendola 01:11
Re: Thanks Chariot Solutions D'Arcy J.M. Cain 12:59
Re: psql large RSS (1.6GB) Gavin Sherry 13:45
Re: psql large RSS (1.6GB) Bruce Momjian 14:04
Re: psql large RSS (1.6GB) Tom Lane 16:03
shared_buffers and Shared Memory Segments Anjan Dave 17:37
Re: psql large RSS (1.6GB) Josh Berkus 18:49
Performance difference when using views Alvaro Nunes Melo 21:40
Re: [PERFORM] [PATCHES] ARC Memory Usage analysis Simon Riggs 22:03
Re: Performance difference when using views Tom Lane 22:08
Re: Performance difference when using views Simon Riggs 22:28

Nov. 2, 2004

Thread Author Time
Re: Speeding up Gist Index creations Neil Conway 01:35
Re: Speeding up Gist Index creations Josh Berkus 05:58
Restricting Postgres Martin Foster 23:52

Nov. 3, 2004

Thread Author Time
Re: Restricting Postgres Andrew Sullivan 14:17
preloading indexes stuff 17:30
Re: preloading indexes Matt Clark 17:59
vacuum analyze slows sql query patrick ~ 18:56
Re: preloading indexes stuff 19:12
Re: vacuum analyze slows sql query Doug Y 19:17
Re: Restricting Postgres Simon Riggs 19:21
Re: preloading indexes Andrew Sullivan 19:35
Re: preloading indexes Pierre-Frédéric Caillaud 19:50
Re: preloading indexes Tom Lane 19:55
Re: vacuum analyze slows sql query Tom Lane 20:12
Re: preloading indexes stuff 20:19
Re: preloading indexes Tom Lane 20:53
Re: preloading indexes Andrew Sullivan 20:53
Re: preloading indexes stuff 20:56
Re: Restricting Postgres Martin Foster 21:25
Re: vacuum analyze slows sql query patrick ~ 22:22
Re: Restricting Postgres John A Meinel 23:25
Re: Restricting Postgres Martin Foster 23:35

Nov. 4, 2004

Thread Author Time
Re: preloading indexes Mike Benoit 00:50
index not used if using IN or OR Mario Ivankovits 07:55
Re: Restricting Postgres Matt Clark 08:29
Re: index not used if using IN or OR Richard Huxton 08:32
Re: Anything to be gained from a 'Postgres Filesystem'? Markus Schaber 11:00
Re: Restricting Postgres Simon Riggs 12:19
Re: Anything to be gained from a 'Postgres Filesystem'? Pierre-Frédéric Caillaud 12:29
Re: Restricting Postgres Martin Foster 13:10
Re: Restricting Postgres Martin Foster 13:17
Re: preloading indexes Andrew Sullivan 14:02
Re: index not used if using IN or OR Tom Lane 14:52
Re: Anything to be gained from a 'Postgres Filesystem'? Chris Browne 15:47
Re: [PERFORM] Restricting Postgres Kevin Barnard 16:00
Re: Restricting Postgres Martin Foster 16:15
Re: Restricting Postgres Matt Clark 16:33
Re: Restricting Postgres Matthew Nuzum 16:37
Re: Restricting Postgres Matt Clark 16:46
Re: Restricting Postgres Pierre-Frédéric Caillaud 17:25
Re: Restricting Postgres Martin Foster 17:59
Re: Restricting Postgres Martin Foster 18:04
Re: Restricting Postgres Matt Clark 18:20
Re: Anything to be gained from a 'Postgres Filesystem'? Simon Riggs 19:03
Re: Anything to be gained from a 'Postgres Filesystem'? Steinar H. Gunderson 19:20
Re: Anything to be gained from a 'Postgres Filesystem'? Tom Lane 19:34
Re: Restricting Postgres Martin Foster 20:30
Re: Restricting Postgres Pierre-Frédéric Caillaud 20:30
Re: Anything to be gained from a 'Postgres Filesystem'? Simon Riggs 20:40
Re: Anything to be gained from a 'Postgres Filesystem'? Tom Lane 20:45
Re: Restricting Postgres Steinar H. Gunderson 20:46
Re: Restricting Postgres Matt Clark 21:00
Re: Restricting Postgres Matt Clark 21:01
Better Hardware, worst Results Alvaro Nunes Melo 21:06
Re: Better Hardware, worst Results Rod Taylor 21:16
Re: Better Hardware, worst Results Tom Lane 21:46
Re: Restricting Postgres Pierre-Frédéric Caillaud 22:00
appropriate indexing T E Schmitz 22:32
Re: Restricting Postgres Matt Clark 22:37
Re: appropriate indexing Matt Clark 22:38
Re: Better Hardware, worst Results al_nunes 22:42
Re: Better Hardware, worst Results Rod Taylor 22:58
Re: Better Hardware, worst Results Matt Clark 22:58
Re: Better Hardware, worst Results Matt Clark 23:08
Re: Restricting Postgres Bruno Wolff III 23:14
Re: Restricting Postgres Pierre-Frédéric Caillaud 23:21
Re: Restricting Postgres Matt Clark 23:22
Re: Restricting Postgres Matt Clark 23:32
Re: Restricting Postgres Matt Clark 23:35

Nov. 5, 2004

Thread Author Time
Re: Anything to be gained from a 'Postgres Filesystem'? Christopher Browne 02:05
Re: Anything to be gained from a 'Postgres Filesystem'? Christopher Browne 02:29
Re: Restricting Postgres Martin Foster 02:49
Re: Anything to be gained from a 'Postgres Filesystem'? Neil Conway 04:28
Re: Anything to be gained from a 'Postgres Filesystem'? Neil Conway 04:33
Re: Anything to be gained from a 'Postgres Filesystem'? Neil Conway 04:35
Re: Restricting Postgres Bruno Wolff III 05:16
Checking = with timestamp field is slow Antony Paul 07:16
Re: Checking = with timestamp field is slow Michael Glaesemann 08:14
Re: Checking = with timestamp field is slow Michael Glaesemann 08:32
Re: Checking = with timestamp field is slow Michael Fuhr 08:34
Re: Restricting Postgres Leeuw van der, Tim 08:48
Re: Checking = with timestamp field is slow Andrew McMillan 08:48
Re: Checking = with timestamp field is slow Michael Fuhr 09:13
Re: Checking = with timestamp field is slow Christopher Browne 12:47
Strange (?) Index behavior? Allen Landsidel 14:39
Re: Strange (?) Index behavior? Matt Clark 15:06
Re: Strange (?) Index behavior? Rod Taylor 15:07
Re: Strange (?) Index behavior? Allen Landsidel 15:32
postgresql amd-64 Merlin Moncure 15:33
Re: Strange (?) Index behavior? Allen Landsidel 16:54
Re: Checking = with timestamp field is slow Michael Fuhr 17:45
Re: Strange (?) Index behavior? Bruno Wolff III 17:51
Re: Strange (?) Index behavior? Allen Landsidel 17:56
What is the difference between these? Matt Nuzum 18:09
Re: postgresql amd-64 Daniel Ceregatti 18:23
Re: vacuum analyze slows sql query patrick ~ 18:26
Re: Strange (?) Index behavior? Matt Clark 18:34
Re: What is the difference between these? Matthew T. O'Connor 19:44
Re: Strange (?) Index behavior? Tom Lane 19:57
Re: What is the difference between these? Tom Lane 20:32
Re: Strange (?) Index behavior? Allen Landsidel 20:36
Question regarding the file system 📎 Gabriele Bartolini 21:00
Re: Strange (?) Index behavior? Allen Landsidel 21:02
Re: Strange (?) Index behavior? Tom Lane 21:08
Re: postgresql amd-64 Merlin Moncure 21:17
Re: Strange (?) Index behavior? Allen Landsidel 22:40
ia64 results with dbt2 and 8.0beta4 Mark Wong 23:13

Nov. 6, 2004

Thread Author Time
Re: Strange (?) Index behavior? Matt Clark 00:14
Re: vacuum analyze slows sql query patrick ~ 00:26
Re: postgresql amd-64 Vishal Kashyap @ [Sai Hertz And Control Systems] 03:01
Re: Strange (?) Index behavior? Tom Lane 04:04
Re: vacuum analyze slows sql query Tom Lane 04:06
Re: vacuum analyze slows sql query patrick ~ 06:18
Re: vacuum analyze slows sql query Tom Lane 06:38
Re: Strange (?) Index behavior? Allen Landsidel 07:27
poor performance in migrated database Carlos Lopez 19:52
Re: poor performance in migrated database Troels Arvin 20:07
Re: poor performance in migrated database Troels Arvin 20:26
Re: [PERFORM] poor performance in migrated database Simon Riggs 21:39
Re: [PERFORM] poor performance in migrated database Scott Marlowe 23:00

Nov. 7, 2004

Thread Author Time
DISTINCT and GROUP BY: possible performance enhancement? Ang Chin Han 11:04

Nov. 8, 2004

Thread Author Time
Re: postgresql amd-64 Iain 02:13
Re: postgresql amd-64 Iain 07:36
Postgresql is using seqscan when is should use indexes. Andreas Åkre Solberg 10:40
Re: postgresql amd-64 Radu-Adrian Popescu 11:40
Re: Better Hardware, worst Results Alvaro Nunes Melo 11:46
Re: Postgresql is using seqscan when is should use indexes. Russell Smith 12:04
ext3 journalling type Dawid Kuroczko 12:26
Re: postgresql amd-64 Merlin Moncure 13:20
Re: ext3 journalling type Bruce Momjian 14:04
Re: ext3 journalling type Matt Clark 15:14
Re: ext3 journalling type Mark Wong 16:29
Re: ext3 journalling type Josh Berkus 17:38
Re: Question regarding the file system Josh Berkus 17:44
Re: vacuum analyze slows sql query patrick ~ 18:57
Re: vacuum analyze slows sql query John Meinel 19:29
Re: [PERFORM] poor performance in migrated database Carlos Lopez 21:28
Re: vacuum analyze slows sql query patrick ~ 23:19
Re: [PERFORM] poor performance in migrated database Tom Lane 23:57

Nov. 9, 2004

Thread Author Time
Re: vacuum analyze slows sql query John Meinel 00:01
Re: vacuum analyze slows sql query Pierre-Frédéric Caillaud 00:04
Slow performance with Group By Erik Norvelle 00:09
Re: vacuum analyze slows sql query John Meinel 00:31
Re: Slow performance with Group By Tom Lane 00:56
Re: Question regarding the file system Josh Berkus 01:31
Re: [PERFORM] poor performance in migrated database Carlos Lopez 14:56
Need advice on postgresql.conf settings Shane | SkinnyCorp 19:01
Re: vacuum analyze slows sql query patrick ~ 19:26
Re: Need advice on postgresql.conf settings Tom Lane 21:56
seqscan strikes again Jim C. Nasby 22:23
Re: Need advice on postgresql.conf settings Sean Chittenden 22:44
Re: seqscan strikes again 📎 Joshua D. Drake 23:14
Re: seqscan strikes again Tom Lane 23:24

Nov. 10, 2004

Thread Author Time
simple select-statement takes more than 25 sec Cao Duy 09:35
Re: simple select-statement takes more than 25 sec Steinar H. Gunderson 10:17
Re: simple select-statement takes more than 25 sec gnari 10:31
Re: simple select-statement takes more than 25 sec Cao Duy 11:22
Re: simple select-statement takes more than 25 sec Steinar H. Gunderson 11:45
Re: Need advice on postgresql.conf settings Jeff 13:04
How to speed-up inserts with jdbc Michael Kleiser 13:51
Re: How to speed-up inserts with jdbc Jeff 13:55
Re: How to speed-up inserts with jdbc Dave Cramer 14:05
Re: How to speed-up inserts with jdbc Leeuw van der, Tim 14:26
Tuning suggestions wanted Rod Taylor 16:52
Re: seqscan strikes again Jim C. Nasby 17:00
Solaris 9 Tuning Tips requested Rod Taylor 17:04
int4 in a GiST index Mike Rylander 21:51

Nov. 11, 2004

Thread Author Time
Re: int4 in a GiST index George Essig 02:50
Re: int4 in a GiST index Mike Rylander 05:53
Re: seqscan strikes again Gaetano Mendola 07:58
Re: vacuum analyze slows sql query Gaetano Mendola 08:03
Re: How to speed-up inserts with jdbc Edwin Eyan Moragas 08:04
Re: How to speed-up inserts with jdbc Steinar H. Gunderson 10:04
Re: Strange (?) Index behavior? Allen Landsidel 16:21
Re: Strange (?) Index behavior? Josh Berkus 18:52
Re: Strange (?) Index behavior? Allen Landsidel 19:30
Re: Strange (?) Index behavior? Greg Stark 20:49
Re: How to speed-up inserts with jdbc Edwin Eyan Moragas 21:10
Re: Strange (?) Index behavior? Allen Landsidel 21:12
Re: Strange (?) Index behavior? Tom Lane 21:41
Re: Strange (?) Index behavior? 📎 Joshua D. Drake 21:48

Nov. 12, 2004

Thread Author Time
Clarification on two bits on VACUUM FULL VERBOSE output Josh Berkus 18:42
Re: Clarification on two bits on VACUUM FULL VERBOSE output Tom Lane 19:20
Re: Strange (?) Index behavior? Allen Landsidel 20:12
Re: Clarification on two bits on VACUUM FULL VERBOSE output Josh Berkus 21:11
Re: Clarification on two bits on VACUUM FULL VERBOSE output Tom Lane 21:19
Re: Strange (?) Index behavior? Tom Lane 22:35

Nov. 13, 2004

Thread Author Time
Re: Strange (?) Index behavior? Allen Landsidel 00:26

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