pgsql-performance 2009-09 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 2009-09 Thread Index (1/2)

Last updated: Wed Jan 18 04:14:34 2012
344 messages

Main Index
[Prev Page]
[Next Page]

CPU cost of operators Matthew Wakeling (Wed 30 17:12)

Re: CPU cost of operators Robert Haas (Wed 30 20:13)

Re: CPU cost of operators Robert Haas (Wed 30 20:14)

Re: CPU cost of operators Tom Lane (Wed 30 20:35)

FullTextSearch - UNION individual indexes or concatenated columns index ? Jeremy Ferrante (Tue 29 20:10)

Re: FullTextSearch - UNION individual indexes or concatenated columns index ? Josh Berkus (Tue 29 22:59)

Using OProfile Reydan Cankur (Tue 29 11:08)

Re: Using OProfile Tom Lane (Tue 29 14:19)

Performance problems with DISTINCT ON Sgarbossa Domenico (Tue 29 06:57)

Re: Performance problems with DISTINCT ON Richard Huxton (Tue 29 08:28)

Re: Performance problems with DISTINCT ON Sgarbossa Domenico (Tue 29 12:47)

Re: Performance problems with DISTINCT ON hubert depesz lubaczewski (Tue 29 12:53)
Re: Performance problems with DISTINCT ON Scott Carey (Tue 29 17:53)

Re: Postgres performance Andy Colson (Mon 28 14:11)

Re: Postgres performance Scott Marlowe (Mon 28 21:16)

LIMIT confuses the planner (again) Kouber Saparev (Mon 28 08:49)

Re: LIMIT confuses the planner (again) Robert Haas (Mon 28 11:39)

Re: Many left outer joins with limit performance Gerhard Wiesinger (Sun 27 07:10)
Bad performance of SELECT ... where id IN (...) Xia Qingran (Sat 26 13:05)

Re: Bad performance of SELECT ... where id IN (...) Claus Guttesen (Sat 26 14:16)

Re: Bad performance of SELECT ... where id IN (...) Paul Ooi (Sat 26 15:33)

Re: Bad performance of SELECT ... where id IN (...) Craig James (Sat 26 15:22)

Re: Bad performance of SELECT ... where id IN (...) Xia Qingran (Sun 27 06:13)

Re: Bad performance of SELECT ... where id IN (...) Tom Lane (Sat 26 17:04)

Re: Bad performance of SELECT ... where id IN (...) Xia Qingran (Sun 27 06:11)

Re: Bad performance of SELECT ... where id IN (...) Ivan Voras (Wed 30 13:21)

Re: Bad performance of SELECT ... where id IN (...) Grzegorz Jaśkiewicz (Sat 26 17:58)

PG 8.3 and large shared buffer settings Dan Sugalski (Fri 25 03:28)

Re: PG 8.3 and large shared buffer settings Tom Lane (Fri 25 04:36)

Re: PG 8.3 and large shared buffer settings Dan Sugalski (Fri 25 10:06)

Re: PG 8.3 and large shared buffer settings Aidan Van Dyk (Fri 25 13:33)

Re: PG 8.3 and large shared buffer settings Scott Carey (Fri 25 15:57)

Re: PG 8.3 and large shared buffer settings Aidan Van Dyk (Fri 25 16:15)
Re: PG 8.3 and large shared buffer settings Jeff Janes (Sat 26 02:54)
Re: PG 8.3 and large shared buffer settings Greg Smith (Sat 26 14:59)
Re: PG 8.3 and large shared buffer settings Gerhard Wiesinger (Sat 26 16:58)
Re: PG 8.3 and large shared buffer settings Jeff Janes (Sat 26 18:59)

Re: PG 8.3 and large shared buffer settings Greg Smith (Sat 26 15:20)

Re: PG 8.3 and large shared buffer settings Pierre Frédéric Caillau d (Sat 26 17:21)
Re: PG 8.3 and large shared buffer settings Jeff Janes (Sat 26 19:17)

Re: PG 8.3 and large shared buffer settings Greg Smith (Sat 26 21:19)

Re: PG 8.3 and large shared buffer settings Josh Berkus (Mon 28 17:36)

