Skip site navigation (1) Skip section navigation (2)

Peripheral Links

Text Size: Normal / Large
Donate
Contact

PostgreSQL

The world's most advanced open source database.

pgsql-performance - February 2010

Prev | Next

Jump to day: 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 20 21 22 23 24 25 26 27 28

Feb. 1, 2010

Re: Constraint propagating for equal fields Віталій Тимчишин (13:30)
Re: Slow query: table iteration (8.3) Yeb Havinga (14:54)

Feb. 2, 2010

Slow-ish Query Needs Some Love Matt White (00:53)
Re: Slow query: table iteration (8.3) Glenn Maynard (02:52)
use pgsql in a big project, but i found pg has some big problem on concurrency write operation, maybe a joke for myself ! wyx6fox (04:39)
the jokes for pg concurrency write performance wyx6fox (04:57)
Re: use pgsql in a big project, but i found pg has some big problem on concurrency write operation, maybe a joke for myself ! Kevin Grittner (05:06)
Re: the jokes for pg concurrency write performance david (05:08)
Re: the jokes for pg concurrency write performance Richard Broersma (05:54)
Sincere apology for my insults and hand-waving in these mails:the jokes for pg concurrency write performance wyx6fox (06:55)
queries with subquery constraints on partitioned tables not optimized? Davor J. (09:48)
Re: Slow query: table iteration (8.3) Yeb Havinga (10:06)
Re: Slow-ish Query Needs Some Love Edgardo Portal (13:06)
Re: 回复：Re: [PERFORM] the jokes for pg concurre?==?UTF-8?Q?ncy write performance Richard Broersma (15:43)
Re: use pgsql in a big project, but i found pg has some big problem on concurrency write operation, maybe a joke for myself ! Greg Stark (16:08)
Re: the jokes for pg concurrency write performance Scott Marlowe (16:12)
Re: the jokes for pg concurrency write performance Alvaro Herrera (16:20)
Re: the jokes for pg concurrency write performance Scott Marlowe (16:27)
Re: [HACKERS] Re: Faster CREATE DATABASE by delaying fsync (was 8.4.1 ubuntu karmic slow createdb) Robert Haas (17:36)
Re: [HACKERS] Re: Faster CREATE DATABASE by delaying fsync (was 8.4.1 ubuntu karmic slow createdb) Andres Freund (17:43)
Re: [HACKERS] Re: Faster CREATE DATABASE by delaying fsync (was 8.4.1 ubuntu karmic slow createdb) Tom Lane (17:50)
Re: [HACKERS] Re: Faster CREATE DATABASE by delaying fsync (was 8.4.1 ubuntu karmic slow createdb) Robert Haas (18:14)
Queries within a function Mridula Mahadevan (18:17)
Re: [HACKERS] Re: Faster CREATE DATABASE by delaying fsync (was 8.4.1 ubuntu karmic slow createdb) Andres Freund (18:34)
Re: Slow-ish Query Needs Some Love Matt White (19:03)
Re: [HACKERS] Re: Faster CREATE DATABASE by delaying fsync (was 8.4.1 ubuntu karmic slow createdb) Robert Haas (19:06)
Re: Queries within a function Pavel Stehule (19:07)
Re: [HACKERS] Re: Faster CREATE DATABASE by delaying fsync (was 8.4.1 ubuntu karmic slow createdb) Andres Freund (19:08)
System overload / context switching / oom, 8.3 Rob (19:11)
Re: Queries within a function Tom Lane (19:27)
Re: [HACKERS] Re: Faster CREATE DATABASE by delaying fsync (was 8.4.1 ubuntu karmic slow createdb) Tom Lane (19:33)
Re: [HACKERS] Re: Faster CREATE DATABASE by delaying fsync (was 8.4.1 ubuntu karmic slow createdb) Robert Haas (19:45)
Re: Re: 回复：Re: [PERFORM] the jokes for pg concurrency write performance Tom Lane (19:58)
Re: Queries within a function Ing. Marcos Ortiz Valmaseda (19:59)
Re: Slow-ish Query Needs Some Love Andy Colson (20:11)
Re: System overload / context switching / oom, 8.3 Scott Marlowe (20:25)
Re: System overload / context switching / oom, 8.3 Kevin Grittner (20:29)
Re: System overload / context switching / oom, 8.3 Andy Colson (20:36)
Re: Queries within a function Mridula Mahadevan (20:36)
Re: System overload / context switching / oom, 8.3 Andy Colson (20:47)
Re: Queries within a function Mridula Mahadevan (20:53)
Re: System overload / context switching / oom, 8.3 Rob (21:44)
Re: System overload / context switching / oom, 8.3 Rob (21:59)

