Mailing lists [pgsql-performance]
- Trigger & Function Duane Lee - EGOVX
- Re: Trigger & Function Mike Nolan
- PostgreSQL on VMWare vs Windows vs CoLinux Vitaly Belman
- Disk performance, was Re: tablespaces and DB administration Marty Scholes
- PostgreSQL and Kernel 2.6.x V i s h a l Kashyap @ [Sai Hertz And Control Systems]
- Re: PostgreSQL and Kernel 2.6.x Rod Taylor
- Re: PostgreSQL on VMWare vs Windows vs CoLinux Greg Stark
- Re: PostgreSQL and Kernel 2.6.x Rajesh Kumar Mallah
- Re: PostgreSQL on VMWare vs Windows vs CoLinux Jan Wieck
- Re: PostgreSQL on VMWare vs Windows vs CoLinux Tom Lane
- Re: Trigger & Function Duane Lee - EGOVX
- Re: PostgreSQL on VMWare vs Windows vs CoLinux Matthew Nuzum
- Re: PostgreSQL on VMWare vs Windows vs CoLinux Leeuw van der, Tim
- Context Switching issue: Spinlock doesn't fix. Josh Berkus
- Postgres query optimization with varchar fields W.H. van Atteveldt
- Re: PostgreSQL on VMWare vs Windows vs CoLinux Shachar Shemesh
- Re: Hardware opinions wanted Andrew Hammond
- Re: PostgreSQL on VMWare vs Windows vs CoLinux Merlin Moncure
- Re: Pl/Pgsql Functions running simultaneously Marcus Whitney
- Re: PostgreSQL on VMWare vs Windows vs CoLinux Gary Doades
- Re: Inherited Tables Performance Marcus Whitney
- Re: PostgreSQL on VMWare vs Windows vs CoLinux Greg Stark
- Re: Postgres query optimization with varchar fields Christopher Kings-Lynne
- Re: PostgreSQL on VMWare vs Windows vs CoLinux Matthew Nuzum
- Re: PostgreSQL on VMWare vs Windows vs CoLinux Tom Lane
- Re: PostgreSQL on VMWare vs Windows vs CoLinux Tom Lane
- Re: select max(id) from aTable is very slow Richard Huxton
- Re: Pl/Pgsql Functions running simultaneously Marcus Whitney
- Most transactions per second on largest box?
- Re: Most transactions per second on largest box? Greg Stark
- Planner problem Mikael Kjellström
- Re: Planner problem Tom Lane
- Re: filesystem option tuning CH
- Re: filesystem option tuning Tom Lane
- postgres performance: comparing 2 data centers Michael Nonemacher
- Re: postgres performance: comparing 2 data centers Merlin Moncure
- Re: postgres performance: comparing 2 data centers Tom Lane
- Re: Pl/Pgsql Functions running simultaneously Robert Treat
- Re: postgres performance: comparing 2 data centers Michael Nonemacher
- Re: postgres performance: comparing 2 data centers Rod Taylor
- Re: postgres performance: comparing 2 data centers Michael Nonemacher
- Re: postgres performance: comparing 2 data centers Greg Stark
- Re: postgres performance: comparing 2 data centers Tom Lane
- Unused table of view Laurent Martelli
- Re: Unused table of view Tom Lane
- Re: Unused table of view Laurent Martelli
- Using a COPY...FROM through JDBC? Steve Wampler
- Re: Slow in morning hours Harald Fuchs
- Query involving views Laurent Martelli
- Re: Query involving views Tom Lane
- Re: Query involving views Laurent Martelli
- Re: postgres performance: comparing 2 data centers Rod Taylor
- Re: [JDBC] Using a COPY...FROM through JDBC? Markus Schaber
- Re: General performance questions about postgres on Apple Gregory S. Williamson
- Relation of cpu_*_costs? SZŰCS Gábor
- Re: [JDBC] Using a COPY...FROM through JDBC? Markus Schaber
- Re: [JDBC] Using a COPY...FROM through JDBC? Kris Jurka
- Postgres function use makes machine crash. Stef
- Re: Relation of cpu_*_costs? Tom Lane
- Re: Postgres function use makes machine crash. Tom Lane
- Re: Postgres function use makes machine crash. Stef
- PREPAREing statements versus compiling PLPGSQL Mark Aufflick
- pl/pgsql and Transaction Isolation Marcus Whitney
- Re: Pl/Pgsql Functions running simultaneously Marcus Whitney
- Re: Relation of cpu_*_costs? SZŰCS Gábor
- is it possible to for the planner to optimize this form? Merlin Moncure
- Re: [JDBC] Using a COPY...FROM through JDBC? Steve Wampler
- Re: [JDBC] Using a COPY...FROM through JDBC? Steve Wampler
- seq scan woes Dan Langille
- Re: seq scan woes Dan Langille
- Re: is it possible to for the planner to optimize this form? Josh Berkus
- Re: seq scan woes Dan Langille
- Re: [JDBC] Using a COPY...FROM through JDBC? Kris Jurka
- Join slow on "large" tables Josué Maldonado
- Re: Join slow on "large" tables Josh Berkus
- Re: Join slow on "large" tables Scott Marlowe
- Re: seq scan woes Dan Langille
- Re: seq scan woes Dan Langille
- Re: Join slow on "large" tables Josué Maldonado
- Re: Join slow on "large" tables Josh Berkus
- Re: Join slow on "large" tables Josué Maldonado
- Re: is it possible to for the planner to optimize this Duane Lee - EGOVX
- Re: pl/pgsql and Transaction Isolation Tom Lane
- Re: Join slow on "large" tables Tom Lane
- Use of Functional Indexs and Planner estimates Russell Smith
- Re: Use of Functional Indexs and Planner estimates Manfred Koizar
- Re: pl/pgsql and Transaction Isolation Marcus Whitney
- Re: Use of Functional Indexs and Planner estimates Tom Lane
- Re: Join slow on "large" tables Josué Maldonado
- Re: Use of Functional Indexs and Planner estimates Scott Marlowe
- reindex and copy - deadlock? Litao Wu
- Re: Join slow on "large" tables Scott Marlowe
- Re: reindex and copy - deadlock? Tom Lane
- Re: reindex and copy - deadlock? Litao Wu
- Re: reindex and copy - deadlock? Tom Lane
- RamDisk
- Re: Use of Functional Indexs and Planner estimates Greg Stark
- Re: seq scan woes Rod Taylor
- Re: seq scan woes Rod Taylor
- Index oddity ken
- Re: Index oddity Rod Taylor
- Re: Index oddity ken
- Re: Index oddity Rod Taylor
- Re: Index oddity ken
- Re: Index oddity Rod Taylor
- Re: Index oddity ken
- Re: Index oddity Christopher Kings-Lynne
- Re: Index oddity Rod Taylor
- Re: Index oddity Mark Kirkwood
- Re: Index oddity Joshua D. Drake
- Re: Index oddity Tom Lane
- *very* inefficient choice made by the planner (regarding IN(...)) Frank van Vugt
- Re: *very* inefficient choice made by the planner (regarding Stephan Szabo
- Re: *very* inefficient choice made by the planner (regarding IN(...)) Tom Lane
- Re: *very* inefficient choice made by the planner (regarding IN(...)) Frank van Vugt
- Re: *very* inefficient choice made by the planner (regarding Jean-Luc Lachance
- Re: *very* inefficient choice made by the planner (regarding Tom Lane
- Re: Database Server Tuning Anjan Dave
- Re: Database Server Tuning Vivek Khera
- Re: *very* inefficient choice made by the planner (regarding Jean-Luc Lachance
- Re: *very* inefficient choice made by the planner (regarding Stephan Szabo
- Re: *very* inefficient choice made by the planner (regarding Stephan Szabo
- ORDER BY user defined function performance issues Nick Trainor
- Re: ORDER BY user defined function performance issues Paul Thomas
- Problems with vacuum! Domenico Sgarbossa
- Re: Problems with vacuum! Chris Hoover
- Re: [BULK] Problems with vacuum! Domenico Sgarbossa
- Re: [BULK] Problems with vacuum! Doug McNaught
- Re: reindex and copy - deadlock? Litao Wu
- Re: reindex and copy - deadlock? Tom Lane
- Re: ORDER BY user defined function performance issues Tom Lane
- in-transaction insert performance in 7.5devel Merlin Moncure
- Re: in-transaction insert performance in 7.5devel Rod Taylor
- Re: in-transaction insert performance in 7.5devel Merlin Moncure
- Re: in-transaction insert performance in 7.5devel Rod Taylor
- Re: reindex and copy - deadlock? Litao Wu
- Re: in-transaction insert performance in 7.5devel Tom Lane
- Re: reindex and copy - deadlock? Tom Lane
- Re: in-transaction insert performance in 7.5devel Merlin Moncure
- Re: in-transaction insert performance in 7.5devel Tom Lane
- Additional select fields in a GROUP BY Vitaly Belman
- Re: Additional select fields in a GROUP BY Tom Lane
- Re: Additional select fields in a GROUP BY Bruno Wolff III
- Re: Additional select fields in a GROUP BY Vitaly Belman
- Re: Additional select fields in a GROUP BY Tom Lane
- Re: [BULK] Problems with vacuum! Dawn Hollingsworth
- 50 000 000 Table entries and I have to do a keyword search HELP NEEDED borajetta
- Re: Index oddity (still) ken
- Re: 50 000 000 Table entries and I have to do a keyword search HELP NEEDED Josh Berkus
- Re: Failed System. Help. Marcus Whitney
- Re: Failed System follow up Marcus Whitney
- Interpreting OSDB Results Neeraj
- why is a constraint not 'pushed down' into a subselect when this subselect is using a 'group by' ?? Frank van Vugt
- Re: 50 000 000 Table entries and I have to do a keyword search HELP NEEDED Jeremy Dunn
- Re: why is a constraint not 'pushed down' into a subselect when this subselect is using a 'group by' ?? Tom Lane
- Re: Index oddity (still) Tom Lane
- Re: why is a constraint not 'pushed down' into a subselect when this subselect is using a 'group by' ?? Frank van Vugt
- Re: why is a constraint not 'pushed down' into a subselect when this subselect is using a 'group by' ?? Tom Lane
- Re: why is a constraint not 'pushed down' into a subselect when this subselect is using a 'group by' ?? Frank van Vugt
- Visual Explain Jeff
- Basic Postgresql Performance Question Bill
- Re: Basic Postgresql Performance Question Stephen Frost
- Re: Basic Postgresql Performance Question Kevin Barnard
- Re: Basic Postgresql Performance Question Scott Marlowe
- Re: Basic Postgresql Performance Question Stephen Frost
- Re: 50 000 000 Table entries and I have to do a keyword search HELP NEEDED Josh Berkus
- Re: Visual Explain Adam Witney
- Re: Visual Explain Paul Thomas
- Re: Visual Explain Jeff
- Re: in-transaction insert performance in 7.5devel Merlin Moncure
- Re: Visual Explain Vitaly Belman
- Re: Visual Explain Jeff
- Re: Visual Explain Paul Thomas
- Re: Visual Explain Vitaly Belman
- Slow vacuum performance Patrick Hatcher
- Re: Slow vacuum performance Dennis Bjorklund
- Re: Slow vacuum performance Andrew McMillan
- Re: *very* inefficient choice made by the planner (regarding SZUCS Gábor
- Major differences between oracle and postgres performance - what can I do ? Gary Cowell
- Re: Major differences between oracle and postgres performance Richard Huxton
- Re: Major differences between oracle and postgres performance - what can I do ? Paul Thomas
- Re: Major differences between oracle and postgres performance - what can I do ? Jeff
- Re: Major differences between oracle and postgres performance Shridhar Daithankar
- memory allocation Michael Ryan S. Puncia
- Re: Major differences between oracle and postgres performance - what can I do ? Gary Cowell
- Re: memory allocation Devrim GUNDUZ
- Re: Major differences between oracle and postgres performance pginfo
- Re: [BULK] Problems with vacuum! Domenico Sgarbossa
- Re: Major differences between oracle and postgres performance Richard Huxton
- Re: memory allocation Richard Huxton
- Re: *very* inefficient choice made by the planner (regarding Tom Lane
- Re: Major differences between oracle and postgres performance - what can I do ? Tom Lane
- Re: [BULK] Problems with vacuum! Tom Lane
- Re: Major differences between oracle and postgres performance pginfo
- Re: *very* inefficient choice made by the planner (regarding Stephan Szabo
- Re: Major differences between oracle and postgres performance - what can I do ? Gary Cowell
- Re: Major differences between oracle and postgres performance - what can I do ? Stephen Frost
- Re: Major differences between oracle and postgres performance - what can I do ? Tom Lane
- Re: Major differences between oracle and postgres performance - what can I do ? Stephen Frost
- Re: [BULK] Problems with vacuum! Scott Marlowe
- Re: Major differences between oracle and postgres performance - what can I do ? Stephen Frost
- Re: [BULK] Problems with vacuum! Scott Marlowe
- Re: [BULK] Problems with vacuum! Joshua D. Drake
- Re: Major differences between oracle and postgres performance - what can I do ? Tom Lane
- Re: Major differences between oracle and postgres performance - what can I do ? Gary Cowell
- Hi! Janio Rosa da Silva
- Indexing question Stan Bielski
- pg_fetch_array Thanks
- Re: 50 000 000 Table entries and I have to do a keyword search HELP NEEDED Aaron
- Re: Indexing question Tom Lane
- Re: pg_fetch_array Rod Taylor
- Re: Slow vacuum performance Andrew McMillan
- Re: pg_fetch_array Richard Huxton
- Re: Slow vacuum performance Patrick Hatcher
- Postgres over Linux NBD or NFS Andrew Hammond
- Re: Pl/Pgsql Functions running simultaneously Andrew Hammond
- Re: Postgres over Linux NBD or NFS Tom Lane
- Re: Postgres over Linux NBD or NFS Andrew Rawnsley
- Re: Postgres over Linux NBD or NFS Scott Marlowe
- Re: Postgres over Linux NBD or NFS Christopher Browne
- Re: Postgres over Linux NBD or NFS Andrew Rawnsley
- Re: Postgres over Linux NBD or NFS Matt Clark
- Re: [BULK] Problems with vacuum! Domenico Sgarbossa
- Re: Postgres over Linux NBD or NFS Andrew Hammond
- postgresql and openmosix migration Bill
- Re: reindex and copy - deadlock? Litao Wu
- Re: Hi! Josh Berkus
- Re: reindex and copy - deadlock? Tom Lane
- Re: postgresql and openmosix migration Josh Berkus
- Re: postgresql and openmosix migration Bill
- Re: postgresql and openmosix migration Bruno Wolff III
- Re: postgresql and openmosix migration
- Re: postgresql and openmosix migration Richard Welty
- after using pg_resetxlog, db lost Shea,Dan [CIS]
- Re: postgresql and openmosix migration Matthew Nuzum
- Re: after using pg_resetxlog, db lost Tom Lane
- Re: after using pg_resetxlog, db lost Richard Huxton
- Re: after using pg_resetxlog, db lost Tom Lane
- Re: postgresql and openmosix migration Joe Conway
- Re: postgresql and openmosix migration Andrew Hammond
- Re: Traduc Party Laurent Martelli
- Re: postgresql and openmosix migration Merlin Moncure
- Re: postgresql and openmosix migration Josh Berkus
- Re: postgresql and openmosix migration Rod Taylor
- Re: postgresql and openmosix migration Richard Welty
- Re: Traduc Party Laurent Martelli
- Re: after using pg_resetxlog, db lost Shea,Dan [CIS]
- Re: Traduc Party Paul Thomas
- Re: after using pg_resetxlog, db lost Tom Lane
- Re: Pas la samedi Laurent Martelli
- Re: after using pg_resetxlog, db lost Shea,Dan [CIS]
- Re: after using pg_resetxlog, db lost Tom Lane
- Re: after using pg_resetxlog, db lost Shea,Dan [CIS]
- postgres 7.4 at 100% Chris Cheston
- Re: postgres 7.4 at 100% Richard Huxton
- How can one see what queries are running withing a postgres instance? P.A.M. van Dam
- Re: How can one see what queries are running withing a postgres instance? Hervé Piedvache
- Re: How can one see what queries are running withing a postgres instance? Hervé Piedvache
- Re: postgres 7.4 at 100% Chris Cheston
- Re: How can one see what queries are running withing a Christopher Kings-Lynne
- Re: postgres 7.4 at 100% Doug McNaught
- Re: postgres 7.4 at 100% Joshua D. Drake
- Re: How can one see what queries are running withing a Tom Lane
- Re: postgres 7.4 at 100% Chris Cheston
- Re: postgres 7.4 at 100% Christopher Kings-Lynne
- SQL stupid query plan... terrible performance ! Jim
- Re: SQL stupid query plan... terrible performance ! Jeff
- Query performance Bill
- Re: SQL stupid query plan... terrible performance ! Tom Lane
- Re: postgres 7.4 at 100% Frank Knobbe
- Re: postgres 7.4 at 100% Tom Lane
- Re: SQL stupid query plan... terrible performance ! Klint Gore
- Re: SQL stupid query plan... terrible performance ! Tom Lane
- Re: Query performance Richard Huxton
- Re: postgres 7.4 at 100% Josh Berkus
- Re: Query performance Bill
- Re: SQL stupid query plan... terrible performance ! Jim
- Re: postgres 7.4 at 100% Josh Berkus
- Re: postgres 7.4 at 100% Frank Knobbe
- Re: postgres 7.4 at 100% Josh Berkus
- no index-usage on aggregate-functions? Harald Lau (Sector-X)
- Re: no index-usage on aggregate-functions? Scott Marlowe
- Re: no index-usage on aggregate-functions? Christopher Kings-Lynne
- Re: postgres 7.4 at 100% Chris Cheston
- Re: postgres 7.4 at 100% Christopher Kings-Lynne
- Re: postgres 7.4 at 100% Chris Cheston
- Re: Query performance Richard Huxton
- Re: no index-usage on aggregate-functions? Harald Lau (Sector-X)
- Re: no index-usage on aggregate-functions? Dennis Bjorklund
- Slow INSERT Michal Táborský
- Re: postgres 7.4 at 100% Bruno Wolff III
- Re: no index-usage on aggregate-functions? Bruno Wolff III
- Re: postgres 7.4 at 100% Tom Lane
- Re: Slow INSERT Tom Lane
- Re: Slow INSERT Michal Taborsky
- Re: Major differences between oracle and postgres performance - what can I do ? Mischa Sandberg
- Re: Postgres over Linux NBD or NFS Carlos Eduardo Smanioto
- Re: Postgres over Linux NBD or NFS Matthew Nuzum
- High load average with PostgreSQL 7.4.2 on debian/ibm eserver. eleven@ludojad.itpp.pl
- Re: Slow INSERT Michal Taborsky
- Re: Slow INSERT Tom Lane
- Re: postgres 7.4 at 100% Gavin M. Roy
- Re: Slow INSERT Tom Lane
- Re: High load average with PostgreSQL 7.4.2 on debian/ibm eserver. Marc
- Re: High load average with PostgreSQL 7.4.2 on debian/ibm Bill Montgomery
- Re: no index-usage on aggregate-functions? Scott Marlowe
- Re: VidéoProj -> RMLL Laurent Martelli
- suggestions to improve performace Mohan A
- Re: High load average with PostgreSQL 7.4.2 on debian/ibm eserver. eleven@ludojad.itpp.pl
- Re: no index-usage on aggregate-functions? Harald Lau (Sector-X)
- Re: Query performance Bill
- Re: Query performance Richard Huxton
- Range query optimization Mischa Sandberg
- Re: Query performance Bruno Wolff III
- Re: High load average with PostgreSQL 7.4.2 on Scott Marlowe
- Re: suggestions to improve performace Josh Berkus
- Re: High load average with PostgreSQL 7.4.2 on debian/ibm eserver. Josh Berkus
- Re: postgres 7.4 at 100% Chris Cheston
- Re: postgres 7.4 at 100% Christopher Kings-Lynne
- Re: postgres 7.4 at 100% Chris Cheston
- Re: postgres 7.4 at 100% Christopher Kings-Lynne
- Re: Query performance Bill
- Re: Query performance Rod Taylor
- Re: reindex and copy - deadlock? Litao Wu
- Re: reindex and copy - deadlock? Tom Lane
- Re: postgres 7.4 at 100% Duane Lee - EGOVX
- Re: reindex and copy - deadlock? Litao Wu
- Re: reindex and copy - deadlock? Tom Lane
- Re: reindex and copy - deadlock? Litao Wu
- Re: reindex and copy - deadlock? Tom Lane