Архив рассылок [pgsql-performance]

1 декабря 2003 г.

• 06:14   Dump restoration via archive files Kamalraj Singh Madhan
• 09:10   Various Questions Evil Azrael
• 09:27   Re: Various Questions Shridhar Daithankar
• 09:45   My indexes aren't being used (according to EXPLAIN) Erik Norvelle
• 10:01   Re: Various Questions Andrew Sullivan
• 10:04   Re: My indexes aren't being used (according to EXPLAIN) Andrew Sullivan
• 10:18   Re: Dump restoration via archive files Jeff
• 10:29   Re: cross table indexes or something? Jeremiah Jahn
• 11:25   Re: Dump restoration via archive files Stephan Szabo
• 11:26   Re: My indexes aren't being used (according to EXPLAIN) Erik Norvelle
• 12:01   Re: cross table indexes or something? Richard Huxton
• 12:26   Re: cross table indexes or something? Arjen van der Meijden
• 13:31   Re: Followup - expression (functional) index use in joins Roger Ging
• 14:05   Re: Followup - expression (functional) index use in joins Tom Lane
• 15:48   Re: cross table indexes or something? Josh Berkus
• 15:58   Various Questions Evil Azrael
• 15:58   Re: Followup - expression (functional) index use in joins Roger Ging
• 17:44   A question on the query planner Jared Carr
• 18:25   Is clustering possible to enhance the performance? LIANHE SHAO
• 18:38   Re: Is clustering possible to enhance the performance? Bruce Momjian
• 20:46   Re: A question on the query planner Tom Lane

2 декабря 2003 г.

• 11:55   Update performance ... is 200,000 updates per hour what I should expect? Erik Norvelle
• 12:30   Re: Update performance ... is 200,000 updates per hour Stephan Szabo
• 12:34   Re: Update performance ... is 200,000 updates per hour what I should expect? Tom Lane
• 12:41   Re: Update performance ... is 200,000 updates per hour what I should expect? Greg Stark
• 13:18   Re: A question on the query planner Robert Treat
• 13:55   Re: A question on the query planner Jared Carr
• 15:01   Re: A question on the query planner Greg Stark
• 15:08   Re: cross table indexes or something? Jeremiah Jahn
• 15:13   Re: A question on the query planner Jared Carr
• 15:28   Re: cross table indexes or something? Josh Berkus
• 16:11   Re: A question on the query planner Greg Stark
• 16:28   Re: A question on the query planner Jared Carr
• 16:38   autovacuum daemon stops doing work after about an hour Vivek Khera
• 17:58   Re: cross table indexes or something? Neil Conway
• 18:32   Re: A question on the query planner Greg Stark
• 18:44   Re: A question on the query planner Greg Stark
• 19:18   Re: cross table indexes or something? Josh Berkus
• 19:37   Re: cross table indexes or something? Neil Conway
• 19:51   Re: A question on the query planner Tom Lane
• 21:33   Re: A question on the query planner Greg Stark
• 21:46   Re: cross table indexes or something? Christopher Kings-Lynne
• 22:00   Re: cross table indexes or something? Christopher Kings-Lynne
• 22:23   Minimum hardware requirements for Postgresql db CHEWTC@ap.nec.com.sg
• 23:53   Re: A question on the query planner Tom Lane

3 декабря 2003 г.

• 00:58   Re: Minimum hardware requirements for Postgresql db Christopher Browne
• 13:49   Re: A question on the query planner Tom Lane
• 14:27   Re: A question on the query planner Jared Carr
• 14:41   Re: Minimum hardware requirements for Postgresql db scott.marlowe
• 15:24   Re: Minimum hardware requirements for Postgresql db Greg Stark
• 15:32   Re: Minimum hardware requirements for Postgresql db Al Hulaton
• 15:33   Re: A question on the query planner Greg Stark
• 17:23   Re: Update performance ... Recommended configuration changes? erik@norvelle.net
• 17:33   Re: Update performance ... Recommended configuration Rod Taylor
• 17:41   Has anyone run on the new G5 yet Sean Shanny
• 17:54   Re: Has anyone run on the new G5 yet Sean Shanny
• 18:13   Re: Has anyone run on the new G5 yet Eric Soroos
• 18:32   sequence overhead Robert Treat
• 18:35   Re: Has anyone run on the new G5 yet Fred Moyer
• 19:18   Re: A question on the query planner Bruce Momjian
• 19:22   Re: A question on the query planner Jared Carr
• 19:56   Re: A question on the query planner Gaetano Mendola
• 19:57   Re: Has anyone run on the new G5 yet Gaetano Mendola
• 20:25   Re: Has anyone run on the new G5 yet Sean Shanny
• 23:10   Re: Minimum hardware requirements for Postgresql db CHEWTC@ap.nec.com.sg

