Mailing lists [pgsql-performance]

1 March 2003

• 21:30   Re: ABOUT YOUR CREDIT........... eyr Orito

4 March 2003

• 03:48   Slow performance with join on many fields Alex Johnson
• 04:27   Re: Slow performance with join on many fields Tom Lane
• 05:46   Re: Slow performance with join on many fields Alex Johnson
• 12:44   Slow query performance on large table Paul McKay
• 13:09   Re: Slow query performance on large table Tomasz Myrta
• 13:13   Re: Slow query performance on large table Tom Lane
• 13:15   Re: Slow query performance on large table Andrew Sullivan
• 14:10   Re: Slow query performance on large table Paul McKay
• 14:38   Re: Slow query performance on large table Andreas Pflug
• 15:02   Re: Slow query performance on large table Robert Treat
• 15:15   Re: Slow query performance on large table Josh Berkus
• 15:18   Re: Slow query performance on large table Paul McKay
• 15:20   Re: Slow query performance on large table Tom Lane
• 15:20   Re: Slow query performance on large table Tomasz Myrta
• 15:29   Re: Slow query performance on large table Tomasz Myrta
• 15:30   PostgreSQL Performance Issue on Mail Server Josh Berkus
• 15:53   Re: Slow query performance on large table Tom Lane

5 March 2003

• 04:34   Re: Slow query performance on large table Andreas Pflug
• 07:49   Re: Slow query performance on large table Paul McKay
• 08:04   Re: Slow query performance on large table Tomasz Myrta
• 08:26   Re: Slow query performance on large table Paul McKay
• 09:14   Planner matching constants across tables in a join Richard Huxton
• 10:42   Re: Planner matching constants across tables in a join Greg Stark
• 11:55   Re: OIDs as keys Neil Conway
• 12:25   Re: Planner matching constants across tables in a join Richard Huxton
• 12:29   Re: OIDs as keys Rod Taylor
• 13:02   Re: Planner matching constants across tables in a join Greg Stark
• 13:08   Re: Planner matching constants across tables in a join Tom Lane
• 13:21   Re: OIDs as keys Tom Lane
• 14:13   Re: Planner matching constants across tables in a join Richard Huxton
• 17:00   Re: Planner matching constants across tables in a Josh Berkus
• 17:26   Re: Planner matching constants across tables in a Richard Huxton
• 17:32   Re: Planner matching constants across tables in a Richard Huxton
• 18:26   Batch copying of databases Tim Mohler
• 19:11   Re: Batch copying of databases Josh Berkus

6 March 2003

• 04:53   Re: Batch copying of databases Shridhar Daithankar
• 13:00   How to notice column changes in trigger Andreas Pflug
• 14:01   Re: How to notice column changes in trigger Oliver Elphick
• 14:09   Re: How to notice column changes in trigger Andreas Pflug
• 15:06   Re: How to notice column changes in trigger Josh Berkus
• 16:51   ISNULL performance tweaks Matt Mello
• 17:03   Re: ISNULL performance tweaks Josh Berkus
• 17:11   Re: ISNULL performance tweaks Josh Berkus
• 18:19   Re: Index File growing big. Bruce Momjian
• 19:11   Re: OIDs as keys Bruce Momjian
• 19:13   Re: OIDs as keys Bruce Momjian
• 19:14   Re: OIDs as keys Tom Lane
• 19:16   Re: OIDs as keys Bruce Momjian
• 19:23   Re: OIDs as keys Neil Conway
• 21:35   Re: Write ahead logging Rod Taylor
• 22:37   Re: [COMMITTERS] pgsql-server/ /configure /configure.in rc/incl ... Sean Chittenden
• 22:47   Re: [COMMITTERS] pgsql-server/ /configure /configure.in rc/incl ... Neil Conway
• 23:51   Re: OIDs as keys Bruce Momjian

7 March 2003

