• 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 2008-08 Thread Index (1/3)

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

• slow update of index during insert/copy Thomas Finneid (Sun 31 13:32)
• Re: slow update of index during insert/copy Scott Carey (Sun 31 18:38)
• Re: slow update of index during insert/copy Thomas Finneid (Sun 31 19:20)
• Re: slow update of index during insert/copy Craig Ringer (Mon 01 01:49)
• update - which way quicker? Emi Lu (Thu 28 19:31)
• Re: update - which way quicker? paul socha (Thu 28 21:14)
• Best hardware/cost tradoff? cluster (Thu 28 19:29)
• Re: Best hardware/cost tradoff? Scott Marlowe (Thu 28 19:46)
• Re: Best hardware/cost tradoff? Fernando Hevia (Thu 28 20:05)
• Re: Best hardware/cost tradoff? Craig James (Thu 28 20:25)
• Re: Best hardware/cost tradoff? cluster (Thu 28 21:30)
• Re: Best hardware/cost tradoff? Scott Marlowe (Thu 28 22:03)
• Re: Best hardware/cost tradoff? cluster (Sat 30 10:30)
• Re: Best hardware/cost tradoff? Scott Marlowe (Thu 28 21:47)
• indexing for distinct search in timestamp based table Rainer Mager (Thu 28 08:14)
• Re: indexing for distinct search in timestamp based table H. Hall (Thu 28 09:46)
• Re: indexing for distinct search in timestamp based table David Rowley (Thu 28 22:48)
• Re: indexing for distinct search in timestamp based table Scott Carey (Thu 28 23:02)
• Re: indexing for distinct search in timestamp based table Rainer Mager (Fri 29 07:33)
• Is there a way to SubPartition? Jerry Champlin (Wed 27 13:45)
• Re: Is there a way to SubPartition? Tom Lane (Wed 27 14:04)
• Re: Is there a way to SubPartition? Jerry Champlin (Wed 27 20:21)
• Re: Is there a way to SubPartition? Alvaro Herrera (Wed 27 20:32)
• Re: Is there a way to SubPartition? Tom Lane (Wed 27 20:54)
• Re: Is there a way to SubPartition? Matthew Wakeling (Wed 27 14:10)
• control the number of clog files and xlog files Duan Ligong (Wed 27 01:09)
• Re: control the number of clog files and xlog files Alvaro Herrera (Wed 27 01:57)
• Re: control the number of clog files and xlog files Duan Ligong (Wed 27 11:28)
• Re: control the number of clog files and xlog files Alvaro Herrera (Wed 27 13:09)
• Re: Query w empty result set with LIMIT orders of magnitude slower than without (SOLVED, pls disregard) Frank Joerdens (Tue 26 17:00)
• select on 22 GB table causes "An I/O error occured while sending to the backend." exception henk de wit (Tue 26 16:44)
• Re: select on 22 GB table causes "An I/O error occured while sending to the backend." exception Mark Lewis (Tue 26 17:10)
• Re: select on 22 GB table causes "An I/O error occured while sending to the backend." exception henk de wit (Tue 26 20:31)
• Re: select on 22 GB table causes "An I/O error occured while sending to the backend." exception Scott Marlowe (Tue 26 18:27)
• Re: select on 22 GB table causes "An I/O error occured while sending to the backend." exception henk de wit (Tue 26 20:53)
• Re: select on 22 GB table causes "An I/O error occured while sending to the backend." exception Bill Moran (Wed 27 13:01)
• Re: select on 22 GB table causes "An I/O error occured while sending to the backend." exception DANIEL CRISTIAN CRUZ (Wed 27 13:27)
• Re: select on 22 GB table causes "An I/O error occured while sending to the backend." exception Shane Ambler (Wed 27 16:46)
• Re: select on 22 GB table causes "An I/O error occured while sending to the backend." exception Greg Smith (Fri 29 04:41)
• Re: select on 22 GB table causes "An I/O error occured while sending to the backend." exception Florian Weimer (Wed 27 07:21)
• Re: select on 22 GB table causes "An I/O error occured while sending to the backend." exception david (Wed 27 21:45)
• Re: select on 22 GB table causes "An I/O error occured while sending to the backend." exception Andrew Sullivan (Wed 27 22:14)
• Re: select on 22 GB table causes "An I/O error occured while sending to the backend." exception david (Wed 27 22:21)
• Re: select on 22 GB table causes "An I/O error occured while sending to the backend." exception Scott Marlowe (Wed 27 22:29)
• Re: select on 22 GB table causes "An I/O error occured while sending to the backend." exception Alvaro Herrera (Thu 28 02:20)
• Re: select on 22 GB table causes "An I/O error occured while sending to the backend." exception Tom Lane (Thu 28 04:37)
• Re: select on 22 GB table causes "An I/O error occured while sending to the backend." exception Tom Lane (Thu 28 04:57)
• Re: select on 22 GB table causes "An I/O error occured while sending to the backend." exception Craig James (Thu 28 06:00)
• Re: select on 22 GB table causes "An I/O error occured while sending to the backend." exception david (Thu 28 06:16)
• Re: select on 22 GB table causes "An I/O error occured while sending to the backend." exception Craig James (Thu 28 16:03)
• Re: select on 22 GB table causes "An I/O error occured while sending to the backend." exception david (Thu 28 16:48)
• Re: select on 22 GB table causes "An I/O error occured while sending to the backend." exception david (Thu 28 06:23)
• Re: select on 22 GB table causes "An I/O error occured while sending to the backend." exception Jeff Davis (Thu 28 18:33)
• Re: select on 22 GB table causes "An I/O error occured while sending to the backend." exception Jeff Davis (Thu 28 17:56)
• Re: select on 22 GB table causes "An I/O error occured while sending to the backend." exception Matthew Wakeling (Thu 28 20:04)
• Re: select on 22 GB table causes "An I/O error occured while sending to the backend." exception Andrew Sullivan (Thu 28 12:36)
• Re: select on 22 GB table causes "An I/O error occured while sending to the backend." exception Matthew Wakeling (Thu 28 13:27)
• Re: select on 22 GB table causes "An I/O error occured while sending to the backend." exception Bill Moran (Thu 28 13:54)
• Re: select on 22 GB table causes"An I/O error occured while sending to the backend." exception Kevin Grittner (Thu 28 14:50)
• Re: select on 22 GB table causes "An I/O error occured while sending to the backend." exception Greg Smith (Fri 29 04:47)
• Re: select on 22 GB table causes "An I/O error occured while sending to the backend." exception Bill Moran (Fri 29 11:09)
• Re: select on 22 GB table causes "An I/O error occured while sending to the backend." exception Gregory Williamson (Fri 29 11:22)
• Re: select on 22 GB table causes "An I/O error occured while sending to the backend." exception Gregory S. Youngblood (Fri 29 16:38)
• Re: select on 22 GB table causes "An I/O error occured while sending to the backend." exception Greg Smith (Fri 29 16:16)
• Re: select on 22 GB table causes "An I/O error occured while sending to the backend." exception Steve Atkins (Thu 28 15:07)
• Re: select on 22 GB table causes "An I/O error occured while sending to the backend." exception Jerry Champlin (Thu 28 15:47)
• Re: select on 22 GB table causes "An I/O error occured while sending to the backend." exception Matthew Wakeling (Thu 28 16:03)
• Re: select on 22 GB table causes "An I/O error occured while sending to the backend." exception Craig James (Thu 28 18:14)
• Re: select on 22 GB table causes "An I/O error occured while sending to the backend." exception david (Thu 28 18:27)
• Re: select on 22 GB table causes "An I/O error occured while sending to the backend." exception Matthew Wakeling (Thu 28 20:29)
• Re: select on 22 GB table causes "An I/O error occured while sending to the backend." exception Scott Marlowe (Thu 28 22:42)
• Re: select on 22 GB table causes "An I/O error occured while sending to the backend." exception david (Thu 28 23:08)
• Re: select on 22 GB table causes "An I/O error occured while sending to the backend." exception Scott Marlowe (Fri 29 01:11)
• Re: select on 22 GB table causes "An I/O error occured while sending to the backend." exception david (Fri 29 01:16)
• Re: select on 22 GB table causes "An I/O error occured while sending to the backend." exception Scott Marlowe (Fri 29 01:52)
• Re: select on 22 GB table causes "An I/O error occured while sending to the backend." exception Magnus Hagander (Fri 29 08:01)
• Re: select on 22 GB table causes "An I/O error occured while sending to the backend." exception Matthew Dennis (Fri 29 01:53)
• Re: select on 22 GB table causes "An I/O error occured while sending to the backend." exception Scott Marlowe (Fri 29 02:02)
• Re: select on 22 GB table causes "An I/O error occured while sending to the backend." exception Alvaro Herrera (Fri 29 02:32)
• Re: select on 22 GB table causes "An I/O error occured while sending to the backend." exception david (Fri 29 02:42)
• Re: select on 22 GB table causes "An I/O error occured while sending to the backend." exception Alvaro Herrera (Fri 29 02:50)
• Re: select on 22 GB table causes "An I/O error occured while sending to the backend." exception david (Fri 29 03:06)
• Re: select on 22 GB table causes "An I/O error occured while sending to the backend." exception Matthew Wakeling (Fri 29 11:02)
• Re: select on 22 GB table causes "An I/O error occured while sending to the backend." exception Alvaro Herrera (Fri 29 13:48)
• Re: select on 22 GB table causes "An I/O error occured while sending to the backend." exception david (Thu 28 16:51)
• Re: select on 22 GB table causes "An I/O error occured while sending to the backend." exception david (Thu 28 18:18)
• Re: select on 22 GB table causes "An I/O error occured while sending to the backend." exception Matthew Wakeling (Thu 28 20:09)
• Re: select on 22 GB table causes "An I/O error occured while sending to the backend." exception James Mansion (Fri 29 05:38)
• Re: select on 22 GB table causes "An I/O error occured while sending to the backend." exception Craig James (Fri 29 15:31)
• Re: select on 22 GB table causes "An I/O error occured while sending to the backend." exception Matthew Wakeling (Fri 29 15:56)
• Re: select on 22 GB table causes "An I/O error occured while sending to the backend." exception Valentin Bogdanov (Fri 29 16:22)
• Query w empty result set with LIMIT orders of magnitude slower than without Frank Joerdens (Tue 26 16:38)
• Re: Query w empty result set with LIMIT orders of magnitude slower than without Tom Lane (Tue 26 16:53)
• Re: Query w empty result set with LIMIT orders of magnitude slower than without Frank Joerdens (Tue 26 18:42)
• Autovacuum does not stay turned off Jerry Champlin (Tue 26 16:10)
• Re: Autovacuum does not stay turned off hubert depesz lubaczewski (Tue 26 16:14)
• Re: Autovacuum does not stay turned off Jerry Champlin (Tue 26 16:46)
• Re: Autovacuum does not stay turned off hubert depesz lubaczewski (Tue 26 17:04)
• Re: Autovacuum does not stay turned off Jerry Champlin (Tue 26 18:06)
• Re: Autovacuum does not stay turned off Andrew Sullivan (Tue 26 16:22)
• NOW vs CURRENT_DATE dforum (Sun 24 20:03)
• Re: NOW vs CURRENT_DATE Peter Schuller (Sun 24 21:22)
• Re: NOW vs CURRENT_DATE Tino Wildenhain (Mon 25 06:13)
• Large number of tables slow insert Loic Petit (Sat 23 01:41)
• Re: Large number of tables slow insert DiezelMax (Sat 23 10:30)
• Re: Large number of tables slow insert tls . wydd (Sat 23 20:24)
• Re: Large number of tables slow insert Scott Marlowe (Sat 23 23:50)
• Re: Large number of tables slow insert tls . wydd (Sun 24 00:18)
• Re: Large number of tables slow insert Scott Marlowe (Sun 24 00:26)
• Re: Large number of tables slow insert H. Hall (Sun 24 21:02)
• Re: Large number of tables slow insert Peter Schuller (Sun 24 21:30)
• Re: Large number of tables slow insert Matthew Wakeling (Tue 26 12:50)
• Re: Large number of tables slow insert Scott Marlowe (Tue 26 15:30)
• <Possible follow-ups>
• Re: Large number of tables slow insert Loic Petit (Sat 23 20:27)
• Re: Large number of tables slow insert Loic Petit (Sun 24 00:47)
• Re: Large number of tables slow insert Scott Marlowe (Sun 24 00:50)
• Re: Large number of tables slow insert Loic Petit (Sun 24 00:59)
• Re: Large number of tables slow insert Scott Marlowe (Sun 24 01:18)
• Re: Large number of tables slow insert dforum (Sun 24 14:42)
• Re: Large number of tables slow insert Loic Petit (Sun 24 01:31)
• Re: Large number of tables slow insert Scott Marlowe (Sun 24 01:37)
• Re: Large number of tables slow insert Loic Petit (Sun 24 01:48)
• Re: Large number of tables slow insert Scott Carey (Sun 24 20:59)
• Re: Large number of tables slow insert DiezelMax (Sun 24 14:42)
• Re: Large number of tables slow insert Loic Petit (Sun 24 22:30)
• Re: Large number of tables slow insert Scott Carey (Mon 25 01:15)
• Re: Large number of tables slow insert Loic Petit (Mon 25 02:22)
• Big delete on big table... now what? Fernando Hevia (Fri 22 20:37)
• Re: Big delete on big table... now what? Kevin Grittner (Fri 22 21:31)
• Re: Big delete on big table... now what? Bill Moran (Fri 22 22:44)
• Re: Big delete on big table... now what? Gregory Stark (Sat 23 00:41)
• Re: Big delete on big table... now what? Fernando Hevia (Mon 25 13:37)
• Nested Loop join being improperly chosen Brad Ediger (Fri 22 16:04)
• Re: Nested Loop join being improperly chosen David Rowley (Thu 28 23:01)
• Re: Nested Loop join being improperly chosen Brad Ediger (Thu 28 23:23)
• Identifying the nature of blocking I/O Peter Schuller (Fri 22 12:01)
• Re: Identifying the nature of blocking I/O Craig Ringer (Mon 25 00:48)
• Re: Identifying the nature of blocking I/O Scott Carey (Mon 25 01:34)
• Re: Identifying the nature of blocking I/O Tom Lane (Mon 25 01:50)
• Re: Identifying the nature of blocking I/O Alvaro Herrera (Mon 25 02:30)
• Re: Identifying the nature of blocking I/O Alexander Staubo (Mon 25 08:18)
• Re: Identifying the nature of blocking I/O RW (Mon 25 08:32)
• Re: Identifying the nature of blocking I/O Tom Lane (Mon 25 01:37)
• Re: Identifying the nature of blocking I/O Greg Smith (Fri 29 03:55)
• Re: Identifying the nature of blocking I/O Jonah H. Harris (Mon 25 14:23)
• Why do my hash joins turn to nested loops? pgsql-performance (Thu 21 22:50)
• Re: Why do my hash joins turn to nested loops? Tom Lane (Fri 22 01:08)
• Re: Why do my hash joins turn to nested loops? pgsql-performance (Fri 22 18:33)
• The state of PG replication in 2008/Q2? Dan Harris (Thu 21 18:26)
• Re: The state of PG replication in 2008/Q2? Mathias Stjernström (Thu 21 20:53)
• Re: The state of PG replication in 2008/Q2? Andrew Sullivan (Thu 21 21:04)
• Re: The state of PG replication in 2008/Q2? Mathias Stjernström (Thu 21 21:21)
• Re: The state of PG replication in 2008/Q2? Joshua Drake (Thu 21 21:23)
• Re: The state of PG replication in 2008/Q2? Alvaro Herrera (Thu 21 21:54)
• Re: The state of PG replication in 2008/Q2? Joshua Drake (Thu 21 22:15)
• Re: The state of PG replication in 2008/Q2? salman (Thu 21 21:33)
• Re: The state of PG replication in 2008/Q2? Alan Hodgson (Thu 21 21:42)
• Re: The state of PG replication in 2008/Q2? Mathias Stjernström (Fri 22 06:29)
• Re: The state of PG replication in 2008/Q2? david (Thu 21 22:10)
• Re: The state of PG replication in 2008/Q2? Alan Hodgson (Thu 21 21:13)
• Re: The state of PG replication in 2008/Q2? RW (Fri 22 06:27)
• Re: The state of PG replication in 2008/Q2? Mathias Stjernström (Fri 22 06:35)
• Re: The state of PG replication in 2008/Q2? Jan Otto (Fri 22 14:38)
• Re: The state of PG replication in 2008/Q2? Shane Ambler (Sat 23 07:40)
• Re: The state of PG replication in 2008/Q2? Peter Eisentraut (Fri 22 09:41)
• How to setup disk spindles for best performance Christiaan Willemsen (Wed 20 22:54)
• Re: How to setup disk spindles for best performance Merlin Moncure (Thu 21 01:50)
• Re: How to setup disk spindles for best performance Christiaan Willemsen (Thu 21 05:39)
• Re: How to setup disk spindles for best performance Joshua D. Drake (Thu 21 05:50)
• Re: How to setup disk spindles for best performance Christiaan Willemsen (Thu 21 08:41)
• Re: How to setup disk spindles for best performance Scott Carey (Thu 21 15:00)
• Re: How to setup disk spindles for best performance Christiaan Willemsen (Thu 21 15:06)
• Re: How to setup disk spindles for best performance Greg Smith (Fri 29 02:44)
• Re: How to setup disk spindles for best performance Christiaan Willemsen (Fri 29 05:08)
• Re: How to setup disk spindles for best performance Ron Mayer (Thu 21 19:15)
• Re: How to setup disk spindles for best performance Scott Marlowe (Thu 21 05:34)
• Postgres not using array André Volpato (Wed 20 19:56)
• Re: Postgres not using array David Wilson (Wed 20 20:16)
• <Possible follow-ups>
• Re: Postgres not using array André Volpato (Wed 20 20:46)
• Re: Postgres not using array André Volpato (Thu 21 13:57)

---

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

---

Mail converted by MHonArc