pgsql-performance 2009-10 Thread Index (2/3)

Skip site navigation (1) Skip section navigation (2)

Peripheral Links

Text Size: Normal / Large
Donate
Contact

Header And Logo

PostgreSQL

|

The world's most advanced open source database.

Site Navigation

pgsql-performance 2009-10 Thread Index (2/3)

Last updated: Wed Jan 18 04:14:25 2012
454 messages

Re: Getting a random row, (continued)
- Re: Getting a random row Grzegorz Jaśkiewicz (Tue 13 15:19)
- Re: Getting a random row Thomas Kellerer (Tue 13 15:30)
- Re: Getting a random row Scott Marlowe (Wed 14 01:18)
index on two tables or Howto speedup max/aggregate-function Michael Schwipps (Tue 13 09:04)

Re: index on two tables or Howto speedup max/aggregate-function Jacques Caron (Tue 13 09:19)
Re: index on two tables or Howto speedup max/aggregate-function Grzegorz Jaśkiewicz (Tue 13 09:21)

Issues with \copy from file Sigurgeir Gunnarsson (Mon 12 22:05)

Re: Issues with \copy from file Euler Taveira de Oliveira (Sun 18 05:34)
Re: Issues with \copy from file Scott Marlowe (Sun 18 06:10)

Re: Issues with \copy from file Matthew Wakeling (Mon 19 09:36)

Are folks running 8.4 in production environments? and 8.4 and slon 1.2? Tory M Blue (Mon 12 19:06)

Re: Are folks running 8.4 in production environments? and 8.4 and slon 1.2? Scott Marlowe (Tue 13 07:03)

Re: Are folks running 8.4 in production environments? and 8.4 and slon 1.2? Kenneth Marshall (Tue 13 12:54)

Re: Are folks running 8.4 in production environments? and 8.4 and slon 1.2? Torsten Zühlsdorff (Tue 13 07:37)

Re: Are folks running 8.4 in production environments? and 8.4 and slon 1.2? Karl Denninger (Sun 18 04:02)

Re: Are folks running 8.4 in production environments? and 8.4 and slon 1.2? Tory M Blue (Sun 18 04:08)

Re: Are folks running 8.4 in production environments? and 8.4 and slon 1.2? Karl Denninger (Sun 18 04:14)

Re: Are folks running 8.4 in production environments? and 8.4 and slon 1.2? Scott Marlowe (Sun 18 05:05)

Performance with sorting and LIMIT on partitioned table Michal Szymanski (Mon 12 14:37)

Re: Performance with sorting and LIMIT on partitioned table Robert Haas (Mon 19 00:52)

Re: Performance with sorting and LIMIT on partitioned table Joe Uhl (Mon 19 10:58)

Re: Performance with sorting and LIMIT on partitioned table Merlin Moncure (Tue 20 02:50)

Re: Performance with sorting and LIMIT on partitioned table Joe Uhl (Tue 20 10:31)

Query performance S Arvind (Mon 12 11:21)

Re: Query performance Grzegorz Jaśkiewicz (Mon 12 12:30)

Re: Query performance S Arvind (Mon 12 12:40)

Re: Query performance Matthew Wakeling (Mon 12 13:02)

Re: Query performance S Arvind (Mon 12 13:23)

Re: Query performance Grzegorz Jaśkiewicz (Mon 12 13:30)
Re: Query performance Matthew Wakeling (Mon 12 13:37)
Re: Query performance Grzegorz Jaśkiewicz (Mon 12 13:40)
Re: Query performance S Arvind (Mon 12 14:46)
Re: Query performance S Arvind (Mon 12 14:53)
Re: Query performance Grzegorz Jaśkiewicz (Mon 12 15:11)

Using unnest function on multi-dimensional array. Nimesh Satam (Mon 12 08:47)

Re: Using unnest function on multi-dimensional array. Pavel Stehule (Mon 12 08:57)

