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 - February 2012

Prev | Next

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

2012-02-01

Re: How to improve insert speed with index on text column Jeff Janes (02:11)
Re: How to improve insert speed with index on text column Rosser Schwarz (03:29)
Re: How to improve insert speed with index on text column Claudio Freire (03:49)
Re: How to improve insert speed with index on text column Claudio Freire (03:51)
Index with all necessary columns - Postgres vs MSSQL Gudmundur Johannesson (17:10)
Re: Index with all necessary columns - Postgres vs MSSQL Merlin Moncure (17:52)
Re: From Simple to Complex Alessandro Gagliardi (18:19)
Re: Index with all necessary columns - Postgres vs MSSQL Scott Marlowe (18:32)
Re: From Simple to Complex Scott Marlowe (18:35)
Re: From Simple to Complex Alessandro Gagliardi (18:48)
Re: Index with all necessary columns - Postgres vs MSSQL Gudmundur Johannesson (18:50)
Re: From Simple to Complex Scott Marlowe (18:53)
Re: From Simple to Complex Bob Lunney (19:04)
Re: From Simple to Complex Alessandro Gagliardi (19:19)
Re: Index with all necessary columns - Postgres vs MSSQL Merlin Moncure (19:35)

2012-02-02

Re: From Simple to Complex Merlin Moncure (14:52)
Re: Index with all necessary columns - Postgres vs MSSQL Gudmundur Johannesson (16:41)
*really* bad insert performance on table with unique index Jon Nelson (17:28)
Re: From Simple to Complex Alessandro Gagliardi (19:38)
Re: Index with all necessary columns - Postgres vs MSSQL Merlin Moncure (20:30)
Re: *really* bad insert performance on table with unique index Jeff Janes (20:59)

2012-02-03

Re: Index with all necessary columns - Postgres vs MSSQL Gudmundur Johannesson (08:22)
Re: rough benchmarks, sata vs. ssd Ivan Voras (11:23)
Re: Slow nested loop execution on larger server Robert Haas (17:15)
Re: wal_level=archive gives better performance than minimal - why? Robert Haas (18:48)
Re: How to improve insert speed with index on text column Kevin Grittner (19:03)
Re: How to improve insert speed with index on text column Scott Marlowe (20:54)
Re: How to remove a table statistics ? Robert Haas (21:56)

2012-02-04

Re: wal_level=archive gives better performance than minimal - why? Cédric Villemain (16:04)
Re: wal_level=archive gives better performance than minimal - why? Tomas Vondra (16:20)
how to demonstrate the effect of direct I/O ? Tomas Vondra (23:25)
Re: how to demonstrate the effect of direct I/O ? Tomas Vondra (23:34)

2012-02-05

Re: How to improve insert speed with index on text column Saurabh (17:29)

2012-02-06

text search: tablescan cost for a tsvector Marc Mamin (11:05)

2012-02-07

Inserts or Updates Ofer Israeli (10:18)
Re: Inserts or Updates Kevin Grittner (12:27)
Re: Inserts or Updates Andy Colson (14:47)
Re: Index with all necessary columns - Postgres vs MSSQL Igor Neyman (15:11)
index scan forward vs backward = speed difference of 357X slower! Kevin Traster (16:49)
Re: Inserts or Updates Ofer Israeli (17:27)
Re: Inserts or Updates Claudio Freire (17:31)
Re: Inserts or Updates Ofer Israeli (17:40)
Re: Inserts or Updates Ofer Israeli (17:43)
Re: Inserts or Updates Claudio Freire (17:57)
Re: Index with all necessary columns - Postgres vs MSSQL Gudmundur Johannesson (17:59)
Re: Inserts or Updates Ofer Israeli (19:12)
Re: Inserts or Updates Claudio Freire (19:20)
Re: Index with all necessary columns - Postgres vs MSSQL Merlin Moncure (19:26)
Re: Inserts or Updates Andy Colson (19:30)
Re: Inserts or Updates Kevin Grittner (19:40)
Re: Inserts or Updates Andy Colson (19:43)

