pgsql-performance - June 2006

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

June 1, 2006

Thread Author Time
Re: App very unresponsive while performing simple update Jim C. Nasby 03:18
Re: App very unresponsive while performing simple update Greg Stark 04:30
vacuuming problems continued Antoine 11:54
Re: vacuuming problems continued Tom Lane 15:05
help me problems with pg_clog file Joao 17:17
Re: Bulk loading/merging Michael Artz 18:04

June 2, 2006

Thread Author Time
Re: [PERFORM] help me problems with pg_clog file Gourish Singbal 07:41
Re: pg_dump issue Evgeny Gridasov 12:17
Initial database loading and IDE x SCSI carlosreimer 18:25
Re: Initial database loading and IDE x SCSI Scott Marlowe 18:40
Re: Initial database loading and IDE x SCSI Mark Lewis 18:41
Re: Initial database loading and IDE x SCSI Tom Lane 18:43
RES: Initial database loading and IDE x SCSI carlosreimer 19:54
Re: RES: Initial database loading and IDE x SCSI Mark Lewis 20:13
RES: RES: Initial database loading and IDE x SCSI carlosreimer 20:37
Re: RES: RES: Initial database loading and IDE x SCSI Mark Lewis 20:44
RES: RES: RES: Initial database loading and IDE x SCSI carlosreimer 20:55

June 3, 2006

Thread Author Time
Re: RES: Initial database loading and IDE x SCSI Mark Kirkwood 00:13
scaling up postgres fzied 09:31
Re: scaling up postgres Steinar H. Gunderson 09:43
Re: scaling up postgres PFC 09:57
Re: Répondre Steinar H. Gunderson 10:52
Re: scaling up postgres David Boreham 12:43
Re: scaling up postgres Tom Lane 15:12
Re: scaling up postgres David Boreham 15:18
Re: scaling up postgres Neil Saunders 15:35

June 4, 2006

Thread Author Time
Re: RES: Initial database loading and IDE x SCSI Bruce Momjian 02:03
Re: RES: Initial database loading and IDE x SCSI Mark Kirkwood 02:21
Re: INSERT OR UPDATE WITHOUT SELECT A. Kretschmer 07:40
Re: Bulk loading/merging Ahmad Fajar 12:00
psql -A (unaligned format) eats too much memory Zoltan Boszormenyi 22:01
Re: psql -A (unaligned format) eats too much memory Zoltan Boszormenyi 22:32

June 5, 2006

Thread Author Time
Re: How can I make this query faster (resend) Jim C. Nasby 14:35
Re: vacuuming problems continued Jim C. Nasby 14:43
Re: [PERFORM] help me problems with pg_clog file Jim C. Nasby 14:48
Re: Bulk loading/merging Jim C. Nasby 15:04
Re: [PERFORM] psql -A (unaligned format) eats too much memory Jim C. Nasby 15:22
Re: [PERFORM] psql -A (unaligned format) eats too much memory Tom Lane 15:27
Re: [PERFORM] psql -A (unaligned format) eats too much memory Jim C. Nasby 15:53
Re: [PERFORM] psql -A (unaligned format) eats too much memory Tom Lane 16:00
Re: [PERFORM] psql -A (unaligned format) eats too much Andrew Dunstan 16:40
Re: [PERFORM] psql -A (unaligned format) eats too much Zoltan Boszormenyi 16:45
Re: [PERFORM] psql -A (unaligned format) eats too much Mark Woodward 16:48
Re: [PERFORM] psql -A (unaligned format) eats too much Mark Woodward 17:01
Re: [PERFORM] psql -A (unaligned format) eats too much Andrew Dunstan 17:03
Re: [PERFORM] psql -A (unaligned format) eats too much Zoltan Boszormenyi 17:17
Re: [PERFORM] psql -A (unaligned format) eats too much Neil Conway 17:52
Re: [PERFORM] psql -A (unaligned format) eats too much Tom Lane 18:10
Some queries starting to hang 📎 Chris Beecroft 19:05
How to force Postgres to use index on ILIKE Andrus 19:29
Re: Some queries starting to hang Andrew Sullivan 19:42
Re: Some queries starting to hang Tom Lane 20:07
Re: Some queries starting to hang Andrew Sullivan 20:38
Re: Some queries starting to hang Chris Beecroft 20:39
Re: vacuuming problems continued Andrew Sullivan 20:41
Re: Some queries starting to hang Tom Lane 21:06
Re: How to force Postgres to use index on ILIKE Josh Berkus 21:26
Re: Some queries starting to hang 📎 Chris Beecroft 22:22

June 6, 2006

