Продукты

О компании

Ресурсы

Мероприятия

Образование

...

Протестировать

Архив рассылок [pgsql-performance]

ФевральАпрель

1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 18 21 22 23 24 25 26 27 28 29 30 31

1 марта 2013 г.

00:30Re: SELECT is slow on smaller table? Ao Jianwang

06:32Processing of subqueries in union Markus Hervén

09:52hardware upgrade, performance degrade? Steven Crandell

11:13Re: hardware upgrade, performance degrade? Guillaume Smet

11:43New server setup Niels Kristian Schjødt

14:09Re: xmlconcat performance Merlin Moncure

15:28Re: New server setup Craig James

15:41Re: hardware upgrade, performance degrade? Craig James

16:50Re: hardware upgrade, performance degrade? Steven Crandell

17:08Re: New server setup Wales Wang

2 марта 2013 г.

06:51Re: hardware upgrade, performance degrade? Scott Marlowe

07:30Re: hardware upgrade, performance degrade? Jesper Krogh

3 марта 2013 г.

20:16Re: hardware upgrade, performance degrade? Josh Berkus

20:35Re: hardware upgrade, performance degrade? Jean-David Beyer

4 марта 2013 г.

11:20Re: New server setup Niels Kristian Schjødt

13:52What setup would you choose for postgresql 9.2 installation? Niels Kristian Schjødt

14:06Re: What setup would you choose for postgresql 9.2 installation? AJ Weber

14:18Re: What setup would you choose for postgresql 9.2 installation? Richard Neill

14:21Re: pgbench intriguing results: better tps figures for larger scale factor Merlin Moncure

14:36Re: What setup would you choose for postgresql 9.2 installation? Scott Marlowe

14:45Re: What setup would you choose for postgresql 9.2 installation? AJ Weber

15:23Re: What setup would you choose for postgresql 9.2 installation? Scott Marlowe

17:25Re: What setup would you choose for postgresql 9.2 installation? Niels Kristian Schjødt

21:32Schema obfuscator for performance question Joseph Pravato

21:37Re: Schema obfuscator for performance question Victor Yegorov

21:37Re: Schema obfuscator for performance question Claudio Freire

22:46Re: pgbench intriguing results: better tps figures for larger scale factor Greg Smith

22:54Re: hardware upgrade, performance degrade? Steven Crandell

23:09Re: hardware upgrade, performance degrade? Mark Kirkwood

23:11Re: hardware upgrade, performance degrade? Sergey Konoplev

23:17Re: hardware upgrade, performance degrade? John Rouillard

23:46Re: hardware upgrade, performance degrade? Scott Marlowe

23:47Re: hardware upgrade, performance degrade? Steven Crandell

5 марта 2013 г.

02:00Re: hardware upgrade, performance degrade? Scott Marlowe

03:05Re: hardware upgrade, performance degrade? Steven Crandell

14:01Optimize SELECT * from table WHERE foreign_key_id IN (key1,key2,key3,key4...) Niels Kristian Schjødt

14:14Re: Poor performance after update from SLES11 SP1 to SP2 Mark Smith

14:27Re: Optimize SELECT * from table WHERE foreign_key_id IN (key1,key2,key3,key4...) Julien Cigar

16:34Re: New server setup Kevin Grittner

17:10Re: New server setup Scott Marlowe

17:11Re: New server setup Niels Kristian Schjødt

17:46Re: Are bitmap index scans slow to start? Jeff Janes

18:03Re: New server setup Benjamin Krajmalnik

18:27Re: New server setup Niels Kristian Schjødt

19:36sniff test on some PG 8.4 numbers Jon Nelson

21:20Re: Are bitmap index scans slow to start? Jeff Janes

21:59Re: New server setup Jeff Janes

23:55Re: Optimize SELECT * from table WHERE foreign_key_id IN (key1,key2,key3,key4...) Niels Kristian Schjødt

6 марта 2013 г.

00:08Re: Optimize SELECT * from table WHERE foreign_key_id IN (key1,key2,key3,key4...) Joshua D. Drake

