pgsql-performance - March 2006

Discussion of PostgreSQL's performance issues. Please see Guide to reporting problems and Slow Query Questions for some tips on how to write your performance question.

Search the Archives

(enter a message-id to go directly to that message)
Advanced Search

Browse Archives

Prev | Next
Jump to day: 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 27 28 29 30 31

March 1, 2006

Thread Author Time
Re: nested query on last n rows of huge table Michael Glaesemann 03:44
Re: Large Table With Only a Few Rows Bruno Wolff III 06:55
Re: wal sync method PFC 11:58
Bad plan on a view PFC 14:56
Re: Bad plan on a view Tom Lane 15:16
Re: [PERFORM] temporary indexes Kevin Grittner 15:35
Re: Bad plan on a view PFC 15:43
Re: Bad plan on a view Greg Stark 16:04
Re: Bad plan on a view PFC 16:49
Re: Looking for a tool to "*" pg tables as ERDs Robert Treat 18:31
Re: triggers, performance Was: Re: [GENERAL] rotate records Jim C. Nasby 18:48
Re: Bad plan on a view Jim C. Nasby 18:51

March 2, 2006

Thread Author Time
Re: qsort again (was Re: [PERFORM] Strange Create Index behaviour) Bruce Momjian 18:17
Re: qsort again (was Re: [PERFORM] Strange Create Index behaviour) Jonah H. Harris 18:50

March 3, 2006

Thread Author Time
Like 'name%' is not using index Jozsef Szalay 00:15
Re: Like 'name%' is not using index Mark Kirkwood 01:28
Re: Like 'name%' is not using index Jozsef Szalay 02:48
Re: Like 'name%' is not using index Greg Stark 04:01
Physical column size Paul Mackay 10:03
Re: Physical column size Peter Eisentraut 10:23
Re: Physical column size Martijn van Oosterhout 10:23
Re: Physical column size Ragnar 10:27
Re: Physical column size Tom Lane 14:53

March 4, 2006

Thread Author Time
Bad row estimates Alex Adriaanse 01:10
Re: Bad row estimates Greg Stark 07:01
Re: Bad row estimates Greg Stark 08:15
How to query and index for customer with lastname and city Joost Kraaijeveld 09:58
Re: How to query and index for customer with lastname and city hubert depesz lubaczewski 13:49
Re: How to query and index for customer with lastname Joost Kraaijeveld 14:18
Re: How to query and index for customer with lastname and city hubert depesz lubaczewski 14:23
Re: Bad row estimates Jim C. Nasby 15:46
Re: Bad row estimates Tom Lane 16:09
Re: Bad row estimates Greg Stark 18:11
Re: How to query and index for customer with lastname and city Kevin Brown 21:35

March 5, 2006

Thread Author Time
Planner enhancement suggestion. PFC 21:00

March 6, 2006

Thread Author Time
t1000/t2000 sun-servers Claus Guttesen 09:05
Postgres on VPS - how much is enough? Nagita Karunaratne 13:28
Re: t1000/t2000 sun-servers Neil Saunders 14:30
Hanging queries and I/O exceptions Jan de Visser 14:38
Re: Postgres on VPS - how much is enough? Matthew Nuzum 14:56
Re: Postgres on VPS - how much is enough? Kevin 15:20
Can anyone explain this pgbench results? Joost Kraaijeveld 15:29
Re: Postgres on VPS - how much is enough? Nagita Karunaratne 16:52
Re: Postgres on VPS - how much is enough? Marc G. Fournier 17:14
Re: Can anyone explain this pgbench results? Michael Fuhr 17:47
Re: Can anyone explain this pgbench results? Joost Kraaijeveld 18:46
Sequencial scan instead of using index Harry Hehl 18:46
Re: Postgres on VPS - how much is enough? Matthew Nuzum 19:45
Postgres and Ingres R3 / SAN Jeremy Haile 19:58
Re: t1000/t2000 sun-servers Jignesh K. Shah 20:10
Re: Can anyone explain this pgbench results? Michael Fuhr 20:17
Re: Sequencial scan instead of using index Ragnar 20:51
Re: t1000/t2000 sun-servers Guido Neitzer 21:24
Re: t1000/t2000 sun-servers Jignesh K. Shah 22:11

March 7, 2006

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

March 8, 2006

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

March 9, 2006

Thread Author Time
embedded postgres and threading Gorshkov 00:32
Re: pg_reset_stats + cache I/O % Jim C. Nasby 03:23
pgCluster and postgres 8.1 Javier Somoza 10:24
Re: firebird X postgresql 8.1.2 windows, performance comparison Carlos Henrique Reimer 10:41
Re: firebird X postgresql 8.1.2 windows, performance comparison PFC 12:05
Re: pg_reset_stats + cache I/O % mcelroy, tim 13:13
Re: Hanging queries on dual CPU windows Jan de Visser 20:07
Re: Hanging queries on dual CPU windows Tom Lane 20:10
Re: Hanging queries on dual CPU windows Jan de Visser 21:15