vacuumdb command soorjith p (Sun 11 15:33)

Re: vacuumdb command Heikki Linnakangas (Sun 11 15:59)

Domain vs table Michal Szymanski (Sun 11 15:07)

Re: Domain vs table Michal Szymanski (Sun 11 15:37)

Re: Domain vs table Merlin Moncure (Tue 20 11:55)

Re: Domain vs table decibel (Mon 26 02:05)

table full scan or index full scan? 旭斌裴 (Sun 11 10:33)

Re: table full scan or index full scan? Euler Taveira de Oliveira (Sun 18 05:01)
Re: table full scan or index full scan? Melton Low (Sun 18 05:07)

table partitioning & max_locks_per_transaction Brian Karlak (Sat 10 21:10)

Re: table partitioning & max_locks_per_transaction Tom Lane (Sun 11 02:57)

Re: table partitioning & max_locks_per_transaction Brian Karlak (Sun 11 16:44)

Databases vs Schemas Scott Otis (Fri 09 17:59)

Re: Databases vs Schemas Ben Chobot (Fri 09 18:12)
Re: Databases vs Schemas Merlin Moncure (Fri 09 21:02)

Re: Databases vs Schemas Scott Carey (Sat 10 02:51)

Re: Databases vs Schemas Tom Lane (Sat 10 03:11)

Re: Databases vs Schemas Chris Kratz (Sat 10 15:17)

Re: Databases vs Schemas Scott Marlowe (Sat 10 21:34)

Re: Databases vs Schemas Merlin Moncure (Sat 10 13:26)

UUID as primary key tsuraan (Fri 09 16:56)

Re: UUID as primary key Mark Mielke (Fri 09 18:30)

Re: UUID as primary key tsuraan (Sat 10 05:14)

Re: UUID as primary key Mark Mielke (Sat 10 15:40)

Re: UUID as primary key decibel (Fri 16 19:45)

Re: UUID as primary key Alvaro Herrera (Fri 16 22:02)

Re: UUID as primary key decibel (Sat 17 03:50)

disk I/O problems and Solutions Alan McKay (Fri 09 16:45)

Re: disk I/O problems and Solutions Flavio Henrique Araque Gurgel (Fri 09 19:03)
Re: disk I/O problems and Solutions Scott Marlowe (Fri 09 19:23)
Re: disk I/O problems and Solutions David Rees (Fri 09 23:09)

Re: disk I/O problems and Solutions Scott Carey (Sat 10 02:46)

Re: High CPU load on Postgres Server during Peak times!!!! Shiva Raman (Fri 09 07:11)

Re: High CPU load on Postgres Server during Peak times!!!! Merlin Moncure (Fri 09 13:27)

Explain Analyze returns faster than psql or JDBC calls. G B (Thu 08 20:30)

Re: Explain Analyze returns faster than psql or JDBC calls. Tom Lane (Thu 08 21:19)

Re: Explain Analyze returns faster than psql or JDBC calls. Dave Cramer (Fri 09 11:57)

concurrent reindex issues Tory M Blue (Thu 08 17:27)

Re: concurrent reindex issues Tom Lane (Thu 08 17:55)

Re: concurrent reindex issues Scott Marlowe (Thu 08 20:05)

Re: concurrent reindex issues Tory M Blue (Fri 09 17:58)

Partitioned Tables and ORDER BY Joe Uhl (Thu 08 15:33)

Re: Partitioned Tables and ORDER BY Michal Szymanski (Sun 11 14:37)

Re: Partitioned Tables and ORDER BY Michal Szymanski (Mon 12 14:37)

Re: Partitioned Tables and ORDER BY Joe Uhl (Sun 18 12:30)

Re: Partitioned Tables and ORDER BY Craig James (Mon 19 17:46)

Re: Partitioned Tables and ORDER BY Grzegorz Jaśkiewicz (Mon 19 08:24)

