db.postgresql.performance (date)

db.postgresql.performance (date)

June 30, 2004

Re: reindex and copy - deadlock?, Tom Lane
Re: reindex and copy - deadlock?, Litao Wu
Re: reindex and copy - deadlock?, Tom Lane
Re: reindex and copy - deadlock?, Litao Wu
Re: postgres 7.4 at 100%, Duane Lee - EGOVX
Re: reindex and copy - deadlock?, Tom Lane
Re: reindex and copy - deadlock?, Litao Wu
Re: Query performance, Rod Taylor
Re: Query performance, Bill
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: postgres 7.4 at 100%, Chris Cheston

June 29, 2004

Re: suggestions to improve performace, Josh Berkus
Re: High load average with PostgreSQL 7.4.2 on debian/ibm eserver., Josh Berkus
Re: High load average with PostgreSQL 7.4.2 on, Scott Marlowe
Re: Query performance, Bruno Wolff III
Range query optimization, Mischa Sandberg
Re: Query performance, Richard Huxton
Re: no index-usage on aggregate-functions?, Harald Lau (Sector-X)
Re: Query performance, Bill
Re: High load average with PostgreSQL 7.4.2 on debian/ibm eserver., eleven
suggestions to improve performace, Mohan A
Re: no index-usage on aggregate-functions?, Scott Marlowe
Re: VidéoProj -> RMLL, Laurent Martelli
Re: High load average with PostgreSQL 7.4.2 on debian/ibm, Bill Montgomery
Re: High load average with PostgreSQL 7.4.2 on debian/ibm eserver., Marc
Re: Slow INSERT, Tom Lane
Re: postgres 7.4 at 100%, Gavin M. Roy
Re: Slow INSERT, Tom Lane
Re: Slow INSERT, Michal Taborsky
Re: Postgres over Linux NBD or NFS, Matthew Nuzum
High load average with PostgreSQL 7.4.2 on debian/ibm eserver., eleven
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: Slow INSERT, Michal Taborsky
Re: Slow INSERT, Tom Lane
Re: postgres 7.4 at 100%, Tom Lane
Re: no index-usage on aggregate-functions?, Bruno Wolff III
Re: postgres 7.4 at 100%, Bruno Wolff III
Slow INSERT, Michal Táborský
Re: no index-usage on aggregate-functions?, Dennis Bjorklund
Re: no index-usage on aggregate-functions?, Harald Lau (Sector-X)
Re: postgres 7.4 at 100%, Chris Cheston
Re: Query performance, Richard Huxton
Re: postgres 7.4 at 100%, Christopher Kings-Lynne
Re: postgres 7.4 at 100%, Chris Cheston
Re: no index-usage on aggregate-functions?, Christopher Kings-Lynne
Re: no index-usage on aggregate-functions?, Scott Marlowe
no index-usage on aggregate-functions?, Harald Lau (Sector-X)

June 28, 2004

Re: postgres 7.4 at 100%, Josh Berkus
Re: postgres 7.4 at 100%, Frank Knobbe
Re: postgres 7.4 at 100%, Josh Berkus
Re: SQL stupid query plan... terrible performance !, Jim
Re: Query performance, Bill
Re: postgres 7.4 at 100%, Josh Berkus
Re: Query performance, Richard Huxton
Re: SQL stupid query plan... terrible performance !, Tom Lane
Re: postgres 7.4 at 100%, Tom Lane
Re: SQL stupid query plan... terrible performance !, Klint Gore
Re: postgres 7.4 at 100%, Frank Knobbe
Re: SQL stupid query plan... terrible performance !, Tom Lane
Query performance, Bill
Re: SQL stupid query plan... terrible performance !, Jeff
SQL stupid query plan... terrible performance !, Jim

June 27, 2004

Re: postgres 7.4 at 100%, Christopher Kings-Lynne

June 26, 2004

Re: postgres 7.4 at 100%, Chris Cheston
Re: How can one see what queries are running withing a, Tom Lane
Re: postgres 7.4 at 100%, Joshua D. Drake
Re: postgres 7.4 at 100%, Doug McNaught
Re: How can one see what queries are running withing a, Christopher Kings-Lynne
Re: postgres 7.4 at 100%, Chris Cheston
Re: How can one see what queries are running withing a postgres instance?, Hervé Piedvache

