Mailing lists [pgsql-performance]

1 March 2006

• 01:50   nested query on last n rows of huge table jcfischer
• 01:51   Re: nested query on last n rows of huge table jcfischer
• 01:51   Large Table With Only a Few Rows Nik
• 01:51   Re: triggers, performance Was: Re: [GENERAL] rotate records Jeevanandam, Kathirvel (IE10)
• 05:45   Re: Large Table With Only a Few Rows Bruno Wolff III
• 06:54   Re: nested query on last n rows of huge table Michael Glaesemann
• 10:58   Re: wal sync method PFC
• 13:56   Bad plan on a view PFC
• 14:16   Re: Bad plan on a view Tom Lane
• 14:43   Re: Bad plan on a view PFC
• 15:05   Re: Bad plan on a view Greg Stark
• 15:31   Re: [HACKERS] temporary indexes Kevin Grittner
• 15:49   Re: Bad plan on a view PFC
• 17:31   Re: Looking for a tool to "*" pg tables as ERDs Robert Treat
• 17:48   Re: triggers, performance Was: Re: [GENERAL] rotate records Jim C. Nasby
• 17:51   Re: Bad plan on a view Jim C. Nasby

2 March 2006

• 17:18   Re: [HACKERS] qsort again (was Re: Strange Create Index behaviour) Bruce Momjian
• 23:15   Like 'name%' is not using index Jozsef Szalay

3 March 2006

• 00:28   Re: Like 'name%' is not using index Mark Kirkwood
• 01:48   Re: Like 'name%' is not using index Jozsef Szalay
• 03:01   Re: Like 'name%' is not using index Greg Stark

4 March 2006

• 00:11   Bad row estimates Alex Adriaanse
• 06:01   Re: Bad row estimates Greg Stark
• 07:15   Re: Bad row estimates Greg Stark
• 08:58   How to query and index for customer with lastname and city Joost Kraaijeveld
• 12:49   Re: How to query and index for customer with lastname and city hubert depesz lubaczewski
• 13:18   Re: How to query and index for customer with lastname Joost Kraaijeveld
• 13:23   Re: How to query and index for customer with lastname and city hubert depesz lubaczewski
• 14:46   Re: Bad row estimates Jim C. Nasby
• 15:10   Re: Bad row estimates Tom Lane
• 17:11   Re: Bad row estimates Greg Stark
• 20:27   Re: How to query and index for customer with lastname and city Kevin Brown

5 March 2006

• 20:06   Planner enhancement suggestion. PFC

6 March 2006

• 08:05   t1000/t2000 sun-servers Claus Guttesen
• 12:28   Postgres on VPS - how much is enough? Nagita Karunaratne
• 13:30   Re: t1000/t2000 sun-servers Neil Saunders
• 13:38   Hanging queries and I/O exceptions Jan de Visser
• 13:56   Re: Postgres on VPS - how much is enough? Matthew Nuzum
• 14:23   Re: Postgres on VPS - how much is enough? Kevin
• 14:29   Can anyone explain this pgbench results? Joost Kraaijeveld
• 15:52   Re: Postgres on VPS - how much is enough? Nagita Karunaratne
• 16:14   Re: Postgres on VPS - how much is enough? Marc G. Fournier
• 16:47   Re: Can anyone explain this pgbench results? Michael Fuhr
• 17:46   Re: Can anyone explain this pgbench results? Joost Kraaijeveld
• 18:45   Re: Postgres on VPS - how much is enough? Matthew Nuzum
• 18:58   Postgres and Ingres R3 / SAN Jeremy Haile
• 19:11   Re: t1000/t2000 sun-servers Jignesh K. Shah
• 19:17   Re: Can anyone explain this pgbench results? Michael Fuhr
• 19:27   Sequencial scan instead of using index Harry Hehl
• 19:50   Re: Sequencial scan instead of using index Ragnar
• 20:24   Re: t1000/t2000 sun-servers Guido Neitzer
• 21:11   Re: t1000/t2000 sun-servers Jignesh K. Shah
• 23:14   Help understanding indexes, explain, and optimizing a query i.v.r.
• 23:19   Re: Planner enhancement suggestion. Jim C. Nasby
• 23:40   Re: Help understanding indexes, explain, and optimizing Chris

7 March 2006

• 01:10   Re: Help understanding indexes, explain, and optimizing i.v.r.
• 02:22   Re: Can anyone explain this pgbench results? Michael Fuhr
• 04:04   Re: Sequencial scan instead of using index Mark Kirkwood
• 09:34   Re: Can anyone explain this pgbench results? Joost Kraaijeveld
• 12:08   Re: Can anyone explain this pgbench results? Joost Kraaijeveld
• 14:03   Re: Help understanding indexes, explain, and optimizing Dave Dutcher
• 14:36   Re: Help understanding indexes, explain, and optimizing Tom Lane
• 15:34   firebird X postgresql 8.1.2 windows, performance comparison andremachado
• 15:42   Re: firebird X postgresql 8.1.2 windows, performance comparison Joshua D. Drake
• 15:57   Re: firebird X postgresql 8.1.2 windows, performance comparison Carlos Henrique Reimer
• 16:08   Re: firebird X postgresql 8.1.2 windows, performance Scott Marlowe
• 16:15   Re: firebird X postgresql 8.1.2 windows, performance Alvaro Herrera
• 16:19   Re: firebird X postgresql 8.1.2 windows, performance Scott Marlowe
• 16:22   Re: firebird X postgresql 8.1.2 windows, performance Alvaro Herrera
• 17:08   Re: Planner enhancement suggestion. PFC
• 17:37   Re: Planner enhancement suggestion. Jim C. Nasby
• 17:43   Re: t1000/t2000 sun-servers Jim C. Nasby
• 17:46   Re: Postgres on VPS - how much is enough? Jim C. Nasby
• 18:00   Re: Postgres and Ingres R3 / SAN Jim C. Nasby
• 18:09   pg_reset_stats + cache I/O % mcelroy, tim
• 18:09   Re: Can anyone explain this pgbench results? Jim C. Nasby
• 18:20   Re: Postgres and Ingres R3 / SAN Mark Lewis
• 18:22   Re: Postgres and Ingres R3 / SAN Jim C. Nasby
• 18:37   Re: pg_reset_stats + cache I/O % Tom Lane
• 18:49   Re: Can anyone explain this pgbench results? Joost Kraaijeveld
• 18:56   Re: firebird X postgresql 8.1.2 windows, performance Tom Lane
• 18:59   Re: Can anyone explain this pgbench results? Jim C. Nasby
• 19:07   Re: Postgres on VPS - how much is enough? Dave Page
• 19:15   Re: Can anyone explain this pgbench results? Joost Kraaijeveld
• 19:21   Re: Can anyone explain this pgbench results? Jim C. Nasby