Re: Partitioned Tables and ORDER BY Robert Haas (Mon 19 16:08)

Re: Partitioned Tables and ORDER BY Grzegorz Jaśkiewicz (Mon 19 16:13)

Re: Partitioned Tables and ORDER BY Robert Haas (Mon 19 19:11)
Re: Partitioned Tables and ORDER BY Scott Carey (Thu 22 22:08)

Query logging time, not values Ludwik Dylag (Thu 08 09:19)

position in DDL of columns used in indexes Michael Gould (Thu 08 14:28)

Re: position in DDL of columns used in indexes Matthew Wakeling (Thu 08 14:37)

Re: position in DDL of columns used in indexes Tom Lane (Thu 08 15:09)

Regarding mulitple rows insert in one shot using ADO .net connected to postgres keshav upadhyaya (Thu 08 06:39)
Dumping + restoring a subset of a table? Shaul Dar (Tue 06 13:16)

Re: Dumping + restoring a subset of a table? Joshua Tolley (Tue 06 13:33)

What is the role of #fsync and #synchronous_commit in configuration file . keshav upadhyaya (Tue 06 07:28)

Re: What is the role of #fsync and #synchronous_commit in configuration file . Dave Dutcher (Tue 06 12:49)

Distributed/Parallel Computing Viji V Nair (Mon 05 19:11)

Re: Distributed/Parallel Computing Jeff Janes (Tue 06 02:41)

Re: Distributed/Parallel Computing Viji V Nair (Tue 06 06:51)

Query plan for NOT IN Matthew Wakeling (Mon 05 13:52)

Re: Query plan for NOT IN Grzegorz Jaśkiewicz (Mon 05 13:56)

Re: Query plan for NOT IN Matthew Wakeling (Mon 05 14:00)

Re: Query plan for NOT IN Grzegorz Jaśkiewicz (Mon 05 14:06)

Re: Query plan for NOT IN Guy Rouillier (Mon 05 19:35)

Re: Query plan for NOT IN Grzegorz Jaśkiewicz (Wed 07 13:27)
Re: Query plan for NOT IN Kevin Grittner (Wed 07 14:40)
Re: Query plan for NOT IN Guy Rouillier (Wed 07 17:33)
Re: Query plan for NOT IN Kevin Grittner (Wed 07 18:17)
Re: Query plan for NOT IN Craig James (Wed 07 20:28)
Re: Query plan for NOT IN Guy Rouillier (Wed 07 22:48)

Re: Query plan for NOT IN Tom Lane (Mon 05 14:30)

Re: Bad performance of SELECT ... where id IN (...) Omar Kilani (Mon 05 01:59)

Re: Bad performance of SELECT ... where id IN (...) Robert Haas (Mon 05 12:01)

Re: Bad performance of SELECT ... where id IN (...) Omar Kilani (Mon 05 12:24)

Re: Bad performance of SELECT ... where id IN (...) Grzegorz Jaśkiewicz (Mon 05 12:30)

Re: Bad performance of SELECT ... where id IN (...) Xia Qingran (Fri 09 12:32)

Re: Bad performance of SELECT ... where id IN (...) Kenneth Marshall (Fri 09 13:09)

Speed / Server anthony (Sun 04 22:53)

Re: Speed / Server Scott Marlowe (Mon 05 00:20)

Re: Speed / Server Nikolas Everett (Mon 05 13:31)

Re: Speed / Server Scott Marlowe (Mon 05 21:32)

Re: Speed / Server Nikolas Everett (Tue 06 13:21)

Re: Speed / Server Scott Marlowe (Tue 06 14:26)
Re: Speed / Server Scott Marlowe (Tue 06 19:29)
Re: Speed / Server Karl Denninger (Tue 06 19:59)
Re: Speed / Server Scott Marlowe (Tue 06 20:35)

Re: Speed / Server Merlin Moncure (Tue 06 21:16)