Regarding Sequential Scans count increase each time we press refresh . keshav upadhyaya (Thu 24 17:33)

Re: Regarding Sequential Scans count increase each time we press refresh . Josh Berkus (Fri 25 00:25)

Re: Regarding Sequential Scans count increase each time we press refresh . Robert Haas (Sun 27 18:38)

Re: Regarding Sequential Scans count increase each time we press refresh . Tom Lane (Sun 27 19:17)

Speed while runnning large transactions. jesper (Thu 24 08:34)

Re: Speed while runnning large transactions. Claus Guttesen (Thu 24 08:41)
Re: Speed while runnning large transactions. Grzegorz Jaśkiewicz (Thu 24 08:44)

Re: Speed while runnning large transactions. jesper (Thu 24 11:39)

Re: Speed while runnning large transactions. Robert Haas (Tue 29 21:28)

Re: Speed while runnning large transactions. Scott Marlowe (Thu 24 09:07)

Re: Speed while runnning large transactions. jesper (Thu 24 11:36)

Use of sequence rather than index scan for one text column on one instance of a database Bill Kirtley (Wed 23 22:37)

Re: Use of sequence rather than index scan for one text column on one instance of a database Tom Lane (Thu 24 02:53)

Message not available
- Re: Use of sequence rather than index scan for one text column on one instance of a database Tom Lane (Thu 24 15:35)

Slow query after upgrade to 8.4 Jared Beck (Wed 23 17:38)

Slow query after upgrade to 8.4 Jared Beck (Wed 23 21:00)

Re: Slow query after upgrade to 8.4 Greg Williamson (Wed 23 23:22)
Re: Slow query after upgrade to 8.4 Tom Lane (Thu 24 02:35)

Re: Slow query after upgrade to 8.4 Jared Beck (Thu 24 12:23)

Re: Slow query after upgrade to 8.4 Robert Haas (Sun 27 18:45)

Re: Slow query after upgrade to 8.4 tv (Thu 24 09:57)

Hunting Unused Indexes .. is it this simple ? Stef Telford (Tue 22 14:12)

Re: Hunting Unused Indexes .. is it this simple ? Gurjeet Singh (Tue 22 14:36)
Re: Hunting Unused Indexes .. is it this simple ? Andy Colson (Tue 22 14:38)

Re: Hunting Unused Indexes .. is it this simple ? Josh Berkus (Tue 22 23:52)

High CPU load on Postgres Server during Peak times!!!! Shiva Raman (Tue 22 13:54)

Re: High CPU load on Postgres Server during Peak times!!!! Merlin Moncure (Tue 22 14:18)
Re: High CPU load on Postgres Server during Peak times!!!! Andy Colson (Tue 22 14:19)

Re: High CPU load on Postgres Server during Peak times!!!! Andy Colson (Tue 22 14:35)

Re: High CPU load on Postgres Server during Peak times!!!! Shiva Raman (Wed 23 18:25)

Re: High CPU load on Postgres Server during Peak times!!!! Andy Colson (Wed 23 18:53)
Re: High CPU load on Postgres Server during Peak times!!!! Scott Marlowe (Wed 23 20:55)

Re: High CPU load on Postgres Server during Peak times!!!! Shiva Raman (Thu 24 12:50)
Re: High CPU load on Postgres Server during Peak times!!!! Praveen DS (Thu 24 13:36)
Re: High CPU load on Postgres Server during Peak times!!!! Andy Colson (Thu 24 15:32)
Re: High CPU load on Postgres Server during Peak times!!!! Karl Denninger (Thu 24 15:49)
Re: High CPU load on Postgres Server during Peak times!!!! Dave Dutcher (Thu 24 17:08)
Re: High CPU load on Postgres Server during Peak times!!!! Karl Denninger (Thu 24 17:56)
Re: High CPU load on Postgres Server during Peak times!!!! Craig James (Thu 24 18:45)
Re: High CPU load on Postgres Server during Peak times!!!! Gerhard Wiesinger (Fri 25 13:20)
Re: High CPU load on Postgres Server during Peak times!!!! Craig James (Fri 25 15:29)
Message not available
Re: High CPU load on Postgres Server during Peak times!!!! Shiva Raman (Fri 25 07:17)
Re: High CPU load on Postgres Server during Peak times!!!! Shiva Raman (Fri 25 08:07)
Re: High CPU load on Postgres Server during Peak times!!!! Grzegorz Jaśkiewicz (Fri 25 08:16)
Re: High CPU load on Postgres Server during Peak times!!!! Shiva Raman (Fri 25 08:55)
Re: High CPU load on Postgres Server during Peak times!!!! Grzegorz Jaśkiewicz (Fri 25 09:03)