8 March 2006

• 00:37   Re: firebird X postgresql 8.1.2 windows, performance comparison Andre Felipe Machado
• 01:15   Re: Postgres on VPS - how much is enough? Matthew Nuzum
• 13:01   Re: pg_reset_stats + cache I/O % mcelroy, tim
• 13:28   Is good idea an array of 365 elements in a cell of a table, in order to perform searchs? Ruben Rubio Rey
• 16:15   Re: Bad row estimates Alex Adriaanse
• 16:37   Re: Bad row estimates Greg Stark
• 17:27   Re: pg_reset_stats + cache I/O % Jim C. Nasby
• 17:46   Re: pg_reset_stats + cache I/O % mcelroy, tim
• 17:53   Re: Is good idea an array of 365 elements in a cell of a table, in order to perform searchs? Jim C. Nasby
• 18:24   Re: Postgres and Ingres R3 / SAN Jim Nasby
• 23:20   embedded postgres and threading Gorshkov

9 March 2006

• 02:23   Re: pg_reset_stats + cache I/O % Jim C. Nasby
• 09:23   pgCluster and postgres 8.1 Javier Somoza
• 09:41   Re: firebird X postgresql 8.1.2 windows, performance comparison Carlos Henrique Reimer
• 11:04   Re: firebird X postgresql 8.1.2 windows, performance comparison PFC
• 12:15   Re: pg_reset_stats + cache I/O % mcelroy, tim
• 19:07   Re: Hanging queries on dual CPU windows Jan de Visser
• 19:10   Re: Hanging queries on dual CPU windows Tom Lane
• 20:15   Re: Hanging queries on dual CPU windows Jan de Visser
• 20:22   Re: Hanging queries on dual CPU windows Magnus Hagander

10 March 2006

• 00:49   Re: pgCluster and postgres 8.1 Chris
• 01:00   Re: Hanging queries on dual CPU windows Jan de Visser
• 01:23   Re: firebird X postgresql 8.1.2 windows, performance comparison David Brown
• 01:28   Using materialized views for commonly-queried subsets Casey Allen Shobe
• 06:11   Process Time X200 NbForYou
• 07:59   Re: Process Time X200 Michael Fuhr
• 08:11   Re: Process Time X200 NbForYou
• 08:20   Re: Hanging queries on dual CPU windows Magnus Hagander
• 08:23   Re: Process Time X200 Guido Neitzer
• 08:33   Re: Process Time X200 Ragnar
• 08:50   x206-x225 H.J. Sanders
• 08:59   FW: x206-x226 H.J. Sanders
• 09:06   Query time Ruben Rubio Rey
• 09:26   Re: Process Time X200 Richard Huxton
• 09:30   Re: Query time Ruben Rubio Rey
• 09:45   Re: Process Time X200 NbForYou
• 09:48   Re: Query time Michael Fuhr
• 10:38   Re: Process Time X200 PFC
• 10:53   Re: Query time Ruben Rubio Rey
• 13:03   Re: Hanging queries on dual CPU windows Jan de Visser
• 13:16   Re: x206-x225 Richard Huxton
• 13:16   Re: Query time Richard Huxton
• 13:27   Re: x206-x225 Daniel Blaisdell
• 13:32   Re: Hanging queries on dual CPU windows Hakan Kocaman
• 13:33   Re: Hanging queries on dual CPU windows Jan de Visser
• 13:47   Re: Hanging queries on dual CPU windows Jan de Visser
• 14:10   Re: Hanging queries on dual CPU windows Magnus Hagander
• 14:15   Re: pg_reset_stats + cache I/O % Jim C. Nasby
• 14:17   Re: Using materialized views for commonly-queried subsets Jim C. Nasby
• 14:26   Re: Query time Jim C. Nasby
• 14:48   Re: Process Time X200 Matthew Nuzum
• 15:13   Re: Hanging queries on dual CPU windows Jan de Visser
• 15:45   one-field index vs. multi-field index planner estimates Evgeny Gridasov
• 15:47   Re: Process Time X200 Scott Marlowe
• 16:09   Re: one-field index vs. multi-field index planner estimates Tom Lane
• 16:28   Re: one-field index vs. multi-field index planner Evgeny Gridasov
• 16:30   Trouble managing planner for timestamptz columns Marc Morin
• 17:31   Re: Trouble managing planner for timestamptz columns Tom Lane
• 17:31   Re: Hanging queries on dual CPU windows Magnus Hagander
• 17:58   Re: one-field index vs. multi-field index planner Tom Lane
• 18:27   Re: Hanging queries on dual CPU windows Jan de Visser
• 18:37   Re: Hanging queries on dual CPU windows Jan de Visser
• 20:47   Re: Trouble managing planner for timestamptz columns Marc Morin
• 22:40   Re: Trouble managing planner for timestamptz columns Tom Lane

11 March 2006

• 00:37   firebird X postgresql 8.1.2 windows, performance comparison Andre Felipe Machado
• 06:49   Re: x206-x225 Joost Kraaijeveld
• 06:57   Re: x206-x225 David Lang
• 07:17   Re: x206-x225 Joost Kraaijeveld
• 10:33   Re: x206-x225 PFC
• 13:26   Re: x206-x225 Joost Kraaijeveld
• 15:59   Re: x206-x225 Tom Lane
• 17:26   Re: x206-x225 Joost Kraaijeveld
• 20:15   Re: x206-x225 David Lang
• 22:08   Re: Postgres and Ingres R3 / SAN Josh Berkus

12 March 2006

• 10:53   help needed asap.... Phadnis
• 17:38   Re: help needed asap.... Matthew Nuzum
• 19:59   Re: help needed asap.... Bruno Wolff III

13 March 2006

