Mailing lists [pgsql-performance]
- Re: views? Richard Huxton
- "Overlaping" indexes Rigmor Ukuhe
- Re: "Overlaping" indexes Tomasz Myrta
- MySQL+InnoDB vs. PostgreSQL test? Josh Berkus
- Mainframe Linux + PostgreSQL Josh Berkus
- Re: "Overlaping" indexes scott.marlowe
- Re: "Overlaping" indexes Tomasz Myrta
- Re: "Overlaping" indexes scott.marlowe
- Re: "Overlaping" indexes Rod Taylor
- Increasing number of PG connections. Kevin Barnard
- pg_stat_activity Orion Henry
- Re: Increasing number of PG connections. Qing Zhao
- Re: [pgsql-advocacy] MySQL+InnoDB vs. PostgreSQL test? Robert Treat
- Re: [pgsql-advocacy] MySQL+InnoDB vs. PostgreSQL test? Adam Ruth
- inserting large number of rows was: Re: Increasing number of PG connections. scott.marlowe
- Bulk Record upload (was Re: Increasing number of PG connections) Richard Huxton
- Re: inserting large number of rows was: Re: Increasing Bill Moran
- Re: Increasing number of PG connections. scott.marlowe
- Re: Increasing number of PG connections. Kevin Barnard
- Re: Increasing number of PG connections. scott.marlowe
- Re: [pgsql-advocacy] MySQL+InnoDB vs. PostgreSQL test? Christopher Kings-Lynne
- Re: [pgsql-advocacy] MySQL+InnoDB vs. PostgreSQL test? scott.marlowe
- Re: [pgsql-advocacy] MySQL+InnoDB vs. PostgreSQL test? Christopher Kings-Lynne
- Re: [pgsql-advocacy] MySQL+InnoDB vs. PostgreSQL test? Josh Berkus
- Re: [pgsql-advocacy] MySQL+InnoDB vs. PostgreSQL test? Tom Lane
- Re: [pgsql-advocacy] MySQL+InnoDB vs. PostgreSQL test? Christopher Kings-Lynne
- Re: [pgsql-advocacy] MySQL+InnoDB vs. PostgreSQL test? Tom Lane
- Re: [pgsql-advocacy] MySQL+InnoDB vs. PostgreSQL test? Christopher Kings-Lynne
- Re: [pgsql-advocacy] MySQL+InnoDB vs. PostgreSQL test? Josh Berkus
- Re: [pgsql-advocacy] MySQL+InnoDB vs. PostgreSQL test? Christopher Kings-Lynne
- Re: inserting large number of rows was: Re: Increasing Erki Kaldjärv
- PQexecParams and types Czuczy Gergely
- cache whole data in RAM David Teran
- Re: cache whole data in RAM Shridhar Daithankar
- Re: cache whole data in RAM Bruno Wolff III
- Re: cache whole data in RAM Chris Trawick
- Re: [pgsql-advocacy] MySQL+InnoDB vs. PostgreSQL test? Jeff
- Re: [pgsql-advocacy] MySQL+InnoDB vs. PostgreSQL test? Rigmor Ukuhe
- Re: PQexecParams and types Tom Lane
- Re: PQexecParams and types Czuczy Gergely
- Re: PQexecParams and types Tom Lane
- Re: Increasing number of PG connections. Kevin Barnard
- Re: [pgsql-advocacy] MySQL+InnoDB vs. PostgreSQL test? Jeff
- Database conversion woes... Kevin Carpenter
- Re: [pgsql-advocacy] MySQL+InnoDB vs. PostgreSQL test? Jeff
- Re: [pgsql-advocacy] MySQL+InnoDB vs. PostgreSQL test? Tom Lane
- Re: Database conversion woes... Jeff
- Re: [pgsql-advocacy] MySQL+InnoDB vs. PostgreSQL test? Tom Lane
- Re: Database conversion woes... scott.marlowe
- Re: [pgsql-advocacy] MySQL+InnoDB vs. PostgreSQL test? Jan Wieck
- Re: views? Loeke
- Re: Database conversion woes... Josh Berkus
- Re: [pgsql-advocacy] MySQL+InnoDB vs. PostgreSQL test? Adam Ruth
- Re: Database conversion woes... Richard Huxton
- Re: Database conversion woes... Christopher Browne
- Compile Vs RPMs Anjan Dave
- Database conversion woes... Kevin
- Re: Compile Vs RPMs Bill Moran
- Re: Compile Vs RPMs Paul Thomas
- Re: Database conversion woes... Richard Huxton
- Re: Compile Vs RPMs Christopher Browne
- Re: [pgsql-advocacy] MySQL+InnoDB vs. PostgreSQL test? Mike Nolan
- Re: Compile Vs RPMs scott.marlowe
- Re: cache whole data in RAM William Yu
- select is not using index? Mark Harrison
- Re: select is not using index? Corey Edwards
- 7.3 vs 7.4 performance Orion Henry
- Re: 7.3 vs 7.4 performance Josh Berkus
- Re: 7.3 vs 7.4 performance Christopher Browne
- Re: 7.3 vs 7.4 performance Chris Trawick
- Re: 7.3 vs 7.4 performance Carlos Eduardo Smanioto
- Index Performance Help Damien Dougan
- Re: 7.3 vs 7.4 performance Christopher Browne
- Re: 7.3 vs 7.4 performance Tom Lane
- Re: Index Performance Help Richard Huxton
- Re: Index Performance Help Damien Dougan
- Re: select is not using index? Mark Harrison
- Re: 7.3 vs 7.4 performance Orion Henry
- Re: Index Performance Help Josh Berkus
- Re: [pgsql-advocacy] MySQL+InnoDB vs. PostgreSQL test? Mark Harrison
- COPY with INDEXES question Slavisa Garic
- Re: COPY with INDEXES question Christopher Kings-Lynne
- Re: COPY with INDEXES question Slavisa Garic
- Seq scan on zero-parameters function Octavio Alvarez
- Re: Seq scan on zero-parameters function Octavio Alvarez
- Re: Seq scan on zero-parameters function Richard Huxton
- Increase performance of a UNION query that thakes 655.07 msec to be runned ? Bruno BAGUETTE
- Re: 7.3 vs 7.4 performance Hannu Krosing
- Re: 7.3 vs 7.4 performance Hannu Krosing
- Re: Seq scan on zero-parameters function Tom Lane
- Re: Increase performance of a UNION query that thakes 655.07 msec to be runned ? Tom Lane
- Re: Increase performance of a UNION query that thakes Stephan Szabo
- RE : Increase performance of a UNION query that thakes 655.07 msec to be runned ? Bruno BAGUETTE
- RE : Increase performance of a UNION query that thakes 655.07 msec to be runned ? Bruno BAGUETTE
- Re: RE : Increase performance of a UNION query that thakes Stephan Szabo
- Re: 7.3 vs 7.4 performance markw@osdl.org
- Re: COPY with INDEXES question Rod Taylor
- Re: [pgsql-advocacy] MySQL+InnoDB vs. PostgreSQL test? Jan Wieck
- Re: Database conversion woes... Kevin Carpenter
- Why is query selecting sequential? Karl Denninger
- Re: Why is query selecting sequential? Josh Berkus
- Re: Why is query selecting sequential? Karl Denninger
- Re: Why is query selecting sequential? Josh Berkus
- Re: 7.3 vs 7.4 performance Orion Henry
- Re: 7.3 vs 7.4 performance Orion Henry
- Re: 7.3 vs 7.4 performance Orion Henry
- Re: Why is query selecting sequential? Karl Denninger
- Re: 7.3 vs 7.4 performance Josh Berkus
- Re: Why is query selecting sequential? Tom Lane
- Re: 7.3 vs 7.4 performance Tom Lane
- Re: Why is query selecting sequential? Karl Denninger
- RE : RE : Increase performance of a UNION query that thakes 655.07 msec to be runned ? Bruno BAGUETTE
- Re: RE : RE : Increase performance of a UNION query that Stephan Szabo
- Re: Why is query selecting sequential? Josh Berkus
- select count(*) from anIntColumn where int_value = 0; is very slow David Teran
- Re: select count(*) from anIntColumn where int_value = 0; Pavel Stehule
- Re: select count(*) from anIntColumn where int_value = 0; is very slow Rigmor Ukuhe
- Re: select count(*) from anIntColumn where int_value = 0; is very slow David Teran
- Re: select count(*) from anIntColumn where int_value = 0; is very slow PC Drew
- update performance stefan bogdan
- slow database alemon@tiago.hazor.com.br
- Re: slow database Dennis Bjorklund
- Re: slow database PC Drew
- Re: slow database PC Drew
- Re: select count(*) from anIntColumn where int_value = 0; Christopher Browne
- Re: slow database Rod Taylor
- Re: slow database Chris Trawick
- Re: update performance Richard Huxton
- Re: select count(*) from anIntColumn where int_value = 0; scott.marlowe
- Re: slow database alemon@tiago.hazor.com.br
- Re: slow database Chris Browne
- Re: update performance scott.marlowe
- Re: slow database Tom Lane
- Re: slow database scott.marlowe
- Re: slow database alemon@tiago.hazor.com.br
- Re: update performance scott.marlowe
- Re: slow database alemon@tiago.hazor.com.br
- Re: slow database scott.marlowe
- Re: slow database Rod Taylor
- Re: slow database scott.marlowe
- coercing int to bigint for indexing purposes Mark Harrison
- Re: coercing int to bigint for indexing purposes Tom Lane
- Re: slow database Mark Kirkwood
- Re: select count(*) from anIntColumn where int_value = Christopher Kings-Lynne
- Disappointing performance in db migrated from MS SQL Server Leon Out
- Re: Disappointing performance in db migrated from MS SQL scott.marlowe
- Re: Disappointing performance in db migrated from MS SQL Server Bruce Momjian
- Re: Disappointing performance in db migrated from MS SQL Gavin M. Roy
- Re: Disappointing performance in db migrated from MS SQL Server PC Drew
- Re: Disappointing performance in db migrated from MS SQL Server Chris Ruprecht
- Re: Disappointing performance in db migrated from MS SQL Server Josh Berkus
- optimization ideas for frequent, large(ish) updates in frequently accessed DB? Marinos J. Yannikos
- Re: optimization ideas for frequent, large(ish) updates in frequently accessed DB? Josh Berkus
- Re: optimization ideas for frequent, large(ish) updates in frequently accessed DB? Manfred Koizar
- Re: Disappointing performance in db migrated from MS SQL Server Andrew Sullivan
- Re: optimization ideas for frequent, large(ish) updates in frequently accessed DB? Manfred Koizar
- Re: optimization ideas for frequent, large(ish) updates in frequently accessed DB? Manfred Koizar
- Re: Disappointing performance in db migrated from MS SQL Server Leon Out
- Lengthy pg_restore and high iowait? Leon Out
- Re: Disappointing performance in db migrated from MS SQL matt@ymogen.net
- Re: Disappointing performance in db migrated from MS SQL Server Vivek Khera
- Re: Disappointing performance in db migrated from MS SQL Server Vivek Khera
- slow GIST index creation Rajesh Kumar Mallah
- Re: optimization ideas for frequent, large(ish) updates Marinos J. Yannikos
- Re: optimization ideas for frequent, large(ish) updates Christopher Kings-Lynne
- Re: optimization ideas for frequent, large(ish) updates Jeff Trout
- Re: optimization ideas for frequent, large(ish) updates Jeff Trout
- Re: optimization ideas for frequent, large(ish) updates Marinos J. Yannikos
- Re: optimization ideas for frequent, large(ish) updates Tom Lane
- select max(id) from aTable is very slow David Teran
- Re: select max(id) from aTable is very slow Nick Barr
- Re: select max(id) from aTable is very slow Nick Barr
- Re: select max(id) from aTable is very slow David Teran
- Slow response of PostgreSQL Saleem Burhani Baloch
- Re: Slow response of PostgreSQL Christopher Kings-Lynne
- Re: Slow response of PostgreSQL Stephan Szabo
- Re: Slow response of PostgreSQL Tom Lane
- Re: very large db performance question Eric Jain
- Re: Slow response of PostgreSQL Saleem Burhani Baloch
- Re: Slow response of PostgreSQL Shridhar Daithankar
- UPDATE with subquery too slow Eric Jain
- Re: UPDATE with subquery too slow Leeuw van der, Tim
- Tables on multiple disk drives Konstantin Tokar
- Re: Slow response of PostgreSQL Bill Moran
- Re: Tables on multiple disk drives Richard Huxton
- Re: Slow response of PostgreSQL Tom Lane
- Re: Disappointing performance in db migrated from MS SQL scott.marlowe
- long running query running too long Todd Fulton
- Re: Slow response of PostgreSQL scott.marlowe
- Re: Tables on multiple disk drives scott.marlowe
- Re: Tables on multiple disk drives Craig Thomas
- Re: Tables on multiple disk drives scott.marlowe
- Re: Tables on multiple disk drives Craig Thomas
- Re: Tables on multiple disk drives scott.marlowe
- Re: long running query running too long PC Drew
- Re: long running query running too long Todd Fulton
- RAID or manual split? Mike Glover
- Re: RAID or manual split? matt@ymogen.net
- Re: long running query running too long PC Drew
- Re: Tables on multiple disk drives Christopher Browne
- Re: long running query running too long Tom Lane
- Re: Slow response of PostgreSQL Christopher Kings-Lynne
- Re: Slow response of PostgreSQL scott.marlowe
- Re: Slow response of PostgreSQL Bill Moran
- Re: Slow response of PostgreSQL Christopher Kings-Lynne
- Re: UPDATE with subquery too slow Kevin Brown
- Optimizer difference using function index between 7.3 and 7.4 Jeff Boes
- Re: Optimizer difference using function index between 7.3 and 7.4 Tom Lane
- Re: UPDATE with subquery too slow Eric Jain
- Forcing filter/join order? Josh Berkus
- Re: Forcing filter/join order? Peter Darley
- Re: Forcing filter/join order? Josh Berkus
- Re: Forcing filter/join order? Josh Berkus
- Re: Forcing filter/join order? Stephan Szabo
- Re: Forcing filter/join order? Josh Berkus
- Re: Forcing filter/join order? Stephan Szabo
- Re: Forcing filter/join order? Tom Lane
- Re: Forcing filter/join order? Josh Berkus
- Re: Tables on multiple disk drives Josh Berkus
- Re: Forcing filter/join order? Tom Lane
- Re: Slow response of PostgreSQL Saleem Burhani Baloch
- Re: Slow response of PostgreSQL Shridhar Daithankar
- Re: Slow response of PostgreSQL Christopher Kings-Lynne
- Postgresql on SAN Anjan Dave
- Re: Postgresql on SAN Josh Berkus
- Re: Forcing filter/join order? Josh Berkus
- Re: Postgresql on SAN Nick Barr
- Re: Slow response of PostgreSQL Hannu Krosing
- Re: Optimizer difference using function index between 7.3 and 7.4 Simon Riggs
- Re: Forcing filter/join order? Josh Berkus
- Slow in morning hours
- Re: Slow in morning hours Andrew Sullivan
- Re: Slow in morning hours Bill Moran
- Re: Slow response of PostgreSQL Neil Conway
- Re: Slow in morning hours ohp@pyrenet.fr
- cacheable stored functions? Bill Moran
- Re: cacheable stored functions? Stephan Szabo
- Re: cacheable stored functions? Tomasz Myrta
- Re: cacheable stored functions? Richard Huxton
- Re: cacheable stored functions? Bill Moran
- General performance questions about postgres on Apple hardware... Sean Shanny
- Re: [ADMIN] Index called with Union but not with OR clause Bruno Wolff III
- Re: General performance questions about postgres on Apple Sean Shanny
- Re: General performance questions about postgres on Apple scott.marlowe
- JOIN order, 15K, 15K, 7MM rows Andrew Lazarus
- Re: RAID or manual split? Rod Taylor
- conceptual method to create high performance query involving time Don Bowman
- Column correlation drifts, index ignored again John Siracusa
- Re: JOIN order, 15K, 15K, 7MM rows Josh Berkus
- Re: Column correlation drifts, index ignored again Josh Berkus
- Re: Column correlation drifts, index ignored again John Siracusa
- Re: Column correlation drifts, index ignored again Tom Lane
- Re: Column correlation drifts, index ignored again John Siracusa
- Re: General performance questions about postgres on Apple Tom Lane
- Re: Column correlation drifts, index ignored again Tom Lane
- Re: Column correlation drifts, index ignored again John Siracusa
- Re: Column correlation drifts, index ignored again Josh Berkus
- Re: General performance questions about postgres on Apple Sean Shanny
- Re: General performance questions about postgres on Apple Tom Lane
- Re: Column correlation drifts, index ignored again Tom Lane
- Slow join using network address function Eric Jain
- Re: Slow join using network address function Steve Atkins
- Re: General performance questions about postgres on Apple scott.marlowe
- Re: General performance questions about postgres on Apple Sean Shanny
- Re: Slow join using network address function Josh Berkus
- Re: General performance questions about postgres on Apple Josh Berkus
- Re: General performance questions about postgres on Apple hardware... Simon Riggs
- Re: General performance questions about postgres on Apple Sean Shanny
- Re: Slow join using network address function Markus Bertheau
- [PERFORMANCE] slow small delete on large table Ed L.
- Re: [PERFORMANCE] slow small delete on large table Christopher Kings-Lynne
- Re: [PERFORMANCE] slow small delete on large table Bruno Wolff III
- Re: Column correlation drifts, index ignored again Kevin Brown
- Re: [PERFORMANCE] slow small delete on large table Christopher Browne
- Re: [PERFORMANCE] slow small delete on large table Tom Lane
- Re: Slow join using network address function Eric Jain
- Re: Slow join using network address function Tom Lane
- Materialized View Summary Jonathan M. Gardner
- Re: Slow join using network address function Nick Barr
- Re: Column correlation drifts, index ignored again Josh Berkus
- Re: [SQL] Materialized View Summary Richard Huxton
- Re: Slow join using network address function Steve Atkins
- Re: Slow join using network address function Steve Atkins
- Re: Column correlation drifts, index ignored again Tom Lane
- Re: [PERFORMANCE] slow small delete on large table Ed L.
- Re: Column correlation drifts, index ignored again Kevin Brown
- Re: [PERFORMANCE] slow small delete on large table Christopher Browne
- Re: Column correlation drifts, index ignored again Ed L.
- Re: Column correlation drifts, index ignored again Kevin Brown
- Re: [HACKERS] [SQL] Materialized View Summary Robert Treat
- Re: Column correlation drifts, index ignored again Tom Lane
- Speed up a function?CREATE TABLE readings ( "when" TIMESTAMP DEFAULT timeofday()::timestamp NOT NULL PRIMARY KEY, "barometer" FLOAT DEFAULT NULL, Robert Creager
- Re: Speed up a function?CREATE TABLE readings ( "when" TIMESTAMP DEFAULT timeofday()::timestamp NOT NULL PRIMARY KEY, "barometer" FLOAT DEFAULT NULL, Tom Lane
- Re: Slow join using network address function Steve Atkins
- Re: [HACKERS] [SQL] Materialized View Summary Jonathan M. Gardner
- Re: [HACKERS] [SQL] Materialized View Summary Robert Treat
- A cache for the results of queries ? David Pradier
- Re: A cache for the results of queries ? Richard Huxton
- Re: A cache for the results of queries ? scott.marlowe
- FreeBSD config Dror Matalon
- Re: FreeBSD config scott.marlowe
- Re: FreeBSD config Dror Matalon
- Re: FreeBSD config scott.marlowe
- Database Server Tuning John Allgood
- Re: FreeBSD config Christopher Kings-Lynne
- Re: FreeBSD config Dror Matalon
- Re: FreeBSD config Kevin Barnard
- Re: Database Server Tuning Josh Berkus
- Re: FreeBSD config Dror Matalon
- Re: FreeBSD config Dror Matalon
- Re: A cache for the results of queries ? William Yu
- Re: Database Server Tuning John Allgood
- Re: FreeBSD config Shridhar Daithankar
- Re: FreeBSD config scott.marlowe
- Select-Insert-Query postgres@countup.de
- Re: FreeBSD config Dror Matalon
- Re: FreeBSD config Vivek Khera
- Re: Select-Insert-Query Richard Huxton
- Re: FreeBSD config Shridhar Daithankar
- WAL Optimisation - configuration and usage Rob Fielding
- Re: WAL Optimisation - configuration and usage Richard Huxton
- Re: FreeBSD config Christopher Weimann
- Re: [HACKERS] [SQL] Materialized View Summary Hans-Jürgen Schönig
- compiling 7.4.1 on Solaris 9 teknokrat
- Re: [HACKERS] [SQL] Materialized View Summary Jonathan Gardner
- Slow query Ivan Voras
- Re: JOIN order, 15K, 15K, 7MM rows andrew@pillette.com
- Re: FreeBSD config Christopher Weimann
- Re: Database Server Tuning Troels Arvin
- Re: [HACKERS] Materialized View Summary Mark Gibson
- Re: WAL Optimisation - configuration and usage Rod Taylor
- Re: WAL Optimisation - configuration and usage Rob Fielding