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

2011-12-01

Re: Guidance Requested - Bulk Inserting + Queries Benjamin Johnson (02:00)
Re: Problems with FTS Jesper Krogh (06:11)
Re: Guidance Requested - Bulk Inserting + Queries Jeff Janes (15:06)
Re: vacuum internals and performance affect Josh Berkus (18:01)
Re: Autovacuum Issue Robert Haas (18:18)
Re: vacuum internals and performance affect MirrorX (19:23)
Re: Autovacuum Issue Mark Kirkwood (22:35)

2011-12-02

Re: Autovacuum Issue Scott Marlowe (03:02)
Intersect/Union X AND/OR Thiago Godoi (15:55)
Re: Intersect/Union X AND/OR Bruce Momjian (19:49)
Re: Intersect/Union X AND/OR Merlin Moncure (20:52)

2011-12-03

Question about VACUUM Ernesto Quiñones (03:32)
Re: Question about VACUUM Scott Marlowe (03:42)
pg_upgrade Tory M Blue (04:09)
Re: Question about VACUUM Ernesto Quiñones (13:11)
Re: pg_upgrade Klaus Ita (14:03)
Re: pg_upgrade Bruce Momjian (14:04)
manually force planner to use of index A vs index B MirrorX (14:34)
Re: manually force planner to use of index A vs index B Tomas Vondra (15:10)
Re: manually force planner to use of index A vs index B MirrorX (15:15)
Re: Question about VACUUM Kevin Grittner (16:00)
Re: pg_upgrade Tory M Blue (19:35)
Re: Question about VACUUM Scott Marlowe (20:05)
Re: pg_upgrade Bruce Momjian (23:42)

2011-12-04

Re: pg_upgrade Bruce Momjian (02:20)
Re: unlogged tables Pierre C (12:28)

2011-12-05

Re: Intersect/Union X AND/OR Thiago Godoi (12:14)
Re: pg_upgrade Nicholson, Brad (Toronto, ON, CA) (13:36)
Re: Intersect/Union X AND/OR Bruce Momjian (15:19)
Re: pg_upgrade Bruce Momjian (15:24)
Re: pg_upgrade Nicholson, Brad (Toronto, ON, CA) (15:29)
Re: pg_upgrade Bruce Momjian (15:34)
Re: Question about VACUUM Ernesto Quiñones (17:19)
Re: pg_upgrade Tory M Blue (17:21)
Re: Question about VACUUM Scott Marlowe (17:42)
Re: Question about VACUUM Scott Marlowe (17:44)
Re: Question about VACUUM Ernesto Quiñones (17:46)
Re: pg_upgrade Bruce Momjian (18:22)
Re: pg_upgrade Tory M Blue (18:31)
Re: Question about VACUUM Kevin Grittner (18:36)
Re: pg_upgrade Tory M Blue (19:00)
Re: pg_upgrade Bruce Momjian (19:08)
Re: pg_upgrade Bruce Momjian (19:08)
Re: Question about VACUUM Scott Marlowe (20:29)
Re: pg_upgrade Tory M Blue (23:25)

2011-12-06

Different query plans on same servers Mario Splivalo (19:48)
Re: Different query plans on same servers Tom Lane (20:00)
Re: Different query plans on same servers Kevin Grittner (20:17)
Re: Different query plans on same servers Kevin Grittner (20:29)
Response time increases over time Havasvölgyi Ottó (21:30)

2011-12-07

Re: Different query plans on same servers Mario Splivalo (00:23)
Re: Different query plans on same servers Mario Splivalo (00:27)
Re: Different query plans on same servers Mario Splivalo (00:35)
Re: Response time increases over time Josh Berkus (04:11)
Re: Question about VACUUM Josh Berkus (04:13)
Re: Response time increases over time Havasvölgyi Ottó (08:23)
Re: Different query plans on same servers Mario Splivalo (09:34)
Re: Response time increases over time Mario Splivalo (09:35)
Re: Intersect/Union X AND/OR Marti Raudsepp (14:56)
Re: Question about VACUUM Kevin Grittner (15:14)
Partitions and joins lead to index lookups on all partitions Christiaan Willemsen (15:15)
autovacuum, any log? Anibal David Acosta (15:34)
Re: pg_upgrade Tory M Blue (20:13)
Re: autovacuum, any log? Scott Marlowe (20:19)
Re: Partitions and joins lead to index lookups on all partitions Ondrej Ivanič (21:36)
Re: Response time increases over time Havasvölgyi Ottó (22:13)
Re: pg_upgrade failure "contrib" issue? Tory M Blue (23:53)

2011-12-08

Re: Response time increases over time Aidan Van Dyk (04:37)
Re: Response time increases over time Havasvölgyi Ottó (08:50)
Re: Response time increases over time Marti Raudsepp (13:44)
Re: Partitions and joins lead to index lookups on all partitions voodooless (13:57)
Re: Response time increases over time Havasvölgyi Ottó (15:48)
Re: Response time increases over time Bob Lunney (15:58)
Re: Response time increases over time Havasvölgyi Ottó (17:21)
Slow query after upgrade from 8.2 to 8.4 Kaloyan Iliev Iliev (17:29)
Re: Slow query after upgrade from 8.2 to 8.4 Shaun Thomas (17:52)
Re: pg_upgrade Bruce Momjian (20:14)

