Mailing lists [pgsql-performance]

1 October 2009

• 04:20   long running insert statement Gerd König
• 05:12   Confusion on shared buffer S Arvind
• 06:47   Best suiting OS S Arvind
• 06:47   Re: CPU cost of operators Matthew Wakeling
• 07:00   Re: Best suiting OS Matthew Wakeling
• 07:04   Re: Best suiting OS Jean-David Beyer
• 07:10   Re: Speed while runnning large transactions. Greg Smith
• 07:11   Re: Best suiting OS S Arvind
• 07:14   Re: Best suiting OS Jean-David Beyer
• 07:15   Re: long running insert statement Matthew Wakeling
• 07:33   Re: Best suiting OS S Arvind
• 07:37   Re: Best suiting OS Claus Guttesen
• 10:25   Re: Database performance post-VACUUM FULL Kevin Grittner
• 11:53   Re: long running insert statement Tom Lane
• 12:05   Re: Best suiting OS Haszlakiewicz, Eric
• 12:06   Re: Speed while runnning large transactions. Tom Lane
• 12:12   Re: Best suiting OS Tom Lane
• 14:16   AMD, Intel and RAID controllers Benjamin Minshall
• 14:46   Re: Best suiting OS S Arvind
• 15:03   Re: Best suiting OS Greg Smith
• 15:16   Re: Best suiting OS Greg Smith
• 16:01   Re: AMD, Intel and RAID controllers Greg Smith
• 16:33   Re: Best suiting OS david@lang.hm
• 16:46   Re: Best suiting OS Scott Marlowe

2 October 2009

• 02:44   Re: long running insert statement Gerd König
• 03:48   Re: AMD, Intel and RAID controllers alpesh gajbe
• 05:22   Re: Best suiting OS Scara Maccai
• 05:48   updating a row in a table with only one row Michal Vitecek
• 06:14   Re: updating a row in a table with only one row A. Kretschmer
• 06:28   Re: Best suiting OS Scara Maccai
• 06:32   Re: updating a row in a table with only one row Hélder M. Vieira
• 08:39   Re: Best suiting OS Matthew Wakeling
• 09:31   Re: Best suiting OS Devrim GÜNDÜZ
• 09:50   Re: AMD, Intel and RAID controllers Scott Marlowe
• 10:54   Re: updating a row in a table with only one row Merlin Moncure
• 11:06   Re: Best suiting OS Tom Lane
• 11:23   Re: Best suiting OS Joe Uhl
• 11:23   Re: Best suiting OS Matthew Wakeling
• 12:41   Re: Best suiting OS Mark Mielke
• 12:44   Re: Best suiting OS - now off topic Aidan Van Dyk
• 14:15   Re: Best suiting OS Jon Nelson
• 14:18   Re: Best suiting OS Greg Smith
• 14:20   Re: Best suiting OS Merlin Moncure
• 14:35   Re: Best suiting OS Greg Smith
• 14:39   Re: updating a row in a table with only one row Robert Haas
• 14:43   Re: Best suiting OS Greg Smith
• 15:18   Re: updating a row in a table with only one row Merlin Moncure
• 15:39   Re: updating a row in a table with only one row Heikki Linnakangas
• 16:00   Re: Best suiting OS Kevin Grittner
• 16:15   Re: Best suiting OS Mark Mielke
• 16:19   Re: Confusion on shared buffer Robert Haas
• 17:30   Re: Speed while runnning large transactions. Kevin Grittner
• 18:38   Re: Best suiting OS Tom Lane
• 18:58   Re: Best suiting OS Dimitri Fontaine
• 19:01   Re: Speed while runnning large transactions. Tom Lane
• 22:48   dump time increase by 1h with new kernel Justin Pryzby
• 23:35   Re: dump time increase by 1h with new kernel Tom Lane

3 October 2009

