Home > mailing lists

Mailing lists [pgsql-performance]

1 January 2003

01:32 alter table TBL add constraint TBL_FK foreign key ... very slow Minghann Ho
01:38 alter table TBL add constraint TBL_FK foreign key ... very slow Minghann Ho
01:38 Re: alter table TBL add constraint TBL_FK foreign key ... Stephan Szabo
06:14 Re: alter table TBL add constraint TBL_FK foreign key Ron Johnson
19:01 Re: preliminary testing, two very slow situations... Tom Lane

2 January 2003

12:57 Re: preliminary testing, two very slow situations... george young
15:40 Question on hardware & server capacity Steve Wolfe
17:44 join over 12 tables takes 3 secs to plan Hilmar Lapp
18:05 Re: Question on hardware & server capacity Tom Lane
18:34 Re: join over 12 tables takes 3 secs to plan Tom Lane
18:48 Re: join over 12 tables takes 3 secs to plan Neil Conway
18:57 Re: Question on hardware & server capacity Steve Wolfe
19:03 Re: join over 12 tables takes 3 secs to plan Hilmar Lapp
19:08 Re: join over 12 tables takes 3 secs to plan Hilmar Lapp
19:11 Re: join over 12 tables takes 3 secs to plan Neil Conway
19:21 Re: join over 12 tables takes 3 secs to plan Neil Conway
19:29 Re: join over 12 tables takes 3 secs to plan Hilmar Lapp
19:42 Re: join over 12 tables takes 3 secs to plan Joe Conway
20:07 Re: Question on hardware & server capacity Hannu Krosing
20:51 Re: join over 12 tables takes 3 secs to plan Hilmar Lapp
22:01 Re: join over 12 tables takes 3 secs to plan Ron Johnson
22:24 Re: join over 12 tables takes 3 secs to plan Hilmar Lapp
22:36 Re: join over 12 tables takes 3 secs to plan Charles H. Woloszynski

3 January 2003

15:10 Re: join over 12 tables takes 3 secs to plan scott.marlowe
15:12 Re: join over 12 tables takes 3 secs to plan Jeff
15:31 Re: Question on hardware & server capacity Steve Wolfe
16:14 Re: Question on hardware & server capacity scott.marlowe
18:47 Re: Question on hardware & server capacity Steve Wolfe
20:09 Re: join over 12 tables takes 3 secs to plan Hilmar Lapp
20:09 Re: join over 12 tables takes 3 secs to plan Hilmar Lapp
20:16 Re: join over 12 tables takes 3 secs to plan Charles H. Woloszynski
20:24 Re: join over 12 tables takes 3 secs to plan Hilmar Lapp

4 January 2003

11:33 Fwd: Stock update like application Albert Cervera Areny

6 January 2003

00:25 Re: executing pgsql on Xeon-dual machine yutaka_inada@justsystem.co.jp
08:59 views vs pl/pgsql Tomasz Myrta
17:12 Re: Question on hardware & server capacity Josh Berkus

7 January 2003

09:31 7.3.1 index use / performance Achilleus Mantzios
09:56 Re: [SQL] 7.3.1 index use / performance Tomasz Myrta
10:13 Re: [SQL] 7.3.1 index use / performance Achilleus Mantzios
13:27 Re: 7.3.1 index use / performance Stephan Szabo
14:19 Re: [SQL] 7.3.1 index use / performance Achilleus Mantzios
14:30 Re: [SQL] 7.3.1 index use / performance Tom Lane
14:56 Re: [SQL] 7.3.1 index use / performance Achilleus Mantzios
15:04 Re: [GENERAL] PostgreSQL and memory usage scott.marlowe
15:09 Re: [GENERAL] PostgreSQL and memory usage Tom Lane
15:44 Re: [SQL] 7.3.1 index use / performance Tom Lane
16:29 Re: [SQL] 7.3.1 index use / performance Achilleus Mantzios
16:40 Re: [SQL] 7.3.1 index use / performance Tom Lane
16:43 Re: [SQL] 7.3.1 index use / performance Achilleus Mantzios
16:45 Re: [SQL] 7.3.1 index use / performance Rod Taylor
17:26 Re: [SQL] 7.3.1 index use / performance Tom Lane
18:03 Re: [GENERAL] PostgreSQL and memory usage Fred Moyer
18:30 path Claiborne, Aldemaco Earl (Al)
21:24 Re: [GENERAL] PostgreSQL and memory usage scott.marlowe

8 January 2003

