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

Prev | Next

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

2007-09-01

Re: Fwd: 8.2 Query 10 times slower than 8.1 (view-heavy) Mark Lewis (00:09)
schemas to limit data access Brennan, Sean (IMS) (03:02)
schemas to limit data access Brennan, Sean (IMS) (03:02)
schemas to limit data access Brennan, Sean (IMS) (03:08)
Slow Query Shawn (17:29)
Re: Slow Query Tom Lane (18:09)
Re: Slow Query Shawn (20:18)
Re: Performance issue with nested loop Decibel! (23:50)

2007-09-02

Re: Slow Query Shawn (00:35)
Re: Slow Query Tom Lane (03:00)
Re: Slow Query Kevin Grittner (15:49)

2007-09-03

Re: Slow Query Shawn (16:15)
Re: Slow Query Shawn (16:57)
Re: Slow Query Kevin Grittner (18:07)
Re: Slow Query Kevin Grittner (18:32)
Re: Slow Query Shawn (23:53)

2007-09-04

Re: Slow Query Tom Lane (00:49)
Re: schemas to limit data access Merlin Moncure (01:08)
Re: Slow Query Kevin Grittner (02:40)
Vacum Analyze problem rafael (17:27)
Re: Vacum Analyze problem Mikko Partio (17:33)
Re: Vacum Analyze problem Kevin Kempter (17:45)
Re: Vacum Analyze problem rafael (17:46)
Re: Vacum Analyze problem Bill Moran (17:55)
About autovacuum Jean-David Beyer (18:39)
Re: Vacum Analyze problem rafael (18:46)
Re: Vacum Analyze problem Richard Broersma Jr (18:52)
join tables vs. denormalization by trigger Walter Mauritz (18:53)
Re: About autovacuum Bill Moran (19:01)
Re: join tables vs. denormalization by trigger Mark Lewis (19:18)
Performance on 8CPU's and 32GB of RAM Carlo Stonebanks (22:45)
Re: join tables vs. denormalization by trigger Marc Mamin (22:48)
Re: Performance on 8CPU's and 32GB of RAM Scott Marlowe (23:03)
Re: Performance on 8CPU's and 32GB of RAM Alvaro Herrera (23:06)
Re: Performance on 8CPU's and 32GB of RAM Scott Marlowe (23:15)
Re: Vacum Analyze problem Gregory Stark (23:24)

2007-09-05

No pg_dumplo on 8.2.4 Daniel Rubio (07:31)
Re: Performance on 8CPU's and 32GB of RAM Hannes Dorbath (08:20)
optimize query with a maximum(date) extraction JS Ubei (09:53)
FW: optimize query with a maximum(date) extraction Gregory Williamson (11:06)
Re: optimize query with a maximum(date) extraction Gregory Stark (11:30)
Re: optimize query with a maximum(date) extraction Gregory Stark (12:06)
Re: optimize query with a maximum(date) extraction Peter Childs (12:43)
Re: optimize query with a maximum(date) extraction Pavel Stehule (12:48)
Re : optimize query with a maximum(date) extraction JS Ubei (13:11)
Re: optimize query with a maximum(date) extraction hubert depesz lubaczewski (13:22)
Re: optimize query with a maximum(date) extraction Gregory Stark (14:14)
Re: optimize query with a maximum(date) extraction Gregory Stark (14:23)
Re: optimize query with a maximum(date) extraction Gregory Stark (14:28)
Re: No pg_dumplo on 8.2.4 Tom Lane (15:03)
Re: Performance on 8CPU's and 32GB of RAM Carlo Stonebanks (15:06)
Re: Performance on 8CPU's and 32GB of RAM Scott Marlowe (15:15)
Re: Performance on 8CPU's and 32GB of RAM Carlo Stonebanks (15:23)
Re: optimize query with a maximum(date) extraction Tom Lane (15:23)
Re: Performance on 8CPU's and 32GB of RAM Scott Marlowe (15:45)
Re: Performance on 8CPU's and 32GB of RAM Carlo Stonebanks (15:57)
Re: Performance on 8CPU's and 32GB of RAM Alvaro Herrera (16:03)
Re: Performance on 8CPU's and 32GB of RAM Scott Marlowe (16:06)
Re: Performance on 8CPU's and 32GB of RAM Trevor Talbot (17:16)
Re: Performance on 8CPU's and 32GB of RAM Ron Mayer (18:09)
Re: Performance on 8CPU's and 32GB of RAM Scott Marlowe (19:29)
Re: Performance on 8CPU's and 32GB of RAM Scott Marlowe (19:36)
Re: Performance on 8CPU's and 32GB of RAM Ansgar -59cobalt- Wiechers (21:02)
Re: Performance on 8CPU's and 32GB of RAM Trevor Talbot (21:08)
Re: Performance on 8CPU's and 32GB of RAM Scott Marlowe (21:59)
Re: Performance on 8CPU's and 32GB of RAM Adam Tauno Williams (22:15)
Postgres with Sun Cluster HA/Solaris 10 Subbiah Stalin-XCGF84 (22:33)
utilising multi-cpu/core machines? Thomas Finneid (22:41)
RESEND:Postgres with Sun Cluster HA/Solaris 10 Subbiah Stalin-XCGF84 (22:48)
Re: utilising multi-cpu/core machines? Jonah H. Harris (23:02)
Re: Performance on 8CPU's and 32GB of RAM Ansgar -59cobalt- Wiechers (23:19)

