Mailing lists [pgsql-performance]

2 March 2014

• 02:47   Help with optimizing a query over hierarchical data Damon Snyder
• 04:02   Re: Help with optimizing a query over hierarchical data Claudio Freire

3 March 2014

• 13:21   Re: Query taking long time acanada
• 20:18   Re: Query taking long time Vladimir Sitnikov
• 20:55   Re: Help with optimizing a query over hierarchical data Damon Snyder
• 21:55   Subselect an order of magnitude faster than nested joins Eli Naeher

4 March 2014

• 00:52   Re: Help with optimizing a query over hierarchical data Claudio Freire
• 02:28   Re: Query taking long time Venkata Balaji Nagothi
• 04:12   Re: Help with optimizing a query over hierarchical data Damon Snyder
• 07:20   Re: Help with optimizing a query over hierarchical data Claudio Freire
• 13:10   Re: Query taking long time acanada
• 14:24   Re: Query taking long time acanada
• 20:06   Re: Help with optimizing a query over hierarchical data Damon Snyder

5 March 2014

• 02:35   Re: Query taking long time Venkata Balaji Nagothi

6 March 2014

• 03:34   Re: Optimal settings for RAID controller - optimized for writes Merlin Moncure
• 08:36   Help me understand why my subselect is an order of magnitude faster than my nested joins Eli Naeher
• 13:47   Re: Query taking long time acanada
• 16:11   Re: Query taking long time desmodemone
• 17:45   Re: Query taking long time acanada

7 March 2014

• 09:04   Slow query Bikram Kesari Naik
• 09:23   Re: Slow query David Johnston
• 09:42   Re: Slow query Bikram Kesari Naik
• 10:18   Re: Slow query David Johnston
• 12:39   Re: Query taking long time Evgeniy Shishkin
• 12:46   Re: Query taking long time acanada
• 13:03   Re: Query taking long time Evgeniy Shishkin
• 13:18   Re: Query taking long time acanada

8 March 2014

• 05:46   How can I get the query planner to use a bitmap index scap instead of an index scan ? Mohan Krishnan

10 March 2014

• 00:47   Re: How can I get the query planner to use a bitmap index scap instead of an index scan ? Jeff Janes
• 11:15   Re: How can I get the query planner to use a bitmap index scap instead of an index scan ? Mohan Krishnan
• 17:45   Re: Query taking long time Evgeniy Shishkin
• 19:30   Re: Query taking long time acanada
• 22:49   Re: Query taking long time Venkata Balaji Nagothi
• 23:22   Re: Query taking long time desmodemone

11 March 2014

• 18:57   Re: Query taking long time acanada
• 23:03   Ye olde slow query Murphy, Kevin

12 March 2014

• 01:23   Re: Ye olde slow query Tom Lane
• 02:16   Re: Query taking long time Evgeny Shishkin

13 March 2014

• 22:27   Very slow query in PostgreSQL 9.3.3 
• 22:37   Re: [BUGS] Very slow query in PostgreSQL 9.3.3 Pavel Stehule

14 March 2014

• 01:12   Re: [BUGS] Very slow query in PostgreSQL 9.3.3 Sergey Konoplev
• 05:19   Re: Very slow query in PostgreSQL 9.3.3 Ian Lawrence Barwick
• 14:30   Adding new field to big table acanada
• 19:49   Re: Adding new field to big table Jeff Janes
• 20:06   Re: Adding new field to big table acanada
• 22:29   Re: Adding new field to big table Jeff Janes

17 March 2014

• 12:39   Re: Adding new field to big table acanada

18 March 2014

• 09:04   Re: Adding new field to big table Jeff Janes

19 March 2014

• 00:20   Re: Help me understand why my subselect is an order of magnitude faster than my nested joins Vincent
• 00:26   question about partial index Yu Zhao
• 00:51   Re: question about partial index Szymon Guz
• 14:09   Re: Query taking long time acanada
• 20:11   slave wal is ahead of master Evgeniy Shishkin
• 21:12   Re: slave wal is ahead of master Sethu Prasad
• 23:01   Re: slave wal is ahead of master Evgeny Shishkin

20 March 2014