11:27 Unions and where optimisation Boris Klug
11:45 Re: [SQL] 7.3.1 index use / performance Achilleus Mantzios
12:08 Re: Unions and where optimisation Hannu Krosing
12:28 Re: Unions and where optimisation Tomasz Myrta
12:36 Re: Unions and where optimisation Tomasz Myrta
12:37 Re: Unions and where optimisation Boris Klug
12:56 Re: Unions and where optimisation Hannu Krosing
13:32 postgresql in cluster of servers enediel
13:47 Re: Unions and where optimisation Michael Paesold
14:14 Re: Unions and where optimisation Boris Klug
15:33 Re: [SQL] 7.3.1 index use / performance Tom Lane
17:05 Re: postgresql in cluster of servers Josh Berkus
19:14 Re: postgresql in cluster of servers Ron Johnson
20:47 Fw: postgresql in cluster of servers enediel
21:38 Re: Fw: postgresql in cluster of servers Ron Johnson

9 January 2003

15:20 Re: Fw: postgresql in cluster of servers pginfo
15:40 Fw: Fw: postgresql in cluster of servers enediel
18:27 Re: Fw: Fw: postgresql in cluster of servers scott.marlowe
19:33 Fw: Fw: Fw: postgresql in cluster of servers enediel

11 January 2003

16:53 "IN" or "=" and "OR" Vernon Wu
23:03 Re: join over 12 tables takes 3 secs to plan Neil Conway

12 January 2003

02:10 Re: "IN" or "=" and "OR" Tom Lane
13:52 Re: join over 12 tables takes 3 secs to plan Charles H. Woloszynski

13 January 2003

16:38 Accessing ANALYZE stats Josh Berkus
16:47 Re: Accessing ANALYZE stats Stephan Szabo
19:33 Cursor rowcount
20:23 Re: Cursor rowcount Tom Lane
23:05 Re: Cursor rowcount

14 January 2003

02:20 Re: Cursor rowcount Tom Lane
07:12 Re: Cursor rowcount Ron Johnson
08:50 complicated queries in pl/pgsql Tomasz Myrta
13:00 Sun vs. Mac CaptainX0r
13:06 Re: Sun vs. Mac Justin Clift
13:18 Re: Sun vs. Mac Andrew Sullivan
13:43 Re: Sun vs. Mac CaptainX0r
13:47 Re: Sun vs. Mac CaptainX0r
14:09 Re: Sun vs. Mac Tom Lane
14:11 Re: Sun vs. Mac Andrew Sullivan
14:20 Sun vs. Mac Lee Kindness
14:31 Re: Sun vs. Mac CaptainX0r
14:40 Re: Sun vs. Mac CaptainX0r
14:58 Re: Sun vs. Mac CaptainX0r
15:33 Re: Sun vs. Mac Hannu Krosing
15:51 Re: Sun vs. Mac CaptainX0r
16:02 Re: Sun vs. Mac Andrew Sullivan
16:11 Re: Sun vs. Mac - best Postgres platform? CaptainX0r
16:17 Re: Sun vs. Mac Tom Lane
16:28 Re: Sun vs. Mac scott.marlowe
16:29 Re: Sun vs. Mac CaptainX0r
16:32 Re: Sun vs. Mac - best Postgres platform? Andrew Sullivan
16:39 Re: Sun vs. Mac - best Postgres platform? eric soroos
16:41 Re: Sun vs. Mac CaptainX0r
16:42 Re: complicated queries in pl/pgsql Josh Berkus
17:01 Re: Sun vs. Mac - best Postgres platform? CaptainX0r
17:18 Re: Sun vs. Mac - best Postgres platform? Andrew Sullivan
17:39 Re: Sun vs. Mac CaptainX0r
17:44 How good I can get Vernon Wu
18:51 Multiple databases Noah Silverman
18:54 Re: Multiple databases Rod Taylor
18:58 Re: Multiple databases Noah Silverman
20:30 Re: Multiple databases Josh Berkus
21:56 Re: Sun vs. Mac - best Postgres platform? Justin Clift
22:02 Re: Sun vs. Mac - best Postgres platform? Andrew Sullivan

15 January 2003

