pgsql-performance 2011-12 Thread Index (1/2)

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 2011-12 Thread Index (1/2)

Last updated: Wed Jan 18 04:11:51 2012
214 messages

Main Index
[Prev Page]
[Next Page]

Query performance - normal on 9.0.4, slow from 9.0.5 onwards Miguel Silva (Fri 30 16:39)

Re: Query performance - normal on 9.0.4, slow from 9.0.5 onwards Tom Lane (Fri 30 17:40)

Re: Query performance - normal on 9.0.4, slow from 9.0.5 onwards Miguel Silva (Fri 30 17:50)

Re: Query performance - normal on 9.0.4, slow from 9.0.5 onwards Merlin Moncure (Fri 30 19:35)
Re: Query performance - normal on 9.0.4, slow from 9.0.5 onwards Tom Lane (Fri 30 22:29)

partitioned table: differents plans, slow on some situations Matteo Sgalaberni (Fri 30 16:00)

Re: partitioned table: differents plans, slow on some situations Marcin Mirosław (Fri 30 16:23)

Re: partitioned table: differents plans, slow on some situations Matteo Sgalaberni (Fri 30 16:34)

Postgresql Replication Performance sgupta (Thu 29 09:33)

Re: Postgresql Replication Performance Aleksej Trofimov (Thu 29 14:34)

Re: Postgresql Replication Performance Claudio Freire (Thu 29 15:00)

Re: Postgresql Replication Performance Aleksej Trofimov (Thu 29 16:05)

Re: Postgresql Replication Performance Merlin Moncure (Thu 29 15:05)

Re: PostgreSQL 9.0.4 blocking in lseek? Matteo Beccati (Wed 28 09:57)

Re: PostgreSQL 9.0.4 blocking in lseek? Matteo Beccati (Wed 28 14:20)
Re: PostgreSQL 9.0.4 blocking in lseek? Matteo Beccati (Wed 28 18:02)

Re: PostgreSQL 9.0.4 blocking in lseek? Claudio Freire (Wed 28 18:07)

Re: PostgreSQL 9.0.4 blocking in lseek? Matteo Beccati (Wed 28 18:42)

Re: PostgreSQL 9.0.4 blocking in lseek? Matteo Beccati (Thu 29 09:03)

Performance costs of various PL languages Carlo Stonebanks (Tue 27 21:10)

Re: Performance costs of various PL languages Pavel Stehule (Tue 27 22:21)

Re: Performance costs of various PL languages Merlin Moncure (Tue 27 22:54)

Re: Performance costs of various PL languages Andrew Dunstan (Tue 27 23:12)
Re: Performance costs of various PL languages Carlo Stonebanks (Tue 27 23:38)

Subquery flattening causing sequential scan Jim Crate (Tue 27 17:29)

Re: Subquery flattening causing sequential scan Tom Lane (Tue 27 18:13)

Re: Subquery flattening causing sequential scan Ondrej Ivanič (Tue 27 22:21)

Re: Subquery flattening causing sequential scan Tom Lane (Wed 28 00:28)

Re: Subquery flattening causing sequential scan Віталій Тимчишин (Wed 28 08:31)
Re: Subquery flattening causing sequential scan Jim Crate (Wed 28 17:23)

parse - bind take more time than execute MirrorX (Tue 27 10:52)

Re: parse - bind take more time than execute MirrorX (Tue 27 11:02)
Re: parse - bind take more time than execute Filip Rembiałkowski (Tue 27 12:01)

Re: parse - bind take more time than execute MirrorX (Tue 27 13:34)

Re: parse - bind take more time than execute Pavel Stehule (Tue 27 14:02)

Re: parse - bind take more time than execute MirrorX (Tue 27 14:21)

<Possible follow-ups>
Re: parse - bind take more time than execute Kevin Grittner (Wed 28 23:22)

Re: parse - bind take more time than execute MirrorX (Thu 29 16:13)

Re: parse - bind take more time than execute Kevin Grittner (Thu 29 16:51)

Exploring memory usage Michael Smolsky (Sat 24 19:22)

Re: Exploring memory usage Claudio Freire (Tue 27 15:33)

Re: Exploring memory usage Scott Marlowe (Tue 27 16:00)

