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 - March 2012

Prev | Next

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

2012-03-01

[planner] Ignore "order by" in subselect if parrent do count(*) Marcin Mirosław (11:45)
Re: [planner] Ignore "order by" in subselect if parrent do count(*) Szymon Guz (11:50)
Re: [planner] Ignore "order by" in subselect if parrent do count(*) Marcin Mirosław (12:02)
Re: [planner] Ignore "order by" in subselect if parrent do count(*) Szymon Guz (12:09)
Re: [planner] Ignore "order by" in subselect if parrent do count(*) Marcin Mirosław (12:19)
Re: PG as in-memory db? How to warm up and re-populate buffers? How to read in all tuples into memory? Jeff Janes (16:34)
Bad estimation for "where field not in" Daniele Varrazzo (16:40)
Re: [planner] Ignore "order by" in subselect if parrent do count(*) Kevin Grittner (16:50)
Re: PG as in-memory db? How to warm up and re-populate buffers? How to read in all tuples into memory? Jeff Janes (16:57)
Re: PG as in-memory db? How to warm up and re-populate buffers? How to read in all tuples into memory? Scott Marlowe (17:35)
Re: PG as in-memory db? How to warm up and re-populate buffers? How to read in all tuples into memory? Dave Crooke (17:38)
Re: [planner] Ignore "order by" in subselect if parrent do count(*) Tom Lane (17:50)
Re: Bad estimation for "where field not in" Ants Aasma (17:53)
Re: [planner] Ignore "order by" in subselect if parrent do count(*) Craig James (18:19)
efficient data reduction (and deduping) Alessandro Gagliardi (18:27)
Re: efficient data reduction (and deduping) Claudio Freire (18:35)
Re: efficient data reduction (and deduping) Craig James (18:35)
Re: efficient data reduction (and deduping) Peter van Hardenberg (18:40)
Re: efficient data reduction (and deduping) Kevin Grittner (18:51)
Re: Large insert and delete batches Kääriäinen Anssi (19:06)
Re: efficient data reduction (and deduping) Alessandro Gagliardi (19:28)
Re: efficient data reduction (and deduping) Alessandro Gagliardi (19:29)
Re: efficient data reduction (and deduping) Alessandro Gagliardi (19:30)
Re: efficient data reduction (and deduping) Alessandro Gagliardi (19:35)
Re: efficient data reduction (and deduping) Claudio Freire (19:39)
Re: efficient data reduction (and deduping) Alessandro Gagliardi (19:43)
Re: efficient data reduction (and deduping) Claudio Freire (19:44)
Re: efficient data reduction (and deduping) Kevin Grittner (20:12)
Re: Large insert and delete batches Marti Raudsepp (20:51)
Re: Bad estimation for "where field not in" Tom Lane (21:18)
Re: [planner] Ignore "order by" in subselect if parrent do count(*) Tom Lane (21:29)
Re: PG as in-memory db? How to warm up and re-populate buffers? How to read in all tuples into memory? Stefan Keller (22:52)
Re: PG as in-memory db? How to warm up and re-populate buffers? How to read in all tuples into memory? Andrew Dunstan (23:08)

2012-03-02

Re: PG as in-memory db? How to warm up and re-populate buffers? How to read in all tuples into memory? Claudio Freire (00:23)
Re: PG as in-memory db? How to warm up and re-populate buffers? How to read in all tuples into memory? Peter van Hardenberg (00:28)
Re: PG as in-memory db? How to warm up and re-populate buffers? How to read in all tuples into memory? Jeff Janes (00:35)
Re: PG as in-memory db? How to warm up and re-populate buffers? How to read in all tuples into memory? Claudio Freire (00:58)
Re: [PERFORM] Re: [PERFORM] Re: [PERFORM] Re: [PERFORM] Re: 回复： [PERFORM] PG as in-memory db? How to warm up and re-populate buffers? How to read in all tuples into memory? Tomas Vondra (01:13)
Re: PG as in-memory db? How to warm up and re-populate buffers? How to read in all tuples into memory? Andrew Dunstan (01:17)
Re: [PERFORM] Re: [PERFORM] Re: [PERFORM] Re: [PERFO?==?UTF-8?Q?RM] Re: 回复： [PERFORM] PG as in-memory db? How to warm ?==?UTF-8?Q?up and re-populate buffers? How to read in all tuples into m?==?UTF-8?Q?emory? Claudio Freire (02:05)
Re: Large insert and delete batches Anssi Kääriäinen (12:51)
Re: Inefficient min/max against partition (ver 9.1.1) Tom Lane (19:31)

