Архив рассылок [pgsql-performance]
Re: Caching of Queries Matt Clark
inconsistent/weird index usage Dustin Sallings
Re: inconsistent/weird index usage John Meinel
Re: inconsistent/weird index usage Tom Lane
Re: inconsistent/weird index usage Richard Huxton
Re: Caching of Queries Jim C. Nasby
Re: Caching of Queries Matt Clark
Re: inconsistent/weird index usage Josh Berkus
Re: inconsistent/weird index usage Tom Lane
Re: Caching of Queries Aaron Werman
Re: Caching of Queries Josh Berkus
Slow update/insert process Patrick Hatcher
Re: Slow update/insert process Aaron Werman
Re: Caching of Queries Aaron Werman
Re: Caching of Queries Josh Berkus
Re: Caching of Queries William Yu
Query planner problem Ryan VanMiddlesworth
Re: Caching of Queries Josh Berkus
Re: Query planner problem Russell Smith
Re: inconsistent/weird index usage Hannu Krosing
Re: Query planner problem Tom Lane
Re: inconsistent/weird index usage Tom Lane
Re: Caching of Queries Pierre-Frédéric Caillaud
Re: Caching of Queries Pierre-Frédéric Caillaud
Re: Caching of Queries Pierre-Frédéric Caillaud
Re: Caching of Queries Tatsuo Ishii
Re: index not used when using function Pierre-Frédéric Caillaud
Re: Query planner problem Greg Stark
Re: would number of fields in a table affect search-query time? Steinar H. Gunderson
Re: Comparing user attributes with bitwise operators Patrick Clery
Re: Caching of Queries Matt Clark
Excessive context switching on SMP Xeons Bill Montgomery
Re: Excessive context switching on SMP Xeons Josh Berkus
Re: Excessive context switching on SMP Xeons Bill Montgomery
Re: Excessive context switching on SMP Xeons Gaetano Mendola
Re: Excessive context switching on SMP Xeons Josh Berkus
slow rule on update Janning Vygen
Planner picks the wrong plan? Nichlas Löfdahl
test post Max Baker
Re: Planner picks the wrong plan? Tom Lane
Re: Excessive context switching on SMP Xeons Alan Stange
Re: Excessive context switching on SMP Xeons Greg Stark
sequential scan on select distinct Ole Langbehn
stats on cursor and query execution troubleshooting Alban Médici (NetCentrex)
Re: sequential scan on select distinct Pierre-Frédéric Caillaud
Re: Excessive context switching on SMP Xeons Alan Stange
Re: Excessive context switching on SMP Xeons Bill Montgomery
Re: sequential scan on select distinct Ole Langbehn
Re: sequential scan on select distinct Greg Stark
Re: Excessive context switching on SMP Xeons SZUCS Gábor
Re: sequential scan on select distinct Pierre-Frédéric Caillaud
Re: Comparing user attributes with bitwise operators Patrick Clery
Re: Comparing user attributes with bitwise operators Patrick Clery
Re: sequential scan on select distinct Greg Stark
Data warehousing requirements Gabriele Bartolini
Re: Excessive context switching on SMP Xeons Gaetano Mendola
Re: Caching of Queries Tatsuo Ishii
Re: Excessive context switching on SMP Xeons Alan Stange
Re: Caching of Queries Tom Lane
Re: Caching of Queries Tatsuo Ishii
Re: Data warehousing requirements Aaron Werman
Re: sequential scan on select distinct Pierre-Frédéric Caillaud
Re: Excessive context switching on SMP Xeons Bill Montgomery
Re: sequential scan on select distinct Greg Stark
Re: Data warehousing requirements Gabriele Bartolini
Re: sequential scan on select distinct Ole Langbehn
Re: Excessive context switching on SMP Xeons Michael Adler
Re: Excessive context switching on SMP Xeons Alan Stange
Re: Excessive context switching on SMP Xeons Bill Montgomery
Re: Data warehousing requirements Josh Berkus
Re: Data warehousing requirements Aaron Werman
Re: Data warehousing requirements Tom Lane
Re: Data warehousing requirements Josh Berkus
Re: stats on cursor and query execution troubleshooting Alban Médici (NetCentrex)
Re: sequential scan on select distinct Pierre-Frédéric Caillaud
integer[] indexing. Dawid Kuroczko
Re: integer[] indexing. Pierre-Frédéric Caillaud
Re: sequential scan on select distinct Pierre-Frédéric Caillaud
Re: integer[] indexing. Harald Fuchs
Re: integer[] indexing. Tom Lane
Query Tuning Pallav Kalva
Re: Query Tuning Tom Lane
Re: Query Tuning Pallav Kalva
Odd planner choice? Gary Doades
Re: Odd planner choice? Gary Doades
Re: Odd planner choice? Tom Lane
Re: Odd planner choice? Gary Doades
Re: First set of OSDL Shared Mem scalability results, J. Andrew Rogers
Re: First set of OSDL Shared Mem scalability results, Steinar H. Gunderson
Re: First set of OSDL Shared Mem scalability results, some wierdness ... Christopher Browne
kernel 2.6 synchronous directory Gaetano Mendola
Re: First set of OSDL Shared Mem scalability results, some Dennis Bjorklund
Views, joins and LIMIT Dawid Kuroczko
COPY slows down? Mike Harding
EXPLAIN ANALYZE much slower than running query normally Chris Hutchinson
why my query is not using index?? HyunSung Jang
Re: sequential scan on select distinct Mischa Sandberg
Re: why my query is not using index?? Janning Vygen
Re: Views, joins and LIMIT Tom Lane
Re: COPY slows down? Tom Lane
Re: [pgsql-benchmarks] stats on cursor and query execution Alban Médici (NetCentrex)
Re: why my query is not using index?? Francisco Reyes
Understanding explains Francisco Reyes
Normal case or bad query plan? Gabriele Bartolini
Re: why my query is not using index?? Janning Vygen
Re: Normal case or bad query plan? Tom Lane
Re: Understanding explains Rosser Schwarz
TestPerf Project started Josh Berkus
Re: why my query is not using index?? John Meinel
Re: why my query is not using index?? Greg Stark
Re: IBM P-series machines (was: Excessive context Christopher Browne
Re: Normal case or bad query plan? Kris Jurka
Re: why my query is not using index?? Francisco Reyes
Re: Understanding explains Francisco Reyes
Re: Normal case or bad query plan? Gabriele Bartolini
Re: Normal case or bad query plan? Tom Lane
Re: IBM P-series machines Matt Clark
Re: execute cursor fetch my ho
Re: Normal case or bad query plan? Aaron Werman
Re: execute cursor fetch Pierre-Frédéric Caillaud
Re: execute cursor fetch Tom Lane
Re: Normal case or bad query plan? Gabriele Bartolini
Re: Normal case or bad query plan? Steinar H. Gunderson
Which plattform do you recommend I run PostgreSQL for best
performance? nd02tsk@student.hig.se
Re: Which plattform do you recommend I run PostgreSQL for Francisco Reyes
Re: Which plattform do you recommend I run PostgreSQL for best performance? Christopher Browne
Re: Caching of Queries Bruce Momjian
query problem Robin Ericsson
Re: query problem Tom Lane
Re: query problem Robin Ericsson
Free PostgreSQL Training, Philadelphia, Oct 30 Aaron Mulder
Opteron vs RHAT Chris Browne
Re: Free PostgreSQL Training, Philadelphia, Oct 30 Bryan Encina
[Fwd: Re: [GENERAL] query problem] Robin Ericsson
Re: Opteron vs RHAT Matt Clark
futex results with dbt-3 Mark Wong
Re: futex results with dbt-3 Neil Conway
Re: Free PostgreSQL Training, Philadelphia, Oct 30 Bruce Momjian
Re: [pgsql-hackers-win32] Performance on Win32 vs Cygwin Magnus Hagander
Performance vs Schemas Igor Maciel Macaubas
Re: Performance vs Schemas Gregory S. Williamson
Re: Excessive context switching on SMP Xeons Dave Cramer
View & Query Performance Igor Maciel Macaubas
Re: [Testperf-general] Re: First set of OSDL Shared Mem Timothy D. Witham
Re: Performance vs Schemas Neil Conway
Re: First set of OSDL Shared Mem scalability results, some wierdness ... Christopher Browne
Re: View & Query Performance Alban Medici (NetCentrex)
Re: View & Query Performance Richard Huxton
Re: [Testperf-general] Re: First set of OSDL Shared Memscalability results, some wierdness ... Simon Riggs
Re: Select with qualified join condition / Batch inserts Leeuw van der, Tim
Re: Select with qualified join condition / Batch inserts Michael Nonemacher
Re: [pgsql-hackers-win32] Performance on Win32 vs Cygwin Merlin Moncure
Re: [Testperf-general] Re: First set of OSDL Shared Memscalability results, some wierdness ... Tom Lane
Does PostgreSQL run with Oracle? Richard_D_Levine@raytheon.com
Re: Does PostgreSQL run with Oracle? Bruce Momjian
Re: Does PostgreSQL run with Oracle? Steve Atkins
Re: Does PostgreSQL run with Oracle? Tom Lane
Re: Does PostgreSQL run with Oracle? Marc Slemko
Re: [Testperf-general] Re: First set of OSDL Shared Memscalability results, some wierdness ... Simon Riggs
Re: [Testperf-general] Re: First set of OSDL Shared Memscalability results, some wierdness ... Josh Berkus
Re: Does PostgreSQL run with Oracle? Mike Rylander
Re: [Testperf-general] Re: First set of OSDL Shared Memscalability results, some wierdness ... Josh Berkus
Re: [Testperf-general] Re: First set of OSDL Shared Memscalability results, some wierdness ... Tom Lane
Re: [Testperf-general] Re: First set of OSDL Shared Memscalability results, some wierdness ... Josh Berkus
Re: [Testperf-general] Re: First set of OSDL Shared Memscalability results, some wierdness ... Tom Lane
Re: [Testperf-general] Re: First set of OSDL Shared Memscalability results, some wierdness ... Mark Wong
Re: [Testperf-general] Re: First set of OSDL Shared Memscalability results, some wierdness ... Tom Lane
Re: [Testperf-general] Re: First set of OSDL Shared Memscalability results, some wierdness ... Mark Wong
Re: execute cursor fetch Kris Jurka
Indexes performance charavay
Queries slow using stored procedures Rod Dutton
How to time several queries? nd02tsk@student.hig.se
Re: How to time several queries? Joshua D. Drake
Re: Indexes performance Josh Berkus
Re: Indexes performance Tom Lane
Re: Queries slow using stored procedures Alban Medici (NetCentrex)
Why isn't this index being used? Knutsen, Mark
Re: Why isn't this index being used? Knutsen, Mark
Re: Why isn't this index being used? Andrew Sullivan
Index not used in query. Why? Andrei Bintintan
Re: Index not used in query. Why? Tom Lane
Speeding up this function Matt Nuzum
Re: Speeding up this function Jeremy Dunn
Re: Speeding up this function Matt Nuzum
Re: Normal case or bad query plan? Mischa Sandberg
Re: [pgsql-hackers-win32] Performance on Win32 vs Cygwin MikeSmialek2@Hotmail.com
Re: Performance vs Schemas Aaron Werman
Performance on Win32 vs Cygwin MikeSmialek2@Hotmail.com
Re: futex results with dbt-3 Manfred Spraul
Re: futex results with dbt-3 Tom Lane
Re: futex results with dbt-3 Josh Berkus
how much mem to give postgres? Josh Close
Re: futex results with dbt-3 Tom Lane
Re: Select with qualified join condition / Batch inserts Russell Smith
Re: Does PostgreSQL run with Oracle? Greg Sabino Mullane
Re: Speeding up this function Pierre-Frédéric Caillaud
Re: how much mem to give postgres? Simon Riggs
Insert performance, what should I expect? Brock Henry
Re: Insert performance, what should I expect? Matthew T. O'Connor
Re: how much mem to give postgres? Josh Close
Re: how much mem to give postgres? Tom Lane
Re: how much mem to give postgres? Josh Berkus
Re: Insert performance, what should I expect? Andrew McMillan
Re: Free PostgreSQL Training, Philadelphia, Oct 30 Aaron Werman
Re: How to time several queries? nd02tsk@student.hig.se
Re: Which plattform do you recommend I run PostgreSQL nd02tsk@student.hig.se
Re: Free PostgreSQL Training, Philadelphia, Oct 30 Aaron Mulder
OS desicion Tom Fischer
Re: OS desicion Matt Clark
Re: how much mem to give postgres? Josh Close
Re: how much mem to give postgres? Josh Close
Re: how much mem to give postgres? Matt Clark
Re: Index not used in query. Why? Contact AR-SD.NET
Re: How to time several queries? Matthew Nuzum
Re: Index not used in query. Why? Thomas F.O'Connell
Re: OS desicion Josh Berkus
Re: futex results with dbt-3 Mark Wong
Re: Insert performance, what should I expect? Robert Creager
Re: OS desicion Matt Clark
Re: futex results with dbt-3 Tom Lane
Re: how much mem to give postgres? Steve Atkins
Re: how much mem to give postgres? Matt Clark
Re: how much mem to give postgres? Steve Atkins
Re: futex results with dbt-3 Mark Wong
Re: futex results with dbt-3 Dave Cramer
iostat question jelle
Re: create index with substr function Stephan Szabo
Re: create index with substr function Rosser Schwarz
Re: create index with substr function Joshua D. Drake
Re: Free PostgreSQL Training, Philadelphia, Oct 30 Alban Medici (NetCentrex)
Re: Anything to be gained from a 'Postgres Filesystem'? Leeuw van der, Tim
Re: Anything to be gained from a 'Postgres Filesystem'? Pierre-Frédéric Caillaud
Re: Anything to be gained from a 'Postgres Filesystem'? Steinar H. Gunderson
Re: Anything to be gained from a 'Postgres Filesystem'? Leeuw van der, Tim
Re: Anything to be gained from a 'Postgres Filesystem'? Steinar H. Gunderson
Re: futex results with dbt-3 Mark Wong
Re: create index with substr function george young
Simple machine-killing query! Victor Ciurus
Re: Simple machine-killing query! Stephan Szabo
Re: Simple machine-killing query! Aaron Werman
Re: Simple machine-killing query! Tom Lane
Re: Anything to be gained from a 'Postgres Filesystem'? Steinar H. Gunderson
Re: Simple machine-killing query! Victor Ciurus
Re: Simple machine-killing query! Josh Berkus
Re: Anything to be gained from a 'Postgres Filesystem'? Sean Chittenden
Links to OSDL test results up Josh Berkus
Performance Anomalies in 7.4.5 Thomas F.O'Connell
Re: Performance Anomalies in 7.4.5 Thomas F.O'Connell
Re: Performance Anomalies in 7.4.5 Dennis Bjorklund
Re: Performance Anomalies in 7.4.5 Thomas F.O'Connell
Re: Performance Anomalies in 7.4.5 Tom Lane
Re: Does PostgreSQL run with Oracle? Jim C. Nasby
Re: OS desicion Jim C. Nasby
Re: Performance Anomalies in 7.4.5 Gary Doades
Large Database Performance suggestions Joshua Marsh
Re: Large Database Performance suggestions Gavin Sherry
Re: Large Database Performance suggestions Scott Marlowe
Re: Large Database Performance suggestions Dave Cramer
Slow query Roger Ging
Re: Performance Anomalies in 7.4.5 Andrew Sullivan
Re: Slow query Tom Lane
Re: Performance Anomalies in 7.4.5 Matthew T. O'Connor
Re: Insert performance, what should I expect? Gaetano Mendola
Re: Insert performance, what should I expect? Steinar H. Gunderson
Re: futex results with dbt-3 Gaetano Mendola
Re: Slow query Joshua Marsh
Re: futex results with dbt-3 Tom Lane
Re: futex results with dbt-3 Gaetano Mendola
Re: futex results with dbt-3 Gaetano Mendola
Queries slow using stored procedures Rod Dutton
Re: Queries slow using stored procedures John Meinel
Re: Queries slow using stored procedures John Meinel
Re: Queries slow using stored procedures John Meinel
Sequential Scan with LIMIT John Meinel
Re: Sequential Scan with LIMIT Tom Lane
Re: Sequential Scan with LIMIT John Meinel
Reindexdb and REINDEX Rod Dutton
Re: Reindexdb and REINDEX Tom Lane
Re: Sequential Scan with LIMIT Curt Sampson
Re: Sequential Scan with LIMIT Neil Conway
Re: Performance Anomalies in 7.4.5 Andrew Sullivan
Re: Sequential Scan with LIMIT John Meinel
Re: futex results with dbt-3 Manfred Spraul
Re: futex results with dbt-3 Manfred Spraul
Re: futex results with dbt-3 Manfred Spraul
Re: futex results with dbt-3 Manfred Spraul
Re: Performance Anomalies in 7.4.5 Bricklen
different io elevators in linux Bjorn Bength
Re: futex results with dbt-3 Manfred Spraul
Re: futex results with dbt-3 Josh Berkus
Re: futex results with dbt-3 Tom Lane
Re: different io elevators in linux Josh Berkus
Re: futex results with dbt-3 Tom Lane
can't handle large number of INSERT/UPDATEs Anjan Dave
Re: can't handle large number of INSERT/UPDATEs Dustin Sallings
Measuring server performance with psql and pgAdmin Joost Kraaijeveld
Re: Large Database Performance suggestions Joshua Marsh
Re: can't handle large number of INSERT/UPDATEs Josh Berkus
Re: Sequential Scan with LIMIT Jaime Casanova
Re: can't handle large number of INSERT/UPDATEs Andrew McMillan
Re: Sequential Scan with LIMIT John Meinel
Re: can't handle large number of INSERT/UPDATEs Curtis Zinzilieta
Re: [PATCHES] [HACKERS] ARC Memory Usage analysis Thomas F.O'Connell
Re: can't handle large number of INSERT/UPDATEs Josh Berkus
Re: can't handle large number of INSERT/UPDATEs John Meinel
Re: Free PostgreSQL Training, Philadelphia, Oct 30 D'Arcy J.M. Cain
Re: Sequential Scan with LIMIT Jaime Casanova
Re: different io elevators in linux Mark Wong
Re: Performance Anomalies in 7.4.5 Alban Medici (NetCentrex)
Re: Sequential Scan with LIMIT John Meinel
Re: Performance Anomalies in 7.4.5 Josh Berkus
Re: Performance Anomalies in 7.4.5 Tom Lane
Re: Performance Anomalies in 7.4.5 Rod Taylor
Re: Performance Anomalies in 7.4.5 Tom Lane
Re: Sequential Scan with LIMIT Jim C. Nasby
Re: Sequential Scan with LIMIT Tom Lane
Re: Sequential Scan with LIMIT Jim C. Nasby
determining max_fsm_pages Patrick Hatcher
Re: determining max_fsm_pages Tatsuo Ishii
Re: determining max_fsm_pages Tom Lane
Re: can't handle large number of INSERT/UPDATEs Markus Bertheau
Re: futex results with dbt-3 Manfred Spraul
psql large RSS (1.6GB) TTK Ciar
Re: psql large RSS (1.6GB) Dustin Sallings
Re: psql large RSS (1.6GB) Markus Bertheau
Thanks Chariot Solutions brew@theMode.com
Speeding up Gist Index creations mallah@trade-india.com
Re: Speeding up Gist Index creations Josh Berkus