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 - November 2007

Prev | Next

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

Nov. 1, 2007

Re: Hardware for PostgreSQL Ow Mun Heng (03:53)
Re: Hardware for PostgreSQL Magnus Hagander (06:52)
Re: Hardware for PostgreSQL Magnus Hagander (06:54)
Re: hardware and For PostgreSQL Magnus Hagander (06:57)
Re: Hardware for PostgreSQL Ow Mun Heng (07:46)
Re: Hardware for PostgreSQL Magnus Hagander (07:52)
Re: hardware and For PostgreSQL Joe Uhl (11:00)
Re: Hardware for PostgreSQL Adam Tauno Williams (12:56)
select max(field) from table much faster with a group by clause? Palle Girgensohn (13:07)
Re: [Fwd: Re: Outer joins and Seq scans] Tom Lane (13:29)
Re: select max(field) from table much faster with a group by clause? Tom Lane (13:43)
Re: select max(field) from table much faster with a group by clause? Palle Girgensohn (14:20)
Re: [Fwd: Re: Outer joins and Seq scans] Sami Dalouche (14:21)
Re: select max(field) from table much faster with a group by clause? Palle Girgensohn (14:36)
Re: select max(field) from table much faster with a group by clause? Tom Lane (15:06)
Re: select max(field) from table much faster with a group by clause? Palle Girgensohn (15:25)
Re: select max(field) from table much faster with a group by clause? Scott Marlowe (15:28)
Re: select max(field) from table much faster with a group by clause? Tom Lane (15:34)
Re: select max(field) from table much faster with a group by clause? Gregory Stark (15:47)
Re: Hardware for PostgreSQL Steve Crawford (16:20)
Re: Hardware for PostgreSQL Steve Crawford (18:16)
How to avoid hashjoin and mergejoin Carlo Stonebanks (20:57)
Re: How to avoid hashjoin and mergejoin Scott Marlowe (21:38)
Re: How to avoid hashjoin and mergejoin Tom Lane (21:41)

Nov. 2, 2007

Re: Hardware for PostgreSQL Ow Mun Heng (00:26)
hardware for PostgreSQL Mark Floyd (01:15)
Re: hardware for PostgreSQL Scott Marlowe (03:31)
Re: How to avoid hashjoin and mergejoin Carlo Stonebanks (04:12)
Re: select max(field) from table much faster with a group by clause? hubert depesz lubaczewski (07:56)
Unfortunate expansion of composite types in union Jens-Wolfhard Schicke (09:38)
Re: Unfortunate expansion of composite types in union Pavel Stehule (10:32)
Re: select max(field) from table much faster with a group by clause? Palle Girgensohn (10:44)
Re: Hardware for PostgreSQL Jurgen Haan (14:05)
Re: How to avoid hashjoin and mergejoin Carlo Stonebanks (14:46)
Re: [Fwd: Re: Outer joins and Seq scans] Alvaro Herrera (18:45)
[No subject] Mark F (20:03)
Re: Hardware for PostgreSQL (RAID configurations) Mark F (21:23)

Nov. 3, 2007

Union within View vs.Union of Views Jeff Larsen (20:22)
Re: Union within View vs.Union of Views Mark Mielke (21:39)
Re: Union within View vs.Union of Views Heikki Linnakangas (23:03)
"MixedCase sensitive quoted" names Whatever Deep (23:40)

Nov. 4, 2007

Re: Union within View vs.Union of Views Tom Lane (01:38)
Re: "MixedCase sensitive quoted" names Tom Lane (01:45)
Re: Union within View vs.Union of Views Jeff Larsen (01:57)
Re: Union within View vs.Union of Views Jeff Larsen (10:11)
Postgresql.conf Settings smiley2211 (16:28)
Re: Unfortunate expansion of composite types in union Jens-Wolfhard Schicke (16:59)
Re: Postgresql.conf Settings Scott Marlowe (17:37)
Re: Postgresql.conf Settings smiley2211 (18:30)
Re: Postgresql.conf Settings Heikki Linnakangas (19:30)

