Search

Peripheral Links

• Home
• About
• Download
• Documentation
• Community
• Developers
• Support
• Your account

pgsql-performance - February 2008

Search archives
	(enter a message-id to go directly to that message)	Advanced Search

Prev | Next

2008-02-01

• Storage space usage Gangadharan S.A. (08:44)

2008-02-02

• Re: Storage space usage Decibel! (06:37)

2008-02-03

• slow 8.2.6 with 50 connections Pavel Stehule (16:02)
• Re: slow 8.2.6 with 50 connections Scott Marlowe (18:58)
• Re: slow 8.2.6 with 50 connections Pavel Stehule (19:35)
• Re: slow 8.2.6 with 50 connections Greg Smith (21:17)

2008-02-04

• Benchmark Data requested Simon Riggs (18:37)
• Re: Benchmark Data requested Luke Lonergan (18:47)
• Re: Benchmark Data requested Claus Guttesen (18:50)
• Re: Benchmark Data requested Simon Riggs (19:07)
• Re: Benchmark Data requested Greg Smith (20:09)
• Re: Benchmark Data requested Simon Riggs (20:21)
• Re: Benchmark Data requested Luke Lonergan (22:32)
• Re: Benchmark Data requested Jignesh K. Shah (22:33)
• Re: Benchmark Data requested Luke Lonergan (22:34)
• Re: Benchmark Data requested Jignesh K. Shah (22:55)
• Re: Benchmark Data requested Greg Smith (22:56)
• Re: Benchmark Data requested Greg Smith (23:37)

2008-02-05

• Re: Benchmark Data requested Gregory Stark (00:10)
• Re: Benchmark Data requested Gregory Stark (00:17)
• Re: Benchmark Data requested Jignesh K. Shah (00:49)
• Re: Benchmark Data requested Jignesh K. Shah (00:57)
• Re: Benchmark Data requested Simon Riggs (08:45)
• Re: Benchmark Data requested Simon Riggs (09:08)
• Re: Performance problems inside a stored procedure. Matthew Lunnon (09:32)
• Performance issue using Tsearch2 Viviane Lestic (11:47)
• Re: Performance issue using Tsearch2 Ansgar -59cobalt- Wiechers (13:36)
• Re: Performance issue using Tsearch2 Guillaume Smet (13:48)
• Re: Benchmark Data requested Dimitri Fontaine (14:06)
• Re: Benchmark Data requested Simon Riggs (14:24)
• Re: Benchmark Data requested Matthew (14:29)
• Re: Benchmark Data requested Richard Huxton (14:43)
• Re: Benchmark Data requested Matthew (14:51)
• Re: Benchmark Data requested Matthew (14:53)
• Re: Benchmark Data requested Simon Riggs (14:54)
• Re: Benchmark Data requested Richard Huxton (15:05)
• Re: Performance issue using Tsearch2 Viviane Lestic (15:08)
• Re: Benchmark Data requested Matthew (15:25)
• Re: Benchmark Data requested Simon Riggs (15:26)
• Re: Benchmark Data requested Richard Huxton (15:52)
• Re: Benchmark Data requested Matthew (15:57)
• Re: Benchmark Data requested Richard Huxton (15:59)
• Re: Benchmark Data requested Richard Huxton (16:09)
• Re: Benchmark Data requested Jignesh K. Shah (16:14)
• Re: Benchmark Data requested Matthew (16:18)
• Re: Benchmark Data requested Dimitri Fontaine (17:01)
• Re: Benchmark Data requested Dimitri Fontaine (17:15)
• Re: Benchmark Data requested Simon Riggs (17:32)
• Re: Benchmark Data requested Jignesh K. Shah (18:47)
• Re: Benchmark Data requested Simon Riggs (19:48)
• Re: Benchmark Data requested Heikki Linnakangas (20:06)
• Re: Benchmark Data requested Jignesh K. Shah (20:45)
• Re: Benchmark Data requested Jignesh K. Shah (20:50)
• Re: Benchmark Data requested Heikki Linnakangas (21:45)
• Re: Benchmark Data requested Simon Riggs (22:00)

