Skip site navigation (1) Skip section navigation (2)

Peripheral Links

Text Size: Normal / Large
Donate
Contact

PostgreSQL

The world's most advanced open source database.

pgsql-performance - March 2006

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

2006-03-01

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)

2006-03-02

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)

2006-03-03

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)

2006-03-04

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)

2006-03-05

Planner enhancement suggestion. PFC (21:00)

2006-03-06

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)

2006-03-07

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)

2006-03-08

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)

2006-03-09

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)
Re: Hanging queries on dual CPU windows Magnus Hagander (21:22)
Re: firebird X postgresql 8.1.2 windows, performance comparison David Brown (23:51)

2006-03-10

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

2006-03-11

firebird X postgresql 8.1.2 windows, performance comparison Andre Felipe Machado (01:39)
Re: firebird X postgresql 8.1.2 windows, performance comparison Chris Travers (06:14)
Re: x206-x225 Joost Kraaijeveld (07:49)
Re: x206-x225 David Lang (07:57)
Re: x206-x225 Joost Kraaijeveld (08:17)
Re: x206-x225 PFC (11:33)
Re: x206-x225 Joost Kraaijeveld (14:26)
Re: x206-x225 Tom Lane (16:59)
Re: x206-x225 Joost Kraaijeveld (18:26)
Re: x206-x225 David Lang (21:15)
Re: Postgres and Ingres R3 / SAN Josh Berkus (23:06)

2006-03-12

help needed asap.... Phadnis (11:46)
Re: help needed asap.... Matthew Nuzum (18:38)
Re: help needed asap.... Bruno Wolff III (21:00)

2006-03-13

Re: Query time Ruben Rubio Rey (08:02)
Re: Query time PFC (08:16)
unsubscribe Nick Howden (11:24)
No vacuum for insert-only database? Craig A. James (15:02)
Re: No vacuum for insert-only database? Alvaro Herrera (15:09)
Re: No vacuum for insert-only database? Craig A. James (17:19)
Re: No vacuum for insert-only database? Alvaro Herrera (17:41)
firebird X postgresql 8.1.2 windows, performance comparison andremachado (18:11)
Re: No vacuum for insert-only database? Bruno Wolff III (18:52)
Re: firebird X postgresql 8.1.2 windows, performance comparison Josh Berkus (19:15)
Re: No vacuum for insert-only database? Josh Berkus (19:16)
Re: firebird X postgresql 8.1.2 windows, performance Scott Marlowe (20:02)
PG Statistics mcelroy, tim (23:49)

2006-03-14

Re: PG Statistics Michael Fuhr (00:18)
Re: PG Statistics Steve Poe (00:37)
import performance Chris (00:40)
Re: import performance Gavin Sherry (00:48)
Re: import performance Dave Dutcher (00:57)
Re: import performance Gavin Sherry (01:00)
Re: import performance Chris (01:24)
Re: import performance Frank Wiles (01:33)
Re: import performance Chris (01:42)
Re: import performance Tom Lane (01:51)
Re: import performance Frank Wiles (01:57)
Re: import performance Chris (02:27)
Re: import performance David Lang (06:13)
Re: import performance Chris (06:28)
firebird X postgresql 8.1.2 windows, performance comparison andremachado (12:02)
Re: PG Statistics mcelroy, tim (13:50)
Re: PG Statistics mcelroy, tim (13:51)
Re: firebird X postgresql 8.1.2 windows, performance comparison Merlin Moncure (14:06)
Vacuum template databases, Urgent: Production problem Pallav Kalva (16:44)
Re: Vacuum template databases, Urgent: Production problem Tom Lane (17:27)
Re: Vacuum template databases, Urgent: Production probl mcelroy, tim (17:28)
firebird X postgresql 8.1.2 windows, performance comparison andremachado (18:33)

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

Privacy Policy | About PostgreSQL
Copyright © 1996-2013 The PostgreSQL Global Development Group