Home > mailing lists

Mailing lists [pgsql-performance]

1 March 2013

03:30 Re: SELECT is slow on smaller table? Ao Jianwang
09:32 Processing of subqueries in union Markus Hervén
12:52 hardware upgrade, performance degrade? Steven Crandell
14:13 Re: hardware upgrade, performance degrade? Guillaume Smet
14:43 New server setup Niels Kristian Schjødt
17:09 Re: xmlconcat performance Merlin Moncure
18:28 Re: New server setup Craig James
18:41 Re: hardware upgrade, performance degrade? Craig James
19:50 Re: hardware upgrade, performance degrade? Steven Crandell
20:08 Re: New server setup Wales Wang

2 March 2013

09:51 Re: hardware upgrade, performance degrade? Scott Marlowe
10:30 Re: hardware upgrade, performance degrade? Jesper Krogh

3 March 2013

23:16 Re: hardware upgrade, performance degrade? Josh Berkus
23:35 Re: hardware upgrade, performance degrade? Jean-David Beyer

4 March 2013

14:20 Re: New server setup Niels Kristian Schjødt
16:52 What setup would you choose for postgresql 9.2 installation? Niels Kristian Schjødt
17:06 Re: What setup would you choose for postgresql 9.2 installation? AJ Weber
17:18 Re: What setup would you choose for postgresql 9.2 installation? Richard Neill
17:21 Re: pgbench intriguing results: better tps figures for larger scale factor Merlin Moncure
17:36 Re: What setup would you choose for postgresql 9.2 installation? Scott Marlowe
17:45 Re: What setup would you choose for postgresql 9.2 installation? AJ Weber
18:23 Re: What setup would you choose for postgresql 9.2 installation? Scott Marlowe
20:25 Re: What setup would you choose for postgresql 9.2 installation? Niels Kristian Schjødt

5 March 2013

00:32 Schema obfuscator for performance question Joseph Pravato
00:37 Re: Schema obfuscator for performance question Victor Yegorov
00:37 Re: Schema obfuscator for performance question Claudio Freire
01:46 Re: pgbench intriguing results: better tps figures for larger scale factor Greg Smith
01:54 Re: hardware upgrade, performance degrade? Steven Crandell
02:09 Re: hardware upgrade, performance degrade? Mark Kirkwood
02:11 Re: hardware upgrade, performance degrade? Sergey Konoplev
02:17 Re: hardware upgrade, performance degrade? John Rouillard
02:46 Re: hardware upgrade, performance degrade? Scott Marlowe
02:47 Re: hardware upgrade, performance degrade? Steven Crandell
05:00 Re: hardware upgrade, performance degrade? Scott Marlowe
06:05 Re: hardware upgrade, performance degrade? Steven Crandell
17:01 Optimize SELECT * from table WHERE foreign_key_id IN (key1,key2,key3,key4...) Niels Kristian Schjødt
17:14 Re: Poor performance after update from SLES11 SP1 to SP2 Mark Smith
17:27 Re: Optimize SELECT * from table WHERE foreign_key_id IN (key1,key2,key3,key4...) Julien Cigar
19:34 Re: New server setup Kevin Grittner
20:10 Re: New server setup Scott Marlowe
20:11 Re: New server setup Niels Kristian Schjødt
20:46 Re: Are bitmap index scans slow to start? Jeff Janes
21:03 Re: New server setup Benjamin Krajmalnik
21:27 Re: New server setup Niels Kristian Schjødt
22:36 sniff test on some PG 8.4 numbers Jon Nelson

6 March 2013

00:20 Re: Are bitmap index scans slow to start? Jeff Janes
00:59 Re: New server setup Jeff Janes
02:55 Re: Optimize SELECT * from table WHERE foreign_key_id IN (key1,key2,key3,key4...) Niels Kristian Schjødt
03:08 Re: Optimize SELECT * from table WHERE foreign_key_id IN (key1,key2,key3,key4...) Joshua D. Drake
04:02 Re: sniff test on some PG 8.4 numbers Josh Berkus
05:13 Re: sniff test on some PG 8.4 numbers Jon Nelson
06:00 Re: sniff test on some PG 8.4 numbers Jon Nelson
15:33 Re: Optimize SELECT * from table WHERE foreign_key_id IN (key1,key2,key3,key4...) Julien Cigar
17:54 Poor plan when joining against a union containing a join David Leverton
19:44 Re: Optimize SELECT * from table WHERE foreign_key_id IN (key1,key2,key3,key4...) Jeff Janes