• 03:12   Re: Confusion on shared buffer S Arvind
• 22:02   Re: Confusion on shared buffer Robert Haas
• 23:02   Postgres performance std pik
• 23:04   Re: Use of sequence rather than index scan for one text column on one instance of a database Bill Kirtley
• 23:04   Performance problems with DISTINCT ON Sgarbossa Domenico
• 23:05   Re: PG 8.3 and large shared buffer settings Hannu Krosing
• 23:05   Performance RAID 0 mange
• 23:07   Re: Best suiting OS Denis Lussier
• 23:08   Re: AMD, Intel and RAID controllers Alpesh Gajbe
• 23:10   Re: Best suiting OS Jon Nelson
• 23:11   dump time increase by 1h with new kernel Justin Pryzby
• 23:37   Re: Performance problems with DISTINCT ON imad
• 23:42   Re: Best suiting OS Karl Denninger
• 23:53   Re: Performance problems with DISTINCT ON Tom Lane

4 October 2009

• 02:31   Re: dump time increase by 1h with new kernel Scott Marlowe
• 08:08   Re: Postgres performance Gerd Koenig
• 10:29   Re: Confusion on shared buffer Gurjeet Singh
• 11:04   Re: Best suiting OS Mark Mielke
• 14:57   Re: Best suiting OS Devrim GÜNDÜZ
• 16:31   Re: Confusion on shared buffer Robert Haas
• 16:51   Re: Best suiting OS Mark Mielke
• 17:57   Re: Best suiting OS Gerhard Wiesinger
• 19:23   Re: Best suiting OS david@lang.hm
• 19:53   Speed / Server anthony@resolution.com
• 21:20   Re: Speed / Server Scott Marlowe
• 21:43   Re: Best suiting OS Scott Marlowe
• 22:59   Re: Bad performance of SELECT ... where id IN (...) Omar Kilani
• 23:21   Maybe OT, not sure Re: Best suiting OS Mark Mielke

5 October 2009

• 04:14   Re: Best suiting OS Craig James
• 06:17   Re: updating a row in a table with only one row Michal Vitecek
• 06:53   Re: Best suiting OS Devrim GÜNDÜZ
• 07:07   Re: Best suiting OS Jean-Michel Pouré
• 07:20   Re: Best suiting OS Devrim GÜNDÜZ
• 07:47   Re: Best suiting OS Devrim GÜNDÜZ
• 08:50   Re: updating a row in a table with only one row Merlin Moncure
• 09:01   Re: Bad performance of SELECT ... where id IN (...) Robert Haas
• 09:24   Re: Bad performance of SELECT ... where id IN (...) Omar Kilani
• 09:30   Re: Best suiting OS Adam Tauno Williams
• 09:30   Re: Bad performance of SELECT ... where id IN (...) Grzegorz Jaśkiewicz
• 09:37   Re: Maybe OT, not sure Re: Best suiting OS Adam Tauno Williams
• 10:25   Re: Best suiting OS Robert Haas
• 10:31   Re: Speed / Server Nikolas Everett
• 10:37   Re: Best suiting OS Jean-David Beyer
• 10:40   Re: Best suiting OS Adam Tauno Williams
• 10:46   Re: [OT] Best suiting OS Csaba Nagy
• 10:52   Query plan for NOT IN Matthew Wakeling
• 10:56   Re: Query plan for NOT IN Grzegorz Jaśkiewicz
• 11:00   Re: Query plan for NOT IN Matthew Wakeling
• 11:06   Re: Query plan for NOT IN Grzegorz Jaśkiewicz
• 11:30   Re: Query plan for NOT IN Tom Lane
• 11:55   Re: Best suiting OS Stefan Kaltenbrunner
• 11:59   Re: Best suiting OS Stefan Kaltenbrunner
• 12:55   Re: Performance RAID 0 Fernando Hevia
• 13:31   Re: Best suiting OS Scott Carey
• 14:27   Re: Best suiting OS Karl Denninger
• 14:29   Re: Best suiting OS Claus Guttesen
• 14:38   Re: Best suiting OS Scott Carey
• 14:43   Re: Best suiting OS Karl Denninger
• 15:06   Re: Best suiting OS Karl Denninger
• 15:14   Re: Best suiting OS Axel Rau
• 15:16   Re: Best suiting OS Karl Denninger
• 15:20   Re: Best suiting OS Greg Smith
• 15:55   Re: Best suiting OS Scott Carey
• 15:59   Re: Speed while runnning large transactions. Greg Smith
• 16:11   Distributed/Parallel Computing Viji V Nair
• 16:35   Re: Query plan for NOT IN Guy Rouillier
• 16:40   Re: Best suiting OS Karl Denninger
• 17:26   Re: Best suiting OS Kevin Grittner
• 17:27   Re: Best suiting OS Axel Rau
• 17:52   Re: Best suiting OS Claus Guttesen
• 18:32   Re: Speed / Server Scott Marlowe
• 18:44   Re: Best suiting OS Karl Denninger
• 19:06   Re: Maybe OT, not sure Re: Best suiting OS Scott Marlowe
• 23:41   Re: Distributed/Parallel Computing Jeff Janes

