pgsql-performance - June 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 13 14 15 16 17 18 20 21 22 23 24 25 26 27 28 29 30

June 1, 2004

Thread Author Time
Trigger & Function Duane Lee - EGOVX 21:03
Re: [PERFORM] Trigger & Function Mike Nolan 22:04
PostgreSQL on VMWare vs Windows vs CoLinux Vitaly Belman 22:56

June 2, 2004

Thread Author Time
Disk performance, was Re: tablespaces and DB administration Marty Scholes 00:08
PostgreSQL and Kernel 2.6.x V i s h a l Kashyap @ [Sai Hertz And Control Systems] 03:16
Re: PostgreSQL and Kernel 2.6.x Rod Taylor 03:31
Postgres query optimization with varchar fields W.H. van Atteveldt 11:57
Re: PostgreSQL on VMWare vs Windows vs CoLinux Greg Stark 14:27
Re: PostgreSQL on VMWare vs Windows vs CoLinux Tom Lane 15:24
Re: PostgreSQL on VMWare vs Windows vs CoLinux Jan Wieck 15:30
Re: PostgreSQL and Kernel 2.6.x Rajesh Kumar Mallah 15:38
Re: [PERFORM] Trigger & Function Duane Lee - EGOVX 17:01
Re: PostgreSQL on VMWare vs Windows vs CoLinux Matthew Nuzum 18:51
Re: PostgreSQL on VMWare vs Windows vs CoLinux Leeuw van der, Tim 19:03
Context Switching issue: Spinlock doesn't fix. Josh Berkus 19:25
Re: Hardware opinions wanted Andrew Hammond 20:18
Re: PostgreSQL on VMWare vs Windows vs CoLinux Shachar Shemesh 20:24
Re: PostgreSQL on VMWare vs Windows vs CoLinux Merlin Moncure 20:45
Re: Pl/Pgsql Functions running simultaneously Marcus Whitney 21:08
Re: Inherited Tables Performance Marcus Whitney 21:27
Re: PostgreSQL on VMWare vs Windows vs CoLinux Gary Doades 21:31
Re: PostgreSQL on VMWare vs Windows vs CoLinux Greg Stark 21:39

June 3, 2004

Thread Author Time
Re: Postgres query optimization with varchar fields Christopher Kings-Lynne 01:42
Re: PostgreSQL on VMWare vs Windows vs CoLinux Matthew Nuzum 02:00
Re: PostgreSQL on VMWare vs Windows vs CoLinux Tom Lane 02:12
Re: PostgreSQL on VMWare vs Windows vs CoLinux Tom Lane 03:51
Re: select max(id) from aTable is very slow Richard Huxton 13:07
Re: Pl/Pgsql Functions running simultaneously Marcus Whitney 21:38
Most transactions per second on largest box? jason.servetar 23:10

June 4, 2004

Thread Author Time
Re: Most transactions per second on largest box? Greg Stark 05:57
Planner problem Mikael Kjellström 12:10
Re: filesystem option tuning CH 14:21
Re: Planner problem Tom Lane 14:41
Re: filesystem option tuning Tom Lane 15:33
postgres performance: comparing 2 data centers Michael Nonemacher 15:42
Re: postgres performance: comparing 2 data centers Merlin Moncure 16:02
Re: postgres performance: comparing 2 data centers Tom Lane 16:07
Re: Pl/Pgsql Functions running simultaneously Robert Treat 21:39
Re: postgres performance: comparing 2 data centers Michael Nonemacher 22:07
Re: postgres performance: comparing 2 data centers Rod Taylor 22:27
Re: postgres performance: comparing 2 data centers Rod Taylor 22:29
Re: postgres performance: comparing 2 data centers Michael Nonemacher 23:12

June 5, 2004