Re: Exploring memory usage Claudio Freire (Tue 27 16:06)
Re: Exploring memory usage Andrew Dunstan (Tue 27 16:15)

Re: Exploring memory usage Scott Marlowe (Tue 27 16:17)

Re: Exploring memory usage Scott Marlowe (Tue 27 16:45)

How to clock the time spent for query parsing and planning? Igor Schtein (Fri 23 19:27)

Re: How to clock the time spent for query parsing and planning? Pavel Stehule (Tue 27 09:39)

Re: How to clock the time spent for query parsing and planning? Igor (Sat 31 01:15)

Re: How to clock the time spent for query parsing and planning? Pavel Stehule (Sat 31 07:50)

Postgresql 9.0.6 Raid 5 or not please help. tuanhoanganh (Fri 23 03:36)

Re: Postgresql 9.0.6 Raid 5 or not please help. Scott Marlowe (Fri 23 03:55)

Re: Postgresql 9.0.6 Raid 5 or not please help. Scott Marlowe (Fri 23 04:00)

Re: Postgresql 9.0.6 Raid 5 or not please help. tuanhoanganh (Fri 23 06:18)

Re: Postgresql 9.0.6 Raid 5 or not please help. Scott Marlowe (Fri 23 07:05)

Re: Postgresql 9.0.6 Raid 5 or not please help. Satoshi Nagayasu (Fri 23 07:59)
Re: Postgresql 9.0.6 Raid 5 or not please help. Mario Weilguni (Fri 23 09:20)
Re: Postgresql 9.0.6 Raid 5 or not please help. alexandre - aldeia digital (Fri 23 12:15)
Re: Postgresql 9.0.6 Raid 5 or not please help. Scott Marlowe (Fri 23 15:26)
Re: Postgresql 9.0.6 Raid 5 or not please help. tuanhoanganh (Fri 23 15:33)
Re: Postgresql 9.0.6 Raid 5 or not please help. Scott Marlowe (Fri 23 18:07)
Re: Postgresql 9.0.6 Raid 5 or not please help. tuanhoanganh (Sun 25 03:13)
Re: Postgresql 9.0.6 Raid 5 or not please help. Scott Marlowe (Sun 25 07:15)

Re: OOM-killer issue with a specific query SOLVED nabble . 30 . miller_2555 (Wed 21 05:09)
OOM-killer issue with a specific query nabble . 30 . miller_2555 (Mon 19 15:52)

Re: OOM-killer issue with a specific query Scott Marlowe (Tue 20 13:24)

Re: OOM-killer issue with a specific query 9 of 20) nabble . 30 . miller_2555 (Tue 20 16:46)

Re: OOM-killer issue with a specific query 9 of 20) Tom Lane (Tue 20 20:47)

Message not available
- Re: OOM-killer issue with a specific query 11 of 20) nabble . 30 . miller_2555 (Tue 20 18:33)

Dramatic change in memory usage with version 9.1 Rafael Martinez (Mon 19 15:05)

Re: Dramatic change in memory usage with version 9.1 ktm(at)rice(dot)edu (Mon 19 15:54)
Re: Dramatic change in memory usage with version 9.1 Marti Raudsepp (Mon 19 16:03)
Re: Dramatic change in memory usage with version 9.1 Cédric Villemain (Tue 20 11:15)

Re: Dramatic change in memory usage with version 9.1 Rafael Martinez (Wed 21 17:41)

Re: Dramatic change in memory usage with version 9.1 Craig Ringer (Tue 20 23:49)

Re: Dramatic change in memory usage with version 9.1 Rafael Martinez (Wed 21 17:50)

Re: Dramatic change in memory usage with version 9.1 Scott Marlowe (Wed 21 18:18)

Re: Dramatic change in memory usage with version 9.1 Kevin Grittner (Wed 21 18:54)

Re: Dramatic change in memory usage with version 9.1 Havasvölgyi Ottó (Wed 21 23:29)

Re: Dramatic change in memory usage with version 9.1 Rafael Martinez (Thu 22 09:00)

Re: Dramatic change in memory usage with version 9.1 Havasvölgyi Ottó (Thu 22 09:59)

will the planner ever use an index when the condition is <> ? Roxanne Reid-Bennett (Sat 17 15:30)

