Mailing lists [pgsql-performance]

1 September 2013

• 04:31   Re: Varchar vs foreign key vs enumerator - table and index size Craig James
• 06:10   Re: Varchar vs foreign key vs enumerator - table and index size Vitalii Tymchyshyn

2 September 2013

• 04:38   Re: How clustering for scale out works in PostgreSQL Scott Marlowe
• 10:09   Re: How clustering for scale out works in PostgreSQL Craig Ringer
• 10:46   Re: How clustering for scale out works in PostgreSQL Craig Ringer
• 12:47   Re: Varchar vs foreign key vs enumerator - table and index size Łukasz Walkowski
• 12:53   Re: Varchar vs foreign key vs enumerator - table and index size Łukasz Walkowski
• 20:03   Re: Varchar vs foreign key vs enumerator - table and index size Andrew Dunstan
• 22:57   planner parameters Torsten Förtsch

3 September 2013

• 10:25   Slow query-plan generation (fast query) PG 9.2 jesper@krogh.cc
• 10:47   Re: Slow query-plan generation (fast query) PG 9.2 Craig Ringer
• 19:21   COPY TO and VACUUM Roberto Grandi
• 22:01   Re: Varchar vs foreign key vs enumerator - table and index size Vitalii Tymchyshyn
• 22:02   Re: planner parameters Kevin Grittner
• 22:34   Re: Slow query-plan generation (fast query) PG 9.2 Jesper Krogh
• 23:34   Re: COPY TO and VACUUM Kevin Grittner

4 September 2013

• 00:47   Weird case of wrong index choice Claudio Freire
• 01:16   apply Milos Babic
• 02:11   Re: Weird case of wrong index choice Tom Lane
• 02:49   Re: Weird case of wrong index choice Claudio Freire
• 09:19   Re: COPY TO and VACUUM Roberto Grandi
• 09:49   Re: SQL statement over 500% slower with 9.2 compared with 9.1 Rafael Martinez
• 11:10   Re: COPY TO and VACUUM Kevin Grittner
• 12:01   AMD vs Intel Johan Loubser
• 13:41   Re: AMD vs Intel Albe Laurenz
• 16:15   Re: AMD vs Intel David Boreham
• 16:59   Re: Slow query-plan generation (fast query) PG 9.2 Merlin Moncure
• 18:23   higth performance write to disk Jeison Bedoya Delgado
• 18:28   Re: higth performance write to disk Merlin Moncure
• 19:29   Re: COPY TO and VACUUM Jeff Janes
• 21:52   Re: higth performance write to disk Jeison Bedoya Delgado
• 22:19   Re: higth performance write to disk Tomas Vondra
• 22:39   Re: higth performance write to disk Merlin Moncure

5 September 2013

• 08:13   Can you please suggest me some links where I can learn: M Tarkeshwar Rao
• 19:10   Re: COPY TO and VACUUM Roberto Grandi
• 19:24   Re: COPY TO and VACUUM David Kerr
• 21:14   Re: COPY TO and VACUUM Jeff Janes

6 September 2013

• 01:42   Re: [GENERAL] Can you please suggest me some links where I can learn: Merlin Moncure
• 01:45   View with and without ::text casting performs differently. Brian Fehrle
• 01:47   Re: View with and without ::text casting performs differently. Brian Fehrle
• 02:50   Re: View with and without ::text casting performs differently. Tom Lane
• 11:05   planner and having clausule Ľubomír Varga
• 11:44   Re: planner and having clausule Ľubomír Varga
• 18:57   RESTORE multiple DBs concurrently Roberto Grandi
• 19:42   Re: View with and without ::text casting performs differently. Brian Fehrle
• 21:35   Re: View with and without ::text casting performs differently. Tom Lane
• 22:46   Re: View with and without ::text casting performs differently. Mark Mayo
• 22:49   Re: View with and without ::text casting performs differently. Mark Mayo

7 September 2013

• 12:46   Re: RESTORE multiple DBs concurrently Michael Paquier

