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 - January 2011

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 21 23 24 25 26 27 28 29 30 31

2011-01-02

Re: encourging bitmap AND Jim Nasby (21:00)
Re: CPU bound Jim Nasby (21:57)

2011-01-03

Re: How to turn autovacuum prevent wrap around run faster? marc.hsiao (02:01)
Re: CPU bound Mladen Gogala (16:17)

2011-01-04

Question: BlockSize > 8192 with FusionIO Strange, John W (00:33)
Re: Question: BlockSize > 8192 with FusionIO Greg Smith (02:13)
Re: Performance of PostgreSQL over NFS Greg Smith (02:28)
Re: adding foreign key constraint locks up table Florian Weimer (13:52)
Re: concurrent IO in postgres? Greg Smith (13:53)
Re: PostgreSQL Greg Smith (14:07)
Re: adding foreign key constraint locks up table Tom Lane (15:21)
Re: Question: BlockSize > 8192 with FusionIO Merlin Moncure (16:48)
Same stament sometime fast, something slow Fernando Mertins (18:03)
Re: Same stament sometime fast, something slow Kevin Grittner (18:12)
Re: Question: BlockSize > 8192 with FusionIO Ben Chobot (18:36)
Re: Question: BlockSize > 8192 with FusionIO Strange, John W (19:01)
Re: Question: BlockSize > 8192 with FusionIO Strange, John W (20:31)

2011-01-05

Re: Same stament sometime fast, something slow Craig Ringer (01:24)
Re: Same stament sometime fast, something slow Greg Smith (01:51)
Re: Question: BlockSize > 8192 with FusionIO Scott Carey (06:41)
Re: adding foreign key constraint locks up table kakarukeys (07:09)
Re: Major performance problem after upgrade from 8.3 to 8.4 Marc Antonio (20:06)
Wrong docs on wal_buffers? Josh Berkus (20:43)
Re: Wrong docs on wal_buffers? Jeff Janes (21:45)
plan question - query with order by and limit not choosing index depends on size of limit, table Mike Broers (22:57)
Re: Wrong docs on wal_buffers? Pierre C (22:58)
Re: plan question - query with order by and limit not choosing index depends on size of limit, table Kevin Grittner (23:10)

2011-01-06

Re: Wrong docs on wal_buffers? Josh Berkus (18:58)
Re: postgres performance tunning Robert Haas (21:31)
Re: plan question - query with order by and limit not choosing index depends on size of limit, table Mike Broers (21:36)
Re: postgres performance tunning Scott Marlowe (21:41)
Re: postgres performance tunning Scott Marlowe (21:41)
Re: Wrong docs on wal_buffers? Scott Carey (21:50)
Re: Wrong docs on wal_buffers? Jeff Janes (23:02)

2011-01-07

"SELECT .. WHERE NOT IN" query running for hours Γιωργος Βαλκανας (02:36)
Re: How to turn autovacuum prevent wrap around run faster? marc47marc47 (03:57)
Re: "SELECT .. WHERE NOT IN" query running for hours Mladen Gogala (04:25)
Re: Wrong docs on wal_buffers? Greg Smith (04:37)
Re: How to turn autovacuum prevent wrap around run faster? marc.hsiao (08:14)
Re: "SELECT .. WHERE NOT IN" query running for hours Γιωργος Βαλκανας (09:29)
Wrong docs on checkpoint_segments? Florian Weimer (12:45)
Re: Wrong docs on checkpoint_segments? Andres Freund (13:39)
Re: Wrong docs on checkpoint_segments? Florian Weimer (13:45)
Re: Wrong docs on checkpoint_segments? Andres Freund (13:47)
Re: plan question - query with order by and limit not choosing index depends on size of limit, table pasman pasmański (14:00)
Re: Wrong docs on wal_buffers? Samuel Gendler (14:09)
Re: Wrong docs on wal_buffers? Tom Lane (15:07)
Re: Wrong docs on wal_buffers? Samuel Gendler (17:25)
Re: Wrong docs on wal_buffers? Greg Smith (18:46)

2011-01-08

pgbench to the MAXINT Greg Smith (01:59)

2011-01-09