4 декабря 2003 г.

• 01:41   Re: autovacuum daemon stops doing work after about an hour Matthew T. O'Connor
• 04:21   Re: Has anyone run on the new G5 yet Paul Tuckfield
• 08:48   Async Query Processing on Solaris Passynkov, Vadim
• 09:28   Re: Minimum hardware requirements for Postgresql db Christopher Browne
• 11:21   Re: [ADMIN] Index not used. WHY? Stephan Szabo
• 12:07   tuning questions Jack Coates
• 12:34   Re: autovacuum daemon stops doing work after about an hour Vivek Khera
• 13:00   Re: tuning questions Jeff
• 13:00   Re: tuning questions Josh Berkus
• 13:10   Re: tuning questions Rob Fielding
• 13:28   Re: Has anyone run on the new G5 yet William Yu
• 13:46   Re: tuning questions scott.marlowe
• 13:58   Re: tuning questions Dror Matalon
• 14:08   Re: tuning questions Jord Tanner
• 14:12   Re: tuning questions Andrew Sullivan
• 14:17   Re: tuning questions Josh Berkus
• 14:31   Re: tuning questions scott.marlowe
• 14:36   Re: autovacuum daemon stops doing work after about an hour Gaetano Mendola
• 14:58   Slow UPADTE, compared to INSERT Ivar Zarans
• 15:17   Re: tuning questions Jack Coates
• 15:17   Re: tuning questions Eric Soroos
• 15:24   Re: Slow UPADTE, compared to INSERT Jeff
• 15:34   Re: tuning questions Josh Berkus
• 15:37   Re: autovacuum daemon stops doing work after about an hour Vivek Khera
• 15:46   Re: autovacuum daemon stops doing work after about an hour Vivek Khera
• 15:55   Re: tuning questions Jack Coates
• 15:55   Re: Slow UPADTE, compared to INSERT Ivar Zarans
• 16:44   Re: tuning questions Jack Coates
• 16:47   Re: Slow UPADTE, compared to INSERT Ivar Zarans
• 16:50   Re: Slow UPADTE, compared to INSERT William Yu
• 16:53   Re: tuning questions Richard Huxton
• 16:55   Re: Slow UPADTE, compared to INSERT Richard Huxton
• 17:00   Re: autovacuum daemon stops doing work after about an hour Matthew T. O'Connor
• 17:20   Re: autovacuum daemon stops doing work after about an hour Vivek Khera
• 17:22   Re: autovacuum daemon stops doing work after about an hour Vivek Khera
• 17:25   Re: tuning questions Josh Berkus
• 17:26   Re: autovacuum daemon stops doing work after about an Larry Rosenman
• 17:29   Re: tuning questions scott.marlowe
• 17:37   Re: autovacuum daemon stops doing work after about an Vivek Khera
• 18:13   Re: Slow UPADTE, compared to INSERT Ivar Zarans
• 18:38   Re: Slow UPADTE, compared to INSERT Richard Huxton
• 18:46   Re: Slow UPADTE, compared to INSERT Richard Huxton
• 19:00   Re: tuning questions Eric Soroos
• 19:17   Re: tuning questions Jack Coates
• 19:20   Re: tuning questions Jack Coates
• 19:48   Re: tuning questions Richard Huxton
• 20:33   Re: tuning questions Jack Coates
• 21:45   Re: Slow UPADTE, compared to INSERT Ivar Zarans
• 22:08   Re: Slow UPADTE, compared to INSERT Ivar Zarans
• 22:14   Re: Slow UPADTE, compared to INSERT Christopher Kings-Lynne

