Search

Peripheral Links

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

pgsql-performance - August 2009

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

Prev | Next

Aug. 1, 2009

• Re: load / stress testing Dimitri Fontaine (15:57)

Aug. 2, 2009

• Re: Performance 8.4.0 Robert Haas (15:25)
• select count(idn) is slow (Seq Scan) instead of Bitmap Heap.. why? Adam PAPAI (16:28)
• Re: Performance 8.4.0 Stephen Frost (17:29)
• Re: Performance Monitoring tool Frits Hoogland (18:08)
• Re: Why is PostgreSQL so slow on Windows ( Postgres 8.3.7) version PFC (20:33)
• Re: Why is PostgreSQL so slow on Windows ( Postgres 8.3.7) version Euler Taveira de Oliveira (20:55)

Aug. 3, 2009

• FW: Performance 8.4.0 Chris Dunn (02:04)
• Re: Greenplum MapReduce Chris (02:04)
• Re: FW: Performance 8.4.0 Robert Haas (02:16)
• Re: Greenplum MapReduce Suvankar Roy (04:57)
• Re: Greenplum MapReduce Richard Huxton (09:25)
• Re: Greenplum MapReduce Suvankar Roy (09:36)
• Re: Greenplum MapReduce Richard Huxton (09:49)
• Re: Why is PostgreSQL so slow on Windows ( Postgres 8.3.7) version Grzegorz Jaśkiewicz (10:48)
• Re: Why is PostgreSQL so slow on Windows ( Postgres 8.3.7) version Marc Cousin (11:46)
• Re: PostgreSQL 8.4 performance tuning questions Scott Carey (17:00)
• Query help Subbiah Stalin-XCGF84 (17:09)
• Re: PostgreSQL 8.4 performance tuning questions Tom Lane (18:56)
• Re: PostgreSQL 8.4 performance tuning questions Scott Carey (19:28)
• Re: Query help Kevin Grittner (19:48)
• Re: Query help Subbiah Stalin-XCGF84 (20:12)
• Re: PostgreSQL 8.4 performance tuning questions PFC (20:15)
• Re: Query help Kevin Grittner (20:44)
• Re: PostgreSQL 8.4 performance tuning questions Merlin Moncure (20:50)
• Re: Query help Subbiah Stalin-XCGF84 (21:17)
• Re: PostgreSQL 8.4 performance tuning questions PFC (21:30)

Aug. 4, 2009

• Re: PostgreSQL 8.4 performance tuning questions Merlin Moncure (13:28)
• Re: select count(idn) is slow (Seq Scan) instead of Bitmap Heap.. why? Robert Haas (13:46)
• Re: PostgreSQL 8.4 performance tuning questions Alvaro Herrera (15:30)
• Re: Query help Kevin Grittner (15:56)
• GiST, caching, and consistency Matthew Wakeling (16:06)
• CHECK constraint fails when it's not supposed to Richard Yen (16:49)
• Re: Query help Subbiah Stalin-XCGF84 (17:07)
• Re: PostgreSQL 8.4 performance tuning questions Scott Carey (17:32)
• CHECK constraint fails when it's not supposed to richyen (18:13)
• Re: PostgreSQL 8.4 performance tuning questions Tom Lane (20:40)
• postgresql and syslog Ibrahim Harrani (21:16)
• Re: GiST, caching, and consistency Robert Haas (22:56)
• Re: GiST, caching, and consistency Greg Stark (23:27)
• Re: CHECK constraint fails when it's not supposed to Greg Stark (23:36)

Aug. 5, 2009

• Re: SQL select query becomes slow when using limit (with no offset) Kees van Dieren (05:01)
• Re: SQL select query becomes slow when using limit (with no offset) Russell Smith (10:16)
• Re: GiST, caching, and consistency Matthew Wakeling (10:20)
• Re: GiST, caching, and consistency Robert Haas (13:42)
• Re: GiST, caching, and consistency Matthew Wakeling (13:53)
• Re: GiST, caching, and consistency Tom Lane (14:11)
• Re: PostgreSQL 8.4 performance tuning questions Merlin Moncure (14:12)
• Re: PostgreSQL 8.4 performance tuning questions Scott Carey (17:00)
• Re: Query help Subbiah Stalin-XCGF84 (19:16)
• Re: Query help Scott Carey (19:30)
• Re: Query help Kevin Grittner (19:42)

Aug. 6, 2009

