Skip site navigation (1)
Skip section navigation (2)
pgsql-performance 2011-12 Chronological Index (1/2)
Last updated: Wed Jan 18 04:11:51 2012
214 messages
30 December 2011
Re: Query performance - normal on 9.0.4, slow from 9.0.5 onwards Merlin Moncure (19:35)
Re: Query performance - normal on 9.0.4, slow from 9.0.5 onwards Miguel Silva (17:50)
Re: Query performance - normal on 9.0.4, slow from 9.0.5 onwards Tom Lane (17:40)
Query performance - normal on 9.0.4, slow from 9.0.5 onwards Miguel Silva (16:39)
Re: partitioned table: differents plans, slow on some situations Matteo Sgalaberni (16:34)
Re: partitioned table: differents plans, slow on some situations Marcin Mirosław (16:23)
partitioned table: differents plans, slow on some situations Matteo Sgalaberni (16:00)
29 December 2011
Re: parse - bind take more time than execute MirrorX (16:13)
Re: Postgresql Replication Performance Aleksej Trofimov (16:05)
Re: Postgresql Replication Performance Merlin Moncure (15:05)
Re: Postgresql Replication Performance Claudio Freire (15:00)
Re: Postgresql Replication Performance Aleksej Trofimov (14:34)
Postgresql Replication Performance sgupta (09:33)
Re: PostgreSQL 9.0.4 blocking in lseek? Matteo Beccati (09:03)
28 December 2011
Re: PostgreSQL 9.0.4 blocking in lseek? Matteo Beccati (18:42)
Re: PostgreSQL 9.0.4 blocking in lseek? Claudio Freire (18:07)
Re: PostgreSQL 9.0.4 blocking in lseek? Matteo Beccati (18:02)
Re: Subquery flattening causing sequential scan Jim Crate (17:23)
Re: PostgreSQL 9.0.4 blocking in lseek? Matteo Beccati (14:20)
Re: PostgreSQL 9.0.4 blocking in lseek? Matteo Beccati (09:57)
Re: Subquery flattening causing sequential scan Віталій Тимчишин (08:31)
Re: Subquery flattening causing sequential scan Tom Lane (00:28)
27 December 2011
Re: Performance costs of various PL languages Andrew Dunstan (23:12)
Re: Performance costs of various PL languages Merlin Moncure (22:54)
Re: Subquery flattening causing sequential scan Ondrej Ivanič (22:21)
Re: Performance costs of various PL languages Pavel Stehule (22:21)
Performance costs of various PL languages Carlo Stonebanks (21:10)
Re: Subquery flattening causing sequential scan Tom Lane (18:13)
Subquery flattening causing sequential scan Jim Crate (17:29)
Re: Exploring memory usage Scott Marlowe (16:45)
Re: Exploring memory usage Scott Marlowe (16:17)
Re: Exploring memory usage Andrew Dunstan (16:15)
Re: Exploring memory usage Claudio Freire (16:06)
Re: Exploring memory usage Scott Marlowe (16:00)
Re: Exploring memory usage Claudio Freire (15:33)
Re: parse - bind take more time than execute MirrorX (14:21)
Re: parse - bind take more time than execute Pavel Stehule (14:02)
Re: parse - bind take more time than execute MirrorX (13:34)
Re: parse - bind take more time than execute Filip Rembiałkowski (12:01)
Re: parse - bind take more time than execute MirrorX (11:02)
parse - bind take more time than execute MirrorX (10:52)
Re: How to clock the time spent for query parsing and planning? Pavel Stehule (09:39)
25 December 2011
Re: Postgresql 9.0.6 Raid 5 or not please help. tuanhoanganh (03:13)
24 December 2011
23 December 2011
Re: Postgresql 9.0.6 Raid 5 or not please help. Scott Marlowe (18:07)
Re: Postgresql 9.0.6 Raid 5 or not please help. tuanhoanganh (15:33)
Re: Postgresql 9.0.6 Raid 5 or not please help. Scott Marlowe (15:26)
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. Mario Weilguni (09:20)
Re: Postgresql 9.0.6 Raid 5 or not please help. Satoshi Nagayasu (07:59)
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. tuanhoanganh (06:18)
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. Scott Marlowe (03:55)
Postgresql 9.0.6 Raid 5 or not please help. tuanhoanganh (03:36)
22 December 2011
Re: Dramatic change in memory usage with version 9.1 Rafael Martinez (09:00)
Re: Guidance Requested - Bulk Inserting + Queries Jeff Janes (08:04)
Re: Guidance Requested - Bulk Inserting + Queries Benjamin Johnson (02:31)
21 December 2011
Re: Dramatic change in memory usage with version 9.1 Kevin Grittner (18:54)
Re: Dramatic change in memory usage with version 9.1 Scott Marlowe (18:18)
Re: Dramatic change in memory usage with version 9.1 Rafael Martinez (17:50)
Re: Dramatic change in memory usage with version 9.1 Rafael Martinez (17:41)
Re: OOM-killer issue with a specific query SOLVED nabble . 30 . miller_2555 (05:09)
20 December 2011
Re: OOM-killer issue with a specific query 9 of 20) Tom Lane (20:47)
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) nabble . 30 . miller_2555 (16:46)
Re: OOM-killer issue with a specific query Scott Marlowe (13:24)
Re: Dramatic change in memory usage with version 9.1 Cédric Villemain (11:15)
19 December 2011
Re: Dramatic change in memory usage with version 9.1 ktm(at)rice(dot)edu (15:54)
OOM-killer issue with a specific query nabble . 30 . miller_2555 (15:52)
Dramatic change in memory usage with version 9.1 Rafael Martinez (15:05)
18 December 2011
Re: will the planner ever use an index when the condition is <> ? Marti Raudsepp (20:12)
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 <> ? Roxanne Reid-Bennett (14:56)
Re: will the planner ever use an index when the condition is <> ? Віталій Тимчишин (10:41)
17 December 2011
will the planner ever use an index when the condition is <> ? Roxanne Reid-Bennett (15:30)
16 December 2011
Slow nested loop execution on larger server Greg Smith (18:28)
15 December 2011
Re: Is it possible to use index on column for regexp match operator '~'? Rural Hunter (01:54)
14 December 2011
Re: Slow query after upgrade from 8.2 to 8.4 Kaloyan Iliev Iliev (17:48)
Re: Partitions and joins lead to index lookups on all partitions voodooless (16:06)
Is it possible to use index on column for regexp match operator '~'? Rural Hunter (16:05)
Re: copy vs. C function Jon Nelson (15:51)
Re: copy vs. C function Jon Nelson (15:40)
Re: copy vs. C function Tom Lane (15:25)
Re: copy vs. C function idc danny (14:32)
Re: copy vs. C function Jon Nelson (14:06)
Re: copy vs. C function Kevin Martyn (13:14)
Re: Postgres array parser Marc Mamin (10:27)
Re: Postgres array parser Aleksej Trofimov (09:59)
Re: Postgres array parser Marc Mamin (09:22)
Re: copy vs. C function idc danny (07:02)
Re: copy vs. C function Tom Lane (06:18)
13 December 2011
Re: select distinct uses index scan vs full table scan Jon Nelson (20:18)
Re: select distinct uses index scan vs full table scan Tom Lane (19:58)
select distinct uses index scan vs full table scan Jon Nelson (18:13)
Re: Postgres array parser Pavel Stehule (14:43)
Re: copy vs. C function Jon Nelson (14:30)
Re: Postgres array parser Aleksej Trofimov (14:28)
Re: Postgres array parser Pavel Stehule (14:03)
Postgres array parser Aleksej Trofimov (13:55)
12 December 2011
Re: autovacuum, exclude table Tom Lane (15:26)
Re: autovacuum, exclude table Heikki Linnakangas (15:16)
Re: autovacuum, exclude table Anibal David Acosta (14:55)
Re: autovacuum, exclude table Craig Ringer (14:45)
autovacuum, exclude table Anibal David Acosta (14:26)
11 December 2011
Re: copy vs. C function Jon Nelson (03:09)
Re: copy vs. C function Sam Gendler (02:35)
Re: copy vs. C function Craig Ringer (02:33)
copy vs. C function Jon Nelson (01:27)
Re: Common slow query reasons - help with a special log Daniel Cristian Cruz (01:27)
10 December 2011
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 (17:26)
Re: Common slow query reasons - help with a special log Andreas Kretschmer (17:25)
Common slow query reasons - help with a special log Daniel Cristian Cruz (16:52)
09 December 2011
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 (03:28)
08 December 2011
Re: Slow query after upgrade from 8.2 to 8.4 Shaun Thomas (17:52)
Slow query after upgrade from 8.2 to 8.4 Kaloyan Iliev Iliev (17:29)
Re: Response time increases over time Havasvölgyi Ottó (17:22)
Re: Response time increases over time Bob Lunney (15:58)
Re: Response time increases over time Havasvölgyi Ottó (15:49)
Re: Partitions and joins lead to index lookups on all partitions voodooless (13:57)
Re: Response time increases over time Marti Raudsepp (13:45)
Re: Response time increases over time Havasvölgyi Ottó (08:50)
Re: Response time increases over time Aidan Van Dyk (04:37)
07 December 2011
Re: Response time increases over time Havasvölgyi Ottó (22:13)
Re: Partitions and joins lead to index lookups on all partitions Ondrej Ivanič (21:36)
Re: autovacuum, any log? Scott Marlowe (20:19)
Re: pg_upgrade Tory M Blue (20:13)
autovacuum, any log? Anibal David Acosta (15:34)
Partitions and joins lead to index lookups on all partitions Christiaan Willemsen (15:16)
Re: Question about VACUUM Kevin Grittner (15:14)
Re: Intersect/Union X AND/OR Marti Raudsepp (14:57)
Re: Response time increases over time Mario Splivalo (09:37)
Re: Different query plans on same servers Mario Splivalo (09:37)
Re: Response time increases over time Havasvölgyi Ottó (08:23)
Re: Question about VACUUM Josh Berkus (04:14)
Re: Response time increases over time Josh Berkus (04:12)
Re: Different query plans on same servers Mario Splivalo (00:37)
Re: Different query plans on same servers Mario Splivalo (00:29)
Re: Different query plans on same servers Mario Splivalo (00:26)
06 December 2011
Re: Different query plans on same servers Kevin Grittner (20:29)
Re: Different query plans on same servers Kevin Grittner (20:17)
Re: Different query plans on same servers Tom Lane (20:01)
Different query plans on same servers Mario Splivalo (19:50)
05 December 2011
Re: Question about VACUUM Scott Marlowe (20:29)
Re: pg_upgrade Bruce Momjian (19:09)
Re: pg_upgrade Bruce Momjian (19:08)
Re: pg_upgrade Tory M Blue (19:00)
Re: Question about VACUUM Kevin Grittner (18:36)
Re: pg_upgrade Tory M Blue (18:32)
Re: pg_upgrade Bruce Momjian (18:23)
Re: Question about VACUUM Ernesto Quiñones (17:47)
Re: Question about VACUUM Scott Marlowe (17:44)