pgsql-performance - January 2007

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.

Search the Archives

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

Browse Archives

Prev | Next
Jump to day: 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 22 23 24 25 26 27 28 29 30 31

Jan. 1, 2007

Thread Author Time
Re: Worse perfomance on 8.2.0 than on 7.4.14 Rolf Østvik 15:04
Re: Worse perfomance on 8.2.0 than on 7.4.14 Rolf Østvik 15:14
Re: Worse perfomance on 8.2.0 than on 7.4.14 Rolf Østvik 15:19
Re: Worse perfomance on 8.2.0 than on 7.4.14 Tom Lane 23:30

Jan. 2, 2007

Thread Author Time
glibc double-free error Craig A. James 01:29
Re: glibc double-free error Tom Lane 01:39
Re: glibc double-free error Craig A. James 06:03
Re: glibc double-free error Tom Lane 06:11
what work_mem needs a query needs? Arnau 09:55
Re: Worse perfomance on 8.2.0 than on 7.4.14 Rolf Østvik 12:45
Re: High update activity, PostgreSQL vs BigDBMS Geoffrey 14:04
Re: High update activity, PostgreSQL vs BigDBMS Ragnar 14:54
Re: High update activity, PostgreSQL vs BigDBMS Lars Heidieker 14:55
Re: High update activity, PostgreSQL vs BigDBMS Jeremy Haile 14:58
Re: Worse perfomance on 8.2.0 than on 7.4.14 Tom Lane 15:07
Config parameters Jeremy Haile 16:22
Re: Config parameters Richard Huxton 16:34
Slow dump? Erik Jones 16:41
Re: Config parameters Jeremy Haile 17:06
Re: Slow dump? Tom Lane 17:30
Re: Slow dump? Erik Jones 17:40
Re: High update activity, PostgreSQL vs BigDBMS Jeff Davis 18:36
Re: Config parameters Richard Huxton 18:49
Re: Config parameters Jeremy Haile 19:19
Re: Config parameters Scott Marlowe 19:51
Re: Config parameters Jeremy Haile 20:01
More 8.2 client issues (Was: [Slow dump?) Erik Jones 21:59
Re: More 8.2 client issues (Was: [Slow dump?) Richard Huxton 22:06
Re: More 8.2 client issues (Was: [Slow dump?) Erik Jones 22:16
Re: More 8.2 client issues (Was: [Slow dump?) Tom Lane 23:09

Jan. 3, 2007

Thread Author Time
Re: Worse perfomance on 8.2.0 than on 7.4.14 Rolf Østvik 08:01
Re: Worse perfomance on 8.2.0 than on 7.4.14 Tom Lane 15:31
Re: More 8.2 client issues (Was: [Slow dump?) Erik Jones 16:13
Re: More 8.2 client issues (Was: [Slow dump?) Tom Lane 16:24
Re: More 8.2 client issues (Was: [Slow dump?) Erik Jones 16:40
Re: More 8.2 client issues (Was: [Slow dump?) Guillaume Smet 16:50
Re: More 8.2 client issues (Was: [Slow dump?) Tom Lane 16:56
Re: More 8.2 client issues (Was: [Slow dump?) Erik Jones 17:10
Re: More 8.2 client issues (Was: [Slow dump?) Erik Jones 17:15
Re: More 8.2 client issues (Was: [Slow dump?) Tom Lane 17:21
Performance of PostgreSQL on Windows vs Linux Jeremy Haile 17:24
Re: More 8.2 client issues (Was: [Slow dump?) Erik Jones 17:58
Re: More 8.2 client issues (Was: [Slow dump?) Tom Lane 18:26
Re: More 8.2 client issues (Was: [Slow dump?) Erik Jones 18:59
Re: Performance of PostgreSQL on Windows vs Linux Magnus Hagander 23:18
Re: Performance of PostgreSQL on Windows vs Linux Dimitri Fontaine 23:46

Jan. 4, 2007

Thread Author Time
Trivial function query optimized badly Craig A. James 03:11
Re: Trivial function query optimized badly Adam Rich 04:17
Re: Trivial function query optimized badly Craig A. James 05:42
Re: Trivial function query optimized badly Tom Lane 05:46
Re: Trivial function query optimized badly Craig A. James 06:57
Re: Performance of PostgreSQL on Windows vs Linux Jeremy Haile 14:27
Re: Performance of PostgreSQL on Windows vs Linux Jeremy Haile 14:46
Re: Performance of PostgreSQL on Windows vs Linux Tom Lane 15:23
Re: Performance of PostgreSQL on Windows vs Linux Jeremy Haile 15:29
PostgreSQL to host e-mail? Charles A. Landemaine 18:00
PostgreSQL to host e-mail? Charles A. Landemaine 18:04
Re: PostgreSQL to host e-mail? Frank Wiles 18:08
Re: PostgreSQL to host e-mail? Joshua D. Drake 18:11
Re: PostgreSQL to host e-mail? Matthew Schumacher 18:42
Slow Query on Postgres 8.2 📎 Dave Dutcher 23:31

Jan. 5, 2007

Thread Author Time
Re: Slow Query on Postgres 8.2 Tom Lane 01:12
Re: Slow Query on Postgres 8.2 Adam Rich 01:19
Re: Slow Query on Postgres 8.2 Dave Dutcher 01:51
Re: Slow Query on Postgres 8.2 Dave Dutcher 02:01
Re: Slow Query on Postgres 8.2 Tom Lane 03:04
Re: PostgreSQL to host e-mail? Grega Bremec 03:10
Partitioning Arnau 11:02
Re: Partitioning Mikael Carneholm 11:47
Re: More 8.2 client issues (Was: [Slow dump?) Erik Jones 18:02
Re: PostgreSQL to host e-mail? Reid Thompson 18:15
Re: Worse perfomance on 8.2.0 than on 7.4.14 Rolf Østvik 18:28

Jan. 6, 2007

Thread Author Time
Re: High update activity, PostgreSQL vs BigDBMS Guy Rouillier 02:51
Re: High update activity, PostgreSQL vs BigDBMS Craig A. James 03:14
Re: High update activity, PostgreSQL vs BigDBMS Dave Cramer 04:05
Re: Worse perfomance on 8.2.0 than on 7.4.14 Simon Riggs 10:17
Missing the point of autovacuum Daryl Herzmann 18:59
Re: Missing the point of autovacuum Tobias Brox 19:33
Re: Missing the point of autovacuum Tom Lane 19:46

Jan. 7, 2007

Thread Author Time
Re: High update activity, PostgreSQL vs BigDBMS Guy Rouillier 04:22
Re: High update activity, PostgreSQL vs BigDBMS Guy Rouillier 04:32
table partioning performance Colin Taylor 04:37
Re: High update activity, PostgreSQL vs BigDBMS Joshua D. Drake 04:56
Re: High update activity, PostgreSQL vs BigDBMS Craig A. James 07:23
Re: High update activity, PostgreSQL vs BigDBMS Shane Ambler 09:04
Re: High update activity, PostgreSQL vs BigDBMS Dave Cramer 15:29
tweaking under repeatable load Ben 19:03
Re: High update activity, PostgreSQL vs BigDBMS Craig A. James 23:56

Jan. 8, 2007

Thread Author Time
Re: High update activity, PostgreSQL vs BigDBMS Adam Rich 02:26
Re: High update activity, PostgreSQL vs BigDBMS Tom Lane 02:47
Re: High update activity, PostgreSQL vs BigDBMS Joshua D. Drake 03:09
Re: High update activity, PostgreSQL vs BigDBMS Guy Rouillier 04:26
Re: High update activity, PostgreSQL vs BigDBMS Adam Rich 04:59
Re: High update activity, PostgreSQL vs BigDBMS Guy Rouillier 04:59
Re: High update activity, PostgreSQL vs BigDBMS Adam Rich 05:53
Re: tweaking under repeatable load Dimitri Fontaine 09:18
Re: table partioning performance Luke Lonergan 15:39
Re: High update activity, PostgreSQL vs BigDBMS Bruce Momjian 18:09
Re: Slow Query on Postgres 8.2 Dave Dutcher 18:59
Re: table partioning performance Steven Flatt 20:02

Jan. 9, 2007

Thread Author Time
Re: table partioning performance Merlin Moncure 00:35
Horribly slow query/ sequential scan Gregory S. Williamson 11:55
Re: High update activity, PostgreSQL vs BigDBMS Jim C. Nasby 12:33
Re: Horribly slow query/ sequential scan db 12:35
Re: table partioning performance Simon Riggs 12:48
Re: Horribly slow query/ sequential scan 12:50
Re: High update activity, PostgreSQL vs BigDBMS Jim C. Nasby 12:54
Re: Horribly slow query/ sequential scan Gregory S. Williamson 12:56
Re: Horribly slow query/ sequential scan Gregory S. Williamson 12:59
Re: Worse perfomance on 8.2.0 than on 7.4.14 Rolf Østvik 14:15
Running PG on cluster files systems Hannes Dorbath 14:15
Re: Horribly slow query/ sequential scan Dave Cramer 14:16
Re: Running PG on cluster files systems Devrim GUNDUZ 14:16
Re: Horribly slow query/ sequential scan Tom Lane 15:13
Re: Horribly slow query/ sequential scan Plugge, Joe R. 15:36
Re: Postgresql Configutation and overflow Jim C. Nasby 16:44
Re: High update activity, PostgreSQL vs BigDBMS Jeff Frost 17:10
High inserts, bulk deletes - autovacuum vs scheduled vacuum Jeremy Haile 17:26
Re: High inserts, bulk deletes - autovacuum vs scheduled vacuum Florian Weimer 18:02
Re: High inserts, bulk deletes - autovacuum vs scheduled Jeremy Haile 20:14
group by will not use an index? tsuraan 23:05
Re: group by will not use an index? Adam Rich 23:32
Re: Horribly slow query/ sequential scan Gregory S. Williamson 23:40
Re: group by will not use an index? Scott Marlowe 23:42

Jan. 10, 2007

Thread Author Time
Re: group by will not use an index? Brian Herlihy 01:07
Re: group by will not use an index? Steinar H. Gunderson 01:11
Re: group by will not use an index? Andrew Lazarus 01:41
Re: Horribly slow query/ sequential scan Tom Lane 05:55
Re: High inserts, bulk deletes - autovacuum vs scheduled vacuum Florian Weimer 09:33
Re: Horribly slow query/ sequential scan Tom Lane 14:53
Slow inner join, but left join is fast Jeremy Haile 16:17
Re: group by will not use an index? tsuraan 17:14
Re: Slow inner join, but left join is fast Tom Lane 17:15
Re: Slow inner join, but left join is fast Jeremy Haile 18:20
Re: Slow inner join, but left join is fast Tom Lane 18:38
Re: Slow inner join, but left join is fast Jeremy Haile 18:38
Re: Slow inner join, but left join is fast Jeremy Haile 18:44
Re: Slow inner join, but left join is fast Tom Lane 19:22
Re: Slow inner join, but left join is fast Jeremy Haile 19:26
Re: performance implications of binary placement Jim C. Nasby 20:01
Re: More 8.2 client issues (Was: [Slow dump?) Jim C. Nasby 20:07
Re: Performance of PostgreSQL on Windows vs Linux Jim C. Nasby 20:15
Re: PostgreSQL to host e-mail? Jim C. Nasby 20:18
Re: Partitioning Jim C. Nasby 20:20
Re: table partioning performance Jim C. Nasby 20:24
Re: High update activity, PostgreSQL vs BigDBMS Jim C. Nasby 20:26
Re: Partitioning Jeremy Haile 20:28
Re: Partitioning Erik Jones 20:30
Re: Performance of PostgreSQL on Windows vs Linux Jeremy Haile 20:32
Re: High update activity, PostgreSQL vs BigDBMS Jeff Frost 20:33
Re: High inserts, bulk deletes - autovacuum vs scheduled vacuum Jim C. Nasby 20:35
Re: Performance of PostgreSQL on Windows vs Linux Scott Marlowe 20:45
Re: table partioning performance Steven Flatt 21:00
Re: Partitioning Jim C. Nasby 21:09
Re: Partitioning Jeremy Haile 21:15
Re: High inserts, bulk deletes - autovacuum vs scheduled vacuum Jim C. Nasby 21:21
Re: Partitioning Scott Marlowe 21:30
Re: table partioning performance Steven Flatt 21:39
Re: High inserts, bulk deletes - autovacuum vs scheduled Jeremy Haile 21:48
Re: Partitioning Scott Marlowe 21:51

Jan. 11, 2007

Thread Author Time
UNSUBSCRIBE andrew 00:49
Re: table partioning performance Jim C. Nasby 01:23
Re: High inserts, bulk deletes - autovacuum vs scheduled vacuum Jim C. Nasby 01:27
Re: High inserts, bulk deletes - autovacuum vs scheduled vacuum Alvaro Herrera 03:10
Re: High inserts, bulk deletes - autovacuum vs scheduled vacuum Jim C. Nasby 03:42
Does it matters the column order in indexes and constraints creation? Arnau 10:56
Re: Does it matters the column order in indexes and constraints Richard Huxton 11:27
Re: table partioning performance Simon Riggs 12:15
Re: Partitioning Bernd Helmle 12:51
Re: Partitioning Mikael Carneholm 12:59
Re: Partitioning Jeremy Haile 14:02
Re: Partitioning Adam Rich 14:18
Re: Partitioning Bernd Helmle 14:32
unusual performance for vac following 8.2 upgrade Kim 17:20
Re: unusual performance for vac following 8.2 upgrade Russell Smith 18:07
Improving SQL performance Carlos H. Reimer 18:17
Re: unusual performance for vac following 8.2 upgrade Tom Lane 18:17
Re: unusual performance for vac following 8.2 upgrade Tom Lane 18:20
Re: Improving SQL performance Russell Smith 18:28
Re: Improving SQL performance Tom Lane 18:31
Re: unusual performance for vac following 8.2 upgrade Kim 19:13
Re: unusual performance for vac following 8.2 upgrade Tom Lane 19:45
Re: [HACKERS] unusual performance for vac following 8.2 upgrade Alvaro Herrera 19:49
Re: unusual performance for vac following 8.2 upgrade Simon Riggs 20:40
Re: [HACKERS] table partioning performance Jim C. Nasby 21:01
Re: [HACKERS] unusual performance for vac following 8.2 upgrade Tom Lane 21:11
RES: Improving SQL performance Carlos H. Reimer 21:14
Re: [HACKERS] unusual performance for vac following 8.2 upgrade Jim C. Nasby 21:16
Re: unusual performance for vac following 8.2 upgrade Kim 21:52
Re: unusual performance for vac following 8.2 upgrade Tom Lane 22:26
Re: [HACKERS] unusual performance for vac following 8.2 upgrade 📎 Tom Lane 23:10
Re: unusual performance for vac following 8.2 upgrade Kim 23:12
Re: [HACKERS] unusual performance for vac following 8.2upgrade Simon Riggs 23:14
Re: RES: Improving SQL performance Cesar Suga 23:47

Jan. 12, 2007

Thread Author Time
Re: [HACKERS] unusual performance for vac following 8.2upgrade Alvaro Herrera 01:09
Re: [HACKERS] unusual performance for vac following 8.2upgrade Tom Lane 02:51
Planner statistics, correlations Tobias Brox 08:16
Re: Planner statistics, correlations Peter Childs 08:56
Re: Planner statistics, correlations Tobias Brox 09:05
Re: [HACKERS] unusual performance for vac following 8.2upgrade Richard Huxton 09:06

Browse Archives

Prev | Next
Jump to day: 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 22 23 24 25 26 27 28 29 30 31