Feb. 3, 2010

Re: queries with subquery constraints on partitioned tables not optimized? Tom Lane (00:14)
some problems when i use postgresql 8.4.2 in my projects . wyx6fox (02:28)
Re: Queries within a function ramasubramanian (04:24)
Re: the jokes for pg concurrency write performance Greg Smith (07:35)
Re: System overload / context switching / oom, 8.3 Greg Smith (07:48)
Re: the jokes for pg concurrency write performance J Sisson (08:31)
Re: queries with subquery constraints on partitioned tables not optimized? Dimitri Fontaine (10:23)
Re: System overload / context switching / oom, 8.3 Matthew Wakeling (11:30)
Re: [HACKERS] Re: Faster CREATE DATABASE by delaying fsync (was 8.4.1 ubuntu karmic slow createdb) Greg Stark (11:53)
Re: [HACKERS] Re: Faster CREATE DATABASE by delaying fsync (was 8.4.1 ubuntu karmic slow createdb) Andres Freund (12:03)
Re: [HACKERS] Re: Faster CREATE DATABASE by delaying fsync (was 8.4.1 ubuntu karmic slow createdb) Robert Haas (13:42)
Re: [HACKERS] Re: Faster CREATE DATABASE by delaying fsync (was 8.4.1 ubuntu karmic slow createdb) Andres Freund (14:19)
Re: some problems when i use postgresql 8.4.2 in my projects . Robert Haas (14:58)
Optimizing Postgresql server and FreeBSD for heavy read and writes Amitabh Kant (15:10)
Re: Optimizing Postgresql server and FreeBSD for heavy read and writes Amitabh Kant (15:12)
Re: some problems when i use postgresql 8.4.2 in my projects . Leo Mannhart (15:16)
Re: queries with subquery constraints on partitioned tables not optimized? Nikolas Everett (15:54)
Re: Queries within a function Віталій Тимчишин (16:10)
Re: Re: Optimizing Postgresql server and FreeBSD for heavy read and writes Reid Thompson (16:19)
Re: Optimizing Postgresql server and FreeBSD for heavy read and writes Ivan Voras (16:35)
Re: Optimizing Postgresql server and FreeBSD for heavy read and writes Andy Colson (18:41)
Re: Slow-ish Query Needs Some Love Andy Colson (18:50)
Re: Queries within a function Mridula Mahadevan (20:06)
Re: System overload / context switching / oom, 8.3 Robert Haas (20:40)
Re: Optimizing Postgresql server and FreeBSD for heavy read and writes Robert Haas (20:43)
Re: Optimizing Postgresql server and FreeBSD for heavy read and writes Greg Smith (21:59)

Feb. 4, 2010

