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

Prev | Next

Jump to day: 1 2 4 5 6 7 8 9 10 11 12 13 14 15 18 19 20 21 22 25 26 27 28

2012-06-01

Re: Trouble with plan statistics for behaviour for query. Craig James (00:08)
Re: Trouble with plan statistics for behaviour for query. Vitalii Tymchyshyn (09:06)
Select from sequence in slow query log Chris Rimmer (13:13)
Re: Select from sequence in slow query log Tom Lane (13:47)
Re: does the query planner consider work_mem? Tom Lane (15:15)
Re: Trouble with plan statistics for behaviour for query. Maciek Sakrejda (15:38)
Re: Select from sequence in slow query log Chris Rimmer (15:41)

2012-06-02

Re: High load average in 64-core server , no I/O wait and CPU is idle Kevin Grittner (02:54)
Array fundamentals idc danny (17:05)
Re: [PERFORM] Array fundamentals Jeff Davis (17:21)

2012-06-04

Re: Recover rows deleted Alejandro Carrillo (16:14)
Re: Recover rows deleted Shaun Thomas (16:43)
Re: Recover rows deleted Alejandro Carrillo (16:47)
Re: Recover rows deleted Merlin Moncure (17:04)
Re: Recover rows deleted Alejandro Carrillo (17:46)
Re: Recover rows deleted Merlin Moncure (18:23)
Re: Recover rows deleted Alejandro Carrillo (18:37)
Re: Recover rows deleted Kevin Grittner (18:46)

2012-06-05

Re: Trouble with plan statistics for behaviour for query. Trevor Campbell (01:25)
Re: Trouble with plan statistics for behaviour for query. Trevor Campbell (03:49)
Sequencial scan in a JOIN Andrew Jaimes (12:48)
Re: Sequencial scan in a JOIN Shaun Thomas (13:15)
Re: Sequencial scan in a JOIN Andrew Jaimes (13:31)
Re: Sequencial scan in a JOIN Shaun Thomas (14:02)
Re: Sequencial scan in a JOIN Shaun Thomas (14:57)
Missing block Magic Alejandro Carrillo (16:12)
Re: Missing block Magic Tom Lane (17:00)
Re: Missing block Magic Alejandro Carrillo (18:51)

2012-06-06

pg 9.1 brings host machine down Konstantin Mikhailov (12:05)
Re: pg 9.1 brings host machine down Vitalii Tymchyshyn (12:25)
Re: pg 9.1 brings host machine down Patric Bechtel (12:40)
Re: pg 9.1 brings host machine down Julien Cigar (12:55)

2012-06-07

Multiple Concurrent Updates of Shared Resource Counter Nir Zilberman (07:53)
Re: Multiple Concurrent Updates of Shared Resource Counter Robert Klemme (11:48)

2012-06-08

Tablespaces and query planning Albe Laurenz (08:15)
Re: Seqscan slowness and stored procedures Albe Laurenz (09:58)
Re: Tablespaces and query planning Cédric Villemain (10:36)
Re: Multiple Concurrent Updates of Shared Resource Counter Cédric Villemain (10:59)
Re: Seqscan slowness and stored procedures Ivan Voras (11:00)
non index use on LIKE on a non pattern string Guillaume Cottenceau (11:11)
Re: non index use on LIKE on a non pattern string Cédric Villemain (11:51)
how to change the index chosen in plan? Rural Hunter (13:33)
Re: non index use on LIKE on a non pattern string Tom Lane (13:57)
Re: how to change the index chosen in plan? Tom Lane (14:10)
Re: how to change the index chosen in plan? Rural Hunter (14:23)
Re: non index use on LIKE on a non pattern string Cédric Villemain (14:31)
Re: how to change the index chosen in plan? Kevin Grittner (14:37)
Re: how to change the index chosen in plan? Rural Hunter (16:23)
Re: how to change the index chosen in plan? Kevin Grittner (16:39)
Re: pg 9.1 brings host machine down Konstantin Mikhailov (17:52)

2012-06-09

