Home > mailing lists

Mailing lists [pgsql-performance]

1 April 2013

03:37 query plan estimate pg noob
03:53 Re: query plan estimate Tom Lane
16:42 Re: Question about postmaster's CPU usage Merlin Moncure

2 April 2013

01:36 Problems with pg_locks explosion Armand du Plessis
01:56 Fwd: Problems with pg_locks explosion Vasilis Ventirozos
02:10 Re: Problems with pg_locks explosion Armand du Plessis
02:15 Re: Problems with pg_locks explosion Armand du Plessis
02:43 Re: Problems with pg_locks explosion Vasilis Ventirozos
03:10 Postgres upgrade, security release, where? Tory M Blue
03:11 Re: Problems with pg_locks explosion Mark Kirkwood
03:21 Re: Problems with pg_locks explosion Jeff Janes
03:27 Re: Postgres upgrade, security release, where? Bruce Momjian
03:32 Fwd: Problems with pg_locks explosion Armand du Plessis
03:40 Re: Postgres upgrade, security release, where? Ian Lawrence Barwick
03:41 Re: Problems with pg_locks explosion Armand du Plessis
03:55 Re: Postgres upgrade, security release, where? Bruce Momjian
03:59 Re: Problems with pg_locks explosion Armand du Plessis
04:07 Re: Problems with pg_locks explosion Steven Crandell
05:54 Re: Problems with pg_locks explosion Armand du Plessis
06:36 Re: Postgres upgrade, security release, where? Tory M Blue
06:41 Re: Fwd: Problems with pg_locks explosion Mark Kirkwood
06:43 Re: Postgres upgrade, security release, where? Mark Kirkwood
09:08 Re: Problems with pg_locks explosion Jeff Janes
09:08 Re: Problems with pg_locks explosion Jeff Janes
09:22 Re: Problems with pg_locks explosion Armand du Plessis
09:25 Re: Problems with pg_locks explosion Mark Kirkwood
09:33 Re: Problems with pg_locks explosion Armand du Plessis
09:43 Re: Problems with pg_locks explosion Mark Kirkwood
11:17 Re: Problems with pg_locks explosion Armand du Plessis
11:34 Re: Postgres upgrade, security release, where? Dave Page
11:47 Re: Postgres upgrade, security release, where? Mark Kirkwood
11:52 Join between 2 tables always executes a sequential scan on the larger table Dieter Rehbein
12:55 Re: Problems with pg_locks explosion Armand du Plessis
17:56 Re: Join between 2 tables always executes a sequential scan on the larger table Igor Neyman
18:46 Re: Re: Join between 2 tables always executes a sequential scan on the larger table Tom Lane
21:16 Re: Problems with pg_locks explosion Armand du Plessis
21:57 Planner is getting wrong row count AI Rumman

3 April 2013

11:19 Re: Join between 2 tables always executes a sequential scan on the larger table Dieter Rehbein
11:25 Re: Join between 2 tables always executes a sequential scan on the larger table Dieter Rehbein
11:50 Re: Join between 2 tables always executes a sequential scan on the larger table Vasilis Ventirozos
18:34 Re: Planner is getting wrong row count Kevin Grittner

4 April 2013

11:52 Re: Postgres upgrade, security release, where? Mark Kirkwood
12:11 Re: Postgres upgrade, security release, where? Ian Lawrence Barwick
17:48 What happens between end of explain analyze and end of query execution ? Franck Routier
18:02 Re: What happens between end of explain analyze and end of query execution ? Nikolas Everett
18:44 Re: What happens between end of explain analyze and end of query execution ? Franck Routier
19:25 Re: What happens between end of explain analyze and end of query execution ? Tom Lane
21:50 Re: What happens between end of explain analyze and end of query execution ? Franck Routier
22:06 Re: What happens between end of explain analyze and end of query execution ? nik9000@gmail.com
22:08 Re: What happens between end of explain analyze and end of query execution ? Tom Lane
22:19 Re: What happens between end of explain analyze and end of query execution ? Merlin Moncure

5 April 2013

16:55 Re: What happens between end of explain analyze and end of query execution ? Franck Routier
17:17 Re: What happens between end of explain analyze and end of query execution ? Tom Lane
17:17 Re: What happens between end of explain analyze and end of query execution ? Merlin Moncure
17:18 Re: What happens between end of explain analyze and end of query execution ? Nikolas Everett
18:51 INDEX Performance Issue Mark Davidson
19:37 Re: INDEX Performance Issue Kevin Grittner
19:54 Re: Picking out the most recent row using a time stamp column Dave Johansen
21:40 Re: Picking out the most recent row using a time stamp column Merlin Moncure

6 April 2013

