Skip site navigation (1)
Skip section navigation (2)
pgsql-performance 2009-01 Chronological Index (1/2)
Last updated: Wed Jan 18 04:15:21 2012
302 messages
30 January 2009
Re: Poor plan choice in prepared statement Scott Carey (19:41)
Re: PG performance in high volume environment (many INSERTs and lots of aggregation reporting) Scott Marlowe (07:53)
Re: Using multiple cores for index creation? Tom Lane (01:25)
Re: Using multiple cores for index creation? henk de wit (00:03)
29 January 2009
Re: Sort performance Subbiah Stalin-XCGF84 (23:36)
Re: Sort performance Gregory Stark (23:35)
Re: Sort performance Robert Haas (23:21)
Re: Using multiple cores for index creation? Joshua D. Drake (23:19)
Re: Using multiple cores for index creation? Robert Haas (23:09)
Re: PG performance in high volume environment (many INSERTs and lots of aggregation reporting) Chris Browne (21:13)
Sort performance Subbiah Stalin-XCGF84 (20:22)
Using multiple cores for index creation? henk de wit (20:21)
Re: Max on union Robert Haas (20:10)
Re: LIKE Query performance Oleg Bartunov (19:06)
Re: LIKE Query performance Hari, Balaji (18:05)
Re: LIKE Query performance Hari, Balaji (17:11)
Max on union anders.blaagaard (16:04)
Re: NOT IN >2hrs vs EXCEPT < 2 sec. Tom Lane (14:56)
Re: NOT IN >2hrs vs EXCEPT < 2 sec. Gregory Stark (13:00)
Re: NOT IN >2hrs vs EXCEPT < 2 sec. Kevin Traster (08:02)
Re: NOT IN >2hrs vs EXCEPT < 2 sec. Kevin Traster (08:01)
Re: NOT IN >2hrs vs EXCEPT < 2 sec. Scott Marlowe (07:37)
NOT IN >2hrs vs EXCEPT < 2 sec. Kevin Traster (07:06)
28 January 2009
Re: [PERFORMANCE] Buying hardware Scott Marlowe (20:02)
Re: PG performance in high volume environment (many INSERTs and lots of aggregation reporting) Merlin Moncure (17:55)
Re: PG performance in high volume environment (many INSERTs and lots of aggregation reporting) Richard Huxton (14:26)
Re: PG performance in high volume environment (many INSERTs and lots of aggregation reporting) Robert Haas (14:18)
Re: LIKE Query performance Robert Haas (14:09)
PG performance in high volume environment (many INSERTs and lots of aggregation reporting) Phoenix Kiula (13:33)
Re: LIKE Query performance A. Kretschmer (09:43)
Re: LIKE Query performance Marcin Stępnicki (09:27)
Need help in setting up DBT2 for PostgreSQL Rohan Pethkar (09:15)
Re: LIKE Query performance Oleg Bartunov (06:27)
LIKE Query performance Hari, Balaji (00:06)
27 January 2009
Re: [PERFORMANCE] Buying hardware M. Edward (Ed) Borasky (15:19)
Re: [PERFORMANCE] Buying hardware david (14:38)
Re: [PERFORMANCE] Buying hardware M. Edward (Ed) Borasky (14:02)
Re: [PERFORMANCE] Buying hardware M. Edward (Ed) Borasky (13:28)
Re: [PERFORMANCE] Buying hardware A B (08:20)
Re: Odd behavior with temp usage logging Craig Ringer (08:14)
Odd behavior with temp usage logging Josh Berkus (06:53)
Re: SSD performance david (06:48)
Re: SSD performance James Mansion (06:47)
Re: [PERFORMANCE] Buying hardware david (03:03)
Re: [PERFORMANCE] Buying hardware david (02:56)
Re: [PERFORMANCE] Buying hardware Craig Ringer (01:07)
26 January 2009
Re: postgresql 8.3 tps rate Ron Mayer (21:48)
Re: [PERFORMANCE] Buying hardware David Rees (21:07)
Re: postgresql 8.3 tps rate M. Edward (Ed) Borasky (20:56)
Re: [PERFORMANCE] Buying hardware Jeff (20:27)
Re: [PERFORMANCE] Buying hardware David Rees (20:12)
Re: [PERFORMANCE] Buying hardware Kenny Gorman (20:04)
Re: [PERFORMANCE] Buying hardware Joshua D. Drake (20:01)
Re: [PERFORMANCE] Buying hardware Jeff (19:58)
Re: [PERFORMANCE] Buying hardware David Rees (19:46)
Re: postgresql 8.3 tps rate Greg Smith (19:29)
Re: postgresql 8.3 tps rate M. Edward (Ed) Borasky (19:12)
Re: postgresql 8.3 tps rate Craig Ringer (18:09)
Re: postgresql 8.3 tps rate M. Edward (Ed) Borasky (16:09)
Re: strange index performance? Kenneth Marshall (15:37)
Re: strange index performance? Thomas Finneid (14:49)
Re: strange index performance? Kenneth Marshall (13:51)
Re: postgresql 8.3 tps rate Matthew Wakeling (12:18)
Re: [PERFORMANCE] Buying hardware Matthew Wakeling (12:10)
Re: strange index performance? Thomas Finneid (09:10)
25 January 2009
Re: postgresql 8.3 tps rate M. Edward (Ed) Borasky (22:24)
Re: strange index performance? Thomas Finneid (22:21)
Re: [PERFORMANCE] Buying hardware Scott Marlowe (21:42)
[PERFORMANCE] Buying hardware A B (21:21)
Re: postgresql 8.3 tps rate Greg Smith (20:45)
Re: postgresql 8.3 tps rate M. Edward (Ed) Borasky (17:04)
Re: postgresql 8.3 tps rate M. Edward (Ed) Borasky (16:22)
Re: SSD performance david (12:13)
Re: SSD performance Gregory Stark (11:55)
Re: strange index performance? Scott Marlowe (09:58)
Re: strange index performance? Thomas Finneid (08:14)
Re: strange index performance? Thomas Finneid (07:45)
Re: SSD performance david (07:32)
Re: SSD performance Greg Smith (07:26)
24 January 2009
Re: strange index performance? Scott Marlowe (19:33)
Re: strange index performance? Scott Marlowe (14:57)
strange index performance? Thomas Finneid (10:57)
"tablespace" for tranaction log? Thomas Finneid (07:02)
Re: SSD performance M. Edward (Ed) Borasky (03:23)
23 January 2009
Re: SSD performance Matthew Wakeling (17:39)
Re: SSD performance Joshua D. Drake (17:30)
Re: SSD performance M. Edward (Ed) Borasky (17:21)
Re: SSD performance david (17:15)
More Troubles Dumping a Very Large Table Ted Allen (15:56)
Re: SSD performance Merlin Moncure (14:59)
Re: postgresql 8.3 tps rate Merlin Moncure (14:51)
Re: SSD performance Florian Weimer (14:37)
Re: SSD performance Craig Ringer (13:50)
Re: SSD performance Luke Lonergan (11:53)
Re: SSD performance Matthew Wakeling (11:53)
Re: SSD performance david (11:49)
Re: SSD performance Luke Lonergan (11:42)
Re: SSD performance david (11:35)
Re: SSD performance Glyn Astill (11:12)
SSD performance david (10:33)
Re: postgresql 8.3 tps rate Scott Marlowe (08:43)
Re: postgresql 8.3 tps rate Craig James (06:35)
Re: dbt-2 tuning results with postgresql-8.3.5 Mark Wong (06:10)
Re: postgresql 8.3 tps rate Ibrahim Harrani (05:52)
Re: caching indexes and pages? Craig Ringer (05:52)
Re: postgresql 8.3 tps rate Greg Smith (03:52)
Re: dbt-2 tuning results with postgresql-8.3.5 Greg Smith (03:45)
Re: dbt-2 tuning results with postgresql-8.3.5 Mark Wong (01:44)
Re: postgresql 8.3 tps rate Craig James (00:37)
Re: postgresql 8.3 tps rate Scott Marlowe (00:28)
22 January 2009
Re: caching indexes and pages? Kenneth Marshall (22:03)
Re: caching indexes and pages? Thomas Finneid (21:58)
Re: postgresql 8.3 tps rate David Rees (21:41)
Re: postgresql 8.3 tps rate Ibrahim Harrani (21:36)
Re: postgresql 8.3 tps rate Ibrahim Harrani (21:27)
Re: Question about clustering indexes and restores Harold A . Giménez Ch . (20:02)
Re: Question about clustering indexes and restores Kenneth Marshall (19:58)
Question about clustering indexes and restores Harold A . Giménez Ch . (19:52)
Re: postgresql 8.3 tps rate Alvaro Herrera (19:00)
Re: linux, memory (mis)accounting/reporting, and the planner/optimizer M. Edward (Ed) Borasky (18:38)
Re: caching written values? Simon Riggs (18:03)
Re: postgresql 8.3 tps rate Merlin Moncure (17:14)
Re: linux, memory (mis)accounting/reporting, and the planner/optimizer Greg Smith (17:03)
Re: postgresql 8.3 tps rate Joshua D. Drake (16:56)
Re: postgresql 8.3 tps rate Claus Guttesen (16:56)
Re: Slow HashAggregate : How to optimize ? Robert Haas (16:50)
postgresql 8.3 tps rate Ibrahim Harrani (15:47)
Slow HashAggregate : How to optimize ? Bruno Baguette (15:41)
Re: caching written values? Robert Haas (15:36)
Re: caching indexes and pages? Robert Haas (15:34)
Re: caching written values? Thomas Finneid (12:35)
Re: caching written values? Thomas Finneid (12:11)
Re: caching written values? Glyn Astill (12:07)
Re: caching written values? Pavan Deolasee (11:20)
caching written values? Thomas Finneid (11:12)
Re: caching indexes and pages? Thomas Markus (07:06)
Re: caching indexes and pages? A. Kretschmer (07:01)
caching indexes and pages? Thomas Finneid (06:48)
Re: linux, memory (mis)accounting/reporting, and the planner/optimizer M. Edward (Ed) Borasky (06:23)
Re: linux, memory (mis)accounting/reporting, and the planner/optimizer Greg Smith (00:03)
21 January 2009
Re: Interesting query plan change linked to the LIMIT parameter Yannick Le Guédart (13:49)
20 January 2009
Interesting query plan change linked to the LIMIT parameter Yannick Le Guédart (16:07)
19 January 2009
Query running long - cost estimation question... Akos Gabriel (18:07)
test Akos Gabriel (17:40)
Re: left join + case - how is it processed? Richard Broersma (16:51)
Re: left join + case - how is it processed? Tom Lane (16:33)
Re: left join + case - how is it processed? Chris (05:05)
Re: left join + case - how is it processed? Evan Carroll (04:52)
Re: left join + case - how is it processed? Chris (04:36)
Re: left join + case - how is it processed? Evan Carroll (04:35)
Re: left join + case - how is it processed? Robert Haas (04:17)
left join + case - how is it processed? Chris (03:31)
16 January 2009
Re: understanding postgres issues/bottlenecks david (07:57)
Re: understanding postgres issues/bottlenecks M. Edward (Ed) Borasky (06:03)
15 January 2009
Re: Slow insert performace, 8.3 Wal related? Scott Marlowe (22:32)
Re: Slow insert performace, 8.3 Wal related? Bill Preston (21:56)
Re: understanding postgres issues/bottlenecks Jean-David Beyer (19:32)
Cost of INSERT rules Enrico Weigelt (18:48)
Re: row-specific conditions possible? A. Kretschmer (11:06)
row-specific conditions possible? Jörg Kiegeland (10:42)
14 January 2009
Re: Slow insert performace, 8.3 Wal related? Heikki Linnakangas (10:10)
Re: index David Wilson (06:16)
index Maksim Sosnovskiy (05:54)
Re: dbt-2 tuning results with postgresql-8.3.5 Mark Wong (03:49)