2012-03-03

Re: [PERFORM] Re: [PERFORM] Re: [PERFORM] Re: [PERFORM] Re: 回复： [PERFORM] PG as in-memory db? How to warm up and re-populate buffers? How to read in all tuples into memory? Tomas Vondra (00:30)
...WHERE TRUE" condition in union results in bad query pla Claus Stadler (22:43)

2012-03-04

Re: ...WHERE TRUE" condition in union results in bad query pla Tom Lane (03:03)
Advice sought : new database server Rory Campbell-Lange (09:58)
Re: Advice sought : new database server Michael Friedl (11:50)
Re: Advice sought : new database server Scott Marlowe (14:19)
Re: Advice sought : new database server Rory Campbell-Lange (18:36)
Re: Advice sought : new database server Andy Colson (19:45)
Re: Advice sought : new database server Scott Marlowe (19:49)
Re: Advice sought : new database server Scott Marlowe (19:51)

2012-03-05

Re: Advice sought : new database server Rory Campbell-Lange (12:26)
Partitioning / Strange optimizer behaviour Marc Schablewski (15:11)
Re: Partitioning / Strange optimizer behaviour Tomas Vondra (15:20)
Re: Partitioning / Strange optimizer behaviour Marc Schablewski (15:44)
Re: Advice sought : new database server Craig James (16:56)
Re: Advice sought : new database server Rory Campbell-Lange (21:59)
SSD and RAID Mark Kirkwood (22:37)
Re: SSD and RAID Tomas Vondra (23:03)
Repeat execution of stable expressions Merlin Moncure (23:15)

2012-03-06

Re: Repeat execution of stable expressions Peter van Hardenberg (00:41)
Re: SSD and RAID Yeb Havinga (08:17)
Re: SSD and RAID Andrea Suisani (08:34)
Re: SSD and RAID Yeb Havinga (09:34)
Re: SSD and RAID Andrea Suisani (09:56)
Re: Advice sought : new database server Rory Campbell-Lange (11:12)
Re: Repeat execution of stable expressions Merlin Moncure (15:00)
Re: Repeat execution of stable expressions Jan Otto (16:21)
Re: Repeat execution of stable expressions Merlin Moncure (19:29)

2012-03-07

Re: Advice sought : new database server Steve Crawford (00:32)
Re: SSD and RAID Mark Kirkwood (00:36)
Re: SSD and RAID Yeb Havinga (09:45)
Advice on Controller card for SAS disks See Sing Lau (17:49)
Re: Advice sought : new database server Merlin Moncure (20:18)
Re: Advice sought : new database server Scott Marlowe (20:45)
Re: Advice sought : new database server Craig James (21:07)
Re: Advice sought : new database server Shaun Thomas (22:24)

2012-03-08

Re: Advice sought : new database server Ants Aasma (12:43)
Re: Advice sought : new database server Rory Campbell-Lange (13:27)
Re: Advice sought : new database server Jeff Janes (16:03)
Re: Advice sought : new database server Jochen Erwied (16:15)
Re: Advice sought : new database server Shaun Thomas (16:18)

2012-03-09

Comments requested on IO performance : new db server Rory Campbell-Lange (11:15)
Tuning wizard Michael Kopljan (15:07)
count on transaction ID ddgs (15:30)
Re: Comments requested on IO performance : new db server Merlin Moncure (16:11)

2012-03-10

Re: Comments requested on IO performance : new db server Rory Campbell-Lange (10:19)
Re: Comments requested on IO performance : new db server Rory Campbell-Lange (10:51)
Re: Comments requested on IO performance : new db server Tomas Vondra (15:12)

