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 - November 2008

Prev | Next

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

2008-11-01

Re: Occasional Slow Commit David Rees (00:14)

2008-11-04

many tables vs large tables Kevin Neufeld (00:29)
Re: Index bloat, reindex weekly, suggestions etc? Tory M Blue (01:30)
Aggregate weirdness Martin Kjeldsen (10:56)
epqa; postgres performance optimizer support tool; opensource. sathiya psql (12:25)
Re: [GENERAL] epqa; postgres performance optimizer support tool; opensource. Sathish Duraiswamy (13:08)
Re: Aggregate weirdness Tom Lane (13:39)
Installation Error of postgresql-8.1.5 with perl. praveen (14:20)
Re: Installation Error of postgresql-8.1.5 with perl. praveen (14:47)
Re: Installation Error of postgresql-8.1.5 with perl. Tom Lane (14:49)
Re: epqa; postgres performance optimizer support tool;opensource. David Fetter (16:11)

2008-11-05

Re: Installation Error of postgresql-8.1.5 with perl. praveen (07:01)
PostgreSQL OR performance Віталій Тимчишин (11:12)
lru_multiplier and backend page write-outs Peter Schuller (12:28)
Re: Installation Error of postgresql-8.1.5 with perl. Tom Lane (15:24)
Re: PostgreSQL OR performance Tom Lane (15:34)
Re: PostgreSQL OR performance Jeff Davis (16:31)
Create and drop temp table in 8.3.4 Kevin Grittner (18:45)
Re: Create and drop temp table in 8.3.4 Kevin Grittner (19:05)
Query planner cost estimate less than the sum of its parts? Scott Carey (20:00)
Re: lru_multiplier and backend page write-outs Greg Smith (20:44)
Re: Query planner cost estimate less than the sum of its parts? Gregory Stark (21:22)
Re: Query planner cost estimate less than the sum of its parts? Scott Carey (22:19)
Re: Create and drop temp table in 8.3.4 Kevin Grittner (23:16)

2008-11-06

Re: Create and drop temp table in 8.3.4 Tom Lane (01:35)
Re: Occasional Slow Commit David Rees (03:25)
Re: Installation Error of postgresql-8.1.5 with perl. praveen (05:22)
Re: lru_multiplier and backend page write-outs Peter Schuller (10:19)
Re: Occasional Slow Commit Peter Schuller (10:21)
server space increasing very fast but transaction are very low brahma tiwari (10:45)
Re: PostgreSQL OR performance Віталій Тимчишин (10:46)
Re: server space increasing very fast but transaction are very low Tino Schwarze (10:57)
Re: server space increasing very fast but transaction are very low Richard Huxton (11:04)
Re: server space increasing very fast but transaction are very low Guillaume Cottenceau (11:57)
Re: PostgreSQL OR performance Helio Campos Mello de Andrade (12:26)
Re: Occasional Slow Commit David Rees (15:47)
Re: Occasional Slow Commit Scott Marlowe (16:07)
Re: PostgreSQL OR performance Віталій Тимчишин (16:33)
Re: PostgreSQL OR performance Richard Huxton (16:44)
Re: PostgreSQL OR performance Helio Campos Mello de Andrade (16:44)
Re: PostgreSQL OR performance Віталій Тимчишин (17:37)
Re: Occasional Slow Commit David Rees (18:46)
Re: Create and drop temp table in 8.3.4 Kevin Grittner (19:02)
Re: Create and drop temp table in 8.3.4 Joshua D. Drake (19:17)
Re: Create and drop temp table in 8.3.4 Kevin Grittner (19:35)
Re: Create and drop temp table in 8.3.4 Scott Carey (21:05)
Re: Create and drop temp table in 8.3.4 Kevin Grittner (21:49)
Re: Create and drop temp table in 8.3.4 Scott Marlowe (22:05)
Re: lru_multiplier and backend page write-outs Greg Smith (22:10)
Re: Create and drop temp table in 8.3.4 Kevin Grittner (22:33)
Re: Create and drop temp table in 8.3.4 Scott Marlowe (22:45)
Re: lru_multiplier and backend page write-outs Peter Schuller (23:04)
Re: Create and drop temp table in 8.3.4 Kevin Grittner (23:04)

2008-11-07

Re: Create and drop temp table in 8.3.4 Scott Marlowe (00:03)
Re: Create and drop temp table in 8.3.4 David Rees (02:21)
Re: PostgreSQL OR performance Віталій Тимчишин (09:14)
Re: PostgreSQL OR performance David Wilson (10:07)
Re: PostgreSQL OR performance Richard Huxton (10:45)

2008-11-10