Nov. 5, 2007

Migrating to 8.3 - checkpoints and background writer Greg Smith (00:33)
Re: Migrating to 8.3 - checkpoints and background writer Steinar H. Gunderson (00:39)
Re: Migrating to 8.3 - checkpoints and background writer Greg Smith (03:06)
Re: partitioned table and ORDER BY indexed_field DESC LIMIT 1 Mark Kirkwood (05:49)
Re: partitioned table and ORDER BY indexed_field DESC LIMIT 1 Gregory Stark (12:12)
hp ciss on freebsd Claus Guttesen (13:19)
Database connections and stored procs (functions) Radhika S (15:32)
Re: hp ciss on freebsd Jeff Trout (15:47)
Re: hp ciss on freebsd Greg Smith (16:32)
index stat Campbell, Lance (16:42)
Training Recommendations Campbell, Lance (16:44)
Re: Migrating to 8.3 - checkpoints and background writer Erik Jones (16:54)
Which index methodology is better?- Chris Hoover (18:43)
Re: Which index methodology is better?- Tom Lane (19:56)
Re: Which index methodology is better?- Heikki Linnakangas (20:07)

Nov. 6, 2007

Re: Database connections and stored procs (functions) Merlin Moncure (02:47)
Is ANALYZE transactional? Craig James (05:12)
Re: Is ANALYZE transactional? Tom Lane (05:30)
dell versus hp Tore Halset (10:12)
Re: dell versus hp Claus Guttesen (11:36)
Re: dell versus hp Dimitri Fontaine (11:53)
Re: dell versus hp Stephen Frost (13:48)
Re: dell versus hp Tore Halset (14:14)
Re: dell versus hp Tore Halset (14:15)
Re: dell versus hp Dimitri Fontaine (15:18)
Re: dell versus hp Greg Smith (18:10)
Subpar Execution Plan Jens-Wolfhard Schicke (20:48)

Nov. 7, 2007

Estimation problem with a LIKE clause containing a / Guillaume Smet (12:53)
Re: Estimation problem with a LIKE clause containing a / Alexander Staubo (13:25)
Re: Estimation problem with a LIKE clause containing a / Guillaume Smet (13:38)
Re: index stat Kevin Grittner (16:32)
Re: Estimation problem with a LIKE clause containing a / Tom Lane (16:34)
Re: Estimation problem with a LIKE clause containing a / Guillaume Smet (16:52)
Re: Estimation problem with a LIKE clause containing a / Tom Lane (16:58)
Re: Estimation problem with a LIKE clause containing a / Tom Lane (23:14)
Re: Estimation problem with a LIKE clause containing a / Guillaume Smet (23:32)
Re: Estimation problem with a LIKE clause containing a / Guillaume Smet (23:36)

Nov. 8, 2007

