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

Prev | Next

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

2011-05-01

Re: stored proc and inserting hundreds of thousands of rows Jeff Janes (00:12)
Re: stored proc and inserting hundreds of thousands of rows Samuel Gendler (01:00)
The right SHMMAX and FILE_MAX Phoenix Kiula (06:48)
Query improvement Mark (10:23)
Re: {Spam} Will shared_buffers crash a server Marti Raudsepp (16:18)
Re: The right SHMMAX and FILE_MAX Kevin Grittner (17:18)
Re: The right SHMMAX and FILE_MAX Greg Smith (19:38)
Re: stored proc and inserting hundreds of thousands of rows Greg Smith (23:31)

2011-05-02

Re: The right SHMMAX and FILE_MAX Adarsh Sharma (04:53)
Re: Query improvement Claudio Freire (07:58)
Re: The right SHMMAX and FILE_MAX Mark Kirkwood (09:06)
Re: The right SHMMAX and FILE_MAX Tomas Vondra (10:50)
Re: The right SHMMAX and FILE_MAX Adarsh Sharma (11:01)
Re: 8.4.7, incorrect estimate Wayne Conrad (13:19)
Re: 8.4.7, incorrect estimate Tom Lane (15:11)
Re: The right SHMMAX and FILE_MAX Greg Smith (15:18)
Re: 8.4.7, incorrect estimate Kevin Grittner (16:04)
Re: 8.4.7, incorrect estimate Wayne Conrad (16:14)
Re: Query improvement Mark (20:54)

2011-05-03

Re: pgpoolAdmin handling several pgpool-II clusters Jorgen (05:32)
Re: Query improvement Claudio Freire (07:21)
Re: pgpoolAdmin handling several pgpool-II clusters Magnus Hagander (07:29)
Re: pgpoolAdmin handling several pgpool-II clusters Jorgen (08:16)
Postgres 9.0.4 + Hot Standby + FusionIO Drive + Performance => Query failed ERROR: catalog is missing 1 attribute(s) for relid 172226 Sethu Prasad (09:02)
Re: Query improvement Marc Mamin (09:14)
[PERFORMANCE] expanding to SAN: which portion best to move Willy-Bas Loos (15:52)
amazon ec2 Joel Reymont (18:48)
Re: amazon ec2 Alan Hodgson (19:41)
Re: amazon ec2 Joel Reymont (19:43)
Re: amazon ec2 Alan Hodgson (20:09)
Re: amazon ec2 Mark Rostron (20:48)
Re: amazon ec2 Greg Spiegelberg (20:52)
Re: amazon ec2 david (20:58)
Re: amazon ec2 Josh Berkus (21:39)
Re: amazon ec2 Greg Smith (22:39)
Re: amazon ec2 Greg Smith (22:44)

2011-05-04

Re: [PERFORMANCE] expanding to SAN: which portion best to move Jesper Krogh (04:43)
Re: Order of tables Rishabh Kumar Jain (05:23)
Re: [PERFORMANCE] expanding to SAN: which portion best to move Willy-Bas Loos (05:25)
Re: Order of tables Rishabh Kumar Jain (05:26)
Re: Order of tables Rishabh Kumar Jain (05:29)
Re: Order of tables Rishabh Kumar Jain (05:30)
Re: [PERFORMANCE] expanding to SAN: which portion best to move Jesper Krogh (05:33)
Re: [PERFORMANCE] expanding to SAN: which portion best to move Willy-Bas Loos (10:31)
Re: amazon ec2 Jim Nasby (13:05)
Re: REINDEX takes half a day (and still not complete!) Jim Nasby (13:28)
row estimate very wrong for array type Denis de Bernardy (13:40)
Re: amazon ec2 Shaun Thomas (14:04)
Re: row estimate very wrong for array type Tom Lane (14:12)
Re: row estimate very wrong for array type Denis de Bernardy (14:42)
Re: row estimate very wrong for array type Denis de Bernardy (14:56)
Re: Shouldn't we have a way to avoid "risky" plans? Jim Nasby (15:40)
Re: Postgres 9.0.4 + Hot Standby + FusionIO Drive + Performance => Query failed ERROR: catalog is missing 1 attribute(s) for relid 172226 Josh Berkus (18:44)

