db.postgresql.performance (date)

Please take our Survey

db.postgresql.performance (date)

January 31, 2004

Re: another query optimization question, David Teran
Re: another query optimization question, Marc G. Fournier
Re: High Performance/High Reliability File system on SuSE64, Bruce Momjian
Re: another query optimization question, Tom Lane
Re: another query optimization question, David Teran
Re: Unique index and estimated rows., Kari Lavikka
Re: High Performance/High Reliability File system on SuSE64, Tom Lane
Re: Unique index and estimated rows., Josh Berkus
Re: views?, Neil Conway
views?, Loeke
Re: Queries with timestamp II, Shridhar Daithankar
Re: Persistent Connections, Randolf Richardson
Re: High Performance/High Reliability File system on SuSE64, Christopher Weimann
Queries with timestamp, 2, Arnau Rebassa i Villalonga

January 30, 2004

Re: another query optimization question, Tom Lane
Re: another query optimization question, David Teran
Re: another query optimization question, Richard Huxton
Re: query optimization differs between view and explicit, Reece Hart
Re: another query optimization question, Tom Lane
Re: another query optimization question, David Teran
Re: another query optimization question, Stephan Szabo
Re: another query optimization question, PC Drew
another query optimization question, David Teran
Re: query optimization question, Jack Coates
Re: Cost of indexscan, Tom Lane
Re: query optimization question, Tom Lane
Re: On the performance of views, Shridhar Daithankar
Re: query optimization question, Greg Stark
Unique index and estimated rows., Kari Lavikka
Re: Explain plan for 2 column index : timestamps and time zones, lnd
Cost of indexscan, Kari Lavikka
Re: query optimization question, Dennis Bjorklund
Re: query optimization question, Dennis Bjorklund
Re: query optimization differs between view and explicit, Tom Lane
Re: query optimization differs between view and explicit, Stephan Szabo
Re: query optimization differs between view and explicit, Christopher Kings-Lynne
query optimization differs between view and explicit query, Reece Hart

January 29, 2004

Re: query optimization question, Jack Coates
Re: Explain plan for 2 column index, Tom Lane
Re: query optimization question, Tom Lane
Re: Explain plan for 2 column index, Richard Huxton
Re: query optimization question, Jack Coates
Explain plan for 2 column index, lnd
Re: query optimization question, Tom Lane
Re: On the performance of views, Bill Moran
Re: query optimization question, Jack Coates
Re: On the performance of views, Josh Berkus
Re: query optimization question, Tom Lane
Re: query optimization question, Jack Coates
Re: [SQL] limit 1 and functional indexes, Bruno Wolff III
Re: query optimization question, Tom Lane
query optimization question, Jack Coates

January 28, 2004

Re: Linux / Clariion, Nick Barr
Linux / Clariion, Cott Lang
Optimization questions, Greg Spiegelberg
Re: High Performance/High Reliability File system on, markw
Re: postgres timeout., Stef
Re: postgres timeout. [SOLVED], Stef
Re: [SQL] postgres timeout., Tom Lane
postgres timeout., Stef
Re: On the performance of views, Bill Moran
Re: On the performance of views, Shridhar Daithankar
Re: pl/pgSQL versus pl/Python, Joe Conway

January 27, 2004

Re: (partial?) indexes, LIKE and NULL, Tom Lane
Re: On the performance of views, Josh Berkus
Re: (partial?) indexes, LIKE and NULL, PC Drew
Re: On the performance of views, Bill Moran
(partial?) indexes, LIKE and NULL, Marinos J. Yannikos
pl/pgSQL versus pl/Python, Joshua D. Drake
Re: High Performance/High Reliability File system on SuSE64, George Essig
Re: Insert Times, Alan Stange
Re: Insert Times, PC Drew
Re: Insert Times, Leeuw van der, Tim
Re: Insert Times, Brad Gawne

January 26, 2004

Insert Times, PC Drew
Re: help with dual indexing, Orion Henry
Re: On the performance of views, Bill Moran
Re: On the performance of views, Josh Berkus
Re: On the performance of views, Tom Lane
Re: High Performance/High Reliability File system on SuSE64, Greg Stark
Re: High Performance/High Reliability File system on SuSE64, Christopher Browne
Re: On the performance of views, Shridhar Daithankar
On the performance of views, Bill Moran
Re: Queries with timestamp II, Tomasz Myrta
Queries with timestamp II, Arnau

