Search

Peripheral Links

• Home
• About
• Download
• Documentation
• Community
• Developers
• Support
• Your account

pgsql-performance - July 2009

Search archives
	(enter a message-id to go directly to that message)	Advanced Search

Prev | Next

July 1, 2009

• 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)

July 2, 2009

• 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)

July 3, 2009

• 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)

July 4, 2009

• Six PostgreSQL questions from a pokerplayer Patvs (18:51)

July 6, 2009

• 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)

July 7, 2009

• 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)

July 8, 2009

• 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)

July 9, 2009

• 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)

July 10, 2009

• 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)

July 13, 2009

• 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)

July 14, 2009

• 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)

July 15, 2009

• 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)

July 16, 2009

• 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)

July 17, 2009

• 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)

Prev | Next