pgsql-performance 2008-11 Thread Index (1/2)

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

Peripheral Links

Text Size: Normal / Large
Donate
Contact

Header And Logo

PostgreSQL

|

The world's most advanced open source database.

Site Navigation

pgsql-performance 2008-11 Thread Index (1/2)

Last updated: Wed Jan 18 04:15:28 2012
305 messages

Main Index
[Prev Page]
[Next Page]

Seq scan over 3.3 millions of rows instead of using date and pattern indexes Andrus (Sun 30 20:42)
Query optimization tmp (Sun 30 19:12)

Re: Query optimization Marc Cousin (Sun 30 19:37)

Increasing GROUP BY CHAR columns speed Andrus (Fri 28 15:12)

Re: Increasing GROUP BY CHAR columns speed Scott Carey (Fri 28 17:07)

Re: Increasing GROUP BY CHAR columns speed Andrus (Fri 28 17:59)

Re: Increasing GROUP BY CHAR columns speed Scott Marlowe (Fri 28 18:24)

Re: Increasing GROUP BY CHAR columns speed Scott Carey (Fri 28 19:51)

Re: Increasing GROUP BY CHAR columns speed Andrus (Fri 28 19:57)
Re: Increasing GROUP BY CHAR columns speed Andrus (Fri 28 20:31)
Re: Increasing GROUP BY CHAR columns speed Scott Marlowe (Fri 28 20:34)
Re: Increasing GROUP BY CHAR columns speed Andrus (Sat 29 17:44)
Re: Increasing GROUP BY CHAR columns speed Greg Stark (Sun 30 13:02)

<Possible follow-ups>
Re: Increasing GROUP BY CHAR columns speed Andrus (Fri 28 20:44)

performance tuning queries Kevin Kempter (Thu 27 04:50)

Re: performance tuning queries PFC (Thu 27 08:44)
Re: performance tuning queries A. Kretschmer (Thu 27 08:55)
Re: performance tuning queries Mario Weilguni (Thu 27 10:09)

Memory Allocation Ryan Hansen (Wed 26 22:10)

Re: Memory Allocation Alan Hodgson (Wed 26 22:18)
Re: Memory Allocation Carlos Moreno (Wed 26 22:57)
Re: Memory Allocation Tom Lane (Wed 26 22:58)
Re: Memory Allocation Scott Carey (Wed 26 23:00)

Re: Memory Allocation Kevin Grittner (Wed 26 23:09)

Re: Memory Allocation Scott Carey (Wed 26 23:52)

Re: Memory Allocation Kevin Grittner (Fri 28 22:28)

many to many performance Chavdar Kopoev (Wed 26 15:38)

Re: many to many performance Craig Ringer (Wed 26 17:40)
<Possible follow-ups>
many to many performance Chavdar Kopoev (Wed 26 19:47)
Re: many to many performance Chavdar Kopoev (Thu 27 16:40)

Partition table query performance Greg Jaman (Wed 26 04:07)

Re: Partition table query performance Gregory Stark (Thu 27 00:48)

Re: Partition table query performance Greg Jaman (Thu 27 17:25)

Deteriorating performance when loading large objects Vegard Bønes (Tue 25 12:54)

Re: Deteriorating performance when loading large objects Ivan Voras (Tue 25 13:18)
Re: Deteriorating performance when loading large objects Tom Lane (Tue 25 13:37)

Re: Deteriorating performance when loading large objects Vegard Bønes (Thu 27 19:05)

Re: Deteriorating performance when loading large objects Tom Lane (Thu 27 21:29)

Re: Deteriorating performance when loading large objects Mario Weilguni (Fri 28 08:30)
Re: Deteriorating performance when loading large objects Vegard Bønes (Fri 28 15:32)

Monitoring buffercache... Kevin Kempter (Mon 24 18:49)

Re: Monitoring buffercache... Brad Nicholson (Mon 24 19:45)
Re: Monitoring buffercache... Scott Marlowe (Mon 24 19:46)

