Mailing lists [pgsql-performance]
- Re: Question about subselect/IN performance bricklen
- Re: SELECT INTO large FKyed table is slow Joshua D. Drake
- Re: BBU Cache vs. spindles Bruce Momjian
- Re: BBU Cache vs. spindles Bruce Momjian
- Re: BBU Cache vs. spindles Bruce Momjian
- Re: SELECT INTO large FKyed table is slow Mario Splivalo
- Re: SELECT INTO large FKyed table is slow Mario Splivalo
- Re: BBU Cache vs. spindles Pierre C
- Re: SELECT INTO large FKyed table is slow Pierre C
- Re: SELECT INTO large FKyed table is slow Pierre C
- Re: tidscan not work ? Pg 8.4.5 + WinXP pasman pasmański
- Re: BBU Cache vs. spindles Bruce Momjian
- Re: SELECT INTO large FKyed table is slow Mladen Gogala
- Clarification, please Mladen Gogala
- Re: Clarification, please Richard Broersma
- Re: SELECT INTO large FKyed table is slow Mario Splivalo
- Re: Clarification, please Mladen Gogala
- Re: Clarification, please Kevin Grittner
- Re: SELECT INTO large FKyed table is slow Mladen Gogala
- Re: SELECT INTO large FKyed table is slow Kenneth Marshall
- Re: SELECT INTO large FKyed table is slow Kevin Grittner
- Re: SELECT INTO large FKyed table is slow Mladen Gogala
- Re: SELECT INTO large FKyed table is slow Mladen Gogala
- Re: SELECT INTO large FKyed table is slow Pierre C
- Re: SELECT INTO large FKyed table is slow Mario Splivalo
- Re: SELECT INTO large FKyed table is slow Mario Splivalo
- Re: SELECT INTO large FKyed table is slow Kevin Grittner
- Multicore Postgres 9.0.1 issue - single transaction problem. Piotr Czekalski
- Re: Multicore Postgres 9.0.1 issue - single transaction problem. Scott Marlowe
- PostBIX to monitor postgresql performaces Andrea Dalle Vacche
- Re: executor stats / page reclaims Robert Haas
- Re: CPUs for new databases Scott Carey
- Re: problem with from_collapse_limit and joined views Kevin Grittner
- Query-plan for partitioned UPDATE/DELETE slow and swaps vmem compared to SELECT John Papandriopoulos
- Re: Query-plan for partitioned UPDATE/DELETE slow and swaps vmem compared to SELECT Tom Lane
- Re: Query-plan for partitioned UPDATE/DELETE slow and swaps vmem compared to SELECT John Papandriopoulos
- Re: problem with from_collapse_limit and joined views Markus Schulz
- Slow query to get last created row using CURRVAL Mathieu De Zutter
- Re: Slow query to get last created row using CURRVAL Marti Raudsepp
- Re: Slow query to get last created row using CURRVAL Mathieu De Zutter
- Re: problem with from_collapse_limit and joined views Kevin Grittner
- Re: Slow query to get last created row using CURRVAL Віталій Тимчишин
- Re: Query-plan for partitioned UPDATE/DELETE slow and swaps vmem compared to SELECT Tom Lane
- Re: problem with from_collapse_limit and joined views Tom Lane
- Re: problem with from_collapse_limit and joined views Markus Schulz
- Re: problem with from_collapse_limit and joined views Markus Schulz
- Re: Update problem on large table felix
- Re: Query-plan for partitioned UPDATE/DELETE slow and swaps vmem compared to SELECT John Papandriopoulos
- Re: Query-plan for partitioned UPDATE/DELETE slow and swaps vmem compared to SELECT Mladen Gogala
- Re: Query-plan for partitioned UPDATE/DELETE slow and swaps vmem compared to SELECT Tom Lane
- Re: Query-plan for partitioned UPDATE/DELETE slow and swaps vmem compared to SELECT Mladen Gogala
- Re: Query-plan for partitioned UPDATE/DELETE slow and swaps vmem compared to SELECT Jochen Erwied
- Re: Query-plan for partitioned UPDATE/DELETE slow and swaps vmem compared to SELECT John Papandriopoulos
- Re: Query-plan for partitioned UPDATE/DELETE slow and swaps vmem compared to SELECT John Papandriopoulos
- Re: Query-plan for partitioned UPDATE/DELETE slow and swaps vmem compared to SELECT John Papandriopoulos
- Re: Query-plan for partitioned UPDATE/DELETE slow and swaps vmem compared to SELECT Tom Lane
- Re: Query-plan for partitioned UPDATE/DELETE slow and swaps vmem compared to SELECT Tom Lane
- Group commit and commit delay/siblings Rob Wultsch
- Re: Group commit and commit delay/siblings Jignesh Shah
- Re: Group commit and commit delay/siblings Rob Wultsch
- Re: Group commit and commit delay/siblings Jignesh Shah
- Re: Group commit and commit delay/siblings Greg Smith
- Re: Query-plan for partitioned UPDATE/DELETE slow and swaps vmem compared to SELECT John Papandriopoulos
- Re: Group commit and commit delay/siblings Jignesh Shah
- Strange optimization - xmin,xmax compression :) pasman pasmański
- Re: Performance under contention Robert Haas
- Re: Group commit and commit delay/siblings Tom Lane
- Re: Query-plan for partitioned UPDATE/DELETE slow and swaps vmem compared to SELECT Tom Lane
- Re: Performance under contention Robert Haas
- Re: Update problem on large table bricklen
- Re: Update problem on large table Jon Nelson
- Re: Update problem on large table Josh Kupershmidt
- Re: Update problem on large table Kenneth Marshall
- Re: Update problem on large table felix
- Re: Query-plan for partitioned UPDATE/DELETE slow and swaps vmem compared to SELECT John Papandriopoulos
- Re: Performance under contention Jignesh Shah
- Re: Performance under contention Jignesh Shah
- Re: Group commit and commit delay/siblings Jignesh Shah
- Re: Group commit and commit delay/siblings Greg Smith
- Slow BLOBs restoring Vlad Arkhipov
- Re: Performance under contention Robert Haas
- Re: Performance under contention Tom Lane
- Re: Performance under contention Dave Crooke
- Compared MS SQL 2000 to Postgresql 9.0 on Windows Tom Polak
- Re: Performance under contention Ivan Voras
- Re: Performance under contention Robert Haas
- Re: Performance under contention Robert Haas
- Re: Compared MS SQL 2000 to Postgresql 9.0 on Windows Kevin Grittner
- Re: Compared MS SQL 2000 to Postgresql 9.0 on Windows Andy Colson
- Re: Compared MS SQL 2000 to Postgresql 9.0 on Windows Andres Freund
- Re: Performance under contention Ivan Voras
- Re: Compared MS SQL 2000 to Postgresql 9.0 on Windows Craig James
- Re: Compared MS SQL 2000 to Postgresql 9.0 on Windows Andy Colson
- Re: Compared MS SQL 2000 to Postgresql 9.0 on Windows Richard Broersma
- Re: Compared MS SQL 2000 to Postgresql 9.0 on Windows Kenneth Marshall
- Re: Compared MS SQL 2000 to Postgresql 9.0 on Windows Gary Doades
- Re: Compared MS SQL 2000 to Postgresql 9.0 on Windows Mladen Gogala
- Re: Compared MS SQL 2000 to Postgresql 9.0 on Windows Andy Colson
- Re: Compared MS SQL 2000 to Postgresql 9.0 on Windows Tom Polak
- Re: Performance under contention Віталій Тимчишин
- Re: Compared MS SQL 2000 to Postgresql 9.0 on Windows Craig James
- Re: Compared MS SQL 2000 to Postgresql 9.0 on Windows Gary Doades
- Re: Update problem on large table Josh Kupershmidt
- Re: Compared MS SQL 2000 to Postgresql 9.0 on Windows Kevin Grittner
- Re: Performance under contention Ivan Voras
- Re: Performance under contention Robert Haas
- Re: Performance under contention Robert Haas
- Re: Slow BLOBs restoring Vlad Arkhipov
- Re: Performance under contention Tom Lane
- Re: Slow BLOBs restoring Tom Lane
- hashed subplan 5000x slower than two sequential operations Bryce Nesbitt
- Re: Group commit and commit delay/siblings Simon Riggs
- Re: hashed subplan 5000x slower than two sequential operations Shrirang Chitnis
- Re: hashed subplan 5000x slower than two sequential operations Bryce Nesbitt
- Re: hashed subplan 5000x slower than two sequential operations Marc Mamin
- Re: hashed subplan 5000x slower than two sequential operations Tom Lane
- Re: hashed subplan 5000x slower than two sequential operations Marc Mamin
- Re: hashed subplan 5000x slower than two sequential operations Pavel Stehule
- Re: hashed subplan 5000x slower than two sequential operations Bryce Nesbitt
- Re: hashed subplan 5000x slower than two sequential operations Bryce Nesbitt
- Re: Performance under contention Robert Haas
- Re: Performance under contention Tom Lane
- Hardware recommendations Benjamin Krajmalnik
- Re: Hardware recommendations Andy
- Re: Compared MS SQL 2000 to Postgresql 9.0 on Windows Pierre C
- Re: Hardware recommendations alaricd@pengdows.com
- Re: Hardware recommendations Benjamin Krajmalnik
- Re: Hardware recommendations John W Strange
- Re: Hardware recommendations Marti Raudsepp
- Re: Hardware recommendations alaricd@pengdows.com
- Re: Hardware recommendations Andy
- Re: Hardware recommendations alaricd@pengdows.com
- Re: Hardware recommendations alaricd@pengdows.com
- Re: Hardware recommendations alaricd@pengdows.com
- Re: Hardware recommendations alaricd@pengdows.com
- Re: Performance under contention Robert Haas
- Re: Hardware recommendations Scott Marlowe
- Re: Slow BLOBs restoring Vlad Arkhipov
- Re: Slow BLOBs restoring Vlad Arkhipov
- libpq vs ODBC Divakar Singh
- Re: libpq vs ODBC Alex Goncharov
- Re: libpq vs ODBC Divakar Singh
- Re: Hardware recommendations mark
- Re: Slow BLOBs restoring Tom Lane
- Re: libpq vs ODBC Alex Goncharov
- Re: libpq vs ODBC Divakar Singh
- Re: libpq vs ODBC Pavel Stehule
- Re: Hardware recommendations Marti Raudsepp
- Re: Hardware recommendations John W Strange
- Re: libpq vs ODBC Pierre C
- Re: Hardware recommendations alan bryan
- Re: Hardware recommendations Andy
- Re: Hardware recommendations Arjen van der Meijden
- Re: Hardware recommendations Arjen van der Meijden
- Re: Hardware recommendations Scott Marlowe
- Re: Hardware recommendations Andy
- Re: Hardware recommendations Greg Smith
- Re: Hardware recommendations Greg Smith
- Tunning Postgres salima
- UNION and bad performance Olivier Pala
- Re: UNION and bad performance Marc Mamin
- Re: UNION and bad performance Andreas Kretschmer
- Re: UNION and bad performance pasman pasmański
- Re: SELECT INTO large FKyed table is slow Robert Haas
- CPU bound Royce Ausburn
- Re: CPU bound Craig Ringer
- Re: CPU bound Josh Berkus
- Re: Hardware recommendations Benjamin Krajmalnik
- Re: Tunning Postgres Robert Haas
- Re: Hardware recommendations mark
- Re: Tunning Postgres Grzegorz Jaśkiewicz
- Re: Help with bulk read performance Jim Nasby
- Re: CPU bound Royce Ausburn
- Index Bloat - how to tell? John W Strange
- Re: Index Bloat - how to tell? Plugge, Joe R.
- Re: Help with bulk read performance Andy Colson
- Re: Help with bulk read performance Jim Nasby
- Re: Help with bulk read performance Andy Colson
- Re: Index Bloat - how to tell? Mladen Gogala
- Re: Help with bulk read performance Jim Nasby
- Re: Help with bulk read performance Nick Matheson
- Re: Index Bloat - how to tell? Dave Crooke
- Re: Index Bloat - how to tell? Mark Kirkwood
- only one index is using, why? AI Rumman
- Re: only one index is using, why? Marti Raudsepp
- Problems with FTS Rauan Maemirov
- performance libpq vs JDBC Werner Scholtes
- Re: Help with bulk read performance Dan Schaffer
- Re: performance libpq vs JDBC Divakar Singh
- Re: performance libpq vs JDBC Werner Scholtes
- Re: performance libpq vs JDBC Divakar Singh
- Re: performance libpq vs JDBC Werner Scholtes
- Re: performance libpq vs JDBC Divakar Singh
- Re: performance libpq vs JDBC Richard Huxton
- How to get FK to use new index without restarting the database Eric Comeau
- Re: performance libpq vs JDBC Werner Scholtes
- Re: How to get FK to use new index without restarting the database Jayadevan M
- Re: performance libpq vs JDBC Richard Huxton
- Re: How to get FK to use new index without restarting the database Richard Huxton
- Re: How to get FK to use new index without restarting the database Eric Comeau
- Re: Help with bulk read performance Krzysztof Nienartowicz
- Re: performance libpq vs JDBC Merlin Moncure
- Re: Help with bulk read performance Pierre C
- Re: How to get FK to use new index without restarting the database Tom Lane
- Re: Index Bloat - how to tell? Mladen Gogala
- Re: How to get FK to use new index without restarting the database Eric Comeau
- postgres performance tunning selvi88
- Re: How to get FK to use new index without restarting the database Eric Comeau
- Auto-clustering? Royce Ausburn
- Re: Auto-clustering? Filip Rembiałkowski
- Re: Auto-clustering? Marti Raudsepp
- Re: postgres performance tunning Pierre C
- Re: Auto-clustering? Filip Rembiałkowski
- Re: Auto-clustering? Pierre C
- Re: postgres performance tunning Greg Smith
- Re: Help with bulk read performance Nick Matheson
- Re: postgres performance tunning Marti Raudsepp
- Re: Auto-clustering? phb07
- Re: Compared MS SQL 2000 to Postgresql 9.0 on Windows Tom Polak
- Re: Compared MS SQL 2000 to Postgresql 9.0 on Windows Craig James
- Re: Compared MS SQL 2000 to Postgresql 9.0 on Windows Richard Broersma
- Re: Compared MS SQL 2000 to Postgresql 9.0 on Windows Rob Wultsch
- Re: Compared MS SQL 2000 to Postgresql 9.0 on Windows Robert Haas
- Re: Compared MS SQL 2000 to Postgresql 9.0 on Windows Andy Colson
- Re: Compared MS SQL 2000 to Postgresql 9.0 on Windows Andy Colson
- Re: Compared MS SQL 2000 to Postgresql 9.0 on Windows Tom Polak
- Re: postgres performance tunning Merlin Moncure
- Re: Compared MS SQL 2000 to Postgresql 9.0 on Windows Robert Haas
- Re: Compared MS SQL 2000 to Postgresql 9.0 on Windows Scott Marlowe
- Re: Index Bloat - how to tell? Robert Haas
- Re: Strange optimization - xmin,xmax compression :) Robert Haas
- Re: Index Bloat - how to tell? Mladen Gogala
- Re: Compared MS SQL 2000 to Postgresql 9.0 on Windows Gael Le Mignot
- Re: Compared MS SQL 2000 to Postgresql 9.0 on Windows Scott Marlowe
- Re: Compared MS SQL 2000 to Postgresql 9.0 on Windows Pierre C
- Re: Compared MS SQL 2000 to Postgresql 9.0 on Windows Kevin Grittner
- Re: Problems with FTS Kevin Grittner
- PostgreSQL 9.0 x64 bit pgbench TPC very low question? tuanhoanganh
- Re: PostgreSQL 9.0 x64 bit pgbench TPC very low question? Kevin Grittner
- Re: PostgreSQL 9.0 x64 bit pgbench TPC very low question? Jeff Janes
- Re: PostgreSQL 9.0 x64 bit pgbench TPC very low question? tuanhoanganh
- Re: PostgreSQL 9.0 x64 bit pgbench TPC very low question? tuanhoanganh
- Re: PostgreSQL 9.0 x64 bit pgbench TPC very low question? tuanhoanganh
- Re: PostgreSQL 9.0 x64 bit pgbench TPC very low question? Jeff Janes
- Re: PostgreSQL 9.0 x64 bit pgbench TPC very low question? Ivan Voras
- Re: Auto-clustering? Royce Ausburn
- Re: Auto-clustering? Royce Ausburn
- Re: postgres performance tunning selvi88
- Re: Compared MS SQL 2000 to Postgresql 9.0 on Windows Justin Pitts
- Re: postgres performance tunning selvi88
- Re: Strange optimization - xmin,xmax compression :) Jim Nasby
- Re: CPU bound James Cloos
- Re: CPU bound Mladen Gogala
- Re: PostgreSQL 9.0 x64 bit pgbench TPC very low question? tuanhoanganh
- Re: PostgreSQL 9.0 x64 bit pgbench TPC very low question? Scott Marlowe
- Re: PostgreSQL 9.0 x64 bit pgbench TPC very low question? Scott Marlowe
- Re: CPU bound James Cloos
- Re: CPU bound Kenneth Marshall
- Re: postgres performance tunning Fernando Hevia
- Re: postgres performance tunning Scott Marlowe
- Re: postgres performance tunning Greg Smith
- Re: CPU bound Jeremy Harris
- Re: postgres performance tunning Scott Marlowe
- Re: UNION and bad performance Robert Haas
- Re: PostgreSQL 9.0 x64 bit pgbench TPC very low question? tuanhoanganh
- Re: PostgreSQL 9.0 x64 bit pgbench TPC very low question? Scott Marlowe
- Re: PostgreSQL 9.0 x64 bit pgbench TPC very low question? Magnus Hagander
- MySQL HandlerSocket - Is this possible in PG? Michael Ben-Nes
- Re: MySQL HandlerSocket - Is this possible in PG? Pavel Stehule
- Re: CPU bound Mladen Gogala
- Query uses incorrect index pasman pasmański
- Re: Query uses incorrect index Kevin Grittner
- Re: MySQL HandlerSocket - Is this possible in PG? Pavel Stehule
- Performance of PostgreSQL over NFS Mladen Gogala
- Re: Performance of PostgreSQL over NFS Rich
- Re: MySQL HandlerSocket - Is this possible in PG? Merlin Moncure
- Re: Performance of PostgreSQL over NFS Mladen Gogala
- Re: MySQL HandlerSocket - Is this possible in PG? Michael Ben-Nes
- Re: MySQL HandlerSocket - Is this possible in PG? Pierre C
- Re: MySQL HandlerSocket - Is this possible in PG? Scott Marlowe
- Re: Query uses incorrect index pasman pasmański
- Re: Query uses incorrect index Guillaume Cottenceau
- Re: MySQL HandlerSocket - Is this possible in PG? Marti Raudsepp
- Re: PostgreSQL 9.0 x64 bit pgbench TPC very low question? tuanhoanganh
- Re: PostgreSQL 9.0 x64 bit pgbench TPC very low question? Gurjeet Singh
- Re: Query uses incorrect index Kevin Grittner
- Re: Query uses incorrect index Tom Lane
- Re: Query uses incorrect index pasman pasmański
- Re: MySQL HandlerSocket - Is this possible in PG? Pierre C
- Re: MySQL HandlerSocket - Is this possible in PG? Michael Ben-Nes
- Re: BBU Cache vs. spindles Bruce Momjian
- Re: PostgreSQL 9.0 x64 bit pgbench TPC very low question? tuanhoanganh
- Re: PostgreSQL 9.0 x64 bit pgbench TPC very low question? Kevin Grittner
- Re: PostgreSQL 9.0 x64 bit pgbench TPC very low question? Kenneth Marshall
- Re: PostgreSQL 9.0 x64 bit pgbench TPC very low question? tuanhoanganh
- Re: PostgreSQL 9.0 x64 bit pgbench TPC very low question? Jeff Janes
- Create index on subfield returned by function that returns base type with sub fields Desmond Coertzen
- Re: Create index on subfield returned by function that returns base type with sub fields Andres Freund
- concurrent IO in postgres? Przemek Wozniak
- Re: concurrent IO in postgres? Scott Marlowe
- Re: concurrent IO in postgres? John W Strange
- Re: concurrent IO in postgres? Kevin Grittner
- Re: concurrent IO in postgres? Przemek Wozniak
- Re: concurrent IO in postgres? Andy
- encourging bitmap AND Ben
- Re: encourging bitmap AND Tom Lane
- Re: encourging bitmap AND Ben
- Re: concurrent IO in postgres? Ben Chobot
- Re: concurrent IO in postgres? John Cagle
- Re: concurrent IO in postgres? Josh Berkus
- Re: concurrent IO in postgres? Pierre C
- Re: concurrent IO in postgres? Jeff Janes
- Re: concurrent IO in postgres? Mladen Gogala
- Re: encourging bitmap AND Marti Raudsepp
- Index on function that returns type with sub fields Desmond Coertzen
- Re: concurrent IO in postgres? Jeff Janes
- Re: encourging bitmap AND Tom Lane
- How to turn autovacuum prevent wrap around run faster? marc.hsiao
- Re: How to turn autovacuum prevent wrap around run faster? Scott Marlowe
- adding foreign key constraint locks up table kakarukeys
- Re: adding foreign key constraint locks up table Gurjeet Singh
- Re: adding foreign key constraint locks up table Kevin Grittner
- Re: adding foreign key constraint locks up table Lew
- Re: adding foreign key constraint locks up table kakarukeys
- Re: adding foreign key constraint locks up table Florian Weimer
- Re: adding foreign key constraint locks up table Gurjeet Singh
- Re: adding foreign key constraint locks up table Gurjeet Singh
- Re: adding foreign key constraint locks up table Kevin Grittner
- Re: adding foreign key constraint locks up table Tom Lane
- Re: Regression: 8.3 2 seconds -> 8.4 100+ seconds Greg Smith
- long wait times in ProcessCatchupEvent() bock@openit.de (Julian v. Bock)
- Re: long wait times in ProcessCatchupEvent() Tom Lane
- Re: long wait times in ProcessCatchupEvent() Craig James
- Re: long wait times in ProcessCatchupEvent() Tom Lane
- Re: long wait times in ProcessCatchupEvent() Craig James
- Re: long wait times in ProcessCatchupEvent() Mladen Gogala
- PostgreSQL nextage Tech
- Re: long wait times in ProcessCatchupEvent() Kevin Grittner
- Re: long wait times in ProcessCatchupEvent() bock@openit.de (Julian v. Bock)
- Re: PostgreSQL Lew