Re: System overload / context switching / oom, 8.3 Rob Lemley (01:27)
Re: System overload / context switching / oom, 8.3 Greg Smith (02:17)
Re: Slow query: table iteration (8.3) Robert Haas (03:05)
foreign key constraint lock behavour in postgresql wangyuxiang (04:05)
Re: foreign key constraint lock behavour in postgresql david (05:40)
Re: Slow query: table iteration (8.3) Glenn Maynard (06:30)
Re: some problems when i use postgresql 8.4.2 in my projects . Pierre Frédéric Caillaud (07:32)
Re: Slow query: table iteration (8.3) Glenn Maynard (08:24)
Re: Slow query: table iteration (8.3) Grzegorz Jaśkiewicz (08:28)
Re: Re: Optimizing Postgresql server and FreeBSD for heavy read and writes Amitabh Kant (08:59)
Re: Optimizing Postgresql server and FreeBSD for heavy read and writes Amitabh Kant (09:02)
Re: Slow query: table iteration (8.3) Glenn Maynard (09:09)
Re: Optimizing Postgresql server and FreeBSD for heavy read and writes Amitabh Kant (09:16)
Re: Optimizing Postgresql server and FreeBSD for heavy read and writes Ivan Voras (09:40)
Re: Optimizing Postgresql server and FreeBSD for heavy read and writes Amitabh Kant (09:52)
Re: Optimizing Postgresql server and FreeBSD for heavy read and writes Amitabh Kant (10:07)
Re: Air-traffic benchmark Simon Riggs (10:41)
Re: Optimizing Postgresql server and FreeBSD for heavy read and writes Matthew Wakeling (11:19)
bigint integers up to 19 digits. Tory M Blue (18:15)
Re: bigint integers up to 19 digits. Craig James (18:43)
Re: bigint integers up to 19 digits. Alvaro Herrera (18:47)
Re: bigint integers up to 19 digits. Tory M Blue (18:51)
Re: bigint integers up to 19 digits. Jochen Erwied (19:01)
Re: bigint integers up to 19 digits. Alvaro Herrera (20:09)
Re: Slow query: table iteration (8.3) Robert Haas (21:57)

Feb. 5, 2010

Re: Slow-ish Query Needs Some Love Robert Haas (01:49)
Re: foreign key constraint lock behavour in postgresql Robert Haas (02:11)
Re: Slow query: table iteration (8.3) Glenn Maynard (03:04)
Re: foreign key constraint lock behavour in postgresql Albe Laurenz (09:00)
Re: Slow query: table iteration (8.3) Yeb Havinga (11:17)
index on partitioned table Wojtek (12:32)
Re: index on partitioned table Nikolas Everett (15:08)
Re: foreign key constraint lock behavour in postgresql Robert Haas (18:17)
Re: index on partitioned table Robert Haas (18:23)

Feb. 6, 2010

Re: Slow query: table iteration (8.3) Glenn Maynard (01:35)
Re: [HACKERS] Re: Faster CREATE DATABASE by delaying fsync (was 8.4.1 ubuntu karmic slow createdb) Greg Smith (05:03)
Re: Slow query: table iteration (8.3) Robert Haas (06:31)
Re: [HACKERS] Re: Faster CREATE DATABASE by delaying fsync (was 8.4.1 ubuntu karmic slow createdb) Andres Freund (12:03)

Feb. 7, 2010

Re: [HACKERS] Re: Faster CREATE DATABASE by delaying fsync (was 8.4.1 ubuntu karmic slow createdb) Robert Haas (05:13)
Re: [HACKERS] Re: Faster CREATE DATABASE by delaying fsync (was 8.4.1 ubuntu karmic slow createdb) Greg Smith (09:23)
Re: [HACKERS] Re: Faster CREATE DATABASE by delaying fsync (was 8.4.1 ubuntu karmic slow createdb) Tom Lane (16:24)
Re: [HACKERS] Re: Faster CREATE DATABASE by delaying fsync (was 8.4.1 ubuntu karmic slow createdb) Robert Haas (18:23)
Re: [HACKERS] Re: Faster CREATE DATABASE by delaying fsync (was 8.4.1 ubuntu karmic slow createdb) Andres Freund (18:27)

Feb. 8, 2010