5 декабря 2003 г.

• 00:53   Re: tuning questions Eric Soroos
• 04:09   Re: [ADMIN] Index not used. WHY? Andrei Bintintan
• 04:40   Re: [ADMIN] Index not used. WHY? Shridhar Daithankar
• 05:13   Re: tuning questions Thierry Missimilly
• 06:08   Re: Slow UPADTE, compared to INSERT Richard Huxton
• 08:39   Re: Slow UPADTE, compared to INSERT Ivar Zarans
• 08:50   Re: Slow UPADTE, compared to INSERT Shridhar Daithankar
• 09:13   Re: Slow UPADTE, compared to INSERT Ivar Zarans
• 09:24   Re: Slow UPADTE, compared to INSERT Richard Huxton
• 09:52   Re: Slow UPADTE, compared to INSERT Shridhar Daithankar
• 11:35   Re: [ADMIN] Index not used. WHY? Stephan Szabo
• 12:48   Re: Slow UPADTE, compared to INSERT Ivar Zarans
• 12:53   Re: Slow UPADTE, compared to INSERT Ivar Zarans
• 13:06   Re: Slow UPADTE, compared to INSERT Mike C. Fletcher
• 13:12   Re: Slow UPADTE, compared to INSERT Mike C. Fletcher
• 13:27   Re: tuning questions Josh Berkus
• 13:29   Re: Slow UPADTE, compared to INSERT Greg Stark
• 15:29   Slightly OT -- Xeon versus Opteron Comparison William Yu
• 17:00   query using cpu nearly 100%, why? LIANHE SHAO
• 17:52   Help tracking down problem with inserts slowing down... Steve Wampler
• 19:39   Re: Help tracking down problem with inserts slowing Neil Conway
• 21:23   Re: tuning questions Jack Coates
• 22:55   Re: Help tracking down problem with inserts slowing down... Robert Treat

6 декабря 2003 г.

• 09:19   Re: Has anyone run on the new G5 yet Bruce Momjian
• 13:09   Pgbench results Rob Sell
• 13:47   Re: query using cpu nearly 100%, why? Richard Huxton
• 15:42   Re: query using cpu nearly 100%, why? Neil Conway
• 15:54   Re: Slow UPADTE, compared to INSERT Neil Conway

7 декабря 2003 г.

• 10:28   Re: Help tracking down problem with inserts slowing down... Steve Wampler
• 10:53   Re: Help tracking down problem with inserts slowing down... Steve Wampler
• 12:54   Re: Help tracking down problem with inserts slowing down... Tom Lane
• 13:29   Re: Help tracking down problem with inserts slowing Steve Wampler
• 17:16   Re: autovacuum daemon stops doing work after about an Bruce Momjian
• 20:47   Re: autovacuum daemon stops doing work after about an hour Gaetano Mendola
• 21:29   Re: autovacuum daemon stops doing work after about an hour Christopher Browne

8 декабря 2003 г.

• 01:28   Re: autovacuum daemon stops doing work after about an hour Matthew T. O'Connor
• 11:15   Re: Help tracking down problem with inserts slowing Steve Wampler
• 11:36   Re: Help tracking down problem with inserts slowing Tom Lane
• 13:44   Re: tuning questions Jack Coates
• 14:41   Re: autovacuum daemon stops doing work after about an hour Vivek Khera
• 15:21   Re: tuning questions Tom Lane

9 декабря 2003 г.

• 04:32   Re: Problem with insert into select... Neil Conway
• 12:58   Re: tuning questions Jack Coates
• 13:08   Re: tuning questions Matt Clark
• 13:36   Re: tuning questions Josh Berkus
• 15:57   Slow UPDATE, INSERT OK Ivar Zarans
• 16:00   TRUNCATE veeeery slow compared to DELETE in 7.4 Hartmut Raschick
• 16:03   Re: [linux-lvm] RE: [ADMIN] backup/restore - another Murthy Kambhampaty
• 16:05   Async Query Processing on Solaris Passynkov, Vadim
• 19:21   Index problem or function problem? LIANHE SHAO