• 03:38   Re: [ADMIN] New Interface for Win Aspire Something
• 04:05   Re: [COMMITTERS] pgsql-server/ /configure /configure.in rc/incl ... Sean Chittenden
• 06:44   Re: Write ahead logging Matthias Meixner
• 12:29   Re: [COMMITTERS] pgsql-server/ /configure /configure.in rc/incl ... Tom Lane
• 19:09   Stored Procedures and compiling Daniel Bruce Lynes
• 19:46   Re: [COMMITTERS] pgsql-server/ /configure /configure.in rc/incl ... Sean Chittenden
• 22:15   Index / Performance issues Lucas Adamski
• 22:34   Re: Index / Performance issues scott.marlowe

8 March 2003

• 00:39   Re: Index / Performance issues Greg Stark
• 01:13   Re: Stored Procedures and compiling Tom Lane
• 08:15   Re: Slow query performance on large table Manfred Koizar
• 16:22   Re: Stored Procedures and compiling Daniel Bruce Lynes
• 18:01   Re: OIDs as keys daniel alvarez
• 18:09   Re: OIDs as keys Tom Lane
• 18:16   Re: OIDs as keys daniel alvarez

10 March 2003

• 14:05   Re: OIDs as keys Bruce Momjian
• 14:56   Re: Index / Performance issues scott.marlowe
• 16:57   Large difference between elapsed time and run time for queries Scott Buchan
• 18:07   Re: Large difference between elapsed time and run time for queries Tom Lane

11 March 2003

• 01:44   Re: Index / Performance issues Kevin Brown
• 06:46   Re: Large difference between elapsed time and run time Nikk Anderson
• 12:17   Re: Large difference between elapsed time and run time Jeffrey D. Brower
• 12:30   Re: Large difference between elapsed time and run time Nikk Anderson
• 12:47   Re: Large difference between elapsed time and run time Jeffrey D. Brower
• 18:23   Re: Large difference between elapsed time and run time for queries Scott Buchan
• 18:52   Re: Large difference between elapsed time and run time scott.marlowe

12 March 2003

• 18:49   Postgresql performance Enix Empreendimentos e Construções Ltda.
• 19:39   Re: Postgresql performance Chad Thompson
• 19:49   Re: Postgresql performance Rod Taylor
• 20:38   speeding up COUNT and DISTINCT queries Max Baker
• 20:52   Re: speeding up COUNT and DISTINCT queries Rod Taylor
• 20:55   Re: speeding up COUNT and DISTINCT queries Chad Thompson
• 21:39   Re: speeding up COUNT and DISTINCT queries Jean-Luc Lachance
• 21:49   Re: speeding up COUNT and DISTINCT queries Manfred Koizar
• 23:00   Re: speeding up COUNT and DISTINCT queries Max Baker
• 23:55   Re: speeding up COUNT and DISTINCT queries Max Baker

13 March 2003

• 00:00   Re: speeding up COUNT and DISTINCT queries Joe Conway
• 00:05   Re: speeding up COUNT and DISTINCT queries Max Baker
• 00:19   Re: speeding up COUNT and DISTINCT queries Christopher Kings-Lynne
• 13:43   Re: speeding up COUNT and DISTINCT queries Greg Stark
• 18:05   Re: speeding up COUNT and DISTINCT queries Robert Treat
• 18:22   Re: speeding up COUNT and DISTINCT queries Max Baker
• 20:27   Re: Postgresql performance Hannu Krosing

14 March 2003

• 15:12   Re: speeding up COUNT and DISTINCT queries Josh Berkus

16 March 2003

• 04:01   postgresql meltdown on PlanetMath.org Aaron Krowne
• 04:12   Re: postgresql meltdown on PlanetMath.org Sean Chittenden
• 04:26   Re: postgresql meltdown on PlanetMath.org Tom Lane
• 04:39   Re: postgresql meltdown on PlanetMath.org Joe Conway
• 05:52   Re: postgresql meltdown on PlanetMath.org Aaron Krowne
• 06:06   Re: postgresql meltdown on PlanetMath.org Aaron Krowne
• 06:21   Re: postgresql meltdown on PlanetMath.org Sean Chittenden
• 06:30   Re: postgresql meltdown on PlanetMath.org Aaron Krowne
• 06:36   Re: postgresql meltdown on PlanetMath.org Sean Chittenden
• 06:37   Re: postgresql meltdown on PlanetMath.org Tom Lane
• 09:31   Re: postgresql meltdown on PlanetMath.org Joe Conway