• 07:02   Re: Query time Ruben Rubio Rey
• 07:16   Re: Query time PFC
• 10:39   unsubscribe Nick Howden
• 14:07   No vacuum for insert-only database? Craig A. James
• 14:10   Re: No vacuum for insert-only database? Alvaro Herrera
• 16:24   Re: No vacuum for insert-only database? Craig A. James
• 16:41   Re: No vacuum for insert-only database? Alvaro Herrera
• 17:18   firebird X postgresql 8.1.2 windows, performance comparison andremachado
• 17:51   Re: No vacuum for insert-only database? Bruno Wolff III
• 18:16   Re: firebird X postgresql 8.1.2 windows, performance comparison Josh Berkus
• 18:18   Re: No vacuum for insert-only database? Josh Berkus
• 19:02   Re: firebird X postgresql 8.1.2 windows, performance Scott Marlowe
• 22:51   PG Statistics mcelroy, tim
• 23:19   Re: PG Statistics Michael Fuhr
• 23:40   import performance Chris
• 23:48   Re: import performance Gavin Sherry
• 23:53   Re: PG Statistics Steve Poe
• 23:57   Re: import performance Dave Dutcher

14 March 2006

• 00:00   Re: import performance Gavin Sherry
• 00:24   Re: import performance Chris
• 00:32   Re: import performance Frank Wiles
• 00:42   Re: import performance Chris
• 00:51   Re: import performance Tom Lane
• 00:56   Re: import performance Frank Wiles
• 01:27   Re: import performance Chris
• 05:14   Re: import performance David Lang
• 05:28   Re: import performance Chris
• 11:09   firebird X postgresql 8.1.2 windows, performance comparison andremachado
• 12:52   Re: PG Statistics mcelroy, tim
• 12:53   Re: PG Statistics mcelroy, tim
• 13:06   Re: firebird X postgresql 8.1.2 windows, performance comparison Merlin Moncure
• 16:00   Vacuum template databases, Urgent: Production problem Pallav Kalva
• 16:27   Re: Vacuum template databases, Urgent: Production problem Tom Lane
• 16:30   Re: Vacuum template databases, Urgent: Production probl mcelroy, tim
• 17:40   firebird X postgresql 8.1.2 windows, performance comparison andremachado
• 18:36   Re: firebird X postgresql 8.1.2 windows, performance comparison Merlin Moncure
• 19:11   Re: Process Time X200 Jim C. Nasby
• 19:26   Re: firebird X postgresql 8.1.2 windows, performance comparison Jim C. Nasby
• 19:32   Re: x206-x225 Jim C. Nasby
• 20:10   Re: firebird X postgresql 8.1.2 windows, performance comparison Jim C. Nasby
• 20:13   Re: Vacuum template databases, Urgent: Production problem Jim C. Nasby
• 20:16   Re: Vacuum template databases, Urgent: Production probl Jim C. Nasby
• 20:21   Re: Vacuum template databases, Urgent: Production probl mcelroy, tim
• 20:24   Re: Vacuum template databases, Urgent: Production probl Jim C. Nasby
• 20:46   Re: x206-x225 Richard Huxton
• 21:08   Re: x206-x225 Jim C. Nasby
• 21:18   Re: Vacuum template databases, Urgent: Production probl Vivek Khera

15 March 2006

• 08:43   Re: x206-x225 Richard Huxton
• 09:09   VACUUM FULL hangs Marcin Mańk
• 11:15   Re: VACUUM FULL hangs Richard Huxton
• 16:57   BETWEEN optimizer problems with single-value range Kevin Grittner
• 17:16   Re: BETWEEN optimizer problems with single-value range Andreas Kretschmer
• 17:43   Re: VACUUM FULL hangs Marcin Mańk
• 17:49   Re: BETWEEN optimizer problems with single-value Kevin Grittner
• 18:17   Re: BETWEEN optimizer problems with single-value Tom Lane
• 18:37   Re: BETWEEN optimizer problems with single-value range Merlin Moncure
• 18:39   Slow SELECTS after large update cycle Jan de Visser
• 18:43   Background writer configuration Kevin Grittner
• 18:51   Re: Background writer configuration Joshua D. Drake
• 19:26   Re: BETWEEN optimizer problems with single-value Kevin Grittner
• 19:43   Re: Background writer configuration Kevin Grittner
• 19:45   Re: BETWEEN optimizer problems with single-value range Andreas Kretschmer
• 21:11   Re: BETWEEN optimizer problems with single-value range Merlin Moncure
• 22:05   Re: [HACKERS] BETWEEN optimizer problems with single-value range Simon Riggs
• 22:12   Re: Slow SELECTS after large update cycle Chris
• 22:21   Re: Slow SELECTS after large update cycle Simon Riggs
• 22:34   Re: [HACKERS] BETWEEN optimizer problems with single-value Kevin Grittner
• 23:07   Re: BETWEEN optimizer problems with single-value Simon Riggs
• 23:24   Re: BETWEEN optimizer problems with single-value Simon Riggs
• 23:42   Re: Slow SELECTS after large update cycle Jan de Visser

16 March 2006

• 01:05   Re: BETWEEN optimizer problems with single-value Tom Lane
• 09:45   PostgreSQL and Xeon MP Guillaume Smet
• 10:37   Re: PostgreSQL and Xeon MP Richard Huxton
• 10:54   Re: BETWEEN optimizer problems with single-value Simon Riggs
• 11:28   Re: PostgreSQL and Xeon MP Guillaume Smet
• 12:11   Re: PostgreSQL and Xeon MP Sven Geisler
• 12:17   Re: PostgreSQL and Xeon MP Richard Huxton
• 12:41   Re: PostgreSQL and Xeon MP Guillaume Smet
• 13:17   Re: PostgreSQL and Xeon MP Guillaume Smet
• 13:30   Re: PostgreSQL and Xeon MP Guillaume Smet
• 14:20   Re: PostgreSQL and Xeon MP Tom Lane
• 14:20   Re: PostgreSQL and Xeon MP Sven Geisler
• 14:56   Re: BETWEEN optimizer problems with single-value Tom Lane
• 15:05   Re: PostgreSQL and Xeon MP Guillaume Smet
• 15:08   Re: PostgreSQL and Xeon MP Guillaume Smet
• 15:35   Re: PostgreSQL and Xeon MP Tom Lane
• 15:37   Re: PostgreSQL and Xeon MP Sven Geisler
• 16:53   Re: PostgreSQL and Xeon MP Guillaume Smet
• 17:15   Re: Background writer configuration Evgeny Gridasov
• 17:33   1 TB of memory Jim Nasby
• 17:41   Re: 1 TB of memory Joshua D. Drake
• 18:28   Re: BETWEEN optimizer problems with single-value Simon Riggs
• 18:41   Re: BETWEEN optimizer problems with single-value Alvaro Herrera
• 18:43   Re: BETWEEN optimizer problems with single-value Simon Riggs
• 18:45   Re: BETWEEN optimizer problems with single-value Tom Lane
• 19:00   Re: BETWEEN optimizer problems with single-value Simon Riggs
• 19:36   Indexes with descending date columns Theo Kramer
• 19:42   Re: 1 TB of memory Ron Peacetree
• 19:46   Re: 1 TB of memory Matthew Nuzum
• 20:40   Help optimizing a slow index scan Dan Harris
• 20:43   Re: Help optimizing a slow index scan Dan Harris
• 20:59   Re: Background writer configuration Kevin Grittner