Re: partitioned table and ORDER BY indexed_field DESC LIMIT 1 Mark Kirkwood (02:46)
Re: partitioned table and ORDER BY indexed_field DESC LIMIT 1 Gregory Stark (06:21)
Re: partitioned table and ORDER BY indexed_field DESC LIMIT 1 Luke Lonergan (06:40)
Re: partitioned table and ORDER BY indexed_field DESC LIMIT 1 Mark Kirkwood (07:18)
Re: Estimation problem with a LIKE clause containing a / Guillaume Smet (10:08)
Need to run CLUSTER to keep performance Rafael Martinez (10:36)
Re: Need to run CLUSTER to keep performance Heikki Linnakangas (11:12)
Re: Need to run CLUSTER to keep performance Tomáš Vondra (11:20)
Re: Need to run CLUSTER to keep performance Rafael Martinez (14:49)
Help understanding stat numbers Chris Hoover (14:49)
Re: Need to run CLUSTER to keep performance Alvaro Herrera (14:56)
Re: Estimation problem with a LIKE clause containing a / Tom Lane (15:01)
Re: Need to run CLUSTER to keep performance Heikki Linnakangas (15:09)
Re: Need to run CLUSTER to keep performance Rafael Martinez (15:10)
Re: Need to run CLUSTER to keep performance Rafael Martinez (15:15)
Re: Need to run CLUSTER to keep performance Bill Moran (15:17)
Re: Estimation problem with a LIKE clause containing a / Guillaume Smet (15:29)
Re: Need to run CLUSTER to keep performance Tom Lane (15:33)
Re: Need to run CLUSTER to keep performance Chris Browne (15:47)
Re: hp ciss on freebsd Vivek Khera (16:37)
Re: dell versus hp Vivek Khera (16:41)
Re: dell versus hp Vivek Khera (16:43)
Re: Hardware for PostgreSQL Robert Treat (17:14)
Re: Estimation problem with a LIKE clause containing a / Tom Lane (17:22)
Re: dell versus hp Scott Marlowe (18:22)
Re: dell versus hp Dimitri Fontaine (20:14)
Re: dell versus hp Kevin Grittner (20:31)
Re: dell versus hp Alan Hodgson (20:56)
Re: dell versus hp Vivek Khera (22:01)
Join performance Pepe Barbe (22:47)
Re: Join performance Steinar H. Gunderson (22:51)
Re: Estimation problem with a LIKE clause containing a / Gregory Stark (23:10)
Re: dell versus hp Scott Marlowe (23:24)

Nov. 9, 2007

Re: Join performance Tom Lane (00:15)
Re: Join performance Tom Lane (00:15)
Re: Join performance Tom Lane (00:15)
Re: Join performance Tom Lane (00:15)
Re: Estimation problem with a LIKE clause containing a / Tom Lane (00:40)
Re: Join performance Tom Lane (00:42)
Re: [HACKERS] Estimation problem with a LIKE clause containing a / Tom Lane (02:08)
Re: Help understanding stat numbers Tom Lane (07:08)
Re: [HACKERS] Estimation problem with a LIKE clause containing a / Guillaume Smet (07:52)
Re: [HACKERS] Estimation problem with a LIKE clause containing a / Gregory Stark (09:21)
Re: dell versus hp Florian Weimer (11:30)
PostgreSQL vs MySQL, and FreeBSD Ivan Voras (12:06)
Re: PostgreSQL vs MySQL, and FreeBSD Jonah H. Harris (14:49)
Re: PostgreSQL vs MySQL, and FreeBSD Sebastian Hennebrueder (15:41)
Re: PostgreSQL vs MySQL, and FreeBSD Erik Jones (15:50)
Re: PostgreSQL vs MySQL, and FreeBSD Scott Marlowe (15:57)
Re: dell versus hp Jurgen Haan (16:01)
Re: PostgreSQL vs MySQL, and FreeBSD Greg Smith (16:11)
Re: [HACKERS] Estimation problem with a LIKE clause containing a / Tom Lane (16:33)
Re: [HACKERS] Estimation problem with a LIKE clause containing a / Guillaume Smet (16:39)
Re: dell versus hp Claus Guttesen (16:40)
Re: dell versus hp Scott Marlowe (16:55)
work_mem and shared_buffers Campbell, Lance (17:49)
Re: work_mem and shared_buffers Heikki Linnakangas (17:56)
Re: dell versus hp Greg Smith (18:03)
Re: work_mem and shared_buffers Campbell, Lance (18:08)
Re: PostgreSQL vs MySQL, and FreeBSD Bill Moran (19:04)
Re: work_mem and shared_buffers Campbell, Lance (19:05)
Re: dell versus hp Vivek Khera (19:08)
Re: work_mem and shared_buffers Scott Marlowe (19:12)
Re: work_mem and shared_buffers Campbell, Lance (19:19)
Re: work_mem and shared_buffers Scott Marlowe (19:24)
Re: PostgreSQL vs MySQL, and FreeBSD Ron Mayer (19:44)
Re: work_mem and shared_buffers Bill Moran (20:08)
Re: work_mem and shared_buffers Erik Jones (20:38)
Re: work_mem and shared_buffers Scott Marlowe (20:47)
Re: [HACKERS] Estimation problem with a LIKE clause containing a / Guillaume Smet (20:57)
Can I Determine if AutoVacuum Does Anything? David Crane (21:44)
Re: Can I Determine if AutoVacuum Does Anything? Alvaro Herrera (21:49)