01:02Re: sniff test on some PG 8.4 numbers Josh Berkus

02:13Re: sniff test on some PG 8.4 numbers Jon Nelson

03:00Re: sniff test on some PG 8.4 numbers Jon Nelson

12:33Re: Optimize SELECT * from table WHERE foreign_key_id IN (key1,key2,key3,key4...) Julien Cigar

14:54Poor plan when joining against a union containing a join David Leverton

16:44Re: Optimize SELECT * from table WHERE foreign_key_id IN (key1,key2,key3,key4...) Jeff Janes

23:15Re: Poor plan when joining against a union containing a join Josh Berkus

7 марта 2013 г.

05:52Re: Poor plan when joining against a union containing a join Tom Lane

18:21Re: Poor plan when joining against a union containing a join David Leverton

18:47Re: Poor plan when joining against a union containing a join Tom Lane

8 марта 2013 г.

06:48Anyone running Intel S3700 SSDs? CSS

08:49Re: Anyone running Intel S3700 SSDs? Yeb Havinga

11:27PostgreSQL 9.2.3 performance problem caused Exclusive locks Emre Hasegeli

13:50Re: Poor plan when joining against a union containing a join David Leverton

19:56Re: PostgreSQL 9.2.3 performance problem caused Exclusive locks Emre Hasegeli

21:28Re: Are bitmap index scans slow to start? Carlo Stonebanks

9 марта 2013 г.

17:53Re: New server setup Gregg Jaskiewicz

10 марта 2013 г.

15:46Re: sniff test on some PG 8.4 numbers Greg Smith

15:58Re: New server setup Greg Smith

11 марта 2013 г.

01:18Re: sniff test on some PG 8.4 numbers Jon Nelson

03:02Re: sniff test on some PG 8.4 numbers Scott Marlowe

04:28Re: sniff test on some PG 8.4 numbers Greg Smith

14:27Large Table - Slow Window Functions (Better Approach?) Jeff Adams - NOAA Affiliate

14:47Re: sniff test on some PG 8.4 numbers Jon Nelson

15:04Re: Large Table - Slow Window Functions (Better Approach?) Pavel Stehule

15:20Re: Large Table - Slow Window Functions (Better Approach?) Jeff Adams - NOAA Affiliate

15:35Re: Large Table - Slow Window Functions (Better Approach?) Pavel Stehule

15:48Re: Large Table - Slow Window Functions (Better Approach?) Jeff Adams - NOAA Affiliate

15:53The dreaded semwait on FreeBSD Benjamin Krajmalnik

22:29Slow query when used in a view Shaun Thomas

23:57Re: Slow query when used in a view Tom Lane

12 марта 2013 г.

03:55Slow concurrent processing Misa Simic

13:08Re: Large Table - Slow Window Functions (Better Approach?) Jeff Adams - NOAA Affiliate

13:37Re: Large Table - Slow Window Functions (Better Approach?) Victor Yegorov

13:49Re: Slow query when used in a view Shaun Thomas

14:13Re: Slow concurrent processing Misa Simic

14:20Re: Slow concurrent processing Steve Crawford

15:06Re: Slow concurrent processing Misa Simic

15:54Re: Slow concurrent processing Steve Crawford

17:09Re: Slow concurrent processing Jeff Janes

17:11Re: Slow concurrent processing Misa Simic

17:16Re: Slow concurrent processing Misa Simic

19:17Re: PostgreSQL 9.2.3 performance problem caused Exclusive locks Emre Hasegeli

21:41Re: New server setup Gregg Jaskiewicz

13 марта 2013 г.

15:24Risk of data corruption/loss? Niels Kristian Schjødt

15:33Re: New server setup John Lister

15:51Re: New server setup Greg Jaskiewicz

16:15Re: New server setup John Lister

17:13Re: Risk of data corruption/loss? Jeff Janes

17:34Re: Risk of data corruption/loss? Niels Kristian Schjødt

17:43Setup of four 15k SAS disk with LSI raid controller Niels Kristian Schjødt