17 March 2006

• 02:44   Re: 1 TB of memory Luke Lonergan
• 03:24   Re: 1 TB of memory Luke Lonergan
• 04:43   Re: 1 TB of memory Josh Berkus
• 05:25   Re: Indexes with descending date columns andrew@pillette.com
• 09:10   planner with index scan cost way off actual cost, advices to tweak cost constants? Guillaume Cottenceau
• 11:24   Re: Background writer configuration Evgeny Gridasov
• 11:59   Re: 1 TB of memory Luke Lonergan
• 12:31   Re: 1 TB of memory Michael Stone
• 12:35   Re: Background writer configuration PFC
• 12:38   Re: 1 TB of memory Rodrigo Madera
• 12:48   Re: 1 TB of memory Alex Stapleton
• 12:55   Re: 1 TB of memory Merlin Moncure
• 13:50   Re: Background writer configuration Evgeny Gridasov
• 13:55   Re: Background writer configuration PFC
• 13:57   Re: 1 TB of memory Merlin Moncure
• 14:08   Re: Background writer configuration Kevin Grittner
• 14:34   Re: Help optimizing a slow index scan Dan Harris
• 14:53   Re: Help optimizing a slow index scan Dan Harris
• 15:56   Re: Help optimizing a slow index scan Merlin Moncure
• 15:57   Re: Background writer configuration Steve Atkins
• 16:19   Re: Background writer configuration Steinar H. Gunderson
• 16:37   Re: 1 TB of memory Jim C. Nasby
• 16:37   Re: Help optimizing a slow index scan Bruno Wolff III
• 16:56   Re: Background writer configuration 11
• 17:07   Re: Help optimizing a slow index scan Merlin Moncure
• 17:36   Re: Background writer configuration Evgeny Gridasov
• 19:03   Re: 1 TB of memory Luke Lonergan
• 19:45   Re: Help optimizing a slow index scan Dan Harris
• 20:28   Re: 1 TB of memory Merlin Moncure
• 20:41   Re: Help optimizing a slow index scan Merlin Moncure
• 21:07   Re: 1 TB of memory Scott Marlowe
• 21:11   Best OS & Configuration for Dual Xeon w/4GB & Adaptec RAID 2200S Kenji Morishige
• 22:00   Re: Best OS & Configuration for Dual Xeon w/4GB & Scott Marlowe
• 22:03   Re: Best OS & Configuration for Dual Xeon w/4GB & Adaptec RAID 2200S Claus Guttesen
• 22:14   Re: Best OS & Configuration for Dual Xeon w/4GB & Adaptec RAID 2200S Tom Lane
• 22:21   Re: Best OS & Configuration for Dual Xeon w/4GB & Scott Marlowe
• 22:29   Re: Best OS & Configuration for Dual Xeon w/4GB & Adaptec RAID 2200S Claus Guttesen
• 23:00   Re: Best OS & Configuration for Dual Xeon w/4GB & Mark Kirkwood
• 23:08   Re: Best OS & Configuration for Dual Xeon w/4GB & Adaptec RAID 2200S Kenji Morishige

18 March 2006

• 03:41   Re: Help optimizing a slow index scan Tom Lane
• 04:29   Re: Help optimizing a slow index scan Michael Fuhr
• 07:52   Re: Help optimizing a slow index scan Oleg Bartunov
• 09:20   Re: planner with index scan cost way off actual cost, advices to tweak cost constants? Guillaume Smet
• 11:01   n00b autovacuum question Antoine
• 13:58   Re: Help optimizing a slow index scan Bruno Wolff III
• 14:04   database model tshirt sizes NbForYou
• 14:54   Re: n00b autovacuum question Matthew T. O'Connor
• 16:46   Re: n00b autovacuum question Andreas Pflug

19 March 2006

• 01:25   Re: firebird X postgresql 8.1.2 windows, performance comparison Chris Travers
• 01:25   Re: PostgreSQL and Xeon MP Kenneth Marshall
• 01:25   Re: Help optimizing a slow index scan Evgeny Gridasov
• 03:14   Re: planner with index scan cost way off actual cost, Mark Kirkwood
• 05:26   Re: Help optimizing a slow index scan Oleg Bartunov
• 11:27   Re: n00b autovacuum question Antoine
• 11:31   partitioning Antoine
• 13:25   Re: database model tshirt sizes Patrick Hatcher
• 13:38   Re: database model tshirt sizes 
• 13:47   Re: n00b autovacuum question Andreas Pflug
• 14:34   Re: n00b autovacuum question Antoine
• 15:26   Re: Best OS & Configuration for Dual Xeon w/4GB & Luke Lonergan
• 16:43   Re: database model tshirt sizes NbForYou
• 17:19   Re: Best OS & Configuration for Dual Xeon w/4GB & Dave Page

20 March 2006