03:12 Re: Sun vs. Mac Tom Lane
16:13 Re: Sun vs. Mac - gprof output CaptainX0r
16:47 7.3.1 New install, large queries are slow Roman Fail
17:58 Re: complicated queries in pl/pgsql Tomasz Myrta
18:14 Re: 7.3.1 New install, large queries are slow Tomasz Myrta
18:17 Re: 7.3.1 New install, large queries are slow Josh Berkus
18:37 Re: 7.3.1 New install, large queries are slow Stephan Szabo
18:51 Re: 7.3.1 New install, large queries are slow Rod Taylor
19:03 Re: 7.3.1 New install, large queries are slow Andrew Sullivan
19:33 Re: complicated queries in pl/pgsql Josh Berkus
19:46 Re: 7.3.1 New install, large queries are slow Hannu Krosing

16 January 2003

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

17 January 2003

03:54 Re: 7.3.1 New install, large queries are slow Roman Fail
04:06 Re: 7.3.1 New install, large queries are slow Tom Lane
05:00 Re: 7.3.1 New install, large queries are slow Stephan Szabo
09:47 index usage Timur Irmatov
11:29 Re: 7.3.1 New install, large queries are slow Charles H. Woloszynski
12:01 Re: 7.3.1 New install, large queries are slow Jeff
12:49 Implicit casting and JOIN syntax constraints Roman Fail
12:57 Re: index usage Tom Lane
13:09 Re: index usage Timur Irmatov
13:11 Re: 7.3.1 New install, large queries are slow Tom Lane
13:16 Re: 7.3.1 New install, large queries are slow Andrew Sullivan
13:33 Re: index usage Andrew Sullivan
13:41 Re: Implicit casting and JOIN syntax constraints Andrew Sullivan
15:14 Re: 7.3.1 New install, large queries are slow Josh Berkus
15:33 Strange Join question Noah Silverman
15:37 Re: 7.3.1 New install, large queries are slow Tom Lane
15:51 Re: Strange Join question Patrick Hatcher
15:56 Re: 7.3.1 New install, large queries are slow Bruce Momjian
16:03 Re: 7.3.1 New install, large queries are slow Andrew Sullivan
16:04 Re: 7.3.1 New install, large queries are slow Tom Lane
17:04 Re: 7.3.1 New install, large queries are slow Jeff

18 January 2003

02:51 Re: 7.3.1 New install, large queries are slow Tom Lane
03:38 x86-64 and PostgreSQL Ron Johnson
05:07 Re: x86-64 and PostgreSQL Ron Johnson
05:07 Re: x86-64 and PostgreSQL Tom Lane
05:39 Re: 7.3.1 New install, large queries are slow Dennis Björklund
17:54 Re: x86-64 and PostgreSQL Andrew Sullivan
17:55 Re: 7.3.1 New install, large queries are slow Andrew Sullivan

20 January 2003

04:29 Re: x86-64 and PostgreSQL Shridhar Daithankar
04:34 Re: 7.3.1 New install, large queries are slow Shridhar Daithankar
05:14 Re: 7.3.1 New install, large queries are slow Tom Lane
05:44 Re: 7.3.1 New install, large queries are slow Shridhar Daithankar
07:41 Very large caches (was Re: 7.3.1 New install, large queries are slow) Ron Johnson
07:52 Re: x86-64 and PostgreSQL Ron Johnson
07:59 Re: x86-64 and PostgreSQL Shridhar Daithankar
10:06 Re: x86-64 and PostgreSQL Ron Johnson
10:11 Re: x86-64 and PostgreSQL Shridhar Daithankar
13:16 Re: Very large caches (was Re: 7.3.1 New install, large queries are slow) Tom Lane
19:40 Re: 7.3.1 New install, large queries are slow Roman Fail
20:15 Re: 7.3.1 New install, large queries are slow Josh Berkus
20:33 Re: 7.3.1 New install, large queries are slow Roman Fail
21:39 subscribe Rudi Starcevic

21 January 2003

06:21 Re: x86-64 and PostgreSQL James H. Cloos Jr.
19:21 Postgres 7.3.1 poor insert/update/search performance esp WRT Oracle Seth Robertson
19:46 Re: Postgres 7.3.1 poor insert/update/search performance Stephan Szabo
20:09 Re: Postgres 7.3.1 poor insert/update/search performance Seth Robertson
20:33 Re: Postgres 7.3.1 poor insert/update/search performance Tom Lane
23:44 Re: Postgres 7.3.1 poor insert/update/search performance Brian Hirt

22 January 2003