7 March 2013

02:15 Re: Poor plan when joining against a union containing a join Josh Berkus
08:52 Re: Poor plan when joining against a union containing a join Tom Lane
21:21 Re: Poor plan when joining against a union containing a join David Leverton
21:47 Re: Poor plan when joining against a union containing a join Tom Lane

8 March 2013

09:48 Anyone running Intel S3700 SSDs? CSS
11:49 Re: Anyone running Intel S3700 SSDs? Yeb Havinga
14:27 PostgreSQL 9.2.3 performance problem caused Exclusive locks Emre Hasegeli
16:50 Re: Poor plan when joining against a union containing a join David Leverton
22:56 Re: PostgreSQL 9.2.3 performance problem caused Exclusive locks Emre Hasegeli

9 March 2013

00:28 Re: Are bitmap index scans slow to start? Carlo Stonebanks
20:53 Re: New server setup Gregg Jaskiewicz

10 March 2013

18:46 Re: sniff test on some PG 8.4 numbers Greg Smith
18:58 Re: New server setup Greg Smith

11 March 2013

04:18 Re: sniff test on some PG 8.4 numbers Jon Nelson
06:02 Re: sniff test on some PG 8.4 numbers Scott Marlowe
07:28 Re: sniff test on some PG 8.4 numbers Greg Smith
17:27 Large Table - Slow Window Functions (Better Approach?) Jeff Adams - NOAA Affiliate
17:47 Re: sniff test on some PG 8.4 numbers Jon Nelson
18:04 Re: Large Table - Slow Window Functions (Better Approach?) Pavel Stehule
18:20 Re: Large Table - Slow Window Functions (Better Approach?) Jeff Adams - NOAA Affiliate
18:35 Re: Large Table - Slow Window Functions (Better Approach?) Pavel Stehule
18:48 Re: Large Table - Slow Window Functions (Better Approach?) Jeff Adams - NOAA Affiliate
18:53 The dreaded semwait on FreeBSD Benjamin Krajmalnik

12 March 2013

01:29 Slow query when used in a view Shaun Thomas
02:57 Re: Slow query when used in a view Tom Lane
06:55 Slow concurrent processing Misa Simic
16:08 Re: Large Table - Slow Window Functions (Better Approach?) Jeff Adams - NOAA Affiliate
16:37 Re: Large Table - Slow Window Functions (Better Approach?) Victor Yegorov
16:49 Re: Slow query when used in a view Shaun Thomas
17:13 Re: Slow concurrent processing Misa Simic
17:20 Re: Slow concurrent processing Steve Crawford
18:06 Re: Slow concurrent processing Misa Simic
18:54 Re: Slow concurrent processing Steve Crawford
20:09 Re: Slow concurrent processing Jeff Janes
20:11 Re: Slow concurrent processing Misa Simic
20:16 Re: Slow concurrent processing Misa Simic
22:17 Re: PostgreSQL 9.2.3 performance problem caused Exclusive locks Emre Hasegeli

13 March 2013

