Mailing lists [pgsql-performance]

1 August 2012

• 05:33   Re: pg_dump and thousands of schemas Hugo
• 16:42   Re: Using ctid column changes plan drastically Kevin Grittner

2 August 2012

• 14:55   query using incorrect index Russell Keane
• 18:02   [repost] Help me develop new commit_delay advice Peter Geoghegan
• 20:13   Re: query using incorrect index Kevin Grittner

3 August 2012

• 09:18   Re: query using incorrect index Robert Klemme
• 09:50   Re: query using incorrect index Russell Keane
• 10:00   Re: query using incorrect index Russell Keane
• 14:33   Re: query using incorrect index Kevin Grittner
• 15:58   Re: query using incorrect index Russell Keane
• 16:14   Postgresql - performance of using array in big database roberthanco@o2.pl
• 17:21   Re: [ADMIN] Messed up time zones Laszlo Nagy
• 18:26   Re: [ADMIN] Messed up time zones Steve Crawford
• 18:40   Re: [ADMIN] Messed up time zones Laszlo Nagy
• 22:30   Re: Linux memory zone reclaim Josh Berkus
• 23:02   Re: Linux memory zone reclaim Scott Marlowe
• 23:15   Re: Linux memory zone reclaim Josh Berkus

4 August 2012

• 00:38   slow query, different plans Midge Brown
• 01:31   Re: slow query, different plans Greg Williamson
• 06:27   Re: slow query, different plans Tom Lane

6 August 2012

• 14:10   Re: Postgres 9.1.4 - high stats collector IO usage Magnus Hagander
• 14:17   Re: Postgres 9.1.4 - high stats collector IO usage Pavel Stehule
• 14:19   Re: Postgres 9.1.4 - high stats collector IO usage Magnus Hagander
• 14:44   Re: Postgres 9.1.4 - high stats collector IO usage Pavel Stehule
• 15:08   Sequential scan instead of index scan Ioannis Anagnostopoulos
• 15:17   Re: Sequential scan instead of index scan David Barton
• 15:25   Re: Sequential scan instead of index scan Ioannis Anagnostopoulos
• 15:34   Re: Sequential scan instead of index scan Tom Lane
• 17:43   Re: slow query, different plans Midge Brown
• 18:37   Re: slow query, different plans Midge Brown
• 22:04   Re: Sequential scan instead of index scan Ioannis Anagnostopoulos

7 August 2012

• 03:13   Re: Sequential scan instead of index scan Tom Lane
• 12:01   Slow query: Select all buildings that have >1 pharmacies and >1 schools within 1000m Stefan Keller
• 12:18   Re: Slow query: Select all buildings that have >1 pharmacies and >1 schools within 1000m Tomas Vondra
• 12:18   Re: Sequential scan instead of index scan Ioannis Anagnostopoulos
• 12:23   Re: Slow query: Select all buildings that have >1 pharmacies and >1 schools within 1000m Stefan Keller
• 13:57   Re: Slow query: Select all buildings that have >1 pharmacies and >1 schools within 1000m Tomas Vondra
• 14:38   Re: Slow query: Select all buildings that have >1 pharmacies and >1 schools within 1000m Craig James
• 16:01   Re: Sequential scan instead of index scan Jeff Janes
• 16:07   Re: Sequential scan instead of index scan Ioannis Anagnostopoulos
• 17:42   Re: Sequential scan instead of index scan Jeff Janes
• 18:50   Is drop/restore trigger transactional? Craig James
• 20:15   Re: Is drop/restore trigger transactional? Merlin Moncure
• 20:40   Re: Is drop/restore trigger transactional? Scott Marlowe
• 20:45   Re: Is drop/restore trigger transactional? Jeff Janes
• 21:21   Re: Is drop/restore trigger transactional? Merlin Moncure
• 21:40   Re: Is drop/restore trigger transactional? Craig James
• 22:01   Re: Is drop/restore trigger transactional? Samuel Gendler
• 22:02   Re: Is drop/restore trigger transactional? Merlin Moncure
• 22:23   Re: Is drop/restore trigger transactional? Jeff Janes
• 22:47   Re: Is drop/restore trigger transactional? Craig James

8 August 2012