• Bottleneck? Ip Wing Kin John (02:50)
• Re: Bottleneck? Scott Marlowe (04:19)
• Re: Bottleneck? wkipjohn (04:30)
• Re: Bottleneck? Scott Marlowe (04:53)
• Re: Bottleneck? wkipjohn (05:13)
• Re: Bottleneck? wkipjohn (05:21)
• Re: Bottleneck? Scott Marlowe (06:15)
• Re: Bottleneck? Ip Wing Kin John (06:23)
• Re: Bottleneck? Scott Marlowe (07:03)
• Re: Bottleneck? Ray Stell (14:53)
• Re: Bottleneck? Tom Lane (15:01)
• Re: Bottleneck? Ray Stell (15:43)
• Re: Bottleneck? Kenneth Cox (15:57)
• Re: Bottleneck? Joshua D. Drake (16:12)
• Re: Bottleneck? Ray Stell (16:38)
• Re: Bottleneck? Joshua D. Drake (16:52)
• Best settings to load a fresh database Campbell, Lance (18:42)
• Re: Best settings to load a fresh database Kenneth Marshall (19:02)
• Re: Best settings to load a fresh database Scott Marlowe (19:02)
• Re: postgresql and syslog Robert Haas (19:33)

Aug. 7, 2009

• Re: Best settings to load a fresh database Euler Taveira de Oliveira (07:30)
• Re: SQL select query becomes slow when using limit (with no offset) Kees van Dieren (08:00)
• Re: SQL select query becomes slow when using limit (with no offset) Robert Haas (12:53)
• Re: postgresql and syslog Michael Nacos (13:06)
• Re: postgresql and syslog Alvaro Herrera (19:56)
• PG-related ACM Article: "The Pathologies of Big Data" Josh Kupershmidt (20:17)
• Re: SQL select query becomes slow when using limit (with no offset) Scott Carey (21:09)
• Need suggestions on kernel settings for dedicated FreeBSD/Postgresql machine Culley Harrelson (21:24)

Aug. 8, 2009

• Re: PG-related ACM Article: "The Pathologies of Big Data" Greg Stark (00:28)
• Re: PG-related ACM Article: "The Pathologies of Big Data" Scott Marlowe (00:40)
• Re: PG-related ACM Article: "The Pathologies of Big Data" Scott Marlowe (00:42)
• Re: PG-related ACM Article: "The Pathologies of Big Data" Scott Carey (01:34)
• Re: PG-related ACM Article: "The Pathologies of Big Data" Scott Marlowe (03:03)
• Re: SQL select query becomes slow when using limit (with no offset) Robert Haas (03:37)
• Re: [PERFORM] BUG #4919: CREATE USER command slows down system performance Bruce Momjian (04:13)
• ORDER BY ... LIMIT and JOIN Fizu (06:02)
• Re: PG-related ACM Article: "The Pathologies of Big Data" Pierre Frédéric Caillaud (09:26)
• Re: [PERFORM] BUG #4919: CREATE USER command slows down system performance Tom Lane (16:02)
• Re: ORDER BY ... LIMIT and JOIN Michael Andreen (17:09)
• Re: [PERFORM] BUG #4919: CREATE USER command slows down system performance Alvaro Herrera (17:57)
• Re: [PERFORM] BUG #4919: CREATE USER command slows down system performance Tom Lane (18:15)
• Re: [PERFORM] BUG #4919: CREATE USER command slows down system performance Tom Lane (18:49)
• Re: [PERFORM] BUG #4919: CREATE USER command slows down system performance Alvaro Herrera (18:59)
• Re: [PERFORM] BUG #4919: CREATE USER command slows down system performance Tom Lane (19:15)
• Re: [PERFORM] BUG #4919: CREATE USER command slows down system performance Alvaro Herrera (19:20)
• Re: [PERFORM] BUG #4919: CREATE USER command slows down system performance Tom Lane (19:25)
• Re: [PERFORM] BUG #4919: CREATE USER command slows down system performance Bruce Momjian (20:31)

Aug. 9, 2009

• Re: Need suggestions on kernel settings for dedicated FreeBSD/Postgresql machine Robert Haas (03:40)
• Re: Need suggestions on kernel settings for dedicated FreeBSD/Postgresql machine Culley Harrelson (13:37)
• Re: ORDER BY ... LIMIT and JOIN Fizu (19:26)
• Re: ORDER BY ... LIMIT and JOIN Michael Andreen (23:03)