2011-05-05

Re: amazon ec2 Josh Berkus (00:02)
Re: amazon ec2 david (00:12)
Re: amazon ec2 Denis de Bernardy (00:21)
ask the database engine tuning on the server Didik Prasetyo (01:18)
Explicit joins Rishabh Kumar Jain (06:04)
Re: Postgres 9.0.4 + Hot Standby + FusionIO Drive + Performance => Query failed ERROR: catalog is missing 1 attribute(s) for relid 172226 Sethu Prasad (07:47)
Re: amazon ec2 Dave Page (07:49)
Re: Explicit joins Kevin Grittner (17:16)
Poor query plan chosen in 9.0.3 vs 8.3.7 Brian Connolly (17:43)
Re: VX_CONCURRENT flag on vxfs( 5.1 or later) for performance for postgresql? Robert Haas (17:53)
Re: ask the database engine tuning on the server Kevin Grittner (18:07)
Re: Poor query plan chosen in 9.0.3 vs 8.3.7 Brian Connolly (19:54)
Re: Poor query plan chosen in 9.0.3 vs 8.3.7 Bosco Rama (20:01)
Re: Poor query plan chosen in 9.0.3 vs 8.3.7 Tom Lane (20:27)

2011-05-06

Re: VX_CONCURRENT flag on vxfs( 5.1 or later) for performance for postgresql? Dimitri (10:53)
Re: REINDEX takes half a day (and still not complete!) Merlin Moncure (15:15)
indexes ignored when querying the master table Thomas Hägi (21:13)

2011-05-07

Re: Query improvement Mark (10:37)
Re: Query improvement Mark (10:38)
Re: Query improvement Mark (10:39)

2011-05-08

Re: Postgres 9.0.4 + Hot Standby + FusionIO Drive + Performance => Query failed ERROR: catalog is missing 1 attribute(s) for relid 172226 Simon Riggs (09:08)

2011-05-09

Re: indexes ignored when querying the master table Florian Weimer (07:57)
Re: indexes ignored when querying the master table Greg Smith (11:45)
wildcard makes seq scan on prod db but not in test Marcus Engene (18:06)
Re: wildcard makes seq scan on prod db but not in test Tom Lane (18:48)
Re: wildcard makes seq scan on prod db but not in test Kevin Grittner (18:57)
Re: wildcard makes seq scan on prod db but not in test Marcus Engene (19:11)
Re: wildcard makes seq scan on prod db but not in test Kevin Grittner (19:59)
Benchmarking a large server Chris Hoover (20:32)
good performance benchmark Merlin Moncure (20:41)
Re: Benchmarking a large server Merlin Moncure (20:50)
Re: Benchmarking a large server David Boreham (20:59)
Re: Benchmarking a large server Ben Chobot (20:59)
Re: Benchmarking a large server Shaun Thomas (21:01)
Re: Benchmarking a large server Merlin Moncure (21:11)
Re: Benchmarking a large server David Boreham (21:13)
Postgres refusing to use >1 core Aren Cambre (21:23)
Re: wildcard makes seq scan on prod db but not in test Marcus Engene (21:25)
Re: Postgres refusing to use >1 core Merlin Moncure (21:35)
Re: Postgres refusing to use >1 core Kevin Grittner (21:45)
Re: Postgres refusing to use >1 core Aren Cambre (21:50)
Re: Postgres refusing to use >1 core Aren Cambre (21:52)
Re: Postgres refusing to use >1 core Merlin Moncure (21:56)
Re: Postgres refusing to use >1 core Kevin Grittner (21:59)
Re: Benchmarking a large server Greg Smith (22:29)
Re: Postgres refusing to use >1 core Greg Smith (22:43)
Re: good performance benchmark Josh Berkus (23:23)
Re: Postgres 9.0.4 + Hot Standby + FusionIO Drive + Performance => Query failed ERROR: catalog is missing 1 attribute(s) for relid 172226 Josh Berkus (23:30)
Re: Benchmarking a large server Cédric Villemain (23:52)