Re: will the planner ever use an index when the condition is <> ? Filip Rembiałkowski (Sat 17 16:24)

Re: will the planner ever use an index when the condition is <> ? Віталій Тимчишин (Sun 18 10:41)
Re: will the planner ever use an index when the condition is <> ? Roxanne Reid-Bennett (Sun 18 14:56)

Re: will the planner ever use an index when the condition is <> ? Tom Lane (Sun 18 18:31)

Re: will the planner ever use an index when the condition is <> ? Roxanne Reid-Bennett (Sun 18 20:19)

Re: will the planner ever use an index when the condition is <> ? Marti Raudsepp (Sun 18 20:12)

Slow nested loop execution on larger server Greg Smith (Fri 16 18:28)

Re: Slow nested loop execution on larger server Scott Marlowe (Fri 16 21:16)

Is it possible to use index on column for regexp match operator '~'? Rural Hunter (Wed 14 16:05)

Re: Is it possible to use index on column for regexp match operator '~'? Marti Raudsepp (Wed 14 20:44)

Re: Is it possible to use index on column for regexp match operator '~'? Rural Hunter (Thu 15 01:54)

select distinct uses index scan vs full table scan Jon Nelson (Tue 13 18:13)

Re: select distinct uses index scan vs full table scan Tom Lane (Tue 13 19:58)

Re: select distinct uses index scan vs full table scan Jon Nelson (Tue 13 20:18)

Postgres array parser Aleksej Trofimov (Tue 13 13:55)

Re: Postgres array parser Pavel Stehule (Tue 13 14:03)

Re: Postgres array parser Aleksej Trofimov (Tue 13 14:28)

Re: Postgres array parser Pavel Stehule (Tue 13 14:43)

Re: Postgres array parser Marc Mamin (Wed 14 09:22)

Re: Postgres array parser Aleksej Trofimov (Wed 14 09:59)
Re: Postgres array parser Marc Mamin (Wed 14 10:27)

autovacuum, exclude table Anibal David Acosta (Mon 12 14:26)

Re: autovacuum, exclude table Craig Ringer (Mon 12 14:45)

Re: autovacuum, exclude table Anibal David Acosta (Mon 12 14:55)

Re: autovacuum, exclude table Tom Lane (Mon 12 15:26)

Re: autovacuum, exclude table Heikki Linnakangas (Mon 12 15:16)

copy vs. C function Jon Nelson (Sun 11 01:27)

Re: copy vs. C function Craig Ringer (Sun 11 02:33)

Re: copy vs. C function Jon Nelson (Sun 11 03:09)

Re: copy vs. C function Sam Gendler (Sun 11 02:35)
Re: copy vs. C function Merlin Moncure (Mon 12 16:38)

Re: copy vs. C function Jon Nelson (Tue 13 14:30)

Re: copy vs. C function Tom Lane (Wed 14 06:18)

Re: copy vs. C function idc danny (Wed 14 07:02)

Re: copy vs. C function Kevin Martyn (Wed 14 13:14)
Re: copy vs. C function idc danny (Wed 14 14:32)

Re: copy vs. C function Jon Nelson (Wed 14 14:06)

Re: copy vs. C function Tom Lane (Wed 14 15:25)
Re: copy vs. C function Jon Nelson (Wed 14 15:40)
Re: copy vs. C function Jon Nelson (Wed 14 15:51)
Re: copy vs. C function Jon Nelson (Thu 15 03:19)

Common slow query reasons - help with a special log Daniel Cristian Cruz (Sat 10 16:52)

Re: Common slow query reasons - help with a special log Andreas Kretschmer (Sat 10 17:25)
Re: Common slow query reasons - help with a special log Tomas Vondra (Sat 10 17:26)

Re: Common slow query reasons - help with a special log Daniel Cristian Cruz (Sat 10 22:40)

Re: Common slow query reasons - help with a special log Tomas Vondra (Sat 10 23:51)

Re: Common slow query reasons - help with a special log Daniel Cristian Cruz (Sun 11 01:27)

Re: Common slow query reasons - help with a special log Tomas Vondra (Sun 11 03:11)

Slow query after upgrade from 8.2 to 8.4 Kaloyan Iliev Iliev (Thu 08 17:29)

