pgsql-performance 2010-02 Thread Index (2/3)

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

Peripheral Links

Text Size: Normal / Large
Donate
Contact

Header And Logo

PostgreSQL

|

The world's most advanced open source database.

Site Navigation

pgsql-performance 2010-02 Thread Index (2/3)

Last updated: Wed Jan 18 04:14:02 2012
404 messages

Re: Immutable table functions, (continued)
- Re: Immutable table functions Yeb Havinga (Fri 12 13:31)
Dell PERC H700/H800 Matthew Wakeling (Thu 11 12:39)

Re: Dell PERC H700/H800 Joshua D. Drake (Thu 11 17:28)

Re: Dell PERC H700/H800 Stefan Kaltenbrunner (Wed 17 13:08)

Re: Dell PERC H700/H800 Scott Marlowe (Thu 11 17:43)
Re: Dell PERC H700/H800 James Mansion (Thu 11 20:11)

Re: Dell PERC H700/H800 Łukasz Jagiełło (Thu 11 21:27)
Re: Dell PERC H700/H800 Scott Marlowe (Thu 11 21:55)

Re: Dell PERC H700/H800 Dave Crooke (Fri 12 19:04)

Re: Dell PERC H700/H800 Greg Smith (Sat 13 07:06)

Re: Dell PERC H700/H800 Scott Marlowe (Sat 13 08:31)
Re: Dell PERC H700/H800 Bruce Momjian (Tue 16 14:12)

perf problem with huge table rama (Wed 10 22:19)

Re: perf problem with huge table Justin Graf (Wed 10 22:45)
Re: perf problem with huge table Dave Crooke (Wed 10 23:16)

Re: perf problem with huge table Jon Lewison (Wed 10 23:31)

Re: perf problem with huge table Dave Crooke (Wed 10 23:48)

Re: perf problem with huge table Jon Lewison (Thu 11 00:09)

Re: perf problem with huge table Dave Crooke (Thu 11 00:51)

Re: perf problem with huge table Leo Mannhart (Thu 11 14:39)

Re: perf problem with huge table Greg Smith (Thu 11 01:42)
Re: perf problem with huge table jesper (Thu 11 10:05)

Deferred constraint and delete performance Franck Routier (Wed 10 11:01)

Re: Deferred constraint and delete performance Tom Lane (Wed 10 15:02)

Re: Deferred constraint and delete performance Andres Freund (Wed 10 17:36)
Re: Deferred constraint and delete performance Віталій Тимчишин (Sun 14 11:21)

How exactly PostgreSQL allocates memory for its needs? Anton Maksimenkov (Wed 10 05:10)

Re: How exactly PostgreSQL allocates memory for its needs? Justin Graf (Wed 10 16:43)

Re: How exactly PostgreSQL allocates memory for its needs? Scott Marlowe (Thu 11 03:47)

512,600ms query becomes 7500ms... but why? Postgres 8.3 query planner quirk? Bryce Nesbitt (Wed 10 04:34)

Re: 512,600ms query becomes 7500ms... but why? Postgres 8.3 query planner quirk? Bryce Nesbitt (Wed 10 08:49)

Re: Re: 512,600ms query becomes 7500ms... but why? Postgres 8.3 query planner quirk? Pavel Stehule (Wed 10 09:12)
Re: Re: 512,600ms query becomes 7500ms... but why? Postgres 8.3 query planner quirk? Robert Haas (Wed 10 20:32)

Re: Re: 512,600ms query becomes 7500ms... but why? Postgres 8.3 query planner quirk? Jorge Montero (Wed 10 23:21)
Re: Re: 512,600ms query becomes 7500ms... but why? Postgres 8.3 query planner quirk? Bryce Nesbitt (Thu 11 01:52)

Re: Re: 512,600ms query becomes 7500ms... but why? Postgres 8.3 query planner quirk? Tom Lane (Thu 11 03:53)

Re: Re: 512,600ms query becomes 7500ms... but why? Postgres 8.3 query planner quirk? Bryce Nesbitt (Sat 13 07:55)
Re: Re: 512,600ms query becomes 7500ms... but why? Postgres 8.3 query planner quirk? Bryce Nesbitt (Sat 13 08:09)