10 September 2013

• 03:39   Re: Performance bug in prepared statement binding in 9.2? Andrew Dunstan
• 04:04   Re: Performance bug in prepared statement binding in 9.2? Bruce Momjian
• 04:36   Re: Performance bug in prepared statement binding in 9.2? Mel Llaguno
• 04:45   Re: Performance bug in prepared statement binding in 9.2? Bruce Momjian
• 05:06   Re: Performance bug in prepared statement binding in 9.2? Mel Llaguno
• 05:16   Re: Performance bug in prepared statement binding in 9.2? Bruce Momjian
• 08:43   Re: Performance bug in prepared statement binding in 9.2? Mel Llaguno
• 14:50   Re: Performance bug in prepared statement binding in 9.2? Bruce Momjian
• 15:32   Re: Performance bug in prepared statement binding in 9.2? Andres Freund
• 15:34   Re: Performance bug in prepared statement binding in 9.2? Andres Freund
• 15:46   Re: Performance bug in prepared statement binding in 9.2? Andrew Dunstan
• 16:22   Re: Performance bug in prepared statement binding in 9.2? Andres Freund
• 16:33   Re: Performance bug in prepared statement binding in 9.2? Andres Freund
• 16:42   Re: Performance bug in prepared statement binding in 9.2? Andrew Dunstan
• 18:05   Intermittent hangs with 9.2 David Whittaker
• 18:27   Re: Intermittent hangs with 9.2 Andrew Dunstan
• 18:32   Re: Intermittent hangs with 9.2 ktm@rice.edu
• 20:44   Re: Intermittent hangs with 9.2 Jeff Janes
• 21:05   Intermittent hangs with 9.2 David Whittaker
• 21:06   Intermittent hangs with 9.2 David Whittaker
• 21:07   Intermittent hangs with 9.2 David Whittaker

11 September 2013

• 10:27   Re: Intermittent hangs with 9.2 Torsten Förtsch
• 11:36   Re: Intermittent hangs with 9.2 Julien Cigar
• 13:37   slow sort Maximilian Tyrtania
• 14:16   Reasons for choosing one execution plan over another? Mikkel Lauritsen
• 15:43   Re: Intermittent hangs with 9.2 Merlin Moncure
• 16:58   Re: slow sort bricklen
• 18:24   Re: slow sort Maximilian Tyrtania
• 18:32   Re: slow sort Andrew Dunstan
• 19:20   Re: Reasons for choosing one execution plan over another? Jeff Janes
• 19:53   Re: Reasons for choosing one execution plan over another? Giuseppe Broccolo
• 20:17   Re: Intermittent hangs with 9.2 Andres Freund
• 21:26   Re: Intermittent hangs with 9.2 Merlin Moncure
• 21:35   Re: Performance bug in prepared statement binding in 9.2? Josh Berkus
• 22:06   Re: Performance bug in prepared statement binding in 9.2? Andrew Dunstan
• 22:23   Re: Reasons for choosing one execution plan overanother? Mikkel Lauritsen

12 September 2013

• 00:09   Re: Reasons for choosing one execution plan over another? Gavin Flower
• 00:10   Re: Performance bug in prepared statement binding in 9.2? Andres Freund
• 00:13   Re: Performance bug in prepared statement binding in 9.2? Andres Freund
• 05:03   Re: Performance bug in prepared statement binding in 9.2? Josh Berkus
• 09:19   Re: COPY TO and VACUUM Roberto Grandi
• 11:00   Re: slow sort Maximilian Tyrtania
• 13:14   Memory-olic query and Materialize Souquieres Adam
• 16:29   Re: Reasons for choosing one execution plan overanother? Mikkel Lauritsen
• 19:35   Re: How clustering for scale out works in PostgreSQL Jim Nasby
• 19:35   Re: Optimising views Jim Nasby
• 19:36   Re: Varchar vs foreign key vs enumerator - table and index size Jim Nasby
• 21:46   Re: How clustering for scale out works in PostgreSQL Kevin Grittner
• 23:07   Re: Intermittent hangs with 9.2 David Whittaker

