• Text Size: Normal / Large
• Donate
• Contact

Section Navigation

• Community
• Contributors
• Mailing Lists
  • Subscribe
  • User lists
    • pgsql-admin
    • pgsql-advocacy
    • pgsql-announce
    • pgsql-bugs
    • pgsql-docs
    • pgsql-general
    • pgsql-jobs
    • pgsql-novice
    • pgsql-performance
    • pgsql-php
    • pgsql-sql
    • pgsql-students
  • Developer lists
  • Regional lists
  • Associations
  • User groups
  • Project lists
  • Inactive lists
• IRC
• Featured Users
• International Sites
• Propaganda
• Resources
• Weekly News
• Community login
  • Profile
  • Lost password

pgsql-performance 2003-12 Thread Index (1/2)

• Main Index
• [Prev Page]
• [Next Page]

• [no subject] Unknown (Wed 18 04:22)
• DELETE ... WHERE ctid IN (...) vs. Iteration Jonathan Gardner (Tue 30 16:33)
• deferred foreign keys Vivek Khera (Mon 29 20:34)
• Re: deferred foreign keys Vivek Khera (Wed 31 17:18)
• Question about difference in performance of 2 queries on large table Sean Shanny (Mon 29 16:36)
• Re: Question about difference in performance of 2 queries on large table Tom Lane (Mon 29 16:49)
• Re: Question about difference in performance of 2 queries Sean Shanny (Mon 29 17:45)
• Re: Question about difference in performance of 2 queries Sean Shanny (Mon 29 18:47)
• Re: Question about difference in performance of 2 queries Tom Lane (Mon 29 19:40)
• Re: Question about difference in performance of 2 queries Sean Shanny (Mon 29 19:53)
• Re: Question about difference in performance of 2 queries Nicholas Shanny (Tue 30 15:03)
• Re: Question about difference in performance of 2 queries Sean Shanny (Mon 29 19:26)
• Re: Question about difference in performance of 2 queries Dennis Bjorklund (Mon 29 16:50)
• What's faster? Keith Bottner (Sat 27 00:12)
• Re: What's faster? Tom Lane (Sat 27 00:49)
• Re: What's faster? Mike Nolan (Sat 27 01:07)
• Re: What's faster? Tom Lane (Sat 27 04:00)
• Re: What's faster? D'Arcy J.M. Cain (Sat 27 10:52)
• Re: What's faster? Tom Lane (Sat 27 18:31)
• [no subject] Michael Rothschild (Wed 24 16:27)
• Re: Christopher Kings-Lynne (Thu 25 02:48)
• Re: Tom Lane (Thu 25 16:29)
• mnogosearch under 7.4 ... Marc G. Fournier (Mon 22 21:15)
• postgresql performance on linux port Michael Guerin (Mon 22 19:13)
• Re: postgresql performance on linux port Tom Lane (Mon 22 22:33)
• Re: postgresql performance on linux port Michael Guerin (Tue 23 00:34)
• "select max/count(id)" not using index Ryszard Lach (Mon 22 10:52)
• Re: "select max/count(id)" not using index Christopher Kings-Lynne (Mon 22 10:57)
• Re: "select max/count(id)" not using index Pavel Stehule (Mon 22 11:03)
• Re: "select max/count(id)" not using index Tomasz Myrta (Mon 22 11:04)
• Re: "select max/count(id)" not using index Evil Azrael (Mon 22 15:29)
• general performance question Conny Thimren (Thu 18 19:42)
• why do optimizer parameters have to be set manually? Marinos J. Yannikos (Thu 18 18:44)
• Re: why do optimizer parameters have to be set manually? Tom Lane (Thu 18 19:57)
• Re: why do optimizer parameters have to be set manually? Marinos J. Yannikos (Fri 19 13:52)
• Re: why do optimizer parameters have to be set manually? Tom Lane (Fri 19 15:08)
• Re: why do optimizer parameters have to be set manually? William Yu (Fri 19 18:05)
• Re: why do optimizer parameters have to be set manually? Christopher Browne (Thu 18 20:31)
• is it possible to get the optimizer to use indexes with a like clause Dave Cramer (Thu 18 23:19)
• Re: is it possible to get the optimizer to use indexes Christopher Kings-Lynne (Fri 19 01:34)
• Re: is it possible to get the optimizer to use indexes Doug McNaught (Fri 19 01:41)
• Re: is it possible to get the optimizer to use indexes Dave Cramer (Wed 24 13:59)
• Re: is it possible to get the optimizer to use indexes Dave Cramer (Fri 19 03:09)
• Re: is it possible to get the optimizer to use indexes Stephan Szabo (Fri 19 03:37)
• Re: is it possible to get the optimizer to use indexes Tom Lane (Fri 19 03:44)
• Re: is it possible to get the optimizer to use indexes Dave Cramer (Fri 19 09:51)
• Re: is it possible to get the optimizer to use indexes Tom Lane (Fri 19 14:39)
• Re: is it possible to get the optimizer to use indexes Erki Kaldjärv (Fri 19 16:01)
• Re: is it possible to get the optimizer to use indexes with a like clause Christopher Browne (Fri 19 03:31)
• general peformance question Conny Thimren (Thu 18 17:05)
• Re: general peformance question Rod Taylor (Mon 22 20:47)
• Re: general peformance question scott.marlowe (Mon 22 22:50)
• Adding RAM: seeking advice & warnings of hidden "gotchas" Nick Fankhauser (Wed 17 19:57)
• Re: Adding RAM: seeking advice & warnings of hidden "gotchas" Eric Soroos (Wed 17 21:39)
• Re: Adding RAM: seeking advice & warnings of hidden "gotchas" Matt Clark (Wed 17 22:19)
• Why is restored database faster? David Shadovitz (Wed 17 05:30)
• Re: Why is restored database faster? Neil Conway (Wed 17 06:00)
• Re: Why is restored database faster? Shridhar Daithankar (Wed 17 06:31)
• Re: Why is restored database faster? Dennis Bjorklund (Wed 17 06:43)
• <Possible follow-ups>
• Re: Why is restored database faster? David Shadovitz (Thu 18 03:59)
• Re: Why is restored database faster? Shridhar Daithankar (Thu 18 06:48)
• Re: Why is restored database faster? Dennis Bjorklund (Thu 18 15:13)
• update slows down in pl/pgsql function Jenny Zhang (Tue 16 23:50)
• Re: [GENERAL] update slows down in pl/pgsql function Stephan Szabo (Tue 16 23:55)
• Re: [GENERAL] update slows down in pl/pgsql function Jenny Zhang (Wed 17 00:04)
• Nested loop performance Nick Fankhauser (Tue 16 17:12)
• Re: Nested loop performance Richard Poole (Tue 16 23:56)
• Re: Nested loop performance Nick Fankhauser (Wed 17 15:26)
• Re: Nested loop performance Stephan Szabo (Wed 17 01:17)
• Re: Nested loop performance Nick Fankhauser (Wed 17 15:26)
• Nested loop question Nick Fankhauser - Doxpop (Tue 16 17:06)
• Re: Nested loop question Richard Huxton (Wed 17 09:52)
• Re: Nested loop question Nick Fankhauser (Wed 17 15:26)
• Postgres respond after toomany times to a query view Claudia D'amato (Tue 16 15:41)
• Unsubscribe Rhaoni Chiu Pereira (Mon 15 17:01)
• Update performance doc Bruce Momjian (Sun 14 05:44)
• Re: Tuning for mid-size server Bruce Momjian (Sun 14 05:42)
• Re: Tuning for mid-size server Andrew Sullivan (Sun 14 17:56)
• a lot of problems with pg 7.4 Kari Lavikka (Sat 13 18:39)
• Re: a lot of problems with pg 7.4 Tarhon-Onu Victor (Sun 14 09:55)
• Re: a lot of problems with pg 7.4 Dennis Bjorklund (Sun 14 17:14)
• Re: a lot of problems with pg 7.4 scott.marlowe (Tue 16 16:56)
• Excessive rows/tuples seriously degrading query performance Chadwick, Russell (Fri 12 22:41)
• Re: Excessive rows/tuples seriously degrading query Hannu Krosing (Tue 16 21:29)
• Re: Excessive rows/tuples seriously degrading query Tom Lane (Wed 17 18:35)
• Update on putting WAL on ramdisk/ William Yu (Fri 12 22:29)
• Re: Update on putting WAL on ramdisk/ Russell Garrett (Fri 12 22:37)
• Re: Update on putting WAL on ramdisk/ William Yu (Fri 12 22:59)
• Performance related to size of tables nbarraza (Fri 12 18:05)
• Re: Performance related to size of tables Mark Kirkwood (Fri 12 21:11)
• Tables Without OIDS and its effect Sai Hertz And Control Systems (Fri 12 16:16)
• Re: Tables Without OIDS and its effect Neil Conway (Fri 12 23:11)
• Re: Tables Without OIDS and its effect Sai Hertz And Control Systems (Sat 13 10:34)
• Re: Tables Without OIDS and its effect Tom Lane (Sun 14 22:53)
• Re: Tables Without OIDS and its effect Neil Conway (Mon 15 02:10)
• ODBC Driver generates a too big "windows swap file" and it's too slow Rhaoni Chiu Pereira (Fri 12 12:40)
• Re: [ADMIN] ODBC Driver generates a too big "windows swap file" and scott.marlowe (Fri 12 16:13)
• Re: [HACKERS] fsync method checking Zeugswetter Andreas SB SD (Fri 12 12:22)
• <Possible follow-ups>
• Re: [HACKERS] fsync method checking Zeugswetter Andreas SB SD (Wed 17 16:58)
• Query plan - now what? David Shadovitz (Fri 12 08:28)
• Re: Query plan - now what? Shridhar Daithankar (Fri 12 09:14)
• Re: Query plan - now what? Tom Lane (Fri 12 15:33)
• <Possible follow-ups>
• Re: Query plan - now what? David Shadovitz (Fri 12 15:47)
• Re: Query plan - now what? Tom Lane (Fri 12 16:53)
• Re: Query plan - now what? David Shadovitz (Sun 14 07:24)
• Measuring execution time for sql called from PL/pgSQL Aram Kananov (Fri 12 01:17)
• Re: Measuring execution time for sql called from PL/pgSQL David Shadovitz (Fri 12 01:57)
• Re: Measuring execution time for sql called from PL/pgSQL Tomasz Myrta (Fri 12 07:47)
• Hardware suggestions for Linux/PGSQL server Jeff Bohmer (Thu 11 20:20)
• Re: Hardware suggestions for Linux/PGSQL server William Yu (Thu 11 21:00)
• Re: Hardware suggestions for Linux/PGSQL server Jeff Bohmer (Thu 11 22:02)
• Re: Hardware suggestions for Linux/PGSQL server William Yu (Fri 12 00:00)
• Re: Hardware suggestions for Linux/PGSQL server Shridhar Daithankar (Fri 12 06:36)
• Re: Hardware suggestions for Linux/PGSQL server William Yu (Fri 12 16:59)
• Re: Hardware suggestions for Linux/PGSQL server Jeff Bohmer (Sat 13 23:01)
• Re: Hardware suggestions for Linux/PGSQL server scott.marlowe (Thu 11 23:08)
• Re: Hardware suggestions for Linux/PGSQL server Jeff Bohmer (Sat 13 22:57)
• Re: Hardware suggestions for Linux/PGSQL server Andrew G. Hammond (Mon 15 04:17)
• Re: Hardware suggestions for Linux/PGSQL server Christopher Browne (Mon 15 05:30)
• Re: Hardware suggestions for Linux/PGSQL server Jeff Bohmer (Mon 15 16:38)
• Optimizing FK & PK performance... Sean P. Thomas (Thu 11 16:51)
• Re: Optimizing FK & PK performance... Neil Conway (Tue 16 22:48)
• Re: Optimizing FK & PK performance... Christopher Kings-Lynne (Wed 17 01:14)
• Command nbarraza (Thu 11 16:46)
• hints in Postgres? sandra ruiz (Thu 11 16:00)
• Re: hints in Postgres? Pavel Stehule (Thu 11 16:22)
• Re: hints in Postgres? Christopher Browne (Thu 11 17:00)
• Re: hints in Postgres? Bruno Wolff III (Thu 11 20:28)
• Performance problems with a higher number of clients Alfranio Correia Junior (Thu 11 04:22)
• Re: Performance problems with a higher number of clients Shridhar Daithankar (Thu 11 06:37)
• Re: Performance problems with a higher number of clients Jeff (Thu 11 13:29)
• Re: Performance problems with a higher number of clients Tom Lane (Thu 11 14:55)
• Re: Performance problems with a higher number of clients Alfranio Tavares Correia Junior (Fri 12 02:35)
• [no subject] nbarraza (Wed 10 19:30)
• Re: Stephan Szabo (Wed 10 20:35)
• Solaris Performance (Again) Mark Kirkwood (Wed 10 05:56)
• Re: Solaris Performance (Again) Jeff (Wed 10 13:54)
• Re: Solaris Performance (Again) Mark Kirkwood (Thu 11 06:04)
• Re: Solaris Performance (Again) Neil Conway (Wed 10 19:16)
• Re: Solaris Performance (Again) Mark Kirkwood (Thu 11 06:09)
• fsync method checking Bruce Momjian (Fri 12 06:50)
• Re: [HACKERS] fsync method checking Manfred Spraul (Fri 12 20:55)
• Re: [HACKERS] fsync method checking Tom Lane (Fri 12 21:29)
• Index problem or function problem? LIANHE SHAO (Tue 09 23:21)
• Re: Index problem or function problem? Tom Lane (Mon 15 18:06)
• Why is VACUUM ANALYZE <table> so slow? David Shadovitz (Tue 09 21:21)
• Re: Why is VACUUM ANALYZE <table> so slow? Neil Conway (Tue 16 22:51)
• <Possible follow-ups>
• Re: Why is VACUUM ANALYZE <table> so slow? David Shadovitz (Wed 17 05:30)
• Re: Problem with insert into select... Neil Conway (Tue 09 08:32)
• TRUNCATE veeeery slow compared to DELETE in 7.4 Hartmut Raschick (Mon 08 14:04)
• Re: TRUNCATE veeeery slow compared to DELETE in 7.4 Josh Berkus (Wed 10 17:20)
• Re: TRUNCATE veeeery slow compared to DELETE in 7.4 Tom Lane (Wed 10 19:55)
• Re: TRUNCATE veeeery slow compared to DELETE in 7.4 Hartmut Raschick (Fri 12 10:49)
• Re: TRUNCATE veeeery slow compared to DELETE in 7.4 Tom Lane (Mon 15 18:22)
• Pgbench results Rob Sell (Sat 06 17:09)
• Help tracking down problem with inserts slowing down... Steve Wampler (Fri 05 21:52)
• Re: Help tracking down problem with inserts slowing Neil Conway (Fri 05 23:39)
• Re: Help tracking down problem with inserts slowing Steve Wampler (Sun 07 17:29)
• Re: Help tracking down problem with inserts slowing down... Robert Treat (Sat 06 02:55)
• Re: Help tracking down problem with inserts slowing down... Steve Wampler (Sun 07 14:28)
• Re: Help tracking down problem with inserts slowing down... Steve Wampler (Sun 07 14:53)
• Re: Help tracking down problem with inserts slowing down... Tom Lane (Sun 07 16:54)
• Re: Help tracking down problem with inserts slowing Steve Wampler (Mon 08 15:15)
• Re: Help tracking down problem with inserts slowing Tom Lane (Mon 08 15:36)
• query using cpu nearly 100%, why? LIANHE SHAO (Fri 05 21:00)
• Re: query using cpu nearly 100%, why? Richard Huxton (Sat 06 17:47)
• Re: query using cpu nearly 100%, why? Neil Conway (Sat 06 19:42)
• Slightly OT -- Xeon versus Opteron Comparison William Yu (Fri 05 19:29)
• Slow UPADTE, compared to INSERT Ivar Zarans (Thu 04 18:58)
• Re: Slow UPADTE, compared to INSERT Jeff (Thu 04 19:24)
• Re: Slow UPADTE, compared to INSERT Ivar Zarans (Thu 04 19:55)
• Re: Slow UPADTE, compared to INSERT Richard Huxton (Thu 04 20:24)
• Re: Slow UPADTE, compared to INSERT Ivar Zarans (Thu 04 20:47)
• Re: Slow UPADTE, compared to INSERT Ivar Zarans (Thu 04 22:13)
• Re: Slow UPADTE, compared to INSERT Richard Huxton (Thu 04 22:46)
• Re: Slow UPADTE, compared to INSERT Ivar Zarans (Fri 05 01:45)
• Re: Slow UPADTE, compared to INSERT Ivar Zarans (Fri 05 02:07)
• Re: Slow UPADTE, compared to INSERT Christopher Kings-Lynne (Fri 05 02:14)
• Re: Slow UPADTE, compared to INSERT Richard Huxton (Fri 05 10:08)
• Re: Slow UPADTE, compared to INSERT Ivar Zarans (Fri 05 12:39)

---

• Main Index
• [Prev Page]
• [Next Page]

---

Mail converted by MHonArc