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 - January 2003

Prev | Next

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

2003-01-01

alter table TBL add constraint TBL_FK foreign key ... very slow Minghann Ho (03:32)
alter table TBL add constraint TBL_FK foreign key ... very slow Minghann Ho (03:38)
Re: alter table TBL add constraint TBL_FK foreign key ... Stephan Szabo (03:38)
Re: alter table TBL add constraint TBL_FK foreign key Ron Johnson (08:14)
Re: 7.3.1 New install, large queries are slow Tomasz Myrta (09:59)
Re: preliminary testing, two very slow situations... Tom Lane (21:01)

2003-01-02

Re: preliminary testing, two very slow situations... george young (15:57)
Question on hardware & server capacity Steve Wolfe (17:42)
join over 12 tables takes 3 secs to plan Hilmar Lapp (19:42)
Re: Question on hardware & server capacity Tom Lane (19:57)
Re: join over 12 tables takes 3 secs to plan Tom Lane (20:24)
Re: join over 12 tables takes 3 secs to plan Neil Conway (20:41)
Re: Question on hardware & server capacity Steve Wolfe (20:59)
Re: join over 12 tables takes 3 secs to plan Hilmar Lapp (21:03)
Re: join over 12 tables takes 3 secs to plan Hilmar Lapp (21:08)
Re: join over 12 tables takes 3 secs to plan Neil Conway (21:11)
Re: join over 12 tables takes 3 secs to plan Neil Conway (21:21)
Re: join over 12 tables takes 3 secs to plan Hilmar Lapp (21:29)
Re: join over 12 tables takes 3 secs to plan Joe Conway (21:40)
Re: Question on hardware & server capacity Hannu Krosing (22:07)
Re: join over 12 tables takes 3 secs to plan Hilmar Lapp (22:49)

2003-01-03

Re: join over 12 tables takes 3 secs to plan Ron Johnson (00:01)
Re: join over 12 tables takes 3 secs to plan Hilmar Lapp (00:24)
Re: join over 12 tables takes 3 secs to plan Charles H. Woloszynski (00:36)
Re: join over 12 tables takes 3 secs to plan scott.marlowe (17:01)
Re: join over 12 tables takes 3 secs to plan Jeff (17:12)
Re: Question on hardware & server capacity Steve Wolfe (17:31)
Re: Question on hardware & server capacity scott.marlowe (18:06)
Re: join over 12 tables takes 3 secs to plan Hilmar Lapp (19:38)
Re: Question on hardware & server capacity Steve Wolfe (20:49)
Re: join over 12 tables takes 3 secs to plan Hilmar Lapp (22:09)
Re: [PERFORM] join over 12 tables takes 3 secs to plan Charles H. Woloszynski (22:16)
Re: join over 12 tables takes 3 secs to plan Hilmar Lapp (22:22)

2003-01-04

Fwd: Stock update like application Albert Cervera Areny (13:31)

2003-01-06

Re: executing pgsql on Xeon-dual machine yutaka_inada (02:27)
views vs pl/pgsql Tomasz Myrta (11:03)
Re: Question on hardware & server capacity Josh Berkus (19:14)

2003-01-07

