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 - October 2011

Prev | Next

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

2011-10-02

Suggestions for Intel 710 SSD test David Boreham (02:39)
Re: Suggestions for Intel 710 SSD test Andy (03:22)
Re: Suggestions for Intel 710 SSD test Gregory Gerard (04:00)
Re: Suggestions for Intel 710 SSD test Arjen van der Meijden (08:33)
[No subject] Eduardo Nazor (09:59)
Re: Suggestions for Intel 710 SSD test David Boreham (13:49)
Re: Suggestions for Intel 710 SSD test David Boreham (14:02)
Re: Suggestions for Intel 710 SSD test David Boreham (23:33)

2011-10-03

Re: Suggestions for Intel 710 SSD test Gregory Gerard (00:26)
Re: Suggestions for Intel 710 SSD test David Boreham (00:44)
Re: Suggestions for Intel 710 SSD test Greg Smith (04:35)
Re: Suggestions for Intel 710 SSD test David Boreham (04:49)
Re: Suggestions for Intel 710 SSD test David Boreham (05:24)
Re: Suggestions for Intel 710 SSD test Gregory Gerard (05:55)
Re: Suggestions for Intel 710 SSD test David Boreham (05:57)
Query with order by and limit is very slow - wrong index used Nowak Michał (09:44)
Re: Query with order by and limit is very slow - wrong index used Gregg Jaskiewicz (10:02)
Re: Query with order by and limit is very slow - wrong index used Nowak Michał (10:51)
Re: : Performance Improvement Strategy Venkat Balaji (10:59)
Re: Query with order by and limit is very slow - wrong index used Gregg Jaskiewicz (11:20)
Fwd: Query with order by and limit is very slow - wrong index used Nowak Michał (13:08)
How can i get record by data block not by sql? 姜头 (13:52)
Re: Query with order by and limit is very slow - wrong index used Nowak Michał (13:59)
Re: Query with order by and limit is very slow - wrong index used Cédric Villemain (14:28)
Re: How can i get record by data block not by sql? Ben Chobot (14:29)
Re: Query with order by and limit is very slow - wrong index used Tom Lane (15:12)
Re: : Performance Improvement Strategy Kevin Grittner (16:15)
Re: : Performance Improvement Strategy Venkat Balaji (16:54)
pkey is not used on productive database Soporte @ TEKSOL S.A. (17:48)
Re: Query with order by and limit is very slow - wrong index used Marcin Mańk (22:45)

2011-10-04

Re: Query with order by and limit is very slow - wrong index used Nowak Michał (07:10)
Re: array_except -- Find elements that are not common to both arrays Gavin Flower (07:16)
Re: Query with order by and limit is very slow - wrong index used Gregg Jaskiewicz (08:08)
Re: Query with order by and limit is very slow - wrong index used Nowak Michał (08:55)
Window functions and index usage Anssi Kääriäinen (09:39)
: Column Performance in a query Venkat Balaji (10:25)
Re: : PG9.0 - Checkpoint tuning and pg_stat_bgwriter Venkat Balaji (10:50)
Re: : PG9.0 - Checkpoint tuning and pg_stat_bgwriter Heikki Linnakangas (11:08)
Re: : PG9.0 - Checkpoint tuning and pg_stat_bgwriter Venkat Balaji (11:23)
Re: pkey is not used on productive database hubert depesz lubaczewski (12:55)
Re: pkey is not used on productive database Scott Marlowe (13:01)
Re: Window functions and index usage Robert Klemme (13:27)
Re: Window functions and index usage Anssi Kääriäinen (14:06)
Re: : PG9.0 - Checkpoint tuning and pg_stat_bgwriter pasman pasmański (14:15)
Re: Window functions and index usage Tom Lane (14:36)
Re: Window functions and index usage Robert Klemme (14:52)
Re: Window functions and index usage Anssi Kääriäinen (15:00)
Re: Window functions and index usage Anssi Kääriäinen (15:05)
Re: array_except -- Find elements that are not common to both arrays Merlin Moncure (16:10)
Re: : Column Performance in a query Ondrej Ivanič (22:26)
Re: : PG9.0 - Checkpoint tuning and pg_stat_bgwriter Greg Smith (22:32)
Re: : PG9.0 - Checkpoint tuning and pg_stat_bgwriter Scott Marlowe (22:47)
Re: Query with order by and limit is very slow - wrong index used Kevin Grittner (23:33)