2012-02-08

random_page_cost = 2.0 on Heroku Postgres Peter van Hardenberg (00:59)
Re: how to demonstrate the effect of direct I/O ? Greg Smith (03:13)
Re: index scan forward vs backward = speed difference of 357X slower! Rural Hunter (08:01)
Re: index scan forward vs backward = speed difference of 357X slower! Rural Hunter (14:36)
Performance on large, append-only tables David Yeu (18:03)
Re: Inserts or Updates Ofer Israeli (19:20)
Re: Inserts or Updates Ofer Israeli (19:22)
Re: index scan forward vs backward = speed difference of 357X slower! Tom Lane (19:31)
Vacuuming problems on TOAST table Ofer Israeli (19:33)
Re: Vacuuming problems on TOAST table Tom Lane (19:44)
Re: index scan forward vs backward = speed difference of 357X slower! Kevin Traster (19:58)
Re: Vacuuming problems on TOAST table Ofer Israeli (19:59)
Re: pl/pgsql functions outperforming sql ones? Robert Haas (20:33)
Re: index scan forward vs backward = speed difference of 357X slower! Merlin Moncure (23:27)
Re: index scan forward vs backward = speed difference of 357X slower! Kevin Traster (23:31)
Re: index scan forward vs backward = speed difference of 357X slower! Kevin Grittner (23:41)

2012-02-09

Re: random_page_cost = 2.0 on Heroku Postgres Josh Berkus (00:50)
Re: random_page_cost = 2.0 on Heroku Postgres Scott Marlowe (01:39)
Re: random_page_cost = 2.0 on Heroku Postgres Peter van Hardenberg (01:45)
Re: random_page_cost = 2.0 on Heroku Postgres Marcos Ortiz Valmaseda (02:05)
Re: random_page_cost = 2.0 on Heroku Postgres Scott Marlowe (02:28)
Re: random_page_cost = 2.0 on Heroku Postgres Peter van Hardenberg (02:47)
Re: random_page_cost = 2.0 on Heroku Postgres Peter van Hardenberg (02:54)
Re: random_page_cost = 2.0 on Heroku Postgres Scott Marlowe (04:38)
Re: random_page_cost = 2.0 on Heroku Postgres Greg Sabino Mullane (04:39)
Re: random_page_cost = 2.0 on Heroku Postgres Marcos Ortiz Valmaseda (05:11)
Re: Inserts or Updates Vik Reykja (10:09)
Re: Inserts or Updates Frank Lanitz (13:28)
Re: random_page_cost = 2.0 on Heroku Postgres Jeff Janes (15:32)
timestamp with time zone Alessandro Gagliardi (18:42)
Re: timestamp with time zone Tom Lane (19:46)
Re: timestamp with time zone Alessandro Gagliardi (20:00)
Re: timestamp with time zone Kevin Grittner (20:15)
Re: timestamp with time zone Alessandro Gagliardi (20:38)
Re: random_page_cost = 2.0 on Heroku Postgres Peter van Hardenberg (22:41)

2012-02-10

Re: random_page_cost = 2.0 on Heroku Postgres Scott Marlowe (01:29)
Re: timestamp with time zone Tom Lane (06:19)
Re: Performance on large, append-only tables Merlin Moncure (15:19)
Re: Performance on large, append-only tables Claudio Freire (15:33)
Re: Performance on large, append-only tables Marti Raudsepp (15:34)
Re: Performance on large, append-only tables Tom Lane (15:35)
Re: Performance on large, append-only tables Kevin Grittner (15:44)
Re: Performance on large, append-only tables David Yeu (16:19)
Re: Performance on large, append-only tables Claudio Freire (16:26)
Re: Performance on large, append-only tables David Yeu (16:45)
Re: Performance on large, append-only tables Claudio Freire (16:58)
Re: Performance on large, append-only tables David Yeu (17:00)
Re: Performance on large, append-only tables Claudio Freire (17:12)
Re: random_page_cost = 2.0 on Heroku Postgres Josh Berkus (19:32)
Re: random_page_cost = 2.0 on Heroku Postgres Cédric Villemain (19:48)
Re: timestamp with time zone Alessandro Gagliardi (19:53)
Re: random_page_cost = 2.0 on Heroku Postgres Peter van Hardenberg (21:30)