• 02:30   Re: Query taking long time Venkata Balaji Nagothi
• 13:17   Re: Query taking long time acanada
• 16:51   long lasting select, no io nor cpu usage ? Franck Routier
• 16:56   Re: long lasting select, no io nor cpu usage ? Tom Lane
• 17:07   Re: long lasting select, no io nor cpu usage ? Franck Routier
• 17:15   Re: long lasting select, no io nor cpu usage ? Tom Lane
• 19:27   Re: long lasting select, no io nor cpu usage ? Franck Routier
• 19:54   Getting query plan alternatives from query planner? Stefan Keller
• 19:57   Performance of UNION vs IN Jean-Max Reymond
• 20:08   Re: Getting query plan alternatives from query planner? Tom Lane
• 20:14   Re: Performance of UNION vs IN Torsten Förtsch

21 March 2014

• 02:56   slow join not using index properly Stefan Amshey
• 08:33   Re: Performance of UNION vs IN Jean-Max Reymond
• 09:02   Re: slow join not using index properly Ilya Kosmodemiansky
• 10:38   Re: Getting query plan alternatives from query planner? Stefan Keller
• 10:51   Re: Getting query plan alternatives from query planner? Atri Sharma
• 11:17   Re: slow join not using index properly Vincent
• 16:35   Re: Getting query plan alternatives from query planner? Craig James
• 17:07   Re: Getting query plan alternatives from query planner? Tom Lane
• 17:49   Connection pooling - Number of connections Guillaume Smet
• 18:49   Re: Connection pooling - Number of connections David Johnston
• 19:05   Re: Connection pooling - Number of connections Guillaume Smet
• 19:17   Re: Connection pooling - Number of connections Tom Lane
• 20:52   Re: Connection pooling - Number of connections Sethu Prasad
• 21:36   Re: Connection pooling - Number of connections Guillaume Smet
• 21:39   Re: Connection pooling - Number of connections Guillaume Smet
• 21:41   Re: Connection pooling - Number of connections David Johnston
• 22:04   Re: Connection pooling - Number of connections Claudio Freire
• 22:43   Re: Getting query plan alternatives from query planner? Shaun Thomas

22 March 2014

• 03:59   Suboptimal query plan when using expensive BCRYPT functions Erik van Zijst
• 23:51   Re: Suboptimal query plan when using expensive BCRYPT functions bricklen

23 March 2014

• 01:27   Re: Suboptimal query plan when using expensive BCRYPT functions Erik van Zijst
• 01:56   Re: Suboptimal query plan when using expensive BCRYPT functions bricklen
• 06:37   Re: Suboptimal query plan when using expensive BCRYPT functions Erik van Zijst
• 06:56   Re: Suboptimal query plan when using expensive BCRYPT functions bricklen
• 09:10   Re: Query taking long time Venkata Balaji Nagothi
• 09:40   Re: Suboptimal query plan when using expensive BCRYPT functions Tom Lane
• 21:30   Re: Suboptimal query plan when using expensive BCRYPT functions Erik van Zijst

24 March 2014

• 10:09   Re: Suboptimal query plan when using expensive BCRYPT functions Heikki Linnakangas
• 16:29   Connection pooling - Number of connections Brett Wooldridge
• 20:38   Re: Suboptimal query plan when using expensive BCRYPT functions Erik van Zijst
• 21:40   Re: slow join not using index properly Stefan Amshey
• 23:24   Re: Connection pooling - Number of connections Gavin Flower

25 March 2014

