Peripheral Links

• Home
• About
• Download
• Documentation
• Community
• Developers
• Support
• Your account

pgsql-performance - December 2003

2003-12-01

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

2003-12-02

• Re: A question on the query planner Tom Lane (00:45)
• Update performance ... is 200,000 updates per hour what I should expect? Erik Norvelle (15:53)
• Re: Update performance ... is 200,000 updates per hour Stephan Szabo (16:29)
• Re: Update performance ... is 200,000 updates per hour what I should expect? Tom Lane (16:32)
• Re: Update performance ... is 200,000 updates per hour what I should expect? Greg Stark (16:40)
• Re: A question on the query planner Robert Treat (17:16)
• Re: A question on the query planner Jared Carr (17:55)
• Re: [linux-lvm] RE: [PERFORM] backup/restore - another Murthy Kambhampaty (18:11)
• Re: A question on the query planner Greg Stark (18:59)
• Re: cross table indexes or something? Jeremiah Jahn (19:08)
• Re: A question on the query planner Jared Carr (19:14)
• Re: cross table indexes or something? Josh Berkus (19:27)
• Re: A question on the query planner Greg Stark (20:11)
• Re: A question on the query planner Jared Carr (20:29)
• autovacuum daemon stops doing work after about an hour Vivek Khera (20:37)
• Re: cross table indexes or something? Neil Conway (21:57)
• Re: A question on the query planner Greg Stark (22:32)
• Re: A question on the query planner Greg Stark (22:43)
• Re: cross table indexes or something? Josh Berkus (23:04)
• Re: cross table indexes or something? Neil Conway (23:37)
• Re: A question on the query planner Tom Lane (23:50)

2003-12-03

• Re: A question on the query planner Greg Stark (01:33)
• Re: cross table indexes or something? Christopher Kings-Lynne (01:50)
• Re: cross table indexes or something? Christopher Kings-Lynne (02:04)
• Minimum hardware requirements for Postgresql db CHEWTC (02:22)
• Re: A question on the query planner Tom Lane (03:53)
• Re: Minimum hardware requirements for Postgresql db Christopher Browne (04:44)
• Re: A question on the query planner Tom Lane (17:49)
• Re: Minimum hardware requirements for Postgresql db scott.marlowe (18:22)
• Re: A question on the query planner Jared Carr (18:27)
• Slow UPDATE, INSERT OK Ivar Zarans (18:29)
• Re: Minimum hardware requirements for Postgresql db Greg Stark (19:23)
• Re: Minimum hardware requirements for Postgresql db Al Hulaton (19:31)
• Re: A question on the query planner Greg Stark (19:32)
• Re: Update performance ... Recommended configuration changes? erik (21:22)
• Re: Update performance ... Recommended configuration Rod Taylor (21:33)
• Has anyone run on the new G5 yet Sean Shanny (21:40)
• Re: Has anyone run on the new G5 yet Sean Shanny (21:54)
• Re: Has anyone run on the new G5 yet Eric Soroos (22:12)
• sequence overhead Robert Treat (22:32)
• Re: Has anyone run on the new G5 yet Fred Moyer (22:35)
• Re: A question on the query planner Bruce Momjian (23:17)
• Re: A question on the query planner Jared Carr (23:21)
• Re: Has anyone run on the new G5 yet Gaetano Mendola (23:50)
• Re: A question on the query planner Gaetano Mendola (23:54)

2003-12-04

