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

Peripheral Links

Text Size: Normal / Large
Donate
Contact

PostgreSQL

The world's most advanced open source database.

pgsql-performance - September 2009

Prev | Next

Jump to day: 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 20 21 22 23 24 25 26 27 28 29 30

Sept. 1, 2009

Re: Number of tables Mike Ivanov (00:19)
Re: Number of tables Greg Stark (01:01)
Re: Number of tables Mike Ivanov (01:10)
Re: BUG #4919: CREATE USER command slows down system performance Alvaro Herrera (02:59)
moving data between tables causes the db to overwhelm the system Kevin Kempter (08:45)
Re: moving data between tables causes the db to overwhelm the system tv (08:58)
Re: moving data between tables causes the db to overwhelm the system Pierre Frédéric Caillaud (09:26)
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 tv (09:54)
Re: moving data between tables causes the db to overwhelm the system Pierre Frédéric Caillaud (11:09)
Re: moving data between tables causes the db to overwhelm the system Robert Schnabel (12:33)
Help: how to speed up query after db server reboot Wei Yan (22:01)
Re: Performance issues with large amounts of time-series data हृषीकेश मेहेंदळ <hashinclude@gmail.com> (22:11)

Sept. 2, 2009

partition queries hitting all partitions even though check key is specified Kevin Kempter (14:52)
Re: partition queries hitting all partitions even thoughcheck key is specified Kenneth Marshall (14:55)
Re: partition queries hitting all partitions even though check key is specified Scott Marlowe (15:02)
Slow select times on select with xpath astro77 (15:04)
Re: partition queries hitting all partitions even though check key is specified Kevin Kempter (15:05)
Re: partition queries hitting all partitions even though check key is specified Kevin Kempter (15:05)
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 Greg Jaman (15:17)
Re: partition queries hitting all partitions even though check key is specified Tom Lane (15:19)
Re: partition queries hitting all partitions even though check key is specified Greg Stark (15:22)
pg_stat_activity.current_query explanation? Pat Chan (15:29)
Re: partition queries hitting all partitions even though check key is specified Kevin Kempter (15:39)
Looking for real configuration data Wei Zheng (15:39)
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 Tom Lane (17:23)
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 Scott Carey (18:28)
partition query using Seq Scan even when index is present Kenneth Cox (20:15)
Re: partition query using Seq Scan even when index is present Greg Jaman (20:31)
Seeking performance advice and explanation for high I/O on 8.3 Scott Otis (20:44)

Sept. 3, 2009

Re: Help: how to speed up query after db server reboot Magnus Hagander (07:51)
Re: pg_stat_activity.current_query explanation? Joshua Tolley (13:05)
PostgreSQL not using index for statement with group by Mark Starkman (13:33)
Re: SAAS and MySQL Tguru (13:52)
Re: Help: how to speed up query after db server reboot Tom Lane (14:32)
Re: partition query using Seq Scan even when index is present Merlin Moncure (14:49)
Re: Seeking performance advice and explanation for high I/O on 8.3 Andy Colson (15:02)
Re: Seeking performance advice and explanation for high I/O on 8.3 Ivan Voras (15:11)
Re: Slow select times on select with xpath Kevin Grittner (15:27)
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 (17:12)
Re: Slow select times on select with xpath Robert Haas (18:25)
Re: Slow select times on select with xpath astro77 (20:06)
Re: Seeking performance advice and explanation for high I/O on 8.3 Scott Otis (20:16)
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 Robert Haas (21:19)
Re: Slow select times on select with xpath Robert Haas (21:19)
Re: Seeking performance advice and explanation for high I/O on 8.3 Andy Colson (21:27)
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 Ivan Voras (21:56)
Re: PostgreSQL not using index for statement with group by Kevin Grittner (22:03)
Re: Seeking performance advice and explanation for high I/O on 8.3 Scott Otis (22:51)
Re: Seeking performance advice and explanation for high I/O on 8.3 Scott Otis (23:11)
Re: SAAS and MySQL Merlin Moncure (23:33)

Sept. 4, 2009

Re: PostgreSQL not using index for statement with group by Scott Marlowe (02:10)
Re: Seeking performance advice and explanation for high I/O on 8.3 Robert Haas (03:05)
Re: Seeking performance advice and explanation for high I/O on 8.3 Scott Otis (06:34)
Re: Seeking performance advice and explanation for high I/O on 8.3 Scott Otis (06:54)
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 Magnus Hagander (08:18)
slow query : very simple delete, 100% cpu, nearly no disk activity Vincent de Phily (10:39)
Planner question - "bit" data types Karl Denninger (19:15)
Re: Seeking performance advice and explanation for high I/O on 8.3 Scott Otis (21:55)
Re: Seeking performance advice and explanation for high I/O on 8.3 Kevin Grittner (22:09)
Re: Planner question - "bit" data types Josh Berkus (22:29)

Sept. 5, 2009