17 March 2003

• 00:08   Re: postgresql meltdown on PlanetMath.org Christopher Kings-Lynne
• 04:05   Re: postgresql meltdown on PlanetMath.org Logan Bowers
• 04:10   Re: postgresql meltdown on PlanetMath.org Sean Chittenden
• 04:19   Re: postgresql meltdown on PlanetMath.org Neil Conway
• 04:29   Re: postgresql meltdown on PlanetMath.org Sean Chittenden
• 04:34   Re: postgresql meltdown on PlanetMath.org Tom Lane
• 13:58   Re: postgresql meltdown on PlanetMath.org Greg Stark
• 14:11   Re: postgresql meltdown on PlanetMath.org Tom Lane
• 15:12   Re: postgresql meltdown on PlanetMath.org Chris Sutton
• 15:38   Performance on large data transformations Josh Berkus
• 16:33   Re: postgresql meltdown on PlanetMath.org Max Baker
• 17:20   Re: postgresql meltdown on PlanetMath.org Neil Conway
• 17:26   Re: postgresql meltdown on PlanetMath.org Tom Lane
• 17:47   Re: postgresql meltdown on PlanetMath.org Andrew Sullivan
• 18:14   Re: Performance on large data transformations Ron Mayer
• 18:46   Re: postgresql meltdown on PlanetMath.org Tom Lane
• 20:46   Re: postgresql meltdown on PlanetMath.org Kendrick C. Wilson
• 21:14   Re: postgresql meltdown on PlanetMath.org Lucas Adamski
• 23:34   Re: postgresql meltdown on PlanetMath.org Christopher Kings-Lynne

18 March 2003

• 00:31   Re: postgresql meltdown on PlanetMath.org Aaron Krowne
• 00:34   Re: postgresql meltdown on PlanetMath.org Logan Bowers
• 00:44   Re: postgresql meltdown on PlanetMath.org Christopher Kings-Lynne
• 00:51   Re: postgresql meltdown on PlanetMath.org Tom Lane
• 12:59   Re: postgresql meltdown on PlanetMath.org Chris Sutton
• 13:19   Re: postgresql meltdown on PlanetMath.org Kendrick C. Wilson
• 14:26   Re: postgresql meltdown on PlanetMath.org Josh Berkus

19 March 2003

• 00:29   Re: ABOUT YOUR CREDIT......... lquwj Lodovico
• 17:53   Re: postgresql meltdown on PlanetMath.org Manfred Koizar

20 March 2003

• 16:55   Make PGSQL faster Torsten Schulz
• 18:45   Page Size in Future Releases Kendrick C. Wilson
• 19:16   just to get some opinion on my configuration Guillaume Houssay
• 19:41   Help with LIKE David Olbersen
• 19:55   Re: Help with LIKE Josh Berkus
• 21:01   Re: postgresql meltdown on PlanetMath.org Florian Weimer
• 21:19   Re: Help with LIKE David Olbersen
• 21:35   Re: Help with LIKE David Olbersen
• 23:27   Re: Help with LIKE Josh Berkus

21 March 2003

• 00:06   Re: Help with LIKE Tom Lane
• 01:39   Re: Page Size in Future Releases Shridhar Daithankar
• 01:48   Re: postgresql meltdown on PlanetMath.org Shridhar Daithankar
• 01:51   Re: Page Size in Future Releases Christopher Kings-Lynne
• 02:04   Re: Page Size in Future Releases Josh Berkus
• 04:18   Re: postgresql meltdown on PlanetMath.org Tom Lane
• 22:15   Re: Page Size in Future Releases Tom Lane

