Skip site navigation (1)
Skip section navigation (2)
344 messages
13 September 2009
Re: [PERFORMANCE] work_mem vs temp files issue decibel (22:12)
Re: Persistent Plan Cache Stephen Frost (21:55)
Re: Persistent Plan Cache Heikki Linnakangas (19:40)
Re: possible wrong query plan on pg 8.3.5, Tom Lane (19:21)
Re: Persistent Plan Cache Joshua Rubin (18:19)
Re: Persistent Plan Cache Tom Lane (17:45)
possible wrong query plan on pg 8.3.5, zz_11 (07:26)
12 September 2009
Re: View vs Stored Proc Performance Dimitri Fontaine (11:51)
11 September 2009
Re: View vs Stored Proc Performance Merlin Moncure (21:53)
Re: slow query : very simple delete, 100% cpu, nearly no disk activity Robert Haas (21:30)
Re: View vs Stored Proc Performance Jason Tesser (21:27)
Re: View vs Stored Proc Performance Merlin Moncure (21:01)
Re: odd iostat graph Greg Smith (20:47)
Persistent Plan Cache Joshua Rubin (20:34)
Re: odd iostat graph Alan McKay (20:31)
Re: odd iostat graph Greg Smith (20:28)
Re: View vs Stored Proc Performance Jason Tesser (18:56)
Re: odd iostat graph Kevin Grittner (18:22)
Re: odd iostat graph Alan McKay (18:13)
Re: odd iostat graph Scott Carey (18:02)
Re: View vs Stored Proc Performance Merlin Moncure (17:38)
odd iostat graph Alan McKay (16:58)
View vs Stored Proc Performance Jason Tesser (15:47)
Re: PSQL 8.4 - partittions - join tables - not optimal plan A. Kretschmer (05:33)
10 September 2009
Re: Sub-optimal plan chosen Tom Lane (17:56)
Re: Sub-optimal plan chosen bricklen (17:12)
Re: Sub-optimal plan chosen bricklen (17:07)
Re: Sub-optimal plan chosen Robert Haas (17:03)
Re: Sub-optimal plan chosen bricklen (17:01)
Re: Sub-optimal plan chosen Robert Haas (16:57)
Re: Sub-optimal plan chosen bricklen (16:57)
Re: Sub-optimal plan chosen Tom Lane (15:43)
Re: Sub-optimal plan chosen tv (15:40)
Re: Best Profiler for PostgreSQL Robert Haas (15:30)
Re: Sub-optimal plan chosen bricklen (15:25)
Re: Sub-optimal plan chosen tv (14:57)
Sub-optimal plan chosen bricklen (14:35)
09 September 2009
Re: partitioning max() sql not using index Kenneth Cox (13:57)
Best Profiler for PostgreSQL Reydan Cankur (10:15)
Re: partitioning max() sql not using index Heikki Linnakangas (10:05)
Re: Forcing postgresql to use an index Eugene Morozov (05:35)
08 September 2009
Re: [GENERAL] [sfpug] Statistics and PostgreSQL: Streaming Webcast tonight David Fetter (18:31)
Re: [sfpug] Statistics and PostgreSQL: Streaming Webcast tonight David Fetter (17:33)
Statistics and PostgreSQL: Streaming Webcast tonight David Fetter (17:31)
Re: Forcing postgresql to use an index Scott Marlowe (17:25)
Re: Forcing postgresql to use an index Kevin Grittner (16:30)
Re: Forcing postgresql to use an index Eugene Morozov (16:20)
Re: Forcing postgresql to use an index Grzegorz Jaśkiewicz (15:33)
Forcing postgresql to use an index Eugene Morozov (15:25)
Re: Using Gprof with Postgresql Craig James (15:13)
Re: Using Gprof with Postgresql Pierre Frédéric Caillau d (12:43)
Re: Using Gprof with Postgresql Reydan Cankur (12:35)
Re: Using Gprof with Postgresql Reydan Cankur (12:32)
Re: Planner question - "bit" data types Tom Lane (03:36)
Re: Planner question - "bit" data types Robert Haas (02:54)
Re: Planner question - "bit" data types Alvaro Herrera (02:23)
Re: Planner question - "bit" data types Karl Denninger (02:06)
Re: Planner question - "bit" data types Brian Cox (01:35)
Re: Planner question - "bit" data types Robert Haas (01:13)
Re: Planner question - "bit" data types Karl Denninger (00:52)
Re: Planner question - "bit" data types Robert Haas (00:49)
07 September 2009
Re: Using Gprof with Postgresql Tom Lane (17:25)
Re: Using Gprof with Postgresql Jeff Janes (17:24)
PSQL 8.4 - partittions - join tables - not optimal plan Vratislav Benes (15:49)
Re: Using Gprof with Postgresql Grzegorz Jaśkiewicz (15:32)
Using Gprof with Postgresql Reydan Cankur (15:11)
Re: slow query : very simple delete, 100% cpu, nearly no disk activity Vincent de Phily (09:13)
Re: slow query : very simple delete, 100% cpu, nearly no disk activity Tom Lane (01:25)
06 September 2009
Re: Planner question - "bit" data types Karl Denninger (00:24)
Re: Planner question - "bit" data types Alvaro Herrera (00:15)
05 September 2009
Re: Planner question - "bit" data types Tom Lane (23:24)
Re: Planner question - "bit" data types Karl Denninger (21:44)
Re: Planner question - "bit" data types Tom Lane (21:35)
Re: Planner question - "bit" data types Karl Denninger (21:10)
Re: Planner question - "bit" data types Tom Lane (20:59)
Re: Planner question - "bit" data types Merlin Moncure (20:09)
04 September 2009
Re: Seeking performance advice and explanation for high I/O on 8.3 Kevin Grittner (22:09)
Re: Seeking performance advice and explanation for high I/O on 8.3 Scott Otis (21:55)
Planner question - "bit" data types Karl Denninger (19:15)
slow query : very simple delete, 100% cpu, nearly no disk activity Vincent de Phily (11:10)
Re: Seeking performance advice and explanation for high I/O on 8.3 Magnus Hagander (08:51)
Re: Seeking performance advice and explanation for high I/O on 8.3 Claus Guttesen (06:59)
Re: Seeking performance advice and explanation for high I/O on 8.3 Scott Otis (06:55)
Re: Seeking performance advice and explanation for high I/O on 8.3 Scott Otis (06:37)
Re: Seeking performance advice and explanation for high I/O on 8.3 Robert Haas (03:06)
Re: PostgreSQL not using index for statement with group by Scott Marlowe (02:11)
03 September 2009
Re: Seeking performance advice and explanation for high I/O on 8.3 Scott Otis (23:11)
Re: Seeking performance advice and explanation for high I/O on 8.3 Scott Otis (22:51)
Re: PostgreSQL not using index for statement with group by Kevin Grittner (22:04)
Re: Seeking performance advice and explanation for high I/O on 8.3 Ivan Voras (21:57)
Re: Seeking performance advice and explanation for high I/O on 8.3 Robert Haas (21:40)
Re: Seeking performance advice and explanation for high I/O on 8.3 Andy Colson (21:27)
Re: Slow select times on select with xpath Robert Haas (21:20)
Re: Seeking performance advice and explanation for high I/O on 8.3 Robert Haas (21:19)
Re: Seeking performance advice and explanation for high I/O on 8.3 Andy Colson (21:09)
Re: Seeking performance advice and explanation for high I/O on 8.3 Scott Otis (20:16)
Re: Slow select times on select with xpath astro77 (20:06)
Re: Slow select times on select with xpath Robert Haas (18:25)
Re: Seeking performance advice and explanation for high I/O on 8.3 Andy Colson (17:12)
Re: partition query using Seq Scan even when index is present Kenneth Cox (16:13)
Re: Seeking performance advice and explanation for high I/O on 8.3 Andy Colson (15:29)
Re: Slow select times on select with xpath Kevin Grittner (15:29)
Re: Seeking performance advice and explanation for high I/O on 8.3 Ivan Voras (15:11)
Re: partition query using Seq Scan even when index is present Merlin Moncure (14:49)
Re: Help: how to speed up query after db server reboot Tom Lane (14:32)
Re: SAAS and MySQL Tguru (13:53)
PostgreSQL not using index for statement with group by Mark Starkman (13:48)
Re: pg_stat_activity.current_query explanation? Joshua Tolley (13:06)
Re: Help: how to speed up query after db server reboot Magnus Hagander (07:51)
02 September 2009
Re: partition query using Seq Scan even when index is present Greg Jaman (20:31)
partition query using Seq Scan even when index is present Kenneth Cox (20:15)
Re: partition queries hitting all partitions even though check key is specified Scott Carey (18:29)
Re: partition queries hitting all partitions even though check key is specified Tom Lane (18:22)
Re: partition queries hitting all partitions even though check key is specified Tom Lane (17:23)
Looking for real configuration data Wei Zheng (16:41)
Re: partition queries hitting all partitions even though check key is specified Joshua D. Drake (15:59)
Re: partition queries hitting all partitions even though check key is specified Kevin Kempter (15:39)
pg_stat_activity.current_query explanation? Pat Chan (15:29)
Re: partition queries hitting all partitions even though check key is specified Greg Stark (15:22)
Re: partition queries hitting all partitions even though check key is specified Tom Lane (15:21)
Re: partition queries hitting all partitions even though check key is specified Greg Jaman (15:17)
Re: partition queries hitting all partitions even though check key is specified bricklen (15:16)
Re: partition queries hitting all partitions even though check key is specified Kevin Kempter (15:06)
Re: partition queries hitting all partitions even though check key is specified Kevin Kempter (15:05)
Slow select times on select with xpath astro77 (15:04)
Re: partition queries hitting all partitions even though check key is specified Scott Marlowe (15:02)
Re: partition queries hitting all partitions even though check key is specified Kenneth Marshall (14:56)
partition queries hitting all partitions even though check key is specified Kevin Kempter (14:52)
01 September 2009
Help: how to speed up query after db server reboot Wei Yan (22:01)
Re: moving data between tables causes the db to overwhelm the system Robert Schnabel (12:43)
Re: moving data between tables causes the db to overwhelm the system Pierre Frédéric Caillau d (11:08)
Re: moving data between tables causes the db to overwhelm the system tv (09:54)
Re: moving data between tables causes the db to overwhelm the system Kevin Kempter (09:32)
Re: moving data between tables causes the db to overwhelm the system Pierre Frédéric Caillau d (09:25)
Re: moving data between tables causes the db to overwhelm the system tv (08:58)
moving data between tables causes the db to overwhelm the system Kevin Kempter (08:46)
Peripheral Links
Header And Logo
|
Site Navigation
pgsql-performance 2009-09 Chronological Index (2/2)
Last updated: Wed Jan 18 04:14:34 2012344 messages
- Thread Index
- [Prev Page]
- [Next Page]
- 14 September 2009
- Re: CLUSTER and a problem Josh Berkus (18:05)
- Re: possible wrong query plan on pg 8.3.5, zz_11 (16:14)
- Re: possible wrong query plan on pg 8.3.5, zz_11 (16:07)
- Re: possible wrong query plan on pg 8.3.5, Scott Marlowe (15:51)
- Re: possible wrong query plan on pg 8.3.5, Robert Haas (15:30)
- CLUSTER and a problem Andrzej Zawadzki (14:25)
- Re: possible wrong query plan on pg 8.3.5, zz_11 (14:17)
- CLUSTER and a problem Andrzej Zawadzki (13:54)
- Re: possible wrong query plan on pg 8.3.5, Robert Haas (13:38)
- Re: possible wrong query plan on pg 8.3.5, zz_11 (10:49)
- Re: Persistent Plan Cache Ivan Voras (10:35)
- Re: possible wrong query plan on pg 8.3.5, tv (09:32)
- Re: Persistent Plan Cache Dimitri Fontaine (07:33)
- Re: possible wrong query plan on pg 8.3.5, zz_11 (06:27)
- Re: Persistent Plan Cache Heikki Linnakangas (05:01)
- Re: [PERFORMANCE] work_mem vs temp files issue Tom Lane (22:37)
- Re: View vs Stored Proc Performance Merlin Moncure (13:23)
- Re: slow query : very simple delete, 100% cpu, nearly no disk activity Merlin Moncure (21:55)
- Re: Sub-optimal plan chosen bricklen (18:03)
- Re: partitioning max() sql not using index Kevin Kempter (14:29)
- partitioning max() sql not using index Kevin Kempter (20:53)
- Re: Planner question - "bit" data types Fernando Hevia (19:32)
- Re: Planner question - "bit" data types Merlin Moncure (05:36)
- Re: Planner question - "bit" data types Karl Denninger (23:39)
- Re: Planner question - "bit" data types Josh Berkus (22:30)
- Re: SAAS and MySQL Merlin Moncure (23:34)
- Seeking performance advice and explanation for high I/O on 8.3 Scott Otis (20:57)
- Re: Performance issues with large amounts of time-series data हृषीकेश मेहेंदळ े (22:12)
- Thread Index
- [Prev Page]
- [Next Page]