2011-12-09

Re: Slow query after upgrade from 8.2 to 8.4 Tom Lane (03:28)
Re: Slow query after upgrade from 8.2 to 8.4 Kaloyan Iliev Iliev (12:23)
Re: Slow query after upgrade from 8.2 to 8.4 Tom Lane (15:30)

2011-12-10

Common slow query reasons - help with a special log Daniel Cristian Cruz (16:52)
Re: Common slow query reasons - help with a special log Andreas Kretschmer (17:25)
Re: Common slow query reasons - help with a special log Tomas Vondra (17:25)
Re: Common slow query reasons - help with a special log Daniel Cristian Cruz (22:40)
Re: Common slow query reasons - help with a special log Tomas Vondra (23:50)

2011-12-11

copy vs. C function Jon Nelson (01:27)
Re: Common slow query reasons - help with a special log Daniel Cristian Cruz (01:27)
Re: copy vs. C function Craig Ringer (02:32)
Re: copy vs. C function Sam Gendler (02:35)
Re: copy vs. C function Jon Nelson (03:08)
Re: Common slow query reasons - help with a special log Tomas Vondra (03:11)

2011-12-12

autovacuum, exclude table Anibal David Acosta (14:25)
Re: autovacuum, exclude table Craig Ringer (14:45)
Re: autovacuum, exclude table Anibal David Acosta (14:55)
Re: autovacuum, exclude table Heikki Linnakangas (15:16)
Re: autovacuum, exclude table Tom Lane (15:26)
Re: copy vs. C function Merlin Moncure (16:38)

2011-12-13

Postgres array parser Aleksej Trofimov (13:55)
Re: Postgres array parser Pavel Stehule (14:02)
Re: Postgres array parser Aleksej Trofimov (14:28)
Re: copy vs. C function Jon Nelson (14:29)
Re: Postgres array parser Pavel Stehule (14:42)
select distinct uses index scan vs full table scan Jon Nelson (18:12)
Re: select distinct uses index scan vs full table scan Tom Lane (19:57)
Re: select distinct uses index scan vs full table scan Jon Nelson (20:17)
Re: Slow query after upgrade from 8.2 to 8.4 Mark Kirkwood (22:13)

2011-12-14

Re: copy vs. C function Tom Lane (06:18)
Re: copy vs. C function idc danny (07:02)
Re: Postgres array parser Marc Mamin (09:21)
Re: Postgres array parser Aleksej Trofimov (09:59)
Re: Postgres array parser Marc Mamin (10:27)
Re: copy vs. C function Kevin Martyn (13:14)
Re: copy vs. C function Jon Nelson (14:06)
Re: copy vs. C function idc danny (14:32)
Re: copy vs. C function Tom Lane (15:25)
Re: copy vs. C function Jon Nelson (15:40)
Re: copy vs. C function Jon Nelson (15:51)
Is it possible to use index on column for regexp match operator '~'? Rural Hunter (16:05)
Re: Partitions and joins lead to index lookups on all partitions voodooless (16:06)
Re: Slow query after upgrade from 8.2 to 8.4 Kaloyan Iliev Iliev (17:48)
Re: Is it possible to use index on column for regexp match operator '~'? Marti Raudsepp (20:43)

2011-12-15

Re: Is it possible to use index on column for regexp match operator '~'? Rural Hunter (01:54)
Re: copy vs. C function Jon Nelson (03:18)

2011-12-16

Slow nested loop execution on larger server Greg Smith (18:27)
Re: Slow nested loop execution on larger server Scott Marlowe (21:16)

2011-12-17

will the planner ever use an index when the condition is <> ? Roxanne Reid-Bennett (15:30)
Re: will the planner ever use an index when the condition is <> ? Filip Rembiałkowski (16:24)

2011-12-18

Re: will the planner ever use an index when the condition is <> ? Віталій Тимчишин (10:41)
Re: will the planner ever use an index when the condition is <> ? Roxanne Reid-Bennett (14:52)
Re: will the planner ever use an index when the condition is <> ? Tom Lane (18:31)
Re: will the planner ever use an index when the condition is <> ? Marti Raudsepp (20:11)
Re: will the planner ever use an index when the condition is <> ? Roxanne Reid-Bennett (20:18)

2011-12-19

Dramatic change in memory usage with version 9.1 Rafael Martinez (15:04)
OOM-killer issue with a specific query nabble.30.miller_2555 (15:52)
Re: Dramatic change in memory usage with version 9.1 ktm@rice.edu (15:54)
Re: Dramatic change in memory usage with version 9.1 Marti Raudsepp (16:02)

2011-12-20

Re: Dramatic change in memory usage with version 9.1 Cédric Villemain (11:15)
Re: OOM-killer issue with a specific query Scott Marlowe (13:24)
Re: OOM-killer issue with a specific query 9 of 20) nabble.30.miller_2555 (16:46)
Re: OOM-killer issue with a specific query 11 of 20) nabble.30.miller_2555 (18:33)
Re: OOM-killer issue with a specific query 9 of 20) Tom Lane (20:46)
Re: Dramatic change in memory usage with version 9.1 Craig Ringer (23:48)