January 25, 2004

Re: query slows under load, Stephan Szabo
Re: Benchmarking PostgreSQL?, Ivan Voras
Re: Persistent Connections, Nick Barr
Re: Benchmarking PostgreSQL?, Tom Lane
Re: Slow delete times??, Octavio Alvarez
Benchmarking PostgreSQL?, Ivan Voras

January 24, 2004

Re: High Performance/High Reliability File system on SuSE64, Mark Kirkwood
Re: High Performance/High Reliability File system on SuSE64, Doug McNaught
Persistent Connections, postgres
Re: High Performance/High Reliability File system on SuSE64, Paul Ganainm
Re: High Performance/High Reliability File system on SuSE64, Joshua D. Drake
Re: High Performance/High Reliability File system on SuSE64, Mark Kirkwood
Re: Slow delete times??, Tom Lane
query slows under load, Jenny Zhang
Re: High Performance/High Reliability File system on SuSE64, Joshua D. Drake
Re: help with dual indexing, Tom Lane
Re: Slow delete times??, Joshua D. Drake
Slow delete times??, Octavio Alvarez

January 23, 2004

Re: High Performance/High Reliability File system on SuSE64, Joshua D. Drake
Re: High Performance/High Reliability File system on SuSE64, Christopher Browne
Re: High Performance/High Reliability File system on SuSE64, Joshua D. Drake
Re: High Performance/High Reliability File system on SuSE64, Andrew Sullivan
Re: High Performance/High Reliability File system on SuSE64, Joshua D. Drake
Re: High Performance/High Reliability File system on SuSE64, Andrew Sullivan
help with dual indexing, Orion Henry
Re: High Performance/High Reliability File system on SuSE64, Joshua D. Drake
Re: High Performance/High Reliability File system on SuSE64, Andrew Sullivan
Optimizing SQL: bind variables, prepared stms, histograms, lnd
Re: High Performance/High Reliability File system on SuSE64, Joshua D. Drake
High Performance/High Reliability File system on SuSE64, Dave Thompson
Re: Postgres on Netapp, Bruce Momjian
Re: Trigger performance, Pavel Stehule
Re: database performance and query performance question, Greg Stark

January 22, 2004

Re: database performance and query performance question, Hannu Krosing
Re: database performance and query performance question, Josh Berkus
Re: database performance and query performance question, Shea,Dan [CIS]
Re: database performance and query performance question, Shea,Dan [CIS]
Re: database performance and query performance question, Hannu Krosing
Re: database performance and query performance question, Hannu Krosing
Re: database performance and query performance question, Josh Berkus
Re: database performance and query performance question, Shea,Dan [CIS]
Re: database performance and query performance question, Shea,Dan [CIS]
Re: database performance and query performance question, Josh Berkus
Re: database performance and query performance question, Josh Berkus
database performance and query performance question, Shea,Dan [CIS]
Re: Trigger performance, pginfo
Re: Trigger performance, Tom Lane
Re: Trigger performance, pginfo
Re: Trigger performance, Tom Lane
Function & Update/Insert Problem and Performance, postgres
Trigger performance, pginfo

January 21, 2004

Re: Queries with timestamps, Josh Berkus
Re: Queries with timestamps, Richard Huxton
Re: Queries with timestamps, Josh Berkus
Re: ORDER BY and LIMIT with SubSelects, Bruno Wolff III
Queries with timestamps, Arnau
ORDER BY and LIMIT with SubSelects, Ron St-Pierre
Re: Trigger question, Stephan Szabo
Re: Really slow even after vacuum, Dennis Bjorklund
Re: PostgreSQL vs. Oracle disk space usage, Thierry Missimilly
Really slow even after vacuum, Jeroen Baekelandt
Re: database profiling, Christopher Kings-Lynne

January 20, 2004

database profiling, Orion Henry
Re: Trigger question, Richard Huxton
Re: Trigger question, Tom Lane
Re: Trigger question, Stephan Szabo
Re: Trigger question, Tom Lane
Re: Trigger question, Neil Conway
Re: Trigger question, Richard Huxton
Re: Trigger question, Neil Conway
Re: COUNT & Pagination, Neil Conway

January 19, 2004

Re: Join optimisation Quandry, Tom Lane