2007-09-06

Re: utilising multi-cpu/core machines? Trevor Talbot (00:07)
Re: Performance on 8CPU's and 32GB of RAM Scott Marlowe (00:12)
Re: Performance on 8CPU's and 32GB of RAM Joshua D. Drake (02:50)
Re: Performance on 8CPU's and 32GB of RAM Ansgar -59cobalt- Wiechers (06:47)
Hardware spec Willo van der Merwe (06:54)
Re: Hardware spec Richard Huxton (08:17)
Re: Hardware spec Willo van der Merwe (09:26)
Re: Hardware spec Jean-David Beyer (11:16)
Re: Hardware spec Willo van der Merwe (11:37)
SAN vs Internal Disks Harsh Azad (12:35)
ADO -PostgreSQL OLE DB Provider Jayaram Bhat (13:15)
Re: utilising multi-cpu/core machines? Kevin Grittner (13:46)
Re: Hardware spec Florian Weimer (14:19)
Re: Hardware spec Willo van der Merwe (14:33)
Re: SAN vs Internal Disks Mark Lewis (14:42)
Re: Hardware spec] Jean-David Beyer (15:00)
Re: Hardware spec Florian Weimer (15:21)
postgres memory management issues? Richard Yen (16:06)
Re: ADO -PostgreSQL OLE DB Provider Richard Broersma Jr (16:08)
Re: SAN vs Internal Disks Scott Marlowe (16:25)
Re: SAN vs Internal Disks Harsh Azad (16:58)
Re: SAN vs Internal Disks Harsh Azad (17:03)
Re: SAN vs Internal Disks Joshua D. Drake (17:12)
Re: SAN vs Internal Disks Arjen van der Meijden (17:39)
Re: SAN vs Internal Disks Scott Marlowe (18:07)
Re: SAN vs Internal Disks Harsh Azad (18:15)
Re: SAN vs Internal Disks Mark Lewis (18:29)
Re: SAN vs Internal Disks Scott Marlowe (18:42)
Re: SAN vs Internal Disks Joe Uhl (19:02)
Re: SAN vs Internal Disks Joel Fradkin (19:14)
Re: SAN vs Internal Disks Arjen van der Meijden (19:38)
Re: SAN vs Internal Disks Arjen van der Meijden (19:40)
Reasonable amount of indices Patric (20:08)
Re: Performance on 8CPU's and 32GB of RAM James Mansion (20:30)
Re: Performance on 8CPU's and 32GB of RAM James Mansion (20:39)
Re: Performance on 8CPU's and 32GB of RAM Carlo Stonebanks (20:46)
Re: Performance on 8CPU's and 32GB of RAM James Mansion (20:55)
Re: Performance on 8CPU's and 32GB of RAM Scott Marlowe (20:59)
Re: Performance on 8CPU's and 32GB of RAM Alvaro Herrera (21:21)
Re: Reasonable amount of indices Alvaro Herrera (22:09)
Re: SAN vs Internal Disks Scott Marlowe (22:35)
Re: Performance on 8CPU's and 32GB of RAM Carlo Stonebanks (23:18)
Re: Reasonable amount of indices Tom Lane (23:18)