Re: Re: 512,600ms query becomes 7500ms... but why? Postgres 8.3 query planner quirk? Robert Haas (Thu 11 13:30)

Re: 512,600ms query becomes 7500ms... but why? Postgres 8.3 query planner quirk? Kevin Grittner (Fri 12 15:09)

Re: 512,600ms query becomes 7500ms... but why? Postgres 8.3 query planner quirk? Karl Denninger (Fri 12 16:07)

Re: 512,600ms query becomes 7500ms... but why? Postgres 8.3 query planner quirk? Kevin Grittner (Fri 12 16:17)

Re: 512,600ms query becomes 7500ms... but why? Postgres 8.3 query planner quirk? Karl Denninger (Fri 12 16:44)

Re: 512,600ms query becomes 7500ms... but why? Postgres 8.3 query planner quirk? Kevin Grittner (Fri 12 16:54)
Re: 512,600ms query becomes 7500ms... but why? Postgres 8.3 query planner quirk? Tom Lane (Fri 12 20:07)
Re: 512,600ms query becomes 7500ms... but why? Postgres 8.3 query planner quirk? Bryce Nesbitt (Sat 13 07:58)
Re: 512,600ms query becomes 7500ms... but why? Postgres 8.3 query planner quirk? Pierre Frédéric Caillau d (Sat 13 15:37)
Re: 512,600ms query becomes 7500ms... but why? Postgres 8.3 query planner quirk? Robert Haas (Mon 15 16:42)

Re: 512,600ms query becomes 7500ms... but why? Postgres 8.3 query planner quirk? Bryce Nesbitt (Sat 13 07:45)

PostgreSQL - case studies Jayadevan M (Wed 10 04:11)

Re: PostgreSQL - case studies Amitabh Kant (Wed 10 04:39)
Re: [GENERAL] PostgreSQL - case studies Scott Marlowe (Wed 10 05:49)

Re: [GENERAL] PostgreSQL - case studies Ing. Marcos L. Ortiz Valmaseda (Wed 10 15:47)

Re: PostgreSQL - case studies Kevin Grittner (Wed 10 15:49)

Re: PostgreSQL - case studies Stephen Frost (Wed 10 15:55)

DISTINCT vs. GROUP BY Dimi Paun (Tue 09 22:12)

Re: DISTINCT vs. GROUP BY Thom Brown (Tue 09 22:22)
Re: DISTINCT vs. GROUP BY Tom Lane (Tue 09 22:38)

Re: DISTINCT vs. GROUP BY Dimi Paun (Wed 10 01:44)

moving pg_xlog -- yeah, it's worth it! Kevin Grittner (Tue 09 16:14)

Re: moving pg_xlog -- yeah, it's worth it! Jesper Krogh (Tue 09 16:23)

Re: moving pg_xlog -- yeah, it's worth it! Kevin Grittner (Tue 09 16:33)

Re: moving pg_xlog -- yeah, it's worth it! Amitabh Kant (Tue 09 17:37)

Re: moving pg_xlog -- yeah, it's worth it! Kevin Grittner (Tue 09 17:45)

Re: moving pg_xlog -- yeah, it's worth it! Bruce Momjian (Thu 11 11:29)

Re: moving pg_xlog -- yeah, it's worth it! Scott Marlowe (Thu 11 16:12)

Re: moving pg_xlog -- yeah, it's worth it! Kevin Grittner (Thu 11 17:49)

Re: moving pg_xlog -- yeah, it's worth it! Alvaro Herrera (Thu 11 17:58)

Re: moving pg_xlog -- yeah, it's worth it! Aidan Van Dyk (Thu 11 18:04)
Re: moving pg_xlog -- yeah, it's worth it! Kevin Grittner (Thu 11 18:19)

<Possible follow-ups>
Re: moving pg_xlog -- yeah, it's worth it! Kevin Grittner (Fri 12 13:22)

Re: moving pg_xlog -- yeah, it's worth it! Alvaro Herrera (Fri 12 14:04)

Re: moving pg_xlog -- yeah, it's worth it! Alvaro Herrera (Fri 12 14:10)

Re: moving pg_xlog -- yeah, it's worth it! Kevin Grittner (Fri 12 14:50)