Re: Monitoring buffercache... Brad Nicholson (Mon 24 19:52)

Re: Monitoring buffercache... Scott Marlowe (Mon 24 21:24)

Re: Monitoring buffercache... Greg Smith (Tue 25 04:48)

Re: Monitoring buffercache... Scott Marlowe (Tue 25 04:54)

Re: Monitoring buffercache... Mark Kirkwood (Tue 25 19:38)

Re: Monitoring buffercache... Greg Smith (Tue 25 04:34)

limit clause produces wrong query plan Andrus (Sun 23 21:41)

Message not available
- Re: limit clause produces wrong query plan Andrus (Mon 24 19:13)

Increasing pattern index query speed Andrus (Sat 22 20:41)

Re: Increasing pattern index query speed Richard Huxton (Mon 24 09:36)

Re: Increasing pattern index query speed Andrus (Mon 24 20:33)

Re: Increasing pattern index query speed Scott Carey (Mon 24 22:51)

Re: Increasing pattern index query speed Andrus (Wed 26 19:25)

Re: Increasing pattern index query speed Scott Carey (Wed 26 22:27)
Re: Increasing pattern index query speed Andrus (Fri 28 14:58)

Re: Increasing pattern index query speed Richard Huxton (Wed 26 10:41)

Re: Increasing pattern index query speed Andrus (Wed 26 18:57)

Re: Increasing pattern index query speed Richard Huxton (Wed 26 19:07)
Re: Increasing pattern index query speed Andrus (Wed 26 19:40)
Re: Increasing pattern index query speed Richard Huxton (Wed 26 19:55)
Re: Increasing pattern index query speed Andrus (Wed 26 20:11)
Re: Increasing pattern index query speed Andrus (Wed 26 20:21)
Re: Increasing pattern index query speed Richard Huxton (Wed 26 20:33)

Re: Increasing pattern index query speed Mario Weilguni (Wed 26 14:21)

seq scan over 3.3 million rows instead of single key index access Andrus (Sat 22 20:41)

Re: seq scan over 3.3 million rows instead of single key index access Gregory Stark (Sat 22 23:04)

Re: seq scan over 3.3 million rows instead of single key index access Tom Lane (Sat 22 23:59)
Re: seq scan over 3.3 million rows instead of single key index access Andrus (Sun 23 04:21)

Re: seq scan over 3.3 million rows instead of single key index access A. Kretschmer (Sun 23 12:20)

Re: seq scan over 3.3 million rows instead of single key index access Andreas Kretschmer (Sun 23 08:10)

Re: seq scan over 3.3 million rows instead of single keyindex access Andrus (Sun 23 12:41)

Re: seq scan over 3.3 million rows instead of single key index access Andreas Kretschmer (Sun 23 08:13)

Perc 3 DC Glyn Astill (Sat 22 14:18)

Re: Perc 3 DC Scott Marlowe (Sat 22 16:16)

Re: Perc 3 DC Glyn Astill (Sat 22 16:59)

Re: Perc 3 DC Scott Marlowe (Sat 22 18:27)

Re: Perc 3 DC Glyn Astill (Sat 22 22:00)

Re: Perc 3 DC Steve Clark (Mon 24 13:24)

Re: Perc 3 DC Glyn Astill (Mon 24 14:49)

Re: Perc 3 DC Scott Marlowe (Mon 24 14:52)
Re: Perc 3 DC Glyn Astill (Mon 24 15:06)
Re: Perc 3 DC Scott Marlowe (Mon 24 15:18)
Re: Perc 3 DC PFC (Mon 24 17:02)
Re: Perc 3 DC Simon Waters (Mon 24 16:14)
Re: Perc 3 DC Scott Marlowe (Mon 24 16:24)

Hash join on int takes 8..114 seconds Andrus (Wed 19 20:40)