June 25, 2004

Re: How can one see what queries are running withing a postgres instance?, Hervé Piedvache
How can one see what queries are running withing a postgres instance?, P.A.M. van Dam
Re: postgres 7.4 at 100%, Richard Huxton
postgres 7.4 at 100%, Chris Cheston

June 24, 2004

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]
Re: Pas la samedi, Laurent Martelli
Re: after using pg_resetxlog, db lost, Tom Lane
Re: Traduc Party, Paul Thomas
Re: after using pg_resetxlog, db lost, Shea,Dan [CIS]

June 23, 2004

Re: Traduc Party, Laurent Martelli
Re: postgresql and openmosix migration, Richard Welty
Re: postgresql and openmosix migration, Rod Taylor
Re: postgresql and openmosix migration, Josh Berkus
Re: postgresql and openmosix migration, Merlin Moncure
Re: Traduc Party, Laurent Martelli
Re: postgresql and openmosix migration, Andrew Hammond
Re: postgresql and openmosix migration, Joe Conway

June 22, 2004

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, Matthew Nuzum
after using pg_resetxlog, db lost, Shea,Dan [CIS]
Re: postgresql and openmosix migration, Richard Welty
Re: postgresql and openmosix migration, jason.servetar
Re: postgresql and openmosix migration, Bruno Wolff III
Re: postgresql and openmosix migration, Bill
Re: postgresql and openmosix migration, Josh Berkus
Re: reindex and copy - deadlock?, Tom Lane
Re: Hi!, Josh Berkus
Re: reindex and copy - deadlock?, Litao Wu
postgresql and openmosix migration, Bill
Re: Postgres over Linux NBD or NFS, Andrew Hammond
Re: [BULK] Problems with vacuum!, Domenico Sgarbossa
Re: Postgres over Linux NBD or NFS, Matt Clark
Re: Postgres over Linux NBD or NFS, Andrew Rawnsley
Re: Postgres over Linux NBD or NFS, Christopher Browne
Re: Postgres over Linux NBD or NFS, Scott Marlowe
Re: Postgres over Linux NBD or NFS, Andrew Rawnsley
Re: Postgres over Linux NBD or NFS, Tom Lane

June 21, 2004

Re: Pl/Pgsql Functions running simultaneously, Andrew Hammond
Postgres over Linux NBD or NFS, Andrew Hammond
Re: Slow vacuum performance, Patrick Hatcher
Re: pg_fetch_array, Richard Huxton
Re: Slow vacuum performance, Andrew McMillan

June 20, 2004

Re: pg_fetch_array, Rod Taylor
Re: Indexing question, Tom Lane
Re: 50 000 000 Table entries and I have to do a keyword search HELP NEEDED, Aaron
pg_fetch_array, Thanks
Indexing question, Stan Bielski
Hi!, Janio Rosa da Silva