10 декабря 2003 г.

• 01:56   Solaris Performance (Again) Mark Kirkwood
• 09:54   Re: Solaris Performance (Again) Jeff
• 13:20   Re: TRUNCATE veeeery slow compared to DELETE in 7.4 Josh Berkus
• 15:16   Re: Solaris Performance (Again) Neil Conway
• 15:30   ... nbarraza@uolsinectis.com.ar
• 15:55   Re: TRUNCATE veeeery slow compared to DELETE in 7.4 Tom Lane
• 16:35   Re: Stephan Szabo

11 декабря 2003 г.

• 00:22   Performance problems with a higher number of clients Alfranio Correia Junior
• 02:04   Re: Solaris Performance (Again) Mark Kirkwood
• 02:09   Re: Solaris Performance (Again) Mark Kirkwood
• 02:37   Re: Performance problems with a higher number of clients Shridhar Daithankar
• 09:29   Re: Performance problems with a higher number of clients Jeff
• 10:59   Re: Performance problems with a higher number of clients Tom Lane
• 12:01   hints in Postgres? sandra ruiz
• 12:22   Re: hints in Postgres? Pavel Stehule
• 12:46   Command nbarraza@uolsinectis.com.ar
• 13:00   Re: hints in Postgres? Christopher Browne
• 16:20   Hardware suggestions for Linux/PGSQL server Jeff Bohmer
• 16:28   Re: hints in Postgres? Bruno Wolff III
• 17:00   Re: Hardware suggestions for Linux/PGSQL server William Yu
• 18:02   Re: Hardware suggestions for Linux/PGSQL server Jeff Bohmer
• 19:08   Re: Hardware suggestions for Linux/PGSQL server scott.marlowe
• 20:00   Re: Hardware suggestions for Linux/PGSQL server William Yu
• 21:17   Measuring execution time for sql called from PL/pgSQL Aram Kananov
• 22:35   Re: Performance problems with a higher number of clients Alfranio Tavares Correia Junior

12 декабря 2003 г.

• 02:36   Re: Hardware suggestions for Linux/PGSQL server Shridhar Daithankar
• 02:50   fsync method checking Bruce Momjian
• 03:47   Re: Measuring execution time for sql called from PL/pgSQL Tomasz Myrta
• 04:28   Query plan - now what? David Shadovitz
• 05:14   Re: Query plan - now what? Shridhar Daithankar
• 06:49   Re: TRUNCATE veeeery slow compared to DELETE in 7.4 Hartmut Raschick
• 08:40   ODBC Driver generates a too big "windows swap file" and it's too slow Rhaoni Chiu Pereira
• 11:34   Re: Query plan - now what? Tom Lane
• 11:47   Re: Query plan - now what? David Shadovitz
• 12:13   Re: [ADMIN] ODBC Driver generates a too big "windows swap file" and scott.marlowe
• 12:16   Tables Without OIDS and its effect Sai Hertz And Control Systems
• 12:53   Re: Query plan - now what? Tom Lane
• 12:59   Re: Hardware suggestions for Linux/PGSQL server William Yu
• 14:05   Performance related to size of tables nbarraza@uolsinectis.com.ar
• 17:11   Re: Performance related to size of tables Mark Kirkwood
• 17:29   Re: [HACKERS] fsync method checking Tom Lane
• 18:29   Update on putting WAL on ramdisk/ William Yu
• 18:37   Re: Update on putting WAL on ramdisk/ Russell Garrett
• 18:59   Re: Update on putting WAL on ramdisk/ William Yu
• 19:11   Re: Tables Without OIDS and its effect Neil Conway

13 декабря 2003 г.

• 06:34   Re: Tables Without OIDS and its effect Sai Hertz And Control Systems
• 14:39   a lot of problems with pg 7.4 Kari Lavikka
• 18:57   Re: Hardware suggestions for Linux/PGSQL server Jeff Bohmer
• 19:01   Re: Hardware suggestions for Linux/PGSQL server Jeff Bohmer

14 декабря 2003 г.