Re: Hash join on int takes 8..114 seconds PFC (Wed 19 23:28)

Re: Hash join on int takes 8..114 seconds Andrus (Thu 20 09:12)

Re: Hash join on int takes 8..114 seconds Richard Huxton (Thu 20 10:45)

Re: Hash join on int takes 8..114 seconds Andrus (Thu 20 11:14)

Re: Hash join on int takes 8..114 seconds Richard Huxton (Thu 20 11:22)

Re: Hash join on int takes 8..114 seconds Andrus (Fri 21 13:49)

Re: Hash join on int takes 8..114 seconds PFC (Thu 20 13:45)

Re: Hash join on int takes 8..114 seconds Andrus (Fri 21 15:16)

Re: Hash join on int takes 8..114 seconds tv (Fri 21 16:14)
Re: Hash join on int takes 8..114 seconds Andrus (Fri 21 19:00)
Re: Hash join on int takes 8..114 seconds PFC (Fri 21 19:07)
Re: Hash join on int takes 8..114 seconds Alan Hodgson (Fri 21 19:13)
Re: Hash join on int takes 8..114 seconds Tomas Vondra (Fri 21 21:22)
Re: Hash join on int takes 8..114 seconds Richard Huxton (Fri 21 16:32)
Re: Hash join on int takes 8..114 seconds Andrus (Fri 21 17:51)
Re: Hash join on int takes 8..114 seconds PFC (Fri 21 17:57)
Re: Hash join on int takes 8..114 seconds Andrus (Fri 21 19:10)
Re: Hash join on int takes 8..114 seconds Alvaro Herrera (Fri 21 19:17)
Re: Hash join on int takes 8..114 seconds Andrus (Fri 21 19:45)
Re: Hash join on int takes 8..114 seconds Alvaro Herrera (Fri 21 19:48)
Re: Hash join on int takes 8..114 seconds Andrus (Fri 21 20:09)
Re: Hash join on int takes 8..114 seconds Alvaro Herrera (Fri 21 20:21)
Re: Hash join on int takes 8..114 seconds Tomas Vondra (Fri 21 20:48)
Re: Hash join on int takes 8..114 seconds Andrus (Fri 21 21:53)
Re: Hash join on int takes 8..114 seconds Scott Carey (Fri 21 23:11)
Re: Hash join on int takes 8..114 seconds PFC (Fri 21 18:31)
Re: Hash join on int takes 8..114 seconds Tom Lane (Fri 21 20:07)
Re: Hash join on int takes 8..114 seconds PFC (Sat 22 17:09)
Re: Hash join on int takes 8..114 seconds Andrus (Sat 22 20:19)
Re: Hash join on int takes 8..114 seconds PFC (Sun 23 07:21)
Re: Hash join on int takes 8..114 seconds Andrus (Sun 23 14:40)
Re: Hash join on int takes 8..114 seconds Tomas Vondra (Sun 23 18:47)
Re: Hash join on int takes 8..114 seconds Andrus (Sun 23 21:41)
Re: Hash join on int takes 8..114 seconds Tomas Vondra (Sun 23 23:11)
Re: Hash join on int takes 8..114 seconds Scott Carey (Sun 23 21:40)
Re: Hash join on int takes 8..114 seconds Andrus (Sun 23 22:44)
Re: Hash join on int takes 8..114 seconds Tomas Vondra (Sun 23 23:39)
Re: Hash join on int takes 8..114 seconds Andrus (Mon 24 13:16)
Re: Hash join on int takes 8..114 seconds tv (Mon 24 13:39)
Re: Hash join on int takes 8..114 seconds Andrus (Mon 24 21:16)

Very Urgent : Sequences Problem Kranti™ K K Parisa (Wed 19 15:54)

Re: Very Urgent : Sequences Problem Josh Berkus (Wed 19 16:34)

Re: Very Urgent : Sequences Problem Greg Smith (Thu 20 05:04)

