Skip site navigation (1) Skip section navigation (2)

Peripheral Links

Text Size: Normal / Large
Donate
Contact

PostgreSQL

The world's most advanced open source database.

pgsql-performance - August 2012

Prev | Next

Jump to day: 1 2 3 4 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 30 31

2012-08-01

Re: pg_dump and thousands of schemas Hugo <Nabble> (05:33)
Re: Help me develop new commit_delay advice Amit Kapila (14:14)
Re: Help me develop new commit_delay advice Peter Geoghegan (15:19)
Re: Using ctid column changes plan drastically Kevin Grittner (16:42)

2012-08-02

Re: Help me develop new commit_delay advice Amit Kapila (11:15)
query using incorrect index Russell Keane (14:54)
Re: Help me develop new commit_delay advice Josh Berkus (17:48)
[repost] Help me develop new commit_delay advice Peter Geoghegan (18:02)
Re: Help me develop new commit_delay advice Peter Geoghegan (18:04)
Re: query using incorrect index Kevin Grittner (20:13)

2012-08-03

Messed up time zones Laszlo Nagy (08:31)
Re: Messed up time zones JC de Villa (08:58)
Re: query using incorrect index Robert Klemme (09:18)
Re: Messed up time zones Laszlo Nagy (09:18)
Re: Messed up time zones JC de Villa (09:48)
Re: query using incorrect index Russell Keane (09:50)
Re: query using incorrect index Russell Keane (10:00)
Re: Messed up time zones Laszlo Nagy (10:40)
Re: Messed up time zones Laszlo Nagy (10:55)
Re: Messed up time zones Tom Lane (14:19)
Re: query using incorrect index Kevin Grittner (14:33)
Re: Messed up time zones Laszlo Nagy (15:23)
Re: Messed up time zones Bill MacArthur (15:34)
Re: query using incorrect index Russell Keane (15:57)
Re: Messed up time zones Laszlo Nagy (16:06)
Re: Messed up time zones Steve Crawford (16:20)
Re: Messed up time zones Tom Lane (16:38)
Re: [ADMIN] Messed up time zones Laszlo Nagy (17:21)
Re: Messed up time zones Laszlo Nagy (17:25)
Re: Messed up time zones Laszlo Nagy (18:25)
Re: [ADMIN] Messed up time zones Steve Crawford (18:25)
Re: [ADMIN] Messed up time zones Laszlo Nagy (18:37)
Re: Linux memory zone reclaim Josh Berkus (22:30)
Re: Linux memory zone reclaim Scott Marlowe (23:02)
Re: Linux memory zone reclaim Josh Berkus (23:15)

2012-08-04

slow query, different plans Midge Brown (00:38)
Re: slow query, different plans Greg Williamson (01:30)
Re: slow query, different plans Tom Lane (06:26)

2012-08-06

Postgres Upgrade from 8.4 to 9.1 Rajiv Kasera (05:38)
Re: Postgres 9.1.4 - high stats collector IO usage Magnus Hagander (14:10)
Re: Postgres 9.1.4 - high stats collector IO usage Pavel Stehule (14:16)
Re: Postgres 9.1.4 - high stats collector IO usage Magnus Hagander (14:18)
Re: Postgres 9.1.4 - high stats collector IO usage Pavel Stehule (14:43)
Sequential scan instead of index scan Ioannis Anagnostopoulos (15:08)
Re: Sequential scan instead of index scan David Barton (15:16)
Re: Sequential scan instead of index scan Ioannis Anagnostopoulos (15:24)
Re: Sequential scan instead of index scan Tom Lane (15:34)
Re: slow query, different plans Midge Brown (17:43)
Re: slow query, different plans Midge Brown (18:36)
Re: Sequential scan instead of index scan Ioannis Anagnostopoulos (22:04)

2012-08-07

Re: Sequential scan instead of index scan Tom Lane (03:13)
Slow query: Select all buildings that have >1 pharmacies and >1 schools within 1000m Stefan Keller (12:01)
Re: Sequential scan instead of index scan Ioannis Anagnostopoulos (12:15)
Re: Slow query: Select all buildings that have >1 pharmacies and >1 schools within 1000m Tomas Vondra (12:16)
Re: Slow query: Select all buildings that have >1 pharmacies and >1 schools within 1000m Stefan Keller (12:22)
Re: Slow query: Select all buildings that have >1 pharmacies and >1 schools within 1000m Tomas Vondra (13:56)
Re: Slow query: Select all buildings that have >1 pharmacies and >1 schools within 1000m Craig James (14:37)
Re: Sequential scan instead of index scan Jeff Janes (16:00)
Re: Sequential scan instead of index scan Ioannis Anagnostopoulos (16:06)
Re: Sequential scan instead of index scan Jeff Janes (17:42)
Is drop/restore trigger transactional? Craig James (18:48)
Re: Is drop/restore trigger transactional? Merlin Moncure (20:15)
Re: Is drop/restore trigger transactional? Scott Marlowe (20:39)
Re: Is drop/restore trigger transactional? Jeff Janes (20:45)
Re: Is drop/restore trigger transactional? Merlin Moncure (21:21)
Re: Is drop/restore trigger transactional? Craig James (21:39)
Re: Is drop/restore trigger transactional? Samuel Gendler (22:01)
Re: Is drop/restore trigger transactional? Merlin Moncure (22:02)
Re: Is drop/restore trigger transactional? Jeff Janes (22:22)
Re: Is drop/restore trigger transactional? Craig James (22:46)