Re: how to change the index chosen in plan? Rural Hunter (02:08)
Re: how to change the index chosen in plan? Kevin Grittner (14:39)
Re: how to change the index chosen in plan? Kevin Grittner (15:38)
partitioning performance question Kevin Kempter (17:58)

2012-06-10

Re: pg 9.1 brings host machine down Craig Ringer (03:26)
Performance of CLUSTER Mark Thornton (08:20)
Re: partitioning performance question Robert Klemme (11:16)
Re: pg_dump and thousands of schemas Jeff Janes (23:47)

2012-06-11

Re: how to change the index chosen in plan? Rural Hunter (04:46)
Re: Tablespaces and query planning Albe Laurenz (07:01)
Re: how to change the index chosen in plan? Kevin Grittner (12:07)
Re: how to change the index chosen in plan? Rural Hunter (12:55)
Re: Performance of CLUSTER Shaun Thomas (13:42)
postgres clustering interactions with pg_dump Fitch, Britt (13:55)
Re: Performance of CLUSTER Mark Thornton (14:02)
Re: Performance of CLUSTER Shaun Thomas (14:14)
Re: Performance of CLUSTER Shaun Thomas (14:44)
Re: pg_dump and thousands of schemas Jeff Janes (16:32)
Re: Performance of CLUSTER Jeff Davis (23:53)

2012-06-12

Re: pg_dump and thousands of schemas Tatsuo Ishii (08:54)
Performance of pg_basebackup Shaun Thomas (14:54)
Re: Performance of pg_basebackup Magnus Hagander (14:57)
Re: Performance of pg_basebackup Shaun Thomas (15:00)
Re: pg_dump and thousands of schemas Jeff Janes (15:33)

2012-06-13

Re: pg_dump and thousands of schemas Tatsuo Ishii (01:45)

2012-06-14

High CPU Usage Siddharth Shah (15:15)

2012-06-15

Expected performance of querying 5k records from 4 million records? Anish Kejariwal (16:17)
Re: Expected performance of querying 5k records from 4 million records? Josh Berkus (17:44)
Re: Expected performance of querying 5k records from 4 million records? Jeff Janes (18:20)
Update blocking a select count(*)? Benedict Holland (18:22)
Re: Update blocking a select count(*)? Peter Geoghegan (18:32)
Re: Update blocking a select count(*)? Kevin Grittner (18:41)
Re: Update blocking a select count(*)? Kevin Grittner (18:43)
Re: Update blocking a select count(*)? Benedict Holland (18:46)
Re: Update blocking a select count(*)? Benedict Holland (18:46)
Re: Update blocking a select count(*)? Kevin Grittner (18:54)
Re: Update blocking a select count(*)? Kevin Grittner (19:03)
Re: Update blocking a select count(*)? Benedict Holland (19:04)
Re: Update blocking a select count(*)? Benedict Holland (19:12)
Re: Update blocking a select count(*)? Benedict Holland (19:27)
Re: Update blocking a select count(*)? Kevin Grittner (19:32)
Re: Update blocking a select count(*)? Benedict Holland (19:45)
Re: Update blocking a select count(*)? Kevin Grittner (19:51)
Re: Update blocking a select count(*)? Benedict Holland (19:58)
Re: Update blocking a select count(*)? Kevin Grittner (20:00)
Re: Update blocking a select count(*)? Benedict Holland (20:29)
Re: Update blocking a select count(*)? Kevin Grittner (20:38)

2012-06-18

correlated exists with join is slow. Віталій Тимчишин (13:47)
Re: correlated exists with join is slow. Tom Lane (14:52)
Re: correlated exists with join is slow. Kevin Grittner (14:58)
Re: correlated exists with join is slow. Віталій Тимчишин (15:02)
Re: Expected performance of querying 5k records from 4 million records? Anish Kejariwal (16:39)
Re: Expected performance of querying 5k records from 4 million records? Samuel Gendler (16:49)
Re: Expected performance of querying 5k records from 4 million records? Josh Berkus (19:08)

2012-06-19

pgbouncer - massive overhead? Strange, John W (16:00)
Why is a hash join being used? Tim Jacobs (21:34)

2012-06-20