6 October 2009

• 03:51   Re: Distributed/Parallel Computing Viji V Nair
• 04:28   What is the role of #fsync and #synchronous_commit in configuration file . keshav upadhyaya
• 07:27   Re: Best suiting OS Axel Rau
• 09:49   Re: What is the role of #fsync and #synchronous_commit in configuration file . Dave Dutcher
• 10:16   Dumping + restoring a subset of a table? Shaul Dar
• 10:21   Re: Speed / Server Nikolas Everett
• 10:33   Re: Dumping + restoring a subset of a table? Joshua Tolley
• 10:39   Re: Best suiting OS Karl Denninger
• 11:26   Re: Speed / Server Scott Marlowe
• 11:59   Re: updating a row in a table with only one row Michal Vitecek
• 12:25   Re: updating a row in a table with only one row Merlin Moncure
• 13:06   Re: updating a row in a table with only one row Craig James
• 15:16   Re: Best suiting OS david@lang.hm
• 16:29   Re: Speed / Server Scott Marlowe
• 16:59   Re: Speed / Server Karl Denninger
• 17:20   Re: Best suiting OS Scott Mead
• 17:35   Re: Speed / Server Scott Marlowe
• 18:16   Re: Speed / Server Merlin Moncure
• 19:40   Re: Speed / Server Anthony Presley
• 21:48   Re: Speed / Server Greg Smith

7 October 2009

• 05:47   Re: Speed / Server 
• 10:27   Re: Query plan for NOT IN Grzegorz Jaśkiewicz
• 11:40   Re: Query plan for NOT IN Kevin Grittner
• 14:33   Re: Query plan for NOT IN Guy Rouillier
• 15:17   Re: Query plan for NOT IN Kevin Grittner
• 17:28   Re: Query plan for NOT IN Craig James
• 19:48   Re: Query plan for NOT IN Guy Rouillier

8 October 2009

• 02:15   Re: dump time increase by 1h with new kernel Greg Smith
• 03:39   Regarding mulitple rows insert in one shot using ADO .net connected to postgres keshav upadhyaya
• 06:19   Query logging time, not values Ludwik Dylag
• 11:26   Re: Best suiting OS Matthew Wakeling
• 11:28   position in DDL of columns used in indexes Michael Gould
• 11:37   Re: position in DDL of columns used in indexes Matthew Wakeling
• 12:09   Re: position in DDL of columns used in indexes Tom Lane
• 12:33   Partitioned Tables and ORDER BY Joe Uhl
• 14:27   concurrent reindex issues Tory M Blue
• 14:44   Re: dump time increase by 1h with new kernel Justin T Pryzby
• 14:49   Re: dump time increase by 1h with new kernel Joshua D. Drake
• 14:55   Re: concurrent reindex issues Tom Lane
• 17:05   Re: concurrent reindex issues Scott Marlowe
• 17:16   Re: dump time increase by 1h with new kernel Justin T Pryzby
• 17:30   Explain Analyze returns faster than psql or JDBC calls. G B
• 17:37   Re: dump time increase by 1h with new kernel Kevin Grittner
• 18:15   Re: dump time increase by 1h with new kernel Justin T Pryzby
• 18:19   Re: Explain Analyze returns faster than psql or JDBC calls. Tom Lane
• 21:49   Re: dump time increase by 1h with new kernel Joshua D. Drake

9 October 2009