2011-10-05

Re: : PG9.0 - Checkpoint tuning and pg_stat_bgwriter Venkat Balaji (02:50)
Re: : PG9.0 - Checkpoint tuning and pg_stat_bgwriter Greg Smith (05:32)
Re: : Performance Improvement Strategy Venkat Balaji (09:08)
Re: : Performance Improvement Strategy Raghavendra (09:30)
Re: : Performance Improvement Strategy Guillaume Cottenceau (09:39)
Re: : Performance Improvement Strategy Kevin Grittner (16:13)
Re: : Performance Improvement Strategy Scott Marlowe (17:09)
Re: : Performance Improvement Strategy Tom Lane (18:15)
Intel 710 Endurance Test Results David Boreham (19:15)
pg9 replication over WAN ? Ben Ciceron (21:53)
Re: Allow sorts to use more available memory Bruce Momjian (21:54)

2011-10-06

Re: : Performance Improvement Strategy Raghavendra (09:31)
Re: : Performance Improvement Strategy Scott Marlowe (19:20)

2011-10-07

Re: pg9 replication over WAN ? mark (03:22)
Performance problem with a table with 38928077 record Giovanni Mancuso (10:04)
Re: Performance problem with a table with 38928077 record Guillaume Cottenceau (10:24)
Re: Performance problem with a table with 38928077 record Gregg Jaskiewicz (10:29)
Re: Performance problem with a table with 38928077 record Cédric Villemain (12:59)
Re: Performance problem with a table with 38928077 record Giovanni Mancuso (15:12)
Re: PostgreSQL-9.0 Monitoring System to improve performance Fernando Hevia (22:01)
Re: PostgreSQL-9.0 Monitoring System to improve performance Ben Ciceron (22:13)

2011-10-08

Re: Performance problem with a table with 38928077 record Giovanni Mancuso (15:04)

2011-10-10

Re: : Performance Improvement Strategy Leonardo Francalanci (08:04)
Adding more memory = hugh cpu load alexandre - aldeia digital (13:26)
Re: Adding more memory = hugh cpu load Kevin Grittner (13:51)
Re: Adding more memory = hugh cpu load Shaun Thomas (14:04)
Re: Adding more memory = hugh cpu load Leonardo Francalanci (15:14)
Re: Adding more memory = hugh cpu load Shaun Thomas (15:39)
Re: Adding more memory = hugh cpu load Greg Smith (16:07)
Re: Adding more memory = hugh cpu load Leonardo Francalanci (16:14)
Re: Adding more memory = hugh cpu load alexandre - aldeia digital (17:31)
Re: Adding more memory = hugh cpu load Kevin Grittner (17:46)
Re: Adding more memory = hugh cpu load alexandre - aldeia digital (18:54)
Re: Adding more memory = hugh cpu load Kevin Grittner (19:39)
Re: Adding more memory = hugh cpu load Shaun Thomas (20:25)
Re: Adding more memory = hugh cpu load alexandre - aldeia digital (20:34)
Re: Adding more memory = hugh cpu load Kevin Grittner (20:52)
Rapidly finding maximal rows James Cranch (21:59)
Re: Adding more memory = hugh cpu load Samuel Gendler (22:02)

2011-10-11