00:50 Performance between triggers/functions written in C and PL/PGSQL Ludwig Lim
05:19 Re: Postgres 7.3.1 poor insert/update/search performance Seth Robertson
10:05 Re: Postgres 7.3.1 poor insert/update/search performance Andrew Sullivan
14:21 Re: Postgres 7.3.1 poor insert/update/search performance Tom Lane
14:33 Re: [GENERAL] optimizing query Stephan Szabo
16:15 Re: Postgres 7.3.1 poor insert/update/search performance Seth Robertson
16:56 Slow query on OS X box Patrick Hatcher
17:22 Re: Performance between triggers/functions written in C and PL/PGSQL Josh Berkus
18:27 Re: Slow query on OS X box Rod Taylor
19:10 Re: Slow query on OS X box Ron Johnson
19:25 Re: Slow query on OS X box Patrick Hatcher
19:25 Re: Slow query on OS X box Tomasz Myrta
20:27 Query plan and Inheritance. Weird behavior John Lange
20:39 Re: Slow query on OS X box Tom Lane
21:41 Re: Slow query on OS X box Rod Taylor
21:45 Proposal: relaxing link between explicit JOINs and execution order Tom Lane
21:51 Re: Terrible performance on wide selects Tom Lane
22:26 Re: [HACKERS] Terrible performance on wide selects Dann Corbit
22:27 Re: Proposal: relaxing link between explicit JOINs and execution order Sean Chittenden
22:28 Re: [HACKERS] Terrible performance on wide selects Tom Lane
22:28 Re: Proposal: relaxing link between explicit JOINs and execution order Tom Lane
22:28 Re: [HACKERS] Terrible performance on wide selects Dann Corbit
22:30 Re: Slow query on OS X box Patrick Hatcher
22:35 Re: Proposal: relaxing link between explicit JOINs and execution order Josh Berkus
22:35 Re: [HACKERS] Terrible performance on wide selects Tom Lane
22:37 Re: [HACKERS] Terrible performance on wide selects Dann Corbit
22:38 Re: Proposal: relaxing link between explicit JOINs and execution order Tom Lane
22:38 Re: [HACKERS] Terrible performance on wide selects Dann Corbit
22:49 Re: [HACKERS] Terrible performance on wide selects Tom Lane
23:14 Re: [HACKERS] Terrible performance on wide selects Dann Corbit
23:29 Re: Query plan and Inheritance. Weird behavior Stephan Szabo

23 January 2003

00:11 Re: Query plan and Inheritance. Weird behavior John Lange
00:27 Same query, same performance alexandre :: aldeia digital
00:45 Re: Query plan and Inheritance. Weird behavior Stephan Szabo
04:08 Re: Query plan and Inheritance. Weird behavior Tom Lane
06:21 types & index usage Timur Irmatov
06:23 Re: Same query, same performance Tomasz Myrta
07:16 Re: [GENERAL] optimizing query Chantal Ackermann
08:12 Re: [HACKERS] Terrible performance on wide selects Hannu Krosing
08:29 Re: [HACKERS] Terrible performance on wide selects Hannu Krosing
08:33 Re: [HACKERS] Terrible performance on wide selects Hannu Krosing
08:44 Re: [HACKERS] Terrible performance on wide selects Hannu Krosing
08:56 Re: [HACKERS] Terrible performance on wide selects Daniel Kalchev
12:41 Re: [HACKERS] Terrible performance on wide selects Tom Lane
12:47 Re: [HACKERS] Terrible performance on wide selects Tom Lane
12:52 Re: [HACKERS] Terrible performance on wide selects Tom Lane
13:09 Re: [GENERAL] optimizing query Stephan Szabo
13:39 Re: [GENERAL] optimizing query Tom Lane
13:47 Re: Query plan and Inheritance. Weird behavior John Lange
14:17 Re: [GENERAL] optimizing query Chantal Ackermann
14:18 Re: [HACKERS] Terrible performance on wide selects Curt Sampson
15:15 Re: Same query, same performance Josh Berkus
15:58 Re: [HACKERS] Terrible performance on wide selects Hannu Krosing
20:27 Re: Same query, same performance alexandre :: aldeia digital
21:03 Re: Same query, same performance alexandre :: aldeia digital

24 January 2003