Re: [HACKERS] Re: Faster CREATE DATABASE by delaying fsync (was 8.4.1 ubuntu karmic slow createdb) Andres Freund (01:31)
Re: [HACKERS] Re: Faster CREATE DATABASE by delaying fsync (was 8.4.1 ubuntu karmic slow createdb) Alvaro Herrera (03:09)
Re: [HACKERS] Re: Faster CREATE DATABASE by delaying fsync (was 8.4.1 ubuntu karmic slow createdb) Robert Haas (04:53)
Re: [HACKERS] Re: Faster CREATE DATABASE by delaying fsync (was 8.4.1 ubuntu karmic slow createdb) Andres Freund (07:13)
Re: foreign key constraint lock behavour in postgresql Albe Laurenz (08:57)
Linux I/O tuning: CFQ vs. deadline Greg Smith (09:45)
Re: Linux I/O tuning: CFQ vs. deadline Albe Laurenz (14:57)
Re: Linux I/O tuning: CFQ vs. deadline Kevin Grittner (15:24)
Re: Linux I/O tuning: CFQ vs. deadline Greg Smith (15:30)
Re: Linux I/O tuning: CFQ vs. deadline Josh Berkus (17:49)
Re: [HACKERS] Re: Faster CREATE DATABASE by delaying fsync (was 8.4.1 ubuntu karmic slow createdb) Greg Stark (18:34)
Re: Linux I/O tuning: CFQ vs. deadline Scott Marlowe (18:59)
Re: [HACKERS] Re: Faster CREATE DATABASE by delaying fsync (was 8.4.1 ubuntu karmic slow createdb) Andres Freund (19:29)

Feb. 9, 2010

Re: Linux I/O tuning: CFQ vs. deadline Mark Wong (01:14)
Re: Linux I/O tuning: CFQ vs. deadline Scott Carey (03:50)
Re: Linux I/O tuning: CFQ vs. deadline Greg Smith (04:14)
Re: Linux I/O tuning: CFQ vs. deadline Greg Smith (04:16)
Re: Linux I/O tuning: CFQ vs. deadline david (04:35)
index is not using AI Rumman (07:43)
index is not using? AI Rumman (07:55)
Re: index is not using? Scott Marlowe (08:33)
Re: index is not using Guillaume Lelarge (09:34)
Re: index is not using Scott Marlowe (09:43)
Re: foreign key constraint lock behavour in postgresql Albe Laurenz (15:22)
moving pg_xlog -- yeah, it's worth it! Kevin Grittner (16:14)
Re: moving pg_xlog -- yeah, it's worth it! Jesper Krogh (16:22)
Re: moving pg_xlog -- yeah, it's worth it! Kevin Grittner (16:33)
Re: moving pg_xlog -- yeah, it's worth it! Amitabh Kant (17:37)
Re: moving pg_xlog -- yeah, it's worth it! Kevin Grittner (17:44)
Re: Linux I/O tuning: CFQ vs. deadline Jeff (19:14)
DISTINCT vs. GROUP BY Dimi Paun (21:46)
Re: DISTINCT vs. GROUP BY Thom Brown (22:22)
Re: DISTINCT vs. GROUP BY Tom Lane (22:38)

Feb. 10, 2010