• 00:08   Re: Slow query: Select all buildings that have >1 pharmacies and >1 schools within 1000m Stefan Keller
• 00:29   Re: Is drop/restore trigger transactional? Craig Ringer
• 00:42   Re: Is drop/restore trigger transactional? Merlin Moncure
• 00:50   Re: Slow query: Select all buildings that have >1 pharmacies and >1 schools within 1000m Jeff Janes
• 06:11   =?UTF-8?Q?Postgresql_-_performance_of_using?= =?UTF-8?Q?_array_in_big_database?= roberthanco@o2.pl
• 06:11   Postgres Upgrade from 8.4 to 9.1 Rajiv Kasera
• 06:33   Re: Postgresql - performance of using array in big database Craig Ringer
• 06:50   Re: Postgres Upgrade from 8.4 to 9.1 Craig Ringer

9 August 2012

• 00:18   Re: Postgresql - performance of using array in big database Ondrej Ivanič
• 11:00   Re: Slow query: Select all buildings that have >1 pharmacies and >1 schools within 1000m Stefan Keller
• 16:17   Re: Slow query: Select all buildings that have >1 pharmacies and >1 schools within 1000m Jeff Janes
• 18:07   Re: DELETE vs TRUNCATE explanation Jeff Janes

10 August 2012

• 23:13   Re: query overhead Jeff Janes

11 August 2012

• 01:16   Index Bloat Problem Strahinja Kustudić
• 12:30   Re: Index Bloat Problem hubert depesz lubaczewski
• 17:10   Increasing WAL usage followed by sudden drop Joseph Marlin
• 17:16   Re: Is drop/restore trigger transactional? Matheus de Oliveira
• 17:23   Improve DB Size / Performance with Table Refactoring Anthony Presley

13 August 2012

• 00:23   Re: Postgres 9.1.4 - high stats collector IO usage Jeff Janes
• 01:42   Re: Deferred constraints performance impact ? Jeff Davis
• 05:17   Re: Postgres 9.1.4 - high stats collector IO usage David Barton
• 11:33   Re: Deferred constraints performance impact ? Robert Klemme
• 22:40   Re: Postgres 9.1.4 - high stats collector IO usage Jeff Janes

14 August 2012

• 01:52   Re: Index Bloat Problem Mark Kirkwood
• 04:09   Re: Increasing WAL usage followed by sudden drop Josh Berkus
• 04:15   7k records into Sort node, 4.5m out? Christophe Pettus
• 04:35   Re: 7k records into Sort node, 4.5m out? Tomas Vondra
• 04:48   Re: 7k records into Sort node, 4.5m out? Christophe Pettus
• 05:11   Re: 7k records into Sort node, 4.5m out? Tom Lane
• 07:14   Re: Index Bloat Problem Jeff Janes
• 18:27   cluster on conditional index? Doug Hunley
• 20:10   Re: cluster on conditional index? Jeff Janes
• 20:29   Re: cluster on conditional index? ktm@rice.edu

15 August 2012

• 16:43   Re: cluster on conditional index? Doug Hunley
• 22:13   Re: 7k records into Sort node, 4.5m out? Christophe Pettus
• 23:51   Re: 7k records into Sort node, 4.5m out? Tom Lane

16 August 2012

• 00:02   Re: 7k records into Sort node, 4.5m out? Josh Berkus
• 00:05   Re: cluster on conditional index? Josh Berkus
• 00:19   Re: cluster on conditional index? Bosco Rama
• 00:44   Re: 7k records into Sort node, 4.5m out? Tom Lane
• 03:25   Re: 7k records into Sort node, 4.5m out? Josh Berkus
• 06:23   High Disk write and space taken by PostgreSQL J Ramesh Kumar
• 06:37   Re: High Disk write and space taken by PostgreSQL David Barton
• 07:30   Re: High Disk write and space taken by PostgreSQL J Ramesh Kumar
• 07:39   Re: High Disk write and space taken by PostgreSQL Scott Marlowe
• 08:40   Re: High Disk write and space taken by PostgreSQL J Ramesh Kumar
• 08:41   Re: High Disk write and space taken by PostgreSQL Claudio Freire
• 08:49   Re: High Disk write and space taken by PostgreSQL Ondrej Ivanič
• 08:50   Re: High Disk write and space taken by PostgreSQL Claudio Freire
• 09:01   Re: 7k records into Sort node, 4.5m out? Tom Lane
• 17:53   Re: High Disk write and space taken by PostgreSQL Bruce Momjian
• 17:56   Re: High Disk write and space taken by PostgreSQL Bruce Momjian
• 18:25   Re: cluster on conditional index? Doug Hunley
• 18:49   Re: High Disk write and space taken by PostgreSQL Scott Marlowe
• 19:04   Re: cluster on conditional index? Jeff Janes
• 19:07   Re: High Disk write and space taken by PostgreSQL anarazel@anarazel.de
• 19:16   Re: cluster on conditional index? Jeff Janes
• 19:23   Re: High Disk write and space taken by PostgreSQL Bruce Momjian
• 19:31   Re: Increasing WAL usage followed by sudden drop delongboy
• 19:40   Re: Increasing WAL usage followed by sudden drop Kevin Grittner
• 22:58   Re: Index Bloat Problem Strahinja Kustudić
• 23:34   best practice to avoid table bloat? Anibal David Acosta
• 23:48   Re: best practice to avoid table bloat? Andrew Dunstan
• 23:52   Re: best practice to avoid table bloat? Kevin Grittner