2011-05-10

Re: Benchmarking a large server Craig James (00:32)
Re: Benchmarking a large server David Boreham (00:38)
Re: Benchmarking a large server Greg Smith (00:45)
Re: Benchmarking a large server david (00:46)
Re: Postgres refusing to use >1 core Aren Cambre (02:12)
Re: Postgres refusing to use >1 core Aren Cambre (02:15)
Re: Postgres refusing to use >1 core Scott Marlowe (02:34)
Re: Postgres refusing to use >1 core Merlin Moncure (02:37)
Re: Postgres refusing to use >1 core Aren Cambre (02:40)
Re: Benchmarking a large server Shaun Thomas (03:13)
Re: Postgres refusing to use >1 core Craig Ringer (04:01)
partition query on multiple cores Didik Prasetyo (04:32)
Re: Benchmarking a large server Greg Smith (04:44)
Re: Benchmarking a large server Yeb Havinga (06:58)
8.2.13 commit is taking too much time AI Rumman (07:01)
Re: Postgres 9.0.4 + Hot Standby + FusionIO Drive + Performance => Query failed ERROR: catalog is missing 1 attribute(s) for relid 172226 Sethu Prasad (07:23)
Re: Benchmarking a large server Claudio Freire (07:24)
Re: indexes ignored when querying the master table Thomas Hägi (09:20)
Re: 8.2.13 commit is taking too much time tv (09:44)
Re: Postgres refusing to use >1 core Merlin Moncure (14:06)
Re: Benchmarking a large server Jeff (14:24)
Re: partition query on multiple cores Maciek Sakrejda (15:06)
Re: Benchmarking a large server Cédric Villemain (15:19)
Re: 8.2.13 commit is taking too much time Greg Smith (15:55)
Re: partition query on multiple cores Shaun Thomas (16:22)
Question processor speed differences. Tory M Blue (17:28)
Re: help speeding up a query in postgres 8.4.5 Robert Haas (17:38)
Re: help speeding up a query in postgres 8.4.5 Maria L. Wilson (17:47)
Re: Benchmarking a large server Greg Smith (17:50)
Postgres NoSQL emulation Pierre C (17:56)
Re: help speeding up a query in postgres 8.4.5 Robert Haas (17:59)
Re: help speeding up a query in postgres 8.4.5 Maria L. Wilson (18:20)
Re: partition query on multiple cores Tomas Vondra (18:57)
Re: Question processor speed differences. Greg Smith (20:53)
Re: Postgres NoSQL emulation Merlin Moncure (21:32)

2011-05-11

Re: Postgres refusing to use >1 core Craig Ringer (01:32)
Re: Postgres refusing to use >1 core Craig Ringer (01:35)
Re: Postgres NoSQL emulation Scott Marlowe (03:13)
Re: Postgres refusing to use >1 core Scott Marlowe (04:26)
Re: help speeding up a query in postgres 8.4.5 Scott Marlowe (07:09)
Re: Postgres refusing to use >1 core Pierre C (11:06)
'Interesting' prepared statement slowdown on large table join Prodan, Andrei (11:08)
Re: Postgres NoSQL emulation Pierre C (11:14)
Re: partition query on multiple cores Mason S (11:56)
Re: help speeding up a query in postgres 8.4.5 Robert Haas (12:01)
Re: partition query on multiple cores Mason S (12:04)
Re: help speeding up a query in postgres 8.4.5 Tom Lane (14:31)
Re: 'Interesting' prepared statement slowdown on large table join Shaun Thomas (15:55)
Re: Postgres refusing to use >1 core Shaun Thomas (16:04)
Re: 'Interesting' prepared statement slowdown on large table join Tom Lane (16:38)
Re: Poor performance when joining against inherited tables Robert Haas (16:38)
Re: Poor performance when joining against inherited tables Tom Lane (17:00)
Re: Postgres refusing to use >1 core Pierre C (18:10)
Re: 'Interesting' prepared statement slowdown on large table join Jeff Janes (19:07)
Re: Postgres refusing to use >1 core gnuoytr (19:53)
Re: Poor performance when joining against inherited tables Lucas Madar (20:47)
Re: Postgres refusing to use >1 core Scott Marlowe (21:44)
Re: Postgres refusing to use >1 core Shaun Thomas (22:04)
Re: Postgres refusing to use >1 core gnuoytr (23:07)

