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 - May 2010

Prev | Next

Jump to day: 1 3 5 6 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

2010-05-01

Re: autovacuum strategy / parameters Alvaro Herrera (03:08)
Re: Optimization idea Cédric Villemain (10:52)
Re: autovacuum strategy / parameters Robert Haas (11:39)
Re: Optimization idea Cédric Villemain (12:00)
Re: autovacuum strategy / parameters Scott Marlowe (16:08)
Re: autovacuum strategy / parameters Scott Marlowe (16:13)
Re: autovacuum strategy / parameters Greg Smith (17:11)
Re: autovacuum strategy / parameters Tom Lane (17:25)
Re: autovacuum strategy / parameters Robert Haas (19:08)
Re: autovacuum strategy / parameters Scott Marlowe (19:17)
Re: autovacuum strategy / parameters Scott Marlowe (19:19)
Re: autovacuum strategy / parameters Robert Haas (19:20)

2010-05-03

Re: Planner issue on sorting joining of two tables with limit Alexander Korotkov (13:57)

2010-05-05

partioning tips? Richard Yen (20:25)
Re: partioning tips? Dave Crooke (21:31)

2010-05-06

PgPool II configuration with PostgreSQL 8.4 Neha Mehta (04:17)
Re: PgPool II configuration with PostgreSQL 8.4 Marcos Ortiz (06:29)
Re: Planner issue on sorting joining of two tables with limit Alexander Korotkov (06:54)
Re: PgPool II configuration with PostgreSQL 8.4 Tatsuo Ishii (07:09)
Re: PgPool II configuration with PostgreSQL 8.4 Rosser Schwarz (22:28)

2010-05-07

Re: debugging handle exhaustion and 15 min/ 5mil row delete Marcos Ortiz (07:44)
Re: debugging handle exhaustion and 15 min/ 5mil row delete Marcos Ortiz (13:22)
debugging handle exhaustion and 15 min/ 5mil row delete Mark Stosberg (13:37)
Re: debugging handle exhaustion and 15 min/ 5mil rowdelete Kenneth Marshall (13:42)
Re: debugging handle exhaustion and 15 min/ 5mil row delete Mark Stosberg (14:10)
Re: Planner issue on sorting joining of two tables with limit Kevin Grittner (15:27)
Re: Planner issue on sorting joining of two tables with limit Tom Lane (15:35)
Re: partioning tips? Josh Berkus (17:48)
Dell Perc HX00 RAID controllers: What's inside? Craig James (21:11)

2010-05-08

8K recordsize bad on ZFS? Josh Berkus (00:09)
Slow Bulk Delete thilo (11:39)
Re: Slow Bulk Delete Andy Colson (13:17)
Ugh - bad plan with LIMIT in a complex SELECT, any way to fix this? Karl Denninger (20:35)
Re: 8K recordsize bad on ZFS? Jignesh Shah (21:39)

2010-05-09

Re: Ugh - bad plan with LIMIT in a complex SELECT, any way to fix this? Jesper Krogh (06:53)
Re: 8K recordsize bad on ZFS? Dimitri (08:45)
Re: Ugh - bad plan with LIMIT in a complex SELECT, any way to fix this? Oleg Bartunov (09:35)
Re: Dell Perc HX00 RAID controllers: What's inside? Greg Smith (21:20)
Re: Slow Bulk Delete thilo (21:26)

2010-05-10

Re: Dell Perc HX00 RAID controllers: What's inside? Scott Marlowe (02:39)
Re: 8K recordsize bad on ZFS? Josh Berkus (18:39)
Re: 8K recordsize bad on ZFS? Ivan Voras (19:13)
Re: 8K recordsize bad on ZFS? Dimitri (19:26)
Re: 8K recordsize bad on ZFS? Josh Berkus (19:30)
Re: 8K recordsize bad on ZFS? Greg Stark (20:01)
Re: 8K recordsize bad on ZFS? Josh Berkus (21:16)

2010-05-11

