Skip site navigation (1)
Skip section navigation (2)
Peripheral Links
pgsql-performance - July 2005
Prev | Next
2005-07-01
- Re: ported application having performance issues Dennis Bjorklund (08:57)
- planner picking more expensive plan Sam Mason (13:33)
- Re: planner picking more expensive plan Tom Lane (14:22)
- Re: planner picking more expensive plan Sam Mason (14:58)
- Re: planner picking more expensive plan John A Meinel (15:17)
- Re: planner picking more expensive plan Sam Mason (15:58)
2005-07-02
- Re: ported application having performance issues John Mendenhall (00:52)
- Planner constants for RAM resident databases Emil Briggs (01:59)
- Re: Planner constants for RAM resident databases Steve Atkins (02:08)
- Re: Planner constants for RAM resident databases John A Meinel (02:40)
- Re: Planner constants for RAM resident databases John A Meinel (03:14)
- B-Tree index not being used Madison Kelly (04:16)
- Re: planner picking more expensive plan Dennis Bjorklund (05:24)
- Re: Planner constants for RAM resident databases Emil Briggs (13:44)
- Re: B-Tree index not being used Tom Lane (13:54)
- Re: B-Tree index not being used Madison Kelly (15:20)
2005-07-03
- Re: investigating slow queries through pg_stat_activity Enrico Weigelt (22:28)
- plain inserts and deletes very slow Enrico Weigelt (22:45)
- Re: plain inserts and deletes very slow Enrico Weigelt (22:57)
- Re: plain inserts and deletes very slow Enrico Weigelt (22:57)
- Re: plain inserts and deletes very slow Steinar H. Gunderson (23:54)
2005-07-04
- Re: plain inserts and deletes very slow Enrico Weigelt (00:01)
- Re: plain inserts and deletes very slow Enrico Weigelt (00:17)
- Re: plain inserts and deletes very slow David Mitchell (00:50)
- Re: plain inserts and deletes very slow David Mitchell (01:12)
- Re: plain inserts and deletes very slow Alvaro Herrera (02:57)
- Re: plain inserts and deletes very slow David Mitchell (03:51)
- Re: plain inserts and deletes very slow Enrico Weigelt (08:57)
- Re: plain inserts and deletes very slow Enrico Weigelt (08:59)
- Re: plain inserts and deletes very slow Alvaro Herrera (14:27)
- Why the planner is not using the INDEX . David Gagnon (19:57)
- Re: Why the planner is not using the INDEX . Stephan Szabo (20:27)
- Re: plain inserts and deletes very slow Klint Gore (23:36)
2005-07-05
- Re: Why the planner is not using the INDEX . David Gagnon (00:29)
- Re: Why the planner is not using the INDEX . Christopher Kings-Lynne (01:13)
- Re: Why the planner is not using the INDEX . Bruno Wolff III (12:32)
- Re: Why the planner is not using the INDEX . Stephan Szabo (14:02)
- Re: Why the planner is not using the INDEX . Tom Lane (16:09)
- Heavy virtual memory usage on production system Alexander Stanier (16:13)
- Re: Heavy virtual memory usage on production system Tom Lane (16:55)
- Re: Why the planner is not using the INDEX . David Gagnon (17:53)
- Re: Planner constants for RAM resident databases Josh Berkus (21:33)
2005-07-06
- Re: Heavy virtual memory usage on production system Alexander Stanier (12:03)
- Re: Heavy virtual memory usage on production system Tom Lane (14:15)
- Re: Heavy virtual memory usage on production system Alexander Stanier (14:49)
- Re: Heavy virtual memory usage on production system Tom Lane (15:06)
- Data Warehousing Tuning Paul Johnson (17:15)
- Storing data and indexes in different disks Alvaro Nunes Melo (17:58)
- Re: Storing data and indexes in different disks Dmitri Bichko (18:46)
- ALTER TABLE tabla ALTER COLUMN columna SET STATISTICS number Dario (19:49)
- Re: ALTER TABLE tabla ALTER COLUMN columna SET STATISTICS number Michael Fuhr (20:07)
- CURSOR slowes down a WHERE clause 100 times? Niccolo Rigacci (21:19)
- Re: CURSOR slowes down a WHERE clause 100 times? John A Meinel (21:29)
- join and query planner Dario Pudlo (21:54)
- join and query planner Dario (22:04)
- Re: join and query planner Stephan Szabo (22:34)
2005-07-07
- Re: Data Warehousing Tuning Frank Wosczyna (00:02)
- Re: Data Warehousing Tuning Josh Berkus (00:40)
- Re: CURSOR slowes down a WHERE clause 100 times? Niccolo Rigacci (07:41)
- Re: CURSOR slowes down a WHERE clause 100 times? Niccolo Rigacci (08:13)
- Re: CURSOR slowes down a WHERE clause 100 times? Richard Huxton (09:14)
- Re: CURSOR slowes down a WHERE clause 100 times? Niccolo Rigacci (10:06)
- How to speed up delete Bendik Rognlien Johansen (11:16)
- [No subject] Jean-Max Reymond (12:42)
- Surprizing performances for Postgres on Centrino Jean-Max Reymond (12:49)
- Re: How to speed up delete PFC (12:55)
- Re: PFC (13:03)
- Need suggestion high-level suggestion on how to solve a performance problem Madison Kelly (13:13)
- Re: Surprizing performances for Postgres on Centrino Dawid Kuroczko (13:48)
- Re: CURSOR slowes down a WHERE clause 100 times? Tom Lane (13:59)
- Re: How to speed up delete Tom Lane (14:02)
- Re: Surprizing performances for Postgres on Centrino Steinar H. Gunderson (14:03)
- Re: Surprizing performances for Postgres on Centrino Alvaro Herrera (14:09)
- Re: Surprizing performances for Postgres on Centrino Jean-Max Reymond (14:23)
- Re: Surprizing performances for Postgres on Centrino Richard Huxton (14:52)
- Re: How to speed up delete Bendik Rognlien Johansen (15:03)
- Re: Need suggestion high-level suggestion on how to solve a performance problem PFC (22:21)
- Re: Need suggestion high-level suggestion on how to solve Madison Kelly (23:28)
- Re: Need suggestion high-level suggestion on how to solve a performance problem PFC (23:58)
2005-07-08
- Re: Need suggestion high-level suggestion on how to solve a performance problem Josh Berkus (01:04)
- Mount database on RAM disk? Stuart Bishop (01:32)
- Re: Mount database on RAM disk? Joshua D. Drake (03:05)
- Re: Mount database on RAM disk? Chris Browne (03:30)
- Re: plain inserts and deletes very slow Enrico Weigelt (13:46)
- Re: Select performance vs. mssql Enrico Weigelt (14:00)
- Re: Mount database on RAM disk? Rod Taylor (14:03)
- Re: Need help to decide Mysql vs Postgres Enrico Weigelt (14:43)
- Re: Why the planner is not using the INDEX . Enrico Weigelt (15:36)
- Re: Need help to decide Mysql vs Postgres Mark Lewis (16:08)
- Re: Need help to decide Mysql vs Postgres Moises Alberto Lindo Gutarra (16:22)
- cost-based vacuum Ian Westmacott (16:25)
- Re: Mount database on RAM disk? Josh Berkus (17:22)
- Re: cost-based vacuum Tom Lane (17:48)
- Re: Mount database on RAM disk? Merlin Moncure (19:21)
- Re: Select performance vs. mssql Jochem van Dieten (21:47)
- How to revoke a password Bailey, Larry (23:56)
2005-07-09
- Re: How to revoke a password Joshua D. Drake (00:09)
- Re: How to revoke a password Bailey, Larry (00:16)
- Re: How to revoke a password Alvaro Herrera (00:17)
- Re: How to revoke a password Joshua D. Drake (00:56)
- Re: How to revoke a password Michael Fuhr (00:58)
- Sorting on longer key is faster ? jobapply (18:38)
- Re: Mount database on RAM disk? Alex Stapleton (21:48)
2005-07-10
- Re: Mount database on RAM disk? Christopher Browne (04:54)
- Re: Data Warehousing Tuning Alexander Kirpa (22:07)
2005-07-11
- Re: cost-based vacuum Simon Riggs (11:31)
- Question Alejandro Lemus (12:59)
- Re: cost-based vacuum Ian Westmacott (13:07)
- Re: cost-based vacuum Tom Lane (13:28)
- Re: Question Richard Huxton (13:29)
- Re: Question Magnus Hagander (13:34)
- Re: cost-based vacuum Simon Riggs (14:51)
- Re: Question Gregory S. Williamson (23:26)
- Re: join and query planner John A Meinel (23:39)
- Re: Sorting on longer key is faster ? John A Meinel (23:42)
- Re: Sorting on longer key is faster ? Tom Lane (23:47)
2005-07-12
- Re: Sorting on longer key is faster ? John A Meinel (01:48)
- Re: Sorting on longer key is faster ? John A Meinel (01:52)
- General DB Tuning Brent Henry (06:22)
- Re: cost-based vacuum Simon Riggs (07:45)
- Re: join and query planner Bruno Wolff III (14:35)
- Projecting currentdb to more users Yves Vindevogel (16:21)
- Re: cost-based vacuum Ian Westmacott (17:50)
- Re: Projecting currentdb to more users Matthew Nuzum (18:00)
- Re: [PERFORM] Projecting currentdb to more users Mohan, Ross (18:24)
- Re: [PERFORM] Projecting currentdb to more users Scott Marlowe (18:41)
- Re: [PERFORM] Projecting currentdb to more users Mark Rae (20:06)
- Re: [PERFORM] Projecting currentdb to more users Scott Marlowe (20:11)
- Re: [PERFORM] Projecting currentdb to more users Mark Rae (20:32)
- Re: General DB Tuning Tom Arthurs (21:54)
- Re: General DB Tuning Brent Henry (23:32)
2005-07-13
- Re: General DB Tuning Tom Arthurs (00:36)
- Re: General DB Tuning Dennis (01:05)
- Re: General DB Tuning Christopher Kings-Lynne (01:17)
- Re: General DB Tuning Tom Arthurs (01:30)
- Re: General DB Tuning Brent Henry (01:36)
- Re: General DB Tuning Christopher Kings-Lynne (01:52)
- Re: General DB Tuning Tom Arthurs (01:53)
- Re: Projecting currentdb to more users Jean-Max Reymond (05:18)
- size of cache Jean-Max Reymond (08:20)
- Re: General DB Tuning Mark Rae (10:07)
- large table vs multiple smal tables Nicolas Beaume (10:08)
- Re: large table vs multiple smal tables Kenneth Marshall (12:33)
- (pas de sujet) Nicolas Beaume (13:55)
- Re: cost-based vacuum Simon Riggs (15:55)
- Re: size of cache Simon Riggs (16:07)
- Re: General DB Tuning Simon Riggs (16:10)
- Re: cost-based vacuum Ian Westmacott (18:40)
- Quad Opteron stuck in the mud Dan Harris (18:54)
- Re: cost-based vacuum Tom Lane (18:58)
- Re: Quad Opteron stuck in the mud Dan Harris (19:09)
- Re: Quad Opteron stuck in the mud John A Meinel (19:11)
- performance problems ... 100 cpu utilization Dennis (19:13)
- Re: Quad Opteron stuck in the mud Dan Harris (19:16)
- Re: Quad Opteron stuck in the mud Stephen Frost (20:17)
- Re: Quad Opteron stuck in the mud Alvaro Herrera (20:18)
- Re: Quad Opteron stuck in the mud Dan Harris (20:20)
- Re: cost-based vacuum Simon Riggs (20:39)
- Re: Quad Opteron stuck in the mud Vivek Khera (20:49)
- Re: cost-based vacuum Ian Westmacott (21:46)
- Functional index is 5 times slower than the basic one jobapply (22:35)
- Re: Quad Opteron stuck in the mud Simon Riggs (22:51)
- Indexing Function called on VACUUM and sorting ? jobapply (23:46)
2005-07-14
- Slow Query Marc McIntyre (00:06)
- JFS fastest filesystem for PostgreSQL? Jeffrey W. Baker (00:20)
- Re: performance problems ... 100 cpu utilization Qingqing Zhou (03:11)
- Re: performance problems ... 100 cpu utilization Dennis (03:28)
- Re: performance problems ... 100 cpu utilization David Mitchell (05:07)
- lots of updates on small table Alison Winters (05:08)
- Profiler for PostgreSQL Agha Asif Raza (05:58)
- Re: Quad Opteron stuck in the mud Greg Stark (06:12)
- Re: Profiler for PostgreSQL Bruce Momjian (06:27)
- Re: Quad Opteron stuck in the mud Dan Harris (06:28)
- Re: Profiler for PostgreSQL Christopher Kings-Lynne (06:29)
- JFS fastest filesystem for PostgreSQL? Jeffrey W. Baker (06:33)
- Indexing Function called on VACUUM and sorting ? jobapply (06:33)
- Re: performance problems ... 100 cpu utilization Dennis (06:54)
- Re: JFS fastest filesystem for PostgreSQL? Dmitri Bichko (07:08)
- PostgresSQL vs. Firebird Relaxin (07:19)
- Re: JFS fastest filesystem for PostgreSQL? Dawid Kuroczko (08:03)
- slow joining very large table to smaller ones Dan Harris (08:05)
- Re: JFS fastest filesystem for PostgreSQL? mudfoot (09:56)
- Re: JFS fastest filesystem for PostgreSQL? Michael Stone (10:30)
- Re: Slow Query Ragnar Hafstað (11:22)
- Re: JFS fastest filesystem for PostgreSQL? Grega Bremec (12:15)
- Re: JFS fastest filesystem for PostgreSQL? Michael Stone (13:20)
- Re: JFS fastest filesystem for PostgreSQL? Jeffrey W. Baker (13:27)
- Re: slow joining very large table to smaller ones John A Meinel (15:42)
- Re: Quad Opteron stuck in the mud Alvaro Herrera (15:47)
- Re: Quad Opteron stuck in the mud Dan Harris (16:05)
- Re: lots of updates on small table Alvaro Herrera (16:21)
- Re: lots of updates on small table Rod Taylor (16:37)
- Re: large table vs multiple smal tables Jim C. Nasby (18:26)
- Re: JFS fastest filesystem for PostgreSQL? Jim C. Nasby (18:29)
- Re: JFS fastest filesystem for PostgreSQL? Joshua D. Drake (18:37)
- Re: Quad Opteron stuck in the mud Greg Stark (20:47)
- Re: Profiler for PostgreSQL Simon Riggs (20:47)
- Re: slow joining very large table to smaller ones Dan Harris (22:29)
- Re: slow joining very large table to smaller ones John A Meinel (22:46)
- Re: slow joining very large table to smaller ones Michael Stone (22:47)