Re: adding foreign key constraint locks up table Robert Haas (03:34)
Re: MySQL HandlerSocket - Is this possible in PG? Dimitri Fontaine (13:58)

2011-01-10

Re: pgbench to the MAXINT Euler Taveira de Oliveira (05:17)
Re: pgbench to the MAXINT Greg Smith (08:25)
Re: plan question - query with order by and limit not choosing index depends on size of limit, table Mike Broers (16:21)
Re: "SELECT .. WHERE NOT IN" query running for hours Mladen Gogala (17:28)
Re: "SELECT .. WHERE NOT IN" query running for hours Scott Carey (20:24)
Re: "SELECT .. WHERE NOT IN" query running for hours Kevin Grittner (20:37)
Re: "SELECT .. WHERE NOT IN" query running for hours Scott Carey (21:05)

2011-01-11

Re: Problems with FTS Rauan Maemirov (08:16)
Re: pgbench to the MAXINT Euler Taveira de Oliveira (21:34)

2011-01-12

Re: Performance of PostgreSQL over NFS Jignesh Shah (01:43)
Performance test of Oracle and PostgreSQL using same binary Divakar Singh (06:54)
Re: How to turn autovacuum prevent wrap around run faster? marc.hsiao (08:21)
Slow query + why bitmap index scan?? Laszlo Nagy (12:14)
Re: Slow query + why bitmap index scan?? Florian Weimer (13:42)
The good, old times Mladen Gogala (13:49)
Re: The good, old times Guillaume Cottenceau (14:16)
Re: Slow query + why bitmap index scan?? Laszlo Nagy (14:21)
Re: Slow query + why bitmap index scan?? Kenneth Marshall (14:26)
Re: Slow query + why bitmap index scan?? Kevin Grittner (14:36)
Re: Slow query + why bitmap index scan?? Laszlo Nagy (15:20)
Re: Slow query + why bitmap index scan?? Kevin Grittner (16:31)
Re: Performance test of Oracle and PostgreSQL using same binary Jeff Janes (17:11)
Re: Slow query + why bitmap index scan?? Cédric Villemain (20:09)

2011-01-13

Re: adding foreign key constraint locks up table kakarukeys (15:33)
queries with lots of UNIONed relations Jon Nelson (15:51)
queries with lots of UNIONed relations Jon Nelson (15:55)
Re: queries with lots of UNIONed relations Tom Lane (17:13)
Re: queries with lots of UNIONed relations Jon Nelson (19:54)
Re: queries with lots of UNIONed relations Tom Lane (20:05)
Re: queries with lots of UNIONed relations Jon Nelson (20:12)
Re: queries with lots of UNIONed relations Robert Haas (21:44)
Re: queries with lots of UNIONed relations Tom Lane (22:26)
Re: queries with lots of UNIONed relations Robert Haas (22:41)
Re: queries with lots of UNIONed relations Robert Haas (22:42)
Re: queries with lots of UNIONed relations Andy Colson (22:47)
Re: queries with lots of UNIONed relations Robert Haas (22:49)
Re: queries with lots of UNIONed relations Andy Colson (22:52)
Re: queries with lots of UNIONed relations Jon Nelson (22:53)
Re: queries with lots of UNIONed relations Tom Lane (23:05)
Re: queries with lots of UNIONed relations Tom Lane (23:07)
Re: queries with lots of UNIONed relations Jon Nelson (23:14)

2011-01-14