June 18, 2004

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 ?, Tom Lane
Re: [BULK] Problems with vacuum!, Joshua D. Drake
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: 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: *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, pginfo
Re: [BULK] Problems with vacuum!, Tom Lane
Re: Major differences between oracle and postgres performance - what can I do ?, Tom Lane
Re: *very* inefficient choice made by the planner (regarding, Tom Lane
Re: Major differences between oracle and postgres performance, Richard Huxton
Re: memory allocation, Richard Huxton
Re: [BULK] Problems with vacuum!, Domenico Sgarbossa
Re: Major differences between oracle and postgres performance, pginfo
Re: memory allocation, Devrim GUNDUZ
Re: Major differences between oracle and postgres performance - what can I do ?, Gary Cowell
memory allocation, Michael Ryan S. Puncia
Re: Major differences between oracle and postgres performance, Shridhar Daithankar
Re: Major differences between oracle and postgres performance - what can I do ?, Jeff
Re: Major differences between oracle and postgres performance - what can I do ?, Paul Thomas
Re: Major differences between oracle and postgres performance, Richard Huxton
Major differences between oracle and postgres performance - what can I do ?, Gary Cowell
Re: *very* inefficient choice made by the planner (regarding, SZUCS Gábor
Re: Slow vacuum performance, Andrew McMillan
Re: Slow vacuum performance, Dennis Bjorklund

June 17, 2004

Slow vacuum performance, Patrick Hatcher
Re: Visual Explain, Vitaly Belman
Re: Visual Explain, Paul Thomas
Re: Visual Explain, Jeff
Re: Visual Explain, Vitaly Belman
Re: in-transaction insert performance in 7.5devel, Merlin Moncure
Re: Visual Explain, Jeff
Re: Visual Explain, Paul Thomas
Re: Visual Explain, Adam Witney
Re: 50 000 000 Table entries and I have to do a keyword search HELP NEEDED, Josh Berkus

June 16, 2004

Re: Basic Postgresql Performance Question, Stephen Frost
Re: Basic Postgresql Performance Question, Scott Marlowe
Re: Basic Postgresql Performance Question, Kevin Barnard
Re: Basic Postgresql Performance Question, Stephen Frost
Basic Postgresql Performance Question, Bill
Visual Explain, Jeff
Re: why is a constraint not 'pushed down' into a subselect when this subselect is using a 'group by' ??, Frank van Vugt

June 15, 2004

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
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' ??, Tom Lane
Re: 50 000 000 Table entries and I have to do a keyword search HELP NEEDED, Jeremy Dunn
why is a constraint not 'pushed down' into a subselect when this subselect is using a 'group by' ??, Frank van Vugt
Interpreting OSDB Results, Neeraj
Re: Failed System follow up, Marcus Whitney
Re: Failed System. Help., Marcus Whitney
Re: 50 000 000 Table entries and I have to do a keyword search HELP NEEDED, Josh Berkus

June 14, 2004

Re: Index oddity (still), ken
50 000 000 Table entries and I have to do a keyword search HELP NEEDED, borajetta
Re: [BULK] Problems with vacuum!, Dawn Hollingsworth

June 13, 2004

Re: Additional select fields in a GROUP BY, Tom Lane
Re: Additional select fields in a GROUP BY, Vitaly Belman
Re: Additional select fields in a GROUP BY, Bruno Wolff III
Re: Additional select fields in a GROUP BY, Tom Lane
Additional select fields in a GROUP BY, Vitaly Belman

June 11, 2004

Re: in-transaction insert performance in 7.5devel, Tom Lane
Re: in-transaction insert performance in 7.5devel, Merlin Moncure
Re: reindex and copy - deadlock?, Tom Lane
Re: in-transaction insert performance in 7.5devel, Tom Lane
Re: reindex and copy - deadlock?, Litao Wu
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
in-transaction insert performance in 7.5devel, Merlin Moncure
Re: ORDER BY user defined function performance issues, Tom Lane
Re: reindex and copy - deadlock?, Tom Lane
Re: reindex and copy - deadlock?, Litao Wu
Re: [BULK] Problems with vacuum!, Doug McNaught
Re: [BULK] Problems with vacuum!, Domenico Sgarbossa
Re: Problems with vacuum!, Chris Hoover
Problems with vacuum!, Domenico Sgarbossa
Re: ORDER BY user defined function performance issues, Paul Thomas
ORDER BY user defined function performance issues, Nick Trainor

June 10, 2004

Re: *very* inefficient choice made by the planner (regarding, Stephan Szabo
Re: *very* inefficient choice made by the planner (regarding, Stephan Szabo
Re: *very* inefficient choice made by the planner (regarding, Jean-Luc Lachance
Re: Database Server Tuning, Vivek Khera
Re: *very* inefficient choice made by the planner (regarding, Tom Lane
Re: Database Server Tuning, Anjan Dave
Re: *very* inefficient choice made by the planner (regarding, Jean-Luc Lachance
Re: *very* inefficient choice made by the planner (regarding IN(...)), Frank van Vugt
Re: *very* inefficient choice made by the planner (regarding IN(...)), Tom Lane
Re: *very* inefficient choice made by the planner (regarding, Stephan Szabo
*very* inefficient choice made by the planner (regarding IN(...)), Frank van Vugt
Re: Bulk INSERT performance in 7.4.1, Florian Weimer
Feature request: smarter use of conditional indexes, John Siracusa
Re: Scaling further up, Anjan Dave
Re: Database Server Tuning, Josh Berkus
Re: Scaling further up, Chris Ruprecht
Re: Index oddity, Tom Lane
Re: Index oddity, Joshua D. Drake
Re: Index oddity, Mark Kirkwood
Re: Scaling further up, Anjan Dave
Re: Index oddity, Rod Taylor
Re: Index oddity, Christopher Kings-Lynne
Re: Slow query, scott.marlowe

June 09, 2004

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, Rod Taylor
Index oddity, ken
Re: seq scan woes, Rod Taylor
Re: seq scan woes, Rod Taylor
Re: Use of Functional Indexs and Planner estimates, Greg Stark
Re: WAL Optimisation - configuration and usage, Rod Taylor
Re: JOIN order, 15K, 15K, 7MM rows, andrew
Re: FreeBSD config, Vivek Khera

June 08, 2004

RamDisk, jason.servetar
Re: reindex and copy - deadlock?, Tom Lane
Re: reindex and copy - deadlock?, Litao Wu
Re: reindex and copy - deadlock?, Tom Lane
Re: Join slow on "large" tables, Scott Marlowe
reindex and copy - deadlock?, Litao Wu
Re: Use of Functional Indexs and Planner estimates, Scott Marlowe
Re: Join slow on "large" tables, Josué Maldonado
Re: Use of Functional Indexs and Planner estimates, Tom Lane
Re: pl/pgsql and Transaction Isolation, Marcus Whitney
Re: FreeBSD config, Dror Matalon
Re: Use of Functional Indexs and Planner estimates, Manfred Koizar
Use of Functional Indexs and Planner estimates, Russell Smith
Re: Join slow on "large" tables, Tom Lane
Re: pl/pgsql and Transaction Isolation, 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: [PERFORMANCE] slow small delete on large table, Christopher Browne

June 07, 2004

Re: is it possible to for the planner to optimize this, Duane Lee - EGOVX
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: seq scan woes, Dan Langille
Re: seq scan woes, Dan Langille
Re: Join slow on "large" tables, Scott Marlowe
Re: Join slow on "large" tables, Josh Berkus
Join slow on "large" tables, Josué Maldonado
Re: [JDBC] Using a COPY...FROM through JDBC?, Kris Jurka
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: [PERFORMANCE] slow small delete on large table, Christopher Browne
seq scan woes, Dan Langille
Re: [JDBC] Using a COPY...FROM through JDBC?, Steve Wampler
Re: [JDBC] Using a COPY...FROM through JDBC?, Steve Wampler
is it possible to for the planner to optimize this form?, Merlin Moncure
Re: Relation of cpu_*_costs?, SZŰCS Gábor
Re: Pl/Pgsql Functions running simultaneously, Marcus Whitney
pl/pgsql and Transaction Isolation, Marcus Whitney
PREPAREing statements versus compiling PLPGSQL, Mark Aufflick
Re: Postgres function use makes machine crash., Stef
Re: Postgres function use makes machine crash., Tom Lane
Re: Relation of cpu_*_costs?, Tom Lane
Re: Slow join using network address function, Josh Berkus
Postgres function use makes machine crash., Stef
Re: [JDBC] Using a COPY...FROM through JDBC?, Kris Jurka
Re: [JDBC] Using a COPY...FROM through JDBC?, Markus Schaber
Relation of cpu_*_costs?, SZŰCS Gábor
Re: General performance questions about postgres on Apple, Gregory S. Williamson
Re: General performance questions about postgres on Apple, Tom Lane
Re: Column correlation drifts, index ignored again, Tom Lane

June 06, 2004

Re: Using a COPY...FROM through JDBC?, Markus Schaber
Re: postgres performance: comparing 2 data centers, Rod Taylor
Re: Query involving views, Laurent Martelli
Re: Query involving views, Tom Lane
Query involving views, Laurent Martelli
Re: Slow in morning hours, Harald Fuchs

June 05, 2004

Using a COPY...FROM through JDBC?, Steve Wampler
Re: Unused table of view, Laurent Martelli
Slow in morning hours, vathakar
Re: Unused table of view, Tom Lane
Unused table of view, Laurent Martelli
Re: postgres performance: comparing 2 data centers, Tom Lane
Re: postgres performance: comparing 2 data centers, Greg Stark

June 04, 2004

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: Pl/Pgsql Functions running simultaneously, Robert Treat
Re: postgres performance: comparing 2 data centers, Tom Lane
Re: postgres performance: comparing 2 data centers, Merlin Moncure
postgres performance: comparing 2 data centers, Michael Nonemacher
Re: filesystem option tuning, Tom Lane
Re: filesystem option tuning, CH
Re: Planner problem, Tom Lane
Planner problem, Mikael Kjellström
Re: Most transactions per second on largest box?, Greg Stark
Re: Forcing filter/join order?, Josh Berkus

June 03, 2004

Most transactions per second on largest box?, jason.servetar
Re: Pl/Pgsql Functions running simultaneously, Marcus Whitney
Re: Tables on multiple disk drives, Christopher Browne
Re: long running query running too long, Todd Fulton
Re: Slow response of PostgreSQL, Tom Lane
Re: select max(id) from aTable is very slow, Richard Huxton
Re: select max(id) from aTable is very slow, David Teran
Re: select max(id) from aTable is very slow, Nick Barr
select max(id) from aTable is very slow, David Teran
Re: PostgreSQL on VMWare vs Windows vs CoLinux, Tom Lane
Re: PostgreSQL on VMWare vs Windows vs CoLinux, Tom Lane
Re: PostgreSQL on VMWare vs Windows vs CoLinux, Matthew Nuzum
Re: Postgres query optimization with varchar fields, Christopher Kings-Lynne

June 02, 2004

Re: PostgreSQL on VMWare vs Windows vs CoLinux, Greg Stark
Re: Inherited Tables Performance, Marcus Whitney
Re: PostgreSQL on VMWare vs Windows vs CoLinux, Gary Doades
Re: Pl/Pgsql Functions running simultaneously, Marcus Whitney
Re: PostgreSQL on VMWare vs Windows vs CoLinux, Merlin Moncure
Re: PostgreSQL on VMWare vs Windows vs CoLinux, Shachar Shemesh
Re: Hardware opinions wanted, Andrew Hammond
Postgres query optimization with varchar fields, W.H. van Atteveldt
Context Switching issue: Spinlock doesn't fix., Josh Berkus
Re: PostgreSQL on VMWare vs Windows vs CoLinux, Leeuw van der, Tim
Re: PostgreSQL on VMWare vs Windows vs CoLinux, Matthew Nuzum
Re: Trigger & Function, Duane Lee - EGOVX
Re: PostgreSQL on VMWare vs Windows vs CoLinux, Tom Lane
Re: PostgreSQL on VMWare vs Windows vs CoLinux, Jan Wieck
Re: PostgreSQL and Kernel 2.6.x, Rajesh Kumar Mallah
Re: PostgreSQL on VMWare vs Windows vs CoLinux, Greg Stark
Re: PostgreSQL and Kernel 2.6.x, Rod Taylor
PostgreSQL and Kernel 2.6.x, V i s h a l Kashyap @ [Sai Hertz And Control Systems]
Disk performance, was Re: tablespaces and DB administration, Marty Scholes

June 01, 2004

PostgreSQL on VMWare vs Windows vs CoLinux, Vitaly Belman
Re: Trigger & Function, Mike Nolan
Trigger & Function, Duane Lee - EGOVX
Re: Disappointing performance in db migrated from MS SQL Server, Andrew Sullivan

^^^ ADDITIONAL NAVIGATION ^^^

Recently Viewed:
file-systems.op... xfree86.newbie/... bug-tracking.bu... apache.shale.de... windows.unatten... vserver/2004-06... yellowdog.gener... security.ids.pr... russian.linuxta... text.xml.svg.de... linux.redhat.ol... qplus.devel/200... kde.devel.kdeve... java.xwt.genera... gnu.gnupg.users... mail.bogofilter... hardware.openco... politics.activi... ide.lazarus.gen... network.nagios.... os.netbsd.devel... encryption.gpg.... dragonfly-bsd.k...

Home | blog view | USPTO Patent Archive (NEW!) | advertise | OSDir is an inevitable website. super tiny logo