• 03:23   Re: Connection pooling - Number of connections Brett Wooldridge
• 04:42   Re: Connection pooling - Number of connections Gavin Flower
• 05:46   Re: Connection pooling - Number of connections Brett Wooldridge
• 07:45   pg_dump vs pg_basebackup gianfranco caca
• 10:05   Re: slow join not using index properly Ilya Kosmodemiansky
• 10:11   Re: pg_dump vs pg_basebackup Ilya Kosmodemiansky
• 10:19   Re: pg_dump vs pg_basebackup gianfranco caca
• 10:33   Re: pg_dump vs pg_basebackup Ilya Kosmodemiansky
• 10:39   Re: pg_dump vs pg_basebackup David Johnston
• 15:05   Re: pg_dump vs pg_basebackup Claudio Freire
• 15:47   Stalls on PGSemaphoreLock Matthew Spilich
• 17:56   Re: pg_dump vs pg_basebackup Joshua D. Drake
• 18:11   Re: pg_dump vs pg_basebackup desmodemone
• 18:18   Re: pg_dump vs pg_basebackup Ilya Kosmodemiansky
• 18:21   Re: pg_dump vs pg_basebackup Magnus Hagander
• 18:23   Re: pg_dump vs pg_basebackup Joshua D. Drake
• 18:29   Re: pg_dump vs pg_basebackup Ilya Kosmodemiansky
• 18:37   Re: pg_dump vs pg_basebackup Ilya Kosmodemiansky
• 18:41   Re: pg_dump vs pg_basebackup Magnus Hagander
• 18:43   Re: pg_dump vs pg_basebackup Ilya Kosmodemiansky
• 18:48   Re: pg_dump vs pg_basebackup Graeme B. Bell
• 18:55   Re: pg_dump vs pg_basebackup Joshua D. Drake
• 19:12   Re: pg_dump vs pg_basebackup Alan Hodgson
• 19:46   Re: pg_dump vs pg_basebackup Claudio Freire
• 20:14   Re: Stalls on PGSemaphoreLock Ray Stell
• 21:39   Re: Stalls on PGSemaphoreLock Matthew Spilich
• 23:35   Re: Stalls on PGSemaphoreLock Emre Hasegeli

26 March 2014

• 09:27   Re: Stalls on PGSemaphoreLock Takashi Horikawa
• 15:23   Why shared_buffers max is 8GB? Alexey Vasiliev
• 15:35   Re: Why shared_buffers max is 8GB? Ilya Kosmodemiansky
• 15:45   Re: Why shared_buffers max is 8GB? desmodemone
• 16:23   Re: Why shared_buffers max is 8GB? Albe Laurenz
• 16:24   Re: Why shared_buffers max is 8GB? Markella Skempri
• 16:30   Re: Why shared_buffers max is 8GB? Martin French
• 16:32   Re: Why shared_buffers max is 8GB? Martin French
• 16:48   Re: Why shared_buffers max is 8GB? Markella Skempri
• 17:04   Re: Why shared_buffers max is 8GB? Martin French
• 17:23   Re: Why shared_buffers max is 8GB? Scott Marlowe
• 17:24   Re: Why shared_buffers max is 8GB? desmodemone
• 19:14   Re: Why shared_buffers max is 8GB? Shaun Thomas
• 19:36   Re: Why shared_buffers max is 8GB? Ilya Kosmodemiansky

27 March 2014

• 03:35   Re: Connection pooling - Number of connections Josh Berkus
• 08:08   Re: Connection pooling - Number of connections Brett Wooldridge
• 08:08   semaphore waits and performance stall Matthew Spilich
• 08:08   RE : Stalls on PGSemaphoreLock Pavy Philippe
• 08:08   Re: Stalls on PGSemaphoreLock Pavy Philippe
• 10:39   Re: Stalls on PGSemaphoreLock Gudmundsson Martin (mg)
• 23:42   Partitions and prepared statements? Dave Johansen

30 March 2014

• 00:20   Re: Connection pooling - Number of connections Jeff Janes
• 06:41   Re: Connection pooling - Number of connections Brett Wooldridge
• 22:45   Slow Count-Distinct Query Christopher Jackson

31 March 2014

• 13:26   Sudden crazy high CPU usage Niels Kristian Schjødt
• 16:18   Re: Slow Count-Distinct Query Shaun Thomas
• 16:47   Re: Sudden crazy high CPU usage Merlin Moncure
• 17:15   Re: Slow Count-Distinct Query Tom Lane
• 17:24   Re: Sudden crazy high CPU usage Niels Kristian Schjødt
• 17:37   Re: Sudden crazy high CPU usage Merlin Moncure
• 17:50   Re: Sudden crazy high CPU usage Scott Marlowe
• 18:53   Re: Slow Count-Distinct Query Christopher Jackson
• 20:17   Re: Sudden crazy high CPU usage Niels Kristian Schjødt
• 20:21   Re: Sudden crazy high CPU usage Niels Kristian Schjødt
• 20:36   Re: Sudden crazy high CPU usage Sergey Konoplev
• 23:02   Re: Sudden crazy high CPU usage Will Platnick