Function scan/Index scan to nested loop Carlo Stonebanks (05:32)
Re: Function scan/Index scan to nested loop Scott Marlowe (07:07)
Re: Function scan/Index scan to nested loop Craig Ringer (07:14)
Performance issues when the number of records are around 10 Million venu madhav (08:47)
Re: Function scan/Index scan to nested loop Carlo Stonebanks (18:00)
Re: Performance issues when the number of recordsare around 10 Million Jorge Montero (21:47)
Re: Performance issues when the number of records are around 10 Million Kevin Grittner (21:50)
Re: Performance issues when the number of records are around 10 Million Shrirang Chitnis (21:52)

2010-05-12

Re: 8K recordsize bad on ZFS? Josh Berkus (01:01)
Re: Performance issues when the number of records are around 10 Million Josh Berkus (01:04)
Re: Performance issues when the number of records are around 10 Million venu madhav (05:45)
Re: Performance issues when the number of records are around 10 Million venu madhav (06:42)
Re: Performance issues when the number of records are around 10 Million venu madhav (06:59)
Re: Performance issues when the number of records are around 10 Million Kevin Grittner (11:55)
Re: Performance issues when the number of records are around 10 Million venu madhav (12:14)
Re: Performance issues when the number of records are around 10 Million Kevin Grittner (13:56)
Re: Performance issues when the number of records are around 10 Million Craig James (14:08)

2010-05-13

Re: Slow Bulk Delete Bob Lunney (03:13)
Re: Performance issues when the number of records are around 10 Million venu madhav (04:41)
Re: Performance issues when the number of records are around 10 Million Kevin Grittner (13:56)

2010-05-14

old server, new server, same performance Piotr Legiecki (08:24)
old server, new server, same performance Piotr Legiecki (13:14)
Re: old server, new server, same performance Thom Brown (14:03)
Re: old server, new server, same performance Kevin Grittner (14:04)
Re: old server, new server, same performance Scott Marlowe (14:07)
Re: old server, new server, same performance Yeb Havinga (14:13)
Re: old server, new server, same performance Scott Marlowe (22:52)

2010-05-15

Re: old server, new server, same performance Scott Carey (00:46)
Re: old server, new server, same performance Sarwani Dwinanto (02:26)
Benchmark with FreeBSD 8.0 and pgbench joao.pinheiro (16:42)
Re: Benchmark with FreeBSD 8.0 and pgbench Josh Berkus (19:48)
Re: Benchmark with FreeBSD 8.0 and pgbench joao.pinheiro (20:41)

2010-05-16

Re: Planner issue on sorting joining of two tables with limit Robert Haas (12:21)

2010-05-17

pg_dump and pg_restore Jayadevan M (05:04)
Re: Benchmark with FreeBSD 8.0 and pgbench Віталій Тимчишин (07:06)
Re: old server, new server, same performance Piotr Legiecki (08:06)
Re: old server, new server, same performance Scott Marlowe (08:10)
Re: old server, new server, same performance Scott Marlowe (08:52)
Re: old server, new server, same performance Scott Marlowe (08:53)
Re: old server, new server, same performance Piotr Legiecki (09:52)
Re: Slow Bulk Delete Pierre C (10:10)
Re: old server, new server, same performance Scott Marlowe (10:25)
Re: Slow Bulk Delete Jon Nelson (11:54)
Re: Slow Bulk Delete Віталій Тимчишин (12:07)
Re: Slow Bulk Delete Grzegorz Jaśkiewicz (12:15)
Re: Slow Bulk Delete A. Kretschmer (12:28)
Re: Slow Bulk Delete Jon Nelson (12:28)
Re: Slow Bulk Delete Grzegorz Jaśkiewicz (12:33)
Re: Slow Bulk Delete Jon Nelson (12:35)

2010-05-18

Does FILTER in SEQSCAN short-circuit AND? Carlo Stonebanks (22:28)

2010-05-19

merge join killing performance Scott Marlowe (00:17)
Re: merge join killing performance Matthew Wakeling (03:00)
Re: merge join killing performance Scott Marlowe (03:06)
Re: merge join killing performance Tom Lane (16:53)
Re: merge join killing performance Scott Marlowe (17:08)
Re: merge join killing performance Scott Marlowe (20:27)
Re: merge join killing performance Scott Marlowe (20:47)