Re: Planner question - "bit" data types Merlin Moncure (20:09)
Re: Planner question - "bit" data types Tom Lane (20:59)
Re: Planner question - "bit" data types Karl Denninger (21:09)
Re: Planner question - "bit" data types Tom Lane (21:33)
Re: Planner question - "bit" data types Karl Denninger (21:39)
Re: Planner question - "bit" data types Tom Lane (23:24)
Re: Planner question - "bit" data types Karl Denninger (23:39)

Sept. 6, 2009

Re: Planner question - "bit" data types Alvaro Herrera (00:15)
Re: Planner question - "bit" data types Karl Denninger (00:19)
Re: Planner question - "bit" data types Merlin Moncure (05:36)

Sept. 7, 2009

Re: slow query : very simple delete, 100% cpu, nearly no disk activity Tom Lane (01:25)
Re: slow query : very simple delete, 100% cpu, nearly no disk activity Vincent de Phily (09:05)
Using Gprof with Postgresql Reydan Cankur (15:11)
Re: Using Gprof with Postgresql Grzegorz Jaśkiewicz (15:32)
PSQL 8.4 - partittions - join tables - not optimal plan Vratislav Benes (15:39)
Re: Using Gprof with Postgresql Jeff Janes (17:18)
Re: Using Gprof with Postgresql Tom Lane (17:24)
Re: Planner question - "bit" data types Fernando Hevia (19:33)

Sept. 8, 2009

Re: Planner question - "bit" data types Robert Haas (00:49)
Re: Planner question - "bit" data types Karl Denninger (00:51)
Re: Planner question - "bit" data types Robert Haas (01:12)
Re: Planner question - "bit" data types Brian Cox (01:22)
Re: Planner question - "bit" data types Karl Denninger (02:05)
Re: Planner question - "bit" data types Alvaro Herrera (02:22)
Re: Planner question - "bit" data types Robert Haas (02:54)
Re: Planner question - "bit" data types Tom Lane (03:36)
Re: Using Gprof with Postgresql Reydan Cankur (12:31)
Re: Using Gprof with Postgresql Reydan Cankur (12:35)
Re: Using Gprof with Postgresql Pierre Frédéric Caillaud (12:44)
Forcing postgresql to use an index Eugene Morozov (14:12)
Re: Using Gprof with Postgresql Craig James (14:30)
Re: Forcing postgresql to use an index Grzegorz Jaśkiewicz (15:33)
Re: Forcing postgresql to use an index Eugene Morozov (16:00)
Re: Forcing postgresql to use an index Kevin Grittner (16:30)
Re: Forcing postgresql to use an index Scott Marlowe (17:25)
Statistics and PostgreSQL: Streaming Webcast tonight David Fetter (17:30)
Re: [sfpug] Statistics and PostgreSQL: Streaming Webcast tonight David Fetter (17:32)
Re: [sfpug] Statistics and PostgreSQL: Streaming Webcasttonight David Fetter (18:17)
partitioning max() sql not using index Kevin Kempter (20:53)

Sept. 9, 2009

Re: Forcing postgresql to use an index Eugene Morozov (05:34)
Re: partitioning max() sql not using index Heikki Linnakangas (10:05)
Best Profiler for PostgreSQL Reydan Cankur (10:15)
Re: partitioning max() sql not using index Kenneth Cox (13:56)
Re: partitioning max() sql not using index Kevin Kempter (14:29)

Sept. 10, 2009

Sub-optimal plan chosen bricklen (14:34)
Re: Sub-optimal plan chosen tv (14:57)
Re: Sub-optimal plan chosen bricklen (15:25)
Re: Best Profiler for PostgreSQL Robert Haas (15:30)
Re: Sub-optimal plan chosen tv (15:40)
Re: Sub-optimal plan chosen Tom Lane (15:43)
Re: Sub-optimal plan chosen bricklen (16:56)
Re: Sub-optimal plan chosen Robert Haas (16:57)
Re: Sub-optimal plan chosen bricklen (17:01)
Re: Sub-optimal plan chosen Robert Haas (17:02)
Re: Sub-optimal plan chosen bricklen (17:07)
Re: Sub-optimal plan chosen bricklen (17:12)
Re: Sub-optimal plan chosen Tom Lane (17:56)
Re: Sub-optimal plan chosen bricklen (18:02)

Sept. 11, 2009

Re: PSQL 8.4 - partittions - join tables - not optimal plan A. Kretschmer (05:33)
View vs Stored Proc Performance Jason Tesser (15:46)
odd iostat graph Alan McKay (16:58)
Re: View vs Stored Proc Performance Merlin Moncure (17:37)
Re: odd iostat graph Scott Carey (18:02)
Re: odd iostat graph Alan McKay (18:13)
Re: odd iostat graph Kevin Grittner (18:22)
Re: View vs Stored Proc Performance Jason Tesser (18:56)
Persistent Plan Cache Joshua Rubin (20:16)
Re: odd iostat graph Greg Smith (20:28)
Re: odd iostat graph Alan McKay (20:31)
Re: odd iostat graph Greg Smith (20:47)
Re: View vs Stored Proc Performance Merlin Moncure (21:01)
Re: View vs Stored Proc Performance Jason Tesser (21:27)
Re: slow query : very simple delete, 100% cpu, nearly no disk activity Robert Haas (21:30)
Re: View vs Stored Proc Performance Merlin Moncure (21:53)
Re: slow query : very simple delete, 100% cpu, nearly no disk activity Merlin Moncure (21:55)