2012-08-08

Re: Slow query: Select all buildings that have >1 pharmacies and >1 schools within 1000m Stefan Keller (00:07)
Re: Is drop/restore trigger transactional? Craig Ringer (00:29)
Re: Is drop/restore trigger transactional? Merlin Moncure (00:42)
Re: Slow query: Select all buildings that have >1 pharmacies and >1 schools within 1000m Jeff Janes (00:50)
Re: Postgresql - performance of using array in big database Craig Ringer (06:33)
Re: Postgres Upgrade from 8.4 to 9.1 Craig Ringer (06:50)

2012-08-09

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

2012-08-10

Increasing WAL usage followed by sudden drop Joseph Marlin (17:35)
Re: query overhead Jeff Janes (18:19)
Index Bloat Problem Strahinja Kustudić (22:15)

2012-08-11

Re: Index Bloat Problem hubert depesz lubaczewski (09:30)
Re: Is drop/restore trigger transactional? Matheus de Oliveira (14:16)
Improve DB Size / Performance with Table Refactoring Anthony Presley (14:23)

2012-08-12

Re: Postgres 9.1.4 - high stats collector IO usage Jeff Janes (21:23)
Re: Deferred constraints performance impact ? Jeff Davis (22:42)

2012-08-13

Re: Postgres 9.1.4 - high stats collector IO usage David Barton (02:17)
Re: Deferred constraints performance impact ? Robert Klemme (08:33)
Re: Postgres 9.1.4 - high stats collector IO usage Jeff Janes (19:40)
Re: Index Bloat Problem Mark Kirkwood (22:52)

2012-08-14

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

2012-08-15

Re: cluster on conditional index? Doug Hunley (13:43)
Re: 7k records into Sort node, 4.5m out? Christophe Pettus (19:13)
Re: 7k records into Sort node, 4.5m out? Tom Lane (20:51)
Re: 7k records into Sort node, 4.5m out? Josh Berkus (21:02)
Re: cluster on conditional index? Josh Berkus (21:05)
Re: cluster on conditional index? Bosco Rama (21:19)
Re: 7k records into Sort node, 4.5m out? Tom Lane (21:44)

2012-08-16

Re: 7k records into Sort node, 4.5m out? Josh Berkus (00:25)
High Disk write and space taken by PostgreSQL J Ramesh Kumar (03:23)
Re: High Disk write and space taken by PostgreSQL David Barton (03:36)
Re: High Disk write and space taken by PostgreSQL J Ramesh Kumar (04:30)
Re: High Disk write and space taken by PostgreSQL Scott Marlowe (04:39)
Re: High Disk write and space taken by PostgreSQL J Ramesh Kumar (05:40)
Re: High Disk write and space taken by PostgreSQL Claudio Freire (05:41)
Re: High Disk write and space taken by PostgreSQL Ondrej Ivanič (05:48)
Re: High Disk write and space taken by PostgreSQL Claudio Freire (05:50)
Re: 7k records into Sort node, 4.5m out? Tom Lane (06:01)
Re: High Disk write and space taken by PostgreSQL Bruce Momjian (14:53)
Re: High Disk write and space taken by PostgreSQL Bruce Momjian (14:56)
Re: cluster on conditional index? Doug Hunley (15:25)
Re: High Disk write and space taken by PostgreSQL Scott Marlowe (15:49)
Re: cluster on conditional index? Jeff Janes (16:04)
Re: High Disk write and space taken by PostgreSQL anarazel@anarazel.de (16:07)
Re: Odd blocking (or massively latent) issue - even with EXPLAIN Jim Vanns (16:14)
Re: cluster on conditional index? Jeff Janes (16:16)
Re: High Disk write and space taken by PostgreSQL Bruce Momjian (16:23)
Re: Increasing WAL usage followed by sudden drop delongboy (16:31)
Re: Increasing WAL usage followed by sudden drop Kevin Grittner (16:39)
Re: Index Bloat Problem Strahinja Kustudić (19:57)
best practice to avoid table bloat? Anibal David Acosta (20:33)
Re: best practice to avoid table bloat? Andrew Dunstan (20:48)
Re: best practice to avoid table bloat? Kevin Grittner (20:52)
Re: best practice to avoid table bloat? Anibal David Acosta (21:10)
Re: High Disk write and space taken by PostgreSQL Merlin Moncure (21:16)
Re: best practice to avoid table bloat? Kevin Grittner (21:39)

2012-08-17

Re: Increasing WAL usage followed by sudden drop Joshua Berkus (15:01)
Re: Increasing WAL usage followed by sudden drop delongboy (17:53)
Re: Increasing WAL usage followed by sudden drop Jeff Janes (18:42)

2012-08-18

