Peripheral Links

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

pgsql-performance - June 2010

June 1, 2010

• Re: planner costs in "warm cache" tests Scott Carey (07:13)
• Re: Zeus IOPS Mindaugas Riauba (07:27)
• Re: Optimize date query for large child tables: GiST or GIN? Matthew Wakeling (09:55)
• Re: PostgreSQL Function Language Performance: C vs PL/PGSQL Matthew Wakeling (12:47)
• Re: PostgreSQL Function Language Performance: C vsPL/PGSQL Stephen Frost (12:54)
• Re: PostgreSQL Function Language Performance: C vs PL/PGSQL Matthew Wakeling (12:59)
• Re: Zeus IOPS Brad Nicholson (13:17)
• Re: planner costs in "warm cache" tests Tom Lane (14:03)
• How to insert a bulk of data with unique-violations very fast Torsten Zühlsdorff (15:03)
• Re: PostgreSQL Function Language Performance: C vs PL/PGSQL Merlin Moncure (16:28)
• Re: Optimize date query for large child tables: GiST or GIN? Alvaro Herrera (17:14)
• PgAdmin iii - Explain. Jeres Caldeira Gomes (17:47)
• Re: Optimize date query for large child tables: GiST or GIN? David Jarvis (18:01)
• Re: Optimize date query for large child tables: GiST or GIN? Alvaro Herrera (19:00)

June 2, 2010

• File system choice for Red Hat systems Mark Kirkwood (03:06)
• Re: File system choice for Red Hat systems Tom Lane (03:26)
• Re: File system choice for Red Hat systems Mark Kirkwood (03:41)
• Re: Optimize date query for large child tables: GiST or GIN? David Jarvis (04:55)
• Re: File system choice for Red Hat systems Devrim GÜNDÜZ (05:17)
• Re: File system choice for Red Hat systems Mark Kirkwood (05:31)
• Re: File system choice for Red Hat systems Greg Smith (06:16)
• Re: performance of temporary vs. regular tables Pierre C (10:03)
• Re: requested shared memory size overflows size_t Tom Wilcox (10:58)
• Overusing 1 CPU Mozzi (11:12)
• Re: Overusing 1 CPU Matthew Wakeling (11:24)
• Re: Overusing 1 CPU Mozzi (11:37)
• Re: Overusing 1 CPU J. Roeleveld (11:48)
• Re: Overusing 1 CPU A. Kretschmer (11:58)
• Re: Overusing 1 CPU Stephen Frost (11:59)
• Re: performance of temporary vs. regular tables Joachim Worringen (12:54)
• Re: File system choice for Red Hat systems Alan Hodgson (14:53)
• Re: File system choice for Red Hat systems Wales Wang (15:29)
• Re: How to insert a bulk of data with unique-violations very fast Scott Marlowe (19:59)
• Re: Autovacuum in postgres. Scott Marlowe (20:12)
• SELECT ignoring index even though ORDER BY and LIMIT present Jori Jovanovich (20:28)
• Re: requested shared memory size overflows size_t Kevin Grittner (20:52)
• Re: requested shared memory size overflows size_t Stephen Frost (20:59)
• Re: Certain query eating up all free memory (out of memory error) Robert Haas (21:26)
• Re: File system choice for Red Hat systems Mark Kirkwood (22:13)
• Re: SELECT ignoring index even though ORDER BY and LIMIT present Kevin Grittner (22:25)
• Re: SELECT ignoring index even though ORDER BY and LIMIT present Szymon Guz (22:27)
• Re: SELECT ignoring index even though ORDER BY and LIMIT present Tom Lane (22:41)
• Weird XFS WAL problem Craig James (23:30)
• Re: Weird XFS WAL problem Mark Kirkwood (23:40)

June 3, 2010