January 18, 2004

Re: Join optimisation Quandry, Ceri Storey
Re: Join optimisation Quandry, Ceri Storey
Re: Join optimisation Quandry, Ceri Storey

January 17, 2004

Re: Idle postmaster taking up a lot of CPU, John Siracusa
Re: Idle postmaster taking up a lot of CPU, Tom Lane
Re: Postgres on Netapp, D'Arcy J.M. Cain
Idle postmaster taking up a lot of CPU, John Siracusa
Re: Join optimisation Quandry, Stephan Szabo
Re: Potential Problem with PostgeSQL performance on SuSE, Mark Kirkwood
Re: Potential Problem with PostgeSQL performance on SuSE, Josh Berkus

January 16, 2004

Re: Potential Problem with PostgeSQL performance on SuSE, Mark Kirkwood
Potential Problem with PostgeSQL performance on SuSE Linux 9.0, Josh Berkus
Re: Question about space usage:, Tom Lane
Re: Join optimisation Quandry, Stephan Szabo
Re: subquery and table join, index not use for table, Stephan Szabo
Re: shared_buffer value, scott.marlowe
Re: Postgres on Netapp, Rod Taylor
Re: [PERFORM] Postgres on Netapp, Larry Rosenman
Re: COUNT & Pagination, CoL
Join optimisation Quandry, Ceri Storey
subquery and table join, index not use for table, CoL
Question about space usage:, Jeremy M. Guthrie
100 simultaneous connections, critical limit?, Jón Ragnarsson
Postgres on Netapp, Shankar K
Re: shared_buffer value, Anjan Dave
Re: Trigger question, Chris Travers
Re: 100 simultaneous connections, critical limit?, Thomas Swan
IDE/SCSI disk tools to turn off write caching, Syd
Re: shared_buffer value, Tom Lane
Re: shared_buffer value, Richard Huxton

January 15, 2004

shared_buffer value, Anjan Dave
Re: insert speed - Mac OSX vs Redhat, Syd
Re: Trigger question, Evil Azrael
Re: Weird query speed, Tom Lane
Re: Trigger question, Richard Huxton
Weird query speed, Rigmor Ukuhe
Re: insert speed - Mac OSX vs Redhat, Tom Lane
Trigger question, pginfo
Re: insert speed - Mac OSX vs Redhat, Matt Clark
insert speed - Mac OSX vs Redhat, Syd
Re: 100 simultaneous connections, critical limit?, Andrew McMillan
Re: 100 simultaneous connections, critical limit?, Christopher Kings-Lynne

January 14, 2004

Re: COUNT & Pagination, scott.marlowe
Re: 100 simultaneous connections, critical limit?, scott.marlowe
Re: 100 simultaneous connections, critical limit?, Evil Azrael
Re: COUNT & Pagination, Rajesh Kumar Mallah
Re: 100 simultaneous connections, critical limit?, Adam Alkins
Re: 100 simultaneous connections, critical limit?, scott.marlowe
Re: 100 simultaneous connections, critical limit?, Tom Lane
Re: 100 simultaneous connections, critical limit?, Nick Barr
Re: 100 simultaneous connections, critical limit?, Jón Ragnarsson
Re: 100 simultaneous connections, critical limit?, Christopher Browne
Re: 100 simultaneous connections, critical limit?, Shridhar Daithankar
100 simultaneous connections, critical limit?, Jón Ragnarsson

January 13, 2004

Re: COUNT & Pagination, scott.marlowe
Re: COUNT & Pagination, David Shadovitz
Re: COUNT & Pagination, mallah
Re: freebsd 5.2 and max_connections, Richard Huxton
freebsd 5.2 and max_connections, David Hill
Re: failures on machines using jfs, Greg Spiegelberg
Re: failures on machines using jfs, Bill Moran
Re: failures on machines using jfs, Hannu Krosing
Re: Ignore Some Updates, Tom Lane
Ignore Some Updates, cnliou

January 12, 2004