00:41 Re: New server setup Gregg Jaskiewicz
18:24 Risk of data corruption/loss? Niels Kristian Schjødt
18:33 Re: New server setup John Lister
18:51 Re: New server setup Greg Jaskiewicz
19:15 Re: New server setup John Lister
20:13 Re: Risk of data corruption/loss? Jeff Janes
20:34 Re: Risk of data corruption/loss? Niels Kristian Schjødt
20:43 Setup of four 15k SAS disk with LSI raid controller Niels Kristian Schjødt
21:15 Re: Setup of four 15k SAS disk with LSI raid controller Vasilis Ventirozos
21:37 Re: Setup of four 15k SAS disk with LSI raid controller Niels Kristian Schjødt
21:45 Re: Setup of four 15k SAS disk with LSI raid controller Vasilis Ventirozos
22:00 Re: Setup of four 15k SAS disk with LSI raid controller Joshua D. Drake
22:23 Re: New server setup Steve Crawford
22:26 Re: Setup of four 15k SAS disk with LSI raid controller Niels Kristian Schjødt
22:38 Re: New server setup Karl Denninger
22:47 Re: New server setup CSS
23:05 Re: New server setup John Lister
23:16 Re: New server setup David Boreham

14 March 2013

00:05 Re: PostgreSQL 9.2.3 performance problem caused Exclusive locks Joshua Berkus
00:18 Re: Risk of data corruption/loss? Joshua Berkus
06:29 Re: New server setup Mark Kirkwood
06:39 Re: New server setup David Boreham
07:54 PostgreSQL 9.2.3 performance problem caused Exclusive locks Jeff Janes
20:07 Re: PostgreSQL 9.2.3 performance problem caused Exclusive locks Emre Hasegeli
21:54 Re: New server setup Bruce Momjian
22:22 Speed of EXCECUTE in PL/PGSQL Artur Zając
22:36 Re: Speed of EXCECUTE in PL/PGSQL Merlin Moncure
22:39 Re: Speed of EXCECUTE in PL/PGSQL Andrew Dunstan

15 March 2013

00:38 Re: New server setup Mark Kirkwood
00:47 Re: New server setup Mark Kirkwood
01:34 Re: New server setup Bruce Momjian
01:53 Re: New server setup Mark Kirkwood
02:38 Re: New server setup David Boreham
18:02 Join the master table with other table is very slow (partitioning) Ao Jianwang
18:09 Re: Join the master table with other table is very slow (partitioning) Ao Jianwang
18:12 Re: Join the master table with other table is very slow (partitioning) AI Rumman
18:17 Re: Join the master table with other table is very slow (partitioning) Ao Jianwang
18:39 Re: Join the master table with other table is very slow (partitioning) Ao Jianwang
18:42 Re: Join the master table with other table is very slow (partitioning) Tom Lane
19:04 Re: Join the master table with other table is very slow (partitioning) Ao Jianwang
20:31 Pre-sorting COPY FROM input Florian Weimer
21:06 Re: New server setup Rick Otten
21:27 Re: Pre-sorting COPY FROM input Heikki Linnakangas
21:55 Re: New server setup Bruce Momjian
22:14 Re: New server setup Scott Marlowe

16 March 2013

11:47 Re: New server setup Mark Kirkwood

18 March 2013

12:14 Why is my pg_xlog directory so huge? Niels Kristian Schjødt
12:26 Re: Why is my pg_xlog directory so huge? Magnus Hagander
17:08 Re: Why is my pg_xlog directory so huge? Niels Kristian Schjødt
17:39 Re: Why is my pg_xlog directory so huge? Magnus Hagander
18:41 Re: Why is my pg_xlog directory so huge? Niels Kristian Schjødt
20:54 effective_cache_size on 32-bits postgres Rodrigo Barboza
21:15 Re: effective_cache_size on 32-bits postgres Rob Wultsch
21:16 Re: effective_cache_size on 32-bits postgres Pavel Stehule
21:18 Re: effective_cache_size on 32-bits postgres Rodrigo Barboza
21:19 Re: effective_cache_size on 32-bits postgres Pavel Stehule
21:24 Re: effective_cache_size on 32-bits postgres Rodrigo Barboza
21:34 Re: effective_cache_size on 32-bits postgres Pavel Stehule
21:47 Re: effective_cache_size on 32-bits postgres Kevin Grittner
21:51 Re: effective_cache_size on 32-bits postgres Claudio Freire
21:51 Re: effective_cache_size on 32-bits postgres Pavel Stehule
21:54 Re: effective_cache_size on 32-bits postgres Rodrigo Barboza

21 March 2013