Aug. 10, 2009

• Re: ORDER BY ... LIMIT and JOIN Robert Haas (01:30)
• Re: Bottleneck? Ip Wing Kin John (06:22)
• Re: Bottleneck? Scott Marlowe (07:07)
• Re: Bottleneck? Robert Haas (12:02)
• Re: SQL select query becomes slow when using limit (with no offset) Kevin Grittner (15:19)
• Re: SQL select query becomes slow when using limit (with no offset) Robert Haas (16:21)
• Re: SQL select query becomes slow when using limit (with no offset) Devin Ben-Hur (18:41)

Aug. 11, 2009

• Why is vacuum_freeze_min_age 100m? Josh Berkus (21:14)
• Re: Why is vacuum_freeze_min_age 100m? Josh Berkus (21:23)
• Re: Why is vacuum_freeze_min_age 100m? Robert Haas (21:45)
• Re: Why is vacuum_freeze_min_age 100m? Josh Berkus (22:06)

Aug. 12, 2009

• Re: Why is vacuum_freeze_min_age 100m? Tom Lane (00:54)
• Re: Why is vacuum_freeze_min_age 100m? Robert Haas (01:11)
• Re: Why is vacuum_freeze_min_age 100m? Torsten Zühlsdorff (06:48)
• transaction delays to apply Nickolay (16:24)
• Re: Why is vacuum_freeze_min_age 100m? Kevin Grittner (18:17)
• Re: Why is vacuum_freeze_min_age 100m? Tom Lane (21:22)
• Re: Why is vacuum_freeze_min_age 100m? Kevin Grittner (21:33)
• Re: transaction delays to apply Pierre Frédéric Caillaud (21:34)
• Re: transaction delays to apply Tom Lane (21:37)
• Re: Why is vacuum_freeze_min_age 100m? Tom Lane (21:57)
• Re: Why is vacuum_freeze_min_age 100m? Robert Haas (23:49)

Aug. 13, 2009

• Memory usage of writer process Alex (04:44)
• Less expensive proprietary or Open source ETL tools Rstat (09:22)
• Re: transaction delays to apply Nickolay (11:54)
• Re: transaction delays to apply Nickolay (13:31)
• How to run this in reasonable time: Matthew Wakeling (14:16)
• Re: How to run this in reasonable time: Greg Stark (14:25)
• Re: Why is vacuum_freeze_min_age 100m? Kevin Grittner (14:32)
• Re: How to run this in reasonable time: Matthew Wakeling (14:36)
• Under the hood of views David Kerr (16:07)
• Re: Under the hood of views Richard Huxton (16:28)
• Re: Memory usage of writer process Alvaro Herrera (20:29)
• Re: Memory usage of writer process Alex Neth (21:01)
• Re: Why is vacuum_freeze_min_age 100m? Josh Berkus (21:15)
• freezing tuples ( was: Why is vacuum_freeze_min_age 100m? ) Jeff Davis (21:33)
• Re: Memory usage of writer process Scott Carey (21:42)
• Re: freezing tuples ( was: Why is vacuum_freeze_min_age 100m? ) Alvaro Herrera (21:58)
• [PERFORM] Re: freezing tuples ( was: Why is vacuum_freeze_min_age100m? ) Kevin Grittner (22:17)
• Re: freezing tuples ( was: Why is vacuum_freeze_min_age 100m? ) Jeff Davis (22:20)
• Re: [PERFORM] Re: freezing tuples ( was: Why is vacuum_freeze_min_age100m? ) Jeff Davis (22:24)
• Re: freezing tuples ( was: Why is vacuum_freeze_min_age 100m? ) Robert Haas (22:25)
• Re: [PERFORM] Re: freezing tuples ( was: Why is vacuum_freeze_min_age 100m? ) Josh Berkus (22:35)
• Re: freezing tuples ( was: Why is vacuum_freeze_min_age 100m? ) Tom Lane (22:46)
• Re: freezing tuples ( was: Why is vacuum_freeze_min_age 100m? ) Jeff Davis (23:01)
• Re: Under the hood of views David Kerr (23:04)
• Re: freezing tuples ( was: Why is vacuum_freeze_min_age 100m? ) Tom Lane (23:05)
• Re: freezing tuples ( was: Why is vacuum_freeze_min_age 100m? ) Josh Berkus (23:07)
• Re: Under the hood of views Greg Stark (23:14)
• Re: freezing tuples ( was: Why is vacuum_freeze_min_age 100m? ) Josh Berkus (23:16)
• Re: freezing tuples ( was: Why is vacuum_freeze_min_age 100m? ) Jeff Davis (23:20)
• Re: freezing tuples ( was: Why is vacuum_freeze_min_age 100m? ) Jeff Davis (23:21)
• Re: freezing tuples ( was: Why is vacuum_freeze_min_age 100m? ) Greg Stark (23:21)
• Re: freezing tuples ( was: Why is vacuum_freeze_min_age 100m? ) Tom Lane (23:21)
• Re: freezing tuples ( was: Why is vacuum_freeze_min_age 100m? ) Greg Stark (23:31)

