Mailing lists [pgsql-performance]
- Re: load / stress testing Dimitri Fontaine
- Re: Performance 8.4.0 Robert Haas
- select count(idn) is slow (Seq Scan) instead of Bitmap Heap.. why? Adam PAPAI
- Greenplum MapReduce Suvankar Roy
- Why is PostgreSQL so slow on Windows ( Postgres 8.3.7) version parimala
- Performance Monitoring tool mukeshp
- Why is PostgreSQL so slow on Windows ( Postgres 8.3.7) version pari krishnan
- SQL select query becomes slow when using limit (with no offset) Kees van Dieren
- Re: Performance 8.4.0 Stephen Frost
- Re: Performance Monitoring tool Frits Hoogland
- Re: Why is PostgreSQL so slow on Windows ( Postgres 8.3.7) version PFC
- Re: Why is PostgreSQL so slow on Windows ( Postgres 8.3.7) version Euler Taveira de Oliveira
- FW: Performance 8.4.0 Chris Dunn
- Re: Greenplum MapReduce Chris
- Re: FW: Performance 8.4.0 Robert Haas
- Re: Greenplum MapReduce Richard Huxton
- Re: Greenplum MapReduce Richard Huxton
- Re: Why is PostgreSQL so slow on Windows ( Postgres 8.3.7) version Grzegorz Jaśkiewicz
- Re: Why is PostgreSQL so slow on Windows ( Postgres 8.3.7) version Marc Cousin
- Re: PostgreSQL 8.4 performance tuning questions Scott Carey
- Query help Subbiah Stalin-XCGF84
- Re: PostgreSQL 8.4 performance tuning questions Tom Lane
- Re: PostgreSQL 8.4 performance tuning questions Scott Carey
- Re: Query help Kevin Grittner
- Re: PostgreSQL 8.4 performance tuning questions PFC
- Re: Query help Subbiah Stalin-XCGF84
- Re: Query help Kevin Grittner
- Re: PostgreSQL 8.4 performance tuning questions Merlin Moncure
- Re: Query help Subbiah Stalin-XCGF84
- Re: PostgreSQL 8.4 performance tuning questions PFC
- Re: Greenplum MapReduce Suvankar Roy
- Re: Greenplum MapReduce Suvankar Roy
- Re: PostgreSQL 8.4 performance tuning questions Merlin Moncure
- Re: select count(idn) is slow (Seq Scan) instead of Bitmap Heap.. why? Robert Haas
- Re: PostgreSQL 8.4 performance tuning questions Alvaro Herrera
- Re: Query help Kevin Grittner
- GiST, caching, and consistency Matthew Wakeling
- Re: Query help Subbiah Stalin-XCGF84
- Re: PostgreSQL 8.4 performance tuning questions Scott Carey
- Re: PostgreSQL 8.4 performance tuning questions Tom Lane
- postgresql and syslog Ibrahim Harrani
- Re: GiST, caching, and consistency Robert Haas
- CHECK constraint fails when it's not supposed to Richard Yen
- Re: GiST, caching, and consistency Greg Stark
- Re: CHECK constraint fails when it's not supposed to Greg Stark
- CHECK constraint fails when it's not supposed to richyen
- Re: SQL select query becomes slow when using limit (with no offset) Kees van Dieren
- Re: GiST, caching, and consistency Matthew Wakeling
- Re: SQL select query becomes slow when using limit (with no offset) Russell Smith
- Re: GiST, caching, and consistency Robert Haas
- Re: GiST, caching, and consistency Matthew Wakeling
- Re: GiST, caching, and consistency Tom Lane
- Re: PostgreSQL 8.4 performance tuning questions Merlin Moncure
- Re: PostgreSQL 8.4 performance tuning questions Scott Carey
- Re: Query help Subbiah Stalin-XCGF84
- Re: Query help Scott Carey
- Re: Query help Kevin Grittner
- Bottleneck? Ip Wing Kin John
- Re: Bottleneck? Scott Marlowe
- Re: Bottleneck? wkipjohn@gmail.com
- Re: Bottleneck? Scott Marlowe
- Re: Bottleneck? wkipjohn@gmail.com
- Re: Bottleneck? wkipjohn@gmail.com
- Re: Bottleneck? Scott Marlowe
- Re: Bottleneck? Ip Wing Kin John
- Re: Bottleneck? Scott Marlowe
- Re: Bottleneck? Ray Stell
- Re: Bottleneck? Tom Lane
- Re: Bottleneck? Ray Stell
- Re: Bottleneck? Kenneth Cox
- Re: Bottleneck? Joshua D. Drake
- Re: Bottleneck? Ray Stell
- Re: Bottleneck? Joshua D. Drake
- Best settings to load a fresh database Campbell, Lance
- Re: Best settings to load a fresh database Scott Marlowe
- Re: Best settings to load a fresh database Kenneth Marshall
- Re: postgresql and syslog Robert Haas
- Re: Bottleneck? Joshua D. Drake
- Re: Bottleneck? Joshua D. Drake
- Re: Best settings to load a fresh database Euler Taveira de Oliveira
- Re: SQL select query becomes slow when using limit (with no offset) Kees van Dieren
- Re: SQL select query becomes slow when using limit (with no offset) Robert Haas
- Re: postgresql and syslog Michael Nacos
- Re: postgresql and syslog Alvaro Herrera
- Re: SQL select query becomes slow when using limit (with no offset) Scott Carey
- Need suggestions on kernel settings for dedicated FreeBSD/Postgresql machine Culley Harrelson
- PG-related ACM Article: "The Pathologies of Big Data" Josh Kupershmidt
- Re: PG-related ACM Article: "The Pathologies of Big Data" Greg Stark
- Re: PG-related ACM Article: "The Pathologies of Big Data" Scott Marlowe
- Re: PG-related ACM Article: "The Pathologies of Big Data" Scott Marlowe
- Re: PG-related ACM Article: "The Pathologies of Big Data" Scott Carey
- Re: PG-related ACM Article: "The Pathologies of Big Data" Scott Marlowe
- Re: SQL select query becomes slow when using limit (with no offset) Robert Haas
- Re: [BUGS] BUG #4919: CREATE USER command slows down system performance Bruce Momjian
- ORDER BY ... LIMIT and JOIN Fizu
- Re: PG-related ACM Article: "The Pathologies of Big Data" Pierre Frédéric Caillaud
- Re: [BUGS] BUG #4919: CREATE USER command slows down system performance Tom Lane
- Re: ORDER BY ... LIMIT and JOIN Michael Andreen
- Re: [BUGS] BUG #4919: CREATE USER command slows down system performance Alvaro Herrera
- Re: [BUGS] BUG #4919: CREATE USER command slows down system performance Tom Lane
- Re: [BUGS] BUG #4919: CREATE USER command slows down system performance Tom Lane
- Re: [BUGS] BUG #4919: CREATE USER command slows down system performance Alvaro Herrera
- Re: [BUGS] BUG #4919: CREATE USER command slows down system performance Tom Lane
- Re: [BUGS] BUG #4919: CREATE USER command slows down system performance Alvaro Herrera
- Re: [BUGS] BUG #4919: CREATE USER command slows down system performance Tom Lane
- Re: [BUGS] BUG #4919: CREATE USER command slows down system performance Bruce Momjian
- Re: Need suggestions on kernel settings for dedicated FreeBSD/Postgresql machine Robert Haas
- Re: Need suggestions on kernel settings for dedicated FreeBSD/Postgresql machine Culley Harrelson
- Re: ORDER BY ... LIMIT and JOIN Fizu
- Re: ORDER BY ... LIMIT and JOIN Michael Andreen
- Re: ORDER BY ... LIMIT and JOIN Robert Haas
- Re: Bottleneck? Ip Wing Kin John
- Re: Bottleneck? Scott Marlowe
- Re: Bottleneck? Robert Haas
- Re: SQL select query becomes slow when using limit (with no offset) Kevin Grittner
- Re: SQL select query becomes slow when using limit (with no offset) Robert Haas
- Re: SQL select query becomes slow when using limit (with no offset) Devin Ben-Hur
- Why is vacuum_freeze_min_age 100m? Josh Berkus
- Re: Why is vacuum_freeze_min_age 100m? Josh Berkus
- Re: Why is vacuum_freeze_min_age 100m? Robert Haas
- Re: Why is vacuum_freeze_min_age 100m? Josh Berkus
- Re: Why is vacuum_freeze_min_age 100m? Tom Lane
- Re: Why is vacuum_freeze_min_age 100m? Robert Haas
- transaction delays to apply Nickolay
- Re: Why is vacuum_freeze_min_age 100m? Kevin Grittner
- Re: Why is vacuum_freeze_min_age 100m? Tom Lane
- Re: transaction delays to apply Pierre Frédéric Caillaud
- Re: Why is vacuum_freeze_min_age 100m? Kevin Grittner
- Re: transaction delays to apply Tom Lane
- Re: Why is vacuum_freeze_min_age 100m? Tom Lane
- Re: Why is vacuum_freeze_min_age 100m? Robert Haas
- Re: Why is vacuum_freeze_min_age 100m? Torsten Zühlsdorff
- Re: transaction delays to apply Nickolay
- Re: transaction delays to apply Nickolay
- How to run this in reasonable time: Matthew Wakeling
- Re: How to run this in reasonable time: Greg Stark
- Re: Why is vacuum_freeze_min_age 100m? Kevin Grittner
- Re: How to run this in reasonable time: Matthew Wakeling
- Under the hood of views David Kerr
- Re: Under the hood of views Richard Huxton
- Less expensive proprietary or Open source ETL tools Rstat
- Memory usage of writer process Alex
- Re: Memory usage of writer process Alvaro Herrera
- Re: Why is vacuum_freeze_min_age 100m? Josh Berkus
- freezing tuples ( was: Why is vacuum_freeze_min_age 100m? ) Jeff Davis
- Re: Memory usage of writer process Scott Carey
- Re: [HACKERS] freezing tuples ( was: Why is vacuum_freeze_min_age 100m? ) Alvaro Herrera
- Re: [HACKERS] freezing tuples ( was: Why is vacuum_freeze_min_age100m? ) Kevin Grittner
- Re: [HACKERS] freezing tuples ( was: Why is vacuum_freeze_min_age 100m? ) Robert Haas
- Re: Re: [HACKERS] freezing tuples ( was: Why is vacuum_freeze_min_age 100m? ) Josh Berkus
- Re: Under the hood of views David Kerr
- Re: Under the hood of views Greg Stark
- Re: Why is vacuum_freeze_min_age 100m? Robert Haas
- Memory reporting on CentOS Linux Jeremy Carroll
- Re: Memory reporting on CentOS Linux Reid Thompson
- Re: Memory reporting on CentOS Linux Jeremy Carroll
- Re: Memory reporting on CentOS Linux Scott Marlowe
- Re: Memory reporting on CentOS Linux Scott Marlowe
- Re: Memory reporting on CentOS Linux Scott Carey
- Per-database warm standby? Craig James
- Re: Per-database warm standby? Tom Lane
- Re: Per-database warm standby? Alvaro Herrera
- Re: Memory usage of writer process Alex Neth
- Re: Scalability in postgres Jeff Janes
- Re: Scalability in postgres Tom Lane
- Re: Memory reporting on CentOS Linux Jeremy Carroll
- Re: Memory reporting on CentOS Linux Tom Lane
- Re: Memory reporting on CentOS Linux Jeremy Carroll
- Re: Memory reporting on CentOS Linux Mark Mielke
- Re: Memory reporting on CentOS Linux Robert Haas
- Re: Per-database warm standby? Nickolay
- Re: Scalability in postgres simon@2ndquadrant.com
- Re: Less expensive proprietary or Open source ETL tools Jean-Max Reymond
- Re: Scalability in postgres Jeff Janes
- Re: Memory reporting on CentOS Linux Matthew Wakeling
- Getting time of a postgresql-request Kai Behncke
- Re: Memory reporting on CentOS Linux Jeremy Carroll
- number of rows estimation for bit-AND operation Slava Moudry
- Re: Memory reporting on CentOS Linux Scott Carey
- Re: Memory reporting on CentOS Linux Scott Carey
- Re: Getting time of a postgresql-request Russell Smith
- Re: Memory reporting on CentOS Linux Greg Smith
- Re: number of rows estimation for bit-AND operation Scott Marlowe
- Re: Getting time of a postgresql-request Pierre Frédéric Caillaud
- Weird index or sort behaviour Matthew Wakeling
- Re: Need suggestions on kernel settings for dedicated FreeBSD/Postgresql machine Ivan Voras
- Re: Weird index or sort behaviour Tom Lane
- Re: Weird index or sort behaviour Matthew Wakeling
- Re: Weird index or sort behaviour Tom Lane
- Re: Weird index or sort behaviour Tom Lane
- Re: Weird index or sort behaviour Greg Stark
- Re: Weird index or sort behaviour Tom Lane
- Re: Weird index or sort behaviour Matthew Wakeling
- Re: Weird index or sort behaviour Tom Lane
- SQL Query Performance - what gives? Karl Denninger
- Re: SQL Query Performance - what gives? Kevin Grittner
- Re: SQL Query Performance - what gives? Karl Denninger
- Re: number of rows estimation for bit-AND operation Scott Marlowe
- Re: SQL Query Performance - what gives? Kevin Grittner
- Re: number of rows estimation for bit-AND operation Scott Marlowe
- Re: number of rows estimation for bit-AND operation Slava Moudry
- Re: number of rows estimation for bit-AND operation Slava Moudry
- Re: SQL Query Performance - what gives? Karl Denninger
- Re: [SQL] SQL Query Performance - what gives? Tom Lane
- Re: [SQL] SQL Query Performance - what gives? Karl Denninger
- Re: [SQL] SQL Query Performance - what gives? Pierre Frédéric Caillaud
- Re: SQL Query Performance - what gives? Ivan Voras
- Re: Weird index or sort behaviour Matthew Wakeling
- PG 8.3 and server load Phoenix Kiula
- Re: PG 8.3 and server load Ivan Voras
- Re: PG 8.3 and server load Guillaume Cottenceau
- Re: PG 8.3 and server load Andy Colson
- Re: PG 8.3 and server load Karl Denninger
- Re: PG 8.3 and server load Andy Colson
- Re: PG 8.3 and server load Phoenix Kiula
- Re: PG 8.3 and server load Kevin Grittner
- Re: PG 8.3 and server load Andy Colson
- Re: PG 8.3 and server load Matthew Wakeling
- Re: PG 8.3 and server load Phoenix Kiula
- Re: PG 8.3 and server load Andy Colson
- Re: PG 8.3 and server load Tom Lane
- Re: PG 8.3 and server load Guillaume Cottenceau
- Re: PG 8.3 and server load Scott Marlowe
- Query tuning Kevin Kempter
- Re: Query tuning Grzegorz Jaśkiewicz
- Re: Query tuning Scott Carey
- Re: Query tuning Nikolas Everett
- Re: Query tuning Kevin Kempter
- Re: Query tuning Kevin Kempter
- [PERFORMANCE] how to set wal_buffers Jaime Casanova
- [PERFORMANCE] work_mem vs temp files issue Jaime Casanova
- Number of tables Fabio La Farcioli
- Re: Number of tables Jochen Erwied
- Re: Number of tables Craig Ringer
- Re: Number of tables Fabio La Farcioli
- Re: Query tuning Віталій Тимчишин
- Re: PG 8.3 and server load Ivan Voras
- Re: number of rows estimation for bit-AND operation Robert Haas
- Re: Number of tables Craig James
- Re: Number of tables Greg Stark
- Re: Number of tables Craig James
- improving my query plan Kevin Kempter
- Re: Number of tables Greg Stark
- Re: Number of tables Alvaro Herrera
- Re: Number of tables Greg Stark
- Re: improving my query plan Chris
- Re: number of rows estimation for bit-AND operation Scott Marlowe
- Re: improving my query plan Scott Carey
- limiting results makes the query slower Jaime Casanova
- Re: number of rows estimation for bit-AND operation Scott Marlowe
- Re: number of rows estimation for bit-AND operation Slava Moudry
- [PERFORMANCE] how to set wal_buffers Jeff Janes
- Performance regression between 8.3 and 8.4 on heavy text indexing gael@pilotsystems.net (Gaël Le Mignot)
- Re: number of rows estimation for bit-AND operation Robert Haas
- Re: number of rows estimation for bit-AND operation Alvaro Herrera
- Re: Number of tables Jerry Champlin
- Re: number of rows estimation for bit-AND operation Slava Moudry
- Re: Number of tables Robert Haas
- Re: Performance regression between 8.3 and 8.4 on heavy text indexing Guillaume Smet
- Re: [PERFORMANCE] how to set wal_buffers Jaime Casanova
- Re: limiting results makes the query slower Robert Haas
- Re: [PERFORMANCE] how to set wal_buffers Jeff Janes
- postgresql uses Hash-join, i need Nested-loop Gábor Farkas
- Re: Number of tables Kevin Grittner
- Re: postgresql uses Hash-join, i need Nested-loop Tom Lane
- Re: improving my query plan Kevin Grittner
- Indexing on a circle datatype Gavin Love
- Re: Indexing on a circle datatype Matthew Wakeling
- Re: Indexing on a circle datatype Tom Lane
- Re: Indexing on a circle datatype Gavin Love
- Fwd: How to create a multi-column index with 2 dates using 'gist'? Fred Janon
- Re: [PERFORMANCE] how to set wal_buffers Jaime Casanova
- Re: Fwd: How to create a multi-column index with 2 dates using 'gist'? Matthew Wakeling
- PostgreSQL does CAST implicitely between int and a domain derived from int Jean-Michel Pouré
- Re: PostgreSQL does CAST implicitely between int and a domain derivedfrom int Kevin Grittner
- Re: Performance regression between 8.3 and 8.4 on heavy text indexing gael@pilotsystems.net (Gaël Le Mignot)
- Re: Performance regression between 8.3 and 8.4 on heavy text indexing Tom Lane
- Performance issues with large amounts of time-series data Hrishikesh (हृषीकेश मेहेंदळे)
- Re: Performance issues with large amounts of time-series data Tom Lane
- Re: Performance issues with large amounts of time-series data Hrishikesh (हृषीकेश मेहेंदळे)
- Re: Performance issues with large amounts of time-series data Tom Lane
- Re: Performance issues with large amounts of time-series data Greg Stark
- Re: Performance regression between 8.3 and 8.4 on heavy text indexing Guillaume Smet
- Re: PostgreSQL does CAST implicitely between int and a domain derived from int Kevin Grittner
- Re: PostgreSQL does CAST implicitely between int and a domain derived from int Kevin Grittner
- Re: PostgreSQL does CAST implicitely between int and a domain derived from int Jean-Michel Pouré
- Re: PostgreSQL does CAST implicitely between int and a domain derived from int Jean-Michel Pouré
- Re: PostgreSQL does CAST implicitely between int and adomain derived from int Kevin Grittner
- Re: PostgreSQL does CAST implicitely between int and adomain derived from int Jean-Michel Pouré
- Re: PostgreSQL does CAST implicitely between int and adomain derived from int Kevin Grittner
- Re: PostgreSQL does CAST implicitely between int and adomain derived from int Jean-Michel Pouré
- Re: PostgreSQL does CAST implicitely between int andadomain derived from int Kevin Grittner
- Re: PostgreSQL does CAST implicitely between int andadomain derived from int Jean-Michel Pouré
- Re: PostgreSQL does CAST implicitely between int and a domain derived from int Kevin Grittner
- Re: PostgreSQL Jean-Michel Pouré
- Re: PostgreSQL does CAST implicitely between int and a domain derived from int Robert Haas
- Re: PostgreSQL does CAST implicitely between int and a domain derived from int Tom Lane
- Re: Performance regression between 8.3 and 8.4 on heavy text indexing gael@pilotsystems.net (Gaël Le Mignot)
- Re: Performance regression between 8.3 and 8.4 on heavy text indexing Guillaume Smet
- Re: PostgreSQL does CAST implicitely between int and a domain derived from int Jean-Michel Pouré
- Re: PostgreSQL does CAST implicitely between int and a domain derived from int Jean-Michel Pouré
- Re: Performance issues with large amounts of time-series data Greg Smith
- Vacuum duration + hint bits? bricklen
- Re: Vacuum duration + hint bits? Tom Lane
- Re: Vacuum duration + hint bits? bricklen
- What exactly is postgres doing during INSERT/UPDATE ? Joseph S
- Re: What exactly is postgres doing during INSERT/UPDATE ? Pierre Frédéric Caillaud
- Re: What exactly is postgres doing during INSERT/UPDATE ? Greg Smith
- Re: What exactly is postgres doing during INSERT/UPDATE ? Scott Marlowe
- Re: What exactly is postgres doing during INSERT/UPDATE ? Joseph S
- Re: What exactly is postgres doing during INSERT/UPDATE ? Joseph S
- Memory monitoring tool Jean-Michel Pouré
- Re: Memory monitoring tool Josh Berkus
- Re: What exactly is postgres doing during INSERT/UPDATE ? Jeff Janes
- Re: What exactly is postgres doing during INSERT/UPDATE ? Luke Koops
- Re: What exactly is postgres doing during INSERT/UPDATE ? Greg Stark
- Re: What exactly is postgres doing during INSERT/UPDATE ? Merlin Moncure
- Re: What exactly is postgres doing during INSERT/UPDATE ? Scott Marlowe
- Re: PostgreSQL does CAST implicitely between int and a domain derived from int Bruce Momjian
- Re: PostgreSQL does CAST implicitely between int and a domain derived from int Jean-Michel Pouré
- Re: PostgreSQL does CAST implicitely between int and a domain derived from int Tom Lane
- Re: What exactly is postgres doing during INSERT/UPDATE ? David Rees
- Re: PostgreSQL does CAST implicitely between int and a domain derived from int Jean-Michel Pouré
- Re: PostgreSQL does CAST implicitely between int and a domain derived from int Tom Lane
- Re: PostgreSQL does CAST implicitely between int and a domain derived from int Greg Stark
- Re: What exactly is postgres doing during INSERT/UPDATE ? Jeff Janes
- Re: What exactly is postgres doing during INSERT/UPDATE ? Merlin Moncure
- Re: What exactly is postgres doing during INSERT/UPDATE ? Greg Stark
- Re: What exactly is postgres doing during INSERT/UPDATE ? Mark Mielke
- Re: What exactly is postgres doing during INSERT/UPDATE ? Joseph S
- Re: What exactly is postgres doing during INSERT/UPDATE ? Merlin Moncure
- Re: What exactly is postgres doing during INSERT/UPDATE ? Greg Stark
- Re: What exactly is postgres doing during INSERT/UPDATE ? Merlin Moncure
- Re: What exactly is postgres doing during INSERT/UPDATE ? Aidan Van Dyk
- Re: What exactly is postgres doing during INSERT/UPDATE ? Jeff Janes
- Re: What exactly is postgres doing during INSERT/UPDATE ? Kevin Grittner
- Re: What exactly is postgres doing during INSERT/UPDATE ? Scott Marlowe