• 04:11   Re: High CPU load on Postgres Server during Peak times!!!! Shiva Raman
• 08:57   Re: Explain Analyze returns faster than psql or JDBC calls. Dave Cramer
• 09:32   Re: Bad performance of SELECT ... where id IN (...) Xia Qingran
• 10:09   Re: Bad performance of SELECT ... where id IN (...) Kenneth Marshall
• 10:27   Re: High CPU load on Postgres Server during Peak times!!!! Merlin Moncure
• 13:45   disk I/O problems and Solutions Alan McKay
• 13:56   UUID as primary key tsuraan
• 14:58   Re: concurrent reindex issues Tory M Blue
• 14:59   Databases vs Schemas Scott Otis
• 15:12   Re: Databases vs Schemas Ben Chobot
• 15:30   Re: UUID as primary key Mark Mielke
• 16:04   Re: disk I/O problems and Solutions Flavio Henrique Araque Gurgel
• 16:23   Re: disk I/O problems and Solutions Scott Marlowe
• 18:02   Re: Databases vs Schemas Merlin Moncure
• 20:09   Re: disk I/O problems and Solutions David Rees
• 23:46   Re: disk I/O problems and Solutions Scott Carey
• 23:51   Re: Databases vs Schemas Scott Carey

10 October 2009

• 00:11   Re: Databases vs Schemas Tom Lane
• 02:14   Re: UUID as primary key tsuraan
• 10:26   Re: Databases vs Schemas Merlin Moncure
• 12:17   Re: Databases vs Schemas Chris Kratz
• 12:40   Re: UUID as primary key Mark Mielke
• 18:10   table partitioning & max_locks_per_transaction Brian Karlak
• 18:34   Re: Databases vs Schemas Scott Marlowe
• 23:57   Re: table partitioning & max_locks_per_transaction Tom Lane

11 October 2009

• 12:33   vacuumdb command soorjith p
• 12:59   Re: vacuumdb command Heikki Linnakangas
• 13:44   Re: table partitioning & max_locks_per_transaction Brian Karlak

12 October 2009

• 05:47   Using unnest function on multi-dimensional array. Nimesh Satam
• 05:57   Re: Using unnest function on multi-dimensional array. Pavel Stehule
• 06:23   Re: updating a row in a table with only one row Michal Vitecek
• 08:21   Query performance S Arvind
• 09:30   Re: Query performance Grzegorz Jaśkiewicz
• 09:40   Re: Query performance S Arvind
• 10:02   Re: Query performance Matthew Wakeling
• 10:24   Re: Query performance S Arvind
• 10:30   Re: Query performance Grzegorz Jaśkiewicz
• 10:37   Re: Query performance Matthew Wakeling
• 10:40   Re: Query performance Grzegorz Jaśkiewicz
• 11:18   Re: Best suiting OS Cédric Villemain
• 11:25   Re: updating a row in a table with only one row Merlin Moncure
• 11:46   Re: Query performance S Arvind
• 11:53   Re: Query performance S Arvind
• 12:11   Re: Query performance Grzegorz Jaśkiewicz
• 12:31   Re: Best suiting OS Dimitri Fontaine
• 16:06   Are folks running 8.4 in production environments? and 8.4 and slon 1.2? Tory M Blue

13 October 2009

• 04:03   Re: Are folks running 8.4 in production environments? and 8.4 and slon 1.2? Scott Marlowe
• 06:04   index on two tables or Howto speedup max/aggregate-function Michael Schwipps
• 06:19   Re: index on two tables or Howto speedup max/aggregate-function Jacques Caron
• 06:21   Re: index on two tables or Howto speedup max/aggregate-function Grzegorz Jaśkiewicz
• 09:54   Re: Are folks running 8.4 in production environments? and 8.4 and slon 1.2? Kenneth Marshall
• 12:17   Getting a random row Shaul Dar
• 12:19   Re: Getting a random row Grzegorz Jaśkiewicz
• 12:30   Re: Getting a random row Thomas Kellerer
• 12:31   Re: Getting a random row Shaul Dar
• 12:34   Re: Getting a random row Michael Glaesemann
• 12:39   Re: Getting a random row Grzegorz Jaśkiewicz
• 12:42   Re: Getting a random row Shaul Dar
• 13:56   Re: Getting a random row Robert Haas
• 21:21   Re: Getting a random row bricklen
• 22:18   Re: Getting a random row Scott Marlowe

14 October 2009

• 03:59   Re: Getting a random row Thom Brown
• 04:20   Re: Getting a random row Pavel Stehule
• 04:31   Re: Getting a random row Scott Marlowe
• 12:03   Re: Getting a random row Віталій Тимчишин
• 23:31   sequential scan on child partition tables Anj Adu

15 October 2009

