Skip site navigation (1)
Skip section navigation (2)
pgsql-performance 2006-03 Chronological Index (1/4)
Last updated: Wed Jan 18 04:19:04 2012
650 messages
01 April 2006
Re: Query using SeqScan instead of IndexScan chris smith (01:23)
Re: Query using SeqScan instead of IndexScan Brendan Duddridge (01:09)
31 March 2006
Re: [Solved] Slow performance on Windows .NET and OleDb Antoine (20:49)
Re: un-'vacuum analyse' Tom Lane (16:27)
un-'vacuum analyse' Frederic Back (16:02)
Re: Query using SeqScan instead of IndexScan Jim C. Nasby (15:59)
Re: Indexes with descending date columns Jim C. Nasby (15:55)
Re: simple join uses indexes, very slow Jim C. Nasby (15:48)
Re: index not used again Stephan Szabo (14:44)
index not used again Jan Kesten (09:16)
Re: Decide between Postgresql and Mysql (help of Guido Neitzer (06:56)
Re: Decide between Postgresql and Mysql (help of Philippe Marzin (02:08)
30 March 2006
Re: Decide between Postgresql and Mysql (help of Steinar H. Gunderson (22:36)
Re: Decide between Postgresql and Mysql (help of PFC (21:31)
Re: CREATE INDEX rather sluggish Gavin Hamill (20:45)
Re: CREATE INDEX rather sluggish Gavin Hamill (20:23)
Re: Decide between Postgresql and Mysql (help of Scott Marlowe (19:21)
Re: Decide between Postgresql and Mysql (help of Chris Browne (18:04)
Re: Index scan startup time Simon Riggs (17:19)
Re: CREATE INDEX rather sluggish Simon Riggs (17:08)
Re: Index scan startup time Tom Lane (15:24)
Re: CREATE INDEX rather sluggish Tom Lane (15:19)
Re: Index scan startup time Peter Eisentraut (15:16)
Re: [Solved] Slow performance on Windows .NET and OleDb Dave Dutcher (14:34)
Re: Index scan startup time Tom Lane (14:26)
Automatic tuning of postgresql.conf parameters? Mattias Kregert (13:57)
Re: Index scan startup time Michael Stone (13:29)
Re: Index scan startup time Steinar H. Gunderson (13:00)
Re: Index scan startup time Peter Eisentraut (12:59)
Re: Index scan startup time Steinar H. Gunderson (12:51)
Re: Index scan startup time Michael Stone (12:43)
Re: Index scan startup time Markus Schaber (12:35)
Re: Index scan startup time Steinar H. Gunderson (12:31)
Re: Index scan startup time Peter Eisentraut (12:24)
Re: Index scan startup time Peter Eisentraut (12:23)
Re: Index scan startup time Michael Stone (12:06)
Re: Index scan startup time Steinar H. Gunderson (12:02)
Index scan startup time Peter Eisentraut (11:59)
Re: Decide between Postgresql and Mysql (help of Markus Schaber (08:49)
CREATE INDEX rather sluggish Gavin Hamill (08:28)
[Solved] Slow performance on Windows .NET and OleDb Greg Quinn (05:57)
Re: Query using SeqScan instead of IndexScan Josh Berkus (05:18)
Re: Database possible corruption , unsolvable mystery Josh Berkus (05:13)
Re: Query using SeqScan instead of IndexScan Brendan Duddridge (03:20)
Query using SeqScan instead of IndexScan Brendan Duddridge (03:12)
Re: Decide between Postgresql and Mysql (help of Gorshkov (03:11)
Re: Decide between Postgresql and Mysql (help of Craig A. James (03:05)
Re: Decide between Postgresql and Mysql (help of Gorshkov (02:39)
Re: Decide between Postgresql and Mysql (help of Craig A. James (02:28)
Re: Slow performance on Windows .NET and OleDb Christopher Kings-Lynne (01:18)
Re: Decide between Postgresql and Mysql (help of Gorshkov (01:09)
29 March 2006
Re: Database possible corruption , unsolvable mystery stef (22:49)
Re: Database possible corruption , unsolvable mystery Eric Lauzon (22:31)
Re: Database possible corruption , unsolvable mystery Mark Lewis (22:16)
Re: Database possible corruption , unsolvable mystery Richard Huxton (22:10)
Database possible corruption , unsolvable mystery Eric Lauzon (17:59)
Re: Decide between Postgresql and Mysql (help of Vivek Khera (15:36)
Re: Decide between Postgresql and Mysql (help of Vivek Khera (15:35)
Re: Decide between Postgresql and Mysql (help of comunity) Vivek Khera (15:33)
Re: simple join uses indexes, very slow george young (15:29)
Re: Slow performance on Windows .NET and OleDb Merlin Moncure (14:05)
Re: Decide between Postgresql and Mysql (help of Merlin Moncure (13:48)
statistics buffer is full Gábriel Ákos (12:22)
Re: Slow performance on Windows .NET and OleDb PFC (11:40)
Re: Slow performance on Windows .NET and OleDb Markus Schaber (11:21)
Re: Slow performance on Windows .NET and OleDb Greg Quinn (11:00)
Re: Indexes with descending date columns Theo Kramer (10:52)
Re: Slow performance on Windows .NET and OleDb Chris (07:16)
Re: Slow performance on Windows .NET and OleDb Ruben Rubio Rey (06:58)
Re: Slow performance on Windows .NET and OleDb Greg Quinn (06:24)
Re: Slow performance on Windows .NET and OleDb Greg Quinn (06:22)
Re: simple join uses indexes, very slow stef (06:11)
Re: simple join uses indexes, very slow Chris (05:16)
Re: MVCC intro and benefits docs? Qingqing Zhou (05:03)
Re: simple join uses indexes, very slow Dave Dutcher (01:30)
28 March 2006
Re: Decide between Postgresql and Mysql (help of Jim C. Nasby (21:56)
Re: Decide between Postgresql and Mysql (help of Jim C. Nasby (21:53)
Re: Decide between Postgresql and Mysql (help of PFC (21:24)
Re: Decide between Postgresql and Mysql (help of PFC (21:18)
Re: simple join uses indexes, very slow george young (20:57)
Re: Decide between Postgresql and Mysql (help of Chris Travers (20:51)
Re: Decide between Postgresql and Mysql (help of Scott Marlowe (20:44)
Re: Decide between Postgresql and Mysql (help of PFC (20:44)
Re: Decide between Postgresql and Mysql (help of Marcos (20:28)
MVCC intro and benefits docs? Antoine (20:27)
Re: Decide between Postgresql and Mysql (help of Scott Marlowe (19:00)
Re: Decide between Postgresql and Mysql (help of comunity) Madison Kelly (18:57)
Decide between Postgresql and Mysql (help of comunity) Marcos (18:34)
Re: simple join uses indexes, very slow Simon Riggs (18:18)
Re: Slow performance on Windows .NET and OleDb Joshua D. Drake (17:52)
Re: Massive Inserts Strategies Jim C. Nasby (17:38)
Re: simple join uses indexes, very slow Steinar H. Gunderson (17:34)
Re: Slow performance on Windows .NET and OleDb Jim C. Nasby (17:32)
Re: simple join uses indexes, very slow Jim C. Nasby (17:30)
Re: count(*) performance Jim C. Nasby (17:26)
Re: simple join uses indexes, very slow Dave Dutcher (17:20)
Re: simple join uses indexes, very slow Steinar H. Gunderson (16:29)
Re: Massive Inserts Strategies Markus Schaber (16:18)
Re: simple join uses indexes, very slow Dave Dutcher (16:18)
Re: Massive Inserts Strategies ashah (15:57)
Re: simple join uses indexes, very slow Markus Schaber (15:26)
Re: simple join uses indexes, very slow george young (15:22)
Re: Slow performance on Windows .NET and OleDb Merlin Moncure (14:10)
Slow performance on Windows .NET and OleDb Greg Quinn (12:14)
Re: count(*) performance Markus Schaber (11:49)
Re: simple join uses indexes, very slow Simon Riggs (08:31)
27 March 2006
Re: count(*) performance Tom Lane (23:13)
Re: count(*) performance Matthew T. O'Connor (22:42)
Re: count(*) performance Mikael Carneholm (21:57)
Large Binary Objects Middleware Rodrigo Madera (20:16)
Re: count(*) performance Guido Neitzer (19:43)
Re: count(*) performance Alvaro Herrera (19:35)
Re: count(*) performance Matthew T. O'Connor (19:21)
Re: count(*) performance Brendan Duddridge (19:21)
simple join uses indexes, very slow george young (18:47)
Re: count(*) performance Gábriel Ákos (18:21)
Re: count(*) performance Luke Lonergan (18:15)
Re: count(*) performance Gábriel Ákos (18:05)
Re: count(*) performance Gábriel Ákos (18:04)
Re: count(*) performance Luke Lonergan (16:32)
Re: Query parallelism Jim C. Nasby (14:31)
Query parallelism luchot (14:25)
Re: count(*) performance Jim C. Nasby (13:41)
count(*) performance Gábriel Ákos (13:34)
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:14)
Re: Array performance Ruben Rubio Rey (07:03)
25 March 2006
Re: limitation using LIKE on ANY(array) K C Lau (01:50)
24 March 2006
Re: Scaling up PostgreSQL in Multiple CPU / Dual Core Chris Browne (20:04)
Re: Scaling up PostgreSQL in Multiple CPU / Dual Core Jim C. Nasby (19:24)
Re: Performance problems with multiple layers of functions Tom Lane (19:23)
Re: Scaling up PostgreSQL in Multiple CPU / Dual Core Michael Stone (19:21)
Re: Performance problems with multiple layers of functions Svenne Krap (19:16)
Re: Scaling up PostgreSQL in Multiple CPU / Dual Core Chris Browne (19:04)
Re: Scaling up PostgreSQL in Multiple CPU / Dual Core Chris Browne (19:04)
Re: WAL logging of SELECT ... INTO command Kris Jurka (18:10)
Re: Postmaster using only 4-5% CPU Scott Marlowe (16:43)
Re: limitation using LIKE on ANY(array) Tom Lane (16:26)
Re: Performance problems with multiple layers of functions Tom Lane (16:02)
Re: Array performance Tom Lane (15:51)
limitation using LIKE on ANY(array) K C Lau (15:26)
Re: Scaling up PostgreSQL in Multiple CPU / Dual Core Luke Lonergan (15:02)
Re: Problem with query, server totally unresponsive Jim C. Nasby (14:57)
Re: Problem with query, server totally unresponsive Dave Dutcher (14:46)
Re: WAL logging of SELECT ... INTO command Jim C. Nasby (13:59)
Re: WAL logging of SELECT ... INTO command Alvaro Herrera (13:47)
Re: Array performance Michael Fuhr (13:32)
Re: Array performance Jim C. Nasby (13:06)
Re: Array performance Ruben Rubio Rey (13:01)
Re: WAL logging of SELECT ... INTO command Jim C. Nasby (13:01)
Re: Performance problems with multiple layers of functions Jim C. Nasby (12:59)
Re: Array performance Jim C. Nasby (12:52)
Performance problems with multiple layers of functions Svenne Krap (12:48)
Array performance Ruben Rubio Rey (12:42)
Re: WAL logging of SELECT ... INTO command Alvaro Herrera (12:39)
Re: Problem with query, server totally unresponsive Jim C. Nasby (10:25)
Re: Indexes with descending date columns Jim C. Nasby (10:21)
Re: Postmaster using only 4-5% CPU Jim C. Nasby (10:16)
Re: Scaling up PostgreSQL in Multiple CPU / Dual Core Jim C. Nasby (10:14)
Re: WAL logging of SELECT ... INTO command Jim C. Nasby (10:07)
Re: WAL logging of SELECT ... INTO command Jim C. Nasby (10:05)
Re: Indexes with descending date columns Tom Lane (04:59)
Re: Indexes with descending date columns Theo Kramer (04:33)
Re: Scaling up PostgreSQL in Multiple CPU / Dual Core Christopher Browne (02:38)
23 March 2006
Re: Scaling up PostgreSQL in Multiple CPU / Dual Core Joshua D. Drake (16:43)
Re: Scaling up PostgreSQL in Multiple CPU / Dual Core Scott Marlowe (16:38)
Re: Scaling up PostgreSQL in Multiple CPU / Dual Core Frank Wiles (16:25)
Problem with query, forget previous message Bendik Rognlien Johansen (13:51)
Re: Scaling up PostgreSQL in Multiple CPU / Dual Core Powered Servers Christopher Browne (13:38)