2010-05-20

Re: merge join killing performance Matthew Wakeling (01:46)
Re: merge join killing performance Scott Marlowe (02:04)
Re: merge join killing performance Scott Marlowe (02:06)
Re: merge join killing performance Scott Marlowe (02:07)
Optimize date query for large child tables: GiST or GIN? David Jarvis (05:06)
Re: Optimize date query for large child tables: GiST or GIN? Yeb Havinga (08:20)
Re: Optimize date query for large child tables: GiST or GIN? Thom Brown (08:33)
Re: Optimize date query for large child tables: GiST or GIN? Matthew Wakeling (13:03)
Re: Optimize date query for large child tables: GiST or GIN? Tom Lane (13:56)
Query causing explosion of temp space with join involving partitioning Krzysztof Nienartowicz (14:00)
Re: merge join killing performance Tom Lane (14:28)
Re: merge join killing performance Scott Marlowe (14:35)
Re: Optimize date query for large child tables: GiST or GIN? David Jarvis (15:43)
Re: Optimize date query for large child tables: GiST or GIN? Thom Brown (18:36)
Re: Optimize date query for large child tables: GiST or GIN? Thom Brown (18:58)
Re: Optimize date query for large child tables: GiST or GIN? Tom Lane (19:02)
Re: Optimize date query for large child tables: GiST or GIN? Thom Brown (19:21)
Re: Query causing explosion of temp space with join involving partitioning Tom Lane (19:21)
Re: Optimize date query for large child tables: GiST or GIN? David Jarvis (19:45)
Re: Optimize date query for large child tables: GiST or GIN? Tom Lane (19:52)
Re: Optimize date query for large child tables: GiST or GIN? David Jarvis (19:58)
Re: Optimize date query for large child tables: GiST or GIN? Tom Lane (20:03)
Re: Optimize date query for large child tables: GiST or GIN? David Jarvis (20:09)
Re: Optimize date query for large child tables: GiST or GIN? Tom Lane (20:18)
Re: Optimize date query for large child tables: GiST or GIN? David Jarvis (20:19)
Re: Optimize date query for large child tables: GiST or GIN? David Jarvis (20:30)
Re: Optimize date query for large child tables: GiST orGIN? Stephen Frost (21:01)
Re: Optimize date query for large child tables: GiST or GIN? Yeb Havinga (21:08)
Re: Optimize date query for large child tables: GiST orGIN? Stephen Frost (21:19)
Re: Optimize date query for large child tables: GiST orGIN? Stephen Frost (21:30)

2010-05-21

Re: Optimize date query for large child tables: GiST or GIN? David Jarvis (00:19)
Re: Optimize date query for large child tables: GiST or GIN? David Jarvis (00:28)
Re: Optimize date query for large child tables: GiST or GIN? David Jarvis (00:46)
Re: Optimize date query for large child tables: GiST or GIN? David Jarvis (02:02)
Re: Optimize date query for large child tables: GiST or GIN? Matthew Wakeling (03:27)
Re: Optimize date query for large child tables: GiST or GIN? David Jarvis (04:11)
Re: Optimize date query for large child tables: GiST or GIN? Yeb Havinga (08:38)
Re: Optimize date query for large child tables: GiST or GIN? Yeb Havinga (08:45)
Autovacuum in postgres. venu madhav (09:38)
Re: Autovacuum in postgres. venu madhav (09:39)
Re: old server, new server, same performance Piotr Legiecki (12:15)
Query timing increased from 3s to 55s when used as functioninstead of select Tyler Hildebrandt (13:54)
Re: Optimize date query for large child tables: GiST or GIN? Matthew Wakeling (15:08)
Re: Optimize date query for large child tables: GiST or GIN? David Jarvis (15:17)
Re: Optimize date query for large child tables: GiST or GIN? Yeb Havinga (18:21)
Re: Optimize date query for large child tables: GiST or GIN? Yeb Havinga (18:49)
Re: Optimize date query for large child tables: GiST or GIN? Matthew Wakeling (19:12)
Re: Optimize date query for large child tables: GiST orGIN? Stephen Frost (19:17)
prepared query performs much worse than regular query Richard Yen (22:53)

