Home > mailing lists

Mailing lists [pgsql-performance]

1 September 2016

01:01 Possible to find disk IOs for a Query? Bobby Mozumder
01:10 Re: Possible to find disk IOs for a Query? Ben Chobot
01:18 Re: Possible to find disk IOs for a Query? Lukas Fittl
08:56 Re: Possible to find disk IOs for a Query? Mark Kirkwood
12:09 Re: Possible to find disk IOs for a Query? Mark Kirkwood

2 September 2016

05:31 Postgres bulk insert/ETL performance on high speed servers - test results Mike Sofen
23:26 Re: Postgres bulk insert/ETL performance on high speed servers - test results Claudio Freire

4 September 2016

15:34 Re: Postgres bulk insert/ETL performance on high speed servers - test results Mike Sofen

7 September 2016

17:32 debug_assertions is enabled in official 9.6rc1 build Mkrtchyan, Tigran
22:22 Re: Postgres bulk insert/ETL performance on high speed servers - test results Jim Nasby

8 September 2016

05:29 Re: Postgres bulk insert/ETL performance on high speed servers - test results Mike Sofen

10 September 2016

13:50 How to reduce IOWAIT and CPU idle time? Samir Magar

11 September 2016

03:34 Re: How to reduce IOWAIT and CPU idle time? Venkata B Nagothi
04:47 Re: How to reduce IOWAIT and CPU idle time? Jeff Janes
10:11 Re: How to reduce IOWAIT and CPU idle time? Samir Magar
10:40 Re: How to reduce IOWAIT and CPU idle time? Pavan Deolasee
11:04 Re: How to reduce IOWAIT and CPU idle time? Samir Magar

12 September 2016

17:15 Strange nested loop for an INSERT phb07
17:41 Re: Strange nested loop for an INSERT Tom Lane
21:05 Re: Strange nested loop for an INSERT phb07

14 September 2016

16:53 Disk filled-up issue after a lot of inserts and drop schema Pietro Pugni
17:17 Re: Disk filled-up issue after a lot of inserts and drop schema Rick Otten
17:44 Re: Disk filled-up issue after a lot of inserts and drop schema Tom Lane
20:45 Re: Disk filled-up issue after a lot of inserts and drop schema Pietro Pugni
20:55 Re: Disk filled-up issue after a lot of inserts and drop schema Tom Lane
21:01 Re: Disk filled-up issue after a lot of inserts and drop schema Pietro Pugni

19 September 2016

10:30 Problem with performance using query with unnest after migrating from V9.1 to V9.2 and higher Knels, Udo
10:40 Postgresql 8.4 optimize for heavy select load Job
11:23 Re: Postgresql 8.4 optimize for heavy select load Mark Kirkwood
12:09 Re: Postgresql 8.4 optimize for heavy select load Torsten Zuehlsdorff
13:05 Re: Postgresql 8.4 optimize for heavy select load julyanto SUTANDANG

21 September 2016

19:53 query against single partition uses index, against master table does seq scan Mike Broers
20:15 Re: query against single partition uses index, against master table does seq scan Ganesh Kannan
20:37 Re: query against single partition uses index, against master table does seq scan Mike Broers

22 September 2016

00:00 Re: query against single partition uses index, against master table does seq scan Mike Broers
00:42 Re: Strange nested loop for an INSERT Jim Nasby
00:48 Re: Problem with performance using query with unnest after migrating from V9.1 to V9.2 and higher Jim Nasby
05:11 Re: query against single partition uses index, against master table does seq scan Tom Lane
07:09 Re: query against single partition uses index, against master table does seq scan Mike Broers
15:39 Re: Problem with performance using query with unnest after migrating from V9.1 to V9.2 and higher Knels, Udo
16:24 Multiple-Table-Spanning Joins with ORs in WHERE Clause Sven R. Kunze
16:37 Re: Multiple-Table-Spanning Joins with ORs in WHERE Clause Madusudanan.B.N
16:39 Re: Problem with performance using query with unnest after migrating from V9.1 to V9.2 and higher Igor Neyman
17:33 Re: Multiple-Table-Spanning Joins with ORs in WHERE Clause Igor Neyman
17:35 Re: Problem with performance using query with unnest after migrating from V9.1 to V9.2 and higher Tom Lane
17:36 Re: Multiple-Table-Spanning Joins with ORs in WHERE Clause Igor Neyman
17:39 Re: Multiple-Table-Spanning Joins with ORs in WHERE Clause Igor Neyman
19:20 Re: Multiple-Table-Spanning Joins with ORs in WHERE Clause Jeff Janes
19:25 Re: query against single partition uses index, against master table does seq scan Tom Lane

23 September 2016

09:35 Re: Multiple-Table-Spanning Joins with ORs in WHERE Clause Sven R. Kunze
13:12 Storing large documents - one table or partition by doc? Dev Nop
15:14 Re: Storing large documents - one table or partition by doc? Mike Sofen
20:59 Re: Strange nested loop for an INSERT phb07
21:51 Re: Strange nested loop for an INSERT Jim Nasby
21:59 Re: Storing large documents - one table or partition by doc? Jim Nasby

24 September 2016

14:33 Re: Storing large documents - one table or partition by doc? Dev Nop

25 September 2016

00:30 Re: Storing large documents - one table or partition by doc? Jim Nasby

26 September 2016