Sept. 12, 2009

Re: View vs Stored Proc Performance Dimitri Fontaine (11:51)
Re: View vs Stored Proc Performance Merlin Moncure (13:22)

Sept. 13, 2009

possible wrong query plan on pg 8.3.5, zz_11 (07:17)
Re: Persistent Plan Cache Tom Lane (17:45)
Re: Persistent Plan Cache Joshua Rubin (18:15)
Re: possible wrong query plan on pg 8.3.5, Tom Lane (19:21)
Re: Persistent Plan Cache Heikki Linnakangas (19:40)
Re: Persistent Plan Cache Stephen Frost (21:54)
Re: [PERFORMANCE] work_mem vs temp files issue decibel (22:12)
Re: [PERFORMANCE] work_mem vs temp files issue Tom Lane (22:37)

Sept. 14, 2009

Re: Persistent Plan Cache Heikki Linnakangas (05:01)
Re: possible wrong query plan on pg 8.3.5, zz_11 (06:16)
Re: Persistent Plan Cache Dimitri Fontaine (07:33)
Re: possible wrong query plan on pg 8.3.5, tv (09:32)
Re: Persistent Plan Cache Ivan Voras (10:30)
Re: possible wrong query plan on pg 8.3.5, zz_11 (10:49)
Re: possible wrong query plan on pg 8.3.5, Robert Haas (13:38)
CLUSTER and a problem Andrzej Zawadzki (13:54)
Re: possible wrong query plan on pg 8.3.5, zz_11 (14:17)
CLUSTER and a problem Andrzej Zawadzki (14:19)
Re: possible wrong query plan on pg 8.3.5, Robert Haas (15:30)
Re: possible wrong query plan on pg 8.3.5, Scott Marlowe (15:51)
Re: possible wrong query plan on pg 8.3.5, zz_11 (16:07)
Re: possible wrong query plan on pg 8.3.5, zz_11 (16:13)
Re: CLUSTER and a problem Josh Berkus (18:05)
How to post Performance Questions Josh Berkus (20:55)
Re: CLUSTER and a problem Andrzej Zawadzki (21:08)
Possible causes of sometimes slow single-row UPDATE with trivial indexed condition? Vlad Romascanu (21:25)
noapic option C Storm (21:48)
Re: CLUSTER and a problem Tom Lane (23:13)
Re: How to post Performance Questions Michael Glaesemann (23:19)

Sept. 15, 2009

Re: possible wrong query plan on pg 8.3.5, Віталій Тимчишин (06:32)
Re: CLUSTER and a problem Andrzej Zawadzki (07:36)
disable heavily updated (but small) table auto-vecuuming Ludwik Dylag (08:06)
statistical table std pik (09:27)
Re: possible wrong query plan on pg 8.3.5, zz_11 (10:09)
Re: CLUSTER and a problem Andrzej Zawadzki (11:13)
Problem with partitionning and orderby query plans Gaël Le Mignot (12:58)
Re: How to post Performance Questions Kevin Grittner (14:50)
Re: View vs Stored Proc Performance Ivan Voras (15:14)
Re: View vs Stored Proc Performance Tom Lane (15:26)
Re: disable heavily updated (but small) table auto-vecuuming Robert Haas (15:44)
Re: View vs Stored Proc Performance Ivan Voras (16:12)
statement stats extra load? Alan McKay (18:10)
Re: CLUSTER and a problem Andrzej Zawadzki (20:10)

Sept. 16, 2009

Re: CLUSTER and a problem Grzegorz Jaśkiewicz (09:34)

Sept. 17, 2009

Re: Possible causes of sometimes slow single-row UPDATE with trivial indexed condition? Richard Huxton (07:58)
Re: noapic option Craig Ringer (08:00)
optimizing for temporal data behind a view Richard Henwood (12:55)
Re: statistical table Lennin Caro (13:43)
Re: statistical table Joshua Tolley (13:43)
Re: Possible causes of sometimes slow single-row UPDATE with trivial indexed condition? Andy Colson (13:45)
Use of BETWEEN with identical values André Volpato (14:53)
Re: optimizing for temporal data behind a view हृषीकेश मेहेंदळ <hashinclude@gmail.com> (14:54)
Re: Possible causes of sometimes slow single-row UPDATE with trivial indexed condition? Vlad Romascanu (16:42)
Re: noapic option christian.storm (18:03)
Re: Use of BETWEEN with identical values André Volpato (21:02)

Prev | Next

Jump to day: 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 20 21 22 23 24 25 26 27 28 29 30

Privacy Policy | About PostgreSQL
Copyright © 1996-2013 The PostgreSQL Global Development Group