Re: Adding more memory = hugh cpu load Claudio Freire (02:19)
Re: Adding more memory = hugh cpu load Greg Smith (06:42)
Re: Adding more memory = hugh cpu load Greg Smith (06:50)
Re: Adding more memory = hugh cpu load Leonardo Francalanci (08:57)
Rapidly finding maximal rows James Cranch (10:16)
Re: Adding more memory = hugh cpu load Ivan Voras (10:20)
Re: Adding more memory = hugh cpu load alexandre - aldeia digital (11:54)
Re: Adding more memory = hugh cpu load alexandre - aldeia digital (12:14)
Re: Adding more memory = hugh cpu load Luca Tettamanti (12:50)
Composite keys Carlo Stonebanks (15:16)
Re: Adding more memory = hugh cpu load Greg Smith (15:32)
Query tuning help CS DBA (17:52)
Re: Query tuning help Pavel Stehule (18:02)
Re: Adding more memory = hugh cpu load [solved] alexandre - aldeia digital (18:02)
Re: Query tuning help Szymon Guz (18:03)
Re: Adding more memory = hugh cpu load [solved] Claudio Freire (18:05)
Re: Query tuning help CS DBA (18:14)
Re: should i expected performance degradation over time Anibal David Acosta (18:20)
Re: Query tuning help CS DBA (18:31)
Re: Query tuning help Pavel Stehule (18:59)
postgresql query runtime Radhya sahal (19:08)
Re: postgresql query runtime Pavel Stehule (19:11)
Re: postgresql query runtime Szymon Guz (19:13)
Re: postgresql query runtime Szymon Guz (19:14)
Re: postgresql query runtime Kevin Grittner (19:15)
Re: Adding more memory = hugh cpu load [solved] alexandre - aldeia digital (20:02)
Re: Adding more memory = hugh cpu load [solved] Claudio Freire (20:08)
Re: Adding more memory = hugh cpu load [solved] Arjen van der Meijden (20:33)
Re: Adding more memory = hugh cpu load [solved] Claudio Freire (20:46)
Re: postgresql query runtime Radhya sahal (21:29)
Re: postgresql query runtime Kevin Grittner (21:43)
Re: Rapidly finding maximal rows bricklen (23:22)

2011-10-12

Re: Composite keys Claudio Freire (00:52)
Re: Rapidly finding maximal rows Dave Crooke (01:05)
Re: Composite keys Dave Crooke (01:28)
Re: Composite keys Carlo Stonebanks (04:39)
Join over two tables of 50K records takes 2 hours Svetlin Manavski (08:55)
Re: Composite keys Greg Smith (10:26)
Re: Rapidly finding maximal rows James Cranch (11:40)
Re: Rapidly finding maximal rows James Cranch (11:41)

2011-10-13

Tablespace files deleted automatically. Vishnu S. (12:52)
Re: Slow query when using ORDER BY *and* LIMIT davidsarmstrong (19:34)

2011-10-14

Re: Rapidly finding maximal rows Tom Lane (04:25)
Re: Join over two tables of 50K records takes 2 hours Tom Lane (04:37)
Re: Join over two tables of 50K records takes 2 hours Scott Marlowe (04:38)
SSD options, small database, ZFS CSS (08:23)
Re: Join over two tables of 50K records takes 2 hours Svetlin Manavski (08:35)
Re: Join over two tables of 50K records takes 2 hours Scott Marlowe (09:41)
Re: SSD options, small database, ZFS Arjen van der Meijden (10:41)
Re: Tablespace files deleted automatically. Josh Berkus (18:19)

2011-10-15

Re: Slow query when using ORDER BY *and* LIMIT Michael Viscuso (21:09)

2011-10-17

Bad plan by Planner (Already resolved?) Robins Tharakan (06:28)
Optimize the database performance Micka (09:48)
Re: Optimize the database performance MirrorX (10:39)
Re: Tablespace files deleted automatically. Robert Klemme (12:04)
Re: Bad plan by Planner (Already resolved?) Kevin Grittner (16:02)
Re: Optimize the database performance Andy Colson (18:35)
Re: Optimize the database performance Cédric Villemain (20:31)

2011-10-18