03:22 Crash Recovery Noah Silverman
03:37 Does "correlation" mislead the optimizer on large tables? Ron Mayer
05:08 Re: Crash Recovery Tom Lane
05:35 Re: Does "correlation" mislead the optimizer on large tables? Tom Lane
11:22 Re: Crash Recovery Andrew Sullivan
11:53 Re: Crash Recovery Ron Johnson
12:12 Crash Recovery, pt 2 Ron Johnson
13:26 Having trouble with backups (was: Re: Crash Recovery) Carlos Moreno
14:07 Re: Crash Recovery, pt 2 Andrew Sullivan
14:31 Re: Having trouble with backups (was: Re: Crash Recovery) Rod Taylor
14:32 Re: Having trouble with backups (was: Re: Crash Recovery) Justin Clift
14:37 Re: Having trouble with backups (was: Re: Crash Recovery) Andrew Sullivan
14:50 Re: Does "correlation" mislead the optimizer on large Stephan Szabo
17:26 Re: Crash Recovery, pt 2 Ron Johnson
17:57 Mount options for Ext3? Josh Berkus
18:10 Re: Does "correlation" mislead the optimizer on large Ron Mayer
18:41 Re: Does "correlation" mislead the optimizer on large Ron Mayer
19:02 Re: Does "correlation" mislead the optimizer on large Tom Lane
19:27 Re: Having trouble with backups (was: Re: Crash Recovery) Tom Lane
20:21 Re: Does "correlation" mislead the optimizer on large Noah Silverman
21:06 Multiple databases one directory Noah Silverman
21:23 Re: Does "correlation" mislead the optimizer on large Ron Mayer
21:28 Re: Multiple databases one directory Josh Berkus
21:59 WEIRD CRASH?!?! Noah Silverman
22:03 Re: WEIRD CRASH?!?! Josh Berkus
22:08 Re: WEIRD CRASH?!?! Noah Silverman
22:14 Re: WEIRD CRASH?!?! Josh Berkus
22:20 Re: WEIRD CRASH?!?! Noah Silverman
22:21 Re: WEIRD CRASH?!?! scott.marlowe
22:29 Re: WEIRD CRASH?!?! Stephan Szabo
22:30 Re: Mount options for Ext3? Kevin Brown
22:30 Re: Having trouble with backups (was: Re: Crash Recovery) Carlos Moreno
22:50 Re: Multiple databases one directory Tom Lane
22:59 Re: Multiple databases one directory Noah Silverman
23:10 Re: WEIRD CRASH?!?! Tom Lane
23:10 Re: Having trouble with backups (was: Re: Crash Recovery) Kevin Brown
23:11 Re: WEIRD CRASH?!?! Rod Taylor
23:14 Re: WEIRD CRASH?!?! Tom Lane
23:14 Re: WEIRD CRASH?!?! Noah Silverman
23:16 Re: Mount options for Ext3? Tom Lane
23:19 Re: Having trouble with backups (was: Re: Crash Recovery) Tom Lane
23:20 Re: WEIRD CRASH?!?! Rod Taylor
23:29 Re: Having trouble with backups (was: Re: Crash Recovery) Tom Lane
23:38 Re: WEIRD CRASH?!?! Tom Lane

25 January 2003

00:11 Re: Mount options for Ext3? Kevin Brown
00:22 Re: Mount options for Ext3? Josh Berkus
00:50 Re: Mount options for Ext3? Kevin Brown
00:58 Re: Mount options for Ext3? Tom Lane
01:10 Re: WEIRD CRASH?!?! Tom Lane
02:13 Re: Mount options for Ext3? Kevin Brown
02:21 Re: Having trouble with backups (was: Re: Crash Recovery) Curt Sampson
04:46 WAL replay logic (was Re: Mount options for Ext3?) Tom Lane
08:12 Re: WAL replay logic (was Re: Mount options for Ext3?) Kevin Brown
13:20 Re: Having trouble with backups (was: Re: Crash Recovery) Andrew Sullivan
13:23 Re: Having trouble with backups (was: Re: Crash Recovery) Carlos Moreno
15:17 Re: Having trouble with backups (was: Re: Crash Recovery) Andrew Sullivan
16:44 Re: WEIRD CRASH?!?! Andrew Sullivan
16:57 LOCK TABLE & speeding up mass data loads Ron Johnson
17:07 Re: LOCK TABLE & speeding up mass data loads Rod Taylor
17:19 Re: LOCK TABLE & speeding up mass data loads Ron Johnson
21:21 Re: Mount options for Ext3? pgsql.spam@vinz.nl

26 January 2003

03:27 Re: Proposal: relaxing link between explicit JOINs and execution order Tom Lane
03:35 Re: Mount options for Ext3? Tom Lane
06:04 Re: Mount options for Ext3? Ron Johnson
19:24 bigserial vs serial - which one I'd have to use? Medve Gabor
21:10 Re: LOCK TABLE & speeding up mass data loads Curt Sampson
22:54 Re: [GENERAL] optimizing query Bruce Momjian

27 January 2003