• Re: requested shared memory size overflows size_t Bob Lunney (01:26)
• Re: SELECT ignoring index even though ORDER BY and LIMIT present Bob Lunney (01:49)
• Re: requested shared memory size overflows size_t Joshua Tolley (02:27)
• Re: SELECT ignoring index even though ORDER BY and LIMIT present Matthew Wakeling (10:15)
• Re: Weird XFS WAL problem Merlin Moncure (13:01)
• Re: SELECT ignoring index even though ORDER BY and LIMIT present Jori Jovanovich (15:32)
• Re: Weird XFS WAL problem Greg Smith (16:52)
• Re: Weird XFS WAL problem Craig James (17:06)
• Re: Weird XFS WAL problem Matthew Wakeling (17:14)
• Re: Weird XFS WAL problem Kevin Grittner (17:30)
• slow query performance Anj Adu (17:47)
• Re: Weird XFS WAL problem Greg Smith (18:18)
• Re: Weird XFS WAL problem Greg Smith (18:27)
• Re: Weird XFS WAL problem Kevin Grittner (18:40)
• Re: slow query performance Andy Colson (18:43)
• Re: Weird XFS WAL problem Scott Marlowe (19:10)
• Re: Weird XFS WAL problem Kevin Grittner (19:17)
• Re: Weird XFS WAL problem Greg Smith (19:31)
• Re: Weird XFS WAL problem Scott Marlowe (19:44)
• Re: Weird XFS WAL problem Kevin Grittner (20:01)
• Re: How to insert a bulk of data with unique-violations very fast Scott Marlowe (20:09)
• Re: slow query performance Anj Adu (20:37)
• Re: How to insert a bulk of data with unique-violations very fast Cédric Villemain (23:03)

June 4, 2010

• slow query Anj Adu (01:45)
• Performance tuning for postgres Yogesh Naik (04:40)
• Re: slow query tv (08:13)
• Re: slow query Matthew Wakeling (09:00)
• Re: Weird XFS WAL problem Matthew Wakeling (09:27)
• How filesystems matter with PostgreSQL Jon Schewe (12:17)
• Re: How filesystems matter with PostgreSQL J. Roeleveld (12:39)
• Re: How filesystems matter with PostgreSQL Andres Freund (13:04)
• performance regression with Linux 2.6.33 and glibc 2.12 Marc Cousin (13:39)
• Re: performance regression with Linux 2.6.33 and glibc 2.12 Tom Lane (13:59)
• Re: Performance tuning for postgres Kevin Grittner (14:00)
• Re: Performance tuning for postgres Michael Gould (14:21)
• Re: How filesystems matter with PostgreSQL Tom Lane (14:25)
• Re: How filesystems matter with PostgreSQL Andres Freund (14:33)
• Re: Weird XFS WAL problem Bruce Momjian (15:06)
• Re: Weird XFS WAL problem Kevin Grittner (15:16)
• Re: Weird XFS WAL problem Bruce Momjian (15:18)
• Re: Weird XFS WAL problem Kevin Grittner (15:23)
• Re: performance regression with Linux 2.6.33 and glibc 2.12 Andres Freund (15:25)
• Re: performance regression with Linux 2.6.33 and glibc 2.12 Marc Cousin (15:29)
• Re: Weird XFS WAL problem Bruce Momjian (15:30)
• Re: Weird XFS WAL problem Kevin Grittner (15:35)
• Re: Weird XFS WAL problem Bruce Momjian (15:41)
• Re: slow query Anj Adu (17:25)
• Re: slow query Anj Adu (17:41)
• Re: slow query Anj Adu (18:01)
• Re: Performance tuning for postgres Bryan Hinton (18:12)
• Re: How filesystems matter with PostgreSQL Bryan Hinton (18:20)
• Re: slow query Anj Adu (18:21)
• Re: How filesystems matter with PostgreSQL Jon Schewe (18:23)
• Re: How filesystems matter with PostgreSQL Jon Schewe (18:26)
• Re: How filesystems matter with PostgreSQL Bryan Hinton (18:37)
• Re: How filesystems matter with PostgreSQL Jon Schewe (18:44)
• Re: How filesystems matter with PostgreSQL Andres Freund (18:46)
• Re: How filesystems matter with PostgreSQL Jon Schewe (18:49)