2011-12-21

Re: OOM-killer issue with a specific query SOLVED nabble.30.miller_2555 (05:09)
Re: Dramatic change in memory usage with version 9.1 Rafael Martinez (17:41)
Re: Dramatic change in memory usage with version 9.1 Rafael Martinez (17:50)
Re: Dramatic change in memory usage with version 9.1 Scott Marlowe (18:18)
Re: Dramatic change in memory usage with version 9.1 Kevin Grittner (18:54)
Re: Dramatic change in memory usage with version 9.1 Havasvölgyi Ottó (23:29)

2011-12-22

Re: Guidance Requested - Bulk Inserting + Queries Benjamin Johnson (02:30)
Re: Guidance Requested - Bulk Inserting + Queries Jeff Janes (08:04)
Re: Dramatic change in memory usage with version 9.1 Rafael Martinez (09:00)
Re: Dramatic change in memory usage with version 9.1 Havasvölgyi Ottó (09:58)

2011-12-23

Postgresql 9.0.6 Raid 5 or not please help. tuanhoanganh (03:36)
Re: Postgresql 9.0.6 Raid 5 or not please help. Scott Marlowe (03:55)
Re: Postgresql 9.0.6 Raid 5 or not please help. Scott Marlowe (04:00)
Re: Postgresql 9.0.6 Raid 5 or not please help. tuanhoanganh (06:18)
Re: Postgresql 9.0.6 Raid 5 or not please help. Scott Marlowe (07:05)
Re: Postgresql 9.0.6 Raid 5 or not please help. Satoshi Nagayasu (07:58)
Re: Postgresql 9.0.6 Raid 5 or not please help. Mario Weilguni (09:20)
Re: Postgresql 9.0.6 Raid 5 or not please help. alexandre - aldeia digital (12:15)
Re: Postgresql 9.0.6 Raid 5 or not please help. Scott Marlowe (15:25)
Re: Postgresql 9.0.6 Raid 5 or not please help. tuanhoanganh (15:32)
Re: Postgresql 9.0.6 Raid 5 or not please help. Scott Marlowe (18:06)
How to clock the time spent for query parsing and planning? Igor Schtein (19:27)

2011-12-24

Exploring memory usage Michael Smolsky (19:22)

2011-12-25

Re: Postgresql 9.0.6 Raid 5 or not please help. tuanhoanganh (03:13)
Re: Postgresql 9.0.6 Raid 5 or not please help. Scott Marlowe (07:15)

2011-12-27

Re: How to clock the time spent for query parsing and planning? Pavel Stehule (09:38)
parse - bind take more time than execute MirrorX (10:52)
Re: parse - bind take more time than execute MirrorX (11:01)
Re: parse - bind take more time than execute Filip Rembiałkowski (12:01)
Re: parse - bind take more time than execute MirrorX (13:34)
Re: parse - bind take more time than execute Pavel Stehule (14:01)
Re: parse - bind take more time than execute MirrorX (14:21)
Re: Exploring memory usage Claudio Freire (15:33)
Re: Exploring memory usage Scott Marlowe (16:00)
Re: Exploring memory usage Claudio Freire (16:06)
Re: Exploring memory usage Andrew Dunstan (16:14)
Re: Exploring memory usage Scott Marlowe (16:17)
Re: Exploring memory usage Scott Marlowe (16:45)
Subquery flattening causing sequential scan Jim Crate (17:29)
Re: Subquery flattening causing sequential scan Tom Lane (18:12)
Performance costs of various PL languages Carlo Stonebanks (21:09)
Re: Performance costs of various PL languages Pavel Stehule (22:20)
Re: Subquery flattening causing sequential scan Ondrej Ivanič (22:21)
Re: Performance costs of various PL languages Merlin Moncure (22:54)
Re: Performance costs of various PL languages Andrew Dunstan (23:11)
Re: Performance costs of various PL languages Carlo Stonebanks (23:38)

2011-12-28

Re: Subquery flattening causing sequential scan Tom Lane (00:28)
Re: Subquery flattening causing sequential scan Віталій Тимчишин (08:30)
Re: PostgreSQL 9.0.4 blocking in lseek? Matteo Beccati (09:57)
Re: PostgreSQL 9.0.4 blocking in lseek? Matteo Beccati (14:20)
Re: Subquery flattening causing sequential scan Jim Crate (17:22)
Re: PostgreSQL 9.0.4 blocking in lseek? Matteo Beccati (18:02)
Re: PostgreSQL 9.0.4 blocking in lseek? Claudio Freire (18:07)
Re: PostgreSQL 9.0.4 blocking in lseek? Matteo Beccati (18:41)
Re: parse - bind take more time than execute Kevin Grittner (23:22)

2011-12-29

Re: PostgreSQL 9.0.4 blocking in lseek? Matteo Beccati (09:03)
Postgresql Replication Performance sgupta (09:33)
Re: Postgresql Replication Performance Aleksej Trofimov (14:33)

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

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