Improve Seq scan performance Lutischán Ferenc (06:50)
Re: Improve Seq scan performance Craig Ringer (06:55)
Re: Improve Seq scan performance Vladimir Sitnikov (07:37)
Re: Improve Seq scan performance Craig Ringer (07:59)
Re: Improve Seq scan performance Vladimir Sitnikov (08:18)
Oddity with view Jim 'Decibel!' Nasby (08:27)
Re: Improve Seq scan performance Craig Ringer (08:41)
Re: Oddity with view Tom Lane (13:06)
Re: Improve Seq scan performance Lutischán Ferenc (16:19)
Simple indexed IN query takes 40 seconds Andrus (16:25)
Re: Simple indexed IN query takes 40 seconds Tom Lane (16:29)
slow full table update firerox (16:30)
Re: slow full table update tv (16:41)
Re: Simple indexed IN query takes 40 seconds tv (17:12)
paging on windows Anshul Dutta (17:14)
Re: Oddity with view Jim 'Decibel!' Nasby (18:16)
Re: Oddity with view Richard Huxton (18:21)
Re: Simple indexed IN query takes 40 seconds Andrus (18:23)
Re: Oddity with view Tom Lane (18:31)
Re: Oddity with view (now with test case) Jim 'Decibel!' Nasby (18:36)
Re: Oddity with view (now with test case) Tom Lane (19:31)
Re: Oddity with view (now with test case) Jim 'Decibel!' Nasby (21:06)

2008-11-11

Re: Oddity with view (now with test case) Tom Lane (03:20)
Re: Create and drop temp table in 8.3.4 Matthew Wakeling (14:52)
Re: Create and drop temp table in 8.3.4 Aidan Van Dyk (15:07)
Re: Oddity with view (now with test case) Jim 'Decibel!' Nasby (18:08)
Re: Oddity with view (now with test case) Tom Lane (19:15)
Using index for IS NULL query Andrus (19:55)
Re: Using index for IS NULL query Tom Lane (20:45)
Re: Using index for IS NULL query Andreas Kretschmer (20:47)
Re: Using index for IS NULL query Andreas Kretschmer (20:50)
Re: Using index for IS NULL query Tomas Vondra (21:01)
Re: Oddity with view (now with test case) Jim 'Decibel!' Nasby (22:42)
Re: Using index for IS NULL query Vladimir Sitnikov (23:00)
Re: Using index for IS NULL query Scott Marlowe (23:34)

2008-11-12

Re: Oddity with view (now with test case) Tom Lane (02:34)
Index usage with sub select or inner joins Julien Theulier (13:22)
Re: Using index for IS NULL query Matthew Wakeling (13:29)
Re: Index usage with sub select or inner joins Joshua Tolley (13:54)
Re: Index usage with sub select or outer joins Julien Theulier (15:09)
Re: slow full table update firerox (16:25)
Performance Question - - (16:27)
Re: slow full table update tv (16:47)
Re: Performance Question J Sisson (16:48)
Re: Performance Question tv (16:56)
Increasing select max(datecol) from bilkaib where datecol<=date'2008-11-01' and (cr='00' or db='00') speed Andrus (17:02)
Disk usage question Franck Routier (17:02)
Re: Performance Question Fernando Hevia (17:16)
Re: slow full table update firerox (17:25)
Re: Increasing select max(datecol) from bilkaib where datecol<=date'2008-11-01' and (cr='00' or db='00') speed Matthew Wakeling (17:26)
Re: Increasing select max(datecol) from bilkaib where datecol<=date'2008-11-01' and (cr='00' or db='00') speed Vladimir Sitnikov (17:28)
Re: Increasing select max(datecol) from bilkaib where datecol<=date'2008-11-01' and (cr='00' or db='00') speed Matthew Wakeling (17:33)
Re: slow full table update Richard Huxton (17:45)
Re: slow full table update Vladimir Sitnikov (17:58)
Re: Increasing select max(datecol) from bilkaib where datecol<=date'2008-11-01' and (cr='00' or db='00') speed Andrus (18:06)
Re: Increasing select max(datecol) from bilkaib where datecol<=date'2008-11-01' and (cr='00' or db='00') speed Vladimir Sitnikov (19:26)
Re: Increasing select max(datecol) from bilkaib wheredatecol<=date'2008-11-01' and (cr='00' or db='00') speed hubert depesz lubaczewski (19:39)
Re: Increasing select max(datecol) from bilkaib where datecol<=date'2008-11-01' and (cr='00' or db='00') speed Andrus (19:44)
Re: Increasing select max(datecol) from bilkaib wheredatecol<=date'2008-11-01' and (cr='00' or db='00') speed Andrus (19:57)
Re: slow full table update Tom Lane (20:54)
Re: slow full table update Scott Marlowe (20:55)
Re: Performance Question Tom Lane (20:57)
Re: slow full table update firerox (22:47)
Re: slow full table update Scott Marlowe (22:58)
Re: Disk usage question Scott Marlowe (23:44)

2008-11-13