• Re: Has anyone run on the new G5 yet Sean Shanny (00:24)
• Re: Minimum hardware requirements for Postgresql db CHEWTC (03:09)
• Re: autovacuum daemon stops doing work after about an hour Matthew T. O'Connor (05:38)
• Async Query Processing on Solaris Passynkov, Vadim (06:22)
• Re: Has anyone run on the new G5 yet Paul Tuckfield (08:24)
• Async Query Processing on Solaris Passynkov, Vadim (12:48)
• Re: Minimum hardware requirements for Postgresql db Christopher Browne (13:10)
• Index not used. WHY? Andrei Bintintan (14:57)
• Re: Index not used. WHY? Stephan Szabo (15:19)
• tuning questions Jack Coates (16:06)
• Re: autovacuum daemon stops doing work after about an hour Vivek Khera (16:33)
• Re: tuning questions Josh Berkus (16:59)
• Re: tuning questions Jeff (16:59)
• Re: Has anyone run on the new G5 yet William Yu (17:06)
• Re: tuning questions Rob Fielding (17:13)
• Re: tuning questions scott.marlowe (17:26)
• Re: tuning questions Dror Matalon (17:57)
• Re: tuning questions Josh Berkus (18:03)
• Re: tuning questions Jord Tanner (18:07)
• Re: tuning questions Andrew Sullivan (18:11)
• Re: tuning questions scott.marlowe (18:12)
• Re: autovacuum daemon stops doing work after about an hour Gaetano Mendola (18:35)
• Slow UPADTE, compared to INSERT Ivar Zarans (18:57)
• Re: tuning questions Jack Coates (19:16)
• Re: tuning questions Eric Soroos (19:17)
• Re: tuning questions Josh Berkus (19:20)
• Re: Slow UPADTE, compared to INSERT Jeff (19:23)
• Re: autovacuum daemon stops doing work after about an hour Vivek Khera (19:29)
• Re: autovacuum daemon stops doing work after about an hour Vivek Khera (19:44)
• Re: tuning questions Jack Coates (19:50)
• Re: Slow UPADTE, compared to INSERT Ivar Zarans (19:51)
• Re: Slow UPADTE, compared to INSERT William Yu (19:59)
• Re: Slow UPADTE, compared to INSERT Richard Huxton (20:23)
• Re: tuning questions Richard Huxton (20:27)
• Re: tuning questions Jack Coates (20:37)
• Re: Slow UPADTE, compared to INSERT Ivar Zarans (20:43)
• Re: autovacuum daemon stops doing work after about an hour Matthew T. O'Connor (20:52)
• Re: tuning questions scott.marlowe (21:10)
• Re: autovacuum daemon stops doing work after about an hour Vivek Khera (21:20)
• Re: autovacuum daemon stops doing work after about an hour Vivek Khera (21:22)
• Re: tuning questions Josh Berkus (21:24)
• Re: autovacuum daemon stops doing work after about an Larry Rosenman (21:25)
• Re: autovacuum daemon stops doing work after about an Vivek Khera (21:37)
• Re: Slow UPADTE, compared to INSERT Ivar Zarans (22:13)
• Re: Slow UPADTE, compared to INSERT Richard Huxton (22:37)
• Re: Slow UPADTE, compared to INSERT Richard Huxton (22:45)
• Re: tuning questions Eric Soroos (22:59)
• Re: tuning questions Jack Coates (23:16)
• Re: tuning questions Jack Coates (23:20)
• Re: tuning questions Richard Huxton (23:47)

2003-12-05

• Re: tuning questions Jack Coates (00:32)
• Re: Slow UPADTE, compared to INSERT Ivar Zarans (01:45)
• Re: Slow UPADTE, compared to INSERT Ivar Zarans (02:07)
• Re: Slow UPADTE, compared to INSERT Christopher Kings-Lynne (02:15)
• Re: tuning questions Eric Soroos (04:52)
• Re: [ADMIN] Index not used. WHY? Andrei Bintintan (08:11)
• Re: [ADMIN] Index not used. WHY? Shridhar Daithankar (08:39)
• Re: tuning questions Thierry Missimilly (09:13)
• Re: Slow UPADTE, compared to INSERT Richard Huxton (10:08)
• Re: Slow UPADTE, compared to INSERT Ivar Zarans (12:38)
• Re: Slow UPADTE, compared to INSERT Shridhar Daithankar (12:49)
• Re: Slow UPADTE, compared to INSERT Ivar Zarans (13:13)
• Re: Slow UPADTE, compared to INSERT Richard Huxton (13:23)
• Re: Slow UPADTE, compared to INSERT Shridhar Daithankar (13:51)
• Re: [ADMIN] Index not used. WHY? Stephan Szabo (15:34)
• Re: Slow UPADTE, compared to INSERT Ivar Zarans (16:47)
• Re: Slow UPADTE, compared to INSERT Ivar Zarans (16:52)
• Re: Slow UPADTE, compared to INSERT Mike C. Fletcher (17:05)
• Re: Slow UPADTE, compared to INSERT Mike C. Fletcher (17:12)
• Re: tuning questions Josh Berkus (17:26)
• Re: Slow UPADTE, compared to INSERT Greg Stark (17:28)
• Slightly OT -- Xeon versus Opteron Comparison William Yu (19:06)
• query using cpu nearly 100%, why? LIANHE SHAO (21:03)
• Help tracking down problem with inserts slowing down... Steve Wampler (21:51)
• Re: Help tracking down problem with inserts slowing Neil Conway (23:38)

2003-12-06