Re: queries with lots of UNIONed relations Tom Lane (00:10)
Re: queries with lots of UNIONed relations Mladen Gogala (03:19)
Re: The good, old times Craig Ringer (06:02)
Re: queries with lots of UNIONed relations Vitalii Tymchyshyn (11:39)
Re: plan question - query with order by and limit not choosing index depends on size of limit, table Mike Broers (16:36)
Re: The good, old times Mladen Gogala (16:54)
Re: plan question - query with order by and limit not choosing index depends on size of limit, table Robert Haas (18:03)
Re: "SELECT .. WHERE NOT IN" query running for hours Robert Haas (19:01)
Re: Problems with FTS Robert Haas (19:03)
"COPY TO stdout" statements occurrence in log files Fernando Mertins (19:42)
Re: queries with lots of UNIONed relations Jon Nelson (20:11)
Re: "COPY TO stdout" statements occurrence in log files Maciek Sakrejda (20:27)
Best way to get the latest revision from a table Nikolas Everett (21:17)
Re: "COPY TO stdout" statements occurrence in log files Chris Browne (21:19)
Re: Best way to get the latest revision from a table Kevin Grittner (22:30)
Re: Best way to get the latest revision from a table Nikolas Everett (22:40)
Re: "COPY TO stdout" statements occurrence in log files Marti Raudsepp (22:42)
Re: Best way to get the latest revision from a table Kevin Grittner (22:57)
Re: Best way to get the latest revision from a table Shaun Thomas (23:06)
Re: Best way to get the latest revision from a table Kevin Grittner (23:33)
Re: Best way to get the latest revision from a table Tom Lane (23:40)

2011-01-15

Re: Best way to get the latest revision from a table Kevin Grittner (00:59)
Re: Best way to get the latest revision from a table Nikolas Everett (01:50)
Re: The good, old times Craig Ringer (13:36)
Problem with query Barbara Woolums (17:56)
Re: queries with lots of UNIONed relations Jon Nelson (18:15)
Re: Best way to get the latest revision from a table Shaun Thomas (19:54)
Re: Best way to get the latest revision from a table Shaun Thomas (19:58)

2011-01-16

Re: The good, old times Craig Ringer (06:50)

2011-01-17

Possible to improve query plan? Jeremy Palmer (03:21)
Re: Possible to improve query plan? Andy Colson (04:22)
Possible to improve query plan? Jeremy Palmer (04:43)
Re: Possible to improve query plan? Andy Colson (04:57)
Re: Possible to improve query plan? Jeremy Palmer (05:13)
Bad plan when join on function Zotov (08:03)
Re: Possible to improve query plan? Jayadevan M (08:44)
Re: Possible to improve query plan? Ing. Marcos Ortiz Valmaseda (13:37)
"NOT IN" substantially slower in 9.0.2 than 8.3.13 - NOT EXISTS runs fast in both 8.3.13 and 9.0.2 Achilleas Mantzios (15:35)
Re: "NOT IN" substantially slower in 9.0.2 than 8.3.13 - NOT EXISTS runs fast in both 8.3.13 and 9.0.2 Mladen Gogala (16:47)
Re: Possible to improve query plan? Kevin Grittner (16:48)
Re: "NOT IN" substantially slower in 9.0.2 than 8.3.13 - NOT EXISTS runs fast in both 8.3.13 and 9.0.2 Ing. Marcos Ortiz Valmaseda (16:52)
Re: Bad plan when join on function Pavel Stehule (20:12)
Re: Possible to improve query plan? Tom Lane (20:24)
Re: Bad plan when join on function Kevin Grittner (20:51)
Re: Possible to improve query plan? Jeremy Palmer (20:52)
Re: Possible to improve query plan? Jeremy Palmer (21:01)
Re: Bad plan when join on function Pavel Stehule (21:24)
Re: Bad plan when join on function Tom Lane (21:33)
Re: Bad plan when join on function Pavel Stehule (21:37)
Re: Possible to improve query plan? Mladen Gogala (22:11)
Re: Problem with query Fernando Hevia (23:42)

2011-01-18

Re: "NOT IN" substantially slower in 9.0.2 than 8.3.13 - NOT EXISTS runs fast in both 8.3.13 and 9.0.2 Achilleas Mantzios (08:06)
Re: The good, old times Devrim GÜNDÜZ (08:43)
Re: The good, old times Dave Page (08:57)
Migrating to Postgresql and new hardware Lars (10:56)
Re: Bad plan when join on function Shaun Thomas (14:15)
Re: "NOT IN" substantially slower in 9.0.2 than 8.3.13 - NOT EXISTS runs fast in both 8.3.13 and 9.0.2 Mladen Gogala (14:26)
Re: [PERFORM] pgbench to the MAXINT Greg Smith (18:42)
Re: hashed subplan 5000x slower than two sequential operations masterchief (18:56)
Re: Migrating to Postgresql and new hardware Andy Colson (19:17)
Re: Migrating to Postgresql and new hardware Andy Colson (19:19)
Re: hashed subplan 5000x slower than two sequential operations Віталій Тимчишин (21:29)
Re: Migrating to Postgresql and new hardware Strange, John W (22:06)
Re: Migrating to Postgresql and new hardware Mark Felder (22:53)