Re: Very Urgent : Sequences Problem Merlin Moncure (Wed 19 16:43)

Re: Very Urgent : Sequences Problem tv (Wed 19 16:52)

PostgreSQL NOT IN performance Віталій Тимчишин (Wed 19 11:51)

Re: PostgreSQL NOT IN performance DANIEL CRISTIAN CRUZ (Wed 19 12:50)

Re: PostgreSQL NOT IN performance Віталій Тимчишин (Wed 19 15:12)

Re: PostgreSQL NOT IN performance Alvaro Herrera (Wed 19 13:11)
Re: PostgreSQL NOT IN performance Stephan Szabo (Wed 19 15:08)

Re: PostgreSQL NOT IN performance Віталій Тимчишин (Wed 19 14:55)

Performance and IN clauses Kynn Jones (Tue 18 15:53)

Re: Performance and IN clauses Matthew Wakeling (Tue 18 16:12)

Re: Performance and IN clauses tv (Tue 18 16:38)

Re: Performance and IN clauses Mark Roberts (Tue 18 23:27)

Re: Performance and IN clauses Tomas Vondra (Wed 19 00:49)
Re: Performance and IN clauses Tomas Vondra (Fri 21 01:35)

Bad performance on simple query Dimi Paun (Mon 17 16:26)

Re: Bad performance on simple query Alan Hodgson (Mon 17 16:28)
Re: Bad performance on simple query Scott Marlowe (Mon 17 16:53)

Re: Bad performance on simple query Dimi Paun (Mon 17 17:07)

Re: Bad performance on simple query Scott Marlowe (Mon 17 17:16)

Re: Bad performance on simple query Dimi Paun (Mon 17 17:31)

Re: Bad performance on simple query Scott Marlowe (Mon 17 17:40)
Re: Bad performance on simple query ries van Twisk (Mon 17 17:45)
Re: Bad performance on simple query Dimi Paun (Mon 17 18:14)
Re: Bad performance on simple query Dave Page (Mon 17 20:47)

Difference in query plan Patrice Beliveau (Fri 14 16:29)

Re: Difference in query plan Richard Huxton (Fri 14 16:47)
<Possible follow-ups>
Re: Difference in query plan Patrice Beliveau (Fri 14 17:07)

Re: Difference in query plan Richard Huxton (Fri 14 17:14)

crosstab speed Jeremiah Elliott (Thu 13 20:42)

Re: crosstab speed Scott Marlowe (Thu 13 21:41)
Re: crosstab speed Joe Conway (Thu 13 23:06)

Slow SQL query (14-15 seconds) Bruno Baguette (Thu 13 12:10)

Re: Slow SQL query (14-15 seconds) Matthew Wakeling (Thu 13 13:28)

Re: Slow SQL query (14-15 seconds) Bruno Baguette (Thu 13 18:02)

Re: Slow SQL query (14-15 seconds) Tom Lane (Thu 13 13:31)

Re: Slow SQL query (14-15 seconds) Bruno Baguette (Thu 13 14:19)

Re: Slow SQL query (14-15 seconds) Tom Lane (Thu 13 14:30)

Re: Slow SQL query (14-15 seconds) Tomasz Myrta (Thu 13 13:36)
Re: Slow SQL query (14-15 seconds) Vladimir Sitnikov (Thu 13 14:29)

Re: Slow SQL query (14-15 seconds) Bruno Baguette (Thu 13 18:02)

Disk usage question Franck Routier (Wed 12 22:28)

Re: Disk usage question Scott Marlowe (Wed 12 23:44)

Increasing select max(datecol) from bilkaib where datecol<=date'2008-11-01' and (cr='00' or db='00') speed Andrus (Wed 12 17:06)

Main Index
[Prev Page]
[Next Page]

Mail converted by MHonArc

Privacy Policy | About PostgreSQL
Copyright © 1996 – 2012 PostgreSQL Global Development Group