04:38 slow joins? Joe Van Dyk
04:43 Re: slow joins? Joe Van Dyk
04:51 Re: slow joins? Joe Van Dyk
04:54 Re: slow joins? Greg Williamson
05:56 Re: slow joins? Joe Van Dyk
06:33 Re: slow joins? Greg Williamson
11:02 Re: What happens between end of explain analyze and end of query execution ? Franck Routier
11:04 Re: What happens between end of explain analyze and end of query execution ? Franck Routier
11:14 Re: What happens between end of explain analyze and end of query execution ? Franck Routier
12:05 Re: What happens between end of explain analyze and end of query execution ? Franck Routier
13:53 Re: slow joins? Julien Cigar
17:22 Re: slow joins? Kevin Grittner
17:44 Re: slow joins? Julien Cigar
18:26 Re: What happens between end of explain analyze and end of query execution ? Kevin Grittner
19:27 Re: What happens between end of explain analyze and end of query execution ? Tom Lane

7 April 2013

07:59 Find how much memory is postgres using Nik Tek
10:15 Re: Find how much memory is postgres using Yetkin Öztürk
12:49 Re: Find how much memory is postgres using hubert depesz lubaczewski
13:03 Re: INDEX Performance Issue Mark Davidson
13:21 Re: INDEX Performance Issue Greg Williamson
15:12 Re: What happens between end of explain analyze and end of query execution ? Franck Routier
18:15 Re: INDEX Performance Issue Kevin Grittner

8 April 2013

01:22 Re: INDEX Performance Issue Mark Davidson
13:18 Re: Find how much memory is postgres using hubert depesz lubaczewski
19:39 Re: What happens between end of explain analyze and end of query execution ? Jeff Janes
19:46 Re: What happens between end of explain analyze and end of query execution ? Tom Lane
20:03 Re: INDEX Performance Issue Mark Davidson
20:19 Re: INDEX Performance Issue Vasilis Ventirozos
22:31 Re: INDEX Performance Issue Mark Davidson
23:03 Re: INDEX Performance Issue Vasilis Ventirozos
23:25 Re: INDEX Performance Issue Mark Davidson
23:28 Re: INDEX Performance Issue Vasilis Ventirozos
23:39 Re: INDEX Performance Issue Jeff Janes
23:57 Re: INDEX Performance Issue Mark Davidson

9 April 2013

00:01 Re: INDEX Performance Issue Mark Davidson
00:10 Re: Picking out the most recent row using a time stamp column Dave Johansen
21:24 Re: Find how much memory is postgres using Nik Tek
21:34 Re: Find how much memory is postgres using hubert depesz lubaczewski
21:42 Re: Find how much memory is postgres using Nik Tek

10 April 2013

16:50 slow bitmap heap scans on pg 9.2 Steve Singer
16:57 Re: slow bitmap heap scans on pg 9.2 ktm@rice.edu
18:56 Re: slow bitmap heap scans on pg 9.2 Steve Singer
20:50 Re: slow bitmap heap scans on pg 9.2 ktm@rice.edu
21:06 Re: slow bitmap heap scans on pg 9.2 Jeff Janes
21:15 Re: slow bitmap heap scans on pg 9.2 Jeff Janes

11 April 2013

00:25 Postgresql.conf file from like 7.x to 9.2 Tory M Blue
00:42 Re: Postgresql.conf file from like 7.x to 9.2 Shaun Thomas
00:53 Re: Postgresql.conf file from like 7.x to 9.2 Tory M Blue
00:58 Postgres log(pg_logs) have lots of message Nik Tek
01:06 Re: [ADMIN] Postgres log(pg_logs) have lots of message Nik Tek
02:54 Re: slow bitmap heap scans on pg 9.2 Steve Singer
10:47 Performance ts_vector fulltext search Luigi Saggese
17:20 Re: slow bitmap heap scans on pg 9.2 Steve Singer
17:58 Re: Performance ts_vector fulltext search Tom Lane

12 April 2013

00:09 PsqL8.3 Thiyagarajan, Palaniappan
09:14 Re: Postgres log(pg_logs) have lots of message Jeff Janes
13:02 Re: PsqL8.3 Richard Huxton
19:45 Segment best size Rodrigo Barboza
19:51 Changing ORDER BY column slows query dramatically brick pglists
20:52 Re: Segment best size Ben Chobot
22:17 Re: Segment best size Rodrigo Barboza
22:59 Re: Changing ORDER BY column slows query dramatically Shaun Thomas
23:38 Re: Changing ORDER BY column slows query dramatically brick pglists

13 April 2013