03:13 Index usage for tstzrange? Josh Berkus
03:45 Re: New server setup David Rees
04:04 Re: New server setup David Boreham
04:46 Re: New server setup Karl Denninger
04:56 Re: New server setup Scott Marlowe
05:26 Re: New server setup Mark Kirkwood
06:59 Re: Index usage for tstzrange? Tom Lane
07:07 Re: Index usage for tstzrange? Vasilis Ventirozos
12:05 Re: Index usage for tstzrange? Heikki Linnakangas

22 March 2013

03:05 Re: Index usage for tstzrange? Josh Berkus
22:46 Performance of query Cindy Makarowsky

23 March 2013

00:14 Re: Performance of query Josh Berkus
00:53 Re: Index usage for tstzrange? Heikki Linnakangas
01:20 Re: Performance of query Cindy Makarowsky
01:25 Re: Performance of query Misa Simic
01:26 Re: Performance of query Cindy Makarowsky
01:53 Re: Index usage for tstzrange? Heikki Linnakangas
04:23 Re: Index usage for tstzrange? Josh Berkus
07:31 Re: Index usage for tstzrange? Tom Lane

24 March 2013

00:53 Re: Performance of query Jeff Janes
01:27 Re: Performance of query Misa Simic
03:12 PostgreSQL planner Misa Simic
09:45 Re: Performance of query Roman Konoval

25 March 2013

12:57 9.2.3 upgrade reduced pgbench performance by 60% Colin Currie
21:18 Re: Performance of query Jeff Janes
21:55 Re: Performance of query Cindy Makarowsky
23:08 Proof of concept: Evolving postgresql.conf using genetic algorithm Greg Jaskiewicz
23:31 Setting vacuum_freeze_min_age really low Josh Berkus
23:34 Re: 9.2.3 upgrade reduced pgbench performance by 60% Josh Berkus

26 March 2013

16:04 [OT] linux 3.10 kernel will improve ipc,sysv semaphore scalability Andrea Suisani
22:00 Re: [OT] linux 3.10 kernel will improve ipc,sysv semaphore scalability Shaun Thomas
23:07 Re: 9.2.3 upgrade reduced pgbench performance by 60% Nicholson, Brad (Toronto, ON, CA)

27 March 2013

17:04 Reg: Slow query Prakash Chinnakannan
17:15 Re: Reg: Slow query Vasilis Ventirozos

28 March 2013

01:52 Re: 9.2.3 upgrade reduced pgbench performance by 60% Josh Berkus
18:59 how to help the planner Marty Frasier
19:18 Re: how to help the planner Tom Lane
22:07 Question about postmaster's CPU usage kelphet xiong
23:45 Re: how to help the planner Marty Frasier

29 March 2013

00:03 Re: Question about postmaster's CPU usage Kevin Grittner
00:21 Re: Question about postmaster's CPU usage ktm@rice.edu
01:13 Re: how to help the planner Stephen Frost
17:21 Postgresql performance degrading... how to diagnose the root cause Franck Routier
17:42 Re: Postgresql performance degrading... how to diagnose the root cause Julien Cigar
17:50 Re: Postgresql performance degrading... how to diagnose the root cause Guillaume Cottenceau
17:53 Re: [OT] linux 3.10 kernel will improve ipc,sysv semaphore scalability Andrea Suisani
18:31 Re: Postgresql performance degrading... how to diagnose the root cause Franck Routier
21:23 Re: how to help the planner Igor Neyman

30 March 2013

02:24 Re: Postgresql performance degrading... how to diagnose the root cause Jeff Janes
03:03 Re: Postgresql performance degrading... how to diagnose the root cause Guillaume Cottenceau
15:57 Re: Postgresql performance degrading... how to diagnose the root cause Cédric Villemain
22:01 Re: Postgresql performance degrading... how to diagnose the root cause Jeff Janes

31 March 2013

02:45 Re: Question about postmaster's CPU usage Ants Aasma
07:00 Re: Question about postmaster's CPU usage Kelphet Xiong
20:16 Re: 9.2.3 upgrade reduced pgbench performance by 60% Jeff Janes