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 2005

Prev | Next

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

2005-03-01

Re: Inheritence versus delete from Tom Lane (01:07)
Re: Inheritence versus delete from John Arbash Meinel (01:41)
Re: seq scan cache vs. index cache smackdown PFC (05:32)
multi billion row tables: possible or insane? Ramon Bastiaans (09:34)
Re: multi billion row tables: possible or insane? Thomas Ganss (12:40)
Re: multi billion row tables: possible or insane? Jeff (13:37)
Re: multi billion row tables: possible or insane? Markus Schaber (14:01)
Re: multi billion row tables: possible or insane? John Arbash Meinel (15:19)
Re: multi billion row tables: possible or insane? Vig, Sandor (G/FI-2) (15:40)
What is the postgres sql command for last_user_id ??? amrit (15:46)
Re: multi billion row tables: possible or insane? John Arbash Meinel (15:52)
Re: multi billion row tables: possible or insane? Andras Kadinger (15:54)
Re: multi billion row tables: possible or insane? Alan Stange (15:57)
Re: multi billion row tables: possible or insane? Markus Schaber (16:26)
Re: Inheritence versus delete from Sven Willenberger (16:27)
Re: Inheritence versus delete from John Arbash Meinel (16:41)
Re: multi billion row tables: possible or insane? John Arbash Meinel (16:44)

2005-03-02

Confusion about locales and 'like' indexes Dan Harris (00:44)
Re: Inheritence versus delete from Gaetano Mendola (00:56)
Re: multi billion row tables: possible or insane? Josh Berkus (01:11)
Re: Confusion about locales and 'like' indexes Tom Lane (01:42)
Re: multi billion row tables: possible or insane? Alan Stange (02:28)
Re: What is the postgres sql command for last_user_id ??? stig erikson (06:43)
Help with tuning this query Ken Egervari (06:51)
Re: What is the postgres sql command for last_user_id ??? Michael Fuhr (08:12)
Re: Help with tuning this query Richard Huxton (08:58)
Re: Help with tuning this query Bricklen Anderson (16:13)
Re: Help with tuning this query Bruce Momjian (16:18)
Re: Help with tuning this query John Arbash Meinel (16:56)
Re: Help with tuning this query Ken Egervari (17:23)
Re: Help with tuning this query John Arbash Meinel (17:38)
Performance tradeoff Shawn Chisholm (17:52)
Re: Help with tuning this query Ragnar Hafstað (18:13)
Re: Help with tuning this query Ken Egervari (18:28)
Re: Help with tuning this query Ragnar Hafstað (18:49)
Re: Help with tuning this query Ken Egervari (18:56)
Re: Help with tuning this query (with explain analyze finally) Ken Egervari (20:06)
Re: Help with tuning this query (with explain analyze finally) Tom Lane (20:29)
Re: Help with tuning this query (with explain analyze finally) Ken Egervari (20:38)
Re: [PERFORM] Help with tuning this query (with explain analyze finally) Tom Lane (22:29)
Re: [PERFORM] Help with tuning this query (with explain analyze finally) Dave Held (23:01)
Re: Help with tuning this query (with explain analyze finally) John A Meinel (23:25)

2005-03-03

Re: Help with tuning this query (with explain analyze finally) Ken Egervari (01:20)
Re: Help with tuning this query (more musings) Ken Egervari (02:51)
Re: Help with tuning this query (Some musings) Ken Egervari (02:52)
Re: Help with tuning this query Mark Kirkwood (04:30)
Re: Help with tuning this query (more musings) John A Meinel (05:04)
Re: Performance tradeoff Josh Berkus (05:31)
Re: Help with tuning this query Josh Berkus (05:36)
Re: Help with tuning this query (with explain analyze finally) Josh Berkus (05:52)
Re: Help with tuning this query (more musings) Ken Egervari (06:35)
Re: Help with tuning this query (with explain analyze finally) Ken Egervari (06:59)
Re: Help with tuning this query (more musings) Richard Huxton (07:06)
Re: Help with tuning this query (with explain analyze finally) Ken Egervari (09:21)
name search query speed Jeremiah Jahn (16:38)
Re: name search query speed Ken Egervari (17:00)
Re: name search query speed Jeremiah Jahn (17:23)
Re: Help with tuning this query (with explain analyze finally) Josh Berkus (17:35)
Re: name search query speed Josh Berkus (17:44)
Re: name search query speed John A Meinel (17:46)
Re: name search query speed Markus Schaber (18:36)
Re: name search query speed Jeremiah Jahn (20:14)
Re: name search query speed Jeremiah Jahn (20:19)
Re: name search query speed Dave Held (20:26)
Re: name search query speed Jeremiah Jahn (20:47)
Re: name search query speed John Arbash Meinel (21:37)
Re: name search query speed Markus Schaber (22:03)
Re: Help with tuning this query (with explain analyze finally) Ken Egervari (23:42)

2005-03-04