Re: Slow query after upgrade from 8.2 to 8.4 Shaun Thomas (Thu 08 17:52)
Re: Slow query after upgrade from 8.2 to 8.4 Tom Lane (Fri 09 03:28)

Re: Slow query after upgrade from 8.2 to 8.4 Kaloyan Iliev Iliev (Fri 09 12:23)

Re: Slow query after upgrade from 8.2 to 8.4 Tom Lane (Fri 09 15:30)

Re: Slow query after upgrade from 8.2 to 8.4 Mark Kirkwood (Tue 13 22:13)

Re: Slow query after upgrade from 8.2 to 8.4 Kaloyan Iliev Iliev (Wed 14 17:48)

Re: pg_upgrade failure "contrib" issue? Tory M Blue (Wed 07 23:53)
autovacuum, any log? Anibal David Acosta (Wed 07 15:34)

Re: autovacuum, any log? Scott Marlowe (Wed 07 20:19)

Partitions and joins lead to index lookups on all partitions Christiaan Willemsen (Wed 07 15:16)

Re: Partitions and joins lead to index lookups on all partitions Ondrej Ivanič (Wed 07 21:36)

Re: Partitions and joins lead to index lookups on all partitions voodooless (Thu 08 13:57)

Re: Partitions and joins lead to index lookups on all partitions voodooless (Wed 14 16:06)

Response time increases over time Havasvölgyi Ottó (Tue 06 21:30)

Re: Response time increases over time Josh Berkus (Wed 07 04:12)

Re: Response time increases over time Havasvölgyi Ottó (Wed 07 08:23)

Re: Response time increases over time Mario Splivalo (Wed 07 09:37)

Re: Response time increases over time Havasvölgyi Ottó (Wed 07 22:13)

Re: Response time increases over time Aidan Van Dyk (Thu 08 04:37)
Re: Response time increases over time Havasvölgyi Ottó (Thu 08 08:50)
Re: Response time increases over time Marti Raudsepp (Thu 08 13:45)
Re: Response time increases over time Havasvölgyi Ottó (Thu 08 15:49)
Re: Response time increases over time Bob Lunney (Thu 08 15:58)
Re: Response time increases over time Havasvölgyi Ottó (Thu 08 17:22)

Different query plans on same servers Mario Splivalo (Tue 06 19:50)

Re: Different query plans on same servers Tom Lane (Tue 06 20:01)

Re: Different query plans on same servers Kevin Grittner (Tue 06 20:17)

Re: Different query plans on same servers Kevin Grittner (Tue 06 20:29)

Re: Different query plans on same servers Mario Splivalo (Wed 07 00:37)

Re: Different query plans on same servers Mario Splivalo (Wed 07 00:29)

Re: Different query plans on same servers Mario Splivalo (Wed 07 00:26)
Re: Different query plans on same servers Mario Splivalo (Wed 07 09:37)

Re: unlogged tables Pierre C (Sun 04 12:28)
manually force planner to use of index A vs index B MirrorX (Sat 03 14:34)

Re: manually force planner to use of index A vs index B Tomas Vondra (Sat 03 15:10)

Re: manually force planner to use of index A vs index B MirrorX (Sat 03 15:16)

pg_upgrade Tory M Blue (Sat 03 04:09)

Re: pg_upgrade Klaus Ita (Sat 03 14:03)
Re: pg_upgrade Bruce Momjian (Sat 03 14:04)

Re: pg_upgrade Tory M Blue (Sat 03 19:35)

Re: pg_upgrade Bruce Momjian (Sat 03 23:42)

Re: pg_upgrade Bruce Momjian (Sun 04 02:20)
Re: pg_upgrade Nicholson, Brad (Toronto, ON, CA) (Mon 05 13:37)

Re: pg_upgrade Bruce Momjian (Mon 05 15:24)
Re: pg_upgrade Nicholson, Brad (Toronto, ON, CA) (Mon 05 15:30)
Re: pg_upgrade Bruce Momjian (Mon 05 15:35)
Re: pg_upgrade Tory M Blue (Mon 05 17:21)
Re: pg_upgrade Bruce Momjian (Mon 05 18:23)
Re: pg_upgrade Tory M Blue (Mon 05 18:32)

Main Index
[Prev Page]
[Next Page]

Mail converted by MHonArc

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