Re: PostgreSQL and memory usage Dann Corbit (03:32)
Re: [SQL] 7.3.1 index use / performance Tomasz Myrta (12:00)
Re: [PERFORM] 7.3.1 index use / performance Stephan Szabo (15:27)
7.3.1 index use / performance Achilleus Mantzios (15:39)
Re: [SQL] 7.3.1 index use / performance Achilleus Mantzios (16:21)
Re: [SQL] [PERFORM] 7.3.1 index use / performance Tom Lane (16:29)
Re: PostgreSQL and memory usage scott.marlowe (16:55)
Re: PostgreSQL and memory usage Tom Lane (17:09)
Re: [SQL] [PERFORM] 7.3.1 index use / performance Tom Lane (17:44)
Re: 7.3.1 function problem: ERROR: cache lookup failed for type 0 Tom Lane (18:22)
Re: 7.3.1 function problem: ERROR: cache lookup failed Joe Conway (18:39)
Re: [SQL] [PERFORM] 7.3.1 index use / performance Tom Lane (18:39)
Re: [SQL] 7.3.1 index use / performance Rod Taylor (18:45)
Re: [SQL] [PERFORM] 7.3.1 index use / performance Tom Lane (19:26)
Re: [PERFORM] PostgreSQL and memory usage Fred Moyer (19:46)
Re: [SQL] [PERFORM] 7.3.1 index use / performance Achilleus Mantzios (20:27)
path Claiborne, Aldemaco Earl (Al) (20:29)
Re: [SQL] [PERFORM] 7.3.1 index use / performance Achilleus Mantzios (21:05)
7.3.1 function problem: ERROR: cache lookup failed for type 0 Achilleus Mantzios (21:55)
Re: 7.3.1 function problem: ERROR: cache lookup failed Achilleus Mantzios (22:32)
Re: [SQL] [PERFORM] 7.3.1 index use / performance Achilleus Mantzios (22:38)
Re: [SQL] [PERFORM] 7.3.1 index use / performance Achilleus Mantzios (22:51)
Re: [PERFORM] PostgreSQL and memory usage scott.marlowe (23:16)

2003-01-08

Unions and where optimisation Boris Klug (13:25)
Re: Unions and where optimisation Tomasz Myrta (14:32)
Re: Unions and where optimisation Boris Klug (14:36)
Re: Unions and where optimisation Tomasz Myrta (14:40)
Re: Unions and where optimisation Michael Paesold (15:48)
Re: Unions and where optimisation Hannu Krosing (16:02)
Re: Unions and where optimisation Boris Klug (16:13)
Re: Unions and where optimisation Hannu Krosing (16:49)
postgresql in cluster of servers enediel (17:18)
Re: [SQL] [PERFORM] 7.3.1 index use / performance Tom Lane (17:32)
Re: [SQL] [PERFORM] 7.3.1 index use / performance Achilleus Mantzios (17:53)
Re: postgresql in cluster of servers Josh Berkus (19:08)
Re: postgresql in cluster of servers Ron Johnson (21:14)
Re: Fw: postgresql in cluster of servers Ron Johnson (23:38)

2003-01-09

Fw: postgresql in cluster of servers enediel (01:49)
Re: Fw: postgresql in cluster of servers pginfo (16:22)
Re: Fw: Fw: postgresql in cluster of servers scott.marlowe (20:18)
Fw: Fw: postgresql in cluster of servers enediel (20:41)

2003-01-10

Fw: Fw: Fw: postgresql in cluster of servers enediel (00:35)

2003-01-11

"IN" or "=" and "OR" Vernon Wu (18:51)

2003-01-12

Re: join over 12 tables takes 3 secs to plan Neil Conway (01:03)
Re: "IN" or "=" and "OR" Tom Lane (04:10)
Re: join over 12 tables takes 3 secs to plan Charles H. Woloszynski (15:52)

2003-01-13

Re: [PERFORM] join over 12 tables takes 3 secs to plan Charles H. Woloszynski (13:08)
Accessing ANALYZE stats Josh Berkus (18:42)
Re: complicated queries in pl/pgsql Josh Berkus (18:44)
Re: Accessing ANALYZE stats Stephan Szabo (18:46)
Cursor rowcount typea (21:33)
Re: Cursor rowcount Tom Lane (22:22)
Re: Multiple databases Josh Berkus (22:32)

2003-01-14