Re: moving pg_xlog -- yeah, it's worth it! Alvaro Herrera (Fri 12 20:11)

Re: moving pg_xlog -- yeah, it's worth it! Greg Smith (Sat 13 06:30)

Re: moving pg_xlog -- yeah, it's worth it! Kevin Grittner (Tue 23 21:24)

Re: moving pg_xlog -- yeah, it's worth it! Ben Chobot (Tue 23 22:14)

Re: [GENERAL] index is not using Guillaume Lelarge (Tue 09 09:34)

<Possible follow-ups>
Re: [GENERAL] index is not using Scott Marlowe (Tue 09 09:44)

index is not using? AI Rumman (Tue 09 08:12)

Re: index is not using? Scott Marlowe (Tue 09 08:33)

Linux I/O tuning: CFQ vs. deadline Greg Smith (Mon 08 09:45)

Re: Linux I/O tuning: CFQ vs. deadline Albe Laurenz (Mon 08 14:58)

Re: Linux I/O tuning: CFQ vs. deadline Kevin Grittner (Mon 08 15:25)

Re: Linux I/O tuning: CFQ vs. deadline Greg Smith (Mon 08 15:30)

Re: Linux I/O tuning: CFQ vs. deadline Josh Berkus (Mon 08 17:49)

Re: Linux I/O tuning: CFQ vs. deadline Scott Marlowe (Mon 08 18:59)
Re: Linux I/O tuning: CFQ vs. deadline Mark Wong (Tue 09 01:18)
Re: Linux I/O tuning: CFQ vs. deadline Scott Carey (Tue 09 03:51)
Re: Linux I/O tuning: CFQ vs. deadline Greg Smith (Tue 09 04:14)
Re: Linux I/O tuning: CFQ vs. deadline Jeff Davis (Tue 16 21:33)

Message not available
- Re: Linux I/O tuning: CFQ vs. deadline Greg Smith (Tue 09 04:16)
- Re: Linux I/O tuning: CFQ vs. deadline david (Tue 09 04:35)
- Re: Linux I/O tuning: CFQ vs. deadline Jeff (Tue 09 20:15)
- Re: Linux I/O tuning: CFQ vs. deadline Greg Smith (Wed 10 06:37)
- Re: Linux I/O tuning: CFQ vs. deadline Scott Marlowe (Wed 10 07:11)
- Re: Linux I/O tuning: CFQ vs. deadline Greg Smith (Thu 11 01:46)
- Re: Linux I/O tuning: CFQ vs. deadline david (Thu 11 01:52)
- Re: Linux I/O tuning: CFQ vs. deadline Greg Smith (Thu 11 02:09)
- Re: Linux I/O tuning: CFQ vs. deadline Jeff (Wed 10 17:23)
- Re: Linux I/O tuning: CFQ vs. deadline Scott Carey (Wed 10 18:08)

index on partitioned table Wojtek (Fri 05 12:38)

Re: index on partitioned table Nikolas Everett (Fri 05 15:10)
Re: index on partitioned table Robert Haas (Fri 05 18:30)

bigint integers up to 19 digits. Tory M Blue (Thu 04 18:16)

Re: bigint integers up to 19 digits. Craig James (Thu 04 18:44)

Re: bigint integers up to 19 digits. Tory M Blue (Thu 04 18:52)

Re: bigint integers up to 19 digits. Jochen Erwied (Thu 04 19:02)

Re: bigint integers up to 19 digits. Alvaro Herrera (Thu 04 20:09)

Re: bigint integers up to 19 digits. Alvaro Herrera (Thu 04 18:48)

Re: Air-traffic benchmark Simon Riggs (Thu 04 10:41)
foreign key constraint lock behavour in postgresql wangyuxiang (Thu 04 04:05)

Re: foreign key constraint lock behavour in postgresql david (Thu 04 05:41)

Re: foreign key constraint lock behavour in postgresql Robert Haas (Fri 05 02:11)

Re: foreign key constraint lock behavour in postgresql Albe Laurenz (Fri 05 09:00)

Re: foreign key constraint lock behavour in postgresql Robert Haas (Fri 05 18:17)