Thread Author Time
Re: postgres performance: comparing 2 data centers Greg Stark 00:33
Re: postgres performance: comparing 2 data centers Tom Lane 04:17
Unused table of view Laurent Martelli 14:37
Re: Unused table of view Tom Lane 17:36
[OFF-TOPIC] - Known maximum size of the PostgreSQL Database Carlos Eduardo Smanioto 18:55
Re: Unused table of view Laurent Martelli 19:01
Using a COPY...FROM through JDBC? Steve Wampler 20:12
Re: Slow in morning hours Harald Fuchs 20:54

June 6, 2004

Thread Author Time
Query involving views Laurent Martelli 11:08
Re: Query involving views Tom Lane 16:22
Re: Query involving views Laurent Martelli 21:12
Re: Using a COPY...FROM through JDBC? Markus Schaber 22:08

June 7, 2004

Thread Author Time
Re: General performance questions about postgres on Apple Gregory S. Williamson 05:54
Relation of cpu_*_costs? SZŰCS Gábor 07:36
Re: Using a COPY...FROM through JDBC? Markus Schaber 07:47
Re: Using a COPY...FROM through JDBC? Kris Jurka 09:26
Postgres function use makes machine crash. 📎 Stef 11:34
Re: Relation of cpu_*_costs? Tom Lane 13:51
Re: Postgres function use makes machine crash. Tom Lane 15:11
Re: Postgres function use makes machine crash. Stef 15:34
PREPAREing statements versus compiling PLPGSQL Mark Aufflick 15:52
pl/pgsql and Transaction Isolation Marcus Whitney 16:31
Re: Pl/Pgsql Functions running simultaneously Marcus Whitney 16:43
Re: Relation of cpu_*_costs? SZŰCS Gábor 17:19
is it possible to for the planner to optimize this form? Merlin Moncure 17:30
Re: [PERFORM] Using a COPY...FROM through JDBC? Steve Wampler 17:40
Re: [PERFORM] Using a COPY...FROM through JDBC? Steve Wampler 17:59
seq scan woes Dan Langille 19:45
Re: seq scan woes Rod Taylor 20:00
Re: seq scan woes Dan Langille 20:12
Re: is it possible to for the planner to optimize this form? Josh Berkus 20:31
Re: seq scan woes Rod Taylor 20:38
Re: seq scan woes Dan Langille 21:02
Re: [PERFORM] Using a COPY...FROM through JDBC? Kris Jurka 21:38
50 000 000 Table entries and I have to do a keyword search HELP NEEDED borajetta 21:47
Join slow on "large" tables Josué Maldonado 22:19
Re: Join slow on "large" tables Josh Berkus 22:31
Re: Join slow on "large" tables Scott Marlowe 22:47
Re: seq scan woes Dan Langille 22:49
Re: seq scan woes Dan Langille 22:55
Re: Join slow on "large" tables Josué Maldonado 23:12
Re: Join slow on "large" tables Josh Berkus 23:21
Re: Join slow on "large" tables Josué Maldonado 23:30
Re: is it possible to for the planner to optimize this Duane Lee - EGOVX 23:31

June 8, 2004

Thread Author Time
Re: pl/pgsql and Transaction Isolation Tom Lane 04:29
Re: Join slow on "large" tables Tom Lane 05:18
Use of Functional Indexs and Planner estimates Russell Smith 07:24
Re: Use of Functional Indexs and Planner estimates Manfred Koizar 08:57
Re: pl/pgsql and Transaction Isolation Marcus Whitney 14:19
Re: Use of Functional Indexs and Planner estimates Tom Lane 14:33
Re: Join slow on "large" tables Josué Maldonado 14:36
Re: Use of Functional Indexs and Planner estimates Scott Marlowe 14:54
Re: Join slow on "large" tables Scott Marlowe 15:27
reindex and copy - deadlock? Litao Wu 15:31
Re: reindex and copy - deadlock? Tom Lane 16:47
Re: reindex and copy - deadlock? Litao Wu 17:25
Re: reindex and copy - deadlock? Tom Lane 17:51
RamDisk jason.servetar 18:45

