Discussion of PostgreSQL's performance issues. Please see Guide to reporting problems and Slow Query Questions for some tips on how to write your performance question.
| Thread | Author | Time |
|---|---|---|
| Re: load / stress testing | Dimitri Fontaine | 15:57 |
| Thread | Author | Time |
|---|---|---|
| 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 |
| Thread | Author | Time |
|---|---|---|
| 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 |
| Thread | Author | Time |
|---|---|---|
| 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 |
| Thread | Author | Time |
|---|---|---|
| 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 |
| Thread | Author | Time |
|---|---|---|
| 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 |
| Thread | Author | Time |
|---|---|---|
| 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 |
| Thread | Author | Time |
|---|---|---|
| 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 |
| Thread | Author | Time |
|---|---|---|
| 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 |
| Thread | Author | Time |
|---|---|---|
| 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 |
| Thread | Author | Time |
|---|---|---|
| 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 |
| Thread | Author | Time |
|---|---|---|
| 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 |
| Thread | Author | Time |
|---|---|---|
| Re: Scalability in postgres | [email protected] | 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 |
| Thread | Author | Time |
|---|---|---|
| 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 |
| Thread | Author | Time |
|---|---|---|
| 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 |