index-only scan is missing the INCLUDE feature Eyal Wilde (04:46)
Re: scale up (postgresql vs mssql) Eyal Wilde (06:01)
Re: Why is a hash join being used? Sergey Konoplev (13:36)
Re: scale up (postgresql vs mssql) Andy Colson (13:43)
Re: index-only scan is missing the INCLUDE feature Craig Ringer (14:11)
SSD, Postgres and safe write cache Michal Szymanski (14:51)
Re: scale up (postgresql vs mssql) Merlin Moncure (14:55)
Re: pgbouncer - massive overhead? Steve Crawford (15:27)
Re: index-only scan is missing the INCLUDE feature Shaun Thomas (15:32)
random char or text variable in pgbench philippe.beaudoin (19:51)
moving tables Midge Brown (22:27)

2012-06-21

Re: moving tables Josh Berkus (00:28)
Re: index-only scan is missing the INCLUDE feature Craig Ringer (02:45)
Re: moving tables Albe Laurenz (08:34)
Can I do better than this heapscan and sort? Andy Halsall (20:07)

2012-06-22

Performance of a large array access by position (tested version 9.1.3) Maxim Boguk (07:02)
Re: Why is a hash join being used? Kevin Grittner (15:59)
Drop statistics? David Kerr (17:07)
Re: Drop statistics? Tom Lane (17:27)
Re: Drop statistics? David Kerr (18:04)
"global/pgstat.stat" corrupt David Kerr (18:46)
Re: "global/pgstat.stat" corrupt Tom Lane (19:49)
Re: "global/pgstat.stat" corrupt David Kerr (20:11)

2012-06-25

Re: index-only scan is missing the INCLUDE feature Cédric Villemain (15:22)
Postgres delete performance problem Frits Jalvingh (15:42)
Re: Postgres delete performance problem Vitalii Tymchyshyn (15:52)
Re: SSD, Postgres and safe write cache Yeb Havinga (16:05)
MemSQL the "world's fastest database"? Craig James (16:25)
Re: MemSQL the "world's fastest database"? Shaun Thomas (17:03)
Re: MemSQL the "world's fastest database"? Kevin Grittner (17:23)
Re: MemSQL the "world's fastest database"? Josh Berkus (17:41)
Re: MemSQL the "world's fastest database"? gnuoytr (18:02)
Re: Postgres delete performance problem Alejandro Carrillo (19:14)
Re: MemSQL the "world's fastest database"? Tom Lane (20:15)

2012-06-26

Re: Performance of a large array access by position (tested version 9.1.3) Jesper Krogh (05:03)
Re: Performance of a large array access by position (tested version 9.1.3) Marc Mamin (07:53)
Re: Performance of a large array access by position (tested version 9.1.3) Pavel Stehule (08:04)
Re: Performance of a large array access by position (tested version 9.1.3) Marc Mamin (08:19)
Re: Performance of a large array access by position (tested version 9.1.3) Pavel Stehule (08:22)
Re: Performance of a large array access by position (tested version 9.1.3) Pavel Stehule (09:03)
Re: Can I do better than this heapscan and sort? Merlin Moncure (13:36)
Re: Can I do better than this heapscan and sort? Merlin Moncure (13:42)
[performance] fast reads on a busy server Willy-Bas Loos (22:16)

2012-06-27

Re: [performance] fast reads on a busy server Hannu Krosing (07:34)
Re: [performance] fast reads on a busy server Willy-Bas Loos (10:01)
Re: [performance] fast reads on a busy server Willy-Bas Loos (11:28)
Re: [performance] fast reads on a busy server Willy-Bas Loos (11:58)
Re: [PERFORM] [performance] fast reads on a busy server Ants Aasma (12:58)
Re: [PERFORM] [performance] fast reads on a busy server Willy-Bas Loos (13:23)
Re: Can I do better than this heapscan and sort? Merlin Moncure (16:49)

2012-06-28

Re: Performance of a large array access by position (tested version 9.1.3) Cédric Villemain (10:22)

Prev | Next

Jump to day: 1 2 4 5 6 7 8 9 10 11 12 13 14 15 18 19 20 21 22 25 26 27 28

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