Re: slow full table update Tomas Vondra (00:13)
Re: slow full table update Tomas Vondra (00:20)
Re: Using index for IS NULL query Tomas Vondra (00:27)
Re: Performance Question Scott Marlowe (02:26)
Re: Performance Question Dave Page (08:55)
Slow SQL query (14-15 seconds) Bruno Baguette (11:02)
Re: Performance Question Merlin Moncure (13:05)
Re: Slow SQL query (14-15 seconds) Tomasz Myrta (13:16)
Re: Slow SQL query (14-15 seconds) Matthew Wakeling (13:28)
Re: Slow SQL query (14-15 seconds) Tom Lane (13:31)
Re: Slow SQL query (14-15 seconds) Bruno Baguette (14:19)
Re: Slow SQL query (14-15 seconds) Vladimir Sitnikov (14:29)
Re: Slow SQL query (14-15 seconds) Tom Lane (14:30)
Re: Slow SQL query (14-15 seconds) Bruno Baguette (14:39)
Re: Slow SQL query (14-15 seconds) Bruno Baguette (15:22)
crosstab speed Jeremiah Elliott (20:42)
Re: crosstab speed Scott Marlowe (21:41)
Re: crosstab speed Joe Conway (22:06)

2008-11-14

Difference in query plan Patrice Beliveau (16:14)
Re: Difference in query plan Richard Huxton (16:47)
Re: Difference in query plan Patrice Beliveau (17:07)
Re: Difference in query plan Richard Huxton (17:14)

2008-11-15

Re: PostgreSQL OR performance Віталій Тимчишин (13:55)
Re: PostgreSQL OR performance Віталій Тимчишин (13:57)
Re: PostgreSQL OR performance Tom Lane (17:07)

2008-11-16

Re: slow full table update PFC (14:50)
Re: Improve Seq scan performance PFC (14:54)
Re: Performance Question PFC (15:20)

2008-11-17

Re: PostgreSQL OR performance Віталій Тимчишин (09:52)
Re: Improve Seq scan performance PFC (10:51)
Bad performance on simple query Dimi Paun (15:53)
Re: Bad performance on simple query Alan Hodgson (16:28)
Re: Bad performance on simple query Scott Marlowe (16:53)
Re: Bad performance on simple query Dimi Paun (17:07)
Re: Bad performance on simple query Scott Marlowe (17:16)
Re: Bad performance on simple query Dimi Paun (17:31)
Re: Bad performance on simple query Scott Marlowe (17:40)
Re: Bad performance on simple query ries van Twisk (17:45)
Re: Bad performance on simple query Dimi Paun (18:14)
Re: Bad performance on simple query Dave Page (20:47)

2008-11-18

Performance and IN clauses Kynn Jones (15:53)
Re: Performance and IN clauses Matthew Wakeling (16:12)
Re: Performance and IN clauses tv (16:38)
Re: Performance and IN clauses Mark Roberts (23:29)

2008-11-19

Re: Performance and IN clauses Tomas Vondra (00:49)
PostgreSQL NOT IN performance Віталій Тимчишин (11:51)
Re: PostgreSQL NOT IN performance DANIEL CRISTIAN CRUZ (12:22)
Re: PostgreSQL NOT IN performance Alvaro Herrera (13:11)
Re: PostgreSQL NOT IN performance Stephan Szabo (14:44)
Re: PostgreSQL NOT IN performance Віталій Тимчишин (14:55)
Re: PostgreSQL NOT IN performance Віталій Тимчишин (15:12)
Very Urgent : Sequences Problem Kranti™ K K Parisa (15:54)
Re: [PERFORM] Very Urgent : Sequences Problem Tino Wildenhain (16:31)
Re: [PERFORM] Very Urgent : Sequences Problem Josh Berkus (16:31)
Re: [PERFORM] Very Urgent : Sequences Problem Merlin Moncure (16:40)
Re: [PERFORM] Very Urgent : Sequences Problem tv (16:53)
Hash join on int takes 8..114 seconds Andrus (20:29)
Re: Hash join on int takes 8..114 seconds PFC (23:28)

2008-11-20

Re: Very Urgent : Sequences Problem Greg Smith (05:04)
Re: Hash join on int takes 8..114 seconds Andrus (09:12)
Re: Hash join on int takes 8..114 seconds Richard Huxton (10:45)
Re: Hash join on int takes 8..114 seconds Andrus (11:14)
Re: Hash join on int takes 8..114 seconds Richard Huxton (11:22)
Re: Hash join on int takes 8..114 seconds PFC (13:46)

2008-11-21

Re: Performance and IN clauses Tomas Vondra (01:09)
Re: Hash join on int takes 8..114 seconds Andrus (13:49)
Re: Hash join on int takes 8..114 seconds Andrus (15:12)
Re: Hash join on int takes 8..114 seconds tv (16:15)
Re: Hash join on int takes 8..114 seconds Richard Huxton (16:32)
Re: Hash join on int takes 8..114 seconds Andrus (17:51)
Re: Hash join on int takes 8..114 seconds PFC (17:57)
Re: Hash join on int takes 8..114 seconds PFC (18:31)
Re: Hash join on int takes 8..114 seconds Andrus (19:00)
Re: Hash join on int takes 8..114 seconds PFC (19:08)
Re: Hash join on int takes 8..114 seconds Andrus (19:10)
Re: Hash join on int takes 8..114 seconds Alan Hodgson (19:13)
Re: Hash join on int takes 8..114 seconds Alvaro Herrera (19:16)

Prev | Next

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

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