17 August 2012

• 00:10   Re: best practice to avoid table bloat? Anibal David Acosta
• 00:39   Re: best practice to avoid table bloat? Kevin Grittner
• 01:38   Re: High Disk write and space taken by PostgreSQL Merlin Moncure
• 10:54   Re: Odd blocking (or massively latent) issue - even with EXPLAIN Jim Vanns
• 18:01   Re: Increasing WAL usage followed by sudden drop Joshua Berkus
• 20:53   Re: Increasing WAL usage followed by sudden drop delongboy
• 21:42   Re: Increasing WAL usage followed by sudden drop Jeff Janes

18 August 2012

• 05:33   Re: Index Bloat Problem Jeff Janes
• 11:01   Re: Index Bloat Problem Greg Williamson

19 August 2012

• 22:53   Re: 7k records into Sort node, 4.5m out? Josh Berkus

20 August 2012

• 18:40   Re: 7k records into Sort node, 4.5m out? Tom Lane
• 20:47   Re: 7k records into Sort node, 4.5m out? Josh Berkus
• 23:51   Re: Increasing WAL usage followed by sudden drop delongboy

21 August 2012

• 02:32   Does setval(nextval()+N) generate unique blocks of IDs? Craig James
• 03:10   Re: Does setval(nextval()+N) generate unique blocks of IDs? Tom Lane
• 03:59   Re: Does setval(nextval()+N) generate unique blocks of IDs? Scott Marlowe
• 04:06   Re: Does setval(nextval()+N) generate unique blocks of IDs? Scott Marlowe
• 10:41   Re: Does setval(nextval()+N) generate unique blocks of IDs? Scott Marlowe
• 10:45   Re: Does setval(nextval()+N) generate unique blocks of IDs? Scott Marlowe
• 17:13   Re: Does setval(nextval()+N) generate unique blocks of IDs? Merlin Moncure
• 17:36   Re: Does setval(nextval()+N) generate unique blocks of IDs? Craig James
• 18:32   Re: Does setval(nextval()+N) generate unique blocks of IDs? Craig James
• 20:53   Re: Does setval(nextval()+N) generate unique blocks of IDs? Merlin Moncure
• 21:35   average query performance measuring Rick Otten
• 21:53   Re: average query performance measuring Stephen Frost
• 22:48   Re: average query performance measuring Karl Denninger
• 23:03   Re: Does setval(nextval()+N) generate unique blocks of IDs? Scott Marlowe
• 23:05   Re: Does setval(nextval()+N) generate unique blocks of IDs? Scott Marlowe
• 23:27   Re: average query performance measuring Stephen Frost
• 23:59   Re: Does setval(nextval()+N) generate unique blocks of IDs? Craig James

22 August 2012

• 00:07   Re: Does setval(nextval()+N) generate unique blocks of IDs? Scott Marlowe
• 00:08   Re: average query performance measuring Tomas Vondra
• 00:51   Re: average query performance measuring Peter Geoghegan
• 01:57   Performance of Seq Scan from buffer cache Matt Daw
• 02:59   Re: Performance of Seq Scan from buffer cache Matt Daw
• 17:04   Re: average query performance measuring Rick Otten

23 August 2012

• 03:28   Re: Increasing WAL usage followed by sudden drop Jeff Janes
• 16:32   Re: Performance of Seq Scan from buffer cache Merlin Moncure
• 17:43   Re: Increasing WAL usage followed by sudden drop delongboy

24 August 2012