• 03:27   partial indexes and inference Tim Allen
• 07:14   Re: planner with index scan cost way off actual cost, advices to tweak cost constants? Guillaume Cottenceau
• 07:35   Re: planner with index scan cost way off actual cost, advices to tweak cost constants? Guillaume Cottenceau
• 09:46   data doesnt get saved in the database / idle in transaction Ksenia Marasanova
• 11:06   Re: data doesnt get saved in the database / idle in transaction Qingqing Zhou
• 13:45   Re: Best OS & Configuration for Dual Xeon w/4GB & Jim C. Nasby
• 13:58   Migration study, step 1: bulk write performance optimization Mikael Carneholm
• 13:59   Query Feromance Marco Furetto
• 14:16   Re: Migration study, step 1: bulk write performance optimization Craig A. James
• 14:19   Re: Migration study, step 1: bulk write performance Csaba Nagy
• 15:20   Re: Best OS & Configuration for Dual Xeon w/4GB & Scott Marlowe
• 15:34   Re: Migration study, step 1: bulk write performance optimization PFC
• 15:34   Re: Query Feromance Reimer
• 16:44   Re: Migration study, step 1: bulk write performance optimization Dave Cramer
• 18:04   Re: 1 TB of memory Vivek Khera
• 18:07   Re: 1 TB of memory Vivek Khera
• 18:12   Auto performance tuning? Orion Henry
• 18:15   Re: Best OS & Configuration for Dual Xeon w/4GB & Adaptec RAID 2200S Vivek Khera
• 18:44   Re: 1 TB of memory Merlin Moncure
• 18:46   Re: Best OS & Configuration for Dual Xeon w/4GB & Alex Hayward
• 19:49   Re: Best OS & Configuration for Dual Xeon w/4GB & Adaptec Miguel
• 19:59   Re: Best OS & Configuration for Dual Xeon w/4GB & Luke Lonergan
• 20:09   Re: Best OS & Configuration for Dual Xeon w/4GB & Adaptec Miguel
• 20:28   Re: Best OS & Configuration for Dual Xeon w/4GB & Luke Lonergan
• 20:48   Re: Best OS & Configuration for Dual Xeon w/4GB & Adaptec Miguel
• 21:04   Re: Best OS & Configuration for Dual Xeon w/4GB & Luke Lonergan
• 21:10   Re: Best OS & Configuration for Dual Xeon w/4GB & Miguel
• 21:24   Re: 1 TB of memory Vivek Khera
• 21:39   Re: Best OS & Configuration for Dual Xeon w/4GB & Adaptec RAID 2200S Vivek Khera
• 21:53   update == delete + insert? Craig A. James
• 21:56   Re: update == delete + insert? Jim Buttafuoco
• 22:00   Re: Best OS & Configuration for Dual Xeon w/4GB & Adaptec Miguel
• 22:05   Re: Best OS & Configuration for Dual Xeon w/4GB & Adaptec RAID 2200S Vivek Khera
• 22:11   Re: Best OS & Configuration for Dual Xeon w/4GB & Adaptec Miguel
• 22:22   Re: update == delete + insert? Tom Lane
• 22:26   Re: Best OS & Configuration for Dual Xeon w/4GB & Adaptec PFC
• 23:27   Re: Migration study, step 1: bulk write performance optimization Tom Lane

21 March 2006

• 00:38   Re: update == delete + insert? Jaime Casanova
• 01:57   Re: Best OS & Configuration for Dual Xeon w/4GB & Mark Kirkwood
• 02:51   Re: Best OS & Configuration for Dual Xeon w/4GB & Mark Kirkwood
• 05:06   Perfomance test figures Amit Soni
• 07:25   Re: Query Feromance Marco Furetto
• 07:40   Re: Query Feromance Thomas Pundt
• 08:50   Re: planner with index scan cost way off actual cost, advices to tweak cost constants? Jim C. Nasby
• 08:56   Re: Query Feromance Marco Furetto
• 08:57   Re: planner with index scan cost way off actual cost, advices to tweak cost constants? Jim C. Nasby
• 08:59   Re: partitioning Jim C. Nasby
• 09:04   Re: partial indexes and inference Jim C. Nasby
• 09:05   Re: data doesnt get saved in the database / idle in transaction Jim C. Nasby
• 09:08   Re: Best OS & Configuration for Dual Xeon w/4GB & Jim C. Nasby
• 09:13   Re: planner with index scan cost way off actual cost, advices to tweak cost constants? Guillaume Cottenceau
• 09:23   Re: Best OS & Configuration for Dual Xeon w/4GB & Jim C. Nasby
• 09:32   Re: Best OS & Configuration for Dual Xeon w/4GB & Adaptec RAID 2200S Jim C. Nasby
• 09:40   Re: planner with index scan cost way off actual cost, Mark Kirkwood
• 09:55   Re: Query Feromance Thomas Pundt
• 10:03   Re: Best OS & Configuration for Dual Xeon w/4GB & Adaptec Mark Kirkwood
• 10:23   Re: update == delete + insert? Jim C. Nasby
• 10:28   Re: Migration study, step 1: bulk write performance Jim C. Nasby
• 10:35   Re: Auto performance tuning? Jim C. Nasby
• 10:38   Re: Perfomance test figures Jim C. Nasby
• 10:47   Re: Best OS & Configuration for Dual Xeon w/4GB & Adaptec Jim C. Nasby
• 10:49   Re: Best OS & Configuration for Dual Xeon w/4GB & Jim C. Nasby
• 10:51   Re: planner with index scan cost way off actual cost, Jim C. Nasby
• 10:52   Re: Migration study, step 1: bulk write performance Csaba Nagy
• 10:55   Re: Migration study, step 1: bulk write performance Steinar H. Gunderson
• 10:58   Re: planner with index scan cost way off actual cost, advices to tweak cost constants? Jim C. Nasby
• 10:59   Re: Migration study, step 1: bulk write performance Csaba Nagy
• 11:01   Re: Migration study, step 1: bulk write performance Jim C. Nasby
• 11:09   Re: Migration study, step 1: bulk write performance Steinar H. Gunderson
• 11:18   Re: Migration study, step 1: bulk write performance Jim C. Nasby
• 11:22   WAL logging of SELECT ... INTO command Jim C. Nasby
• 11:22   Re: Best OS & Configuration for Dual Xeon w/4GB & Adaptec Alex Hayward
• 11:29   Re: Migration study, step 1: bulk write performance Steinar H. Gunderson
• 11:34   Re: Best OS & Configuration for Dual Xeon w/4GB & Adaptec Jim C. Nasby
• 11:45   Re: Migration study, step 1: bulk write performance Jim C. Nasby
• 11:48   Re: Migration study, step 1: bulk write performance Michael Stone
• 11:51   Postmaster using only 4-5% CPU Edoardo Serra
• 12:03   Re: planner with index scan cost way off actual cost, Guillaume Cottenceau
• 12:30   Re: planner with index scan cost way off actual cost, advices to tweak cost constants? Guillaume Cottenceau
• 13:03   Re: Perfomance test figures Merlin Moncure
• 13:11   Re: Postmaster using only 4-5% CPU Markus Bertheau
• 13:12   Re: update == delete + insert? Merlin Moncure
• 13:34   Re: Postmaster using only 4-5% CPU Guillaume Cottenceau
• 14:25   Re: Best OS & Configuration for Dual Xeon w/4GB & Luke Lonergan
• 14:33   Re: Best OS & Configuration for Dual Xeon w/4GB & Adaptec Vivek Khera
• 14:34   Re: Best OS & Configuration for Dual Xeon w/4GB & Adaptec Vivek Khera
• 14:40   Re: Best OS & Configuration for Dual Xeon w/4GB & Adam Witney
• 15:57   Re: PostgreSQL and Xeon MP Guillaume Smet
• 16:38   Re: update == delete + insert? Jim C. Nasby
• 16:44   Re: Postmaster using only 4-5% CPU Scott Marlowe
• 16:46   Re: planner with index scan cost way off actual cost, advices to tweak cost constants? Jim C. Nasby
• 16:49   Re: planner with index scan cost way off actual cost, Jim C. Nasby
• 16:59   Re: Best OS & Configuration for Dual Xeon w/4GB & Jim C. Nasby
• 17:10   Sequence Scan vs. Index scan Fernando Lujan
• 17:16   Re: Sequence Scan vs. Index scan Steinar H. Gunderson
• 17:22   Re: Sequence Scan vs. Index scan Mikael Carneholm
• 17:23   Re: Sequence Scan vs. Index scan Reimer
• 18:04   Re: Best OS & Configuration for Dual Xeon w/4GB & Adaptec PFC
• 18:14   Re: Best OS & Configuration for Dual Xeon w/4GB & Mark Kirkwood
• 18:22   Re: Best OS & Configuration for Dual Xeon w/4GB & Jeff Frost
• 19:08   Re: qsort again (was Re: Strange Create Index behaviour) Tom Lane
• 19:32   Re: Best OS & Configuration for Dual Xeon w/4GB & Adaptec Vivek Khera
• 19:34   Re: WAL logging of SELECT ... INTO command Simon Riggs
• 19:45   Re: Migration study, step 1: bulk write performance Simon Riggs
• 19:58   Re: planner with index scan cost way off actual cost, Simon Riggs
• 20:15   Re: Migration study, step 1: bulk write performance Ron
• 20:19   Re: Migration study, step 1: bulk write performance Scott Marlowe
• 20:20   Re: Migration study, step 1: bulk write performance Alvaro Herrera
• 20:56   Re: Migration study, step 1: bulk write performance Tom Lane
• 21:23   Re: Migration study, step 1: bulk write performance Scott Marlowe
• 21:44   Poor performance o Craig A. James
• 22:33   Re: Poor performance o Tom Lane

