Home > mailing lists

Mailing lists [pgsql-performance]

1 June 2012

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

2 June 2012

02:54 Re: High load average in 64-core server , no I/O wait and CPU is idle Kevin Grittner
17:05 Array fundamentals idc danny

4 June 2012

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

5 June 2012

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

6 June 2012

12:06 pg 9.1 brings host machine down Konstantin Mikhailov
12:26 Re: pg 9.1 brings host machine down Vitalii Tymchyshyn
12:40 Re: pg 9.1 brings host machine down Patric Bechtel
12:56 Re: pg 9.1 brings host machine down Julien Cigar

7 June 2012

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

8 June 2012

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

9 June 2012

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

10 June 2012

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

11 June 2012

04:47 Re: how to change the index chosen in plan? Rural Hunter
07:02 Re: Tablespaces and query planning Albe Laurenz
12:08 Re: how to change the index chosen in plan? Kevin Grittner
12:55 Re: how to change the index chosen in plan? Rural Hunter
13:43 Re: Performance of CLUSTER Shaun Thomas
13:55 postgres clustering interactions with pg_dump Fitch, Britt
14:02 Re: Performance of CLUSTER Mark Thornton
14:15 Re: Performance of CLUSTER Shaun Thomas
14:44 Re: Performance of CLUSTER Shaun Thomas
16:33 Re: pg_dump and thousands of schemas Jeff Janes
23:54 Re: Performance of CLUSTER Jeff Davis

12 June 2012

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

13 June 2012

01:46 Re: pg_dump and thousands of schemas Tatsuo Ishii

15 June 2012

16:17 Expected performance of querying 5k records from 4 million records? Anish Kejariwal
17:45 Re: Expected performance of querying 5k records from 4 million records? Josh Berkus
18:20 Re: Expected performance of querying 5k records from 4 million records? Jeff Janes
18:22 Update blocking a select count(*)? Benedict Holland
18:33 Re: Update blocking a select count(*)? Peter Geoghegan
18:41 Re: Update blocking a select count(*)? Kevin Grittner
18:43 Re: Update blocking a select count(*)? Kevin Grittner
18:46 Re: Update blocking a select count(*)? Benedict Holland
18:46 Re: Update blocking a select count(*)? Benedict Holland
18:54 Re: Update blocking a select count(*)? Kevin Grittner
19:03 Re: Update blocking a select count(*)? Kevin Grittner
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(*)? Benedict Holland
19:32 Re: Update blocking a select count(*)? Kevin Grittner
19:46 Re: Update blocking a select count(*)? Benedict Holland
19:51 Re: Update blocking a select count(*)? Kevin Grittner
19:58 Re: Update blocking a select count(*)? Benedict Holland
20:00 Re: Update blocking a select count(*)? Kevin Grittner
20:29 Re: Update blocking a select count(*)? Benedict Holland
20:38 Re: Update blocking a select count(*)? Kevin Grittner

18 June 2012

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

20 June 2012

07:51 High CPU Usage Siddharth Shah
07:54 Re: scale up (postgresql vs mssql) Eyal Wilde
07:54 index-only scan is missing the INCLUDE feature Eyal Wilde
07:54 Why is a hash join being used? Tim Jacobs
07:54 pgbouncer - massive overhead? Strange, John W
13:37 Re: Why is a hash join being used? Sergey Konoplev
13:43 Re: scale up (postgresql vs mssql) Andy Colson
14:11 Re: index-only scan is missing the INCLUDE feature Craig Ringer
14:56 Re: scale up (postgresql vs mssql) Merlin Moncure
15:27 Re: pgbouncer - massive overhead? Steve Crawford
15:32 Re: index-only scan is missing the INCLUDE feature Shaun Thomas
22:27 moving tables Midge Brown

21 June 2012

00:28 Re: moving tables Josh Berkus
02:46 Re: index-only scan is missing the INCLUDE feature Craig Ringer
08:34 Re: moving tables Albe Laurenz

22 June 2012

16:00 Re: Why is a hash join being used? Kevin Grittner
17:08 Drop statistics? David Kerr
17:28 Re: Drop statistics? Tom Lane
18:04 Re: Drop statistics? David Kerr
18:46 "global/pgstat.stat" corrupt David Kerr
19:49 Re: "global/pgstat.stat" corrupt Tom Lane
20:11 Re: "global/pgstat.stat" corrupt David Kerr

25 June 2012

15:22 Re: index-only scan is missing the INCLUDE feature Cédric Villemain
15:42 Postgres delete performance problem Frits Jalvingh
15:51 random char or text variable in pgbench philippe.beaudoin@bull.net
15:51 SSD, Postgres and safe write cache Michal Szymanski
15:51 Can I do better than this heapscan and sort? Andy Halsall
15:51 Performance of a large array access by position (tested version 9.1.3) Maxim Boguk
15:52 Re: Postgres delete performance problem Vitalii Tymchyshyn
16:05 Re: SSD, Postgres and safe write cache Yeb Havinga
16:26 MemSQL the "world's fastest database"? Craig James
17:03 Re: MemSQL the "world's fastest database"? Shaun Thomas
17:23 Re: MemSQL the "world's fastest database"? Kevin Grittner
17:42 Re: MemSQL the "world's fastest database"? Josh Berkus
18:03 Re: MemSQL the "world's fastest database"?
19:14 Re: Postgres delete performance problem Alejandro Carrillo
20:15 Re: MemSQL the "world's fastest database"? Tom Lane

26 June 2012

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

27 June 2012

07:34 Re: [pgsql-cluster-hackers][performance] fast reads on a busy server Hannu Krosing
10:02 Re: [pgsql-cluster-hackers][performance] fast reads on a busy server Willy-Bas Loos
11:28 Re: [pgsql-cluster-hackers][performance] fast reads on a busy server Willy-Bas Loos
11:58 Re: [pgsql-cluster-hackers][performance] fast reads on a busy server Willy-Bas Loos
12:59 Re: [pgsql-cluster-hackers][performance] fast reads on a busy server Ants Aasma
13:24 Re: [pgsql-cluster-hackers][performance] fast reads on a busy server Willy-Bas Loos
16:49 Re: Can I do better than this heapscan and sort? Merlin Moncure

28 June 2012

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