Mailing lists [pgsql-performance]
- Re: Number of tables Mike Ivanov
- Re: Number of tables Greg Stark
- Re: Number of tables Mike Ivanov
- moving data between tables causes the db to overwhelm the system Kevin Kempter
- Re: moving data between tables causes the db to overwhelm the system tv@fuzzy.cz
- Re: moving data between tables causes the db to overwhelm the system Pierre Frédéric Caillaud
- Re: moving data between tables causes the db to overwhelm the system Kevin Kempter
- Re: moving data between tables causes the db to overwhelm the system tv@fuzzy.cz
- Re: moving data between tables causes the db to overwhelm the system Pierre Frédéric Caillaud
- Re: moving data between tables causes the db to overwhelm the system Robert Schnabel
- Re: Performance issues with large amounts of time-series data Hrishikesh (हृषीकेश मेहेंदळे)
- partition queries hitting all partitions even though check key is specified Kevin Kempter
- Re: partition queries hitting all partitions even though check key is specified Kenneth Marshall
- Re: partition queries hitting all partitions even though check key is specified Scott Marlowe
- Re: partition queries hitting all partitions even though check key is specified Kevin Kempter
- Re: partition queries hitting all partitions even though check key is specified Kevin Kempter
- Re: partition queries hitting all partitions even though check key is specified bricklen
- Re: partition queries hitting all partitions even though check key is specified Greg Jaman
- Re: partition queries hitting all partitions even though check key is specified Tom Lane
- Re: partition queries hitting all partitions even though check key is specified Greg Stark
- Re: partition queries hitting all partitions even though check key is specified Kevin Kempter
- Re: partition queries hitting all partitions even though check key is specified Joshua D. Drake
- Re: partition queries hitting all partitions even though check key is specified Tom Lane
- Re: partition queries hitting all partitions even though check key is specified Tom Lane
- Re: partition queries hitting all partitions even though check key is specified Scott Carey
- partition query using Seq Scan even when index is present Kenneth Cox
- Re: partition query using Seq Scan even when index is present Greg Jaman
- Seeking performance advice and explanation for high I/O on 8.3 Scott Otis
- Re: partition queries hitting all partitions even thoughcheck key is specified Joshua D. Drake
- Help: how to speed up query after db server reboot Wei Yan
- Slow select times on select with xpath astro77
- pg_stat_activity.current_query explanation? Pat Chan
- Looking for real configuration data Wei Zheng
- Re: Help: how to speed up query after db server reboot Magnus Hagander
- Re: pg_stat_activity.current_query explanation? Joshua Tolley
- Re: Help: how to speed up query after db server reboot Tom Lane
- Re: partition query using Seq Scan even when index is present Merlin Moncure
- Re: Seeking performance advice and explanation for high I/O on 8.3 Ivan Voras
- Re: Slow select times on select with xpath Kevin Grittner
- Re: Seeking performance advice and explanation for high I/O on 8.3 Andy Colson
- Re: partition query using Seq Scan even when index is present Kenneth Cox
- Re: Seeking performance advice and explanation for high I/O on 8.3 Andy Colson
- Re: Slow select times on select with xpath Robert Haas
- Re: Seeking performance advice and explanation for high I/O on 8.3 Scott Otis
- Re: Seeking performance advice and explanation for high I/O on 8.3 Andy Colson
- PostgreSQL not using index for statement with group by Mark Starkman
- Re: SAAS and MySQL Tguru
- Re: Slow select times on select with xpath astro77
- Re: Seeking performance advice and explanation for high I/O on 8.3 Robert Haas
- Re: Slow select times on select with xpath Robert Haas
- Re: Seeking performance advice and explanation for high I/O on 8.3 Andy Colson
- Re: Seeking performance advice and explanation for high I/O on 8.3 Robert Haas
- Re: Seeking performance advice and explanation for high I/O on 8.3 Ivan Voras
- Re: PostgreSQL not using index for statement with group by Kevin Grittner
- Re: Seeking performance advice and explanation for high I/O on 8.3 Scott Otis
- Re: Seeking performance advice and explanation for high I/O on 8.3 Scott Otis
- Re: SAAS and MySQL Merlin Moncure
- Re: PostgreSQL not using index for statement with group by Scott Marlowe
- Re: Seeking performance advice and explanation for high I/O on 8.3 Robert Haas
- Re: Seeking performance advice and explanation for high I/O on 8.3 Scott Otis
- Re: Seeking performance advice and explanation for high I/O on 8.3 Scott Otis
- Re: Seeking performance advice and explanation for high I/O on 8.3 Claus Guttesen
- Re: Seeking performance advice and explanation for high I/O on 8.3 Magnus Hagander
- Planner question - "bit" data types Karl Denninger
- Re: Seeking performance advice and explanation for high I/O on 8.3 Scott Otis
- Re: Seeking performance advice and explanation for high I/O on 8.3 Kevin Grittner
- Re: Planner question - "bit" data types Josh Berkus
- Re: Planner question - "bit" data types Merlin Moncure
- Re: Planner question - "bit" data types Tom Lane
- Re: Planner question - "bit" data types Karl Denninger
- Re: Planner question - "bit" data types Tom Lane
- Re: Planner question - "bit" data types Karl Denninger
- Re: Planner question - "bit" data types Tom Lane
- Re: Planner question - "bit" data types Karl Denninger
- Re: Planner question - "bit" data types Alvaro Herrera
- Re: Planner question - "bit" data types Karl Denninger
- Re: Planner question - "bit" data types Merlin Moncure
- slow query : very simple delete, 100% cpu, nearly no disk activity Vincent de Phily
- Re: slow query : very simple delete, 100% cpu, nearly no disk activity Tom Lane
- Using Gprof with Postgresql Reydan Cankur
- Re: Using Gprof with Postgresql Grzegorz Jaśkiewicz
- Re: Using Gprof with Postgresql Jeff Janes
- Re: Using Gprof with Postgresql Tom Lane
- Re: Planner question - "bit" data types Fernando Hevia
- Re: Planner question - "bit" data types Robert Haas
- Re: Planner question - "bit" data types Karl Denninger
- Re: Planner question - "bit" data types Robert Haas
- Re: Planner question - "bit" data types Brian Cox
- Re: Planner question - "bit" data types Karl Denninger
- Re: Planner question - "bit" data types Alvaro Herrera
- Re: Planner question - "bit" data types Robert Haas
- Re: Planner question - "bit" data types Tom Lane
- Re: Using Gprof with Postgresql Reydan Cankur
- Re: Using Gprof with Postgresql Reydan Cankur
- Re: Using Gprof with Postgresql Pierre Frédéric Caillaud
- Re: Using Gprof with Postgresql Craig James
- Forcing postgresql to use an index Eugene Morozov
- Re: Forcing postgresql to use an index Grzegorz Jaśkiewicz
- Re: Forcing postgresql to use an index Kevin Grittner
- Re: Forcing postgresql to use an index Scott Marlowe
- Statistics and PostgreSQL: Streaming Webcast tonight David Fetter
- Re: [sfpug] Statistics and PostgreSQL: Streaming Webcast tonight David Fetter
- Re: [GENERAL] [sfpug] Statistics and PostgreSQL: Streaming Webcast tonight David Fetter
- partitioning max() sql not using index Kevin Kempter
- Re: Forcing postgresql to use an index Eugene Morozov
- Re: partitioning max() sql not using index Heikki Linnakangas
- Best Profiler for PostgreSQL Reydan Cankur
- Re: partitioning max() sql not using index Kenneth Cox
- Re: partitioning max() sql not using index Kevin Kempter
- Sub-optimal plan chosen bricklen
- Re: Sub-optimal plan chosen tv@fuzzy.cz
- Re: Sub-optimal plan chosen bricklen
- Re: Best Profiler for PostgreSQL Robert Haas
- Re: Sub-optimal plan chosen tv@fuzzy.cz
- Re: Sub-optimal plan chosen Tom Lane
- Re: Sub-optimal plan chosen bricklen
- Re: Sub-optimal plan chosen Robert Haas
- Re: Sub-optimal plan chosen bricklen
- Re: Sub-optimal plan chosen Robert Haas
- Re: Sub-optimal plan chosen bricklen
- Re: Sub-optimal plan chosen bricklen
- Re: Sub-optimal plan chosen Tom Lane
- Re: Sub-optimal plan chosen bricklen
- Re: slow query : very simple delete, 100% cpu, nearly no disk activity Vincent de Phily
- PSQL 8.4 - partittions - join tables - not optimal plan Vratislav Benes
- Re: Forcing postgresql to use an index Eugene Morozov
- Re: PSQL 8.4 - partittions - join tables - not optimal plan A. Kretschmer
- View vs Stored Proc Performance Jason Tesser
- odd iostat graph Alan McKay
- Re: View vs Stored Proc Performance Merlin Moncure
- Re: odd iostat graph Scott Carey
- Re: odd iostat graph Alan McKay
- Re: odd iostat graph Kevin Grittner
- Re: View vs Stored Proc Performance Jason Tesser
- Re: odd iostat graph Greg Smith
- Re: odd iostat graph Alan McKay
- Re: odd iostat graph Greg Smith
- Re: View vs Stored Proc Performance Merlin Moncure
- Re: View vs Stored Proc Performance Jason Tesser
- Re: slow query : very simple delete, 100% cpu, nearly no disk activity Robert Haas
- Re: View vs Stored Proc Performance Merlin Moncure
- Re: slow query : very simple delete, 100% cpu, nearly no disk activity Merlin Moncure
- Re: View vs Stored Proc Performance Dimitri Fontaine
- Re: View vs Stored Proc Performance Merlin Moncure
- possible wrong query plan on pg 8.3.5, zz_11@mail.bg
- Persistent Plan Cache Joshua Rubin
- Re: Persistent Plan Cache Tom Lane
- Re: possible wrong query plan on pg 8.3.5, Tom Lane
- Re: Persistent Plan Cache Heikki Linnakangas
- Re: Persistent Plan Cache Stephen Frost
- Re: [PERFORMANCE] work_mem vs temp files issue decibel
- Re: [PERFORMANCE] work_mem vs temp files issue Tom Lane
- Re: Persistent Plan Cache Joshua Rubin
- Re: Persistent Plan Cache Heikki Linnakangas
- Re: possible wrong query plan on pg 8.3.5, zz_11@mail.bg
- Re: Persistent Plan Cache Dimitri Fontaine
- Re: possible wrong query plan on pg 8.3.5, tv@fuzzy.cz
- Re: Persistent Plan Cache Ivan Voras
- Re: possible wrong query plan on pg 8.3.5, zz_11@mail.bg
- Re: possible wrong query plan on pg 8.3.5, Robert Haas
- Re: possible wrong query plan on pg 8.3.5, zz_11@mail.bg
- CLUSTER and a problem Andrzej Zawadzki
- Re: possible wrong query plan on pg 8.3.5, Robert Haas
- Re: possible wrong query plan on pg 8.3.5, Scott Marlowe
- Re: possible wrong query plan on pg 8.3.5, zz_11@mail.bg
- Re: possible wrong query plan on pg 8.3.5, zz_11@mail.bg
- Re: CLUSTER and a problem Josh Berkus
- CLUSTER and a problem Andrzej Zawadzki
- How to post Performance Questions Josh Berkus
- Re: CLUSTER and a problem Andrzej Zawadzki
- Re: CLUSTER and a problem Tom Lane
- Re: How to post Performance Questions Michael Glaesemann
- Re: possible wrong query plan on pg 8.3.5, Віталій Тимчишин
- Re: CLUSTER and a problem Andrzej Zawadzki
- disable heavily updated (but small) table auto-vecuuming Ludwik Dylag
- Re: possible wrong query plan on pg 8.3.5, zz_11@mail.bg
- Re: CLUSTER and a problem Andrzej Zawadzki
- Problem with partitionning and orderby query plans gael@pilotsystems.net (Gaël Le Mignot)
- Re: How to post Performance Questions Kevin Grittner
- Re: View vs Stored Proc Performance Ivan Voras
- Re: View vs Stored Proc Performance Tom Lane
- Re: disable heavily updated (but small) table auto-vecuuming Robert Haas
- Re: View vs Stored Proc Performance Ivan Voras
- statement stats extra load? Alan McKay
- Re: CLUSTER and a problem Andrzej Zawadzki
- Re: CLUSTER and a problem Grzegorz Jaśkiewicz
- Possible causes of sometimes slow single-row UPDATE with trivial indexed condition? Vlad Romascanu
- noapic option C Storm
- statistical table std pik
- Re: Possible causes of sometimes slow single-row UPDATE with trivial indexed condition? Richard Huxton
- Re: noapic option Craig Ringer
- optimizing for temporal data behind a view Richard Henwood
- Re: statistical table Lennin Caro
- Re: statistical table Joshua Tolley
- Re: Possible causes of sometimes slow single-row UPDATE with trivial indexed condition? Andy Colson
- Re: optimizing for temporal data behind a view Hrishikesh (हृषीकेश मेहेंदळे)
- Use of BETWEEN with identical values André Volpato
- Re: Use of BETWEEN with identical values André Volpato
- Re: Planner question - "bit" data types Bruce Momjian
- Re: Planner question - "bit" data types Karl Denninger
- Re: Planner question - "bit" data types Bruce Momjian
- Re: Planner question - "bit" data types Bruce Momjian
- Re: Planner question - "bit" data types Karl Denninger
- Different query plans for the same query Hell, Robert
- Re: Different query plans for the same query tv@fuzzy.cz
- Re: Different query plans for the same query Hell, Robert
- Database performance post-VACUUM FULL Karl Wright
- Re: Database performance post-VACUUM FULL Robert Haas
- Re: Use of BETWEEN with identical values Robert Haas
- Re: Different query plans for the same query Tom Lane
- Re: Different query plans for the same query Robert Haas
- Planner question - wrong row count estimation Michael Korbakov
- Re: Possible causes of sometimes slow single-row UPDATE with trivial indexed condition? Vlad Romascanu
- Re: noapic option christian.storm
- Planner question - wrong row count estimation Michael Korbakov
- Index row requires 9324 bytes maximum size is 8191 solAris23
- Re: Index row requires 9324 bytes maximum size is 8191 Euler Taveira de Oliveira
- Re: Index row requires 9324 bytes maximum size is 8191 Pavel Stehule
- Re: Index row requires 9324 bytes maximum size is 8191 Grzegorz Jaśkiewicz
- Re: Index row requires 9324 bytes maximum size is 8191 Florian Weimer
- query memory consumption Alan McKay
- Re: slow query : very simple delete, 100% cpu, nearly no disk activity Merlin Moncure
- Re: How to post Performance Questions Alvaro Herrera
- Re: query memory consumption Robert Haas
- Re: statement stats extra load? Bruce Momjian
- Re: Planner question - wrong row count estimation Josh Berkus
- Re: statement stats extra load? Alan McKay
- Re: statement stats extra load? Bruce Momjian
- session servers in ram Scott Marlowe
- Re: slow query : very simple delete, 100% cpu, nearly no disk activity Vincent de Phily
- Re: slow query : very simple delete, 100% cpu, nearly no disk activity Vincent de Phily
- Re: slow query : very simple delete, 100% cpu, nearly no disk activity Vincent de Phily
- Re: Slow select times on select with xpath astro77
- Re: Slow select times on select with xpath astro77
- Re: Slow select times on select with xpath astro77
- Re: Slow select times on select with xpath Ron Mayer
- Re: statement stats extra load? Magnus Hagander
- Re: query memory consumption Matthew Wakeling
- Re: Slow select times on select with xpath Dimitri Fontaine
- Re: query memory consumption Alan McKay
- Re: query memory consumption Grzegorz Jaśkiewicz
- Re: query memory consumption Alan McKay
- Re: session servers in ram Greg Spiegelberg
- Re: query memory consumption Grzegorz Jaśkiewicz
- Re: session servers in ram Pavel Stehule
- Re: session servers in ram Aidan Van Dyk
- Re: statement stats extra load? Alan McKay
- High CPU load on Postgres Server during Peak times!!!! Shiva Raman
- Hunting Unused Indexes .. is it this simple ? Stef Telford
- Re: High CPU load on Postgres Server during Peak times!!!! Merlin Moncure
- Re: High CPU load on Postgres Server during Peak times!!!! Andy Colson
- Re: High CPU load on Postgres Server during Peak times!!!! Andy Colson
- Re: Hunting Unused Indexes .. is it this simple ? Gurjeet Singh
- Re: Hunting Unused Indexes .. is it this simple ? Andy Colson
- Re: High CPU load on Postgres Server during Peak times!!!! Fernando Hevia
- Re: session servers in ram Alan Hodgson
- Re: session servers in ram Ron Mayer
- Re: session servers in ram Scott Marlowe
- Re: Hunting Unused Indexes .. is it this simple ? Josh Berkus
- Re: statement stats extra load? Magnus Hagander
- Re: High CPU load on Postgres Server during Peak times!!!! Shiva Raman
- Re: High CPU load on Postgres Server during Peak times!!!! Shiva Raman
- Re: High CPU load on Postgres Server during Peak times!!!! Andy Colson
- Re: High CPU load on Postgres Server during Peak times!!!! Fernando Hevia
- Re: High CPU load on Postgres Server during Peak times!!!! Karl Denninger
- Re: High CPU load on Postgres Server during Peak times!!!! Scott Marlowe
- Slow query after upgrade to 8.4 Jared Beck
- Re: Slow query after upgrade to 8.4 Greg Williamson
- Slow query after upgrade to 8.4 Jared Beck
- Use of sequence rather than index scan for one text column on one instance of a database Bill Kirtley
- Re: Slow query after upgrade to 8.4 Tom Lane
- Re: Use of sequence rather than index scan for one text column on one instance of a database Tom Lane
- Re: Different query plans for the same query Hell, Robert
- Speed while runnning large transactions. jesper@krogh.cc
- Re: Speed while runnning large transactions. Claus Guttesen
- Re: Speed while runnning large transactions. Grzegorz Jaśkiewicz
- Re: Speed while runnning large transactions. Scott Marlowe
- Re: Index row requires 9324 bytes maximum size is 8191 solAris23
- Re: Slow query after upgrade to 8.4 tv@fuzzy.cz
- Re: Speed while runnning large transactions. jesper@krogh.cc
- Re: Speed while runnning large transactions. jesper@krogh.cc
- Re: Slow query after upgrade to 8.4 Jared Beck
- Re: High CPU load on Postgres Server during Peak times!!!! Shiva Raman
- Re: High CPU load on Postgres Server during Peak times!!!! Praveen DS
- Re: High CPU load on Postgres Server during Peak times!!!! Andy Colson
- Re: Use of sequence rather than index scan for one text column on one instance of a database Tom Lane
- Re: High CPU load on Postgres Server during Peak times!!!! Karl Denninger
- Re: Use of sequence rather than index scan for one text column on one instance of a database Tom Lane
- Re: High CPU load on Postgres Server during Peak times!!!! Dave Dutcher
- Regarding Sequential Scans count increase each time we press refresh . keshav upadhyaya
- Re: High CPU load on Postgres Server during Peak times!!!! Karl Denninger
- Re: High CPU load on Postgres Server during Peak times!!!! Craig James
- Re: Regarding Sequential Scans count increase each time we press refresh . Josh Berkus
- PG 8.3 and large shared buffer settings Dan Sugalski
- Re: PG 8.3 and large shared buffer settings Tom Lane
- Re: High CPU load on Postgres Server during Peak times!!!! Shiva Raman
- Re: High CPU load on Postgres Server during Peak times!!!! Shiva Raman
- Re: High CPU load on Postgres Server during Peak times!!!! Grzegorz Jaśkiewicz
- Re: High CPU load on Postgres Server during Peak times!!!! Shiva Raman
- Re: High CPU load on Postgres Server during Peak times!!!! Grzegorz Jaśkiewicz
- Re: PG 8.3 and large shared buffer settings Dan Sugalski
- Re: High CPU load on Postgres Server during Peak times!!!! Gerhard Wiesinger
- Re: PG 8.3 and large shared buffer settings Aidan Van Dyk
- Re: High CPU load on Postgres Server during Peak times!!!! Craig James
- Re: PG 8.3 and large shared buffer settings Scott Carey
- Re: PG 8.3 and large shared buffer settings Aidan Van Dyk
- Re: PG 8.3 and large shared buffer settings Jeff Janes
- Re: query memory consumption Jeff Janes
- Bad performance of SELECT ... where id IN (...) Xia Qingran
- Re: Bad performance of SELECT ... where id IN (...) Claus Guttesen
- Re: PG 8.3 and large shared buffer settings Greg Smith
- Re: PG 8.3 and large shared buffer settings Greg Smith
- Re: Bad performance of SELECT ... where id IN (...) Craig James
- Re: Bad performance of SELECT ... where id IN (...) Paul Ooi
- Re: PG 8.3 and large shared buffer settings Gerhard Wiesinger
- Re: Bad performance of SELECT ... where id IN (...) Tom Lane
- Re: PG 8.3 and large shared buffer settings Pierre Frédéric Caillaud
- Re: Bad performance of SELECT ... where id IN (...) Grzegorz Jaśkiewicz
- Re: PG 8.3 and large shared buffer settings Jeff Janes
- Re: PG 8.3 and large shared buffer settings Jeff Janes
- Re: PG 8.3 and large shared buffer settings Greg Smith
- Re: Bad performance of SELECT ... where id IN (...) Xia Qingran
- Re: Bad performance of SELECT ... where id IN (...) Xia Qingran
- Re: Many left outer joins with limit performance Gerhard Wiesinger
- Re: Regarding Sequential Scans count increase each time we press refresh . Robert Haas
- Re: query memory consumption Robert Haas
- Re: Slow query after upgrade to 8.4 Robert Haas
- Re: Regarding Sequential Scans count increase each time we press refresh . Tom Lane
- LIMIT confuses the planner (again) Kouber Saparev
- Re: LIMIT confuses the planner (again) Robert Haas
- Re: Postgres performance Andy Colson
- Re: PG 8.3 and large shared buffer settings Josh Berkus
- Re: Postgres performance Scott Marlowe
- Performance problems with DISTINCT ON Sgarbossa Domenico
- Re: Performance problems with DISTINCT ON Richard Huxton
- Using OProfile Reydan Cankur
- Re: Performance problems with DISTINCT ON Sgarbossa Domenico
- Re: Performance problems with DISTINCT ON hubert depesz lubaczewski
- Re: Using OProfile Tom Lane
- Re: Performance problems with DISTINCT ON Scott Carey
- FullTextSearch - UNION individual indexes or concatenated columns index ? Jeremy Ferrante
- Re: Speed while runnning large transactions. Robert Haas
- Re: FullTextSearch - UNION individual indexes or concatenated columns index ? Josh Berkus
- Re: Bad performance of SELECT ... where id IN (...) Ivan Voras
- CPU cost of operators Matthew Wakeling
- Re: CPU cost of operators Robert Haas
- Re: CPU cost of operators Robert Haas
- Re: CPU cost of operators Tom Lane