2008-02-06

• Re: Benchmark Data requested Greg Smith (03:35)
• Re: Benchmark Data requested NikhilS (07:38)
• Optimizer : query rewrite and execution plan ? SURANTYN Jean François (08:42)
• Re: Optimizer : query rewrite and execution plan ? Richard Huxton (09:47)
• Re: Optimizer : query rewrite and execution plan ? SURANTYN Jean François (10:02)
• Re: Optimizer : query rewrite and execution plan ? Richard Huxton (10:06)
• Re: Benchmark Data requested Dimitri Fontaine (10:29)
• Re: Benchmark Data requested --- pgloader CE design ideas Dimitri Fontaine (11:27)
• Re: Benchmark Data requested --- pgloader CE design ideas Simon Riggs (11:45)
• Re: Optimizer : query rewrite and execution plan ? Simon Riggs (11:53)
• Re: Optimizer : query rewrite and execution plan ? Theo Kramer (12:12)
• Re: Benchmark Data requested --- pgloader CE design ideas Dimitri Fontaine (12:36)
• Re: Optimizer : query rewrite and execution plan ? Roberts, Jon (13:35)
• Re: Optimizer : query rewrite and execution plan ? Erik Jones (15:27)
• Re: Optimizer : query rewrite and execution plan ? Roberts, Jon (15:35)
• Re: Benchmark Data requested Greg Smith (15:40)
• Re: Benchmark Data requested --- pgloader CE design ideas Greg Smith (15:56)
• Re: Optimizer : query rewrite and execution plan ? Tom Lane (16:00)
• Re: Benchmark Data requested --- pgloader CE design ideas Luke Lonergan (16:17)
• Re: Benchmark Data requested --- pgloader CE design ideas Jignesh K. Shah (16:34)
• Re: Benchmark Data requested Dimitri Fontaine (17:31)
• Re: Benchmark Data requested --- pgloader CE design ideas Dimitri Fontaine (17:37)
• Re: Benchmark Data requested --- pgloader CE design ideas Luke Lonergan (17:49)
• Re: Benchmark Data requested --- pgloader CE design ideas Dimitri Fontaine (19:59)
• Re: Benchmark Data requested --- pgloader CE design ideas Dimitri Fontaine (20:04)
• Re: Benchmark Data requested --- pgloader CE design ideas Greg Smith (23:36)

2008-02-07

• Re: Benchmark Data requested --- pgloader CE design ideas Dimitri Fontaine (09:31)
• Index Scan Backward + check additional condition before heap access Markus Bertheau (14:51)
• Re: Benchmark Data requested --- pgloader CE design ideas Greg Smith (17:06)
• Re: Benchmark Data requested --- pgloader CE design ideas Matthew (17:11)
• Re: Benchmark Data requested --- pgloader CE design ideas Mark Lewis (17:14)
• Re: Benchmark Data requested --- pgloader CE design ideas Kenneth Marshall (17:15)
• index usage on arrays andrew klassen (18:38)
• Re: index usage on arrays Oleg Bartunov (18:55)
• Re: index usage on arrays Tom Lane (19:01)

2008-02-08

• Wrong number of rows estimation by the planner Yonatan Ben-Nes (12:12)
• Re: Benchmark Data requested Mark Wong (20:12)
• Re: Benchmark Data requested Mark Wong (20:16)
• Parallel inserts Ivan Voras (20:59)

2008-02-09

• Re: Parallel inserts Bruce Momjian (04:19)

2008-02-11