2011-01-19

Re: Migrating to Postgresql and new hardware mark (04:09)
Re: Migrating to Postgresql and new hardware Craig Ringer (07:26)
Re: Migrating to Postgresql and new hardware Scott Marlowe (07:49)
Re: Migrating to Postgresql and new hardware Lars (08:17)
Re: Migrating to Postgresql and new hardware Lars (08:45)
Re: Migrating to Postgresql and new hardware Lars (09:09)
Re: "NOT IN" substantially slower in 9.0.2 than 8.3.13 - NOT EXISTS runs fast in both 8.3.13 and 9.0.2 Achilleas Mantzios (09:10)
the XID question Charles.Hou (09:19)
Re: the XID question Charles.Hou (10:21)
Re: the XID question Filip Rembiałkowski (12:00)
Re: the XID question Kevin Grittner (14:39)
Re: the XID question Charles.Hou (14:54)
Re: Running PostgreSQL as fast as possible no matter the consequences Bruce Momjian (17:07)
Re: "NOT IN" substantially slower in 9.0.2 than 8.3.13 - NOT EXISTS runs fast in both 8.3.13 and 9.0.2 Tom Lane (17:26)
Re: Running PostgreSQL as fast as possible no matter the consequences Fabrízio de Royes Mello (17:27)
Re: the XID question Chris Browne (18:06)
Re: the XID question Andres Freund (18:31)
Re: the XID question Kevin Grittner (18:41)
Re: anti-join chosen even when slower than old plan Bruce Momjian (19:47)
Re: anti-join chosen even when slower than old plan Bruce Momjian (20:03)
Re: anti-join chosen even when slower than old plan Bruce Momjian (20:04)
Re: the XID question Greg Smith (22:46)

2011-01-20

Re: Migrating to Postgresql and new hardware Craig Ringer (00:42)
Re: "NOT IN" substantially slower in 9.0.2 than 8.3.13 - NOT EXISTS runs fast in both 8.3.13 and 9.0.2 Achilleas Mantzios (07:05)
Re: the XID question Charles.Hou (07:26)
Re: anti-join chosen even when slower than old plan Cédric Villemain (09:17)
Re: anti-join chosen even when slower than old plan Robert Haas (14:19)
Re: Migrating to Postgresql and new hardware Andy Colson (14:48)
Re: Running PostgreSQL as fast as possible no matter the consequences Robert Haas (15:25)
Re: Migrating to Postgresql and new hardware Scott Marlowe (15:43)
Re: anti-join chosen even when slower than old plan Cédric Villemain (16:16)
Re: anti-join chosen even when slower than old plan Cédric Villemain (16:36)
Re: the XID question Kevin Grittner (17:04)
copy command and blobs Madhu Ramachandran (20:12)
Re: copy command and blobs Mladen Gogala (20:17)
Re: copy command and blobs Tom Lane (21:11)

2011-01-21

Re: "NOT IN" substantially slower in 9.0.2 than 8.3.13 - NOT EXISTS runs fast in both 8.3.13 and 9.0.2 Robert Haas (17:09)
Re: Best way to get the latest revision from a table Robert Haas (17:13)
Re: "NOT IN" substantially slower in 9.0.2 than 8.3.13 - NOT EXISTS runs fast in both 8.3.13 and 9.0.2 Mladen Gogala (17:42)
Re: the XID question Robert Haas (17:49)
Re: "NOT IN" substantially slower in 9.0.2 than 8.3.13 - NOT EXISTS runs fast in both 8.3.13 and 9.0.2 Robert Haas (17:51)
Fun little performance IMPROVEMENT... grant (18:12)
Re: "NOT IN" substantially slower in 9.0.2 than 8.3.13 - NOT EXISTS runs fast in both 8.3.13 and 9.0.2 Mladen Gogala (18:12)

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 21 23 24 25 26 27 28 29 30 31

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