Re: COUNT & Pagination, Robert Treat
Re: failures on machines using jfs, Greg Spiegelberg
Re: failures on machines using jfs, Hannu Krosing
Re: COUNT & Pagination, David Shadovitz
Re: annoying query/planner choice, Andrew Rawnsley
Re: COUNT & Pagination, Richard Huxton
Re: annoying query/planner choice, Tom Lane
Re: annoying query/planner choice, Christopher Browne
Re: annoying query/planner choice, Andrew Rawnsley
Re: annoying query/planner choice, Dennis Bjorklund
annoying query/planner choice, Andrew Rawnsley
Re: Explain not accurate, Greg Stark
Re: COUNT & Pagination, Christopher Kings-Lynne
Re: Explain not accurate, Christopher Kings-Lynne

January 11, 2004

Re: COUNT & Pagination, Jeff Fitzmyers
Re: Explain not accurate, Dennis Bjorklund
Explain not accurate, Richard van den Berg
Re: optimizing Postgres queries, Rod Taylor
COUNT & Pagination, David Shadovitz
Re: failures on machines using jfs, Tom Lane
Re: failures on machines using jfs, Spiegelberg, Greg
Re: Postgresql on Quad CPU machine, Doug McNaught
Postgresql on Quad CPU machine, D. Dante Lorenso
Re: failures on machines using jfs, Christopher Browne

January 10, 2004

Re: failures on machines using jfs, Robert Creager

January 09, 2004

Re: Slow query problem, Stephan Szabo
Re: Slow query problem, Tom Lane
Re: Slow query problem, Bradley Tate
Re: Slow query problem, Richard Huxton
Re: Slow query problem, Dennis Björklund
Re: Slow query problem, Richard Huxton
Re: Slow query problem, Dennis Björklund
Re: Slow query problem, Tom Lane
Re: Slow query problem, Bruno Wolff III
PostgreSQL vs. Oracle disk space usage, Seum-Lim Gan
Re: Slow query problem, Mike Glover
Slow query problem, Bradley Tate
Re: optimizing Postgres queries, Tom Lane
Re: Select max(foo) and select count(*) optimization, CoL
Re: optimizing Postgres queries, David Teran

January 08, 2004

Re: failures on machines using jfs, Josh Berkus

January 07, 2004

failures on machines using jfs, Andrew Sullivan
Re: Index creation, scott.marlowe
RAID array stripe sizes, Greg Stark
Re: Find original number of rows before applied LIMIT/OFFSET?, Greg Stark
Re: Index creation, Jeff
Find original number of rows before applied LIMIT/OFFSET?, D. Dante Lorenso
Index creation, Eric Jain

January 06, 2004

Re: Select max(foo) and select count(*) optimization, Tom Lane
Re: PgAdmin startup query VERY slow, Tom Lane
Re: Select max(foo) and select count(*) optimization, D'Arcy J.M. Cain
Re: PgAdmin startup query VERY slow, Josh Berkus
Re: PgAdmin startup query VERY slow, Michael Shapiro
Re: PgAdmin startup query VERY slow, Josh Berkus
PgAdmin startup query VERY slow, Michael Shapiro
Re: Select max(foo) and select count(*) optimization, Mark Kirkwood
Re: Inefficient SELECT with OFFSET and LIMIT, Tom Lane
Re: Inefficient SELECT with OFFSET and LIMIT, Greg Stark
Re: Select max(foo) and select count(*) optimization, Shridhar Daithankar
Re: Select max(foo) and select count(*) optimization, Robert Treat
Inefficient SELECT with OFFSET and LIMIT, Clive Page
Re: Select max(foo) and select count(*) optimization, Shridhar Daithankar
Re: Select max(foo) and select count(*) optimization, D'Arcy J.M. Cain
Re: Select max(foo) and select count(*) optimization, Shridhar Daithankar
Re: Select max(foo) and select count(*) optimization, Shridhar Daithankar
Re: optimizing Postgres queries, Bruce Momjian
Re: Select max(foo) and select count(*) optimization, Christopher Browne
Re: Select max(foo) and select count(*) optimization, Christopher Browne
Re: Select max(foo) and select count(*) optimization, Doug McNaught
Re: Select max(foo) and select count(*) optimization, Paul Tuckfield

January 05, 2004