Aug. 14, 2009

• Re: Scalability in postgres Jeff Janes (01:18)
• Re: Why is vacuum_freeze_min_age 100m? Robert Haas (03:11)
• Memory reporting on CentOS Linux Jeremy Carroll (18:00)
• Re: freezing tuples ( was: Why is vacuum_freeze_min_age 100m? ) Tom Lane (18:37)
• Re: Memory reporting on CentOS Linux Reid Thompson (19:43)
• Re: Memory reporting on CentOS Linux Jeremy Carroll (20:20)
• Re: Memory reporting on CentOS Linux Scott Marlowe (20:21)
• Re: Memory reporting on CentOS Linux Scott Marlowe (20:23)
• Re: Memory reporting on CentOS Linux Scott Carey (20:37)
• Re: freezing tuples ( was: Why is vacuum_freeze_min_age 100m? ) Jeff Davis (20:57)
• Per-database warm standby? Craig James (21:20)
• Re: Per-database warm standby? Tom Lane (22:05)
• Re: Per-database warm standby? Alvaro Herrera (22:09)
• Re: Scalability in postgres Tom Lane (23:21)

Aug. 15, 2009

• Re: Per-database warm standby? Nickolay (08:11)
• Re: Memory reporting on CentOS Linux Jeremy Carroll (14:25)
• Re: Memory reporting on CentOS Linux Tom Lane (15:24)
• Re: Memory reporting on CentOS Linux Jeremy Carroll (15:39)
• Re: Memory reporting on CentOS Linux Mark Mielke (16:18)
• Re: Memory reporting on CentOS Linux Robert Haas (20:10)
• Re: freezing tuples ( was: Why is vacuum_freeze_min_age 100m? ) Peter Eisentraut (23:02)
• Re: freezing tuples ( was: Why is vacuum_freeze_min_age 100m? ) Jeff Davis (23:55)

Aug. 16, 2009

• Re: Scalability in postgres simon@2ndquadrant.com (09:10)
• Re: freezing tuples ( was: Why is vacuum_freeze_min_age 100m? ) Peter Eisentraut (12:14)
• Re: Less expensive proprietary or Open source ETL tools Jean-Max Reymond (13:02)
• Re: Scalability in postgres Jeff Janes (21:55)

Aug. 17, 2009

• Re: Memory reporting on CentOS Linux Matthew Wakeling (11:03)
• Re: freezing tuples ( was: Why is vacuum_freeze_min_age100m? ) Kevin Grittner (14:38)
• Getting time of a postgresql-request Kai Behncke (16:38)
• Re: Memory reporting on CentOS Linux Jeremy Carroll (17:24)
• number of rows estimation for bit-AND operation Slava Moudry (20:07)
• Re: Memory reporting on CentOS Linux Scott Carey (23:43)

Aug. 18, 2009

• Re: Memory reporting on CentOS Linux Scott Carey (02:35)
• Re: Getting time of a postgresql-request Russell Smith (04:25)
• Re: Memory reporting on CentOS Linux Greg Smith (04:33)
• Re: number of rows estimation for bit-AND operation Scott Marlowe (07:08)
• Re: Getting time of a postgresql-request Pierre Frédéric Caillaud (09:38)
• Weird index or sort behaviour Matthew Wakeling (13:20)
• Re: Need suggestions on kernel settings for dedicated FreeBSD/Postgresql machine Ivan Voras (14:12)
• Re: Weird index or sort behaviour Tom Lane (15:05)
• Re: Weird index or sort behaviour Matthew Wakeling (16:41)
• Re: Weird index or sort behaviour Tom Lane (16:49)

Prev | Next