00:05 Recommended Swap space Nik Tek
00:15 Re: Recommended Swap space Scott Marlowe
00:21 Re: Recommended Swap space Claudio Freire
00:41 Default value checkpoint_completion_target Rodrigo Barboza
02:06 Re: Recommended Swap space Scott Marlowe
04:20 Re: Segment best size Jeff Janes
04:20 Re: slow bitmap heap scans on pg 9.2 Jeff Janes
11:25 limit is sometimes not pushed in view with order Rikard Pavelic
18:21 Re: limit is sometimes not pushed in view with order Tom Lane
18:37 Re: limit is sometimes not pushed in view with order Julian
19:14 Re: slow bitmap heap scans on pg 9.2 Steve Singer
20:29 Re: Segment best size Rodrigo Barboza
21:08 Re: limit is sometimes not pushed in view with order Rikard Pavelic
22:51 Re: Segment best size Jeff Janes
23:54 Re: slow bitmap heap scans on pg 9.2 Jeff Janes

14 April 2013

01:08 Re: limit is sometimes not pushed in view with order Rikard Pavelic
06:01 Re: Segment best size Rodrigo Barboza
08:21 Re: Segment best size Scott Marlowe
13:34 Re: limit is sometimes not pushed in view with order Rikard Pavelic
17:34 Re: limit is sometimes not pushed in view with order Rikard Pavelic

15 April 2013

01:34 Re: Segment best size Jeff Janes
02:30 Re: Segment best size Rodrigo Barboza
03:07 Re: slow bitmap heap scans on pg 9.2 Steve Singer
09:09 Advice on testing buffer spin lock contention Atri Sharma
20:54 Re: Advice on testing buffer spin lock contention Atri Sharma
22:31 Re: INDEX Performance Issue Jeff Janes
22:37 Re: INDEX Performance Issue Jeff Janes
23:16 Re: INDEX Performance Issue Jeff Janes

16 April 2013

00:00 Poor performance on an aggregate query Anne Rosset
00:04 Re: Poor performance on an aggregate query Peter Geoghegan
12:16 Re: Postgresql performance degrading... how to diagnose the root cause Franck Routier

18 April 2013

17:20 "WHERE 1 = 2 OR ..." makes planner choose a very inefficient plan dmitry potapov
17:43 Re: "WHERE 1 = 2 OR ..." makes planner choose a very inefficient plan Richard Huxton
17:47 Re: "WHERE 1 = 2 OR ..." makes planner choose a very inefficient plan Tom Lane
23:42 Query planner ignoring constraints on partitioned tables when joining Michael Okner
23:44 SQLNestedException: Cannot get a connection, pool error Timeout waiting for idle object itishree sukla
23:45 Re: [GENERAL] SQLNestedException: Cannot get a connection, pool error Timeout waiting for idle object Alfonso Afonso
23:47 High CPU usage buy low I/O wait bing1221
23:54 Re: High CPU usage buy low I/O wait ktm@rice.edu

19 April 2013

00:17 Re: SQLNestedException: Cannot get a connection, pool error Timeout waiting for idle object Vitalii Tymchyshyn
00:42 Re: Query planner ignoring constraints on partitioned tables when joining Tom Lane
20:05 Re: slow bitmap heap scans on pg 9.2 Steve Singer

20 April 2013

00:55 maintenance_work_mem and autovacuum_max_workers Rodrigo Barboza

21 April 2013

15:46 sunil virmani
20:01 Re: Rob Wultsch
20:28 Re: Scott Marlowe
20:32 Re: Scott Marlowe

22 April 2013

00:30 Issues with OSX and SHMMAX? Josh Berkus
00:33 Re: Issues with OSX and SHMMAX? Evgeny Shishkin
11:26 Re: - why only 9.1? Ireneusz Pluta
14:31 template1 vacuuming consuming much time compared to another production DBs pradeep singh
15:08 Re: template1 vacuuming consuming much time compared to another production DBs Andrew Dunstan
19:49 Performance with the new security release Anne Rosset
20:41 Re: Performance with the new security release Heikki Linnakangas
21:19 Re: Issues with OSX and SHMMAX? Josh Berkus

23 April 2013

01:31 Re: Issues with OSX and SHMMAX? Steve Atkins
03:39 Re: Issues with OSX and SHMMAX? Tom Lane
04:49 Re: template1 vacuuming consuming much time compared to another production DBs pradeep singh

25 April 2013

02:56 Question about network bandwidth usage between PostgreSQL’s client and server Kelphet Xiong
14:26 Re: [PERFORM] Question about network bandwidth usage between PostgreSQL’s client and server Heikki Linnakangas
15:18 different plans for the same query - different filter values Misa Simic

26 April 2013

05:33 In progress INSERT wrecks plans on table Mark Kirkwood
06:20 Re: In progress INSERT wrecks plans on table Mark Kirkwood

30 April 2013

20:13 Bad Execution Plan with "OR" Clauses Across Outer-Joined Tables Mark Hampton
22:24 Re: Bad Execution Plan with "OR" Clauses Across Outer-Joined Tables Vitalii Tymchyshyn
23:03 Re: Bad Execution Plan with "OR" Clauses Across Outer-Joined Tables Mark Hampton