06:18 Re: 7.3.1 New install, large queries are slow Sean Chittenden
07:08 Re: LOCK TABLE & speeding up mass data loads Ron Johnson
07:18 Re: bigserial vs serial - which one I'd have to use? Ron Johnson
07:44 Re: LOCK TABLE & speeding up mass data loads Shridhar Daithankar
07:54 Re: LOCK TABLE & speeding up mass data loads Ron Johnson
07:56 Re: LOCK TABLE & speeding up mass data loads Shridhar Daithankar
08:00 Re: LOCK TABLE & speeding up mass data loads Shridhar Daithankar
08:23 Re: LOCK TABLE & speeding up mass data loads Curt Sampson
08:34 Re: 7.3.1 New install, large queries are slow Curt Sampson
13:17 Re: 7.3.1 New install, large queries are slow Ron Johnson
17:23 Re: Mount options for Ext3? Josh Berkus
17:32 Re: bigserial vs serial - which one I'd have to use? Josh Berkus
17:43 Re: Mount options for Ext3? Ron Johnson
17:55 Re: bigserial vs serial - which one I'd have to use? Ron Johnson
18:11 Re: Mount options for Ext3? Bruce Momjian
18:28 Re: WAL replay logic (was Re: Mount options for Ext3?) Bruce Momjian
18:40 Indexing foreign keys Matt Mello
18:56 Re: Indexing foreign keys Matt Mello
19:10 Re: 7.3.1 New install, large queries are slow Bruce Momjian
19:13 Re: Indexing foreign keys Josh Berkus
19:15 Re: Indexing foreign keys Ron Johnson
19:19 Re: Indexing foreign keys Stephan Szabo
19:25 Re: Indexing foreign keys Josh Berkus
22:05 Re: Indexing foreign keys Ron St.Pierre
23:42 Re: 7.3.1 New install, large queries are slow Ron Johnson

28 January 2003

03:46 Re: Indexing foreign keys Matt Mello
03:51 Re: Indexing foreign keys Matt Mello
05:49 Re: Indexing foreign keys Stephan Szabo
08:54 Re: 7.3.1 New install, large queries are slow Curt Sampson
13:15 Re: Indexing foreign keys Ron Johnson
15:29 inefficient query plan with left joined view Andreas Pflug
18:05 Re: inefficient query plan with left joined view Tom Lane
18:38 Re: inefficient query plan with left joined view Andreas Pflug
22:12 Re: inefficient query plan with left joined view Tom Lane

29 January 2003

02:19 Re: Query plan and Inheritance. Weird behavior John Lange
04:37 Re: Query plan and Inheritance. Weird behavior Tom Lane
06:25 1 char in the world Matt Mello
07:22 Re: Query plan and Inheritance. Weird behavior Andras Kadinger
08:50 Re: 1 char in the world Justin Clift
08:53 Re: 1 char in the world Hannu Krosing
13:58 Re: 1 char in the world Tom Lane
16:30 Re: Query plan and Inheritance. Weird behavior John Lange
21:29 Re: 1 char in the world Matt Mello
21:59 Re: 1 char in the world Tom Lane
23:03 Re: Query plan and Inheritance. Weird behavior Andras Kadinger

30 January 2003

06:25 Strangae Query Plans Anil Kumar
07:09 Re: Strangae Query Plans Anil Kumar
08:43 Re: Strangae Query Plans Rajesh Kumar Mallah.
15:34 One large v. many small Noah Silverman
15:59 Re: One large v. many small Josh Berkus
16:02 Re: One large v. many small Andrew Sullivan
16:24 Re: One large v. many small Noah Silverman
17:13 Re: One large v. many small Jeff
17:14 Re: One large v. many small Robert Treat
20:27 Re: One large v. many small Chad Thompson
21:18 Re: Postgres 7.3.1 poor insert/update/search performance Neil Conway

31 January 2003

02:04 Re: Postgres 7.3.1 poor insert/update/search performance Curt Sampson
02:57 Re: One large v. many small Curt Sampson
04:03 Re: One large v. many small Josh Berkus
04:28 Re: One large v. many small Shridhar Daithankar
15:50 Re: One large v. many small Josh Berkus
16:24 Re: One large v. many small Curtis Faith
16:29 Re: One large v. many small (fwd) Jeff
16:43 Re: One large v. many small (fwd) Josh Berkus
21:16 not using index for select min(...) Don Bowman
23:49 Re: not using index for select min(...) Josh Berkus
23:49 Re: not using index for select min(...) Andrew Sullivan