2012-03-11

Feature Request: No pg_dump lock on unlogged tables McGehee, Robert (17:38)

2012-03-12

Re: count on transaction ID Kevin Grittner (14:40)
Re: count on transaction ID ddgs (15:46)
Re: Tuning wizard Tomas Vondra (16:03)
Re: count on transaction ID Kevin Grittner (16:05)
Re: Advice on Controller card for SAS disks Tomas Vondra (16:10)
Re: count on transaction ID ddgs (16:34)
Re: Tuning wizard Scott Marlowe (16:37)
Re: Advice on Controller card for SAS disks Scott Marlowe (16:43)
Re: count on transaction ID Kevin Grittner (16:56)

2012-03-13

Re: Tuning wizard Raghavendra (00:55)
Gin index insert performance issue Rural Hunter (05:43)
Re: Gin index insert performance issue Jesper Krogh (06:29)
Re: Gin index insert performance issue Rural Hunter (07:52)

2012-03-15

Re: Gin index insert performance issue Rural Hunter (03:49)
Shared memory for large PostGIS operations maplabs (04:29)
index choosing problem Rural Hunter (08:32)
Re: index choosing problem Ants Aasma (11:44)

2012-03-16

Re: Shared memory for large PostGIS operations Andy Colson (13:55)
Re: Shared memory for large PostGIS operations Kevin Grittner (14:17)
Obtaining resource usage statistics from execution? (v 9.1) Karl Denninger (14:31)
Re: Obtaining resource usage statistics from execution? (v 9.1) Ants Aasma (14:48)
Re: Obtaining resource usage statistics from execution? (v 9.1) Tom Lane (14:53)
Re: Obtaining resource usage statistics from execution? (v 9.1) Tomas Vondra (15:08)
Re: Obtaining resource usage statistics from execution? (v 9.1) Karl Denninger (15:38)
Re: Shared memory for large PostGIS operations Brian Hamlin (21:00)
Re: Shared memory for large PostGIS operations Kevin Grittner (22:30)

2012-03-17

Re: Shared memory for large PostGIS operations Andy Colson (13:20)
Re: Shared memory for large PostGIS operations Kevin Grittner (16:16)
slow self-join query Robert Poor (20:56)

2012-03-18

Re: slow self-join query Scott Marlowe (00:57)
Re: slow self-join query Robert Poor (14:37)
Re: slow self-join query Andrew Dunstan (14:51)
Re: slow self-join query Scott Marlowe (15:30)
Re: slow self-join query Scott Marlowe (15:44)

2012-03-19

Re: slow self-join query Robert Poor (03:57)
Re: slow self-join query Merlin Moncure (13:35)
Re: slow self-join query Kevin Grittner (14:27)
Re: slow self-join query Robert Poor (15:22)
Re: slow self-join query Kevin Grittner (16:45)

2012-03-21

DBD-Pg prepared statement versus plain execution Rafael Martinez (11:21)
timing != log duration Rafael Martinez (11:42)
Re: timing != log duration Marti Raudsepp (11:53)
Re: DBD-Pg prepared statement versus plain execution ktm@rice.edu (12:59)
Re: DBD-Pg prepared statement versus plain execution Andy Colson (13:44)
Re: timing != log duration Tom Lane (14:11)
Re: set autovacuum=off Robert Haas (14:32)
Re: timing != log duration Albe Laurenz (14:48)

2012-03-22

Write workload is causing severe slowdown in Production Gnanakumar (07:27)
Re: Write workload is causing severe slowdown in Production Vitalii Tymchyshyn (09:42)
Re: Write workload is causing severe slowdown in Production Tomas Vondra (10:04)
Re: Write workload is causing severe slowdown in Production Gnanakumar (10:32)
Re: Write workload is causing severe slowdown in Production Tomas Vondra (10:43)
Re: Write workload is causing severe slowdown in Production Gnanakumar (12:10)
Re: Write workload is causing severe slowdown in Production Gnanakumar (12:38)
Re: Write workload is causing severe slowdown in Production Tomas Vondra (12:52)
Re: Write workload is causing severe slowdown in Production Tomas Vondra (12:55)
Re: Write workload is causing severe slowdown in Production Kevin Grittner (15:13)
Re: Write workload is causing severe slowdown in Production Merlin Moncure (16:18)
Sudden Query slowdown on our Postgresql Server Sebastian Melchior (22:52)