13 September 2013

• 17:52   Re: Intermittent hangs with 9.2 Merlin Moncure
• 18:06   Re: Intermittent hangs with 9.2 David Whittaker

14 September 2013

• 21:28   Extremely slow server? Craig James
• 21:36   Re: Extremely slow server? bricklen

15 September 2013

• 04:54   Re: Extremely slow server? Craig James
• 05:06   Re: Extremely slow server? bricklen
• 10:50   Re: Extremely slow server? Vitalii Tymchyshyn
• 23:55   Re: Extremely slow server? Jeff Janes

16 September 2013

• 03:18   Re: COPY TO and VACUUM Jeff Janes
• 18:19   Re: COPY TO and VACUUM Roberto Grandi
• 18:53   How to optimization database for heavy I/O from updates (software and hardware) Niels Kristian Schjødt
• 22:22   Re: stable and immutable functions in GROUP BY clauses. Marc Mamin

17 September 2013

• 02:40   Re: function execute on v.9.2 slow down Robert Haas
• 14:55   Re: Cpu usage 100% on slave. s_lock problem. Дмитрий Дегтярёв
• 14:59   Re: Cpu usage 100% on slave. s_lock problem. Andres Freund
• 16:19   Re: Cpu usage 100% on slave. s_lock problem. Merlin Moncure
• 16:24   Re: Cpu usage 100% on slave. s_lock problem. Andres Freund
• 16:32   Re: Cpu usage 100% on slave. s_lock problem. Merlin Moncure
• 16:35   Re: Cpu usage 100% on slave. s_lock problem. Andres Freund
• 16:40   Re: Cpu usage 100% on slave. s_lock problem. Merlin Moncure
• 16:43   Re: Cpu usage 100% on slave. s_lock problem. Andres Freund

18 September 2013

• 01:17   Re: Planner performance extremely affected by an hanging transaction (20-30 times)? Bartłomiej Romański
• 14:25   Re: function execute on v.9.2 slow down Александр Белинский
• 18:42   autovacuum and dead tuples 
• 19:27   Re: autovacuum and dead tuples Shaun Thomas
• 21:50   Re: View with and without ::text casting performs differently. Brian Fehrle

19 September 2013

• 23:47   Why is n_distinct always -1 for range types? Josh Berkus

20 September 2013

• 03:49   Planner performance extremely affected by an hanging transaction (20-30 times)? Bartłomiej Romański
• 04:43   Re: Planner performance extremely affected by an hanging transaction (20-30 times)? Julian
• 05:03   Re: Planner performance extremely affected by an hanging transaction (20-30 times)? Bartłomiej Romański
• 21:12   Re: Intermittent hangs with 9.2 David Whittaker

21 September 2013

• 01:01   Re: Planner performance extremely affected by an hanging transaction (20-30 times)? Jeff Janes
• 08:08   Re: Planner performance extremely affected by an hanging transaction (20-30 times)? Jesper Krogh

23 September 2013

• 17:00   Re: Planner performance extremely affected by an hanging transaction (20-30 times)? Kevin Grittner

24 September 2013

• 12:24   Slow plan for MAX/MIN or LIMIT 1? Sam Wong
• 13:35   Re: Planner performance extremely affected by an hanging transaction (20-30 times)? Tom Lane
• 17:38   Re: Planner performance extremely affected by an hanging transaction (20-30 times)? jesper@krogh.cc
• 20:43   Re: Planner performance extremely affected by an hanging transaction (20-30 times)? Josh Berkus
• 21:03   Re: Planner performance extremely affected by an hanging transaction (20-30 times)? didier
• 21:53   Bringing up new slaves faster François Deliège

25 September 2013