Re: foreign key constraint lock behavour in postgresql Albe Laurenz (Mon 08 08:58)
Re: foreign key constraint lock behavour in postgresql Albe Laurenz (Tue 09 15:24)

Optimizing Postgresql server and FreeBSD for heavy read and writes Amitabh Kant (Wed 03 15:13)

Re: Optimizing Postgresql server and FreeBSD for heavy read and writes Amitabh Kant (Wed 03 15:13)

Re: Re: Optimizing Postgresql server and FreeBSD for heavy read and writes Reid Thompson (Wed 03 16:19)

Re: Re: Optimizing Postgresql server and FreeBSD for heavy read and writes Amitabh Kant (Thu 04 09:00)

Re: Optimizing Postgresql server and FreeBSD for heavy read and writes Ivan Voras (Wed 03 16:37)

Re: Optimizing Postgresql server and FreeBSD for heavy read and writes Amitabh Kant (Thu 04 09:03)

Re: Optimizing Postgresql server and FreeBSD for heavy read and writes Ivan Voras (Thu 04 09:40)

Re: Optimizing Postgresql server and FreeBSD for heavy read and writes Amitabh Kant (Thu 04 09:53)

Re: Optimizing Postgresql server and FreeBSD for heavy read and writes Matthew Wakeling (Thu 04 11:20)

Re: Optimizing Postgresql server and FreeBSD for heavy read and writes Andy Colson (Wed 03 18:41)

Re: Optimizing Postgresql server and FreeBSD for heavy read and writes Amitabh Kant (Thu 04 09:17)

Re: Optimizing Postgresql server and FreeBSD for heavy read and writes Robert Haas (Wed 03 20:44)

Re: Optimizing Postgresql server and FreeBSD for heavy read and writes Greg Smith (Wed 03 21:59)

Re: Optimizing Postgresql server and FreeBSD for heavy read and writes Amitabh Kant (Thu 04 10:08)

some problems when i use postgresql 8.4.2 in my projects . wyx6fox (Wed 03 02:28)

Re: some problems when i use postgresql 8.4.2 in my projects . Robert Haas (Wed 03 14:58)
Re: some problems when i use postgresql 8.4.2 in my projects . Leo Mannhart (Wed 03 15:18)
Re: some problems when i use postgresql 8.4.2 in my projects . Pierre Frédéric Caillau d (Thu 04 07:30)

System overload / context switching / oom, 8.3 Rob (Tue 02 20:17)

Re: System overload / context switching / oom, 8.3 Scott Marlowe (Tue 02 20:39)

Re: System overload / context switching / oom, 8.3 Rob (Tue 02 21:44)

Re: System overload / context switching / oom, 8.3 Kevin Grittner (Tue 02 20:42)

Re: System overload / context switching / oom, 8.3 Rob (Tue 02 21:59)

Re: System overload / context switching / oom, 8.3 Andy Colson (Tue 02 20:47)
Re: System overload / context switching / oom, 8.3 Andy Colson (Tue 02 20:50)

Re: System overload / context switching / oom, 8.3 Greg Smith (Wed 03 07:48)
Re: System overload / context switching / oom, 8.3 Robert Haas (Wed 03 20:41)
Re: System overload / context switching / oom, 8.3 Rob Lemley (Thu 04 01:28)

Re: System overload / context switching / oom, 8.3 Greg Smith (Thu 04 02:18)

Re: System overload / context switching / oom, 8.3 Matthew Wakeling (Wed 03 11:31)

Queries within a function Mridula Mahadevan (Tue 02 18:53)

Re: Queries within a function Pavel Stehule (Tue 02 20:07)
Re: Queries within a function Tom Lane (Tue 02 20:22)

Re: Queries within a function Mridula Mahadevan (Tue 02 20:54)

Re: Queries within a function ramasubramanian (Wed 03 04:24)

Re: Queries within a function Ing. Marcos Ortiz Valmaseda (Tue 02 20:30)

Re: Queries within a function Mridula Mahadevan (Tue 02 20:47)

Re: Queries within a function Віталій Тимчишин (Wed 03 16:12)

Re: Queries within a function Mridula Mahadevan (Wed 03 20:06)

