Mailing lists [pgsql-performance]
- Re: Raid 10 chunksize Mark Kirkwood
- Re: Raid 10 chunksize Mark Kirkwood
- PostgreSQL Mahu Vasile
- Re: How to get parallel restore in PG 8.4 to work? henk de wit
- Re: How to get parallel restore in PG 8.4 to work? Tom Lane
- Re: PostgreSQL Robert Haas
- Re: Raid 10 chunksize Stef Telford
- Re: Raid 10 chunksize Greg Smith
- Re: Raid 10 chunksize Stef Telford
- self join revisited Rikard Pavelic
- Re: Raid 10 chunksize Scott Marlowe
- Re: self join revisited Matthew Wakeling
- Re: Raid 10 chunksize Stef Telford
- Re: Raid 10 chunksize Matthew Wakeling
- Re: Raid 10 chunksize Scott Marlowe
- Re: Raid 10 chunksize Matthew Wakeling
- Re: Raid 10 chunksize Scott Marlowe
- Re: Very specialised query Matthew Wakeling
- Re: Raid 10 chunksize Stef Telford
- Re: self join revisited Tom Lane
- Re: Very specialised query Matthew Wakeling
- Re: Raid 10 chunksize Greg Smith
- Re: Raid 10 chunksize Matthew Wakeling
- Re: Raid 10 chunksize Scott Marlowe
- Re: Very specialised query Matthew Wakeling
- Re: self join revisited Rikard Pavelic
- Re: Raid 10 chunksize Stef Telford
- Re: Raid 10 chunksize david@lang.hm
- Re: Raid 10 chunksize Stef Telford
- Re: Raid 10 chunksize david@lang.hm
- Re: self join revisited Robert Haas
- Re: Raid 10 chunksize Scott Carey
- Re: Raid 10 chunksize Scott Carey
- Re: Raid 10 chunksize Scott Carey
- Re: Raid 10 chunksize Scott Carey
- Re: Raid 10 chunksize david@lang.hm
- Re: Raid 10 chunksize Scott Marlowe
- Re: Raid 10 chunksize Mark Kirkwood
- Re: Raid 10 chunksize Mark Kirkwood
- Re: Raid 10 chunksize Greg Smith
- Re: Very specialised query Matthew Wakeling
- Re: Very specialised query Craig Ringer
- Re: Raid 10 chunksize Merlin Moncure
- Re: Raid 10 chunksize James Mansion
- Re: How to get parallel restore in PG 8.4 to work? henk de wit
- Re: Raid 10 chunksize Scott Carey
- Re: Raid 10 chunksize Merlin Moncure
- Re: Raid 10 chunksize Scott Carey
- Re: Raid 10 chunksize Scott Carey
- Re: 8.4 Performance improvements: was Re: Proposal of tunable fix for scalability of 8.4 Bruce Momjian
- Re: Raid 10 chunksize Ron Mayer
- Re: Raid 10 chunksize Hannes Dorbath
- Re: Raid 10 chunksize Mark Kirkwood
- Re: Raid 10 chunksize Greg Smith
- Re: Raid 10 chunksize Greg Smith
- Re: Raid 10 chunksize Greg Smith
- Rewriting using rules for performance Matthew Wakeling
- plpgsql arrays Matthew Wakeling
- Re: Rewriting using rules for performance Robert Haas
- Re: plpgsql arrays Robert Haas
- Re: Rewriting using rules for performance Matthew Wakeling
- Re: plpgsql arrays Matthew Wakeling
- Re: plpgsql arrays Tom Lane
- Re: plpgsql arrays Tom Lane
- Re: plpgsql arrays Matthew Wakeling
- Re: plpgsql arrays Tom Lane
- Re: plpgsql arrays Matthew Wakeling
- Re: plpgsql arrays Matthew Wakeling
- Re: plpgsql arrays Tom Lane
- Re: plpgsql arrays Matthew Wakeling
- Re: plpgsql arrays Merlin Moncure
- Re: plpgsql arrays Merlin Moncure
- Re: plpgsql arrays Matthew Wakeling
- Re: plpgsql arrays Merlin Moncure
- Re: Rewriting using rules for performance Merlin Moncure
- Re: Rewriting using rules for performance Merlin Moncure
- Re: plpgsql arrays Simon Riggs
- Re: plpgsql arrays Alvaro Herrera
- Re: plpgsql arrays Tom Lane
- Re: plpgsql arrays Nathan Boley
- Question on pgbench output David Kerr
- Re: Question on pgbench output Tom Lane
- Re: Question on pgbench output David Kerr
- Re: Question on pgbench output Scott Marlowe
- Re: Question on pgbench output Greg Smith
- Re: Question on pgbench output Tom Lane
- Re: Question on pgbench output Tom Lane
- Using IOZone to simulate DB access patterns Josh Berkus
- Re: Question on pgbench output David Kerr
- Re: Question on pgbench output David Kerr
- Re: Using IOZone to simulate DB access patterns Josh Berkus
- Re: Raid 10 chunksize david@lang.hm
- Re: Raid 10 chunksize Greg Smith
- Re: Question on pgbench output Greg Smith
- Re: Raid 10 chunksize Scott Carey
- Re: Using IOZone to simulate DB access patterns henk de wit
- Re: Using IOZone to simulate DB access patterns Jesper Krogh
- Re: Using IOZone to simulate DB access patterns henk de wit
- Re: Strange behavior: pgbench and new Linux kernels Greg Smith
- Re: Strange behavior: pgbench and new Linux kernels Josh Berkus
- Re: Strange behavior: pgbench and new Linux kernels Greg Smith
- Re: Question on pgbench output David Kerr
- Re: Question on pgbench output Simon Riggs
- Re: Question on pgbench output Tom Lane
- Re: Question on pgbench output David Kerr
- Re: Question on pgbench output Tom Lane
- Best replication solution? Lists
- Re: Best replication solution? Lists
- difficulties with time based queries Rainer Mager
- Re: difficulties with time based queries David Wilson
- Re: difficulties with time based queries PFC
- Re: difficulties with time based queries Tom Lane
- Re: difficulties with time based queries Rainer Mager
- Re: difficulties with time based queries Tom Lane
- Re: Best replication solution? Greg Sabino Mullane
- Re: difficulties with time based queries Rainer Mager
- probelm with alter table add constraint...... roopasatish
- Re: Best replication solution? Heikki Linnakangas
- Re: difficulties with time based queries Robert Haas
- Re: probelm with alter table add constraint...... Robert Haas
- Re: probelm with alter table add constraint...... Albe Laurenz
- Re: plpgsql arrays Matthew Wakeling
- Re: Forcing seq_scan off for large table joined with tiny table yeilds improved performance Mario Splivalo
- Re: difficulties with time based queries Matthew Wakeling
- Re: Best replication solution? Andrew Sullivan
- Re: plpgsql arrays Matthew Wakeling
- Re: probelm with alter table add constraint...... Tom Lane
- Re: Forcing seq_scan off for large table joined with tiny table yeilds improved performance Scott Marlowe
- Re: plpgsql arrays Robert Haas
- Re: Forcing seq_scan off for large table joined with tiny table yeilds improved performance Mario Splivalo
- Re: Forcing seq_scan off for large table joined with tiny table yeilds improved performance Scott Marlowe
- Re: Forcing seq_scan off for large table joined with tiny table yeilds improved performance Mario Splivalo
- Re: Forcing seq_scan off for large table joined with tiny table yeilds improved performance Scott Marlowe
- Re: Best replication solution? Lists
- Re: Best replication solution? Lists
- Re: Best replication solution? Dimitri Fontaine
- Re: Best replication solution? Ivan Voras
- Re: Best replication solution? Mark Kirkwood
- Re: plpgsql arrays Matthew Wakeling
- Re: plpgsql arrays justin
- Re: plpgsql arrays Matthew Wakeling
- Re: plpgsql arrays justin
- Re: plpgsql arrays Tom Lane
- Re: Best replication solution? Andrew Sullivan
- Re: plpgsql arrays Matthew Wakeling
- Re: Best replication solution? Andrew Sullivan
- determining the locks that will be held by a query Brian Cox
- Re: plpgsql arrays Merlin Moncure
- Re: plpgsql arrays Tom Lane
- Re: 8.4 Performance improvements: was Re: Proposal of tunable fix for scalability of 8.4 Bruce Momjian
- Re: Best replication solution? Mark Kirkwood
- Re: plpgsql arrays Matthew Wakeling
- Re: Best replication solution? Marinos Yannikos
- bad query plans for ~ "^string" (and like "string%") (8.3.6) Marinos Yannikos
- Re: bad query plans for ~ "^string" (and like "string%") (8.3.6) Marinos Yannikos
- Re: bad query plans for ~ "^string" (and like "string%") (8.3.6) Robert Haas
- Re: bad query plans for ~ "^string" (and like "string%") (8.3.6) Tom Lane
- Re: Best replication solution? Jeff
- Re: Best replication solution? Dimitri Fontaine
- Nested query performance issue Glenn Maynard
- Re: Nested query performance issue Віталій Тимчишин
- Re: Nested query performance issue Glenn Maynard
- Re: difficulties with time based queries Rainer Mager
- Re: Nested query performance issue Віталій Тимчишин
- Re: Nested query performance issue Heikki Linnakangas
- Re: Best replication solution? Jeff
- linux deadline i/o elevator tuning Mark Wong
- Re: linux deadline i/o elevator tuning Kevin Grittner
- Re: linux deadline i/o elevator tuning Grzegorz Jaśkiewicz
- Re: linux deadline i/o elevator tuning Matthew Wakeling
- Re: linux deadline i/o elevator tuning Grzegorz Jaśkiewicz
- Re: linux deadline i/o elevator tuning Kevin Grittner
- Re: linux deadline i/o elevator tuning Kevin Grittner
- Re: linux deadline i/o elevator tuning Matthew Wakeling
- Re: linux deadline i/o elevator tuning Grzegorz Jaśkiewicz
- Re: linux deadline i/o elevator tuning Arjen van der Meijden
- Re: linux deadline i/o elevator tuning Mark Wong
- Re: linux deadline i/o elevator tuning Kevin Grittner
- Re: linux deadline i/o elevator tuning Mark Wong
- Re: linux deadline i/o elevator tuning Scott Carey
- Re: Nested query performance issue Glenn Maynard
- Re: Nested query performance issue Glenn Maynard
- Re: Nested query performance issue Greg Smith
- Re: difficulties with time based queries Rainer Mager
- Re: difficulties with time based queries Tom Lane
- Re: Using IOZone to simulate DB access patterns Josh Berkus
- Re: Nested query performance issue Glenn Maynard
- Re: Using IOZone to simulate DB access patterns Mark Kirkwood
- Shouldn't the planner have a higher cost for reverse index scans? Josh Berkus
- Re: linux deadline i/o elevator tuning Albe Laurenz *EXTERN*
- Postgres 8.x on Windows Server in production Ognjen Blagojevic
- Re: Nested query performance issue Tom Lane
- Re: Shouldn't the planner have a higher cost for reverse index scans? Tom Lane
- Re: Using IOZone to simulate DB access patterns Joshua D. Drake
- Re: Shouldn't the planner have a higher cost for reverse index scans? Josh Berkus
- Re: Using IOZone to simulate DB access patterns Josh Berkus
- Re: Using IOZone to simulate DB access patterns Scott Carey
- Re: Using IOZone to simulate DB access patterns Josh Berkus
- Re: Shouldn't the planner have a higher cost for reverse index scans? Tom Lane
- Re: Using IOZone to simulate DB access patterns Josh Berkus
- Re: Using IOZone to simulate DB access patterns Scott Carey
- Re: Shouldn't the planner have a higher cost for reverse index scans? Josh Berkus
- Re: plpgsql arrays Tom Lane
- Re: Using IOZone to simulate DB access patterns Greg Smith
- Re: Postgres 8.x on Windows Server in production Josh Berkus
- Re: Using IOZone to simulate DB access patterns Scott Carey
- determining the locks that will be held by a query Brian Cox
- Re: Using IOZone to simulate DB access patterns Greg Smith
- Re: determining the locks that will be held by a query Kevin Grittner
- 2.6.26 kernel and PostgreSQL Glyn Astill
- Re: 2.6.26 kernel and PostgreSQL Kevin Grittner
- Re: Postgres 8.x on Windows Server in production Grzegorz Jaśkiewicz
- Re: 2.6.26 kernel and PostgreSQL Glyn Astill
- Re: Using IOZone to simulate DB access patterns M. Edward (Ed) Borasky
- Re: Using IOZone to simulate DB access patterns Mark Wong
- Re: Using IOZone to simulate DB access patterns Scott Carey
- Re: Postgres 8.x on Windows Server in production Rainer Mager
- Re: Postgres 8.x on Windows Server in production Scott Marlowe
- Re: Postgres 8.x on Windows Server in production Rainer Mager
- Re: Postgres 8.x on Windows Server in production Scott Marlowe
- Re: 2.6.26 kernel and PostgreSQL Greg Smith
- Re: 2.6.26 kernel and PostgreSQL Glyn Astill
- Re: Postgres 8.x on Windows Server in production Ognjen Blagojevic
- Re: linux deadline i/o elevator tuning Jeff
- Re: linux deadline i/o elevator tuning Kevin Grittner
- Re: Postgres 8.x on Windows Server in production Scott Marlowe
- Re: Postgres 8.x on Windows Server in production Grzegorz Jaśkiewicz
- Re: Postgres 8.x on Windows Server in production Justin Pitts
- INSERT times - same storage space but more fields -> much slower inserts Craig Ringer
- Re: difficulties with time based queries PFC
- Re: Nested query performance issue Matthew Wakeling
- Re: Shouldn't the planner have a higher cost for reverse index scans? Matthew Wakeling
- Re: Nested query performance issue Glenn Maynard
- Re: Nested query performance issue Merlin Moncure
- Re: INSERT times - same storage space but more fields -> much slower inserts Stephen Frost
- Re: difficulties with time based queries Nikolas Everett
- Re: INSERT times - same storage space but more fields -> much slower inserts Matthew Wakeling
- Re: INSERT times - same storage space but more fields -> much slower inserts Stephen Frost
- Re: INSERT times - same storage space but more fields -> much slower inserts Craig Ringer
- Re: INSERT times - same storage space but more fields -> much slower inserts Tom Lane
- error updating a very large table Brian Cox
- Re: INSERT times - same storage space but more fields -> much slower inserts Stephen Frost
- Re: error updating a very large table Grzegorz Jaśkiewicz
- need information Peeyush
- Re: INSERT times - same storage space but more fields -> much slower inserts Matthew Wakeling
- Re: INSERT times - same storage space but more fields -> much slower inserts Matthew Wakeling
- Re: error updating a very large table Tom Lane
- Re: error updating a very large table Simon Riggs
- Re: Shouldn't the planner have a higher cost for reverse index scans? Lists
- Re: Shouldn't the planner have a higher cost for reverse index scans? Grzegorz Jaśkiewicz
- Really dumb planner decision Matthew Wakeling
- Re: Really dumb planner decision Grzegorz Jaśkiewicz
- Re: Really dumb planner decision Grzegorz Jaśkiewicz
- Re: Really dumb planner decision Matthew Wakeling
- Re: Really dumb planner decision Matthew Wakeling
- Re: Really dumb planner decision Robert Haas
- Re: Really dumb planner decision Matthew Wakeling
- Re: Shouldn't the planner have a higher cost for reverse index scans? Merlin Moncure
- Re: Really dumb planner decision Merlin Moncure
- Re: Really dumb planner decision Tom Lane
- Re: Really dumb planner decision Kevin Grittner
- Re: Really dumb planner decision Merlin Moncure
- Re: Shouldn't the planner have a higher cost for reverse index scans? Tom Lane
- Re: Shouldn't the planner have a higher cost for reverse index scans? Tom Lane
- Re: Really dumb planner decision Robert Haas
- Re: Shouldn't the planner have a higher cost for reverse index scans? Lists
- Re: Really dumb planner decision Matthew Wakeling
- Re: Shouldn't the planner have a higher cost for reverse index scans? Tom Lane
- Re: Really dumb planner decision Tom Lane
- GiST index performance Matthew Wakeling
- Re: GiST index performance Kevin Grittner
- Re: GiST index performance Matthew Wakeling
- Re: GiST index performance Tom Lane
- Re: GiST index performance Matthew Wakeling
- Re: GiST index performance dforum
- Re: GiST index performance Tom Lane
- Re: GiST index performance Matthew Wakeling
- Re: GiST index performance Tom Lane
- Re: GiST index performance Matthew Wakeling
- No hash join across partitioned tables? Kris Jurka
- Re: No hash join across partitioned tables? Tom Lane
- Re: No hash join across partitioned tables? Kris Jurka
- Re: No hash join across partitioned tables? Kris Jurka
- Re: GiST index performance Craig Ringer
- Optimizer's issue Vlad Arkhipov
- Re: No hash join across partitioned tables? Tom Lane
- Re: No hash join across partitioned tables? Tom Lane
- Re: No hash join across partitioned tables? Kris Jurka
- Re: No hash join across partitioned tables? Kris Jurka
- Re: GiST index performance Matthew Wakeling
- stats are way off on 8.4 b1 Grzegorz Jaśkiewicz
- Re: stats are way off on 8.4 b1 Tom Lane
- Re: stats are way off on 8.4 b1 Grzegorz Jaśkiewicz
- Re: stats are way off on 8.4 b1 Heikki Linnakangas
- Re: stats are way off on 8.4 b1 Grzegorz Jaśkiewicz
- SQL With Dates Rafael Domiciano
- Re: GiST index performance Matthew Wakeling
- Re: SQL With Dates Grzegorz Jaśkiewicz
- Re: GiST index performance Tom Lane
- Re: SQL With Dates Rafael Domiciano
- Re: SQL With Dates Scott Marlowe
- Re: SQL With Dates Mark Lewis
- performance for high-volume log insertion david@lang.hm
- Re: performance for high-volume log insertion Stephen Frost
- Re: performance for high-volume log insertion david@lang.hm
- Re: performance for high-volume log insertion Stephen Frost
- Re: performance for high-volume log insertion Greg Smith
- Re: performance for high-volume log insertion Stephen Frost
- Re: performance for high-volume log insertion david@lang.hm
- Re: performance for high-volume log insertion Stephen Frost
- Re: performance for high-volume log insertion david@lang.hm
- Re: performance for high-volume log insertion david@lang.hm
- Re: performance for high-volume log insertion david@lang.hm
- Re: performance for high-volume log insertion Stephen Frost
- Re: performance for high-volume log insertion Stephen Frost
- Re: performance for high-volume log insertion Stephen Frost
- Re: performance for high-volume log insertion david@lang.hm
- Re: performance for high-volume log insertion david@lang.hm
- Re: performance for high-volume log insertion Richard Huxton
- Re: GiST index performance Matthew Wakeling
- Re: performance for high-volume log insertion Kenneth Marshall
- WHERE condition not being pushed down to union parts John L. Clark
- Re: WHERE condition not being pushed down to union parts Tom Lane
- Re: WHERE condition not being pushed down to union parts John L. Clark
- Re: WHERE condition not being pushed down to union parts Tom Lane
- Re: performance for high-volume log insertion david@lang.hm
- Re: performance for high-volume log insertion Kenneth Marshall
- Re: SQL With Dates Robert Haas
- Re: performance for high-volume log insertion Ben Chobot
- Re: performance for high-volume log insertion Stephen Frost
- Re: performance for high-volume log insertion david@lang.hm
- Re: performance for high-volume log insertion Greg Smith
- Re: performance for high-volume log insertion Stephen Frost
- Re: performance for high-volume log insertion david@lang.hm
- Re: WHERE condition not being pushed down to union parts John L. Clark
- Re: performance for high-volume log insertion Kenneth Marshall
- Re: performance for high-volume log insertion david@lang.hm
- Re: performance for high-volume log insertion david@lang.hm
- Re: performance for high-volume log insertion Stephen Frost
- Re: performance for high-volume log insertion Stephen Frost
- Re: performance for high-volume log insertion James Mansion
- Re: performance for high-volume log insertion Stephen Frost
- Re: WHERE condition not being pushed down to union parts Tom Lane
- Re: performance for high-volume log insertion Greg Smith
- Re: performance for high-volume log insertion david@lang.hm
- Re: performance for high-volume log insertion Robert Haas
- Re: performance for high-volume log insertion James Mansion
- Re: probelm with alter table add constraint...... roopabenzer
- Re: performance for high-volume log insertion Stephen Frost
- Re: performance for high-volume log insertion Stephen Frost
- Re: GiST index performance Matthew Wakeling
- Re: performance for high-volume log insertion Simon Riggs
- Re: GiST index performance Matthew Wakeling
- Re: performance for high-volume log insertion Glenn Maynard
- Re: performance for high-volume log insertion david@lang.hm
- Re: performance for high-volume log insertion Stephen Frost
- Re: performance for high-volume log insertion Tom Lane
- Re: performance for high-volume log insertion James Mansion
- Re: performance for high-volume log insertion Glenn Maynard
- Re: performance for high-volume log insertion Joshua D. Drake
- Re: performance for high-volume log insertion Glenn Maynard
- Re: performance for high-volume log insertion Glenn Maynard
- Re: performance for high-volume log insertion Stephen Frost
- Re: performance for high-volume log insertion Glenn Maynard
- Re: performance for high-volume log insertion david@lang.hm
- Re: performance for high-volume log insertion Stephen Frost
- Re: performance for high-volume log insertion Stephen Frost
- Re: performance for high-volume log insertion Glenn Maynard
- Re: performance for high-volume log insertion david@lang.hm
- Re: performance for high-volume log insertion Stephen Frost
- Re: performance for high-volume log insertion Stephen Frost
- Re: WHERE condition not being pushed down to union parts John L. Clark
- Re: WHERE condition not being pushed down to union parts Tom Lane
- Re: performance for high-volume log insertion Thomas Kellerer
- Adam Ruth
- Re: performance for high-volume log insertion Kris Jurka
- Re: performance for high-volume log insertion Thomas
- Re: Using IOZone to simulate DB access patterns Mark Wong
- Re: Using IOZone to simulate DB access patterns Mark Wong
- Re: performance for high-volume log insertion Scott Marlowe
- Re: performance for high-volume log insertion Kris Jurka
- Re: performance for high-volume log insertion Scott Marlowe
- Re: performance for high-volume log insertion david@lang.hm
- plpgsql function running long, but resources consumption is very low Wojtek
- Re: plpgsql function running long, but resources consumption is very low Pavel Stehule
- Re: Using IOZone to simulate DB access patterns Laurent Laborde
- Re: plpgsql function running long, but resources consumption is very low Scott Carey
- any interest of changing the page size ? Laurent Laborde
- partition question for new server setup Whit Armstrong
- Re: partition question for new server setup Scott Marlowe
- Re: partition question for new server setup Whit Armstrong
- pg_lock_status() performance Merlin Moncure
- Re: partition question for new server setup Scott Marlowe
- Re: partition question for new server setup Kenneth Marshall
- Re: partition question for new server setup Craig James
- Re: partition question for new server setup Alan Hodgson
- Re: partition question for new server setup Craig James
- Re: partition question for new server setup Kevin Grittner
- Re: partition question for new server setup Whit Armstrong
- Re: partition question for new server setup Kenneth Marshall
- Re: partition question for new server setup Kevin Grittner
- Re: partition question for new server setup Whit Armstrong
- Re: partition question for new server setup Scott Marlowe
- Re: partition question for new server setup Scott Marlowe
- Re: partition question for new server setup Scott Marlowe
- Re: pg_lock_status() performance Tom Lane
- Re: pg_lock_status() performance Merlin Moncure
- Re: pg_lock_status() performance Merlin Moncure
- Re: pg_lock_status() performance Tom Lane
- Re: partition question for new server setup Scott Carey
- Re: partition question for new server setup Scott Carey
- Re: partition question for new server setup Whit Armstrong
- Re: partition question for new server setup Whit Armstrong
- Re: partition question for new server setup Scott Marlowe
- Re: partition question for new server setup Scott Carey
- Re: partition question for new server setup Scott Carey
- Re: partition question for new server setup Scott Carey
- Re: partition question for new server setup Whit Armstrong