22 March 2006

• 00:08   Re: Poor performance o Craig A. James
• 01:22   Re: Best OS & Configuration for Dual Xeon w/4GB & Vivek Khera
• 01:48   motherboard recommendations Jeff Frost
• 03:31   Re: Poor performance o Tom Lane
• 07:04   Re: planner with index scan cost way off actual cost, Guillaume Cottenceau
• 08:04   Re: Migration study, step 1: bulk write performanceoptimization Mikael Carneholm
• 08:18   Re: Query Feromance Marco Furetto
• 08:48   Re: Migration study, step 1: bulk write Simon Riggs
• 10:50   Re: Sequence Scan vs. Index scan Alejandro D. Burne
• 11:12   Re: Sequence Scan vs. Index scan Steinar H. Gunderson
• 11:24   Re: Sequence Scan vs. Index scan Alejandro D. Burne
• 11:25   Re: Poor performance o Jim C. Nasby
• 11:47   Re: WAL logging of SELECT ... INTO command Jim C. Nasby
• 11:55   Re: Migration study, step 1: bulk write performanceoptimization Jim C. Nasby
• 12:08   Re: WAL logging of SELECT ... INTO command Simon Riggs
• 12:12   Re: Migration study, step 1: bulk write performanceoptimization Mikael Carneholm
• 12:19   Re: WAL logging of SELECT ... INTO command Jim C. Nasby
• 13:06   Intel C/C++ Compiler Tests Spiegelberg, Greg
• 13:34   Re: Migration study, step 1: bulk write performanceoptimization Tom Lane
• 14:06   Re: WAL logging of SELECT ... INTO command Tom Lane
• 14:14   Re: WAL logging of SELECT ... INTO command Jim C. Nasby
• 14:35   Re: WAL logging of SELECT ... INTO command Tom Lane
• 14:50   Massive Inserts Strategies ashah
• 15:07   Re: Massive Inserts Strategies PFC
• 15:09   Re: Massive Inserts Strategies Jim C. Nasby
• 15:16   Re: planner with index scan cost way off actual cost, Scott Marlowe
• 15:20   Re: WAL logging of SELECT ... INTO command Csaba Nagy
• 15:26   Re: planner with index scan cost way off actual cost, Guillaume Cottenceau
• 16:11   Re: Intel C/C++ Compiler Tests Luke Lonergan
• 18:37   Re: WAL logging of SELECT ... INTO command Kris Jurka

23 March 2006

• 03:15   Re: WAL logging of SELECT ... INTO command Qingqing Zhou
• 05:19   Scaling up PostgreSQL in Multiple CPU / Dual Core Powered Servers Jojo Paderes
• 08:12   Re: Postmaster using only 4-5% CPU Edoardo Serra
• 10:47   Re: Indexes with descending date columns Theo Kramer
• 11:12   Problem with query, server totally unresponsive Bendik Rognlien Johansen
• 12:24   Re: Indexes with descending date columns Alvaro Herrera
• 12:38   Re: Scaling up PostgreSQL in Multiple CPU / Dual Core Powered Servers Christopher Browne
• 12:51   Problem with query, forget previous message Bendik Rognlien Johansen
• 15:25   Re: Scaling up PostgreSQL in Multiple CPU / Dual Core Frank Wiles
• 15:38   Re: Scaling up PostgreSQL in Multiple CPU / Dual Core Scott Marlowe
• 15:43   Re: Scaling up PostgreSQL in Multiple CPU / Dual Core Joshua D. Drake
• 16:02   Re: Scaling up PostgreSQL in Multiple CPU / Dual Core Scott Marlowe

24 March 2006