22 March 2003

• 00:10   Re: Make PGSQL faster Andrew McMillan

23 March 2003

• 06:45   Re: Page Size in Future Releases Mario Weilguni
• 15:38   Slow update of indexed column with many nulls bsamwel@xs4all.nl
• 15:58   Adding a foreign key constraint is extremely slow bsamwel@xs4all.nl
• 17:30   Re: Adding a foreign key constraint is extremely slow Stephan Szabo
• 19:55   Re: Slow update of indexed column with many nulls Josh Berkus

24 March 2003

• 16:45   Slow query Oleg Lebedev
• 16:54   Re: Slow query Josh Berkus
• 16:59   Re: Slow query Oleg Lebedev
• 17:03   Re: Slow query Stephan Szabo
• 17:16   Re: Slow query Oleg Lebedev
• 17:47   Re: Slow query Josh Berkus
• 18:25   Re: Slow query Oleg Lebedev
• 18:48   Re: Slow query Tom Lane
• 19:42   Re: Slow query Oleg Lebedev
• 20:08   Re: Slow query Tom Lane
• 20:33   Re: Slow query Oleg Lebedev

25 March 2003

• 01:26   Re: Slow query Nikolaus Dilger
• 11:12   Finding the PID keeping a transaction open Andrew Sullivan
• 12:37   Re: Finding the PID keeping a transaction open Tom Lane
• 13:30   Re: Finding the PID keeping a transaction open Andrew Sullivan
• 18:32   ... dharana@gamersmafia.com

26 March 2003

• 00:34   What's better: one huge database or several smaller ones? dharana
• 08:52    Abhishek Sharma
• 12:17   Re: Adding a foreign key constraint is extremely slow Greg Stark
• 15:08   Re: Adding a foreign key constraint is extremely slow Bart Samwel

27 March 2003

• 14:58   max_fsm settings Robert D Oden
• 19:11   Re: max_fsm settings Robert Treat

28 March 2003

• 13:42   slow query - where not in Jeremiah Elliott
• 13:59   Re: slow query - where not in Bruno Wolff III
• 14:20   Re: slow query - where not in Greg Stark
• 14:50   Re: slow query - where not in Michael Paesold
• 15:04   calling analyze from a stored procedure in C Ulli Mueckstein
• 15:54   Re: slow query - where not in Bruno Wolff III
• 19:03   Re: slow query - where not in Jeremiah Elliott

29 March 2003

• 07:49   Index not used, performance problem Andreas Kostyrka
• 11:48   Re: Index not used, performance problem Christopher Kings-Lynne
• 13:34   Re: Index not used, performance problem Andrew Sullivan
• 14:48   Re: Index not used, performance problem John K. Herreshoff
• 14:57   Re: Index not used, performance problem Andreas Kostyrka
• 14:58   Re: Index not used, performance problem Jord Tanner
• 14:59   Re: Index not used, performance problem Andreas Kostyrka
• 15:54   Re: Index not used, performance problem Matt Mello
• 19:16   Bad perfomance of pl/pgsql-function on new server Wil Peters
• 21:14   Re: Index not used, performance problem Tom Lane
• 21:25   Re: Bad perfomance of pl/pgsql-function on new server Tom Lane

31 March 2003

• 13:46   WAL monitoring and optimizing Marco Colombo
• 15:54   Re: WAL monitoring and optimizing Tom Lane
• 16:28   Re: Index not used, performance problem scott.marlowe
• 16:54   Re: Index not used, performance problem Tom Lane
• 18:55   ext3 filesystem / linux 7.3 Shankar K
• 19:13   30-70 seconds query... alexandre :: aldeia digital
• 20:13   Re: 30-70 seconds query... Tomasz Myrta
• 20:17   Re: 30-70 seconds query... Tom Lane
• 20:58   Re: 30-70 seconds query... Tom Lane
• 21:48   Re: 30-70 seconds query... scott.marlowe