• 00:49   Re: Slow plan for MAX/MIN or LIMIT 1? Merlin Moncure
• 00:56   Re: Slow plan for MAX/MIN or LIMIT 1? Claudio Freire
• 02:30   Re: Planner performance extremely affected by an hanging transaction (20-30 times)? Jeff Janes
• 02:44   Re: Planner performance extremely affected by an hanging transaction (20-30 times)? Bartłomiej Romański
• 07:49   Re: Planner performance extremely affected by an hanging transaction (20-30 times)? didier
• 09:38   Re: Performance bug in prepared statement binding in 9.2? Jeff Janes
• 09:48   Re: Planner performance extremely affected by an hanging transaction (20-30 times)? Jeff Janes
• 10:06   Re: Planner performance extremely affected by an hanging transaction (20-30 times)? Jeff Janes
• 15:23   Re: Slow plan for MAX/MIN or LIMIT 1? Sam Wong
• 16:29   Re: Slow plan for MAX/MIN or LIMIT 1? Merlin Moncure
• 18:05   earthdistance query performance AI Rumman
• 18:20   Re: Slow plan for MAX/MIN or LIMIT 1? Claudio Freire
• 18:54   Re: Slow plan for MAX/MIN or LIMIT 1? Merlin Moncure
• 18:58   Troubleshooting query performance issues Jim Garrison
• 19:25   Re: earthdistance query performance Merlin Moncure
• 19:30   Re: Troubleshooting query performance issues bricklen
• 19:34   Re: Slow plan for MAX/MIN or LIMIT 1? Sam Wong
• 19:42   Re: Slow plan for MAX/MIN or LIMIT 1? Sam Wong
• 20:05   Re: Slow plan for MAX/MIN or LIMIT 1? Claudio Freire
• 20:29   Re: Why is n_distinct always -1 for range types? Josh Berkus
• 20:36   Re: Planner performance extremely affected by an hanging transaction (20-30 times)? Josh Berkus
• 20:53   Re: Planner performance extremely affected by an hanging transaction (20-30 times)? Andres Freund
• 20:53   Re: Why is n_distinct always -1 for range types? Peter Geoghegan
• 21:17   Re: Planner performance extremely affected by an hanging transaction (20-30 times)? Jeff Janes
• 21:43   Re: Planner performance extremely affected by an hanging transaction (20-30 times)? Andres Freund

27 September 2013

• 02:08   Re: Cpu usage 100% on slave. s_lock problem. Andres Freund
• 06:14   Re: Cpu usage 100% on slave. s_lock problem. Merlin Moncure
• 15:56   Re: Cpu usage 100% on slave. s_lock problem. Merlin Moncure
• 19:04   Re: Troubleshooting query performance issues - Resolved (sort of) Jim Garrison
• 22:57   Re: Troubleshooting query performance issues - resolved (sort of) Jim Garrison
• 23:57   Re: Planner performance extremely affected by an hanging transaction (20-30 times)? Josh Berkus

28 September 2013

• 00:14   Re: Planner performance extremely affected by an hanging transaction (20-30 times)? Andres Freund

29 September 2013

• 12:09   BASH script for collecting analyze-related info Ken Tanzer
• 19:57   Re: BASH script for collecting analyze-related info Craig James

30 September 2013

• 00:25   Re: BASH script for collecting analyze-related info Ken Tanzer
• 02:59   Re: BASH script for collecting analyze-related info Craig James
• 09:11   Re: Slow plan for MAX/MIN or LIMIT 1? didier
• 10:05   Re: BASH script for collecting analyze-related info hubert depesz lubaczewski
• 15:45   pg_statio_all_tables columns Xenofon Papadopoulos
• 17:38   Re: pg_statio_all_tables columns Giuseppe Broccolo
• 17:41   Re: pg_statio_all_tables columns Xenofon Papadopoulos
• 19:28   Re: pg_statio_all_tables columns Giuseppe Broccolo
• 20:44   Re: pg_statio_all_tables columns Jeff Janes
• 20:50   Re: pg_statio_all_tables columns Xenofon Papadopoulos