Mailing lists [pgsql-performance]
- Re: degenerate performance on one server of 3 Craig Ringer
- Re: degenerate performance on one server of 3 Tom Lane
- Re: degenerate performance on one server of 3 Erik Aronesty
- Vacuuming technique doubt S Arvind
- Postgresql cache (memory) performance + how to warm up the cache Shaul Dar
- Re: Vacuuming technique doubt David Rees
- Re: Postgresql cache (memory) performance + how to warm up the cache Greg Smith
- Re: degenerate performance on one server of 3 Tom Lane
- Re: Vacuuming technique doubt Greg Smith
- Using index for bitwise operations? Shaul Dar
- Best way to load test a postgresql server Peter Sheats
- Very inefficient query plan with disjunction in WHERE clause Koen Martens
- Re: Using index for bitwise operations? Richard Huxton
- Re: Using index for bitwise operations? Tom Lane
- Re: Very inefficient query plan with disjunction in WHERE clause Віталій Тимчишин
- Re: Best way to load test a postgresql server Alan McKay
- Re: Vacuuming technique doubt S Arvind
- Re: Unexpected query plan results Anne Rosset
- Re: Scalability in postgres Scott Carey
- Re: Unexpected query plan results Robert Haas
- Re: Unexpected query plan results Anne Rosset
- Re: Unexpected query plan results Dave Dutcher
- Re: Unexpected query plan results Anne Rosset
- Re: Unexpected query plan results Robert Haas
- Re: Vacuuming technique doubt Kevin Grittner
- Re: Vacuuming technique doubt Robert Haas
- Re: Scalability in postgres Ron Mayer
- Re: Scalability in postgres Greg Smith
- Re: Best way to load test a postgresql server Dimitri Fontaine
- Re: Unexpected query plan results Віталій Тимчишин
- Re: Unexpected query plan results Robert Haas
- Re: Very inefficient query plan with disjunction in WHERE clause Matthew Wakeling
- Re: Very inefficient query plan with disjunction in WHERE clause Matthew Wakeling
- Re: Using index for bitwise operations? Matthew Wakeling
- Re: Best way to load test a postgresql server Kenneth Cox
- Re: Best way to load test a postgresql server Shaul Dar
- Re: Unexpected query plan results Anne Rosset
- Re: Unexpected query plan results Robert Haas
- Re: Best way to load test a postgresql server Dimitri Fontaine
- Re: Scalability in postgres James Mansion
- Re: Best way to load test a postgresql server Shaul Dar
- Re: Best way to load test a postgresql server Kenneth Cox
- Re: Scalability in postgres Kevin Grittner
- poor performing plan from analyze vs. fast default plan pre-analyze on new database Davin Potts
- Re: poor performing plan from analyze vs. fast default plan pre-analyze on new database Grzegorz Jaśkiewicz
- Re: poor performing plan from analyze vs. fast default plan pre-analyze on new database Tom Lane
- Re: poor performing plan from analyze vs. fast default plan pre-analyze on new database Scott Carey
- Re: Scalability in postgres Dimitri
- Re: Scalability in postgres Kevin Grittner
- Re: Scalability in postgres Scott Carey
- Re: Scalability in postgres Dimitri
- Re: Scalability in postgres Robert Haas
- Re: degenerate performance on one server of 3 Erik Aronesty
- Re: Scalability in postgres Scott Carey
- Re: degenerate performance on one server of 3 Tom Lane
- Pointers needed on optimizing slow SQL statements Janine Sisk
- Re: Pointers needed on optimizing slow SQL statements Tom Lane
- Re: Pointers needed on optimizing slow SQL statements Janine Sisk
- Re: Best way to load test a postgresql server Greg Smith
- Re: Pointers needed on optimizing slow SQL statements Robert Haas
- Query plan issues - volatile tables Brian Herlihy
- Re: Pointers needed on optimizing slow SQL statements Janine Sisk
- Re: degenerate performance on one server of 3 Reid Thompson
- Re: Pointers needed on optimizing slow SQL statements Scott Marlowe
- Re: Scalability in postgres Marc Cousin
- Re: Scalability in postgres Robert Haas
- Re: degenerate performance on one server of 3 Erik Aronesty
- Re: degenerate performance on one server of 3 Robert Haas
- GiST index performance Matthew Wakeling
- Re: Query plan issues - volatile tables Craig James
- Re: degenerate performance on one server of 3 Scott Carey
- Re: Scalability in postgres Scott Carey
- Re: degenerate performance on one server of 3 Scott Carey
- Re: Scalability in postgres Robert Haas
- Re: Pointers needed on optimizing slow SQL statements Josh Berkus
- Re: Scalability in postgres James Mansion
- Re: Scalability in postgres Kevin Grittner
- Re: Scalability in postgres Kevin Grittner
- Re: Scalability in postgres Mark Mielke
- Re: Scalability in postgres david@lang.hm
- Re: Scalability in postgres Scott Carey
- Re: Scalability in postgres david@lang.hm
- Re: Scalability in postgres Robert Haas
- Re: Scalability in postgres Mark Mielke
- Re: Scalability in postgres Greg Smith
- Re: Scalability in postgres david@lang.hm
- Re: Scalability in postgres david@lang.hm
- Re: Scalability in postgres Mark Mielke
- Why is my stats collector so busy? Laszlo Nagy
- Re: Why is my stats collector so busy? Bruce Momjian
- Re: Why is my stats collector so busy? Tom Lane
- Re: Why is my stats collector so busy? Merlin Moncure
- Re: Scalability in postgres Kevin Grittner
- Re: Scalability in postgres Kevin Grittner
- Re: Scalability in postgres Robert Haas
- Re: Scalability in postgres Craig James
- Re: Scalability in postgres Greg Smith
- Re: Scalability in postgres Greg Smith
- Re: Why is my stats collector so busy? Robert Schnabel
- Re: GiST index performance Robert Haas
- Re: Scalability in postgres Robert Haas
- Re: Bad Plan for Questionnaire-Type Query David Blewett
- Re: Bad Plan for Questionnaire-Type Query Josh Berkus
- Re: Bad Plan for Questionnaire-Type Query David Blewett
- Re: degenerate performance on one server of 3 Erik Aronesty
- Re: Bad Plan for Questionnaire-Type Query Robert Haas
- Re: degenerate performance on one server of 3 Robert Haas
- Re: Pointers needed on optimizing slow SQL statements Simon Riggs
- Vacuum ALL FULL S Arvind
- Re: Vacuum ALL FULL S Arvind
- Re: Vacuum ALL FULL Tom Lane
- Re: Vacuum ALL FULL S Arvind
- Re: Vacuum ALL FULL S Arvind
- Re: Vacuum ALL FULL Tom Lane
- Re: Vacuum ALL FULL S Arvind
- Re: Vacuum ALL FULL Tom Lane
- Re: Vacuum ALL FULL S Arvind
- Postgres installation for Performance S Arvind
- Re: Pointers needed on optimizing slow SQL statements Dimitri Fontaine
- Re: Pointers needed on optimizing slow SQL statements Robert Haas
- Re: Why is my stats collector so busy? Laszlo Nagy
- Re: Problems with autovacuum Alvaro Herrera
- Re: Problems with autovacuum Tom Lane
- Re: Pointers needed on optimizing slow SQL statements Віталій Тимчишин
- Re: Pointers needed on optimizing slow SQL statements Dimitri Fontaine
- Re: Best way to load test a postgresql server Shaul Dar
- Re: Best way to load test a postgresql server Tom Lane
- Re: Problems with autovacuum Alvaro Herrera
- Re: Problems with autovacuum Alvaro Herrera
- Re: Problems with autovacuum Tom Lane
- Looking for installations with a large number of concurrent users David Kerr
- Re: Why is my stats collector so busy? Laszlo Nagy
- Re: Hosted servers with good DB disk performance? Markus Wanner
- Re: GiST index performance Matthew Wakeling
- Censorship Matthew Wakeling
- Re: Censorship Guillaume Cottenceau
- Re: Censorship Matthew Wakeling
- Re: Censorship Gurjeet Singh
- Re: Censorship Matthew Wakeling
- Re: Censorship Scott Mead
- Re: Censorship Matthew Wakeling
- Re: Censorship Tom Lane
- Explaining an EXPLAIN. Matthew Wakeling
- EXPLAIN understanding? (restarted from Censorship) Richard Huxton
- Re: EXPLAIN understanding? (restarted from Censorship) Richard Huxton
- Re: Explaining an EXPLAIN. Tom Lane
- Re: Explaining an EXPLAIN. Matthew Wakeling
- Re: Looking for installations with a large number of concurrent users Kevin Grittner
- Re: GiST index performance Tom Lane
- Re: Why is my stats collector so busy? Tom Lane
- Re: Looking for installations with a large number of concurrent users David Kerr
- Re: Hosted servers with good DB disk performance? Dimitri Fontaine
- Re: GiST index performance Matthew Wakeling
- Postgres replication: dump/restore, PITR, Slony,...? Shaul Dar
- Re: GiST index performance Tom Lane
- Re: Postgres replication: dump/restore, PITR, Slony,...? Dimitri Fontaine
- Re: GiST index performance Matthew Wakeling
- Re: GiST index performance Tom Lane
- Re: Postgres replication: dump/restore, PITR, Slony,...? Joshua D. Drake
- Re: Postgres replication: dump/restore, PITR, Slony,...? Greg Sabino Mullane
- Re: Postgres replication: dump/restore, PITR, Slony,...? Joshua D. Drake
- Re: GiST index performance Matthew Wakeling
- Re: GiST index performance Matthew Wakeling
- Re: GiST index performance Matthew Wakeling
- Re: GiST index performance Tom Lane
- Re: Best way to load test a postgresql server Erik Aronesty
- Re: Postgres replication: dump/restore, PITR, Slony,...? Shaul Dar
- Re: GiST index performance Adam Gundy
- Re: Postgres replication: dump/restore, PITR, Slony,...? Greg Sabino Mullane
- what server stats to track / monitor ? Alan McKay
- Re: what server stats to track / monitor ? Joshua Tolley
- Re: what server stats to track / monitor ? Alan McKay
- Re: what server stats to track / monitor ? Alan McKay
- Re: what server stats to track / monitor ? Rauan Maemirov
- Re: what server stats to track / monitor ? Joshua Tolley
- Re: Censorship Dan Langille
- Postgres connection status as BIND Nimesh Satam
- Re: Postgres connection status as BIND Tom Lane
- Re: Postgres connection status as BIND Alan Hodgson
- Yet another slow nested loop Alexander Staubo
- performance with query Alberto Dalmaso
- Re: Yet another slow nested loop Dave Dutcher
- Re: Yet another slow nested loop Alexander Staubo
- Re: performance with query Joshua Tolley
- Re: performance with query Kevin Grittner
- Re: Yet another slow nested loop Tom Lane
- Re: performance with query Alberto Dalmaso
- Re: performance with query Matthew Wakeling
- Re: performance with query Kevin Grittner
- Re: performance with query Alberto Dalmaso
- Re: Yet another slow nested loop Alexander Staubo
- Re: performance with query Tom Lane
- Re: performance with query Kevin Grittner
- Re: performance with query Alberto Dalmaso
- Re: performance with query Kevin Grittner
- Re: performance with query Alberto Dalmaso
- Re: performance with query Kevin Grittner
- Re: performance with query Tom Lane
- Re: performance with query Alberto Dalmaso
- Re: performance with query Alberto Dalmaso
- Speeding up a query. Hartman, Matthew
- Re: Speeding up a query. Anthony Presley
- Performance discrepancy Mark Steben
- High cost of ... where ... not in (select ...) Aaron Turner
- Re: High cost of ... where ... not in (select ...) Alvaro Herrera
- Re: High cost of ... where ... not in (select ...) Aaron Turner
- Re: High cost of ... where ... not in (select ...) Robert Haas
- Re: High cost of ... where ... not in (select ...) Aaron Turner
- Re: High cost of ... where ... not in (select ...) Robert Haas
- Re: High cost of ... where ... not in (select ...) Aaron Turner
- Re: High cost of ... where ... not in (select ...) Aaron Turner
- Index Scan taking long time Bryce Ewing
- Re: High cost of ... where ... not in (select ...) Tom Lane
- Re: Yet another slow nested loop Robert Haas
- Re: Index Scan taking long time Scott Marlowe
- 8.4 COPY performance regression on Solaris Alan Li
- Re: performance with query Alberto Dalmaso
- Re: performance with query (OT) Albe Laurenz
- Re: Speeding up a query. Albe Laurenz
- Re: 8.4 COPY performance regression on Solaris Stefan Kaltenbrunner
- Re: Speeding up a query. Grzegorz Jaśkiewicz
- Re: Speeding up a query. Alberto Dalmaso
- Re: GiST index performance Heikki Linnakangas
- Re: Speeding up a query. Merlin Moncure
- Re: Index Scan taking long time Tom Lane
- Re: performance with query Kevin Grittner
- Re: Speeding up a query. Kevin Grittner
- Re: Speeding up a query. Hartman, Matthew
- Re: Speeding up a query. Hartman, Matthew
- Re: Speeding up a query. Tom Lane
- Re: performance with query Alberto Dalmaso
- Re: Speeding up a query. Hartman, Matthew
- Re: performance with query Kevin Grittner
- Performance issue - 2 linux machines, identical configs, different performance Mark Steben
- Re: Performance issue - 2 linux machines, identical configs, different performance Robert Haas
- Re: Performance issue - 2 linux machines, identical configs, different performance Dave Dutcher
- Re: Performance issue - 2 linux machines, identical configs, different performance Mark Steben
- very slow selects on a small table Brian Cox
- Re: Index Scan taking long time Bryce Ewing
- enum for performance? Whit Armstrong
- Re: enum for performance? Tom Lane
- Re: very slow selects on a small table Tom Lane
- Re: Index Scan taking long time Tom Lane
- Re: very slow selects on a small table Brian Cox
- Re: very slow selects on a small table Tom Lane
- Re: very slow selects on a small table Brian Cox
- Re: very slow selects on a small table Tom Lane
- Re: very slow selects on a small table Brian Cox
- Re: very slow selects on a small table Tom Lane
- Re: very slow selects on a small table Brian Cox
- Re: very slow selects on a small table Tom Lane
- Re: performance with query Alberto Dalmaso
- Re: enum for performance? Merlin Moncure
- Re: very slow selects on a small table Brian Cox
- Re: very slow selects on a small table Grzegorz Jaśkiewicz
- Re: very slow selects on a small table Brian Cox
- Re: very slow selects on a small table Grzegorz Jaśkiewicz
- Re: very slow selects on a small table Tom Lane
- Strange performance response for high load times Peter Alban
- Re: Strange performance response for high load times Kenneth Marshall
- Re: performance with query Kevin Grittner
- Re: performance with query Tom Lane
- Re: Strange performance response for high load times Peter Alban
- Re: performance with query Kevin Grittner
- Re: Strange performance response for high load times Kenneth Marshall
- Re: Strange performance response for high load times Peter Alban
- Re: Strange performance response for high load times Kevin Grittner
- Re: Index Scan taking long time Bryce Ewing
- select max() much slower than select min() Brian Cox
- Re: select max() much slower than select min() Kevin Grittner
- Re: select max() much slower than select min() Brian Cox
- Re: select max() much slower than select min() Kevin Grittner
- Re: 8.4 COPY performance regression on Solaris Kenneth Marshall
- Re: select max() much slower than select min() Dave Dutcher
- Re: select max() much slower than select min() Tom Lane
- Re: 8.4 COPY performance regression on Solaris Tom Lane
- Re: select max() much slower than select min() Greg Stark
- processor running queue - general rule of thumb? Alan McKay
- Re: processor running queue - general rule of thumb? justin
- Re: processor running queue - general rule of thumb? Scott Marlowe
- Re: processor running queue - general rule of thumb? Alan McKay
- Re: select max() much slower than select min() Brian Cox
- Re: select max() much slower than select min() David Rees
- Re: select max() much slower than select min() Brian Cox
- Re: select max() much slower than select min() David Rees
- same query in high number of times Peter Alban
- Re: same query in high number of times Justin Graf
- Re: same query in high number of times Robert Haas
- Re: same query in high number of times Peter Alban
- Re: same query in high number of times Justin Graf
- Re: same query in high number of times Grzegorz Jaśkiewicz
- Re: same query in high number of times Justin Graf
- Re: same query in high number of times Peter Alban
- Re: same query in high number of times Scott Marlowe
- Re: same query in high number of times Justin Graf
- Re: same query in high number of times Robert Haas
- Re: same query in high number of times Peter Alban
- Re: same query in high number of times Scott Carey
- Re: same query in high number of times Laurent Laborde
- Re: same query in high number of times Laurent Laborde
- How would you store read/unread topic status? Mathieu Nebra
- Re: How would you store read/unread topic status? Andres Freund
- Re: How would you store read/unread topic status? Alexander Staubo
- Re: How would you store read/unread topic status? Andres Freund
- Re: How would you store read/unread topic status? justin
- Re: How would you store read/unread topic status? Nikolas Everett
- Re: How would you store read/unread topic status? Matthew Wakeling
- Re: How would you store read/unread topic status? Mathieu Nebra
- Re: How would you store read/unread topic status? Mathieu Nebra
- Re: How would you store read/unread topic status? Robert Haas
- Re: How would you store read/unread topic status? Guillaume Cottenceau
- Re: How would you store read/unread topic status? Andres Freund
- Re: How would you store read/unread topic status? Robert Haas
- Re: How would you store read/unread topic status? Grzegorz Jaśkiewicz
- Re: How would you store read/unread topic status? Mathieu Nebra
- Re: How would you store read/unread topic status? Robert Haas
- Re: How would you store read/unread topic status? Mike
- Re: How would you store read/unread topic status? Mike
- Re: How would you store read/unread topic status? Scott Carey
- Re: How would you store read/unread topic status? Scott Carey
- Re: How would you store read/unread topic status? Greg Stark
- Implications of having large number of users Mike Ivanov
- Re: How would you store read/unread topic status? Mathieu Nebra
- Re: How would you store read/unread topic status? Alexander Staubo
- Re: processor running queue - general rule of thumb? Alan McKay
- Re: How would you store read/unread topic status? Craig James
- SOLVED: processor running queue - general rule of thumb? Alan McKay
- Re: How would you store read/unread topic status? Greg Stark
- Re: How would you store read/unread topic status? Chris St Denis
- tsvector_update_trigger performance? Chris St Denis
- Re: tsvector_update_trigger performance? Oleg Bartunov
- Re: How would you store read/unread topic status? Mathieu Nebra
- Re: How would you store read/unread topic status? Mathieu Nebra
- Re: Implications of having large number of users Albe Laurenz
- Re: Implications of having large number of users Robert Haas
- Nested Loop "Killer" on 8.1 Dave North
- Re: Implications of having large number of users Albe Laurenz
- Re: Implications of having large number of users Tom Lane
- Re: Implications of having large number of users Robert Haas
- Re: tsvector_update_trigger performance? Alvaro Herrera
- cluster index on a table Ibrahim Harrani
- Re: cluster index on a table Kenneth Marshall
- Re: cluster index on a table Scott Marlowe
- Re: tsvector_update_trigger performance? Dimitri Fontaine
- Re: tsvector_update_trigger performance? Chris St Denis
- Re: tsvector_update_trigger performance? Craig Ringer
- Re: tsvector_update_trigger performance? Dimitri Fontaine
- Re: Implications of having large number of users Mike Ivanov
- Re: Nested Loop "Killer" on 8.1 Josh Berkus
- Re: Nested Loop "Killer" on 8.1 Greg Stark
- Re: Nested Loop "Killer" on 8.1 Mark Mielke
- Re: Nested Loop "Killer" on 8.1 Tom Lane
- Re: Nested Loop "Killer" on 8.1 Greg Stark
- slow DELETE on 12 M row table Janet Jacobsen
- Re: slow DELETE on 12 M row table Greg Stark
- Re: slow DELETE on 12 M row table Richard Huxton
- Re: slow DELETE on 12 M row table Janet Jacobsen
- Re: slow DELETE on 12 M row table Marcin Stępnicki
- Re: GiST index performance Greg Smith
- Re: GiST index performance Robert Haas
- Insert performance and multi-column index order bob_lunney@yahoo.com
- Re: Nested Loop "Killer" on 8.1 Dave North
- Terrible Write Performance of a Stored Procedure Brian Troutwine
- Re: Terrible Write Performance of a Stored Procedure Alan Hodgson
- Re: Terrible Write Performance of a Stored Procedure Merlin Moncure
- Re: Terrible Write Performance of a Stored Procedure Brian Troutwine
- Re: Terrible Write Performance of a Stored Procedure Brian Troutwine
- Re: Terrible Write Performance of a Stored Procedure Scott Mead
- Re: Nested Loop "Killer" on 8.1 Tom Lane
- Re: Terrible Write Performance of a Stored Procedure Greg Smith
- Re: Insert performance and multi-column index order Tom Lane
- Re: slow DELETE on 12 M row table Janet Jacobsen
- Re: slow DELETE on 12 M row table Robert Haas
- Re: what server stats to track / monitor ? Greg Smith
- Re: Insert performance and multi-column index order Greg Smith
- Re: slow DELETE on 12 M row table Scott Carey
- Re: slow DELETE on 12 M row table Robert Haas
- Re: what server stats to track / monitor ? Alan McKay
- Re: Terrible Write Performance of a Stored Procedure Scott Mead
- random slow query Sean Ma
- Re: random slow query Andres Freund
- Utilizing multiple cores in a function call. Hartman, Matthew
- Re: Utilizing multiple cores in a function call. Jean-David Beyer
- Re: random slow query Kevin Grittner
- Re: Utilizing multiple cores in a function call. Hartman, Matthew
- Re: Utilizing multiple cores in a function call. Joe Conway
- Re: Utilizing multiple cores in a function call. Greg Smith
- Re: Utilizing multiple cores in a function call. Merlin Moncure
- Re: random slow query Mike Ivanov
- Re: Utilizing multiple cores in a function call. Craig Ringer
- Re: Terrible Write Performance of a Stored Procedure valgog
- Re: Insert performance and multi-column index order Bob Lunney
- Re: Utilizing multiple cores in a function call. Hartman, Matthew
- Re: Utilizing multiple cores in a function call. Merlin Moncure
- Re: Utilizing multiple cores in a function call. Hartman, Matthew
- Re: random slow query Sean Ma
- Re: random slow query Mike Ivanov
- Re: random slow query Scott Marlowe
- Re: random slow query Sean Ma
- Re: random slow query Scott Marlowe
- Re: random slow query Mike Ivanov
- Re: random slow query Mike Ivanov
- Re: random slow query Scott Marlowe
- Re: random slow query Mike Ivanov
- Re: random slow query Scott Marlowe
- Re: random slow query Scott Marlowe
- Re: random slow query Alan Hodgson
- Re: random slow query Mike Ivanov
- Re: random slow query Jean-David Beyer
- Re: random slow query Mike Ivanov
- Re: random slow query Scott Carey
- Re: random slow query Scott Carey
- Re: random slow query Scott Carey
- Re: random slow query Mike Ivanov