Re: Help with tuning this query (with explain analyze finally) John Arbash Meinel (00:22)
Re: name search query speed William Yu (02:55)
Re: Help with tuning this query (with explain analyze finally) Ken Egervari (05:22)
Query's fast standalone - slow as a subquery. Ron Mayer (11:27)
Re: Query's fast standalone - slow as a subquery. Tom Lane (15:22)
Re: name search query speed stig erikson (15:46)
Re: Help with tuning this query (with explain analyze finally) Richard Huxton (15:56)
Re: Help with tuning this query (with explain analyze finally) Ken (16:36)
Re: Help with tuning this query (with explain analyze finally) John Arbash Meinel (16:56)
Re: Help with tuning this query (with explain analyze finally) John Arbash Meinel (17:07)
Select in FOR LOOP Performance Charles Joseph (17:53)
Re: Select in FOR LOOP Performance Tom Lane (18:29)
Re: Help with tuning this query (with explain analyze finally) Josh Berkus (18:29)
Re: Help with tuning this query (with explain analyze finally) John A Meinel (19:56)
MAIN vs. PLAIN Dave Held (20:59)
Re: multi billion row tables: possible or insane? Jim C. Nasby (22:05)

2005-03-05

Re: multi billion row tables: possible or insane? Alex Turner (00:15)
Re: MAIN vs. PLAIN Tom Lane (04:33)
performance problems Michael Zoephel (12:26)
Query Optimization - Hash Join estimate off? mark.lubratt (18:38)

2005-03-07

