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: Samsung 32GB SATA SSD tested | behrangs | 04:20 |
| dblink /synonyms? | Jan-Peter Seifert | 08:58 |
| Partitions number limitation ? | s.caillet | 10:00 |
| SAN and full_page_writes | Nikolas Everett | 16:03 |
| Re: Partitions number limitation ? | Scott Marlowe | 16:43 |
| Thread | Author | Time |
|---|---|---|
| Re: too many clog files | Duan Ligong | 02:58 |
| Re: inaccurate stats on large tables | David Wilson | 03:25 |
| Re: slow update of index during insert/copy | Thomas Finneid | 08:09 |
| Re: too many clog files | Matthew Wakeling | 11:49 |
| You may need to increase mas_loks_per_trasaction | Jonas Pacheco | 11:59 |
| Re: You may need to increase mas_loks_per_trasaction | Claus Guttesen | 12:37 |
| Re: SAN and full_page_writes | Nikolas Everett | 14:24 |
| Re: indexing for distinct search in timestamp based table | Vladimir Sitnikov | 15:10 |
| Re: too many clog files | Alvaro Herrera | 16:24 |
| Re: too many clog files | Scott Marlowe | 16:39 |
| Re: You may need to increase mas_loks_per_trasaction | Greg Smith | 20:43 |
| Thread | Author | Time |
|---|---|---|
| Re: SAN and full_page_writes | Bruce Momjian | 19:46 |
| Thread | Author | Time |
|---|---|---|
| performance impact of non-C locale | Axel Rau | 10:50 |
| Thread | Author | Time |
|---|---|---|
| Re: too many clog files | Duan Ligong | 02:45 |
| Re: too many clog files | Duan Ligong | 03:07 |
| Re: indexing for distinct search in timestamp based table | Rainer Mager | 03:54 |
| Re: SAN and full_page_writes | Nikolas Everett | 14:02 |
| Re: SAN and full_page_writes | Gregory Stark | 14:16 |
| Re: SAN and full_page_writes | Nikolas Everett | 14:48 |
| Re: SAN and full_page_writes | Gregory Stark | 14:59 |
| Re: SAN and full_page_writes | Nikolas Everett | 15:17 |
| Re: inaccurate stats on large tables | Matt Smiley | 16:16 |
| bitmap heap scan versus simple index and nested loop | Scott Marlowe | 16:36 |
| Re: SAN and full_page_writes | Bruce Momjian | 22:35 |
| Intel's X25-M SSD | Greg Smith | 23:12 |
| Re: Intel's X25-M SSD | Merlin Moncure | 23:59 |
| Thread | Author | Time |
|---|---|---|
| Re: Effects of setting linux block device readahead size | Scott Marlowe | 02:30 |
| Re: PostgreSQL TPC-H test result? | Jignesh K. Shah | 03:30 |
| Re: [GENERAL] PostgreSQL TPC-H test result? | Tom Lane | 03:48 |
| Re: Effects of setting linux block device readahead size | Greg Smith | 04:09 |
| Re: [GENERAL] PostgreSQL TPC-H test result? | Jonah H. Harris | 04:46 |
| Re: Choosing a filesystem | Matthew Wakeling | 07:45 |
| Re: Choosing a filesystem | Guillaume Cottenceau | 08:38 |
| Re: Choosing a filesystem | Greg Smith | 09:01 |
| Re: Effects of setting linux block device readahead size | James Mansion | 09:05 |
| Re: Choosing a filesystem | Greg Smith | 09:11 |
| Postgres Performance on CPU limited Platforms 📎 | George McCollister | 14:13 |
| Re: Choosing a filesystem | Merlin Moncure | 14:35 |
| Re: Postgres Performance on CPU limited Platforms | H. Hall | 18:07 |
| Thread | Author | Time |
|---|---|---|
| Re: Effects of setting linux block device readahead size | david | 21:21 |
| Re: Choosing a filesystem | david | 21:26 |
| Thread | Author | Time |
|---|---|---|
| Re: Choosing a filesystem | Merlin Moncure | 02:49 |
| Re: select on 22 GB table causes "An I/O error occured while sending to the backend." exception | Florian Weimer | 08:36 |
| Re: select on 22 GB table causes "An I/O error occured while sending to the backend." exception | Craig James | 14:11 |
| Re: select on 22 GB table causes "An I/O error occured while sending to the backend." exception | Florian Weimer | 14:15 |
| Re: select on 22 GB table causes "An I/O error occured while sending to the backend." exception | Craig James | 14:25 |
| Re: Effects of setting linux block device readahead size | Matthew Wakeling | 16:18 |
| Re: Effects of setting linux block device readahead size | Scott Carey | 17:33 |
| Thread | Author | Time |
|---|---|---|
| Statement Timeout at User Level | Gauri Kanekar | 05:07 |
| Re: Statement Timeout at User Level | Albe Laurenz | 07:34 |
| Re: RAID arrays and performance | Matthew Wakeling | 13:21 |
| Why does this query write to the disk? | Nikolas Everett | 17:30 |
| Re: Why does this query write to the disk? | Kevin Grittner | 17:49 |
| Re: Why does this query write to the disk? | Tom Lane | 18:13 |
| Re: Why does this query write to the disk? | Scott Carey | 18:30 |
| Re: Why does this query write to the disk? | Scott Carey | 18:33 |
| Re: Why does this query write to the disk? | Nikolas Everett | 18:44 |
| Re: Why does this query write to the disk? | Tom Lane | 18:58 |