Nov. 10, 2007

Re: Join performance Russell Smith (05:26)
Curious about dead rows. Jean-David Beyer (16:27)
Re: Curious about dead rows. Tom Lane (17:08)
Re: Curious about dead rows. Jean-David Beyer (18:38)
Re: Curious about dead rows. Joshua D. Drake (18:51)
Re: Curious about dead rows. Jean-David Beyer (19:57)

Nov. 11, 2007

Re: Curious about dead rows. Scott Marlowe (02:11)
Re: Curious about dead rows. Jean-David Beyer (02:22)
Re: PostgreSQL vs MySQL, and FreeBSD Dimitri (19:27)
Re: PostgreSQL vs MySQL, and FreeBSD Joshua D. Drake (20:17)
Re: PostgreSQL vs MySQL, and FreeBSD Steinar H. Gunderson (23:43)

Nov. 12, 2007

Clustered/covering indexes (or lack thereof :-) adrobj (06:59)
Re: work_mem and shared_buffers Cédric Villemain (10:17)
Re: PostgreSQL vs MySQL, and FreeBSD Shane Ambler (10:23)
difference between a unique constraint and a unique index ??? Dave Cramer (14:51)
Re: difference between a unique constraint and a uniqueindex ??? Alvaro Herrera (14:56)
Re: difference between a unique constraint and a unique index ??? Dave Cramer (15:13)
Re: PostgreSQL vs MySQL, and FreeBSD Erik Jones (15:22)
Re: Need to run CLUSTER to keep performance Rafael Martinez (15:38)
Re: Need to run CLUSTER to keep performance Rafael Martinez (16:11)
Re: Need to run CLUSTER to keep performance Heikki Linnakangas (16:31)
Re: Curious about dead rows. Andrew Sullivan (16:32)
Re: Need to run CLUSTER to keep performance Scott Marlowe (16:35)
Re: difference between a unique constraint and a unique index ??? Tom Lane (16:37)
Re: Need to run CLUSTER to keep performance Bill Moran (16:37)
Re: Need to run CLUSTER to keep performance Heikki Linnakangas (17:01)
Re: Need to run CLUSTER to keep performance Scott Marlowe (17:04)
Re: Need to run CLUSTER to keep performance Heikki Linnakangas (18:03)
Re: difference between a unique constraint and a unique index ??? Dave Cramer (18:32)
ERROR: "invalid memory alloc request size" or "unexpected end of data" on large table Stephane Bailliez (19:57)
Re: ERROR: "invalid memory alloc request size" or "unexpected end of data" on large table Tom Lane (22:54)

Nov. 13, 2007

Re: Need to run CLUSTER to keep performance Rafael Martinez (08:49)
Re: Need to run CLUSTER to keep performance Rafael Martinez (09:03)
random_page_cost etc. per tablespace? Jens-Wolfhard Schicke (10:24)
Re: ERROR: "invalid memory alloc request size" or "unexpected end of data" on large table Stephane Bailliez (15:06)
Re: Curious about dead rows. Andrew Sullivan (15:21)
Re: dell versus hp Alan Hodgson (15:49)
Re: Curious about dead rows. Jean-David Beyer (19:50)
Re: dell versus hp Jeff Frost (20:32)
Re: Curious about dead rows. Andrew Sullivan (21:35)
Re: Curious about dead rows. Andrew Sullivan (22:10)

Prev | Next

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

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