Mailing lists [pgsql-performance]
- Re: temp table "on commit delete rows": transaction overhead Bruce Momjian
- Re: How to fast the REINDEX Craig Ringer
- Re: How to fast the REINDEX Steve Clark
- Re: How to fast the REINDEX Greg Smith
- Re: experiments in query optimization Faheem Mitha
- Re: How to fast the REINDEX Pierre C
- Re: How to fast the REINDEX raghavendra t
- Re: How to fast the REINDEX Brad Nicholson
- Re: How to fast the REINDEX Kevin Grittner
- Re: experiments in query optimization Eliot Gable
- Re: experiments in query optimization Faheem Mitha
- Re: experiments in query optimization Robert Haas
- Re: experiments in query optimization Faheem Mitha
- Re: experiments in query optimization Eliot Gable
- Re: experiments in query optimization Faheem Mitha
- Re: Database size growing over time and leads to performance impact Scott Carey
- Re: Database size growing over time and leads to performance impact Tom Lane
- Re: Database size growing over time and leads to performance impact Scott Carey
- Using high speed swap to improve performance? Christiaan Willemsen
- Re: Using high speed swap to improve performance? Arjen van der Meijden
- Re: How much memory is PostgreSQL using Campbell, Lance
- Does the psql executable support a "fetch many" approach when dumping large queries to stdout? Beaver, John E
- Re: *** PROBABLY SPAM *** Does the psql executable support a "fetch many" approach when dumping large queries to stdout? Pierre C
- Re: Does the psql executable support a "fetch many" approach when dumping large queries to stdout? John Beaver
- Re: *** PROBABLY SPAM *** Does the psql executable support a "fetch many" approach when dumping large queries to stdout? John Beaver
- David Crooke wants to stay in touch on LinkedIn David Crooke
- Re: How much memory is PostgreSQL using Guillaume Lelarge
- ERROR: cache lookup failed for relation X raghavendra t
- Re: [GENERAL] ERROR: cache lookup failed for relation X justin@magwerks.com
- Re: [GENERAL] ERROR: cache lookup failed for relation X Tom Lane
- Re: [GENERAL] ERROR: cache lookup failed for relation X raghavendra t
- Re: Using high speed swap to improve performance? Robert Haas
- Re: Using high speed swap to improve performance? Robert Haas
- Re: Using high speed swap to improve performance? Scott Marlowe
- Re: temp table "on commit delete rows": transaction overhead Bruce Momjian
- Huge table searching optimization Oliver Kindernay
- Re: Huge table searching optimization hubert depesz lubaczewski
- Re: Using high speed swap to improve performance? Greg Smith
- Re: Huge table searching optimization Andres Freund
- Re: Huge table searching optimization Tom Lane
- Re: How to fast the REINDEX Robert Haas
- Re: Huge table searching optimization Oliver Kindernay
- query slow; strace output worrisome Brian Cox
- Re: query slow; strace output worrisome Craig Ringer
- Re: query slow; strace output worrisome Brian Cox
- Re: query slow; strace output worrisome Craig Ringer
- Re: Using high speed swap to improve performance? Christiaan Willemsen
- Re: temp table "on commit delete rows": transaction overhead Artiom Makarov
- Some question Ľubomír Varga
- Re: How to fast the REINDEX Hannu Krosing
- Re: Does the psql executable support a "fetch many" approach when dumping large queries to stdout? Hannu Krosing
- Re: Using high speed swap to improve performance? Lew
- LIMIT causes planner to do Index Scan using a less optimal index Joel Jacobson
- Re: temp table "on commit delete rows": transaction overhead Artiom Makarov
- Re: query slow; strace output worrisome Brian Cox
- Re: 3ware vs. MegaRAID Ireneusz Pluta
- Re: LIMIT causes planner to do Index Scan using a less optimal index Robert Haas
- Re: Some question Scott Marlowe
- Re: Using high speed swap to improve performance? Scott Marlowe
- Re: Some question Kevin Grittner
- indexes in partitioned tables - again Samuel Gendler
- Re: LIMIT causes planner to do Index Scan using a less optimal index Robert Haas
- Re: query slow; strace output worrisome Craig Ringer
- Re: Some question Yeb Havinga
- Re: LIMIT causes planner to do Index Scan using a less optimal index Sherry.CTR.Zhu@faa.gov
- Re: LIMIT causes planner to do Index Scan using a less optimal index Grzegorz Jaśkiewicz
- Re: LIMIT causes planner to do Index Scan using a less optimal index Sherry.CTR.Zhu@faa.gov
- Re: LIMIT causes planner to do Index Scan using a less optimal index Grzegorz Jaśkiewicz
- Re: LIMIT causes planner to do Index Scan using a less optimal index Sherry.CTR.Zhu@faa.gov
- Re: LIMIT causes planner to do Index Scan using a less optimal index Matthew Wakeling
- Re: query slow; strace output worrisome Robert Haas
- Re: indexes in partitioned tables - again Robert Haas
- Occasional giant spikes in CPU load Craig James
- Re: Occasional giant spikes in CPU load Joshua D. Drake
- Re: Occasional giant spikes in CPU load Craig James
- Re: Occasional giant spikes in CPU load Greg Smith
- Re: Occasional giant spikes in CPU load Tom Lane
- Re: Occasional giant spikes in CPU load Joshua D. Drake
- Re: Occasional giant spikes in CPU load David Rees
- Re: Occasional giant spikes in CPU load Craig James
- Re: Occasional giant spikes in CPU load Craig James
- Re: Occasional giant spikes in CPU load Steve Crawford
- Re: Occasional giant spikes in CPU load David Rees
- Re: Occasional giant spikes in CPU load Tom Lane
- Re: Occasional giant spikes in CPU load Robert Haas
- Re: Occasional giant spikes in CPU load Craig James
- Re: Occasional giant spikes in CPU load David Rees
- Re: Occasional giant spikes in CPU load Robert Haas
- Re: 3ware vs. MegaRAID Scott Carey
- Re: 3ware vs. MegaRAID Dave Crooke
- Re: Occasional giant spikes in CPU load Joshua D. Drake
- Re: Occasional giant spikes in CPU load Joshua D. Drake
- Re: Occasional giant spikes in CPU load Greg Smith
- Re: 3ware vs. MegaRAID Greg Smith
- PostgreSQL with Zabbix - problem of newbe Krzysztof Kardas
- Re: PostgreSQL with Zabbix - problem of newbe Grzegorz Jaśkiewicz
- Re: PostgreSQL with Zabbix - problem of newbe Merlin Moncure
- Query Optimization Kaloyan Iliev Iliev
- Re: Query Optimization Kaloyan Iliev Iliev
- Re: LIMIT causes planner to do Index Scan using a less optimal index Joel Jacobson
- significant slow down with various LIMIT norn
- How check execution plan of a function Sabin Coanda
- Re: LIMIT causes planner to do Index Scan using a less optimal index Joel Jacobson
- Re: Using high speed swap to improve performance? Lew
- Re: How check execution plan of a function Sabin Coanda
- Re: Occasional giant spikes in CPU load Alan Hodgson
- Re: Query Optimization A. Kretschmer
- Re: How check execution plan of a function Andy Colson
- Re: significant slow down with various LIMIT Kevin Grittner
- Re: PostgreSQL with Zabbix - problem of newbe Robert Haas
- Re: PostgreSQL with Zabbix - problem of newbe Richard Yen
- Re: PostgreSQL with Zabbix - problem of newbe Greg Smith
- Re: 3ware vs. MegaRAID Scott Carey
- Re: PostgreSQL with Zabbix - problem of newbe Greg Smith
- Re: 3ware vs. MegaRAID Jesper Krogh
- Re: How check execution plan of a function Andy Colson
- Re: PostgreSQL with Zabbix - problem of newbe Merlin Moncure
- Re: PostgreSQL with Zabbix - problem of newbe Scott Mead
- Re: 3ware vs. MegaRAID Greg Smith
- Re: PostgreSQL with Zabbix - problem of newbe Greg Smith
- Re: 3ware vs. MegaRAID Jesper Krogh
- Re: PostgreSQL with Zabbix - problem of newbe Scott Marlowe
- Re: PostgreSQL with Zabbix - problem of newbe Merlin Moncure
- Re: PostgreSQL with Zabbix - problem of newbe Scott Marlowe
- Re: 3ware vs. MegaRAID Greg Smith
- Re: 3ware vs. MegaRAID Jesper Krogh
- Re: 3ware vs. MegaRAID Scott Marlowe
- "could not open relation..." Brian Cox
- Re: significant slow down with various LIMIT norn
- About “context-switching issue on Xeon” test case ？ RD黄永卫
- Re: How check execution plan of a function Sabin Coanda
- Re: significant slow down with various LIMIT Robert Haas
- Re: About “context-switching issue on Xeon” test case ？ Greg Smith
- Re: "could not open relation..." Tom Lane
- Re: [PERFORM] About “context-switching issue on Xeon” test case ？ Scott Marlowe
- Re: [PERFORM] About “context-switching issue on Xeon” test case ？ Scott Marlowe
- Re: PostgreSQL with Zabbix - problem of newbe Krzysztof Kardas
- function performs differently with different values Ben Chobot
- Re: About “context-switching issue on Xeon” test case ？ Greg Smith
- Re: "could not open relation..." Brian Cox
- Re: Some question Kevin Grittner
- Re: [PERFORM] About “context-switching issue on Xeon” test case ？ Scott Marlowe
- planer chooses very bad plan Corin
- Re: planer chooses very bad plan Scott Marlowe
- Re: planer chooses very bad plan Luke Lonergan
- Re: planer chooses very bad plan Corin
- Re: planer chooses very bad plan Corin
- Re: planer chooses very bad plan Scott Marlowe
- Re: significant slow down with various LIMIT Helio Campos Mello de Andrade
- Re: planer chooses very bad plan Pierre C
- significant slow down with various LIMIT Helio Campos Mello de Andrade
- Re: significant slow down with various LIMIT Kevin Grittner
- Re: function performs differently with different values Robert Haas
- Re: How check execution plan of a function Kevin Grittner
- Re: significant slow down with various LIMIT norn
- Re: Some question Ľubomír Varga
- Re: planer chooses very bad plan Hannu Krosing
- 答复: [PERFORM] About “context-switching issue on Xeon” test case ？ RD黄永卫
- How to diagnose a “context-switching ” storm problem ? RD黄永卫
- Re: significant slow down with various LIMIT norn
- Re: [PERFORM] How to diagnose a “context-switching ” storm problem ? Sergey Konoplev
- Re: significant slow down with various LIMIT Kevin Grittner
- Re: How to diagnose a *context-switching * storm problem ? Kevin Grittner
- Re: *** PROBABLY SPAM *** Does the psql executable support a "fetch many" approach when dumping large queries to stdout? Bruce Momjian
- Re: significant slow down with various LIMIT norn
- count is ten times faster Sabin Coanda
- stats collector suddenly causing lots of IO Chris
- Re: significant slow down with various LIMIT Kevin Grittner
- Re: significant slow down with various LIMIT Chris Bowlby
- Re: count is ten times faster Pierre C
- Re: stats collector suddenly causing lots of IO Cédric Villemain
- Re: "could not open relation..." Tom Lane
- Re: stats collector suddenly causing lots of IO Alvaro Herrera
- Re: PostgreSQL with Zabbix - problem of newbe Krzysztof Kardas
- Re: PostgreSQL with Zabbix - problem of newbe Grzegorz Jaśkiewicz
- Re: PostgreSQL with Zabbix - problem of newbe Kevin Grittner
- Re: count is ten times faster Kevin Grittner
- Re: significant slow down with various LIMIT Kevin Grittner
- Re: PostgreSQL with Zabbix - problem of newbe Krzysztof Kardas
- JDBC question for PG 8.3.9 Dave Crooke
- Re: Occasional giant spikes in CPU load Bruce Momjian
- Re: JDBC question for PG 8.3.9 Craig Ringer
- Good/Bad query plans based on text criteria JmH
- Re: Good/Bad query plans based on text criteria Tom Lane
- Re: JDBC question for PG 8.3.9 Dave Crooke
- Re: JDBC question for PG 8.3.9 Dave Cramer
- 8.3.9 - latency spikes with Linux (and tuning for consistently low latency) Marinos Yannikos
- Re: 8.3.9 - latency spikes with Linux (and tuning for consistently low latency) Tom Lane
- Re: 8.3.9 - latency spikes with Linux (and tuning for consistently low latency) Kevin Grittner
- Autovaccum with cost_delay does not complete on one solaris 5.10 machine Josh Berkus
- Re: Autovaccum with cost_delay does not complete on one solaris 5.10 machine Alvaro Herrera
- Re: HELP: How to tame the 8.3.x JDBC driver with a biq guery result set Dave Crooke
- Re: Autovaccum with cost_delay does not complete on one solaris 5.10 machine Tom Lane
- Re: Autovaccum with cost_delay does not complete on one solaris 5.10 machine Alvaro Herrera
- Re: Autovaccum with cost_delay does not complete on one solaris 5.10 machine Josh Berkus
- Re: stats collector suddenly causing lots of IO Tom Lane
- Re: 8.3.9 - latency spikes with Linux (and tuning for consistently low latency) Greg Smith
- Re: Autovaccum with cost_delay does not complete on one solaris 5.10 machine Tom Lane
- Re: Autovaccum with cost_delay does not complete on one solaris 5.10 machine Josh Berkus
- SOLVED: Re: HELP: How to tame the 8.3.x JDBC driver with a biq guery result set Dave Crooke
- Planner not using column limit specified for one column for another column equal to first Віталій Тимчишин
- Re: Planner not using column limit specified for one column for another column equal to first Yeb Havinga
- Re: Planner not using column limit specified for one column for another column equal to first Віталій Тимчишин
- Re: Planner not using column limit specified for one column for another column equal to first Віталій Тимчишин
- Re: Planner not using column limit specified for one column for another column equal to first Yeb Havinga
- Re: Planner not using column limit specified for one column for another column equal to first Віталій Тимчишин
- Re: Planner not using column limit specified for one column for another column equal to first Tom Lane
- Re: stats collector suddenly causing lots of IO Josh Kupershmidt
- Re: stats collector suddenly causing lots of IO Tom Lane
- Re: stats collector suddenly causing lots of IO Tom Lane
- Re: stats collector suddenly causing lots of IO Josh Kupershmidt
- Re: Planner not using column limit specified for one column for another column equal to first Yeb Havinga
- Re: stats collector suddenly causing lots of IO Tom Lane
- Re: Planner not using column limit specified for one column for another column equal to first Tom Lane
- Re: stats collector suddenly causing lots of IO Tom Lane
- Re: stats collector suddenly causing lots of IO Josh Kupershmidt
- Re: Autovaccum with cost_delay does not complete on one solaris 5.10 machine Josh Berkus
- Re: stats collector suddenly causing lots of IO Tom Lane
- Re: stats collector suddenly causing lots of IO Tom Lane
- Re: Autovaccum with cost_delay does not complete on one solaris 5.10 machine Alvaro Herrera
- Re: Autovaccum with cost_delay does not complete on one solaris 5.10 machine Josh Berkus
- Re: stats collector suddenly causing lots of IO Scott Carey
- Re: stats collector suddenly causing lots of IO Scott Carey
- Re: stats collector suddenly causing lots of IO Josh Kupershmidt
- Re: stats collector suddenly causing lots of IO Greg Smith
- Re: stats collector suddenly causing lots of IO Josh Kupershmidt
- Re: stats collector suddenly causing lots of IO Greg Smith
- Re: stats collector suddenly causing lots of IO Tom Lane
- Re: stats collector suddenly causing lots of IO Josh Kupershmidt
- Re: Planner not using column limit specified for one column for another column equal to first Віталій Тимчишин
- Re: Planner not using column limit specified for one column for another column equal to first Matthew Wakeling
- Re: Re: HELP: How to tame the 8.3.x JDBC driver with a biq guery result set Scott Carey
- Getting rid of a cursor from JDBC .... Re: Re: HELP: How to tame the 8.3.x JDBC driver with a biq guery result set Dave Crooke
- SOLVED ... Re: Getting rid of a cursor from JDBC .... Re: Re: HELP: How to tame the 8.3.x JDBC driver with a biq guery result set Dave Crooke
- Dbt2 with postgres issues on CentOS-5.3 MUHAMMAD ASIF
- [JDBC] SOLVED ... Re: Getting rid of a cursor from JDBC .... Re: Re: HELP: How to tame the 8.3.x JDBC driver with a biq guery result set Kevin Grittner
- stats collector suddenly causing lots of IO Chris
- Re: significant slow down with various LIMIT norn
- Re: Planner not using column limit specified for one column for another column equal to first Hannu Krosing
- HELP: How to tame the 8.3.x JDBC driver with a biq guery result set Dave Crooke
- Re: [JDBC] SOLVED ... Re: Getting rid of a cursor from JDBC .... Re: Re: HELP: How to tame the 8.3.x JDBC driver with a biq guery result set Dave Crooke
- Re: [JDBC] SOLVED ... Re: Getting rid of a cursor from JDBC .... Re: Re: HELP: How to tame the 8.3.x JDBC driver with a biq guery result set Kris Jurka
- Re: [JDBC] SOLVED ... Re: Getting rid of a cursor from JDBC .... Re: Re: HELP: How to tame the 8.3.x JDBC driver with a biq guery result set Kevin Grittner
- Very high effective_cache_size == worse performance? David Kerr
- Re: Very high effective_cache_size == worse performance? Joshua D. Drake
- Re: Very high effective_cache_size == worse performance? Robert Haas
- Re: Very high effective_cache_size == worse performance? David Kerr
- Re: Very high effective_cache_size == worse performance? Nikolas Everett
- Re: Very high effective_cache_size == worse performance? Robert Haas
- Re: Very high effective_cache_size == worse performance? Scott Marlowe
- Re: Very high effective_cache_size == worse performance? Kevin Grittner
- Re: Very high effective_cache_size == worse performance? Kris Jurka
- Re: Very high effective_cache_size == worse performance? Scott Marlowe
- Re: Very high effective_cache_size == worse performance? David Kerr
- Re: Very high effective_cache_size == worse performance? Scott Marlowe
- Re: Very high effective_cache_size == worse performance? David Kerr
- Re: Very high effective_cache_size == worse performance? Scott Marlowe
- Re: Very high effective_cache_size == worse performance? David Kerr
- Re: Very high effective_cache_size == worse performance? David Kerr
- Re: Very high effective_cache_size == worse performance? David Kerr
- performance change from 8.3.1 to later releases Roger Ging
- Re: Very high effective_cache_size == worse performance? Scott Marlowe
- Re: Very high effective_cache_size == worse performance? Scott Marlowe
- Re: [JDBC] SOLVED ... Re: Getting rid of a cursor from JDBC .... Re: Re: HELP: How to tame the 8.3.x JDBC driver with a biq guery result set Dave Crooke
- Re: performance change from 8.3.1 to later releases Scott Marlowe
- Re: [JDBC] SOLVED ... Re: Getting rid of a cursor from JDBC .... Re: Re: HELP: How to tame the 8.3.x JDBC driver with a biq guery result set Nikolas Everett
- Re: [JDBC] SOLVED ... Re: Getting rid of a cursor from JDBC .... Re: Re: HELP: How to tame the 8.3.x JDBC driver with a biq guery result set Kevin Grittner
- Re: Very high effective_cache_size == worse performance? Greg Smith
- Re: Very high effective_cache_size == worse performance? David Kerr
- Re: [JDBC] SOLVED ... Re: Getting rid of a cursor from JDBC .... Re: Re: HELP: How to tame the 8.3.x JDBC driver with a biq guery result set Dave Crooke
- Re: [JDBC] SOLVED ... Re: Getting rid of a cursor from JDBC .... Re: Re: HELP: How to tame the 8.3.x JDBC driver with a biq guery result set Kris Jurka
- Re: significant slow down with various LIMIT Kevin Grittner
- Re: Very high effective_cache_size == worse performance? Joshua D. Drake
- Re: performance change from 8.3.1 to later releases Tom Lane
- Re: Very high effective_cache_size == worse performance? Greg Smith
- Re: significant slow down with various LIMIT Kevin Grittner
- Re: [JDBC] SOLVED ... Re: Getting rid of a cursor from JDBC .... Re: Re: HELP: How to tame the 8.3.x JDBC driver with a biq guery result set Robert Haas
- Re: [JDBC] SOLVED ... Re: Getting rid of a cursor from JDBC .... Re: Re: HELP: How to tame the 8.3.x JDBC driver with a biq guery result set Nikolas Everett
- Re: [JDBC] SOLVED ... Re: Getting rid of a cursor from JDBC .... Re: Re: HELP: How to tame the 8.3.x JDBC driver with a biq guery result set Tom Lane
- Re: [JDBC] SOLVED ... Re: Getting rid of a cursor from JDBC .... Re: Re: HELP: How to tame the 8.3.x JDBC driver with a biq guery result set Nikolas Everett
- Re: [JDBC] SOLVED ... Re: Getting rid of a cursor from JDBC .... Re: Re: HELP: How to tame the 8.3.x JDBC driver with a biq guery result set Kris Jurka
- Re: [JDBC] SOLVED ... Re: Getting rid of a cursor from JDBC .... Re: Re: HELP: How to tame the 8.3.x JDBC driver with a biq guery result set Kris Jurka
- Replacing Cursors with Temporary Tables Eliot Gable
- Re: [PERFORM] Dbt2 with postgres issues on CentOS-5.3 Mark Wong
- Re: Replacing Cursors with Temporary Tables Robert Haas
- Re: Very high effective_cache_size == worse performance? Scott Carey
- Re: Replacing Cursors with Temporary Tables Scott Carey
- Optimization idea Vlad Arkhipov
- Re: Replacing Cursors with Temporary Tables Merlin Moncure
- Re: Replacing Cursors with Temporary Tables Merlin Moncure
- Re: Optimization idea Greg Smith
- Re: Replacing Cursors with Temporary Tables Merlin Moncure
- Re: Replacing Cursors with Temporary Tables Merlin Moncure
- Re: significant slow down with various LIMIT norn
- autovacuum strategy / parameters Rick
- Re: significant slow down with various LIMIT norn
- Re: autovacuum strategy / parameters Robert Haas
- Re: Replacing Cursors with Temporary Tables Eliot Gable
- Re: Optimization idea Vlad Arkhipov
- Re: Optimization idea Vlad Arkhipov
- Re: Optimization idea Robert Haas
- Re: Optimization idea Cédric Villemain
- Re: Optimization idea Robert Haas
- Re: Optimization idea Kevin Grittner
- Re: Optimization idea Cédric Villemain
- Re: Replacing Cursors with Temporary Tables Eliot Gable
- Re: Replacing Cursors with Temporary Tables Merlin Moncure
- Re: Optimization idea Robert Haas
- Re: Replacing Cursors with Temporary Tables Robert Haas
- Re: Optimization idea Tom Lane
- Re: Optimization idea Robert Haas
- Re: Replacing Cursors with Temporary Tables Eliot Gable
- Re: Replacing Cursors with Temporary Tables Eliot Gable
- Re: Replacing Cursors with Temporary Tables Pierre C
- Re: Replacing Cursors with Temporary Tables Merlin Moncure
- Re: Replacing Cursors with Temporary Tables Grzegorz Jaśkiewicz
- Re: Replacing Cursors with Temporary Tables Merlin Moncure
- Re: Optimization idea Vlad Arkhipov
- Re: Optimization idea Cédric Villemain
- Re: autovacuum strategy / parameters Rick
- Planner issue on sorting joining of two tables with limit Коротков Александр
- Re: Planner issue on sorting joining of two tables with limit Tom Lane
- Re: autovacuum strategy / parameters Alvaro Herrera
- tmpfs and postgres memory Anj Adu
- Re: tmpfs and postgres memory Greg Spiegelberg
- Re: Optimization idea Robert Haas
- Re: autovacuum strategy / parameters Robert Haas
- Re: tmpfs and postgres memory Robert Haas
- Re: Optimization idea Cédric Villemain
- Re: Optimization idea Vlad Arkhipov
- Re: autovacuum strategy / parameters Kevin Grittner
- Re: autovacuum strategy / parameters Thomas Kellerer
- Re: autovacuum strategy / parameters akp geek
- Re: autovacuum strategy / parameters Kenneth Marshall
- Re: autovacuum strategy / parameters Thomas Kellerer
- Re: Optimization idea Robert Haas
- Re: Optimization idea Cédric Villemain
- Re: autovacuum strategy / parameters Josh Berkus