2012-02-11

Re: random_page_cost = 2.0 on Heroku Postgres Josh Berkus (01:40)
Re: random_page_cost = 2.0 on Heroku Postgres Peter van Hardenberg (02:13)
Re: rough benchmarks, sata vs. ssd CSS (06:35)
Re: random_page_cost = 2.0 on Heroku Postgres Jeff Janes (16:26)
Re: random_page_cost = 2.0 on Heroku Postgres Peter van Hardenberg (19:52)

2012-02-12

Re: Inserts or Updates Ofer Israeli (10:48)
Re: Inserts or Updates Frank Lanitz (18:29)
Re: Inserts or Updates Ofer Israeli (18:32)
Re: random_page_cost = 2.0 on Heroku Postgres Jeff Janes (19:49)
Re: random_page_cost = 2.0 on Heroku Postgres Joshua Berkus (20:01)
Re: random_page_cost = 2.0 on Heroku Postgres Peter van Hardenberg (22:28)
Re: random_page_cost = 2.0 on Heroku Postgres Peter Geoghegan (23:37)

2012-02-13

Re: rough benchmarks, sata vs. ssd CSS (21:49)
Re: rough benchmarks, sata vs. ssd Ivan Voras (22:12)

2012-02-15

client performance v.s. server statistics Zhou Han (03:59)
Re: client performance v.s. server statistics Amit Kapila (05:23)
Re: client performance v.s. server statistics Zhou Han (07:01)
Fwd: [HACKERS] client performance v.s. server statistics Zhou Han (09:38)
Fwd: [HACKERS] client performance v.s. server statistics Zhou Han (10:19)
Re: Fwd: [HACKERS] client performance v.s. server statistics Andres Freund (10:55)
Re: Fwd: [HACKERS] client performance v.s. server statistics Han Zhou (11:02)
Re: Fwd: [HACKERS] client performance v.s. server statistics Han Zhou (11:33)
Re: Fwd: [HACKERS] client performance v.s. server statistics Andres Freund (11:36)
Re: client performance v.s. server statistics Amit Kapila (15:24)
UPDATE on NOT JOIN Gabriel Biberian (18:33)
Re: UPDATE on NOT JOIN Marti Raudsepp (19:12)
Optimizer is not choosing index Markus Innerebner (22:40)
Re: Optimizer is not choosing index Tom Lane (23:11)

2012-02-16

Re: Fwd: [HACKERS] client performance v.s. server statistics Han Zhou (01:44)
Re: Optimizer is not choosing index Markus Innerebner (06:54)

2012-02-17

Why so slow? Alessandro Gagliardi (18:34)
Re: Why so slow? Steve Crawford (19:21)
Re: Why so slow? Alessandro Gagliardi (22:20)

2012-02-18

Re: Why so slow? Ants Aasma (05:29)
Query slow as function Steve Horn (14:50)
Query slow as Function Steve Horn (15:03)
Re: Query slow as Function Andreas Kretschmer (16:02)
Re: Query slow as Function Tom Lane (16:37)
Re: Query slow as Function Andrew Dunstan (16:41)
Re: Query slow as Function Steve Horn (17:15)
Re: Query slow as Function Tom Lane (17:20)
Re: Query slow as Function Andreas Kretschmer (17:32)

2012-02-20