2007-09-07

How planner decides left-anchored LIKE can use index Carlo Stonebanks (00:06)
Re: How planner decides left-anchored LIKE can use index Tom Lane (00:28)
Re: SAN vs Internal Disks Greg Smith (04:26)
Re: SAN vs Internal Disks Florian Weimer (08:14)
Re: Performance on 8CPU's and 32GB of RAM Florian Weimer (08:17)
Re: Postgres with Sun Cluster HA/Solaris 10 Markus Schiltknecht (08:23)
Re: postgres memory management issues? Richard Huxton (08:42)
Re: postgres memory management issues? Claus Guttesen (09:01)
Re: postgres memory management issues? Gregory Stark (09:31)
DRBD and Postgres: how to improve the perfomance? Maila Fatticcioni (09:37)
Re: postgres memory management issues? Florian Weimer (09:38)
Re: utilising multi-cpu/core machines? Sven Geisler (09:50)
Re: SAN vs Internal Disks Michael Stone (10:04)
Re: postgres memory management issues? Michael Stone (10:11)
Re: DRBD and Postgres: how to improve the perfomance? Heikki Linnakangas (10:12)
Re: SAN vs Internal Disks Tobias Brox (10:33)
Re: DRBD and Postgres: how to improve the perfomance? Merlin Moncure (12:56)
Re: SAN vs Internal Disks Michael Stone (13:16)
Re: postgres memory management issues? Tom Lane (14:56)
Re: Performance on 8CPU's and 32GB of RAM Scott Marlowe (16:16)
Re: SAN vs Internal Disks Matthew Schumacher (17:21)
Re: Performance on 8CPU's and 32GB of RAM Harald Armin Massa (17:32)
Re: SAN vs Internal Disks Bryan Murphy (17:56)
Re: SAN vs Internal Disks Alan Hodgson (18:18)
Re: SAN vs Internal Disks Brian Hurt (18:21)
Re: SAN vs Internal Disks Joshua D. Drake (18:21)
Re: DRBD and Postgres: how to improve the perfomance? Simon Riggs (19:00)
Re: Postgres with Sun Cluster HA/Solaris 10 Subbiah Stalin-XCGF84 (19:24)
Re: SAN vs Internal Disks Greg Smith (20:04)
Re: SAN vs Internal Disks Vivek Khera (20:35)
Re: SAN vs Internal Disks david (21:10)
Re: SAN vs Internal Disks Joshua D. Drake (21:15)
Re: DRBD and Postgres: how to improve the perfomance? Bernd Helmle (21:54)

2007-09-08

Re: DRBD and Postgres: how to improve the perfomance? Simon Riggs (06:28)
Re: optimize query with a maximum(date) extraction Dimitri (08:00)
Re: DRBD and Postgres: how to improve the perfomance? Gregory Stark (10:04)
Re: DRBD and Postgres: how to improve the perfomance? Joshua D. Drake (16:15)
Re: DRBD and Postgres: how to improve the perfomance? Stefan Kaltenbrunner (16:33)
Re: DRBD and Postgres: how to improve the perfomance? Tom Lane (16:39)
Re: DRBD and Postgres: how to improve the perfomance? Gregory Stark (16:49)
Re: DRBD and Postgres: how to improve the perfomance? Joshua D. Drake (16:53)
Re: DRBD and Postgres: how to improve the perfomance? Joshua D. Drake (17:02)
Re: DRBD and Postgres: how to improve the perfomance? Stefan Kaltenbrunner (17:25)
Re: DRBD and Postgres: how to improve the perfomance? Gregory Stark (17:32)
Re: DRBD and Postgres: how to improve the perfomance? Bernd Helmle (18:22)
Re: DRBD and Postgres: how to improve the perfomance? Joshua D. Drake (21:25)
Re: DRBD and Postgres: how to improve the perfomance? Joshua D. Drake (21:30)

