Skip site navigation (1)
Skip section navigation (2)
pgsql-performance 2011-10 Chronological Index (1/2)
Last updated: Wed Jan 18 04:12:00 2012
289 messages
29 October 2011
Re: WAL in RAM Marcus Engene (17:54)
Re: application of KNN code to US zipcode searches? Mark Stosberg (14:46)
Re: Bad plan by Planner (Already resolved?) Robins Tharakan (14:42)
Re: SSL encryption makes bytea transfer slow Heikki Linnakangas (08:51)
Re: Performance Problem with postgresql 9.03, 8GB RAM,Quadcore Processor Server--Need help!!!!!!! Mohamed Hashim (04:10)
28 October 2011
Re: backups blocking everything Merlin Moncure (21:20)
Re: WAL in RAM David Boreham (19:55)
Re: WAL in RAM Claudio Freire (19:09)
Re: WAL in RAM Tomas Vondra (19:07)
Re: WAL in RAM Tomas Vondra (19:03)
Re: should i expected performance degradation over time Robert Haas (19:03)
Re: WAL in RAM Merlin Moncure (18:40)
Re: WAL in RAM Tomas Vondra (18:26)
Re: Strange query plan Tomas Vondra (18:10)
Strange query plan Sorbara, Giorgio (CIOK) (17:37)
Re: WAL in RAM Merlin Moncure (16:11)
Re: WAL in RAM Kevin Grittner (15:46)
WAL in RAM Marcus Engene (15:35)
Re: function slower than the same code in an sql file CS DBA (13:39)
Re: Choosing between Intel 320, Intel 510 or OCZ Vertex 3 SSD for db server David Boreham (13:22)
Re: [GENERAL] Performance Problem with postgresql 9.03, 8GB RAM,Quadcore Processor Server--Need help!!!!!!! Alban Hertroys (11:37)
SSL encryption makes bytea transfer slow Albe Laurenz (11:03)
Re: Performance Problem with postgresql 9.03, 8GB RAM,Quadcore Processor Server--Need help!!!!!!! Mohamed Hashim (08:21)
Re: Performance Problem with postgresql 9.03, 8GB RAM,Quadcore Processor Server--Need help!!!!!!! Gregg Jaskiewicz (07:58)
Performance Problem with postgresql 9.03, 8GB RAM,Quadcore Processor Server--Need help!!!!!!! Mohamed Hashim (07:02)
Re: Choosing between Intel 320, Intel 510 or OCZ Vertex 3 SSD for db server Amitabh Kant (06:40)
Re: Usage of pg_stat_database Amitabh Kant (06:38)
Re: Usage of pg_stat_database Jeff Davis (05:54)
Re: function slower than the same code in an sql file Pavel Stehule (05:11)
Re: function slower than the same code in an sql file Tom Lane (05:10)
function slower than the same code in an sql file CS DBA (05:02)
Re: PostgreSQL 9.0.4 blocking in lseek? Josh Berkus (02:42)
Re: PostgreSQL 9.0.4 blocking in lseek? Tom Lane (00:33)
27 October 2011
Re: Performance problem with a table with 38928077 record Tom Lane (22:19)
Re: backups blocking everything Nicholson, Brad (Toronto, ON, CA) (22:12)
Re: Performance problem with a table with 38928077 record Shaun Thomas (21:25)
Re: backups blocking everything Samuel Gendler (21:21)
Re: Performance problem with a table with 38928077 record Robert Haas (19:13)
Re: Shortcutting too-large offsets? Robert Haas (18:47)
Re: backups blocking everything Merlin Moncure (17:39)
backups blocking everything Samuel Gendler (17:23)
Re: PostgreSQL 9.0.4 blocking in lseek? Claudio Freire (14:55)
Re: PostgreSQL 9.0.4 blocking in lseek? Sören Meyer-Eppler (12:04)
Re: PostgreSQL 9.0.4 blocking in lseek? Gregg Jaskiewicz (07:42)
Re: Anti join miscalculates row number? Julius Tuskenis (07:03)
26 October 2011
PostgreSQL 9.0.4 blocking in lseek? Sören Meyer-Eppler (15:57)
Re: Anti join miscalculates row number? Tom Lane (15:43)
Re: Slow cursor Andres Freund (13:10)
Re: Slow cursor Cezariusz Marek (12:57)
Re: CTE vs Subquery Linos (12:55)
Re: Slow cursor Gregg Jaskiewicz (12:49)
Slow cursor Cezariusz Marek (12:43)
Re: CTE vs Subquery Merlin Moncure (12:23)
Anti join miscalculates row number? Jens Reufsteck (11:45)
Re: CTE vs Subquery Linos (09:00)
Re: how to use explain analyze Julius Tuskenis (07:48)
25 October 2011
Re: CTE vs Subquery Linos (16:48)
Re: CTE vs Subquery Tom Lane (16:43)
CTE vs Subquery Linos (16:22)
Re: Choosing between Intel 320, Intel 510 or OCZ Vertex 3 SSD for db server David Boreham (15:00)
Re: Choosing between Intel 320, Intel 510 or OCZ Vertex 3 SSD for db server Claudio Freire (14:55)
how to use explain analyze alan (14:36)
sub Cezariusz Marek (13:31)
Re: Bad plan by Planner (Already resolved?) Robins Tharakan (10:53)
Re: Query running a lot faster with enable_nestloop=false Robins Tharakan (09:41)
Query running a lot faster with enable_nestloop=false Mohanaraj Gopala Krishnan (09:09)
Re: Choosing between Intel 320, Intel 510 or OCZ Vertex 3 SSD for db server Thilo Raufeisen (07:48)
Re: : PG9.0 - Checkpoint tuning and pg_stat_bgwriter Venkat Balaji (05:05)
Re: Choosing between Intel 320, Intel 510 or OCZ Vertex 3 SSD for db server David Boreham (02:37)
Re: : PG9.0 - Checkpoint tuning and pg_stat_bgwriter Robert Haas (02:17)
24 October 2011
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 Merlin Moncure (21:31)
Re: Tsearch2 - bad performance with concatenated ts-vectors Robert Haas (19:31)
Re: : PG9.0 - Checkpoint tuning and pg_stat_bgwriter Venkat Balaji (17:35)
Re: Choosing between Intel 320, Intel 510 or OCZ Vertex 3 SSD for db server David Boreham (16:54)
Choosing between Intel 320, Intel 510 or OCZ Vertex 3 SSD for db server Amitabh Kant (16:43)
Usage of pg_stat_database Amitabh Kant (16:39)
Re: delete/recreate indexes alan (16:36)
Re: hstore query: Any better idea than adding more memory? Stephen Frost (00:41)
Re: hstore query: Any better idea than adding more memory? Stefan Keller (00:20)
23 October 2011
Re: explain workload Tom Lane (15:45)
Re: explain workload Robins Tharakan (10:45)
Re: 8.4.4, 9.0, and 9.1 Planner Differences Tom Lane (02:32)
22 October 2011
Re: 8.4.4, 9.0, and 9.1 Planner Differences Anthony Presley (23:12)
Re: 8.4.4, 9.0, and 9.1 Planner Differences Tom Lane (15:58)
explain workload Radhya sahal (01:11)
21 October 2011
Re: How many Cluster database on a single server d(dot)davolio(at)mastertraining(dot)it (06:57)
20 October 2011
Re: Heavy contgnous load Jeff Janes (15:55)
Re: delete/recreate indexes Bort, Paul (13:37)
Re: Heavy contgnous load Craig Ringer (03:44)
Re: How many Cluster database on a single server Craig Ringer (03:34)
Re: delete/recreate indexes Jeff Davis (02:51)
Re: disused indexes and performance? Scott Marlowe (02:01)
19 October 2011
Re: Heavy contgnous load kzsolt (18:55)
Re: does update of column with no relation imply a relation check of other column? Greg Jaskiewicz (16:43)
does update of column with no relation imply a relation check of other column? Anibal David Acosta (15:51)
Re: How many Cluster database on a single server Scott Marlowe (15:44)
disused indexes and performance? Elisa (15:33)
Re: How many Cluster database on a single server Kevin Grittner (15:13)
delete/recreate indexes alan (15:03)
Re: How many Cluster database on a single server d(dot)davolio(at)mastertraining(dot)it (15:03)
Re: Rapidly finding maximal rows Merlin Moncure (14:55)
Re: How many Cluster database on a single server Craig James (14:14)
Re: Inner Join - Explicit vs Implicit Join Performance Pavel Stehule (11:15)
Inner Join - Explicit vs Implicit Join Performance Gnanakumar (10:47)
How many Cluster database on a single server d(dot)davolio(at)mastertraining(dot)it (10:14)
Re: Heavy contgnous load Craig Ringer (00:56)
18 October 2011
Re: Bad plan by Planner (Already resolved?) Kevin Grittner (12:46)
Heavy contgnous load kzsolt (12:29)
Re: Bad plan by Planner (Already resolved?) Mark Kirkwood (06:18)
Re: Bad plan by Planner (Already resolved?) Robins Tharakan (05:58)
17 October 2011
Re: Optimize the database performance Andy Colson (18:35)
Re: Bad plan by Planner (Already resolved?) Kevin Grittner (16:02)
Re: Tablespace files deleted automatically. Robert Klemme (12:04)
Re: Optimize the database performance MirrorX (10:39)
Optimize the database performance Micka (09:48)
Bad plan by Planner (Already resolved?) Robins Tharakan (06:35)
15 October 2011
14 October 2011
Re: SSD options, small database, ZFS Arjen van der Meijden (10:41)
Re: Join over two tables of 50K records takes 2 hours Scott Marlowe (09:42)
Re: Join over two tables of 50K records takes 2 hours Svetlin Manavski (08:36)
SSD options, small database, ZFS CSS (08:31)
Re: Join over two tables of 50K records takes 2 hours Scott Marlowe (04:38)
Re: Join over two tables of 50K records takes 2 hours Tom Lane (04:37)
Re: Rapidly finding maximal rows Tom Lane (04:26)
13 October 2011
Tablespace files deleted automatically. Vishnu S. (12:52)
12 October 2011
Re: Rapidly finding maximal rows James Cranch (11:41)
Re: Composite keys Greg Smith (10:26)
Join over two tables of 50K records takes 2 hours Svetlin Manavski (08:55)
Re: Composite keys Carlo Stonebanks (04:39)
Re: Composite keys Dave Crooke (01:28)
Re: Rapidly finding maximal rows Dave Crooke (01:05)
Re: Composite keys Claudio Freire (00:52)
11 October 2011
Composite keys Carlo Stonebanks (23:11)
Re: postgresql query runtime Kevin Grittner (21:43)
Re: postgresql query runtime Radhya sahal (21:36)
Re: Adding more memory = hugh cpu load [solved] Claudio Freire (20:46)
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:08)
Re: Adding more memory = hugh cpu load [solved] alexandre - aldeia digital (20:02)
Re: postgresql query runtime Kevin Grittner (19:16)
Re: postgresql query runtime Szymon Guz (19:14)
Re: postgresql query runtime Szymon Guz (19:13)
Re: postgresql query runtime Pavel Stehule (19:12)
postgresql query runtime Radhya sahal (19:08)
Re: Query tuning help Pavel Stehule (19:00)
Re: Query tuning help CS DBA (18:37)