Thread Author Time
Problem: query becomes slow when calling a fast user defined function. Dan Libby 00:03
Re: Problem: query becomes slow when calling a fast user defined function. Tom Lane 02:43
Re: How to force Postgres to use index on ILIKE Andrus 09:57
Re: [PERFORM] psql -A (unaligned format) eats too much Hannu Krosing 12:30
Re: [PERFORM] psql -A (unaligned format) eats too much Tom Lane 13:48
Re: How to force Postgres to use index on ILIKE Tom Lane 14:23
Re: Some queries starting to hang Simon Riggs 14:39
Re: [PERFORM] psql -A (unaligned format) eats too much Jim C. Nasby 14:39
Re: Some queries starting to hang Tom Lane 14:43
Re: [PERFORM] psql -A (unaligned format) eats too much Tom Lane 14:47
Re: Some queries starting to hang Simon Riggs 14:52
Re: Some queries starting to hang Jim C. Nasby 15:03
Re: Some queries starting to hang Tom Lane 15:06
Re: Some queries starting to hang Jim C. Nasby 15:14
Re: Some queries starting to hang A.M. 15:21
Re: Some queries starting to hang Andrew Sullivan 15:29
Re: Some queries starting to hang Greg Stark 15:37
Re: Some queries starting to hang A.M. 15:37
Re: Some queries starting to hang Tom Lane 15:41
Re: Some queries starting to hang Andrew Sullivan 16:20
Re: Some queries starting to hang Craig A. James 17:45
Re: Some queries starting to hang Craig A. James 17:50
Re: Some queries starting to hang Scott Marlowe 17:54
Re: vacuuming problems continued 📎 Mischa Sandberg 18:51
Re: vacuuming problems continued Joshua D. Drake 19:21
Re: vacuuming problems continued Mischa Sandberg 19:38
Re: Some queries starting to hang Jim C. Nasby 20:51
Re: Some queries starting to hang Scott Marlowe 21:02
Re: Some queries starting to hang Tom Lane 21:11
Re: Some queries starting to hang Scott Marlowe 21:14
Re: lowering priority automatically at connection Ron Mayer 23:27

June 7, 2006

Thread Author Time
Re: Some queries starting to hang Simon Riggs 11:42
Regarding ALTER Command soni de 12:43
Re: Regarding ALTER Command Jim C. Nasby 14:50
Curious sorting puzzle Ivan Voras 19:26
Re: vacuuming problems continued Antoine 20:52
Re: Curious sorting puzzle Tom Lane 21:16
Re: vacuuming problems continued Jim C. Nasby 22:17
Re: Curious sorting puzzle Ivan Voras 23:04

June 8, 2006

Thread Author Time
Re: Regarding ALTER Command soni de 06:07
Regarding pg_dump utility soni de 06:09
JOIN with inherited table ignores indexes Andreas Pflug 11:40
Re: Regarding ALTER Command Tom Lane 15:04
Re: Regarding pg_dump utility Tom Lane 15:06
Re: Regarding pg_dump utility Jim C. Nasby 15:16
Re: JOIN with inherited table ignores indexes Jim C. Nasby 15:22
Re: Regarding pg_dump utility Geoffrey 15:42
Re: JOIN with inherited table ignores indexes Tom Lane 16:06
Re: Regarding pg_dump utility Alvaro Herrera 16:23
Re: Regarding pg_dump utility Andreas Pflug 16:33
Re: Regarding pg_dump utility Jim C. Nasby 16:35
Re: Regarding pg_dump utility Alvaro Herrera 16:38
Re: JOIN with inherited table ignores indexes Andreas Pflug 16:42
Why date index is not used Andrus 18:53
Re: Why date index is not used Tomas Vondra 19:10
Re: Why date index is not used Tomas Vondra 19:20
Re: Why date index is not used Tom Lane 19:20
Re: Why date index is not used Dave Dutcher 20:07
Re: Why date index is not used Jim C. Nasby 21:57
Re: Why date index is not used Tom Lane 22:19

June 9, 2006

Thread Author Time
Re: Regarding pg_dump utility Christopher Kings-Lynne 01:16
Re: Regarding pg_dump utility Christopher Kings-Lynne 01:19
Re: Why date index is not used Andrus 09:06
Re: Why date index is not used Andrus 09:40
Re: Why date index is not used Andrus 09:52
pgsql_tmp and postgres settings Domenico - Sal. F.lli Riva 12:23
Re: Regarding pg_dump utility Paul S 14:22
Re: Why date index is not used Jim C. Nasby 15:54
Re: pgsql_tmp and postgres settings Jim C. Nasby 15:59
pg_xlog on data partition with BBU RAID Jim C. Nasby 19:41
Re: pg_xlog on data partition with BBU RAID Scott Marlowe 20:21

June 10, 2006

Thread Author Time
FW: pg_xlog on data partition with BBU RAID Jim Nasby 02:24

June 11, 2006

Thread Author Time
Variation between query runtimes John Top-k apad 06:35
function not called if part of aggregate Craig A. James 17:18
Re: function not called if part of aggregate Steinar H. Gunderson 17:31
Re: function not called if part of aggregate Tom Lane 17:39
Re: function not called if part of aggregate Jim C. Nasby 17:48
Re: function not called if part of aggregate Greg Stark 18:00
Re: scaling up postgres Mario Splivalo 21:42
Re: scaling up postgres Steinar H. Gunderson 21:43
Re: scaling up postgres Joshua D. Drake 23:21