2011-05-12

Re: Postgres refusing to use >1 core Josh Berkus (01:14)
Re: Postgres refusing to use >1 core Aren Cambre (03:17)
Re: Postgres refusing to use >1 core Aren Cambre (03:18)
Re: Postgres refusing to use >1 core Aren Cambre (03:20)
Re: HashJoin order, hash the large or small table? Postgres likes to hash the big one, why? Robert Haas (03:21)
Re: DBT-5 & Postgres 9.0.3 Robert Haas (03:22)
Re: Postgres refusing to use >1 core Scott Marlowe (03:35)
Re: Checkpoint execution overrun impact? Robert Haas (03:36)
Re: tuning on ec2 Robert Haas (03:38)
Re: Postgres refusing to use >1 core David Boreham (04:25)
Re: DBT-5 & Postgres 9.0.3 Sethu Prasad (07:18)
Re: Postgres refusing to use >1 core Vitalii Tymchyshyn (07:28)
Re: Postgres refusing to use >1 core Michael Graham (08:30)
Re: Postgres refusing to use >1 core Shaun Thomas (13:06)
Re: Postgres refusing to use >1 core Tom Lane (14:51)
[PERFORM] since when has pg_stat_user_indexes.idx_scan been counting? Willy-Bas Loos (15:39)
Re: Postgres refusing to use >1 core Shaun Thomas (15:48)
Re: 'Interesting' prepared statement slowdown on large table join Prodan, Andrei (15:53)
Re: Postgres refusing to use >1 core Tom Lane (16:07)
Re: Postgres refusing to use >1 core Shaun Thomas (16:11)
Re: Postgres refusing to use >1 core Eric McKeeth (18:15)
Re: since when has pg_stat_user_indexes.idx_scan been counting? Tomas Vondra (18:18)
Re: since when has pg_stat_user_indexes.idx_scan been counting? Tomas Vondra (18:19)
Re: [PERFORM] since when has pg_stat_user_indexes.idx_scan been counting? raghu ram (18:22)
Re: Postgres refusing to use >1 core Aren Cambre (18:25)
Re: Postgres refusing to use >1 core Aren Cambre (18:27)
Re: [PERFORM] since when has pg_stat_user_indexes.idx_scan been counting? Willy-Bas Loos (20:03)
Re: since when has pg_stat_user_indexes.idx_scan been counting? Greg Smith (20:06)
Re: since when has pg_stat_user_indexes.idx_scan been counting? Tom Lane (20:16)
Re: [ADMIN] since when has pg_stat_user_indexes.idx_scan been counting? Tomas Vondra (20:46)
Re: Poor performance when joining against inherited tables Maciek Sakrejda (21:07)
setting configuration values inside a stored proc Samuel Gendler (23:10)
Re: 'Interesting' prepared statement slowdown on large table join Jeff Janes (23:28)

2011-05-13

Re: tuning on ec2 Josh Berkus (00:10)
Re: Checkpoint execution overrun impact? Greg Smith (02:10)
Re: [ADMIN] since when has pg_stat_user_indexes.idx_scan been counting? Greg Smith (02:26)
Re: setting configuration values inside a stored proc Andres Freund (08:28)
Re: [ADMIN] since when has pg_stat_user_indexes.idx_scan been counting? tv (08:44)
Re: setting configuration values inside a stored proc Samuel Gendler (09:41)

Prev | Next

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

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