2007-09-10

Re: Slow Query Shawn (01:31)
Re: DRBD and Postgres: how to improve the perfomance? Greg Smith (04:06)
Re: DRBD and Postgres: how to improve the perfomance? Tom Lane (04:54)
random_page_costs - are defaults of 4.0 realistic for SCSI RAID 1 Carlo Stonebanks (19:25)
Re: random_page_costs - are defaults of 4.0 realistic for SCSI RAID 1 Luke Lonergan (20:19)
Re: random_page_costs - are defaults of 4.0 realistic for SCSI RAID 1 Mark Mielke (20:52)
Re: random_page_costs - are defaults of 4.0 realistic for SCSI RAID 1 Josh Berkus (21:26)
Re: random_page_costs - are defaults of 4.0 realistic for SCSI RAID 1 Gregory Stark (21:44)
Re: random_page_costs - are defaults of 4.0 realistic for SCSI RAID 1 Scott Marlowe (21:59)
Re: random_page_costs - are defaults of 4.0 realisticfor SCSI RAID 1 Jeff Davis (22:03)
Re: random_page_costs - are defaults of 4.0 realistic for SCSI RAID 1 Mark Mielke (22:08)
Re: random_page_costs - are defaults of 4.0 realistic for SCSI RAID 1 Mark Mielke (22:22)
Re: random_page_costs - are defaults of 4.0 realistic for SCSI RAID 1 Luke Lonergan (22:45)
Re: random_page_costs - are defaults of 4.0 realistic for SCSI RAID 1 Luke Lonergan (22:46)

2007-09-11

What to vacuum after deleting lots of tables Craig James (04:12)
Re: What to vacuum after deleting lots of tables Tom Lane (04:23)
[Again] Postgres performance problem Ruben Rubio (06:33)
Re: random_page_costs - are defaults of 4.0 realistic for SCSI RAID 1 Gregory Stark (07:28)
Re: [Again] Postgres performance problem db (07:31)
Re: random_page_costs - are defaults of 4.0 realistic for SCSI RAID 1 Luke Lonergan (07:33)
Re: [Again] Postgres performance problem Ruben Rubio (07:49)
Barcelona vs Tigerton Mindaugas (07:57)
Re: Barcelona vs Tigerton Luke Lonergan (08:31)
Re: random_page_costs - are defaults of 4.0 realistic for SCSI RAID 1 Heikki Linnakangas (09:00)
Re: random_page_costs - are defaults of 4.0 realistic for SCSI RAID 1 Jean-David Beyer (11:07)
Re: DRBD and Postgres: how to improve the perfomance? Maila Fatticcioni (14:47)
Re: DRBD and Postgres: how to improve the perfomance? Steinar H. Gunderson (14:57)
Re: Barcelona vs Tigerton Greg Smith (15:11)
More Vacuum questions... Kevin Kempter (16:24)
500rows = 1min/2.5k rows=20min/6K rows 2 hours and still running El-Lotso (16:57)
Re: 500rows = 1min/2.5k rows=20min/6K rows 2 hours and stillrunning El-Lotso (17:02)
Re: More Vacuum questions... Heikki Linnakangas (17:29)
Re: random_page_costs - are defaults of 4.0 realistic for SCSI RAID 1 Gregory Stark (18:16)
Re: Re: 500rows = 1min/2.5k rows=20min/6K rows 2 hours and still running Tom Lane (18:23)
Re: DRBD and Postgres: how to improve the perfomance? Mario Weilguni (18:26)
Re: random_page_costs - are defaults of 4.0 realistic for SCSI RAID 1 Jean-David Beyer (18:49)
efficient pattern queries (using LIKE, ~) Fernan Aguero (18:54)
Re: efficient pattern queries (using LIKE, ~) Mario Weilguni (19:08)
Re: Barcelona vs Tigerton Guy Rouillier (19:52)

Prev | Next

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

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