June 5, 2010

• Re: planner costs in "warm cache" tests Robert Haas (01:29)
• Re: how to force hashaggregate plan? Robert Haas (01:40)
• Re: PgAdmin iii - Explain. Robert Haas (01:43)
• Re: slow query hubert depesz lubaczewski (09:02)
• Re: slow query Scott Marlowe (09:38)
• Re: slow query Anj Adu (14:02)
• Re: slow query Scott Marlowe (21:25)
• Re: How filesystems matter with PostgreSQL Greg Smith (22:36)
• Re: How filesystems matter with PostgreSQL Jon Schewe (22:41)
• Re: Weird XFS WAL problem Greg Smith (22:50)
• Re: How filesystems matter with PostgreSQL Greg Smith (22:52)
• Re: How filesystems matter with PostgreSQL Jon Schewe (23:03)
• Re: How filesystems matter with PostgreSQL Scott Marlowe (23:54)
• Re: How filesystems matter with PostgreSQL Jon Schewe (23:58)

June 6, 2010

• Re: How filesystems matter with PostgreSQL Scott Marlowe (00:02)
• Re: How filesystems matter with PostgreSQL Jon Schewe (00:07)
• Re: How filesystems matter with PostgreSQL Scott Marlowe (03:34)
• Re: How filesystems matter with PostgreSQL Ron Mayer (06:51)
• Re: How filesystems matter with PostgreSQL Craig Ringer (07:48)
• Re: How to insert a bulk of data with unique-violations very fast Torsten Zühlsdorff (12:02)
• Re: How to insert a bulk of data with unique-violations very fast Torsten Zühlsdorff (12:05)
• Re: How to insert a bulk of data with unique-violations very fast Andy Colson (12:45)
• Re: How to insert a bulk of data with unique-violations very fast Scott Marlowe (17:46)
• Re: How to insert a bulk of data with unique-violations very fast Pierre C (22:35)
• Re: performance of temporary vs. regular tables Pierre C (22:37)

June 7, 2010

• Re: How to insert a bulk of data with unique-violations very fast Torsten Zühlsdorff (13:21)
• Re: How to insert a bulk of data with unique-violations very fast Pierre C (16:52)

June 9, 2010

• Re: How to insert a bulk of data with unique-violations very fast Torsten Zühlsdorff (07:45)
• Re: How to insert a bulk of data with unique-violations very fast Pierre C (10:51)
• Large (almost 50%!) performance drop after upgrading to 8.4.4? Max Williams (10:56)
• Re: Large (almost 50%!) performance drop after upgrading to 8.4.4? Pierre C (11:35)
• Re: No hash join across partitioned tables? Robert Haas (19:47)
• Re: No hash join across partitioned tables? Tom Lane (20:11)

June 10, 2010