• 01:42   Re: Tuning for mid-size server Bruce Momjian
• 01:44   Update performance doc Bruce Momjian
• 03:24   Re: Query plan - now what? David Shadovitz
• 05:55   Re: a lot of problems with pg 7.4 Tarhon-Onu Victor
• 13:14   Re: a lot of problems with pg 7.4 Dennis Bjorklund
• 13:56   Re: Tuning for mid-size server Andrew Sullivan
• 18:53   Re: Tables Without OIDS and its effect Tom Lane
• 22:10   Re: Tables Without OIDS and its effect Neil Conway

15 декабря 2003 г.

• 00:17   Re: Hardware suggestions for Linux/PGSQL server Andrew G. Hammond
• 01:30   Re: Hardware suggestions for Linux/PGSQL server Christopher Browne
• 12:38   Re: Hardware suggestions for Linux/PGSQL server Jeff Bohmer
• 13:01   Unsubscribe Rhaoni Chiu Pereira
• 14:06   Re: Index problem or function problem? Tom Lane
• 14:22   Re: TRUNCATE veeeery slow compared to DELETE in 7.4 Tom Lane

16 декабря 2003 г.

• 11:42   Postgres respond after toomany times to a query view Claudia D'amato
• 12:57   Re: a lot of problems with pg 7.4 scott.marlowe
• 13:12   Nested loop performance Nick Fankhauser
• 17:07   Why is VACUUM ANALYZE so slow? David Shadovitz
  17:08   Re: [HACKERS] fsync method checking Manfred Spraul
  17:08   Optimizing FK & PK performance... Sean P. Thomas
  17:08   Excessive rows/tuples seriously degrading query performance Chadwick, Russell
  17:13   Re: Measuring execution time for sql called from PL/pgSQL David Shadovitz
  17:15   Nested loop question Nick Fankhauser - Doxpop
  17:15   Re: [HACKERS] fsync method checking Zeugswetter Andreas SB SD
  17:29   Re: Excessive rows/tuples seriously degrading query Hannu Krosing
  18:48   Re: Optimizing FK & PK performance... Neil Conway
  18:51   Re: Why is VACUUM ANALYZE
  so slow? Neil Conway
  19:50   update slows down in pl/pgsql function Jenny Zhang
  19:55   Re: [GENERAL] update slows down in pl/pgsql function Stephan Szabo
  19:56   Re: Nested loop performance Richard Poole
  20:05   Re: [GENERAL] update slows down in pl/pgsql function Jenny Zhang
  21:14   Re: Optimizing FK & PK performance... Christopher Kings-Lynne
  21:17   Re: Nested loop performance Stephan Szabo

  17 декабря 2003 г.

  • 01:30   Why is restored database faster? David Shadovitz
  • 01:31   Re: Why is VACUUM ANALYZE
  so slow? David Shadovitz
  02:00   Re: Why is restored database faster? Neil Conway
  02:31   Re: Why is restored database faster? Shridhar Daithankar
  02:43   Re: Why is restored database faster? Dennis Bjorklund
  05:52   Re: Nested loop question Richard Huxton
  11:26   Re: Nested loop performance Nick Fankhauser
  11:26   Re: Nested loop question Nick Fankhauser
  11:27   Re: Nested loop performance Nick Fankhauser
  14:35   Re: Excessive rows/tuples seriously degrading query Tom Lane
  15:57   Adding RAM: seeking advice & warnings of hidden "gotchas" Nick Fankhauser
  17:39   Re: Adding RAM: seeking advice & warnings of hidden "gotchas" Eric Soroos
  18:19   Re: Adding RAM: seeking advice & warnings of hidden "gotchas" Matt Clark

  18 декабря 2003 г.

  • 00:00   Re: Why is restored database faster? David Shadovitz
  • 02:48   Re: Why is restored database faster? Shridhar Daithankar
  • 11:13   Re: Why is restored database faster? Dennis Bjorklund
  • 14:44   why do optimizer parameters have to be set manually? Marinos J. Yannikos
  • 15:57   Re: why do optimizer parameters have to be set manually? Tom Lane
  • 16:31   Re: why do optimizer parameters have to be set manually? Christopher Browne
  • 19:19   is it possible to get the optimizer to use indexes with a like clause Dave Cramer
  • 21:34   Re: is it possible to get the optimizer to use indexes Christopher Kings-Lynne
  • 23:09   Re: is it possible to get the optimizer to use indexes Dave Cramer
  • 23:31   Re: is it possible to get the optimizer to use indexes with a like clause Christopher Browne
  • 23:37   Re: is it possible to get the optimizer to use indexes Stephan Szabo
  • 23:44   Re: is it possible to get the optimizer to use indexes Tom Lane

  19 декабря 2003 г.

  • 05:51   Re: is it possible to get the optimizer to use indexes Dave Cramer
  • 09:52   Re: why do optimizer parameters have to be set manually? Marinos J. Yannikos
  • 10:39   Re: is it possible to get the optimizer to use indexes Tom Lane
  • 11:08   Re: why do optimizer parameters have to be set manually? Tom Lane
  • 12:01   Re: is it possible to get the optimizer to use indexes Erki Kaldjärv
  • 14:06   Re: why do optimizer parameters have to be set manually? William Yu

  22 декабря 2003 г.

  • 06:52   "select max/count(id)" not using index Ryszard Lach
  • 06:57   Re: "select max/count(id)" not using index Christopher Kings-Lynne
  • 07:03   Re: "select max/count(id)" not using index Pavel Stehule
  • 07:04   Re: "select max/count(id)" not using index Tomasz Myrta
  • 11:29   Re: "select max/count(id)" not using index Evil Azrael
  • 16:38   Re: [HACKERS] fsync method checking Zeugswetter Andreas SB SD
  • 16:38   general peformance question Conny Thimren
  • 16:39   Re: is it possible to get the optimizer to use indexes Doug McNaught
  • 16:39   general performance question Conny Thimren
  • 16:39   postgresql performance on linux port Michael Guerin
  • 16:47   Re: general peformance question Rod Taylor
  • 18:33   Re: postgresql performance on linux port Tom Lane
  • 18:50   Re: general peformance question scott.marlowe

  24 декабря 2003 г.

  • 09:59   Re: is it possible to get the optimizer to use indexes Dave Cramer
  • 20:53   mnogosearch under 7.4 ... Marc G. Fournier
  • 21:06   Re: postgresql performance on linux port Michael Guerin
  • 21:06    Michael Rothschild
  • 22:48   Re: Christopher Kings-Lynne

  25 декабря 2003 г.

  • 12:29   Re: Tom Lane

  26 декабря 2003 г.

  • 20:12   What's faster? Keith Bottner
  • 20:49   Re: What's faster? Tom Lane
  • 21:07   Re: What's faster? Mike Nolan

  27 декабря 2003 г.

  • 00:01   Re: What's faster? Tom Lane
  • 06:52   Re: What's faster? D'Arcy J.M. Cain
  • 14:31   Re: What's faster? Tom Lane

  29 декабря 2003 г.

  • 12:36   Question about difference in performance of 2 queries on large table Sean Shanny
  • 12:49   Re: Question about difference in performance of 2 queries on large table Tom Lane
  • 12:50   Re: Question about difference in performance of 2 queries Dennis Bjorklund
  • 13:45   Re: Question about difference in performance of 2 queries Sean Shanny
  • 14:47   Re: Question about difference in performance of 2 queries Sean Shanny
  • 15:26   Re: Question about difference in performance of 2 queries Sean Shanny
  • 15:40   Re: Question about difference in performance of 2 queries Tom Lane
  • 15:53   Re: Question about difference in performance of 2 queries Sean Shanny
  • 16:34   deferred foreign keys Vivek Khera

  30 декабря 2003 г.

  • 11:03   Re: Question about difference in performance of 2 queries Nicholas Shanny
  • 12:33   DELETE ... WHERE ctid IN (...) vs. Iteration Jonathan Gardner

  31 декабря 2003 г.

  • 13:18   Re: deferred foreign keys Vivek Khera

  Есть вопросы? Напишите нам!

  Соглашаюсь с условиями обработки персональных данных и Политикой конфиденциальности

  Отправить
  ✖