2012-03-23

Re: Write workload is causing severe slowdown in Production Mark Kirkwood (00:08)
Re: Sudden Query slowdown on our Postgresql Server Stephen Frost (00:47)
Re: Sudden Query slowdown on our Postgresql Server Sebastian Melchior (04:37)
Re: Sudden Query slowdown on our Postgresql Server Scott Marlowe (04:48)
Re: Sudden Query slowdown on our Postgresql Server Sebastian Melchior (04:53)
Re: Sudden Query slowdown on our Postgresql Server Scott Marlowe (05:19)
Re: Sudden Query slowdown on our Postgresql Server Yeb Havinga (07:10)
Re: Sudden Query slowdown on our Postgresql Server Sebastian Melchior (07:52)
Re: Write workload is causing severe slowdown in Production Gnanakumar (10:10)
Re: Write workload is causing severe slowdown in Production Tomas Vondra (10:24)
Re: Write workload is causing severe slowdown in Production Gnanakumar (12:25)
Re: Write workload is causing severe slowdown in Production Kevin Grittner (14:09)

2012-03-26

Determining working set size Peter van Hardenberg (07:11)
anyone tried to use hoard allocator? Tomas Vondra (09:50)
Re: anyone tried to use hoard allocator? Pavel Stehule (11:09)
Re: anyone tried to use hoard allocator? Steve Atkins (16:00)

2012-03-27

Re: Determining working set size Joshua Berkus (19:58)
Linux machine aggressively clearing cache Joshua Berkus (20:06)
Re: Linux machine aggressively clearing cache Claudio Freire (20:10)
Distinct + Limit Francois Deliege (20:37)
Re: Linux machine aggressively clearing cache Dave Crooke (20:40)
Re: Distinct + Limit Francois Deliege (20:54)

2012-03-28

Re: Distinct + Limit Ants Aasma (00:18)
Re: Distinct + Limit Tom Lane (14:13)
Re: Distinct + Limit Merlin Moncure (16:39)
Re: Linux machine aggressively clearing cache Joshua Berkus (18:37)

2012-03-29

database slowdown while a lot of inserts occur Campbell, Lance (17:59)
Re: database slowdown while a lot of inserts occur Campbell, Lance (18:02)
Re: database slowdown while a lot of inserts occur Filippos Kalamidas (18:14)
Re: database slowdown while a lot of inserts occur Deron (18:17)
Re: database slowdown while a lot of inserts occur Bob Lunney (19:27)
Re: database slowdown while a lot of inserts occur Andrew Dunstan (19:39)
Re: database slowdown while a lot of inserts occur Shrirang Chitnis (20:17)
Re: database slowdown while a lot of inserts occur Scott Marlowe (21:36)

2012-03-30

Tablespaces on a raid configuration Campbell, Lance (14:45)
Re: Tablespaces on a raid configuration ktm@rice.edu (14:53)
Re: Tablespaces on a raid configuration Greg Spiegelberg (15:02)
Re: Tablespaces on a raid configuration Andrew Dunstan (15:02)
Re: Tablespaces on a raid configuration Merlin Moncure (16:11)
Re: Tablespaces on a raid configuration Craig James (17:30)

2012-03-31

Re: Linux machine aggressively clearing cache Josh Berkus (00:51)
Re: database slowdown while a lot of inserts occur Tomas Vondra (01:11)
Re: database slowdown while a lot of inserts occur Tomas Vondra (01:21)
Re: Tablespaces on a raid configuration Tomas Vondra (01:32)
Re: Tablespaces on a raid configuration Aidan Van Dyk (13:42)

Prev | Next

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

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