• Re: requested shared memory size overflows size_t Robert Haas (01:49)
• Re: Large (almost 50%!) performance drop after upgrading to 8.4.4? Robert Haas (01:51)
• Re: slow query performance Robert Haas (02:12)
• Re: slow query performance Tom Lane (02:55)
• Re: slow query performance Anj Adu (03:17)
• Re: Large (almost 50%!) performance drop after upgrading to 8.4.4? Max Williams (08:18)
• Re: Large (almost 50%!) performance drop after upgrading to 8.4.4? Devrim GÜNDÜZ (08:29)
• Autovaccum settings while Bulk Loading data Ambarish Bhattacharya (08:47)
• Re: Autovaccum settings while Bulk Loading data Heikki Linnakangas (09:01)
• query hangs AI Rumman (10:16)
• Re: Large (almost 50%!) performance drop after upgrading to 8.4.4? Max Williams (10:19)
• Re: query hangs Szymon Guz (11:26)
• Re: query hangs AI Rumman (11:36)
• Re: query hangs Szymon Guz (11:44)
• Re: query hangs Kevin Grittner (12:28)
• Re: query hangs AI Rumman (12:35)
• Re: query hangs Amit Khandekar (12:55)
• Re: query hangs AI Rumman (13:17)
• Re: slow query performance Robert Haas (13:28)
• Re: [PERFORM] No hash join across partitioned tables? Robert Haas (13:29)
• Re: Large (almost 50%!) performance drop after upgrading to 8.4.4? Tom Lane (14:10)
• Re: requested shared memory size overflows size_t Bob Lunney (14:41)
• Error with GIT Repository Luxenberg, Scott I. (14:42)
• Re: Large (almost 50%!) performance drop after upgrading to 8.4.4? Max Williams (15:09)
• Re: Large (almost 50%!) performance drop after upgrading to 8.4.4? Kevin Grittner (15:15)
• Re: Large (almost 50%!) performance drop after upgrading to 8.4.4? Tom Lane (15:21)
• Re: Error with GIT Repository Andrew Dunstan (15:26)
• Re: Autovaccum settings while Bulk Loading data Heikki Linnakangas (15:27)
• Re: slow query performance Anj Adu (15:32)
• Re: Large (almost 50%!) performance drop after upgrading to 8.4.4? Max Williams (15:40)
• Re: Error with GIT Repository Stephen Frost (15:44)
• Re: Large (almost 50%!) performance drop after upgrading to 8.4.4? Tom Lane (15:46)
• Re: Error with GIT Repository Andrew Dunstan (16:15)
• Re: Error with GIT Repository Stephen Frost (16:20)
• Re: Large (almost 50%!) performance drop after upgrading to 8.4.4? Alvaro Herrera (16:34)
• Re: slow query performance Robert Haas (16:42)
• Re: Performance tuning for postgres Robert Haas (16:44)
• Re: slow query performance Anj Adu (16:58)
• Re: Error with GIT Repository Magnus Hagander (17:30)
• Need to increase performance of a query Anne Rosset (17:50)
• Re: Large (almost 50%!) performance drop after upgrading to 8.4.4? Lacey Powers (18:01)
• Re: Need to increase performance of a query Jesper Krogh (18:12)
• Re: Need to increase performance of a query hubert depesz lubaczewski (18:33)
• Re: Need to increase performance of a query Anne Rosset (18:36)
• Re: Need to increase performance of a query Jochen Erwied (19:22)
• Re: Error with GIT Repository Alvaro Herrera (19:23)
• Re: Need to increase performance of a query Anne Rosset (19:34)
• Re: Need to increase performance of a query Kenneth Marshall (19:37)
• Re: Need to increase performance of a query Jochen Erwied (19:39)
• Re: Need to increase performance of a query Anne Rosset (19:42)
• Re: Need to increase performance of a query Anne Rosset (19:44)
• Re: Need to increase performance of a query Craig James (19:47)
• Re: Need to increase performance of a query Anne Rosset (19:56)
• Re: Need to increase performance of a query Heikki Linnakangas (19:57)
• Re: Need to increase performance of a query Anne Rosset (20:08)
• Re: Need to increase performance of a query Joe Conway (20:10)
• Re: Need to increase performance of a query Joe Conway (20:13)
• Re: Large (almost 50%!) performance drop after upgrading to 8.4.4? Greg Smith (20:15)
• Re: Need to increase performance of a query Anne Rosset (20:21)
• Re: Need to increase performance of a query Heikki Linnakangas (20:59)
• Re: Need to increase performance of a query Joe Conway (21:06)
• Re: Need to increase performance of a query Anne Rosset (21:20)

June 11, 2010

• Re: Analysis Function David Jarvis (00:41)
• Re: slow query performance Robert Haas (00:49)
• Re: Analysis Function Andy Colson (02:11)