Re: DISTINCT vs. GROUP BY Dimi Paun (01:43)
512,600ms query becomes 7500ms... but why? Postgres 8.3 query planner quirk? Bryce Nesbitt (04:04)
PostgreSQL - case studies Jayadevan M (04:09)
Re: PostgreSQL - case studies Amitabh Kant (04:38)
How exactly PostgreSQL allocates memory for its needs? Anton Maksimenkov (05:10)
Re: PostgreSQL - case studies Scott Marlowe (05:49)
Re: Linux I/O tuning: CFQ vs. deadline Greg Smith (06:37)
Re: Linux I/O tuning: CFQ vs. deadline Scott Marlowe (07:11)
Re: 512,600ms query becomes 7500ms... but why? Postgres 8.3 query planner quirk? Bryce Nesbitt (08:29)
Re: Re: 512,600ms query becomes 7500ms... but why? Postgres 8.3 query planner quirk? Pavel Stehule (09:11)
Re: [PERFORM] PostgreSQL - case studies Ing. Marcos L. Ortiz Valmaseda (09:47)
Deferred constraint and delete performance Franck Routier (10:55)
Re: Deferred constraint and delete performance Tom Lane (14:56)
Re: [PERFORM] PostgreSQL - case studies Kevin Grittner (15:47)
Re: [PERFORM] PostgreSQL - case studies Stephen Frost (15:55)
Re: [PERFORM] PostgreSQL - case studies David Boreham (16:10)
Re: How exactly PostgreSQL allocates memory for its needs? Justin Graf (16:43)
Re: Linux I/O tuning: CFQ vs. deadline Jeff (17:22)
Re: Deferred constraint and delete performance Andres Freund (17:36)
Re: Linux I/O tuning: CFQ vs. deadline Scott Carey (18:04)
Re: Re: 512,600ms query becomes 7500ms... but why? Postgres 8.3 query planner quirk? Robert Haas (20:31)
perf problem with huge table rama (22:13)
Re: perf problem with huge table Justin Graf (22:45)
Re: perf problem with huge table Dave Crooke (23:16)
Re: Re: 512,600ms query becomes 7500ms... but why?Postgres 8.3 query planner quirk? Jorge Montero (23:18)
Re: perf problem with huge table Jon Lewison (23:30)
Re: perf problem with huge table Dave Crooke (23:48)

Feb. 11, 2010

Re: perf problem with huge table Jon Lewison (00:09)
Re: perf problem with huge table Dave Crooke (00:51)
Re: perf problem with huge table Greg Smith (01:42)
Re: Linux I/O tuning: CFQ vs. deadline Greg Smith (01:46)
Re: Linux I/O tuning: CFQ vs. deadline david (01:52)
Re: Re: 512,600ms query becomes 7500ms... but why? Postgres 8.3 query planner quirk? Bryce Nesbitt (01:52)
Re: Linux I/O tuning: CFQ vs. deadline Greg Smith (02:09)
Re: [HACKERS] Re: Faster CREATE DATABASE by delaying fsync (was 8.4.1 ubuntu karmic slow createdb) Andres Freund (02:27)
Re: How exactly PostgreSQL allocates memory for its needs? Scott Marlowe (03:46)
Re: Re: 512,600ms query becomes 7500ms... but why? Postgres 8.3 query planner quirk? Tom Lane (03:52)
Re: perf problem with huge table jesper (10:05)
Re: moving pg_xlog -- yeah, it's worth it! Bruce Momjian (11:29)
Dell PERC H700/H800 Matthew Wakeling (12:39)
Re: Re: 512,600ms query becomes 7500ms... but why? Postgres 8.3 query planner quirk? Robert Haas (13:29)
Re: perf problem with huge table Leo Mannhart (14:39)
Re: moving pg_xlog -- yeah, it's worth it! Scott Marlowe (16:12)
Re: Dell PERC H700/H800 Joshua D. Drake (17:26)
Re: Dell PERC H700/H800 Scott Marlowe (17:42)
Re: moving pg_xlog -- yeah, it's worth it! Kevin Grittner (17:48)
Re: moving pg_xlog -- yeah, it's worth it! Alvaro Herrera (17:57)
Re: moving pg_xlog -- yeah, it's worth it! Aidan Van Dyk (18:04)
Re: moving pg_xlog -- yeah, it's worth it! Kevin Grittner (18:19)
Re: Dell PERC H700/H800 James Mansion (20:11)
Re: Dell PERC H700/H800 Łukasz Jagiełło (20:58)
Re: Dell PERC H700/H800 Scott Marlowe (21:55)

Feb. 12, 2010

Immutable table functions Luiz Angelo Daros de Luca (12:54)
Re: moving pg_xlog -- yeah, it's worth it! Kevin Grittner (13:21)
Re: Immutable table functions Yeb Havinga (13:31)

Prev | Next

Jump to day: 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 20 21 22 23 24 25 26 27 28

Privacy Policy | About PostgreSQL
Copyright © 1996-2013 The PostgreSQL Global Development Group