Re: deferred foreign keys, Stephan Szabo
Re: Use my (date) index, darn it!, Christopher Browne
Re: Select max(foo) and select count(*) optimization, Christopher Browne
Re: Select max(foo) and select count(*) optimization, Neil Conway
Re: deferred foreign keys, Rod Taylor
Re: Select max(foo) and select count(*) optimization, John Siracusa
Re: Select max(foo) and select count(*) optimization, Rod Taylor
Re: deferred foreign keys, Stephan Szabo
Re: optimizing Postgres queries, David Teran
Re: optimizing Postgres queries, Tom Lane
Select max(foo) and select count(*) optimization, John Siracusa
Re: optimizing Postgres queries, David Teran
Re: deferred foreign keys, Vivek Khera
Re: deferred foreign keys, Stephan Szabo
Re: deferred foreign keys, Vivek Khera
Re: optimizing Postgres queries, Tom Lane
Re: optimizing Postgres queries, David Teran
Re: deferred foreign keys, Bruno Wolff III
Re: Use my (date) index, darn it!, John Siracusa
Re: Use my (date) index, darn it!, Christopher Browne
Re: deferred foreign keys, Vivek Khera
Re: Use my (date) index, darn it!, Tom Lane
Re: Use my (date) index, darn it!, John Siracusa
Re: optimizing Postgres queries, Tom Lane
Re: optimizing Postgres queries, Christopher Kings-Lynne
Re: optimizing Postgres queries, Shridhar Daithankar
Re: optimizing Postgres queries, David Teran
Re: optimizing Postgres queries, Shridhar Daithankar
Re: optimizing Postgres queries, David Teran
Re: optimizing Postgres queries, Shridhar Daithankar
optimizing Postgres queries, David Teran
Re: Use my (date) index, darn it!, Tom Lane

January 04, 2004

Use my (date) index, darn it!, John Siracusa
Re: Indexing a Boolean or Null column?, Christopher Browne
Re: Indexing a Boolean or Null column?, Tom Lane
Re: Indexing a Boolean or Null column?, Christopher Kings-Lynne
Re: Indexing a Boolean or Null column?, Christopher Kings-Lynne
Re: Indexing a Boolean or Null column?, D. Dante Lorenso
Re: Indexing a Boolean or Null column?, Christopher Kings-Lynne
Re: Indexing a Boolean or Null column?, Tom Lane
Indexing a Boolean or Null column?, D. Dante Lorenso

January 03, 2004

Re: deferred foreign keys, Christopher Kings-Lynne
Re: "fun with multipart primary keys" hobby kit, Chris Trawick
Re: "fun with multipart primary keys" hobby kit, Tom Lane
"fun with multipart primary keys" hobby kit, Chris Trawick
Re: Tuning Techniques To Avoid?, Greg Stark
Re: Why memory is not used ? Why vacuum so slow ?, Hervé Piedvache
Re: Why memory is not used ? Why vacuum so slow ?, Tom Lane
Re: Very slow update + not using clustered index, Tom Lane

January 02, 2004

Re: Why memory is not used ? Why vacuum so slow ?, Tom Lane
Tuning Techniques To Avoid?, Christopher Browne
Why memory is not used ? Why vacuum so slow ?, Hervé Piedvache
Re: Very slow update + not using clustered index, Mike Glover
Re: Very slow update + not using clustered index, Tom Lane
Very slow update + not using clustered index, Mike Glover

January 01, 2004

pg_restore makes disk busy, cnliou

Recently Viewed:
qnx.openqnx.dev... gcc.libstdc++.c... solaris.opensol... information-ret... misc.misterhous... web.catalyst.ge... apache.webservi... redhat.release.... hardware.lirc/2... kernel.autofs/2... technology.sust... linux.vdr/2003-... editors.lyx.gen... org.user-groups... netbsd.devel.pk... xdg.devel/2004-... version-control... jakarta.slide.d... debian.packages... creativecommons... ports.ppc.embed... bug-tracking.bu...

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

Free Magazines

Cisco News
Receive a free quarterly e-newsletter with exclusive articles on how Cisco IT uses its own products and solutions to enable the business.
subscribe

Systems Management News, the newspaper for IT systems administration and data center managers! Each issue of Systems Management News is chock-full of news and analysis to help you understand what's happening in your field.
subscribe

The Enterprise Newsweekly eWeek is the essential technology information source for builders of e-business.
subscribe

Oracle Magazine Oracle Magazine contains technology strategy articles, sample code, tips, Oracle and partner news, how to articles for developers and DBAs, and more. Oracle (NASDAQ: ORCL) is the world's largest enterprise software company.
subscribe

Total Telecom Total Telecom is "The Economist of the communications industry".
subscribe