Re: Index Bloat Problem Jeff Janes (02:33)
Re: Index Bloat Problem Greg Williamson (08:01)

2012-08-19

Re: 7k records into Sort node, 4.5m out? Josh Berkus (19:53)

2012-08-20

Re: 7k records into Sort node, 4.5m out? Tom Lane (15:40)
Re: 7k records into Sort node, 4.5m out? Josh Berkus (17:47)
Re: Increasing WAL usage followed by sudden drop delongboy (20:51)
Does setval(nextval()+N) generate unique blocks of IDs? Craig James (23:32)

2012-08-21

Re: Does setval(nextval()+N) generate unique blocks of IDs? Tom Lane (00:10)
Re: Does setval(nextval()+N) generate unique blocks of IDs? Scott Marlowe (00:59)
Re: Does setval(nextval()+N) generate unique blocks of IDs? Scott Marlowe (01:06)
Re: Does setval(nextval()+N) generate unique blocks of IDs? Scott Marlowe (07:41)
Re: Does setval(nextval()+N) generate unique blocks of IDs? Scott Marlowe (07:45)
Re: Does setval(nextval()+N) generate unique blocks of IDs? Merlin Moncure (14:12)
Re: Does setval(nextval()+N) generate unique blocks of IDs? Craig James (14:36)
Re: Does setval(nextval()+N) generate unique blocks of IDs? Craig James (15:32)
Re: Does setval(nextval()+N) generate unique blocks of IDs? Merlin Moncure (17:53)
average query performance measuring Rick Otten (18:35)
Re: average query performance measuring Stephen Frost (18:53)
Re: average query performance measuring Karl Denninger (19:48)
Re: Does setval(nextval()+N) generate unique blocks of IDs? Scott Marlowe (20:03)
Re: Does setval(nextval()+N) generate unique blocks of IDs? Scott Marlowe (20:04)
Re: average query performance measuring Stephen Frost (20:27)
Re: Does setval(nextval()+N) generate unique blocks of IDs? Craig James (20:59)
Re: Does setval(nextval()+N) generate unique blocks of IDs? Scott Marlowe (21:06)
Re: average query performance measuring Tomas Vondra (21:08)
Re: average query performance measuring Peter Geoghegan (21:51)
Performance of Seq Scan from buffer cache Matt Daw (22:57)
Re: Performance of Seq Scan from buffer cache Matt Daw (23:59)

2012-08-22

Re: average query performance measuring Rick Otten (14:04)

2012-08-23

Re: Increasing WAL usage followed by sudden drop Jeff Janes (00:28)
Re: Performance of Seq Scan from buffer cache Merlin Moncure (13:32)
Re: Increasing WAL usage followed by sudden drop delongboy (14:43)

2012-08-24

Slow Performance on a XEON E5504 Felix Schubert (09:47)
Loose Index Scans by Planner? Shaun Thomas (16:20)
NOTIFY performance Artur Zając (18:46)
Re: NOTIFY performance Merlin Moncure (19:12)
Re: Loose Index Scans by Planner? Kevin Grittner (19:40)
Re: NOTIFY performance Artur Zając (21:11)
Re: Loose Index Scans by Planner? Shaun Thomas (21:22)

2012-08-25

Re: Loose Index Scans by Planner? Jeff Janes (03:42)
Slow Performance on a XEON E5504 Felix Schubert (12:07)
Re: Slow Performance on a XEON E5504 Scott Marlowe (12:42)
Re: Slow Performance on a XEON E5504 Felix Schubert (12:53)
Re: Slow Performance on a XEON E5504 Scott Marlowe (12:59)
Re: Slow Performance on a XEON E5504 Scott Marlowe (13:04)
Re: Loose Index Scans by Planner? Shaun Thomas (14:39)
Re: Slow Performance on a XEON E5504 Felix Schubert (21:26)
Re: Slow Performance on a XEON E5504 Scott Marlowe (21:47)

2012-08-26

Investigating the reason for a very big TOAST table size Liron Shiri (12:46)
Investigating the reason for a very big TOAST table size Liron Shiri (12:51)

2012-08-27

Execution from java - slow Jayadevan M (12:37)
Re: Execution from java - slow Albe Laurenz (12:47)
Re: Investigating the reason for a very big TOAST table size Daniel Farina (16:42)

2012-08-28

Vacuum problems with 9.1 Nimesh Satam (04:33)
Re: Investigating the reason for a very big TOAST table size Liron Shiri (06:24)
Re: Vacuum problems with 9.1 Pavan Deolasee (06:33)
Re: Vacuum problems with 9.1 Craig Ringer (06:53)
Re: Execution from java - slow Pavan Deolasee (07:11)
pg_trgm and slow bitmap index scan plan Mathieu De Zutter (07:39)
Re: Investigating the reason for a very big TOAST table size Daniel Farina (08:57)
Re: Investigating the reason for a very big TOAST table size Daniel Farina (08:59)

Prev | Next

Jump to day: 1 2 3 4 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 30 31

Privacy Policy | About PostgreSQL
Copyright © 1996-2013 The PostgreSQL Global Development Group