Re: Cursor rowcount typea (01:05)
Re: Cursor rowcount Tom Lane (04:19)
Re: Cursor rowcount Ron Johnson (09:12)
complicated queries in pl/pgsql Tomasz Myrta (10:54)
Sun vs. Mac CaptainX0r (15:00)
Re: Sun vs. Mac Justin Clift (15:09)
Re: Sun vs. Mac Andrew Sullivan (15:10)
Re: Sun vs. Mac CaptainX0r (15:18)
Re: Sun vs. Mac CaptainX0r (15:41)
Re: Sun vs. Mac Tom Lane (16:04)
Re: Sun vs. Mac Andrew Sullivan (16:08)
Sun vs. Mac Lee Kindness (16:18)
Re: Sun vs. Mac CaptainX0r (16:29)
Re: Sun vs. Mac CaptainX0r (16:38)
Re: Sun vs. Mac CaptainX0r (16:54)
Re: Sun vs. Mac CaptainX0r (17:50)
Re: Sun vs. Mac Andrew Sullivan (17:58)
Re: Sun vs. Mac - best Postgres platform? CaptainX0r (18:10)
Re: Sun vs. Mac Tom Lane (18:15)
Re: Sun vs. Mac scott.marlowe (18:26)
Re: Sun vs. Mac CaptainX0r (18:27)
Re: Sun vs. Mac - best Postgres platform? Andrew Sullivan (18:30)
Re: Sun vs. Mac - best Postgres platform? eric soroos (18:39)
Re: Sun vs. Mac CaptainX0r (18:41)
Re: Sun vs. Mac - best Postgres platform? CaptainX0r (19:01)
Re: Sun vs. Mac - best Postgres platform? Andrew Sullivan (19:18)
Re: Sun vs. Mac Hannu Krosing (19:26)
Re: 7.3.1 New install, large queries are slow Josh Berkus (19:32)
Re: Sun vs. Mac CaptainX0r (19:38)
How good I can get Vernon Wu (19:42)
Re: complicated queries in pl/pgsql Josh Berkus (20:36)
Multiple databases Noah Silverman (20:51)
Re: Multiple databases Rod Taylor (20:54)
Re: Multiple databases Noah Silverman (20:58)
Re: Sun vs. Mac - best Postgres platform? Justin Clift (23:59)

2003-01-15

Re: Sun vs. Mac - best Postgres platform? Andrew Sullivan (00:02)
Re: Sun vs. Mac Tom Lane (05:12)
Re: Sun vs. Mac - gprof output CaptainX0r (17:22)
7.3.1 New install, large queries are slow Roman Fail (18:00)
Re: complicated queries in pl/pgsql Tomasz Myrta (19:12)
Re: 7.3.1 New install, large queries are slow Tomasz Myrta (19:31)
Re: 7.3.1 New install, large queries are slow Stephan Szabo (19:44)
Re: 7.3.1 New install, large queries are slow Rod Taylor (19:53)
Re: 7.3.1 New install, large queries are slow Andrew Sullivan (20:10)
Re: 7.3.1 New install, large queries are slow Hannu Krosing (20:42)
Re: 7.3.1 New install, large queries are slow Roman Fail (23:30)

2003-01-16