June 12, 2006

Thread Author Time
Re: Variation between query runtimes Qingqing Zhou 02:50
Re: pgsql_tmp and postgres settings Gourish Singbal 05:56
Re: scaling up postgres Alex Stapleton 09:56
Re: scaling up postgres 📎 Sven Geisler 10:01
Re: scaling up postgres Sven Geisler 11:21
Posrgres speed problem Ruben Rubio Rey 14:38
Re: Posrgres speed problem Dave Dutcher 14:45
Re: Posrgres speed problem Ruben Rubio Rey 14:58
Re: Posrgres speed problem Ruben Rubio Rey 15:02
Re: Posrgres speed problem Michael Fuhr 15:05
Re: pgsql_tmp and postgres settings Jim C. Nasby 15:15
Re: Posrgres speed problem Jim C. Nasby 15:17
Re: Posrgres speed problem Ruben Rubio Rey 15:22
Re: Posrgres speed problem Jim C. Nasby 15:23
Re: Posrgres speed problem Jim C. Nasby 15:25
Re: Posrgres speed problem Sven Geisler 15:33
Interesting slow query PFC 19:42
Re: scaling up postgres Zydoon 21:47
64-bit vs 32-bit performance ... backwards? Anthony Presley 22:28
Re: Interesting slow query Tom Lane 22:53
Re: 64-bit vs 32-bit performance ... backwards? Josh Berkus 23:16
Re: 64-bit vs 32-bit performance ... backwards? David Boreham 23:19
Re: 64-bit vs 32-bit performance ... backwards? Steve Atkins 23:26
Re: 64-bit vs 32-bit performance ... backwards? Tom Lane 23:35

June 13, 2006

Thread Author Time
Re: 64-bit vs 32-bit performance ... backwards? Stephen Frost 00:04
Re: 64-bit vs 32-bit performance ... backwards? Bill Moran 00:29
Re: 64-bit vs 32-bit performance ... backwards? Joshua D. Drake 01:15
Re: 64-bit vs 32-bit performance ... backwards? Steve Atkins 01:29
Re: 64-bit vs 32-bit performance ... backwards? Luke Lonergan 01:50
Re: 64-bit vs 32-bit performance ... backwards? mark 02:16
Re: 64-bit vs 32-bit performance ... backwards? Alex Turner 02:26
Re: 64-bit vs 32-bit performance ... backwards? Christopher Browne 02:31
Re: 64-bit vs 32-bit performance ... backwards? Leigh Dyer 02:42
Re: 64-bit vs 32-bit performance ... backwards? Tom Lane 02:44
Re: 64-bit vs 32-bit performance ... backwards? Christopher Browne 02:51
Re: 64-bit vs 32-bit performance ... backwards? Luke Lonergan 02:57
Re: 64-bit vs 32-bit performance ... backwards? David Wheeler 03:00
Re: 64-bit vs 32-bit performance ... backwards? Josh Berkus 04:34
Re: 64-bit vs 32-bit performance ... backwards? J. Andrew Rogers 06:00
Re: function not called if part of aggregate Craig A. James 06:26
Placement of 64-bit libraries (offtopic) Steinar H. Gunderson 06:30
Re: Posrgres speed problem Ruben Rubio Rey 06:37
Re: Posrgres speed problem - solved? Ruben Rubio Rey 06:44
Re: Posrgres speed problem - solved? Guido Neitzer 08:11
Re: Posrgres speed problem - solved? Ruben Rubio Rey 08:17
Re: 64-bit vs 32-bit performance ... backwards? Nis Jorgensen 08:40
Re: 64-bit vs 32-bit performance ... backwards? 📎 Sven Geisler 09:04
Re: Posrgres speed problem - solved! Ruben Rubio Rey 10:33
Re: 64-bit vs 32-bit performance ... backwards? PFC 10:47
Re: 64-bit vs 32-bit performance ... backwards? Luke Lonergan 11:33
Re: Posrgres speed problem - solved! Guido Neitzer 11:48
Re: Interesting slow query PFC 11:56
Re: 64-bit vs 32-bit performance ... backwards? Sven Geisler 12:03
Re: 64-bit vs 32-bit performance ... backwards? Christopher Browne 12:23
Re: 64-bit vs 32-bit performance ... backwards? Luke Lonergan 12:42
OT - select + must have from - sql standard syntax? Antoine 12:43
Re: 64-bit vs 32-bit performance ... backwards? Sven Geisler 12:46
Re: 64-bit vs 32-bit performance ... backwards? Luke Lonergan 12:49
Re: 64-bit vs 32-bit performance ... backwards? Sven Geisler 12:52
Re: 64-bit vs 32-bit performance ... backwards? Andreas Pflug 13:15
Re: 64-bit vs 32-bit performance ... backwards? J. Andrew Rogers 13:46

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