• 02:16   Re: sequential scan on child partition tables Tom Lane
• 06:35   [OT] Recommended whitebox server vendors in the UK? Glyn Astill
• 11:03   Regarding facing lot of time Consumed by Socket.Poll() keshav upadhyaya
• 17:51   Re: sequential scan on child partition tables Anj Adu

16 October 2009

• 00:49   There is a statistic table? waldomiro
• 01:28   Re: There is a statistic table? Scott Marlowe
• 03:28   Re: There is a statistic table? Albe Laurenz
• 16:45   Re: UUID as primary key decibel
• 19:02   Re: UUID as primary key Alvaro Herrera
• 20:43   Indexes on low cardinality columns Vikul Khosla
• 22:27   Re: Indexes on low cardinality columns Greg Stark

17 October 2009

• 00:50   Re: UUID as primary key decibel
• 14:03   Re: Indexes on low cardinality columns Vikul Khosla
• 14:34   Re: Indexes on low cardinality columns Robert Haas
• 18:24   Re: Indexes on low cardinality columns Jeff Janes
• 20:40   Calculation of unused columns Volker Grabsch
• 21:09   Re: Calculation of unused columns Tom Lane
• 22:41   Re: Calculation of unused columns Tom Lane
• 23:12   Re: Calculation of unused columns Robert Haas

18 October 2009

• 00:38   table full scan or index full scan? 旭斌 裴
• 00:38   Re: Partitioned Tables and ORDER BY Michal Szymanski
• 00:38   Domain vs table Michal Szymanski
• 00:39   Re: Domain vs table Michal Szymanski
• 00:39   Re: Partitioned Tables and ORDER BY Michal Szymanski
• 00:39   Performance with sorting and LIMIT on partitioned table Michal Szymanski
• 00:39   Issues with \copy from file Sigurgeir Gunnarsson
• 00:39   sequential scan on child partition tables Anj Adu
• 00:39   Re: Are folks running 8.4 in production environments? and 8.4 and slon 1.2? Torsten Zühlsdorff
• 00:39   Re: Indexes on low cardinality columns Vikul Khosla
• 00:39   Improving join performance over multiple moderately wide tables miller_2555
• 00:46   Re: Calculation of unused columns Tom Lane
• 01:02   Re: Are folks running 8.4 in production environments? and 8.4 and slon 1.2? Karl Denninger
• 01:08   Re: Are folks running 8.4 in production environments? and 8.4 and slon 1.2? Tory M Blue
• 01:14   Re: Are folks running 8.4 in production environments? and 8.4 and slon 1.2? Karl Denninger
• 02:01   Re: table full scan or index full scan? Euler Taveira de Oliveira
• 02:05   Re: Are folks running 8.4 in production environments? and 8.4 and slon 1.2? Scott Marlowe
• 02:07   Re: table full scan or index full scan? Melton Low
• 02:09   Re: sequential scan on child partition tables Scott Marlowe
• 02:34   Re: Issues with \copy from file Euler Taveira de Oliveira
• 03:10   Re: Issues with \copy from file Scott Marlowe
• 09:30   Re: Partitioned Tables and ORDER BY Joe Uhl
• 12:17   Re: Calculation of unused columns Daniel Migowski
• 12:24   Re: sequential scan on child partition tables Anj Adu
• 13:00   Re: Calculation of unused columns Tom Lane
• 13:50   Full text search - query plan? PG 8.4.1 Jesper Krogh
• 14:36   Re: Calculation of unused columns Tim Landscheidt
• 14:59   Re: Calculation of unused columns Jeff Janes
• 15:20   Re: Full text search - query plan? PG 8.4.1 Tom Lane
• 15:56   Re: Full text search - query plan? PG 8.4.1 Jesper Krogh
• 16:48   Re: Full text search - query plan? PG 8.4.1 Tom Lane
• 17:00   Re: Calculation of unused columns Robert Haas
• 17:54   Re: Calculation of unused columns Tom Lane
• 19:54   Re: Calculation of unused columns Robert Haas
• 20:41   Re: Calculation of unused columns Tom Lane
• 21:49   Re: Improving join performance over multiple moderately wide tables Robert Haas
• 21:52   Re: Performance with sorting and LIMIT on partitioned table Robert Haas

19 October 2009