June 9, 2004

Thread Author Time
Re: Use of Functional Indexs and Planner estimates Greg Stark 15:59
Index oddity ken 19:31
Re: Index oddity Rod Taylor 20:12
Re: Index oddity ken 20:50
Re: Index oddity Rod Taylor 20:56
Re: Index oddity ken 21:02
Re: Index oddity Rod Taylor 21:29
Re: Index oddity ken 23:11

June 10, 2004

Thread Author Time
Re: Index oddity Christopher Kings-Lynne 01:45
Re: Index oddity Rod Taylor 02:17
Re: Index oddity Mark Kirkwood 03:08
Re: Index oddity Joshua D. Drake 03:32
Re: Index oddity Tom Lane 05:01
*very* inefficient choice made by the planner (regarding IN(...)) Frank van Vugt 14:24
Re: *very* inefficient choice made by the planner (regarding Stephan Szabo 15:00
Re: *very* inefficient choice made by the planner (regarding IN(...)) Tom Lane 15:19
Re: *very* inefficient choice made by the planner (regarding IN(...)) Frank van Vugt 15:32
Re: *very* inefficient choice made by the planner (regarding Jean-Luc Lachance 15:45
Re: *very* inefficient choice made by the planner (regarding Tom Lane 15:59
Re: Database Server Tuning Anjan Dave 16:02
Re: Database Server Tuning Vivek Khera 16:51
Re: *very* inefficient choice made by the planner (regarding Jean-Luc Lachance 16:56
Re: *very* inefficient choice made by the planner (regarding Stephan Szabo 17:09
Re: *very* inefficient choice made by the planner (regarding Stephan Szabo 17:14

June 11, 2004

Thread Author Time
ORDER BY user defined function performance issues Nick Trainor 11:14
Re: ORDER BY user defined function performance issues Paul Thomas 13:41
Problems with vacuum! Domenico Sgarbossa 13:54
Re: Problems with vacuum! Chris Hoover 14:39
Re: [BULK] Problems with vacuum! Domenico Sgarbossa 14:53
Re: [BULK] Problems with vacuum! Doug McNaught 15:03
Re: reindex and copy - deadlock? Litao Wu 15:11
Re: reindex and copy - deadlock? Tom Lane 16:05
Re: ORDER BY user defined function performance issues Tom Lane 17:59
in-transaction insert performance in 7.5devel Merlin Moncure 18:40
Re: in-transaction insert performance in 7.5devel Rod Taylor 18:55
Re: in-transaction insert performance in 7.5devel Merlin Moncure 19:04
Re: in-transaction insert performance in 7.5devel Rod Taylor 19:27
Re: reindex and copy - deadlock? Litao Wu 19:35
Re: in-transaction insert performance in 7.5devel Tom Lane 19:52
Re: reindex and copy - deadlock? Tom Lane 20:27
Re: in-transaction insert performance in 7.5devel Merlin Moncure 21:04
Re: in-transaction insert performance in 7.5devel Tom Lane 21:30

June 13, 2004

Thread Author Time
Additional select fields in a GROUP BY Vitaly Belman 03:21
Re: Additional select fields in a GROUP BY Tom Lane 03:39
Re: Additional select fields in a GROUP BY Bruno Wolff III 13:52
Re: Additional select fields in a GROUP BY Vitaly Belman 17:35
Re: Additional select fields in a GROUP BY Tom Lane 17:59

June 14, 2004

Thread Author Time
pg_fetch_array Thanks 09:12
Re: [BULK] Problems with vacuum! Dawn Hollingsworth 15:24
Re: Index oddity (still) ken 23:47

June 15, 2004

Thread Author Time
Re: 50 000 000 Table entries and I have to do a keyword search HELP NEEDED Josh Berkus 00:11
Re: Failed System. Help. Marcus Whitney 03:33
Re: Failed System follow up Marcus Whitney 03:41
Interpreting OSDB Results Neeraj 06:03
why is a constraint not 'pushed down' into a subselect when this subselect is using a 'group by' ?? Frank van Vugt 06:49
Re: 50 000 000 Table entries and I have to do a keyword search HELP NEEDED Jeremy Dunn 12:43
Re: why is a constraint not 'pushed down' into a subselect when this subselect is using a 'group by' ?? Tom Lane 13:23
Re: Index oddity (still) Tom Lane 13:52
Re: 50 000 000 Table entries and I have to do a keyword search HELP NEEDED Aaron 15:16
Re: why is a constraint not 'pushed down' into a subselect when this subselect is using a 'group by' ?? Frank van Vugt 15:30
Re: why is a constraint not 'pushed down' into a subselect when this subselect is using a 'group by' ?? Tom Lane 18:04
Indexing question Stan Bielski 21:29

June 16, 2004

Thread Author Time
Re: why is a constraint not 'pushed down' into a subselect when this subselect is using a 'group by' ?? Frank van Vugt 08:42
Visual Explain Jeff 14:01
Basic Postgresql Performance Question Bill 19:15
Re: Basic Postgresql Performance Question Stephen Frost 19:35
Re: Basic Postgresql Performance Question Kevin Barnard 20:08
Re: Basic Postgresql Performance Question Scott Marlowe 20:18
Re: Basic Postgresql Performance Question Stephen Frost 20:49

June 17, 2004

Thread Author Time
Re: 50 000 000 Table entries and I have to do a keyword search HELP NEEDED Josh Berkus 00:33
Re: Visual Explain Adam Witney 11:10
Re: [PERFORM] Visual Explain Paul Thomas 12:16
Re: Visual Explain Paul Thomas 12:52
Re: Visual Explain Jeff 13:37
Re: in-transaction insert performance in 7.5devel Merlin Moncure 16:35
Re: Visual Explain Vitaly Belman 16:54
Re: Visual Explain Jeff 17:05
Re: Visual Explain Paul Thomas 17:35
Re: Visual Explain Vitaly Belman 18:13
Slow vacuum performance Patrick Hatcher 20:09

June 18, 2004

Thread Author Time
Re: Slow vacuum performance Dennis Bjorklund 04:30
Re: Slow vacuum performance Andrew McMillan 08:15
Re: *very* inefficient choice made by the planner (regarding SZUCS Gábor 08:37
Major differences between oracle and postgres performance - what can I do ? Gary Cowell 11:31
Re: Major differences between oracle and postgres performance Richard Huxton 12:07
Re: Major differences between oracle and postgres performance - what can I do ? Paul Thomas 12:09
Re: Major differences between oracle and postgres performance - what can I do ? Jeff 12:14
Re: Major differences between oracle and postgres performance Shridhar Daithankar 12:17
Re: Major differences between oracle and postgres performance pginfo 12:36
Re: Major differences between oracle and postgres performance - what can I do ? Gary Cowell 13:25
memory allocation Michael Ryan S. Puncia 13:34
Re: memory allocation Devrim GUNDUZ 13:39
Re: [BULK] Problems with vacuum! Domenico Sgarbossa 13:54
Re: Major differences between oracle and postgres performance Richard Huxton 13:56
Re: memory allocation Richard Huxton 13:58
Re: Major differences between oracle and postgres performance pginfo 13:59
Re: *very* inefficient choice made by the planner (regarding Tom Lane 14:29
Re: Major differences between oracle and postgres performance - what can I do ? Tom Lane 14:57
Re: [BULK] Problems with vacuum! Tom Lane 15:11
Re: *very* inefficient choice made by the planner (regarding Stephan Szabo 15:32

Browse Archives

Prev | Next
Jump to day: 1 2 3 4 5 6 7 8 9 10 11 13 14 15 16 17 18 20 21 22 23 24 25 26 27 28 29 30