• Re: Optimizer : query rewrite and execution plan ? Simon Riggs (09:44)
• Update with Subquery Performance Linux Guru (11:06)
• Re: Optimizer : query rewrite and execution plan ? Tom Lane (16:44)
• Re: Update with Subquery Performance Tom Lane (16:59)
• Join Query Perfomance Issue Thomas Zaksek (18:08)
• Question about CLUSTER salman (20:03)
• Re: Update with Subquery Performance Scott Marlowe (21:29)
• Re: [PERFORM] Question about CLUSTER Scott Marlowe (21:33)
• Re: Join Query Perfomance Issue Scott Marlowe (21:37)
• Re: Join Query Perfomance Issue Scott Marlowe (21:38)
• mis-estimate in nested query causes slow runtimes Chris Kratz (22:24)
• Re: mis-estimate in nested query causes slow runtimes Tom Lane (23:07)
• Questions about enabling SSL fabrix peñuelas (23:58)

2008-02-12

• Re: Questions about enabling SSL Michael Fuhr (00:37)
• Re: Questions about enabling SSL Michael Fuhr (01:00)
• Re: [PERFORM] Question about CLUSTER Michael Fuhr (02:42)
• Re: Update with Subquery Performance Linux Guru (08:32)
• Re: Update with Subquery Performance Linux Guru (08:46)
• Re: Join Query Perfomance Issue Thomas Zaksek (10:11)
• Re: mis-estimate in nested query causes slow runtimes Chris Kratz (14:02)
• Re: mis-estimate in nested query causes slow runtimes Chris Kratz (15:09)
• Re: Update with Subquery Performance Tom Lane (16:18)
• Dell Perc/6 Craig James (16:32)
• Re: Questions about enabling SSL fabrix peñuelas (17:46)
• Re: Dell Perc/6 Greg Smith (19:01)
• Re: Join Query Perfomance Issue Peter Koczan (20:34)
• Optimizing No matching record Queries Pallav Kalva (21:35)
• Re: Optimizing No matching record Queries Stephen Denne (22:09)

2008-02-13

• Re: Optimizing No matching record Queries Dean Gibson (DB Administrator) (00:07)
• Re: Optimizing No matching record Queries Gregory Stark (00:16)
• Re: Optimizing No matching record Queries Richard Huxton (08:54)
• Re: Dell Perc/6 Tore Halset (10:02)
• Re: Update with Subquery Performance Linux Guru (10:59)
• Re: Dell Perc/6 Dave Cramer (11:06)
• Re: Join Query Perfomance Issue Thomas Zaksek (11:17)
• Re: Join Query Perfomance Issue Thomas Zaksek (11:45)
• Small DB Server Advice Rory Campbell-Lange (13:12)
• Re: Small DB Server Advice Matthew (13:53)
• Creating and updating table using function parameter reference Linux Guru (14:25)
• Re: Small DB Server Advice Magnus Hagander (14:32)
• Re: Small DB Server Advice Matthew (14:35)
• Re: Creating and updating table using function parameter reference Albert Cervera Areny (15:23)
• Re: Join Query Perfomance Issue Tom Lane (15:48)
• Re: Dell Perc/6 Merlin Moncure (15:56)
• Anyone using a SAN? Peter Koczan (16:56)
• Re: Small DB Server Advice Greg Smith (17:38)
• Re: Anyone using a SAN? Kenneth Marshall (17:46)
• Re: Join Query Perfomance Issue Thomas Zaksek (17:46)
• HOT TOAST? Josh Berkus (17:50)
• Re: Anyone using a SAN? Alex Deucher (17:58)
• Re: HOT TOAST? Tom Lane (18:04)
• Re: Dell Perc/6 Tore Halset (19:45)
• Re: Optimizing No matching record Queries Pallav Kalva (19:46)
• Re: Dell Perc/6 Tore Halset (20:28)
• Re: Optimizing No matching record Queries Gregory Stark (20:51)
• Re: Anyone using a SAN? Tobias Brox (21:06)
• Re: Join Query Perfomance Issue Scott Marlowe (21:36)
• Re: Anyone using a SAN? Arjen van der Meijden (22:20)
• Re: Anyone using a SAN? Greg Smith (23:02)
• Re: HOT TOAST? Josh Berkus (23:07)
• Re: Anyone using a SAN? Tobias Brox (23:29)