How to Partition? xsk (06:26)
Re: [PERFORM] Help with tuning this query (with explain analyze finally) Magnus Hagander (08:55)
Re: [PERFORM] Help with tuning this query (with explain analyze finally) Tom Lane (14:11)
Re: [PERFORM] Help with tuning this query (with explain analyze finally) Magnus Hagander (14:36)
Re: [PERFORM] Help with tuning this query (with explain analyze finally) Tom Lane (14:45)
Tuning, configuration for 7.3.5 on a Sun E4500 tsarevich (14:46)
Re: [PERFORM] Help with tuning this query (with John A Meinel (16:29)
Re: [PERFORM] Help with tuning this query (with explain analyze finally) Tom Lane (16:38)
Help trying to tune query that executes 40x slower than in SqlServer Hugo Ferreira (17:01)
Re: [PERFORM] Help with tuning this query (with John A Meinel (17:24)
Re: Help trying to tune query that executes 40x slower than in SqlServer Josh Berkus (17:28)
Re: Tuning, configuration for 7.3.5 on a Sun E4500 Josh Berkus (17:31)
Re: Help trying to tune query that executes 40x slower than in SqlServer Hugo Ferreira (17:45)
Re: Help trying to tune query that executes 40x slower than in SqlServer Tom Lane (18:02)
Re: [PERFORM] Help with tuning this query (with Greg Stark (18:05)
Re: Building postmaster with Profiling Support WAS "Tweaking a C Adam Palmblad (22:26)
Re: [PERFORM] Help with tuning this query (with Dave Held (22:30)
Re: [PERFORM] Help with tuning this query (with explain analyze finally) Dave Held (22:34)
Re: [PERFORM] Help with tuning this query (with John A Meinel (22:48)
Re: [PERFORM] Help with tuning this query (with Tom Lane (22:56)
Re: [PERFORM] Help with tuning this query (with Dave Page (23:08)
Re: [PERFORM] Help with tuning this query (with Greg Stark (23:15)
adding 'limit' leads to very slow query Michael McFarland (23:39)
Help with slow running query jesse d (23:54)

2005-03-08

Re: [PERFORM] Help with tuning this query (with Dave Held (00:11)
Re: [PERFORM] Help with tuning this query (with Dave Held (00:29)
Re: [PERFORM] Help with tuning this query (with Steinar H. Gunderson (01:37)
Re: [PERFORM] Help with tuning this query (with Tom Lane (02:02)
Re: [PERFORM] Help with tuning this query (with Steinar H. Gunderson (02:06)
Re: [PERFORM] Help with tuning this query (with PFC (03:51)
Re: [PERFORM] Help with tuning this query (with John A Meinel (04:35)
Re: adding 'limit' leads to very slow query John A Meinel (04:46)
Re: adding 'limit' leads to very slow query Stephan Szabo (07:03)
Re: Tuning, configuration for 7.3.5 on a Sun E4500 tsarevich (07:47)
Re: [PERFORM] Help with tuning this query (with Magnus Hagander (09:05)
bad plan Gaetano Mendola (10:32)
Re: bad plan Richard Huxton (11:39)
pl/pgsql faster than raw SQL? Markus Bertheau ☭ (12:20)
Re: bad plan Gaetano Mendola (12:22)
Re: pl/pgsql faster than raw SQL? Richard Huxton (12:48)
Re: bad plan Richard Huxton (13:20)
Re: pl/pgsql faster than raw SQL? John A Meinel (15:10)
Re: Tuning, configuration for 7.3.5 on a Sun E4500 Josh Berkus (17:10)
Re: bad plan Gaetano Mendola (18:35)
index scan on =, but not < ? Rick Schumeyer (18:35)
Re: index scan on =, but not < ? Thomas F.O'Connell (18:52)
Re: index scan on =, but not < ? John Arbash Meinel (19:01)
Re: index scan on =, but not < ? Rick Schumeyer (19:02)
Re: index scan on =, but not < ? Dennis Bjorklund (19:04)
Re: bad plan Richard Huxton (19:20)
Re: bad plan Tom Lane (20:01)
Why would writes to pgsql_tmp bottleneck at 1mb/s? Josh Berkus (20:18)
Re: bad plan Richard Huxton (20:25)
Re: bad plan Tom Lane (20:42)

2005-03-09

Query Optimization James G Wilkinson (00:04)
Re: Why would writes to pgsql_tmp bottleneck at 1mb/s? Josh Berkus (00:17)
Re: Why would writes to pgsql_tmp bottleneck at 1mb/s? Josh Berkus (00:44)
Re: bad plan Gaetano Mendola (00:47)
Re: pl/pgsql faster than raw SQL? Gaetano Mendola (00:54)
vacuum full, why multiple times ? Gaetano Mendola (01:02)
Re: Why would writes to pgsql_tmp bottleneck at 1mb/s? Aaron Birkland (01:13)
Re: pl/pgsql faster than raw SQL? John A Meinel (01:27)
Re: Query Optimization John A Meinel (01:46)
Re: vacuum full, why multiple times ? Michael Fuhr (02:15)
64bit Opteron multi drive raid. Help with best config settings David B (03:07)
Re: 64bit Opteron multi drive raid. Help with best config Karim Nassar (03:53)
Re: Why would writes to pgsql_tmp bottleneck at 1mb/s? Tom Lane (04:27)
Re: Why would writes to pgsql_tmp bottleneck at 1mb/s? Josh Berkus (04:37)
Re: Why would writes to pgsql_tmp bottleneck at 1mb/s? Tom Lane (04:37)
Re: index scan on =, but not < ? Bruno Wolff III (04:38)
Re: index scan on =, but not < ? Jim C. Nasby (04:55)
Re: index scan on =, but not < ? Bruno Wolff III (05:20)
Re: Why would writes to pgsql_tmp bottleneck at 1mb/s? Josh Berkus (07:00)
Re: pl/pgsql faster than raw SQL? Gaetano Mendola (11:20)
Re: vacuum full, why multiple times ? Gaetano Mendola (11:27)
Re: Help trying to tune query that executes 40x slower than in SqlServer Hugo Ferreira (12:08)
Re: vacuum full, why multiple times ? Richard Huxton (12:30)
Re: vacuum full, why multiple times ? Gaetano Mendola (14:30)
Re: vacuum full, why multiple times ? Tom Lane (15:16)
Re: adding 'limit' leads to very slow query Michael McFarland (16:00)
Re: vacuum full, why multiple times ? Gaetano Mendola (16:17)
Re: index scan on =, but not < ? Jim C. Nasby (17:22)
How to speed up tsearch2 indexing Werner Bohl (17:25)
Re: How to speed up tsearch2 indexing Oleg Bartunov (17:41)
Re: How to speed up tsearch2 indexing Werner Bohl (20:21)
Re: How to speed up tsearch2 indexing Oleg Bartunov (20:27)
Re: Help trying to tune query that executes 40x slower than in SqlServer Russell Smith (22:08)

2005-03-10

Re: index scan on =, but not < ? David Brown (00:06)
Re: index scan on =, but not < ? David Brown (00:24)
Re: Help trying to tune query that executes 40x slower Jim Johannsen (02:09)
Multi-line requests in COPY ... FROM STDIN Mischa (05:29)
What's better: Raid 0 or disk for seperate pg_xlog Karim Nassar (07:44)
Re: What's better: Raid 0 or disk for seperate pg_xlog David Brown (14:14)
Re: What's better: Raid 0 or disk for seperate pg_xlog John A Meinel (15:26)
Re: What's better: Raid 0 or disk for seperate pg_xlog Mario Weilguni (16:41)
Re: What's better: Raid 0 or disk for seperate pg_xlog Karim Nassar (19:50)
Re: What's better: Raid 0 or disk for seperate pg_xlog John Arbash Meinel (19:56)

2005-03-11

Re: What's better: Raid 0 or disk for seperate pg_xlog Richard Huxton (08:05)
Statistics not working?? Hugo Ferreira (11:53)
more execution time AL ELK (11:54)
Re: Statistics not working?? Oleg Bartunov (12:03)
Re: [GENERAL] more execution time Richard Huxton (13:05)
What is the number of rows in explain? Joost Kraaijeveld (13:45)
cpu_tuple_cost Daniel Schuchardt (14:25)
Re: cpu_tuple_cost Daniel Schuchardt (14:27)
Re: What is the number of rows in explain? John A Meinel (14:43)
Performance tuning Jacques Caron (15:40)
Query performance Lou O'Quin (18:47)
Questions about 2 databases. jelle (18:54)
Re: Query performance Tom Lane (19:10)
Re: Query performance Lou O'Quin (19:38)
Postgres on RAID5 Arshavir Grigorian (19:48)

Prev | Next

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

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