• 05:24   Re: Partitioned Tables and ORDER BY Grzegorz Jaśkiewicz
• 06:36   Re: Issues with \copy from file Matthew Wakeling
• 07:58   Re: Performance with sorting and LIMIT on partitioned table Joe Uhl
• 10:43   Known Bottlenecks Vikul Khosla
• 10:47   Re: Known Bottlenecks Grzegorz Jaśkiewicz
• 10:59   Re: Indexes on low cardinality columns Ron Mayer
• 13:01   Re: Calculation of unused columns Tom Lane
• 13:08   Re: Partitioned Tables and ORDER BY Robert Haas
• 13:13   Re: Partitioned Tables and ORDER BY Grzegorz Jaśkiewicz
• 14:36   Re: Calculation of unused columns Simon Riggs
• 14:43   Re: Calculation of unused columns Tom Lane
• 14:46   Re: Partitioned Tables and ORDER BY Craig James
• 14:48   Re: Calculation of unused columns Kevin Grittner
• 14:49   Re: Calculation of unused columns Simon Riggs
• 14:56   Re: Calculation of unused columns Gerhard Wiesinger
• 14:58   Re: Calculation of unused columns Tom Lane
• 15:05   Re: Calculation of unused columns Tom Lane
• 15:09   Re: Calculation of unused columns Simon Riggs
• 15:24   Re: Calculation of unused columns Tom Lane
• 16:11   Re: Partitioned Tables and ORDER BY Robert Haas
• 16:32   maintain_cluster_order_v5.patch phb07@apra.asso.fr
• 19:06   Re: maintain_cluster_order_v5.patch Jeff Davis
• 23:50   Re: Performance with sorting and LIMIT on partitioned table Merlin Moncure

20 October 2009

• 07:31   Re: Performance with sorting and LIMIT on partitioned table Joe Uhl
• 08:55   Re: Domain vs table Merlin Moncure
• 09:37   Finding rows in table T1 that DO NOT MATCH any row in table T2 Shaul Dar
• 09:46   Re: Finding rows in table T1 that DO NOT MATCH any row in table T2 Shaul Dar
• 09:54   Re: Finding rows in table T1 that DO NOT MATCH any row in table T2 A. Kretschmer
• 10:59   Re: Finding rows in table T1 that DO NOT MATCH any row in table T2 Tom Lane
• 13:14   Re: Finding rows in table T1 that DO NOT MATCH any row in table T2 Melton Low

21 October 2009

• 08:52   Re: Finding rows in table T1 that DO NOT MATCH any row in table T2 Shaul Dar
• 12:03   Random penalties on GIN index updates? jesper@krogh.cc
• 12:14   Re: Random penalties on GIN index updates? Tom Lane
• 14:18   Re: There is a statistic table? Scott Carey
• 14:55   Re: maintain_cluster_order_v5.patch phb07@apra.asso.fr
• 14:58   Re: Random penalties on GIN index updates? Jesper Krogh
• 15:11   Re: Finding rows in table T1 that DO NOT MATCH any row in table T2 Scott Carey
• 15:28   Are unreferenced TOASTed values retrieved? William Blunn
• 15:35   Re: Random penalties on GIN index updates? Tom Lane
• 16:12   Re: Are unreferenced TOASTed values retrieved? Tom Lane
• 19:06   Re: There is a statistic table? Scott Marlowe
• 19:51   optimizing query with multiple aggregates Doug Cole
• 21:39   Re: optimizing query with multiple aggregates Merlin Moncure
• 23:21   Re: optimizing query with multiple aggregates Doug Cole
• 23:47   Re: optimizing query with multiple aggregates David Wilson
• 23:48   Re: optimizing query with multiple aggregates Nikolas Everett

22 October 2009

• 00:16   Re: Random penalties on GIN index updates? Robert Haas
• 01:58   Re: Random penalties on GIN index updates? Jesper Krogh
• 03:56   Re: maintain_cluster_order_v5.patch Heikki Linnakangas
• 08:05   Re: There is a statistic table? Cédric Villemain
• 10:22   Re: optimizing query with multiple aggregates Kenneth Marshall
• 10:27   Re: optimizing query with multiple aggregates Robert Haas
• 13:28   Queryplan within FTS/GIN index -search. Jesper Krogh
• 15:51   Re: Queryplan within FTS/GIN index -search. Kevin Grittner
• 16:16   Table Clustering & Time Range Queries Kevin Buckham
• 16:25   Re: Table Clustering & Time Range Queries Kevin Grittner
• 18:34   Re: Table Clustering & Time Range Queries Scott Carey
• 18:49   Re: optimizing query with multiple aggregates Scott Carey
• 19:08   Re: Partitioned Tables and ORDER BY Scott Carey
• 19:57   Re: Queryplan within FTS/GIN index -search. Jeff Davis