03:20 Re: Storing large documents - one table or partition by doc? Jeff Janes
05:50 Millions of tables Greg Spiegelberg
06:04 Re: Millions of tables julyanto SUTANDANG
06:24 Re: Millions of tables Mike Sofen
07:05 Re: Millions of tables Greg Spiegelberg
07:19 Re: Millions of tables Greg Spiegelberg
08:05 Re: Millions of tables Gavin Flower
09:07 Re: Millions of tables Jeff Janes
09:28 Re: Millions of tables julyanto SUTANDANG
11:27 Re: Storing large documents - one table or partition by doc? Dev Nop
11:29 Re: Millions of tables Álvaro Hernández Tortosa
12:43 Re: Millions of tables Stuart Bishop
13:24 Re: Millions of tables Rick Otten
15:53 Re: Millions of tables Greg Spiegelberg
15:54 Re: Millions of tables Yves Dorfsman
16:05 Re: Millions of tables Mike Sofen
16:51 Re: Millions of tables Greg Spiegelberg
16:53 Re: Millions of tables Greg Spiegelberg
16:57 Re: Millions of tables Greg Spiegelberg
17:09 Re: Millions of tables Greg Spiegelberg
17:21 Re: Millions of tables Stuart Bishop
17:24 Re: Millions of tables Greg Spiegelberg
18:39 temporary table vs array performance dbyzaa@163.com
18:49 Re: [HACKERS] temporary table vs array performance David G. Johnston
19:00 Re: Problem with performance using query with unnest after migrating from V9.1 to V9.2 and higher Knels, Udo
19:17 Re: [HACKERS] temporary table vs array performance Pavel Stehule
19:29 Re: Millions of tables Jeff Janes
19:52 Re: Millions of tables Tom Lane
22:59 Re: Storing large documents - one table or partition by doc? Jim Nasby

27 September 2016

17:30 Re: Millions of tables Craig James
18:10 Re: Millions of tables Mike Sofen
18:43 Re: Millions of tables Mike Sofen
18:46 Re: Millions of tables Greg Spiegelberg
18:49 Re: Millions of tables Greg Spiegelberg
19:00 Re: PostgreSQL on ZFS: performance tuning Torsten Zuehlsdorff
19:15 Re: Millions of tables Terry Schmitt
19:27 Re: Millions of tables Greg Spiegelberg

28 September 2016

00:38 Re: PostgreSQL on ZFS: performance tuning Tomas Vondra
01:15 Re: PostgreSQL on ZFS: performance tuning Karl Denninger
03:02 Unexpected expensive index scan Jake Nielsen
03:21 Re: Unexpected expensive index scan Jake Nielsen
03:42 Re: Unexpected expensive index scan Mike Sofen
04:03 Re: Unexpected expensive index scan Jake Nielsen
04:24 Re: Unexpected expensive index scan Jake Nielsen
05:46 Re: Unexpected expensive index scan Jake Nielsen
07:06 Re: PostgreSQL on ZFS: performance tuning Jov
07:11 Re: PostgreSQL on ZFS: performance tuning Jov
14:44 Re: PostgreSQL on ZFS: performance tuning Karl Denninger
16:05 Re: Unexpected expensive index scan Tom Lane
18:40 Re: Millions of tables Vitalii Tymchyshyn
19:05 Re: Millions of tables Richard Albright
19:27 Re: Millions of tables Greg Spiegelberg
20:28 Re: Millions of tables Stephen Frost
20:38 Re: Millions of tables Greg Spiegelberg
21:00 Re: Millions of tables Stephen Frost
21:11 Re: Unexpected expensive index scan Jake Nielsen
21:42 Re: PostgreSQL on ZFS: performance tuning trafdev
22:06 Re: PostgreSQL on ZFS: performance tuning Karl Denninger

29 September 2016

11:21 Re: Millions of tables Simon Riggs
14:11 Re: Millions of tables Alex Ignatov \(postgrespro\)
15:20 Re: Multiple-Table-Spanning Joins with ORs in WHERE Clause Sven R. Kunze
15:37 Failing Multi-Job Restores, Missing Indexes on Restore Cea Stapleton
15:52 Re: Failing Multi-Job Restores, Missing Indexes on Restore Tom Lane
15:56 Re: Failing Multi-Job Restores, Missing Indexes on Restore Cea Stapleton
16:09 Re: Failing Multi-Job Restores, Missing Indexes on Restore Tom Lane
21:03 Re: Multiple-Table-Spanning Joins with ORs in WHERE Clause Jeff Janes
21:13 Re: Multiple-Table-Spanning Joins with ORs in WHERE Clause Pavel Stehule
21:48 Re: Multiple-Table-Spanning Joins with ORs in WHERE Clause Sven R. Kunze
21:49 Re: Multiple-Table-Spanning Joins with ORs in WHERE Clause Sven R. Kunze
22:12 Re: Multiple-Table-Spanning Joins with ORs in WHERE Clause Pavel Stehule
23:26 Re: Multiple-Table-Spanning Joins with ORs in WHERE Clause Jeff Janes
23:35 Re: Multiple-Table-Spanning Joins with ORs in WHERE Clause Jeff Janes

30 September 2016

14:22 Re: Multiple-Table-Spanning Joins with ORs in WHERE Clause Sven R. Kunze
14:29 Re: Multiple-Table-Spanning Joins with ORs in WHERE Clause Sven R. Kunze
15:03 MYSQL Stats Joe Proietti
16:44 Re: MYSQL Stats Joe Proietti