Re: High CPU load on Postgres Server during Peak times!!!! Fernando Hevia (Tue 22 15:28)

Re: High CPU load on Postgres Server during Peak times!!!! Shiva Raman (Wed 23 18:28)

Re: High CPU load on Postgres Server during Peak times!!!! Fernando Hevia (Wed 23 20:49)

Re: High CPU load on Postgres Server during Peak times!!!! Karl Denninger (Wed 23 20:53)

session servers in ram Scott Marlowe (Mon 21 23:39)

Re: session servers in ram Greg Spiegelberg (Tue 22 12:49)

Re: session servers in ram Pavel Stehule (Tue 22 13:05)

Re: session servers in ram Aidan Van Dyk (Tue 22 13:16)
Re: session servers in ram Alan Hodgson (Tue 22 16:04)

Re: session servers in ram Ron Mayer (Tue 22 18:01)

Re: session servers in ram Scott Marlowe (Tue 22 18:22)

query memory consumption Alan McKay (Mon 21 14:48)

Re: query memory consumption Robert Haas (Mon 21 20:08)

Re: query memory consumption Alan McKay (Tue 22 12:37)

Re: query memory consumption Grzegorz Jaśkiewicz (Tue 22 12:41)

Re: query memory consumption Alan McKay (Tue 22 12:46)

Re: query memory consumption Grzegorz Jaśkiewicz (Tue 22 12:51)
Re: query memory consumption Jeff Janes (Sat 26 03:06)
Re: query memory consumption Robert Haas (Sun 27 18:40)

Re: query memory consumption Matthew Wakeling (Tue 22 10:58)

Index row requires 9324 bytes maximum size is 8191 solAris23 (Fri 18 16:06)

Re: Index row requires 9324 bytes maximum size is 8191 Euler Taveira de Oliveira (Sun 20 03:06)

Re: Index row requires 9324 bytes maximum size is 8191 solAris23 (Thu 24 09:49)

Re: Index row requires 9324 bytes maximum size is 8191 Pavel Stehule (Sun 20 05:47)
Re: Index row requires 9324 bytes maximum size is 8191 Grzegorz Jaśkiewicz (Mon 21 08:38)
Re: Index row requires 9324 bytes maximum size is 8191 Florian Weimer (Mon 21 08:51)

Planner question - wrong row count estimation Michael Korbakov (Fri 18 14:28)

<Possible follow-ups>
Planner question - wrong row count estimation Michael Korbakov (Sun 20 00:08)

Re: Planner question - wrong row count estimation Josh Berkus (Mon 21 21:21)

Database performance post-VACUUM FULL Karl Wright (Fri 18 13:11)

Re: Database performance post-VACUUM FULL Robert Haas (Fri 18 13:40)

Different query plans for the same query Hell, Robert (Fri 18 08:06)

Message not available
- Re: Different query plans for the same query tv (Fri 18 09:20)

Use of BETWEEN with identical values André Volpato (Thu 17 15:26)

Re: Use of BETWEEN with identical values André Volpato (Thu 17 21:02)

Re: Use of BETWEEN with identical values Robert Haas (Fri 18 14:01)

optimizing for temporal data behind a view Richard Henwood (Thu 17 13:02)

Re: optimizing for temporal data behind a view हृषीकेश मेहेंदळ े (Thu 17 14:54)

statement stats extra load? Alan McKay (Tue 15 18:13)

Re: statement stats extra load? Bruce Momjian (Mon 21 21:19)

Re: statement stats extra load? Alan McKay (Mon 21 21:28)

Re: statement stats extra load? Bruce Momjian (Mon 21 21:41)

