Skip site navigation (1)
Skip section navigation (2)
Peripheral Links
pgsql-performance - July 2009
Prev | Next
2009-07-01
- Re: random slow query Scott Carey (00:11)
- Re: random slow query Mike Ivanov (00:58)
- - Slow Query Rui Carvalho (09:40)
- Re: - Slow Query Mike Ivanov (16:39)
- Re: - Slow Query justin (16:41)
- Re: - Slow Query Mike Ivanov (17:12)
- Re: - Slow Query Rui Carvalho (17:37)
- Re: - Slow Query Scott Marlowe (17:42)
- Re: - Slow Query Tom Lane (17:52)
- Re: - Slow Query Mike Ivanov (17:53)
- Re: - Slow Query Scott Marlowe (18:00)
- Re: - Slow Query Tom Lane (18:07)
2009-07-02
- regression ? 8.4 do not apply One-Time Filter to subquery Sergey Burladyan (00:08)
- Re: slow DELETE on 12 M row table Janet Jacobsen (22:48)
2009-07-03
- Re: slow DELETE on 12 M row table Scott Marlowe (00:21)
- Most effective insert or replace Sergei Politov (11:06)
- Re: Most effective insert or replace Matthew Wakeling (11:20)
- Re: - Slow Query Віталій Тимчишин (11:22)
- Re: - Slow Query Віталій Тимчишин (11:29)
2009-07-04
- Six PostgreSQL questions from a pokerplayer Patvs (18:51)
2009-07-06
- Re: Six PostgreSQL questions from a pokerplayer Craig Ringer (05:33)
- Bundling postgreSQL with my Java application Saurabh Dave (05:48)
- Re: Bundling postgreSQL with my Java application Mark Mielke (06:00)
- Re: Six PostgreSQL questions from a pokerplayer Mark Kirkwood (06:13)
- Re: Bundling postgreSQL with my Java application Guillaume Cottenceau (07:07)
- Re: Bundling postgreSQL with my Java application Saurabh Dave (07:17)
- Re: Bundling postgreSQL with my Java application Mark Mielke (08:27)
- Re: Six PostgreSQL questions from a pokerplayer Scott Carey (08:43)
- Re: Six PostgreSQL questions from a pokerplayer Scott Carey (08:47)
- Re: Six PostgreSQL questions from a pokerplayer Greg Stark (09:40)
- Re: Six PostgreSQL questions from a pokerplayer Stephen Frost (10:23)
- Re: Six PostgreSQL questions from a pokerplayer Greg Smith (13:26)
- Re: Six PostgreSQL questions from a pokerplayer Dave Page (13:48)
- Re: Six PostgreSQL questions from a pokerplayer Mark Mielke (19:27)
- Re: Bundling postgreSQL with my Java application justin (23:16)
2009-07-07
- Re: Six PostgreSQL questions from a pokerplayer Craig Ringer (04:51)
- Re: Bundling postgreSQL with my Java application Saurabh Dave (05:11)
- Re: Six PostgreSQL questions from a pokerplayer Scott Marlowe (05:51)
- Re: Bundling postgreSQL with my Java application Scott Marlowe (05:59)
- Re: Speeding up a query. Simon Riggs (09:38)
- Re: Speeding up a query. Hartman, Matthew (12:32)
- Re: Bundling postgreSQL with my Java application Kevin Grittner (13:40)
2009-07-08
- Re: [PERFORM] Postgres Clustering Tim Uckun (02:26)
- Performance difference between IN(...) and ANY(...) operator Gnanam (06:50)
- Maximum size of an XML document Franclin Foping (16:27)
2009-07-09
- Data caching Martin Chlupac (10:29)
- Re: Data caching Richard Huxton (10:52)
- Sorting by an arbitrary criterion Craig James (16:26)
- embedded sql regression from 8.2.4 to 8.3.7 Haszlakiewicz, Eric (16:31)
- Re: Sorting by an arbitrary criterion Grzegorz Jaśkiewicz (16:35)
- Huge difference in query performance between 8.3 and 8.4 (possibly) Robin Houston (16:35)
- Re: Sorting by an arbitrary criterion Tom Lane (16:38)
- Re: Sorting by an arbitrary criterion Kevin Grittner (16:39)
- Re: Sorting by an arbitrary criterion Alexander Staubo (16:39)
- Re: Huge difference in query performance between 8.3 and8.4 (possibly) Alvaro Herrera (17:02)
- Re: Huge difference in query performance between 8.3 and 8.4 (possibly) Tom Lane (17:09)
- Re: Huge difference in query performance between 8.3 and 8.4 (possibly) Hartman, Matthew (17:36)
- Re: Sorting by an arbitrary criterion hubert depesz lubaczewski (18:11)
- Re: Sorting by an arbitrary criterion Hartman, Matthew (18:13)
- Re: Sorting by an arbitrary criterion Grzegorz Jaśkiewicz (20:25)
- Poor query performance Alex (21:34)
- Re: Poor query performance Alex (21:35)
2009-07-10
- Re: embedded sql regression from 8.2.4 to 8.3.7 Albe Laurenz (09:05)
- Cost performace question paulo matadr (14:39)
- Re: Cost performace question Kevin Grittner (14:51)
- Re: autovacuum hung? Brian Cox (18:11)
- Res: Cost performace question paulo matadr (19:33)
2009-07-13
- Performance comparison between Postgres and Greenplum Suvankar Roy (11:23)
- Re: Res: Cost performace question Matthew Wakeling (12:21)
- Very big insert/join performance problem (bacula) Marc Cousin (13:40)
- Re: Very big insert/join performance problem (bacula) SystemManagement (14:37)
- Re: Very big insert/join performance problem (bacula) Marc Cousin (14:51)
- Re: Very big insert/join performance problem (bacula) Andres Freund (15:06)
- Re: embedded sql regression from 8.2.4 to 8.3.7 Haszlakiewicz, Eric (15:51)
- Re: embedded sql regression from 8.2.4 to 8.3.7 Haszlakiewicz, Eric (18:24)
- Poor overall performance unless regular VACUUM FULL Wayne Conrad (19:31)
- Odd performance / query plan with bitmasked field as opposed to equality Frank Joerdens (20:46)
2009-07-14
- Re: Very big insert/join performance problem (bacula) Marc Cousin (05:54)
- Re: Very big insert/join performance problem (bacula) Richard Huxton (08:15)
- Re: Very big insert/join performance problem (bacula) Richard Huxton (08:23)
- Re: Very big insert/join performance problem (bacula) Marc Cousin (09:16)
- Re: Very big insert/join performance problem (bacula) Marc Cousin (09:22)
- Re: embedded sql regression from 8.2.4 to 8.3.7 Albe Laurenz (09:39)
- BUG #4919: CREATE USER command slows down system performance Lauris Ulmanis (12:39)
- CREATE USER command slows down when user count per server reaches up to 500 000 Lauris Ulmanis (13:14)
- Re: BUG #4919: CREATE USER command slows down system performance Heikki Linnakangas (15:09)
2009-07-15
- Repeated Query is much slower in PostgreSQL8.2.4 than DB2 9.1 ning (03:10)
- Re: Performance comparison between Postgres and Greenplum Scott Marlowe (03:40)
- Re: Poor overall performance unless regular VACUUM FULL Scott Marlowe (04:52)
- Re: Poor overall performance unless regular VACUUM FULL David Wilson (04:53)
- Re: Performance comparison between Postgres and Greenplum Suvankar Roy (05:33)
- Re: Poor query performance Greg Stark (06:52)
- Re: Poor query performance Alex (07:50)
- Re: Poor query performance Greg Stark (08:22)
- Re: Repeated Query is much slower in PostgreSQL8.2.4 than DB2 9.1 Craig Ringer (08:26)
- Re: Repeated Query is much slower in PostgreSQL8.2.4 than DB2 9.1 Craig Ringer (08:27)
- Re: Repeated Query is much slower in PostgreSQL8.2.4 than DB2 9.1 Greg Stark (08:37)
- Re: Poor query performance Alex (08:42)
- Strange memory behavior with rails - caching in connection? Alex (08:44)
- Re: Repeated Query is much slower in PostgreSQL8.2.4 than DB2 9.1 ning (08:51)
- Re: Repeated Query is much slower in PostgreSQL8.2.4 than DB2 9.1 ning (09:05)
- Re: Performance comparison between Postgres and Greenplum Scott Marlowe (09:30)
- Re: Performance comparison between Postgres and Greenplum Suvankar Roy (09:39)
- Re: BUG #4919: CREATE USER command slows down system performance Lauris Ulmanis (10:31)
- Re: Very big insert/join performance problem (bacula) Marc Cousin (11:37)
- Re: Performance comparison between Postgres and Greenplum Alex Goncharov (12:37)
- Re: Poor overall performance unless regular VACUUM FULL Wayne Conrad (12:51)
- Re: Performance comparison between Postgres and Greenplum Suvankar Roy (13:02)
- Re: Performance comparison between Postgres and Greenplum Alex Goncharov (13:18)
- Re: Very big insert/join performance problem (bacula) Alvaro Herrera (13:45)
- Re: Very big insert/join performance problem (bacula) Marc Cousin (13:53)
- Re: BUG #4919: CREATE USER command slows down systemperformance Alvaro Herrera (14:02)
- Re: BUG #4919: CREATE USER command slows down system performance toruvinn (14:21)
- Re: Poor overall performance unless regular VACUUM FULL Scott Marlowe (14:30)
- Re: BUG #4919: CREATE USER command slows down systemperformance Alvaro Herrera (14:47)
- Re: BUG #4919: CREATE USER command slows down system performance Tom Lane (14:59)
- Re: cluster index on a table Ibrahim Harrani (15:04)
- Re: [PERFORM] BUG #4919: CREATE USER command slows down system performance Marko Kreen (15:10)
- Re: [PERFORM] BUG #4919: CREATE USER command slows down system performance David Wilson (15:16)
- Re: [PERFORM] BUG #4919: CREATE USER command slows down system performance Tom Lane (15:30)
- Re: [PERFORM] BUG #4919: CREATE USER command slows down system performance Marko Kreen (15:31)
- Re: Performance comparison between Postgres and Greenplum Scott Mead (15:33)
- Re: CREATE USER command slows down when user count per server reaches up to 500 000 Haszlakiewicz, Eric (21:38)
- Re: Poor overall performance unless regular VACUUM FULL Wayne Conrad (22:03)
- Re: Repeated Query is much slower in PostgreSQL8.2.4 than DB2 9.1 Mike Ivanov (22:37)
- Re: Repeated Query is much slower in PostgreSQL8.2.4 than DB2 9.1 Andres Freund (22:51)
- Re: Very big insert/join performance problem (bacula) Devin Ben-Hur (23:56)
2009-07-16
- Re: Poor overall performance unless regular VACUUM FULL Scott Carey (00:30)
- Re: cluster index on a table Scott Carey (00:33)
- Re: Poor overall performance unless regular VACUUM FULL Scott Marlowe (00:40)
- Re: Very big insert/join performance problem (bacula) Scott Carey (00:43)
- Re: Repeated Query is much slower in PostgreSQL8.2.4 than DB2 9.1 ning (00:53)
- Re: Repeated Query is much slower in PostgreSQL8.2.4 than DB2 9.1 ning (01:11)
- Re: Performance comparison between Postgres and Greenplum Greg Smith (01:14)
- Re: Performance comparison between Postgres and Greenplum Greg Smith (01:17)
- Re: cluster index on a table Justin Pitts (02:17)
- Concurrency issue under very heay loads Raji Sridar (raji) (04:59)
- Re: [PERFORM] Concurrency issue under very heay loads ramasubramanian (05:19)
- Re: Very big insert/join performance problem (bacula) Marc Cousin (05:20)
- Re: Concurrency issue under very heay loads Greenhorn (05:30)
- Re: Concurrency issue under very heay loads John R Pierce (05:34)
- Re: [PERFORM] Concurrency issue under very heay loads Scott Marlowe (06:11)
- Re: Very big insert/join performance problem (bacula) Marc Cousin (07:41)
- Re: Repeated Query is much slower in PostgreSQL8.2.4 than DB2 9.1 Andres Freund (07:45)
- Re: [PERFORM] Concurrency issue under very heay loads Albe Laurenz (09:15)
- Re: Repeated Query is much slower in PostgreSQL8.2.4 than DB2 9.1 ning (09:30)
- Re: Repeated Query is much slower in PostgreSQL8.2.4 than DB2 9.1 Andres Freund (09:33)
- Re: [PERFORM] Concurrency issue under very heay loads Allan Kamau (09:44)
- Re: Repeated Query is much slower in PostgreSQL8.2.4 than DB2 9.1 ning (09:46)
- Re: Repeated Query is much slower in PostgreSQL8.2.4 than DB2 9.1 Andres Freund (09:52)
- Re: Concurrency issue under very heay loads Bill Moran (11:11)
- Re: BUG #4919: CREATE USER command slows down systemperformance Lauris Ulmanis (11:49)
- Re: cluster index on a table Scott Mead (12:34)
- Re: cluster index on a table Scara Maccai (13:33)
- Re: Poor overall performance unless regular VACUUM FULL Wayne Conrad (15:00)
- Re: cluster index on a table Scott Carey (17:35)
- Re: cluster index on a table Justin Pitts (17:52)
- Incr/Decr Integer William Scott Jordan (17:56)
- Re: cluster index on a table Scott Carey (18:21)
- Re: [PERFORM] Incr/Decr Integer Andres Freund (18:30)
- Re: cluster index on a table Justin Pitts (18:35)
- Re: Incr/Decr Integer Richard Huxton (18:46)
- Re: cluster index on a table Kevin Grittner (19:15)
- Re: cluster index on a table Scott Carey (19:18)
- Re: Incr/Decr Integer Kevin Grittner (19:19)
- Re: cluster index on a table Greg Stark (19:46)
- Re: cluster index on a table Scott Carey (20:06)
- Re: Very big insert/join performance problem (bacula) Kevin Grittner (20:07)
- Re: cluster index on a table Kevin Grittner (20:14)
- Re: Repeated Query is much slower in PostgreSQL8.2.4 than DB2 9.1 Dimitri Fontaine (20:43)
- Re: cluster index on a table Greg Stark (20:49)
- Re: Very big insert/join performance problem (bacula) Marc Cousin (20:50)
- Re: cluster index on a table Greg Stark (21:01)
- Re: Concurrency issue under very heay loads Greg Smith (21:03)
- Re: [PERFORM] Incr/Decr Integer William Scott Jordan (21:11)
- Re: cluster index on a table Ibrahim Harrani (21:16)
- Re: [PERFORM] Incr/Decr Integer William Scott Jordan (21:20)
- Re: [PERFORM] Incr/Decr Integer Andres Freund (21:27)
- Re: Very big insert/join performance problem (bacula) Kevin Grittner (21:54)
- Re: Very big insert/join performance problem (bacula) Marc Cousin (22:03)
- Re: Very big insert/join performance problem (bacula) Devin Ben-Hur (22:29)
- Re: Very big insert/join performance problem (bacula) Kevin Grittner (22:30)
2009-07-17
- Re: cluster index on a table Scott Carey (00:02)
- Re: cluster index on a table Greg Stark (00:27)
- Re: Repeated Query is much slower in PostgreSQL8.2.4 than DB2 9.1 Mike Ivanov (01:25)
- Re: cluster index on a table Scott Carey (03:07)
- Re: Performance comparison between Postgres and Greenplum Scott Marlowe (06:24)
- Re: cluster index on a table Scara Maccai (06:45)
- Re: cluster index on a table Scara Maccai (07:22)
- Re: Strange memory behavior with rails - caching in connection? Scott Marlowe (09:06)
- Re: cluster index on a table phb07@apra.asso.fr (13:25)
- Calling conventions Matthew Wakeling (13:40)
- Re: cluster index on a table Kevin Grittner (14:14)
- Re: Concurrency issue under very heay loads Craig Ringer (14:29)
- Re: [PERFORM] Concurrency issue under very heay loads Craig Ringer (14:32)
- Re: cluster index on a table Scara Maccai (14:36)
- Re: cluster index on a table Kevin Grittner (15:26)
- Re: Calling conventions Peter Eisentraut (15:32)
- Re: Calling conventions Matthew Wakeling (16:09)
- Re: Calling conventions Tom Lane (16:34)