Re: Query slow as function Merlin Moncure (17:32)
Insertions slower than Updates? Ofer Israeli (18:59)
Re: Insertions slower than Updates? Kevin Grittner (19:13)
Re: Insertions slower than Updates? Ofer Israeli (19:21)
Re: Insertions slower than Updates? Kevin Grittner (19:29)
Re: Insertions slower than Updates? Steve Horn (19:32)
Re: Insertions slower than Updates? Ofer Israeli (20:16)
Re: Insertions slower than Updates? Ofer Israeli (20:16)
Re: Why so slow? Alessandro Gagliardi (21:14)
Indexes and Primary Keys on Rapidly Growing Tables Alessandro Gagliardi (22:06)
Re: Indexes and Primary Keys on Rapidly Growing Tables Josh Berkus (23:30)

2012-02-21

Re: Indexes and Primary Keys on Rapidly Growing Tables Alessandro Gagliardi (17:59)
Re: Indexes and Primary Keys on Rapidly Growing Tables Samuel Gendler (23:53)

2012-02-22

Re: Indexes and Primary Keys on Rapidly Growing Tables Alessandro Gagliardi (00:11)
set autovacuum=off Alessandro Gagliardi (23:50)

2012-02-23

Very long deletion time on a 200 GB database Reuven M. Lerner (08:39)
Re: Very long deletion time on a 200 GB database Glyn Astill (09:50)
Re: Very long deletion time on a 200 GB database Marcin Mańk (10:07)
Re: Very long deletion time on a 200 GB database Richard Huxton (11:23)
: Cost calculation for EXPLAIN output Venkat Balaji (12:21)
Re: set autovacuum=off Thom Brown (12:34)
Re: Very long deletion time on a 200 GB database Claudio Freire (14:07)
Re: Very long deletion time on a 200 GB database Andrew Dunstan (14:25)
Re: set autovacuum=off Andy Colson (15:18)
Re: Very long deletion time on a 200 GB database Reuven M. Lerner (15:25)
Re: Very long deletion time on a 200 GB database ktm@rice.edu (15:28)
Re: Very long deletion time on a 200 GB database Lew (15:42)
Re: Very long deletion time on a 200 GB database Steve Crawford (15:47)
Re: Very long deletion time on a 200 GB database Shaun Thomas (16:37)
Re: : Cost calculation for EXPLAIN output Kevin Grittner (16:51)
Re: : Cost calculation for EXPLAIN output Shaun Thomas (16:56)
Re: set autovacuum=off Alessandro Gagliardi (17:35)
Re: set autovacuum=off Thom Brown (17:45)
Re: Very long deletion time on a 200 GB database Greg Spiegelberg (17:56)
Re: set autovacuum=off Alessandro Gagliardi (17:58)
Re: set autovacuum=off Steve Crawford (18:01)
Re: Very long deletion time on a 200 GB database Shaun Thomas (18:05)
Re: Very long deletion time on a 200 GB database Andy Colson (18:11)
Re: Very long deletion time on a 200 GB database Greg Spiegelberg (18:13)
Re: Very long deletion time on a 200 GB database Tom Lane (18:30)
Re: set autovacuum=off Alessandro Gagliardi (18:38)
Re: set autovacuum=off Peter van Hardenberg (18:42)
Re: Very long deletion time on a 200 GB database Tom Lane (19:04)
Re: set autovacuum=off Andy Colson (19:07)
Re: set autovacuum=off Steve Crawford (19:26)
Re: Very long deletion time on a 200 GB database Jesper Krogh (19:46)
Disable-spinlocks while compiling postgres 9.1 for ARM Cortex A8 Jayashankar K B (20:14)
Re: [PERFORM] Disable-spinlocks while compiling postgres 9.1 for ARM Cortex A8 Tom Lane (20:19)
Re: set autovacuum=off Alessandro Gagliardi (20:28)
Re: set autovacuum=off Alessandro Gagliardi (20:40)
Re: set autovacuum=off Andy Colson (20:57)
Re: set autovacuum=off Alessandro Gagliardi (21:07)
Re: [PERFORM] Disable-spinlocks while compiling postgres 9.1 for ARM Cortex A8 Jayashankar K B (21:09)
Re: set autovacuum=off Peter van Hardenberg (21:11)
Re: set autovacuum=off Steve Crawford (21:37)

Prev | Next

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

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