2008-02-14

• Re: Anyone using a SAN? Scott Marlowe (00:55)
• Re: Anyone using a SAN? Bruce Momjian (03:23)
• Re: Anyone using a SAN? Peter Koczan (04:17)
• Re: Anyone using a SAN? Greg Stark (10:12)
• Re: Join Query Perfomance Issue Thomas Zaksek (10:57)
• Re: Creating and updating table using function parameter reference Linux Guru (12:35)
• Re: Creating and updating table using function parameter reference Albert Cervera Areny (12:54)
• Query slows after offset of 100K Michael Lorenz (18:28)
• Re: Query slows after offset of 100K Tom Lane (19:08)
• Re: Query slows after offset of 100K Michael Lorenz (19:49)
• Re: Query slows after offset of 100K Mark Lewis (20:32)
• Re: Query slows after offset of 100K Tom Lane (21:55)
• Re: Join Query Perfomance Issue Chris (23:48)
• Re: Query slows after offset of 100K Greg Smith (23:54)

2008-02-15

• Re: Query slows after offset of 100K Tom Lane (00:02)
• Avoid long-running transactions in a long-running stored procedure? David Crane (01:15)
• Re: Avoid long-running transactions in a long-running stored procedure? Josh Berkus (01:29)
• Re: Avoid long-running transactions in a long-runningstored procedure? Ow Mun Heng (01:30)
• Re: Avoid long-running transactions in a long-runningstored procedure? David Crane (01:38)
• shared_buffers in 8.3 w/ lots of RAM on dedicated PG machine Peter Schuller (12:35)
• Re: shared_buffers in 8.3 w/ lots of RAM on dedicated PGmachine Kenneth Marshall (13:37)
• Re: shared_buffers in 8.3 w/ lots of RAM on dedicated PGmachine Peter Schuller (13:58)
• Re: Creating and updating table using function parameter reference Linux Guru (14:14)
• Re: shared_buffers in 8.3 w/ lots of RAM on dedicated PG machine Greg Smith (14:29)
• Re: Query slows after offset of 100K Matthew (14:47)
• Re: shared_buffers in 8.3 w/ lots of RAM on dedicated PG machine Josh Berkus (18:06)
• Re: shared_buffers in 8.3 w/ lots of RAM on dedicated PG machine Erik Jones (18:37)
• Re: shared_buffers in 8.3 w/ lots of RAM on dedicated PG machine Joshua D. Drake (18:42)
• Re: shared_buffers in 8.3 w/ lots of RAM on dedicated PG machine Jignesh K. Shah (19:34)
• Re: shared_buffers in 8.3 w/ lots of RAM on dedicated PG machine Erik Jones (19:46)
• wal_sync_methods for AIX Dan Langille (21:55)
• Re: wal_sync_methods for AIX Joshua D. Drake (22:04)
• Re: wal_sync_methods for AIX Erik Jones (22:20)

2008-02-16

• Re: Anyone using a SAN? Greg Smith (06:08)

2008-02-17

• Example web access to Postgres DB Mohamed Ali JBELI (11:21)
• Re: Example web access to Postgres DB Tino Wildenhain (13:53)
• Re: Example web access to Postgres DB Bill Moran (15:18)
• Re: Example web access to Postgres DB Dave Cramer (16:12)
• Re: Example web access to Postgres DB Adam Tauno Williams (16:22)

2008-02-18

• Re: shared_buffers in 8.3 w/ lots of RAM on dedicated PG machine Peter Schuller (07:39)
• Disable WAL completely Kathirvel, Jeevanandam (09:11)
• Re: Disable WAL completely hubert depesz lubaczewski (09:19)
• Re: Disable WAL completely A. Kretschmer (09:24)
• Re: Disable WAL completely Kathirvel, Jeevanandam (09:30)

Prev | Next