• Re: tuning questions Jack Coates (01:22)
• Re: Help tracking down problem with inserts slowing down... Robert Treat (02:54)
• Re: Has anyone run on the new G5 yet Bruce Momjian (13:19)
• Pgbench results Rob Sell (17:09)
• Re: query using cpu nearly 100%, why? Richard Huxton (17:46)
• Re: query using cpu nearly 100%, why? Neil Conway (19:41)
• Re: Slow UPADTE, compared to INSERT Neil Conway (19:54)

2003-12-07

• Re: Help tracking down problem with inserts slowing down... Steve Wampler (14:28)
• Re: Help tracking down problem with inserts slowing down... Steve Wampler (14:52)
• Re: Help tracking down problem with inserts slowing down... Tom Lane (16:52)
• Re: Help tracking down problem with inserts slowing Steve Wampler (17:28)
• Re: autovacuum daemon stops doing work after about an Bruce Momjian (21:16)

2003-12-08

• Re: autovacuum daemon stops doing work after about an hour Gaetano Mendola (00:46)
• Re: autovacuum daemon stops doing work after about an hour Christopher Browne (01:17)
• Re: autovacuum daemon stops doing work after about an hour Matthew T. O'Connor (05:27)
• TRUNCATE veeeery slow compared to DELETE in 7.4 Hartmut Raschick (14:03)
• Re: Help tracking down problem with inserts slowing Steve Wampler (15:14)
• Re: Help tracking down problem with inserts slowing Tom Lane (15:35)
• Re: tuning questions Jack Coates (17:43)
• Re: autovacuum daemon stops doing work after about an hour Vivek Khera (18:41)
• Re: tuning questions Tom Lane (19:19)

2003-12-09

• Re: Problem with insert into select... Neil Conway (08:32)
• Re: tuning questions Jack Coates (16:57)
• Re: tuning questions Matt Clark (17:07)
• Re: tuning questions Josh Berkus (17:35)
• Why is VACUUM ANALYZE <table> so slow? David Shadovitz (21:14)
• Index problem or function problem? LIANHE SHAO (23:24)

2003-12-10

• Solaris Performance (Again) Mark Kirkwood (05:56)
• Re: Solaris Performance (Again) Jeff (13:53)
• Re: TRUNCATE veeeery slow compared to DELETE in 7.4 Josh Berkus (17:18)
• Re: Solaris Performance (Again) Neil Conway (19:15)
• [No subject] nbarraza (19:29)
• Re: TRUNCATE veeeery slow compared to DELETE in 7.4 Tom Lane (19:54)
• Re: Stephan Szabo (20:35)

2003-12-11

• Performance problems with a higher number of clients Alfranio Correia Junior (04:13)
• Re: Solaris Performance (Again) Mark Kirkwood (06:04)
• Re: Solaris Performance (Again) Mark Kirkwood (06:09)
• Re: Performance problems with a higher number of clients Shridhar Daithankar (06:36)
• Re: Performance problems with a higher number of clients Jeff (13:28)
• Re: Performance problems with a higher number of clients Tom Lane (14:54)
• hints in Postgres? sandra ruiz (16:00)
• Re: hints in Postgres? Pavel Stehule (16:22)
• Re: hints in Postgres? Christopher Browne (16:31)
• Optimizing FK & PK performance... Sean P. Thomas (16:38)
• Command nbarraza (16:45)
• Hardware suggestions for Linux/PGSQL server Jeff Bohmer (20:19)
• Re: hints in Postgres? Bruno Wolff III (20:27)
• Re: Hardware suggestions for Linux/PGSQL server William Yu (20:50)
• Re: Hardware suggestions for Linux/PGSQL server Jeff Bohmer (22:02)
• Re: Hardware suggestions for Linux/PGSQL server scott.marlowe (22:48)
• Re: Hardware suggestions for Linux/PGSQL server William Yu (23:32)

2003-12-12

• Measuring execution time for sql called from PL/pgSQL Aram Kananov (01:17)
• Re: Measuring execution time for sql called from PL/pgSQL David Shadovitz (01:50)
• Re: Performance problems with a higher number of clients Alfranio Tavares Correia Junior (02:35)
• Re: Hardware suggestions for Linux/PGSQL server Shridhar Daithankar (06:35)
• fsync method checking Bruce Momjian (06:49)
• Re: Measuring execution time for sql called from PL/pgSQL Tomasz Myrta (07:46)
• Query plan - now what? David Shadovitz (08:18)
• Re: Query plan - now what? Shridhar Daithankar (09:14)
• Re: TRUNCATE veeeery slow compared to DELETE in 7.4 Hartmut Raschick (10:47)