• 01:38   Re: Scaling up PostgreSQL in Multiple CPU / Dual Core Christopher Browne
• 03:33   Re: Indexes with descending date columns Theo Kramer
• 03:59   Re: Indexes with descending date columns Tom Lane
• 09:05   Re: WAL logging of SELECT ... INTO command Jim C. Nasby
• 09:07   Re: WAL logging of SELECT ... INTO command Jim C. Nasby
• 09:14   Re: Scaling up PostgreSQL in Multiple CPU / Dual Core Jim C. Nasby
• 09:16   Re: Postmaster using only 4-5% CPU Jim C. Nasby
• 09:21   Re: Indexes with descending date columns Jim C. Nasby
• 09:25   Re: Problem with query, server totally unresponsive Jim C. Nasby
• 11:39   Re: WAL logging of SELECT ... INTO command Alvaro Herrera
• 11:42   Array performance Ruben Rubio Rey
• 11:48   Performance problems with multiple layers of functions Svenne Krap
• 11:52   Re: Array performance Jim C. Nasby
• 11:59   Re: Performance problems with multiple layers of functions Jim C. Nasby
• 12:01   Re: WAL logging of SELECT ... INTO command Jim C. Nasby
• 12:01   Re: Array performance Ruben Rubio Rey
• 12:06   Re: Array performance Jim C. Nasby
• 12:32   Re: Array performance Michael Fuhr
• 12:47   Re: WAL logging of SELECT ... INTO command Alvaro Herrera
• 12:59   Re: WAL logging of SELECT ... INTO command Jim C. Nasby
• 13:46   Re: Problem with query, server totally unresponsive Dave Dutcher
• 13:57   Re: Problem with query, server totally unresponsive Jim C. Nasby
• 14:02   Re: Scaling up PostgreSQL in Multiple CPU / Dual Core Luke Lonergan
• 14:26   limitation using LIKE on ANY(array) K C Lau
• 14:51   Re: Array performance Tom Lane
• 15:02   Re: Performance problems with multiple layers of functions Tom Lane
• 15:26   Re: limitation using LIKE on ANY(array) Tom Lane
• 15:43   Re: Postmaster using only 4-5% CPU Scott Marlowe
• 17:10   Re: WAL logging of SELECT ... INTO command Kris Jurka
• 18:04   Re: Scaling up PostgreSQL in Multiple CPU / Dual Core Chris Browne
• 18:04   Re: Scaling up PostgreSQL in Multiple CPU / Dual Core Chris Browne
• 18:16   Re: Performance problems with multiple layers of functions Svenne Krap
• 18:21   Re: Scaling up PostgreSQL in Multiple CPU / Dual Core Michael Stone
• 18:23   Re: Performance problems with multiple layers of functions Tom Lane
• 18:24   Re: Scaling up PostgreSQL in Multiple CPU / Dual Core Jim C. Nasby
• 19:04   Re: Scaling up PostgreSQL in Multiple CPU / Dual Core Chris Browne
• 21:54   Query plan from hell PFC

25 March 2006

• 00:50   Re: limitation using LIKE on ANY(array) K C Lau
• 08:53   Re: Query plan from hell Guido Neitzer

27 March 2006

• 06:03   Re: Array performance Ruben Rubio Rey
• 11:14   Re: [GENERAL] experiences needed - how does Itanium2/1.5GHz(4MB) compare to AMD and Intel CPUs as far as Postgresql is concerned Jim C. Nasby
• 12:34   count(*) performance Gábriel Ákos
• 12:41   Re: count(*) performance Jim C. Nasby
• 13:25   Query parallelism luchot
• 13:31   Re: Query parallelism Jim C. Nasby
• 15:32   Re: count(*) performance Luke Lonergan
• 17:04   Re: count(*) performance Gábriel Ákos
• 17:05   Re: count(*) performance Gábriel Ákos
• 17:15   Re: count(*) performance Luke Lonergan
• 17:21   Re: count(*) performance Gábriel Ákos
• 17:47   simple join uses indexes, very slow george young
• 18:21   Re: count(*) performance Brendan Duddridge
• 18:21   Re: count(*) performance Matthew T. O'Connor
• 18:35   Re: count(*) performance Alvaro Herrera
• 18:43   Re: count(*) performance Guido Neitzer
• 19:16   Large Binary Objects Middleware Rodrigo Madera
• 20:57   Re: count(*) performance Mikael Carneholm
• 21:42   Re: count(*) performance Matthew T. O'Connor
• 22:13   Re: count(*) performance Tom Lane
• 22:17   Re: count(*) performance Mikael Carneholm

28 March 2006