Re: Bad plan by Planner (Already resolved?) Robins Tharakan (05:57)
Re: Bad plan by Planner (Already resolved?) Mark Kirkwood (06:18)
Heavy contgnous load kzsolt (12:09)
Re: Bad plan by Planner (Already resolved?) Kevin Grittner (12:46)
Re: Heavy contgnous load Kevin Grittner (20:40)

2011-10-19

Re: Heavy contgnous load Craig Ringer (00:56)
How many Cluster database on a single server d.davolio@mastertraining.it (09:46)
Inner Join - Explicit vs Implicit Join Performance Gnanakumar (10:39)
Re: Inner Join - Explicit vs Implicit Join Performance Pavel Stehule (11:14)
Re: How many Cluster database on a single server Craig James (13:54)
Re: Rapidly finding maximal rows Merlin Moncure (14:54)
Re: How many Cluster database on a single server d.davolio@mastertraining.it (15:02)
delete/recreate indexes alan (15:03)
Re: How many Cluster database on a single server Kevin Grittner (15:13)
disused indexes and performance? Elisa (15:24)
Re: How many Cluster database on a single server Scott Marlowe (15:44)
does update of column with no relation imply a relation check of other column? Anibal David Acosta (15:51)
Re: does update of column with no relation imply a relation check of other column? Greg Jaskiewicz (16:42)
Re: Heavy contgnous load kzsolt (18:55)
Re: Heavy contgnous load kzsolt (19:04)

2011-10-20

Re: disused indexes and performance? Scott Marlowe (02:01)
Re: delete/recreate indexes Jeff Davis (02:51)
Re: How many Cluster database on a single server Craig Ringer (03:34)
Re: Heavy contgnous load Craig Ringer (03:44)
Re: delete/recreate indexes Bort, Paul (13:24)
Re: Heavy contgnous load Jeff Janes (15:55)
Re: Heavy contgnous load kzsolt (20:10)

2011-10-21

Re: How many Cluster database on a single server d.davolio@mastertraining.it (06:57)
8.4.4, 9.0, and 9.1 Planner Differences Anthony Presley (23:39)

2011-10-22

explain workload Radhya sahal (01:11)
Re: 8.4.4, 9.0, and 9.1 Planner Differences Tom Lane (15:58)
Re: 8.4.4, 9.0, and 9.1 Planner Differences Anthony Presley (23:12)
hstore query: Any better idea than adding more memory? Stefan Keller (23:33)

2011-10-23

Re: 8.4.4, 9.0, and 9.1 Planner Differences Tom Lane (02:31)
Re: explain workload Robins Tharakan (10:38)
Re: explain workload Tom Lane (15:44)
Re: hstore query: Any better idea than adding more memory? Stephen Frost (23:25)

2011-10-24

Re: hstore query: Any better idea than adding more memory? Stefan Keller (00:19)
Re: hstore query: Any better idea than adding more memory? Stephen Frost (00:41)
Re: : PG9.0 - Checkpoint tuning and pg_stat_bgwriter Venkat Balaji (12:16)
Usage of pg_stat_database Amitabh Kant (14:04)
Re: delete/recreate indexes alan (14:08)
Choosing between Intel 320, Intel 510 or OCZ Vertex 3 SSD for db server Amitabh Kant (14:09)
Re: Choosing between Intel 320, Intel 510 or OCZ Vertex 3 SSD for db server David Boreham (16:53)
Re: Tsearch2 - bad performance with concatenated ts-vectors Robert Haas (19:31)
Re: Choosing between Intel 320, Intel 510 or OCZ Vertex 3 SSD for db server Merlin Moncure (21:31)
Re: Choosing between Intel 320, Intel 510 or OCZ Vertex 3 SSD for db server Claudio Freire (22:47)
Re: Choosing between Intel 320, Intel 510 or OCZ Vertex 3 SSD for db server David Boreham (23:18)

2011-10-25

Re: : PG9.0 - Checkpoint tuning and pg_stat_bgwriter Robert Haas (02:17)
Re: Choosing between Intel 320, Intel 510 or OCZ Vertex 3 SSD for db server David Boreham (02:37)

Prev | Next

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

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