Re: statement stats extra load? Magnus Hagander (Tue 22 06:50)

Re: statement stats extra load? Alan McKay (Tue 22 13:20)
Re: statement stats extra load? Magnus Hagander (Wed 23 08:05)

Problem with partitionning and orderby query plans Gaël Le Mignot (Tue 15 12:58)
statistical table std pik (Tue 15 09:32)

Re: statistical table Lennin Caro (Thu 17 13:43)
Re: statistical table Joshua Tolley (Thu 17 13:43)

disable heavily updated (but small) table auto-vecuuming Ludwik Dylag (Tue 15 08:06)

Re: disable heavily updated (but small) table auto-vecuuming Robert Haas (Tue 15 15:45)

noapic option C Storm (Mon 14 22:01)

Re: noapic option Craig Ringer (Thu 17 08:02)

Re: noapic option christian.storm (Thu 17 18:32)

Possible causes of sometimes slow single-row UPDATE with trivial indexed condition? Vlad Romascanu (Mon 14 21:54)

Re: Possible causes of sometimes slow single-row UPDATE with trivial indexed condition? Richard Huxton (Thu 17 07:58)
Re: Possible causes of sometimes slow single-row UPDATE with trivial indexed condition? Andy Colson (Thu 17 13:45)

Re: Possible causes of sometimes slow single-row UPDATE with trivial indexed condition? Vlad Romascanu (Thu 17 16:49)

How to post Performance Questions Josh Berkus (Mon 14 20:56)

Re: How to post Performance Questions Michael Glaesemann (Mon 14 23:19)

Re: How to post Performance Questions Kevin Grittner (Tue 15 14:50)

Re: How to post Performance Questions Alvaro Herrera (Mon 21 18:23)

CLUSTER and a problem Andrzej Zawadzki (Mon 14 13:54)

<Possible follow-ups>
CLUSTER and a problem Andrzej Zawadzki (Mon 14 14:25)

Re: CLUSTER and a problem Josh Berkus (Mon 14 18:05)

Re: CLUSTER and a problem Andrzej Zawadzki (Mon 14 21:08)

Re: CLUSTER and a problem Tom Lane (Mon 14 23:13)

Re: CLUSTER and a problem Andrzej Zawadzki (Tue 15 07:36)
Re: CLUSTER and a problem Andrzej Zawadzki (Tue 15 11:13)
Re: CLUSTER and a problem Andrzej Zawadzki (Tue 15 20:11)
Re: CLUSTER and a problem Grzegorz Jaśkiewicz (Wed 16 09:34)

Re: [PERFORMANCE] work_mem vs temp files issue decibel (Sun 13 22:12)

Re: [PERFORMANCE] work_mem vs temp files issue Tom Lane (Sun 13 22:37)

possible wrong query plan on pg 8.3.5, zz_11 (Sun 13 07:26)

Re: possible wrong query plan on pg 8.3.5, Tom Lane (Sun 13 19:21)

Re: possible wrong query plan on pg 8.3.5, zz_11 (Mon 14 06:27)

Re: possible wrong query plan on pg 8.3.5, tv (Mon 14 09:32)

Re: possible wrong query plan on pg 8.3.5, zz_11 (Mon 14 10:49)
Re: possible wrong query plan on pg 8.3.5, Robert Haas (Mon 14 13:38)

Re: possible wrong query plan on pg 8.3.5, zz_11 (Mon 14 14:17)
Re: possible wrong query plan on pg 8.3.5, Robert Haas (Mon 14 15:30)
Re: possible wrong query plan on pg 8.3.5, zz_11 (Mon 14 16:14)
Re: possible wrong query plan on pg 8.3.5, Віталій Тимчишин (Tue 15 06:32)
Re: possible wrong query plan on pg 8.3.5, zz_11 (Tue 15 10:10)

Re: possible wrong query plan on pg 8.3.5, Scott Marlowe (Mon 14 15:51)

Re: possible wrong query plan on pg 8.3.5, zz_11 (Mon 14 16:07)

Persistent Plan Cache Joshua Rubin (Fri 11 20:34)

Main Index
[Prev Page]
[Next Page]

Mail converted by MHonArc

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