23 October 2009

• 02:19   Re: Queryplan within FTS/GIN index -search. Jesper Krogh
• 02:43   Re: Queryplan within FTS/GIN index -search. Jeff Davis
• 04:23   Re: Table Clustering & Time Range Queries Scara Maccai
• 04:46   Re: Queryplan within FTS/GIN index -search. jesper@krogh.cc
• 05:26   Re: Queryplan within FTS/GIN index -search. Richard Huxton
• 06:04   Re: Queryplan within FTS/GIN index -search. jesper@krogh.cc
• 11:31   Re: Queryplan within FTS/GIN index -search. Richard Huxton
• 12:44   query planning different in plpgsql? Michal J. Kubski
• 12:50   Re: query planning different in plpgsql? Scott Mead
• 12:55   Re: Queryplan within FTS/GIN index -search. Jeff Davis
• 12:56   Re: query planning different in plpgsql? Grzegorz Jaśkiewicz
• 13:05   Re: Queryplan within FTS/GIN index -search. Jeff Davis
• 13:20   Re: query planning different in plpgsql? Tom Lane
• 13:28   Re: Queryplan within FTS/GIN index -search. Richard Huxton
• 15:13   Re: Queryplan within FTS/GIN index -search. Jesper Krogh
• 15:39   Calculating selectivity for the query-planner on ts_vector colums. Jesper Krogh
• 16:11   Re: Calculating selectivity for the query-planner on ts_vector colums. Tom Lane
• 16:18   Re: Table Clustering & Time Range Queries Kevin Buckham
• 16:22   Re: Queryplan within FTS/GIN index -search. Jeff Davis
• 16:30   Re: Calculating selectivity for the query-planner on ts_vector colums. Jesper Krogh
• 17:33   Re: Full text search - query plan? PG 8.4.1 Jesper Krogh
• 19:06   Re: Full text search - query plan? PG 8.4.1 Tom Lane
• 19:08   Re: Full text search - query plan? PG 8.4.1 Scott Marlowe
• 19:55   Re: Table Clustering & Time Range Queries Stephen Frost

24 October 2009

• 01:06   Re: Full text search - query plan? PG 8.4.1 Jesper Krogh
• 21:22   Re: Table Clustering & Time Range Queries Greg Smith

25 October 2009

• 23:05   Re: Domain vs table decibel

26 October 2009

• 06:40   Re: optimizing query with multiple aggregates Marc Mamin
• 07:05   Re: query planning different in plpgsql? Michal J. Kubski
• 10:45   Re: query planning different in plpgsql? Merlin Moncure
• 15:02   Re: query planning different in plpgsql? Michal J. Kubski
• 16:20   Re: Full text search - query plan? PG 8.4.1 Jesper Krogh
• 16:25   Re: Full text search - query plan? PG 8.4.1 Tom Lane
• 16:34   Re: query planning different in plpgsql?  Tom Lane
• 17:11   Re: query planning different in plpgsql? Waldomiro
• 17:13   bitmap heap scan way cheaper than seq scan on the same amount of tuples (fts-search). Jesper Krogh

27 October 2009

• 01:57   Re: bitmap heap scan way cheaper than seq scan on the same amount of tuples (fts-search). Craig Ringer
• 02:09   Re: bitmap heap scan way cheaper than seq scan on the same amount of tuples (fts-search). Jesper Krogh
• 02:34   Re: bitmap heap scan way cheaper than seq scan on the same amount of tuples (fts-search). Craig Ringer
• 02:45   Re: bitmap heap scan way cheaper than seq scan on the same amount of tuples (fts-search). Jesper Krogh
• 03:14   Re: bitmap heap scan way cheaper than seq scan on the same amount of tuples (fts-search). Craig Ringer
• 03:42   Re: bitmap heap scan way cheaper than seq scan on the same amount of tuples (fts-search). Jesper Krogh
• 11:48   Re: bitmap heap scan way cheaper than seq scan on the same amount of tuples (fts-search). Robert Haas
• 12:08   Re: bitmap heap scan way cheaper than seq scan on the same amount of tuples (fts-search). jesper@krogh.cc
• 22:25   Re: bitmap heap scan way cheaper than seq scan on the same amount of tuples (fts-search). Robert Haas

