Skip site navigation (1)
Skip section navigation (2)
404 messages
13 February 2010
Re: Dell PERC H700/H800 Scott Marlowe (08:31)
Re: Re: 512,600ms query becomes 7500ms... but why? Postgres 8.3 query planner quirk? Bryce Nesbitt (08:09)
Re: 512,600ms query becomes 7500ms... but why? Postgres 8.3 query planner quirk? Bryce Nesbitt (07:58)
Re: Re: 512,600ms query becomes 7500ms... but why? Postgres 8.3 query planner quirk? Bryce Nesbitt (07:55)
Re: 512,600ms query becomes 7500ms... but why? Postgres 8.3 query planner quirk? Bryce Nesbitt (07:45)
Re: Dell PERC H700/H800 Greg Smith (07:06)
Re: moving pg_xlog -- yeah, it's worth it! Greg Smith (06:30)
12 February 2010
Re: Almost infinite query -> Different Query Plan when changing where clause value lionel duboeuf (20:32)
Re: moving pg_xlog -- yeah, it's worth it! Alvaro Herrera (20:11)
Re: 512,600ms query becomes 7500ms... but why? Postgres 8.3 query planner quirk? Tom Lane (20:07)
Re: Dell PERC H700/H800 Dave Crooke (19:04)
Re: Questions on plan with INSERT/SELECT on partitioned table Tom Lane (18:20)
Re: 512,600ms query becomes 7500ms... but why? Postgres 8.3 query planner quirk? Kevin Grittner (16:54)
Re: 512,600ms query becomes 7500ms... but why? Postgres 8.3 query planner quirk? Karl Denninger (16:44)
Questions on plan with INSERT/SELECT on partitioned table Connors, Bill (16:20)
Re: 512,600ms query becomes 7500ms... but why? Postgres 8.3 query planner quirk? Kevin Grittner (16:17)
Re: 512,600ms query becomes 7500ms... but why? Postgres 8.3 query planner quirk? Karl Denninger (16:07)
Re: 512,600ms query becomes 7500ms... but why? Postgres 8.3 query planner quirk? Kevin Grittner (15:09)
Re: Almost infinite query -> Different Query Plan when changing where clause value Kevin Grittner (15:05)
Re: moving pg_xlog -- yeah, it's worth it! Kevin Grittner (14:50)
Re: moving pg_xlog -- yeah, it's worth it! Alvaro Herrera (14:10)
Re: moving pg_xlog -- yeah, it's worth it! Alvaro Herrera (14:04)
Almost infinite query -> Different Query Plan when changing where clause value lionel duboeuf (13:35)
Re: Immutable table functions Yeb Havinga (13:31)
Re: moving pg_xlog -- yeah, it's worth it! Kevin Grittner (13:22)
Immutable table functions Luiz Angelo Daros de Luca (12:57)
11 February 2010
Re: Dell PERC H700/H800 Łukasz Jagiełło (21:27)
Re: Dell PERC H700/H800 James Mansion (20:11)
Re: moving pg_xlog -- yeah, it's worth it! Kevin Grittner (18:19)
Re: moving pg_xlog -- yeah, it's worth it! Aidan Van Dyk (18:04)
Re: moving pg_xlog -- yeah, it's worth it! Alvaro Herrera (17:58)
Re: moving pg_xlog -- yeah, it's worth it! Kevin Grittner (17:49)
Re: Dell PERC H700/H800 Scott Marlowe (17:43)
Re: Dell PERC H700/H800 Joshua D. Drake (17:28)
Re: moving pg_xlog -- yeah, it's worth it! Scott Marlowe (16:12)
Re: perf problem with huge table Leo Mannhart (14:39)
Re: Re: 512,600ms query becomes 7500ms... but why? Postgres 8.3 query planner quirk? Robert Haas (13:30)
Dell PERC H700/H800 Matthew Wakeling (12:39)
Re: moving pg_xlog -- yeah, it's worth it! Bruce Momjian (11:29)
Re: perf problem with huge table jesper (10:05)
Re: Re: 512,600ms query becomes 7500ms... but why? Postgres 8.3 query planner quirk? Tom Lane (03:53)
Re: How exactly PostgreSQL allocates memory for its needs? Scott Marlowe (03:47)
Re: [HACKERS] Re: Faster CREATE DATABASE by delaying fsync (was 8.4.1 ubuntu karmic slow createdb) Andres Freund (02:27)
Re: Linux I/O tuning: CFQ vs. deadline Greg Smith (02:09)
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 david (01:52)
Re: Linux I/O tuning: CFQ vs. deadline Greg Smith (01:46)
Re: perf problem with huge table Greg Smith (01:42)
Re: perf problem with huge table Dave Crooke (00:51)
Re: perf problem with huge table Jon Lewison (00:09)
10 February 2010
Re: perf problem with huge table Jon Lewison (23:31)
Re: Re: 512,600ms query becomes 7500ms... but why? Postgres 8.3 query planner quirk? Jorge Montero (23:21)
Re: perf problem with huge table Dave Crooke (23:16)
Re: perf problem with huge table Justin Graf (22:45)
perf problem with huge table rama (22:19)
Re: Re: 512,600ms query becomes 7500ms... but why? Postgres 8.3 query planner quirk? Robert Haas (20:32)
Re: Linux I/O tuning: CFQ vs. deadline Scott Carey (18:08)
Re: Deferred constraint and delete performance Andres Freund (17:36)
Re: Linux I/O tuning: CFQ vs. deadline Jeff (17:23)
Re: How exactly PostgreSQL allocates memory for its needs? Justin Graf (16:43)
Re: PostgreSQL - case studies Stephen Frost (15:55)
Re: PostgreSQL - case studies Kevin Grittner (15:49)
Re: [GENERAL] PostgreSQL - case studies Ing. Marcos L. Ortiz Valmaseda (15:47)
Re: Deferred constraint and delete performance Tom Lane (15:02)
Deferred constraint and delete performance Franck Routier (11:01)
Re: Re: 512,600ms query becomes 7500ms... but why? Postgres 8.3 query planner quirk? Pavel Stehule (09:12)
Re: 512,600ms query becomes 7500ms... but why? Postgres 8.3 query planner quirk? Bryce Nesbitt (08:49)
Re: Linux I/O tuning: CFQ vs. deadline Scott Marlowe (07:11)
Re: Linux I/O tuning: CFQ vs. deadline Greg Smith (06:37)
Re: [GENERAL] PostgreSQL - case studies Scott Marlowe (05:49)
How exactly PostgreSQL allocates memory for its needs? Anton Maksimenkov (05:10)
Re: PostgreSQL - case studies Amitabh Kant (04:39)
512,600ms query becomes 7500ms... but why? Postgres 8.3 query planner quirk? Bryce Nesbitt (04:34)
PostgreSQL - case studies Jayadevan M (04:11)
Re: DISTINCT vs. GROUP BY Dimi Paun (01:44)
09 February 2010
Re: DISTINCT vs. GROUP BY Thom Brown (22:22)
DISTINCT vs. GROUP BY Dimi Paun (22:12)
Re: Linux I/O tuning: CFQ vs. deadline Jeff (20:15)
Re: moving pg_xlog -- yeah, it's worth it! Kevin Grittner (17:45)
Re: moving pg_xlog -- yeah, it's worth it! Amitabh Kant (17:37)
Re: moving pg_xlog -- yeah, it's worth it! Kevin Grittner (16:33)
Re: moving pg_xlog -- yeah, it's worth it! Jesper Krogh (16:23)
moving pg_xlog -- yeah, it's worth it! Kevin Grittner (16:14)
Re: foreign key constraint lock behavour in postgresql Albe Laurenz (15:24)
Re: [GENERAL] index is not using Scott Marlowe (09:44)
Re: [GENERAL] index is not using Guillaume Lelarge (09:34)
Re: index is not using? Scott Marlowe (08:33)
index is not using? AI Rumman (08:12)
Re: Linux I/O tuning: CFQ vs. deadline david (04:35)
Re: Linux I/O tuning: CFQ vs. deadline Greg Smith (04:16)
Re: Linux I/O tuning: CFQ vs. deadline Greg Smith (04:14)
Re: Linux I/O tuning: CFQ vs. deadline Scott Carey (03:51)
Re: Linux I/O tuning: CFQ vs. deadline Mark Wong (01:18)
08 February 2010
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) Greg Stark (18:36)
Re: Linux I/O tuning: CFQ vs. deadline Josh Berkus (17:49)
Re: Linux I/O tuning: CFQ vs. deadline Greg Smith (15:30)
Re: Linux I/O tuning: CFQ vs. deadline Kevin Grittner (15:25)
Re: Linux I/O tuning: CFQ vs. deadline Albe Laurenz (14:58)
Linux I/O tuning: CFQ vs. deadline Greg Smith (09:45)
Re: foreign key constraint lock behavour in postgresql Albe Laurenz (08:58)
Re: [HACKERS] Re: Faster CREATE DATABASE by delaying fsync (was 8.4.1 ubuntu karmic slow createdb) Andres Freund (07:14)
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) Alvaro Herrera (03:15)
Re: [HACKERS] Re: Faster CREATE DATABASE by delaying fsync (was 8.4.1 ubuntu karmic slow createdb) Andres Freund (01:39)
07 February 2010
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) Tom Lane (16:24)
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) Robert Haas (05:13)
06 February 2010
Re: Slow query: table iteration (8.3) Robert Haas (11:46)
Re: [HACKERS] Re: Faster CREATE DATABASE by delaying fsync (was 8.4.1 ubuntu karmic slow createdb) Greg Smith (05:17)
Re: Slow query: table iteration (8.3) Glenn Maynard (01:43)
05 February 2010
Re: foreign key constraint lock behavour in postgresql Robert Haas (18:17)
Re: index on partitioned table Nikolas Everett (15:10)
index on partitioned table Wojtek (12:38)
Re: Slow query: table iteration (8.3) Yeb Havinga (11:17)
Re: foreign key constraint lock behavour in postgresql Albe Laurenz (09:00)
Re: Slow query: table iteration (8.3) Glenn Maynard (03:05)
Re: foreign key constraint lock behavour in postgresql Robert Haas (02:11)
Re: Slow-ish Query Needs Some Love Robert Haas (01:49)
04 February 2010
Re: bigint integers up to 19 digits. Alvaro Herrera (20:09)
Re: bigint integers up to 19 digits. Jochen Erwied (19:02)
Re: bigint integers up to 19 digits. Tory M Blue (18:52)
Re: bigint integers up to 19 digits. Alvaro Herrera (18:48)
Re: bigint integers up to 19 digits. Craig James (18:44)
bigint integers up to 19 digits. Tory M Blue (18:16)
Re: Optimizing Postgresql server and FreeBSD for heavy read and writes Matthew Wakeling (11:20)
Re: Air-traffic benchmark Simon Riggs (10:41)
Re: Optimizing Postgresql server and FreeBSD for heavy read and writes Amitabh Kant (10:08)
Re: Optimizing Postgresql server and FreeBSD for heavy read and writes Amitabh Kant (09:53)
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:17)
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:03)
Re: Re: Optimizing Postgresql server and FreeBSD for heavy read and writes Amitabh Kant (09:00)
Re: Slow query: table iteration (8.3) Grzegorz Jaśkiewicz (08:29)
Re: Slow query: table iteration (8.3) Glenn Maynard (08:24)
Re: some problems when i use postgresql 8.4.2 in my projects . Pierre Frédéric Caillau d (07:30)
Re: Slow query: table iteration (8.3) Glenn Maynard (06:35)
Re: foreign key constraint lock behavour in postgresql david (05:41)
foreign key constraint lock behavour in postgresql wangyuxiang (04:05)
Re: Slow query: table iteration (8.3) Robert Haas (03:06)
Re: System overload / context switching / oom, 8.3 Greg Smith (02:18)
Re: System overload / context switching / oom, 8.3 Rob Lemley (01:28)
03 February 2010
Re: Optimizing Postgresql server and FreeBSD for heavy read and writes Robert Haas (20:44)
Re: System overload / context switching / oom, 8.3 Robert Haas (20:41)
Re: Queries within a function Mridula Mahadevan (20:06)
Re: Slow-ish Query Needs Some Love Andy Colson (18:51)
Re: Optimizing Postgresql server and FreeBSD for heavy read and writes Andy Colson (18:41)
Re: Optimizing Postgresql server and FreeBSD for heavy read and writes Ivan Voras (16:37)
Re: Re: Optimizing Postgresql server and FreeBSD for heavy read and writes Reid Thompson (16:19)
Re: Queries within a function Віталій Тимчишин (16:12)
Re: queries with subquery constraints on partitioned tables not optimized? Nikolas Everett (15:54)
Re: some problems when i use postgresql 8.4.2 in my projects . Leo Mannhart (15:18)
Optimizing Postgresql server and FreeBSD for heavy read and writes Amitabh Kant (15:13)
Re: Optimizing Postgresql server and FreeBSD for heavy read and writes Amitabh Kant (15:13)
Re: some problems when i use postgresql 8.4.2 in my projects . Robert Haas (14:58)
Re: [HACKERS] Re: Faster CREATE DATABASE by delaying fsync (was 8.4.1 ubuntu karmic slow createdb) Andres Freund (14:20)
Re: [HACKERS] Re: Faster CREATE DATABASE by delaying fsync (was 8.4.1 ubuntu karmic slow createdb) Robert Haas (13:43)
Re: [HACKERS] Re: Faster CREATE DATABASE by delaying fsync (was 8.4.1 ubuntu karmic slow createdb) Andres Freund (12:05)
Re: [HACKERS] Re: Faster CREATE DATABASE by delaying fsync (was 8.4.1 ubuntu karmic slow createdb) Greg Stark (11:55)
Re: System overload / context switching / oom, 8.3 Matthew Wakeling (11:31)
Re: queries with subquery constraints on partitioned tables not optimized? Dimitri Fontaine (10:27)
Re: the jokes for pg concurrency write performance J Sisson (08:32)
Re: System overload / context switching / oom, 8.3 Greg Smith (07:48)
Re: the jokes for pg concurrency write performance Greg Smith (07:36)
Re: Queries within a function ramasubramanian (04:24)
some problems when i use postgresql 8.4.2 in my projects . wyx6fox (02:28)
Peripheral Links
Header And Logo
|
Site Navigation
pgsql-performance 2010-02 Chronological Index (2/3)
Last updated: Wed Jan 18 04:14:02 2012404 messages
- 14 February 2010
- Re: Deferred constraint and delete performance Віталій Тимчишин (11:21)
- Re: 512,600ms query becomes 7500ms... but why? Postgres 8.3 query planner quirk? Pierre Frédéric Caillau d (15:37)
- Re: Almost infinite query -> Different Query Plan when changing where clause value Kevin Grittner (21:00)
- Re: Dell PERC H700/H800 Scott Marlowe (21:55)
- Re: perf problem with huge table Dave Crooke (23:48)
- Re: DISTINCT vs. GROUP BY Tom Lane (22:38)
- Re: index on partitioned table Robert Haas (18:30)
- Re: Slow query: table iteration (8.3) Robert Haas (21:57)
- Re: Optimizing Postgresql server and FreeBSD for heavy read and writes Greg Smith (21:59)