18:15Re: Setup of four 15k SAS disk with LSI raid controller Vasilis Ventirozos

18:37Re: Setup of four 15k SAS disk with LSI raid controller Niels Kristian Schjødt

18:45Re: Setup of four 15k SAS disk with LSI raid controller Vasilis Ventirozos

19:00Re: Setup of four 15k SAS disk with LSI raid controller Joshua D. Drake

19:23Re: New server setup Steve Crawford

19:26Re: Setup of four 15k SAS disk with LSI raid controller Niels Kristian Schjødt

19:38Re: New server setup Karl Denninger

19:47Re: New server setup CSS

20:05Re: New server setup John Lister

20:16Re: New server setup David Boreham

21:05Re: PostgreSQL 9.2.3 performance problem caused Exclusive locks Joshua Berkus

21:18Re: Risk of data corruption/loss? Joshua Berkus

14 марта 2013 г.

03:29Re: New server setup Mark Kirkwood

03:39Re: New server setup David Boreham

04:54PostgreSQL 9.2.3 performance problem caused Exclusive locks Jeff Janes

17:07Re: PostgreSQL 9.2.3 performance problem caused Exclusive locks Emre Hasegeli

18:54Re: New server setup Bruce Momjian

19:22Speed of EXCECUTE in PL/PGSQL Artur Zając

19:36Re: Speed of EXCECUTE in PL/PGSQL Merlin Moncure

19:39Re: Speed of EXCECUTE in PL/PGSQL Andrew Dunstan

21:38Re: New server setup Mark Kirkwood

21:47Re: New server setup Mark Kirkwood

22:34Re: New server setup Bruce Momjian

22:53Re: New server setup Mark Kirkwood

23:38Re: New server setup David Boreham

15 марта 2013 г.

15:02Join the master table with other table is very slow (partitioning) Ao Jianwang

15:09Re: Join the master table with other table is very slow (partitioning) Ao Jianwang

15:12Re: Join the master table with other table is very slow (partitioning) AI Rumman

15:17Re: Join the master table with other table is very slow (partitioning) Ao Jianwang

15:39Re: Join the master table with other table is very slow (partitioning) Ao Jianwang

15:42Re: Join the master table with other table is very slow (partitioning) Tom Lane

16:04Re: Join the master table with other table is very slow (partitioning) Ao Jianwang

17:31Pre-sorting COPY FROM input Florian Weimer

18:06Re: New server setup Rick Otten

18:27Re: Pre-sorting COPY FROM input Heikki Linnakangas

18:55Re: New server setup Bruce Momjian

19:14Re: New server setup Scott Marlowe

16 марта 2013 г.

08:47Re: New server setup Mark Kirkwood

18 марта 2013 г.

09:14Why is my pg_xlog directory so huge? Niels Kristian Schjødt

09:26Re: Why is my pg_xlog directory so huge? Magnus Hagander

14:08Re: Why is my pg_xlog directory so huge? Niels Kristian Schjødt

14:39Re: Why is my pg_xlog directory so huge? Magnus Hagander

15:41Re: Why is my pg_xlog directory so huge? Niels Kristian Schjødt

17:54effective_cache_size on 32-bits postgres Rodrigo Barboza

18:15Re: effective_cache_size on 32-bits postgres Rob Wultsch

18:16Re: effective_cache_size on 32-bits postgres Pavel Stehule

18:18Re: effective_cache_size on 32-bits postgres Rodrigo Barboza

18:19Re: effective_cache_size on 32-bits postgres Pavel Stehule

18:24Re: effective_cache_size on 32-bits postgres Rodrigo Barboza

18:34Re: effective_cache_size on 32-bits postgres Pavel Stehule

18:47Re: effective_cache_size on 32-bits postgres Kevin Grittner

18:51Re: effective_cache_size on 32-bits postgres Claudio Freire

18:51Re: effective_cache_size on 32-bits postgres Pavel Stehule

18:54Re: effective_cache_size on 32-bits postgres Rodrigo Barboza

21 марта 2013 г.

00:13Index usage for tstzrange? Josh Berkus