Re: [HACKERS] Re: Faster CREATE DATABASE by delaying fsync (was 8.4.1 ubuntu karmic slow createdb) Robert Haas (Tue 02 18:49)

Re: [HACKERS] Re: Faster CREATE DATABASE by delaying fsync (was 8.4.1 ubuntu karmic slow createdb) Andres Freund (Tue 02 18:44)

Re: [HACKERS] Re: Faster CREATE DATABASE by delaying fsync (was 8.4.1 ubuntu karmic slow createdb) Tom Lane (Tue 02 18:44)

Re: [HACKERS] Re: Faster CREATE DATABASE by delaying fsync (was 8.4.1 ubuntu karmic slow createdb) Robert Haas (Tue 02 18:52)

Re: [HACKERS] Re: Faster CREATE DATABASE by delaying fsync (was 8.4.1 ubuntu karmic slow createdb) Andres Freund (Tue 02 18:55)

Re: [HACKERS] Re: Faster CREATE DATABASE by delaying fsync (was 8.4.1 ubuntu karmic slow createdb) Robert Haas (Tue 02 19:07)
Re: [HACKERS] Re: Faster CREATE DATABASE by delaying fsync (was 8.4.1 ubuntu karmic slow createdb) Andres Freund (Tue 02 19:18)
Re: [HACKERS] Re: Faster CREATE DATABASE by delaying fsync (was 8.4.1 ubuntu karmic slow createdb) Tom Lane (Tue 02 20:24)
Re: [HACKERS] Re: Faster CREATE DATABASE by delaying fsync (was 8.4.1 ubuntu karmic slow createdb) Robert Haas (Tue 02 20:28)
Re: [HACKERS] Re: Faster CREATE DATABASE by delaying fsync (was 8.4.1 ubuntu karmic slow createdb) Greg Stark (Wed 03 11:55)
Re: [HACKERS] Re: Faster CREATE DATABASE by delaying fsync (was 8.4.1 ubuntu karmic slow createdb) Andres Freund (Wed 03 12:05)
Re: [HACKERS] Re: Faster CREATE DATABASE by delaying fsync (was 8.4.1 ubuntu karmic slow createdb) Robert Haas (Wed 03 13:43)
Re: [HACKERS] Re: Faster CREATE DATABASE by delaying fsync (was 8.4.1 ubuntu karmic slow createdb) Andres Freund (Wed 03 14:20)
Re: [HACKERS] Re: Faster CREATE DATABASE by delaying fsync (was 8.4.1 ubuntu karmic slow createdb) Greg Smith (Sat 06 05:17)
Re: [HACKERS] Re: Faster CREATE DATABASE by delaying fsync (was 8.4.1 ubuntu karmic slow createdb) Andres Freund (Sat 06 12:04)
Re: [HACKERS] Re: Faster CREATE DATABASE by delaying fsync (was 8.4.1 ubuntu karmic slow createdb) Robert Haas (Sun 07 05:13)
Re: [HACKERS] Re: Faster CREATE DATABASE by delaying fsync (was 8.4.1 ubuntu karmic slow createdb) Greg Smith (Sun 07 09:23)
Re: [HACKERS] Re: Faster CREATE DATABASE by delaying fsync (was 8.4.1 ubuntu karmic slow createdb) Tom Lane (Sun 07 16:24)
Re: [HACKERS] Re: Faster CREATE DATABASE by delaying fsync (was 8.4.1 ubuntu karmic slow createdb) Robert Haas (Sun 07 18:23)
Re: [HACKERS] Re: Faster CREATE DATABASE by delaying fsync (was 8.4.1 ubuntu karmic slow createdb) Andres Freund (Sun 07 18:27)
Re: [HACKERS] Re: Faster CREATE DATABASE by delaying fsync (was 8.4.1 ubuntu karmic slow createdb) Andres Freund (Mon 08 01:39)
Re: [HACKERS] Re: Faster CREATE DATABASE by delaying fsync (was 8.4.1 ubuntu karmic slow createdb) Alvaro Herrera (Mon 08 03:15)

Mail converted by MHonArc

Privacy Policy | About PostgreSQL
Copyright © 1996 – 2012 PostgreSQL Global Development Group