• 07:31   Re: simple join uses indexes, very slow Simon Riggs
• 10:49   Re: count(*) performance Markus Schaber
• 11:14   Slow performance on Windows .NET and OleDb Greg Quinn
• 13:10   Re: Slow performance on Windows .NET and OleDb Merlin Moncure
• 14:22   Re: simple join uses indexes, very slow george young
• 14:26   Re: simple join uses indexes, very slow Markus Schaber
• 14:57   Re: Massive Inserts Strategies ashah
• 15:18   Re: simple join uses indexes, very slow Dave Dutcher
• 15:18   Re: Massive Inserts Strategies Markus Schaber
• 15:29   Re: simple join uses indexes, very slow Steinar H. Gunderson
• 16:20   Re: simple join uses indexes, very slow Dave Dutcher
• 16:26   Re: count(*) performance Jim C. Nasby
• 16:30   Re: simple join uses indexes, very slow Jim C. Nasby
• 16:32   Re: Slow performance on Windows .NET and OleDb Jim C. Nasby
• 16:34   Re: simple join uses indexes, very slow Steinar H. Gunderson
• 16:38   Re: Massive Inserts Strategies Jim C. Nasby
• 16:52   Re: Slow performance on Windows .NET and OleDb Joshua D. Drake
• 17:18   Re: simple join uses indexes, very slow Simon Riggs
• 17:34   Decide between Postgresql and Mysql (help of comunity) Marcos
• 17:57   Re: Decide between Postgresql and Mysql (help of comunity) Madison Kelly
• 18:00   Re: Decide between Postgresql and Mysql (help of Scott Marlowe
• 19:27   MVCC intro and benefits docs? Antoine
• 19:28   Re: Decide between Postgresql and Mysql (help of Marcos
• 19:44   Re: Decide between Postgresql and Mysql (help of Scott Marlowe
• 19:44   Re: Decide between Postgresql and Mysql (help of PFC
• 19:51   Re: Decide between Postgresql and Mysql (help of Chris Travers
• 19:57   Re: simple join uses indexes, very slow george young
• 20:18   Re: Decide between Postgresql and Mysql (help of PFC
• 20:24   Re: Decide between Postgresql and Mysql (help of PFC
• 20:53   Re: Decide between Postgresql and Mysql (help of Jim C. Nasby
• 20:56   Re: Decide between Postgresql and Mysql (help of Jim C. Nasby
• 20:59   Re: MVCC intro and benefits docs? Jim C. Nasby

29 March 2006

• 00:30   Re: simple join uses indexes, very slow Dave Dutcher
• 04:03   Re: MVCC intro and benefits docs? Qingqing Zhou
• 04:16   Re: simple join uses indexes, very slow Chris
• 05:11   Re: simple join uses indexes, very slow stef
• 05:22   Re: Slow performance on Windows .NET and OleDb Greg Quinn
• 05:24   Re: Slow performance on Windows .NET and OleDb Greg Quinn
• 05:58   Re: Slow performance on Windows .NET and OleDb Ruben Rubio Rey
• 06:16   Re: Slow performance on Windows .NET and OleDb Chris
• 09:52   Re: Indexes with descending date columns Theo Kramer
• 10:00   Re: Slow performance on Windows .NET and OleDb Greg Quinn
• 10:21   Re: Slow performance on Windows .NET and OleDb Markus Schaber
• 10:40   Re: Slow performance on Windows .NET and OleDb PFC
• 11:22   statistics buffer is full Gábriel Ákos
• 12:48   Re: Decide between Postgresql and Mysql (help of Merlin Moncure
• 13:05   Re: Slow performance on Windows .NET and OleDb Merlin Moncure
• 14:29   Re: simple join uses indexes, very slow george young
• 14:33   Re: Decide between Postgresql and Mysql (help of comunity) Vivek Khera
• 14:35   Re: Decide between Postgresql and Mysql (help of Vivek Khera
• 14:36   Re: Decide between Postgresql and Mysql (help of Vivek Khera
• 16:59   Database possible corruption , unsolvable mystery Eric Lauzon
• 21:10   Re: Database possible corruption , unsolvable mystery Richard Huxton
• 21:16   Re: Database possible corruption , unsolvable mystery Mark Lewis
• 21:31   Re: Database possible corruption , unsolvable mystery Eric Lauzon
• 21:49   Re: Database possible corruption , unsolvable mystery stef
• 22:33   Re: Database possible corruption , unsolvable mystery Eric Lauzon

30 March 2006

• 00:09   Re: Decide between Postgresql and Mysql (help of Gorshkov
• 00:18   Re: Slow performance on Windows .NET and OleDb Christopher Kings-Lynne
• 01:28   Re: Decide between Postgresql and Mysql (help of Craig A. James
• 01:39   Re: Decide between Postgresql and Mysql (help of Gorshkov
• 02:05   Re: Decide between Postgresql and Mysql (help of Craig A. James
• 02:11   Re: Decide between Postgresql and Mysql (help of Gorshkov
• 02:12   Query using SeqScan instead of IndexScan Brendan Duddridge
• 02:20   Re: Query using SeqScan instead of IndexScan Brendan Duddridge
• 04:14   Re: Database possible corruption , unsolvable mystery Josh Berkus
• 04:18   Re: Query using SeqScan instead of IndexScan Josh Berkus
• 04:57   [Solved] Slow performance on Windows .NET and OleDb Greg Quinn
• 07:28   CREATE INDEX rather sluggish Gavin Hamill
• 07:49   Re: Decide between Postgresql and Mysql (help of Markus Schaber
• 10:59   Index scan startup time Peter Eisentraut
• 11:02   Re: Index scan startup time Steinar H. Gunderson
• 11:06   Re: Index scan startup time Michael Stone
• 11:24   Re: Index scan startup time Peter Eisentraut
• 11:24   Re: Index scan startup time Peter Eisentraut
• 11:31   Re: Index scan startup time Steinar H. Gunderson
• 11:35   Re: Index scan startup time Markus Schaber
• 11:43   Re: Index scan startup time Michael Stone
• 11:51   Re: Index scan startup time Steinar H. Gunderson
• 11:59   Re: Index scan startup time Peter Eisentraut
• 12:00   Re: Index scan startup time Steinar H. Gunderson
• 12:29   Re: Index scan startup time Michael Stone
• 12:57   Automatic tuning of postgresql.conf parameters? Mattias Kregert
• 13:26   Re: Index scan startup time Tom Lane
• 13:34   Re: [Solved] Slow performance on Windows .NET and OleDb Dave Dutcher
• 14:16   Re: Index scan startup time Peter Eisentraut
• 14:19   Re: CREATE INDEX rather sluggish Tom Lane
• 14:24   Re: Index scan startup time Tom Lane
• 16:09   Re: CREATE INDEX rather sluggish Simon Riggs
• 16:19   Re: Index scan startup time Simon Riggs
• 17:04   Re: Decide between Postgresql and Mysql (help of Chris Browne
• 18:21   Re: Decide between Postgresql and Mysql (help of Scott Marlowe
• 19:23   Re: CREATE INDEX rather sluggish Gavin Hamill
• 19:45   Re: CREATE INDEX rather sluggish Gavin Hamill
• 20:31   Re: Decide between Postgresql and Mysql (help of PFC
• 21:36   Re: Decide between Postgresql and Mysql (help of Steinar H. Gunderson
• 22:04   Re: Decide between Postgresql and Mysql (help of Chris Browne

31 March 2006

• 01:08   Re: Decide between Postgresql and Mysql (help of Philippe Marzin
• 05:56   Re: Decide between Postgresql and Mysql (help of Guido Neitzer
• 08:16   index not used again Jan Kesten
• 13:44   Re: index not used again Stephan Szabo
• 14:48   Re: simple join uses indexes, very slow Jim C. Nasby
• 14:55   Re: Indexes with descending date columns Jim C. Nasby
• 14:59   Re: Query using SeqScan instead of IndexScan Jim C. Nasby
• 15:02   un-'vacuum analyse' Frederic Back
• 15:27   Re: un-'vacuum analyse' Tom Lane
• 19:49   Re: [Solved] Slow performance on Windows .NET and OleDb Antoine
• 22:27   Re: [Solved] Slow performance on Windows .NET and OleDb Magnus Hagander