2010-05-22

Re: prepared query performs much worse than regular query Rosser Schwarz (00:30)
Re: prepared query performs much worse than regular query Matthew Wakeling (03:26)
Re: Optimize date query for large child tables: GiST or GIN? David Jarvis (08:11)
Re: pg_dump and pg_restore Robert Haas (11:29)
Re: Optimize date query for large child tables: GiST or GIN? David Jarvis (17:54)
Re: pg_dump and pg_restore Peter Koczan (19:55)

2010-05-23

Re: Optimize date query for large child tables: GiST or GIN? David Jarvis (22:55)

2010-05-24

Re: pg_dump and pg_restore Jayadevan M (03:45)
Re: shared_buffers advice Konrad Garus (11:25)
[SPAM] Re: shared_buffers advice Ben Chobot (15:27)
Certain query eating up all free memory (out of memory error) Łukasz Dejneka (16:50)
Re: shared_buffers advice Merlin Moncure (18:25)
which hardware setup Pedro Axelrud (21:03)

2010-05-25

Random Page Cost and Planner David Jarvis (05:54)
Certain query eating up all free memory (out of memory error) Łukasz Dejneka (06:16)
Re: which hardware setup Jesper Krogh (06:21)
Re: Certain query eating up all free memory (out of memory error) Łukasz Dejneka (06:37)
Re: Random Page Cost and Planner David Jarvis (06:41)
performance of temporary vs. regular tables Joachim Worringen (07:59)
Re: performance of temporary vs. regular tables Grzegorz Jaśkiewicz (08:49)
Re: performance of temporary vs. regular tables Joachim Worringen (09:00)
Re: performance of temporary vs. regular tables Thom Brown (09:15)
Re: performance of temporary vs. regular tables Joachim Worringen (09:32)
Re: performance of temporary vs. regular tables Grzegorz Jaśkiewicz (09:38)
Re: performance of temporary vs. regular tables Joachim Worringen (09:52)
Re: shared_buffers advice Konrad Garus (09:58)
Query timing increased from 3s to 55s when used as a functioninstead of select Tyler Hildebrandt (09:59)
Re: Query timing increased from 3s to 55s when used as a function instead of select A. Kretschmer (10:30)
Re: performance of temporary vs. regular tables Andres Freund (10:41)
Re: Query timing increased from 3s to 55s when used as afunction instead of select Tyler Hildebrandt (13:41)
tunning pgsql 7.3.7 over RHEL 4.0 32 x86 (2.6.9-5ELsmp) Juan Pablo Sandoval Rivera (14:04)
Re: tunning pgsql 7.3.7 over RHEL 4.0 32 x86(2.6.9-5ELsmp) Joshua Tolley (14:27)
Re: Query timing increased from 3s to 55s when used as a function instead of select Merlin Moncure (14:55)
Re: Query timing increased from 3s to 55s when used as a function instead of select Merlin Moncure (14:57)
Re: Query timing increased from 3s to 55s when usedas a function instead of select Jorge Montero (16:18)
Re: which hardware setup Pedro Axelrud (17:07)
Re: prepared query performs much worse than regular query Scott Carey (18:27)
Re: Random Page Cost and Planner Kevin Grittner (18:28)
Re: prepared query performs much worse than regular query Joshua Tolley (19:01)
mergejoin null handling (was Re: [PERFORM] merge join killing performance) Tom Lane (20:06)
Re: shared_buffers advice Merlin Moncure (21:03)
Re: Random Page Cost and Planner David Jarvis (23:26)

2010-05-26

Re: Random Page Cost and Planner Tom Lane (00:24)
Re: Random Page Cost and Planner Rob Wultsch (00:56)
Re: Random Page Cost and Planner David Jarvis (03:50)
Re: Function scan/Index scan to nested loop Robert Haas (04:13)
Re: Performance issues when the number of records are around 10 Million Robert Haas (04:25)
Re: Random Page Cost and Planner David Jarvis (06:13)

Prev | Next

Jump to day: 1 3 5 6 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