Re: 7.3.1 New install, large queries are slow Kevin Brown (02:05)
Re: 7.3.1 New install, large queries are slow Stephan Szabo (03:40)
Re: 7.3.1 New install, large queries are slow Stephan Szabo (03:46)
Re: 7.3.1 New install, large queries are slow Tom Lane (04:35)
Re: 7.3.1 New install, large queries are slow Josh Berkus (04:41)
Re: 7.3.1 New install, large queries are slow Kevin Brown (04:48)
Re: 7.3.1 New install, large queries are slow Tom Lane (05:07)
Re: Sun vs. Mac - gprof output Tom Lane (06:11)
Re: 7.3.1 New install, large queries are slow Roman Fail (09:03)
Re: 7.3.1 New install, large queries are slow Kevin Brown (10:40)
Re: 7.3.1 New install, large queries are slow Ron Johnson (12:29)
Re: 7.3.1 New install, large queries are slow Hannu Krosing (12:54)
Re: 7.3.1 New install, large queries are slow Andrew Sullivan (13:17)
Re: Sun vs. Mac - gprof output CaptainX0r (13:45)
schema/db design wrt performance CaptainX0r (13:51)
Re: schema/db design wrt performance Fernando Papa (14:07)
Re: schema/db design wrt performance Andrew Sullivan (14:20)
Re: 7.3.1 New install, large queries are slow Rod Taylor (14:23)
Re: schema/db design wrt performance Ron Johnson (14:34)
Re: 7.3.1 New install, large queries are slow Tom Lane (15:13)
Re: schema/db design wrt performance Andrew Sullivan (15:39)
Re: 7.3.1 New install, large queries are slow Tom Lane (15:46)
Re: schema/db design wrt performance Ron Johnson (15:50)
Re: 7.3.1 New install, large queries are slow Charles H. Woloszynski (15:53)
Re: schema/db design wrt performance Stephan Szabo (16:02)
Re: schema/db design wrt performance Andrew Sullivan (16:05)
Re: 7.3.1 New install, large queries are slow Bruce Momjian (16:18)
Re: schema/db design wrt performance Ron Johnson (16:25)
Re: schema/db design wrt performance Stephan Szabo (16:38)
Re: schema/db design wrt performance Andrew Sullivan (16:46)
Re: 7.3.1 New install, large queries are slow Stephan Szabo (17:02)
Re: 7.3.1 New install, large queries are slow Josh Berkus (17:16)
Re: schema/db design wrt performance Ron Johnson (17:24)
Re: 7.3.1 New install, large queries are slow Josh Berkus (17:28)
Re: 7.3.1 New install, large queries are slow Tom Lane (17:30)
Re: 7.3.1 New install, large queries are slow Stephan Szabo (17:47)
Re: 7.3.1 New install, large queries are slow Josh Berkus (17:52)
Re: 7.3.1 New install, large queries are slow Tom Lane (18:40)
Re: 7.3.1 New install, large queries are slow Stephan Szabo (18:43)
Re: 7.3.1 New install, large queries are slow Roman Fail (19:22)
Re: 7.3.1 New install, large queries are slow Stephan Szabo (19:35)
Re: 7.3.1 New install, large queries are slow Tom Lane (19:46)
Re: 7.3.1 New install, large queries are slow jasiek (20:48)

2003-01-17

Re: 7.3.1 New install, large queries are slow Roman Fail (05:54)
Re: 7.3.1 New install, large queries are slow Tom Lane (06:06)
Re: 7.3.1 New install, large queries are slow Stephan Szabo (07:00)
index usage Timur Irmatov (11:48)
Re: 7.3.1 New install, large queries are slow Charles H. Woloszynski (13:29)
Re: 7.3.1 New install, large queries are slow Jeff (14:00)
Implicit casting and JOIN syntax constraints Roman Fail (14:48)
Re: index usage Tom Lane (14:57)
Re: index usage Timur Irmatov (15:08)
Re: 7.3.1 New install, large queries are slow Tom Lane (15:11)
Re: 7.3.1 New install, large queries are slow Andrew Sullivan (15:15)
Re: index usage Andrew Sullivan (15:33)
Re: Implicit casting and JOIN syntax constraints Andrew Sullivan (15:41)
Re: 7.3.1 New install, large queries are slow Josh Berkus (17:08)
Strange Join question Noah Silverman (17:28)
Re: 7.3.1 New install, large queries are slow Tom Lane (17:33)
Re: Strange Join question Patrick Hatcher (17:38)
Re: 7.3.1 New install, large queries are slow Bruce Momjian (17:52)
Re: 7.3.1 New install, large queries are slow Andrew Sullivan (17:59)
Re: 7.3.1 New install, large queries are slow Tom Lane (18:01)
Re: 7.3.1 New install, large queries are slow Jeff (18:39)

Prev | Next

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

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