00:45Re: New server setup David Rees

01:04Re: New server setup David Boreham

01:46Re: New server setup Karl Denninger

01:56Re: New server setup Scott Marlowe

02:26Re: New server setup Mark Kirkwood

03:59Re: Index usage for tstzrange? Tom Lane

04:07Re: Index usage for tstzrange? Vasilis Ventirozos

09:05Re: Index usage for tstzrange? Heikki Linnakangas

22 марта 2013 г.

00:05Re: Index usage for tstzrange? Josh Berkus

19:46Performance of query Cindy Makarowsky

21:14Re: Performance of query Josh Berkus

21:53Re: Index usage for tstzrange? Heikki Linnakangas

22:20Re: Performance of query Cindy Makarowsky

22:25Re: Performance of query Misa Simic

22:26Re: Performance of query Cindy Makarowsky

22:53Re: Index usage for tstzrange? Heikki Linnakangas

23 марта 2013 г.

01:23Re: Index usage for tstzrange? Josh Berkus

04:31Re: Index usage for tstzrange? Tom Lane

21:53Re: Performance of query Jeff Janes

22:27Re: Performance of query Misa Simic

24 марта 2013 г.

00:12PostgreSQL planner Misa Simic

06:45Re: Performance of query Roman Konoval

25 марта 2013 г.

09:579.2.3 upgrade reduced pgbench performance by 60% Colin Currie

18:18Re: Performance of query Jeff Janes

18:55Re: Performance of query Cindy Makarowsky

20:08Proof of concept: Evolving postgresql.conf using genetic algorithm Greg Jaskiewicz

20:31Setting vacuum_freeze_min_age really low Josh Berkus

20:34Re: 9.2.3 upgrade reduced pgbench performance by 60% Josh Berkus

26 марта 2013 г.

13:04[OT] linux 3.10 kernel will improve ipc,sysv semaphore scalability Andrea Suisani

19:00Re: [OT] linux 3.10 kernel will improve ipc,sysv semaphore scalability Shaun Thomas

20:07Re: 9.2.3 upgrade reduced pgbench performance by 60% Nicholson, Brad (Toronto, ON, CA)

27 марта 2013 г.

14:04Reg: Slow query Prakash Chinnakannan

14:15Re: Reg: Slow query Vasilis Ventirozos

22:52Re: 9.2.3 upgrade reduced pgbench performance by 60% Josh Berkus

28 марта 2013 г.

15:59how to help the planner Marty Frasier

16:18Re: how to help the planner Tom Lane

19:07Question about postmaster's CPU usage kelphet xiong

20:45Re: how to help the planner Marty Frasier

21:03Re: Question about postmaster's CPU usage Kevin Grittner

21:21Re: Question about postmaster's CPU usage ktm@rice.edu

22:13Re: how to help the planner Stephen Frost

29 марта 2013 г.

14:21Postgresql performance degrading... how to diagnose the root cause Franck Routier

14:42Re: Postgresql performance degrading... how to diagnose the root cause Julien Cigar

14:50Re: Postgresql performance degrading... how to diagnose the root cause Guillaume Cottenceau

14:53Re: [OT] linux 3.10 kernel will improve ipc,sysv semaphore scalability Andrea Suisani

15:31Re: Postgresql performance degrading... how to diagnose the root cause Franck Routier

18:23Re: how to help the planner Igor Neyman

23:24Re: Postgresql performance degrading... how to diagnose the root cause Jeff Janes

30 марта 2013 г.

00:03Re: Postgresql performance degrading... how to diagnose the root cause Guillaume Cottenceau

12:57Re: Postgresql performance degrading... how to diagnose the root cause Cédric Villemain

19:01Re: Postgresql performance degrading... how to diagnose the root cause Jeff Janes

23:45Re: Question about postmaster's CPU usage Ants Aasma

31 марта 2013 г.

04:00Re: Question about postmaster's CPU usage Kelphet Xiong

17:16Re: 9.2.3 upgrade reduced pgbench performance by 60% Jeff Janes

Ответы на вопросы