• 19:20   Loose Index Scans by Planner? Shaun Thomas
• 21:46   NOTIFY performance Artur Zając
• 22:12   Re: NOTIFY performance Merlin Moncure
• 22:41   Re: Loose Index Scans by Planner? Kevin Grittner

25 August 2012

• 00:11   Re: NOTIFY performance Artur Zając
• 00:22   Re: Loose Index Scans by Planner? Shaun Thomas
• 06:42   Re: Loose Index Scans by Planner? Jeff Janes
• 15:07   Slow Performance on a XEON E5504 Felix Schubert
• 15:42   Re: Slow Performance on a XEON E5504 Scott Marlowe
• 15:53   Re: Slow Performance on a XEON E5504 Felix Schubert
• 16:04   Re: Slow Performance on a XEON E5504 Scott Marlowe
• 16:08   Re: Slow Performance on a XEON E5504 Scott Marlowe
• 17:39   Re: Loose Index Scans by Planner? Shaun Thomas

26 August 2012

• 00:26   Re: Slow Performance on a XEON E5504 Felix Schubert
• 00:47   Re: Slow Performance on a XEON E5504 Scott Marlowe
• 15:51   Investigating the reason for a very big TOAST table size Liron Shiri

27 August 2012

• 14:51   Slow Performance on a XEON E5504 Felix Schubert
• 14:51   Investigating the reason for a very big TOAST table size Liron Shiri
• 15:37   Execution from java - slow Jayadevan M
• 15:47   Re: Execution from java - slow Albe Laurenz
• 19:43   Re: Investigating the reason for a very big TOAST table size Daniel Farina

28 August 2012

• 07:33   Vacuum problems with 9.1 Nimesh Satam
• 09:24   Re: Investigating the reason for a very big TOAST table size Liron Shiri
• 09:33   Re: Vacuum problems with 9.1 Pavan Deolasee
• 09:54   Re: Vacuum problems with 9.1 Craig Ringer
• 10:11   Re: Execution from java - slow Pavan Deolasee
• 10:40   pg_trgm and slow bitmap index scan plan Mathieu De Zutter
• 11:58   Re: Investigating the reason for a very big TOAST table size Daniel Farina
• 12:00   Re: Investigating the reason for a very big TOAST table size Daniel Farina
• 16:27   Re: pg_trgm and slow bitmap index scan plan Merlin Moncure
• 16:32   Re: Execution from java - slow Merlin Moncure
• 18:11   Re: NOTIFY performance Merlin Moncure

30 August 2012

• 11:11   Re: Investigating the reason for a very big TOAST table size Daniel Farina
• 11:11   Question about caching on full table scans Markus Innerebner
• 11:35   Re: Investigating the reason for a very big TOAST table size Liron Shiri
• 11:40   Re: Investigating the reason for a very big TOAST table size Daniel Farina
• 12:32   Re: Question about caching on full table scans Albe Laurenz
• 20:32   Re: Question about caching on full table scans Markus Innerebner
• 21:00   Re: Question about caching on full table scans Jeff Janes
• 21:13   Re: Question about caching on full table scans Scott Marlowe
• 23:44   Re: pg_dump and thousands of schemas Bruce Momjian
• 23:52   Re: pg_dump and thousands of schemas Tom Lane
• 23:53   Re: pg_dump and thousands of schemas Bruce Momjian

31 August 2012

• 00:45   Re: [HACKERS] pg_dump and thousands of schemas Robert Haas
• 06:18   Re: [HACKERS] pg_dump and thousands of schemas Tom Lane
• 10:28   Re: Question about caching on full table scans Markus Innerebner
• 15:27   exponential performance decrease in ISD transaction John Nash
• 16:36   Re: exponential performance decrease in ISD transaction Heikki Linnakangas
• 16:38   JDBC 5 million function insert returning Single Transaction Lock Access Exclusive Problem Eileen
• 16:50   Re: JDBC 5 million function insert returning Single Transaction Lock Access Exclusive Problem Dave Cramer
• 17:18   Re: JDBC 5 million function insert returning Single Transaction Lock Access Exclusive Problem Albe Laurenz
• 18:18   Re: JDBC 5 million function insert returning Single Transaction Lock Access Exclusive Problem Scott Marlowe
• 19:17   Re: exponential performance decrease in ISD transaction Jeff Janes
• 22:54   Re: NOTIFY performance Jeff Janes
• 23:23   Re: NOTIFY performance Tom Lane