28 October 2009

• 09:11   Postgresql optimisation Denis BUCHER
• 09:26   Re: Postgresql optimisation Grzegorz Jaśkiewicz
• 10:49   Re: Postgresql optimisation Denis BUCHER
• 11:17   Re: Postgresql optimisation Grzegorz Jaśkiewicz
• 11:39   Re: Postgresql optimisation Kevin Grittner
• 13:08   Re: Postgresql optimisation Denis BUCHER
• 13:20   Re: Postgresql optimisation Greg Smith
• 13:30   Re: Postgresql optimisation Dave Dutcher
• 13:37   Re: Postgresql optimisation Matthew Wakeling
• 14:23   Re: Postgresql optimisation Dave Dutcher
• 15:13   sub-select in IN clause results in sequential scan Anj Adu

29 October 2009

• 06:54   Re: sub-select in IN clause results in sequential scan Grzegorz Jaśkiewicz
• 07:33   Re: sub-select in IN clause results in sequential scan Angayarkanni
• 11:10   Re: sub-select in IN clause results in sequential scan Anj Adu
• 11:28   Re: query planning different in plpgsql? Michal J. Kubski
• 11:32   Re: Postgresql optimisation Denis BUCHER
• 11:32   Re: query planning different in plpgsql? Michal J. Kubski
• 12:12   database size growing continously Peter Meszaros
• 12:25   Re: bitmap heap scan way cheaper than seq scan on the same amount of tuples (fts-search). Tom Lane
• 12:29   Re: sub-select in IN clause results in sequential scan Bob Lunney
• 12:34   Re: database size growing continously Ludwik Dylag
• 12:35   Re: sub-select in IN clause results in sequential scan Robert Haas
• 12:40   Re: sub-select in IN clause results in sequential scan Anj Adu
• 12:42   Re: database size growing continously Josh Rovero
• 13:00   Re: database size growing continously Matthew Wakeling
• 13:01   Re: database size growing continously Ludwik Dylag
• 13:14   Re: database size growing continously Chris Ernst
• 13:15   Re: database size growing continously Joshua D. Drake
• 13:21   Re: database size growing continously Steve Crawford
• 13:40   Re: database size growing continously Steve Crawford
• 13:44   Re: query planning different in plpgsql? Scott Carey
• 14:00   Re: database size growing continously Scott Marlowe
• 17:53   Modeling a table with arbitrary columns Andreas Hartmann
• 18:25   Re: Modeling a table with arbitrary columns Thomas Kellerer
• 19:14   Re: database size growing continously Joshua D. Drake
• 19:25   Re: optimizing query with multiple aggregates Doug Cole
• 22:39   Re: AMD, Intel and RAID controllers Greg Smith

30 October 2009

• 07:18   Re: Modeling a table with arbitrary columns Віталій Тимчишин
• 09:35   Re: sub-select in IN clause results in sequential scan Grzegorz Jaśkiewicz
• 09:43   Re: database size growing continously Merlin Moncure
• 12:03   Re: sub-select in IN clause results in sequential scan Robert Haas
• 16:13   Re: database size growing continously Jeremy Harris
• 16:46   Re: Queryplan within FTS/GIN index -search. Jesper Krogh
• 16:53   Re: database size growing continously Anj Adu
• 17:02   Re: database size growing continously Greg Stark
• 17:11   Re: database size growing continously Anj Adu
• 17:18   Re: database size growing continously Jeremy Harris
• 19:17   Re: database size growing continously Greg Stark

31 October 2009

• 00:11   Re: Queryplan within FTS/GIN index -search. Tom Lane
• 03:20   Re: Queryplan within FTS/GIN index -search. Jesper Krogh
• 05:56   Re: Queryplan within FTS/GIN index -search. Greg Stark
• 10:03   Re: Modeling a table with arbitrary columns Robert Haas