Re: Speed / Server Anthony Presley (Tue 06 22:40)
Re: Speed / Server richard.henwood (Wed 07 08:47)

Re: Speed / Server Greg Smith (Wed 07 00:48)

dump time increase by 1h with new kernel Justin Pryzby (Fri 02 19:58)

Re: dump time increase by 1h with new kernel Justin T Pryzby (Thu 08 17:44)

Re: dump time increase by 1h with new kernel Joshua D. Drake (Thu 08 17:49)

Re: dump time increase by 1h with new kernel Justin T Pryzby (Thu 08 20:16)

Re: dump time increase by 1h with new kernel Kevin Grittner (Thu 08 20:37)

Re: dump time increase by 1h with new kernel Justin T Pryzby (Thu 08 21:15)

<Possible follow-ups>
dump time increase by 1h with new kernel Justin Pryzby (Sat 03 01:48)

Re: dump time increase by 1h with new kernel Tom Lane (Sat 03 02:35)
Re: dump time increase by 1h with new kernel Scott Marlowe (Sun 04 05:31)
Re: dump time increase by 1h with new kernel Greg Smith (Thu 08 05:15)

updating a row in a table with only one row Michal Vitecek (Fri 02 08:48)

Re: updating a row in a table with only one row A. Kretschmer (Fri 02 09:14)
Re: updating a row in a table with only one row Hélder M . Vieira (Fri 02 09:32)
Re: updating a row in a table with only one row Merlin Moncure (Fri 02 13:54)

Re: updating a row in a table with only one row Robert Haas (Fri 02 17:39)

Re: updating a row in a table with only one row Merlin Moncure (Fri 02 18:18)
Re: updating a row in a table with only one row Heikki Linnakangas (Fri 02 18:39)
Re: updating a row in a table with only one row Michal Vitecek (Mon 05 09:17)

Re: updating a row in a table with only one row Merlin Moncure (Mon 05 11:50)

Re: updating a row in a table with only one row Michal Vitecek (Tue 06 14:59)
Re: updating a row in a table with only one row Merlin Moncure (Tue 06 15:25)
Re: updating a row in a table with only one row Craig James (Tue 06 16:06)
Re: updating a row in a table with only one row Michal Vitecek (Mon 12 09:23)
Re: updating a row in a table with only one row Merlin Moncure (Mon 12 14:25)

AMD, Intel and RAID controllers Benjamin Minshall (Thu 01 17:16)

Re: AMD, Intel and RAID controllers Greg Smith (Thu 01 19:01)
Re: AMD, Intel and RAID controllers Alpesh Gajbe (Fri 02 06:42)
Re: AMD, Intel and RAID controllers alpesh gajbe (Fri 02 06:48)

Re: AMD, Intel and RAID controllers Scott Marlowe (Fri 02 12:50)

Re: AMD, Intel and RAID controllers Greg Smith (Fri 30 01:39)

Re: Database performance post-VACUUM FULL Kevin Grittner (Thu 01 13:25)
Re: Speed while runnning large transactions. Greg Smith (Thu 01 10:10)

Re: Speed while runnning large transactions. Tom Lane (Thu 01 15:06)

Re: Speed while runnning large transactions. Kevin Grittner (Fri 02 20:30)

Re: Speed while runnning large transactions. Tom Lane (Fri 02 22:01)

Re: Speed while runnning large transactions. Greg Smith (Mon 05 18:59)

Re: CPU cost of operators Matthew Wakeling (Thu 01 09:47)
Best suiting OS S Arvind (Thu 01 09:47)

Re: Best suiting OS Matthew Wakeling (Thu 01 10:00)

Re: Best suiting OS Jean-David Beyer (Thu 01 10:14)

Mail converted by MHonArc

Privacy Policy | About PostgreSQL
Copyright © 1996 – 2012 PostgreSQL Global Development Group