Home > mailing lists

Mailing lists [pgsql-performance]

1 October 2006

23:50 selecting data from information_schema.columns performance. Steve Martin

2 October 2006

00:01 Re: selecting data from information_schema.columns performance. Tom Lane
10:07 Re: PostgreSQL runs a query much slower than BDE and Simon Riggs
12:50 How much memory in 32 bits Architecture to Shared Buffers is Possible Marcelo Costa
12:54 Re: any hope for my big query? Shaun Thomas
13:08 Re: Optimizing queries Simon Riggs
13:25 Re: archive wal's failure and load increase. Simon Riggs
13:26 Re: How much memory in 32 bits Architecture to Shared Buffers Joshua D. Drake
13:31 Re: How much memory in 32 bits Architecture to Shared Buffers is Possible Marcelo Costa
14:36 Unsubscribe uwcssa
16:08 Re: Table not getting vaccumed. Jim C. Nasby
16:11 Re: selecting data from information_schema.columns performance. Jim C. Nasby
19:36 Re: Unsubscribe Markus Schaber
20:31 Re: selecting data from information_schema.columns Steve Martin
22:50 Re: selecting data from information_schema.columns Jim Nasby
23:44 Re: Performace Optimization for Dummies Carlo Stonebanks

3 October 2006

00:03 Re: Performace Optimization for Dummies Carlo Stonebanks
00:04 Re: Performace Optimization for Dummies Carlo Stonebanks
00:05 Re: Performace Optimization for Dummies Carlo Stonebanks
00:58 Re: Forcing the use of particular execution plans Tim Truman
01:19 Re: Forcing the use of particular execution plans Tom Lane
04:00 Re: Forcing the use of particular execution plans Tim Truman
04:36 Re: High CPU Load Jérôme BENOIS
05:15 Re: Performace Optimization for Dummies Markus Schaber
05:20 Re: Performace Optimization for Dummies Markus Schaber
05:33 Performance Optimization for Dummies 2 - the SQL Carlo Stonebanks
06:32 Re: Performace Optimization for Dummies Carlo Stonebanks
06:36 Re: Performace Optimization for Dummies Carlo Stonebanks
08:54 Poor performance on very simple query ? Arnaud Lesauvage
09:01 Re: Poor performance on very simple query ? Steinar H. Gunderson
09:04 Re: Poor performance on very simple query ? Arnaud Lesauvage
09:08 Re: Poor performance on very simple query ? Alexander Staubo
09:10 Re: Poor performance on very simple query ? Tobias Brox
09:11 Re: Poor performance on very simple query ? Tobias Brox
09:14 Re: Poor performance on very simple query ? Arnaud Lesauvage
09:17 Re: Poor performance on very simple query ? Tobias Brox
09:25 Re: Poor performance on very simple query ? Arnaud Lesauvage
09:28 Re: Poor performance on very simple query ? Guillaume Cottenceau
11:35 Re: Poor performance on very simple query ? Tom Lane
11:49 Re: Unsubscribe Geoffrey
12:04 Re: Performance Optimization for Dummies 2 - the SQL Merlin Moncure
12:30 Re: Poor performance on very simple query ? Darcy Buskermolen
12:35 Re: Poor performance on very simple query ? Darcy Buskermolen
12:47 Re: Performance Optimization for Dummies 2 - the SQL Alex Stapleton
13:59 Re: Performance Optimization for Dummies 2 - the SQL Carlo Stonebanks
14:29 Re: Unsubscribe felix@crowfix.com
14:55 Re: Unsubscribe Carlo Stonebanks
15:07 Re: Performance Optimization for Dummies 2 - the SQL Carlo Stonebanks
15:41 Re: BUG #2658: Query not using index Graham Davis
16:04 Re: BUG #2658: Query not using index Chris Browne
16:12 Re: BUG #2658: Query not using index Graham Davis
16:15 Re: BUG #2658: Query not using index Graham Davis
16:21 Re: Performance Optimization for Dummies 2 - the SQL Merlin Moncure
17:04 Re: BUG #2658: Query not using index Chris Browne
17:34 Re: BUG #2658: Query not using index Graham Davis
17:38 Re: BUG #2658: Query not using index Bruno Wolff III
17:48 Re: BUG #2658: Query not using index Tom Lane
17:54 Re: BUG #2658: Query not using index Graham Davis
18:07 Re: BUG #2658: Query not using index Mark Lewis
18:25 Re: BUG #2658: Query not using index Graham Davis
18:34 Re: BUG #2658: Query not using index Mark Lewis
18:37 Re: BUG #2658: Query not using index Graham Davis
18:49 PostgreSQL Caching Adnan DURSUN
18:54 Re: BUG #2658: Query not using index Mark Lewis
19:11 Re: PostgreSQL Caching Tomeh, Husam
19:39 Re: BUG #2658: Query not using index Tom Lane
20:53 Re: PostgreSQL Caching Adnan DURSUN
21:10 Re: Forcing the use of particular execution plans Ron Mayer
21:56 Re: Forcing the use of particular execution plans Jim C. Nasby
22:29 Re: PostgreSQL Caching Tomeh, Husam
23:24 Re: PostgreSQL Caching Adnan DURSUN

4 October 2006

04:48 simple case using index on windows but not on linux simon godden
05:19 Unsubscribe Luc Delgado
06:11 Re: simple case using index on windows but not on linux Heikki Linnakangas
06:19 Re: simple case using index on windows but not on linux simon godden
06:40 Re: simple case using index on windows but not on linux simon godden
06:51 Re: simple case using index on windows but not on linux Richard Huxton
07:36 Re: simple case using index on windows but not on linux Richard Huxton
07:59 Re: slow queue-like empty table Tobias Brox
09:11 Re: Performance Optimization for Dummies 2 - the SQL Markus Schaber
09:38 Re: PostgreSQL Caching Dave Dutcher
10:45 Re: simple case using index on windows but not on linux Richard Huxton
10:47 Re: PostgreSQL Caching Brad Nicholson
10:48 Re: simple case using index on windows but not on linux simon godden
10:52 Re: PostgreSQL Caching Brad Nicholson
11:05 Re: simple case using index on windows but not on linux Richard Huxton
11:12 Re: simple case using index on windows but not on linux Dave Dutcher
11:46 Re: simple case using index on windows but not on linux simon godden
11:49 Re: simple case using index on windows but not on linux simon godden
12:23 Re: Unsubscribe Bruno Wolff III
12:30 Re: Unsubscribe Joshua D. Drake
12:44 Re: Unsubscribe Tobias Brox
12:54 Re: Unsubscribe Nolan Cafferky
12:54 Re: Unsubscribe Joshua D. Drake
13:00 Re: Unsubscribe Joshua D. Drake
13:03 Re: Unsubscribe Csaba Nagy
13:18 Re: Unsubscribe Bruno Wolff III
13:18 Re: Unsubscribe D'Arcy J.M. Cain
13:24 Re: Unsubscribe Joshua D. Drake
13:26 Re: Unsubscribe Joshua D. Drake
13:26 Re: Unsubscribe Mark Lewis
13:35 Re: Unsubscribe Csaba Nagy
13:46 Re: Unsubscribe Steve Atkins
13:48 Re: Unsubscribe Geoffrey
14:10 Re: Poor performance on very simple query ? Markus Schaber
15:01 UPDATE becomes mired / win32 Steve Peterson
15:13 Multi-key index not beeing used - bug? Tobias Brox
15:14 Re: UPDATE becomes mired / win32
15:23 Re: Performance Optimization for Dummies 2 - the SQL Carlo Stonebanks
15:25 Re: Multi-key index not beeing used - bug? Graham Davis
16:19 Re: Unsubscribe Michael Stone
17:28 Re: UPDATE becomes mired / win32 Tom Lane
17:34 Re: Multi-key index not beeing used - bug? Tom Lane
17:41 Re: Multi-key index not beeing used - bug? Tobias Brox
18:07 Re: Performance Optimization for Dummies 2 - the SQL Merlin Moncure
18:42 Re: any hope for my big query? Ben
19:41 Re: Performance Optimization for Dummies 2 - the SQL Carlo Stonebanks
22:35 pg_trgm indexes giving bad estimations? Ben
22:55 Re: pg_trgm indexes giving bad estimations? Tom Lane

5 October 2006

01:56 Re: UPDATE becomes mired / win32 Steve Peterson
02:07 Re: UPDATE becomes mired / win32 Steve Peterson
03:26 Re: Performance Optimization for Dummies 2 - the SQL Merlin Moncure
04:32 Re: Performance Optimization for Dummies 2 - the SQL Carlo Stonebanks
10:20 Re: UPDATE becomes mired / win32 Tom Lane
10:24 Re: Performance Optimization for Dummies 2 - the SQL Tom Lane
10:30 Re: Performance Optimization for Dummies 2 - the SQL Merlin Moncure
13:28 Re: Performance Optimization for Dummies 2 - the SQL Carlo Stonebanks
13:35 Re: Performance Optimization for Dummies 2 - the SQL Tom Lane
14:45 Re: Performance Optimization for Dummies 2 - the SQL Carlo Stonebanks

6 October 2006

02:24 Re: any hope for my big query? Jim Nasby
02:25 Re: Unsubscribe Jim Nasby
02:25 Re: Unsubscribe Jim Nasby
02:26 Re: Unsubscribe Jim Nasby
02:26 Re: slow queue-like empty table Jim Nasby
13:42 Re: Performance Optimization for Dummies 2 - the SQL Carlo Stonebanks
13:53 Re: Performance Optimization for Dummies 2 - the SQL Scott Marlowe
16:17 Re: Performance Optimization for Dummies 2 - the SQL Merlin Moncure
17:45 Re: Performance Optimization for Dummies 2 - the SQL Carlo Stonebanks

7 October 2006

03:36 Simple join optimized badly? Craig A. James
12:51 Re: Simple join optimized badly? Tom Lane
22:50 Re: Simple join optimized badly? Denis Lussier

8 October 2006

14:17 Re: Simple join optimized badly? Jim Nasby
22:03 Re: Simple join optimized badly? Josh Berkus
22:09 Re: Simple join optimized badly? Craig A. James
22:14 Re: Simple join optimized badly? Tom Lane
23:12 Re: Simple join optimized badly? Bruce Momjian
23:41 Re: Simple join optimized badly? Mark Kirkwood
23:45 Re: Simple join optimized badly? Craig A. James
23:48 Re: Simple join optimized badly? Craig A. James

9 October 2006

00:03 Re: Performance Optimization for Dummies 2 - the SQL Jim C. Nasby
00:06 Re: Performance Optimization for Dummies 2 - the SQL Jim C. Nasby
00:10 Re: Simple join optimized badly? Chris Browne
00:38 Re: Simple join optimized badly? Mark Kirkwood
01:44 Re: Simple join optimized badly? Tom Lane
10:49 Re: Performance Optimization for Dummies 2 - the SQL Merlin Moncure
11:02 autovacuum not working? Medora Schauer
11:11 Re: autovacuum not working? Bill Moran
11:19 Re: Performance Optimization for Dummies 2 - the SQL Merlin Moncure
11:27 Re: autovacuum not working? Medora Schauer
14:12 Re: Simple join optimized badly? Josh Berkus
14:42 Re: Simple join optimized badly? Tom Lane
15:22 odd variances in count(*) times Merlin Moncure
15:30 Re: odd variances in count(*) times Stephen Frost
15:41 Re: odd variances in count(*) times Merlin Moncure
15:45 Re: odd variances in count(*) times Steinar H. Gunderson
16:04 Re: Simple join optimized badly? Chris Browne
17:31 Re: Simple join optimized badly? Scott Marlowe
18:18 Re: Simple join optimized badly? Jim C. Nasby
18:24 Re: odd variances in count(*) times Jim C. Nasby
18:26 Re: autovacuum not working? Jim C. Nasby
18:33 Re: Simple join optimized badly? Tobias Brox
19:30 Re: Simple join optimized badly? Jim C. Nasby
19:40 Re: Simple join optimized badly? Tom Lane
19:41 Re: Simple join optimized badly? Joshua D. Drake
19:45 Re: Simple join optimized badly? Tom Lane
22:17 Re: Simple join optimized badly? Brian Herlihy

10 October 2006

00:18 Re: Simple join optimized badly? Craig A. James
00:22 Re: Simple join optimized badly? Joshua D. Drake
03:30 Re: odd variances in count(*) times Merlin Moncure
08:07 Postgre 8.0 Installation - Issues Ravindran G - TLS, Chennai.
11:00 Re: Simple join optimized badly? Jim C. Nasby
11:02 Re: Simple join optimized badly? Jim C. Nasby
11:07 Re: Simple join optimized badly? Jim C. Nasby
11:15 Re: Simple join optimized badly? Tom Lane
11:16 Re: Postgre 8.0 Installation - Issues Jim C. Nasby
11:16 Re: Simple join optimized badly? Steinar H. Gunderson
11:21 Re: Simple join optimized badly? Jim C. Nasby
11:23 Re: Simple join optimized badly? Joshua D. Drake
11:24 Re: Simple join optimized badly? Joshua D. Drake
11:25 Re: Simple join optimized badly? Joshua D. Drake
13:10 long running transactions Tobias Brox
13:23 Re: long running transactions Tom Lane
13:34 Re: Simple join optimized badly? Bruno Wolff III
13:39 Re: long running transactions Tobias Brox
13:41 Re: long running transactions Tobias Brox
13:42 Re: long running transactions Tom Lane
14:06 Re: long running transactions Tobias Brox
14:09 Re: long running transactions Tom Lane
14:13 Re: long running transactions Tobias Brox
14:18 Re: long running transactions Tom Lane
14:27 Re: Simple join optimized badly? Josh Berkus
14:50 Re: long running transactions Tobias Brox
15:05 Re: long running transactions Tom Lane
15:20 Re: long running transactions Tobias Brox
15:27 Re: long running transactions Tom Lane
15:44 Re: long running transactions Tobias Brox
16:26 Re: Simple join optimized badly? Jim C. Nasby
18:44 Scrub one large table against another Brendan Curran
19:14 Re: Scrub one large table against another Tom Lane
19:37 Re: Scrub one large table against another Brendan Curran
19:47 Re: Scrub one large table against another Tom Lane
20:46 Re: Scrub one large table against another Brendan Curran
21:35 Re: Simple join optimized badly? Mark Kirkwood
21:37 Re: Simple join optimized badly? Mark Kirkwood
22:03 Re: Scrub one large table against another Jim C. Nasby
22:22 Re: Simple join optimized badly? Brian Herlihy
23:38 Re: Simple join optimized badly? Tom Lane
23:50 Re: Scrub one large table against another Tom Lane

11 October 2006

00:58 Re: Simple join optimized badly? Brian Herlihy
11:27 Re: Simple join optimized badly? Bucky Jordan
11:51 Re: Simple join optimized badly? Heikki Linnakangas
11:53 Re: Simple join optimized badly? Bruce Momjian
12:07 Re: Simple join optimized badly? Mark Lewis
13:54 Re: Scrub one large table against another Brendan Curran
14:25 Re: Scrub one large table against another (vmstat output) Brendan Curran
17:28 Collect stats during seqscan (was: Simple join optimized badly?) Jim C. Nasby
17:53 Re: Scrub one large table against another Jim C. Nasby

12 October 2006

03:55 Re: Scrub one large table against another (vmstat output) Markus Schaber
04:50 FW: Simple join optimized badly? H.J. Sanders
06:59 Re: FW: Simple join optimized badly? Mark Kirkwood
10:53 Re: FW: Simple join optimized badly? Jim C. Nasby
11:44 Re: FW: Simple join optimized badly? Tom Lane
12:14 Hints proposal Jim C. Nasby
12:19 Re: Hints proposal Bruce Momjian
12:26 Re: Hints proposal Joshua Marsh
12:42 Re: Hints proposal Tom Lane
12:55 Re: Hints proposal Heikki Linnakangas
13:22 Re: Hints proposal Merlin Moncure
13:24 Re: Hints proposal Tom Lane
13:25 Re: [HACKERS] Hints proposal Jim C. Nasby
13:34 Re: Hints proposal Csaba Nagy
13:37 Re: FW: Simple join optimized badly? Jim C. Nasby
13:40 Re: Hints proposal Bucky Jordan
13:41 Re: [HACKERS] Hints proposal Josh Berkus
13:43 Re: Hints proposal Jeff Davis
13:46 Re: [HACKERS] Hints proposal Josh Berkus
13:46 Re: Hints proposal Jim C. Nasby
13:53 Re: Hints proposal Jim C. Nasby
14:05 Re: [HACKERS] Hints proposal Csaba Nagy
14:18 Re: [HACKERS] Hints proposal Tom Lane
14:21 Re: Hints proposal Csaba Nagy
15:00 Re: FW: Simple join optimized badly? Scott Marlowe
15:05 Re: Scrub one large table against another Brendan Curran
15:25 Re: Scrub one large table against another Tom Lane
16:04 Re: [HACKERS] Hints proposal Andrew Sullivan
16:08 Re: Hints proposal Jeff Davis
16:24 Re: [HACKERS] Hints proposal Jim C. Nasby
16:34 Re: Hints proposal Jim C. Nasby
17:57 Re: [HACKERS] Hints proposal Josh Berkus
18:07 Re: Hints proposal Arjen van der Meijden
18:19 Re: [HACKERS] Hints proposal Bucky Jordan
18:29 Re: Hints proposal Tom Lane
18:41 Re: Hints proposal Richard Broersma Jr
19:03 Re: [HACKERS] Hints proposal Alvaro Herrera
19:07 Re: FW: Simple join optimized badly? Mark Kirkwood
19:15 Re: Hints proposal Jeff Davis
19:26 Re: FW: Simple join optimized badly? Mark Kirkwood
19:41 Re: Hints proposal Jeff Davis
23:55 Re: Hints proposal Christopher Browne

13 October 2006

13:16 Re: [HACKERS] Hints proposal Jim C. Nasby
13:36 Re: [HACKERS] Hints proposal Tom Lane
14:33 Re: [HACKERS] Hints proposal Bucky Jordan
19:56 Re: [HACKERS] Hints proposal Josh Berkus
19:58 Re: [HACKERS] Hints proposal Josh Berkus
20:36 Re: [HACKERS] Hints proposal Jim C. Nasby
22:29 Re: [HACKERS] Hints proposal Alvaro Herrera

14 October 2006

01:20 Re: [HACKERS] Hints proposal Tom Lane

15 October 2006

06:53 Re: [ADMIN] autovacuum on a -mostly- r/o table Tobias Brox
11:42 Re: [ADMIN] autovacuum on a -mostly- r/o table Matthew T. O'Connor
11:52 Re: [ADMIN] autovacuum on a -mostly- r/o table Tobias Brox
18:46 Re: Performance Optimization for Dummies 2 - the SQL Carlo Stonebanks
19:27 Re: Performance Optimization for Dummies 2 - the SQL Tom Lane
19:48 Re: Performance Optimization for Dummies 2 - the SQL Carlo Stonebanks
20:58 Re: Hints proposal Craig A. James
21:28 Re: Hints proposal Craig A. James

16 October 2006

06:17 measuring shared memory usage on Windows Harald Armin Massa
07:17 Re: measuring shared memory usage on Windows Magnus Hagander
08:00 Re: Hints proposal mark@mark.mielke.cc
08:18 Re: measuring shared memory usage on Windows Harald Armin Massa
09:05 Re: measuring shared memory usage on Windows Magnus Hagander
09:18 Re: measuring shared memory usage on Windows Harald Armin Massa
09:31 Re: measuring shared memory usage on Windows Magnus Hagander
09:34 Re: Hints proposal Mark Kirkwood
09:56 Re: measuring shared memory usage on Windows David Boreham
09:57 Re: measuring shared memory usage on Windows David Boreham
10:27 Re: Hints proposal Csaba Nagy
10:38 Re: Performance Optimization for Dummies 2 - the SQL Merlin Moncure
12:36 Re: Hints proposal Brian Hurt
13:43 Re: Hints proposal Bruce Momjian
14:00 Re: Hints proposal Shaun Thomas
14:32 Re: Performance Optimization for Dummies 2 - the SQL Carlo Stonebanks
17:21 measuring shared memory usage on Windows Harald Armin Massa
17:25 Re: Hints proposal Mark Kirkwood
17:30 Re: measuring shared memory usage on Windows Harald Armin Massa
17:46 Re: Performance Optimization for Dummies 2 - the SQL Jim C. Nasby
18:07 Re: Performance Optimization for Dummies 2 - the SQL Merlin Moncure
18:37 Re: Performance Optimization for Dummies 2 - the SQL Carlo Stonebanks
18:57 Re: Performance Optimization for Dummies 2 - the SQL Carlo Stonebanks
19:28 Re: Performance Optimization for Dummies 2 - the SQL Shaun Thomas

17 October 2006

03:39 Re: Performance Optimization for Dummies 2 - the SQL Carlo Stonebanks
03:44 Re: Performance Optimization for Dummies 2 - the SQL Carlo Stonebanks
06:12 Optimization of this SQL sentence Ruben Rubio
06:21 Re: Optimization of this SQL sentence Gregory S. Williamson
06:33 Re: Optimization of this SQL sentence Ruben Rubio
06:40 Re: Optimization of this SQL sentence Ruben Rubio
06:48 Re: Optimization of this SQL sentence A. Kretschmer
06:53 Re: Optimization of this SQL sentence Alexander Staubo
07:00 Re: Optimization of this SQL sentence Heikki Linnakangas
07:25 Re: Optimization of this SQL sentence (SOLVED) Ruben Rubio
08:39 Regarding Bitmap Scan soni de
08:45 Re: Regarding Bitmap Scan A. Kretschmer
09:27 Re: Regarding Bitmap Scan Dawid Kuroczko
12:18 Re: Optimization of this SQL sentence Craig A. James
13:04 Re: Optimization of this SQL sentence Alexander Staubo
13:26 Re: Optimization of this SQL sentence Alexander Staubo
13:30 Re: Optimization of this SQL sentence Mario Weilguni
13:51 Re: Optimization of this SQL sentence Merlin Moncure
16:04 Re: Optimization of this SQL sentence Chris Browne
16:04 Re: Optimization of this SQL sentence Chris Browne
16:11 Re: Optimization of this SQL sentence Shane Ambler
16:38 Re: Optimization of this SQL sentence Christopher Browne
16:41 Re: Optimization of this SQL sentence Shane Ambler
17:01 Jdbc/postgres performance Rohit_Behl
17:28 Re: Jdbc/postgres performance Merlin Moncure
21:47 Re: Jdbc/postgres performance Bucky Jordan
23:43 Re: [HACKERS] Hints proposal Robert Treat
23:43 Re: Hints proposal Robert Treat
23:48 Re: Optimization of this SQL sentence Craig A. James
23:55 Re: Hints proposal Tom Lane

18 October 2006

00:41 Re: Jdbc/postgres performance Merlin Moncure
02:19 Re: Jdbc/postgres performance Tom Lane
04:06 Re: Optimization of this SQL sentence Ruben Rubio
06:31 Re: Optimization of this SQL sentence Mario Weilguni
07:20 Re: Optimization of this SQL sentence Mark Kirkwood
08:21 Index on two columns not used Arnaud Lesauvage
08:40 Re: Index on two columns not used Heikki Linnakangas
09:01 Re: Jdbc/postgres performance Rohit_Behl
09:07 Re: Jdbc/postgres performance Rohit_Behl
09:12 Re: Index on two columns not used Arnaud Lesauvage
09:50 Re: Optimization of this SQL sentence mark@mark.mielke.cc
09:52 Re: Jdbc/postgres performance Heikki Linnakangas
10:21 Re: Jdbc/postgres performance Merlin Moncure
10:32 Re: Jdbc/postgres performance Merlin Moncure
10:57 Re: Index on two columns not used Heikki Linnakangas
11:15 Re: Index on two columns not used Arnaud Lesauvage
11:51 Re: Index on two columns not used Heikki Linnakangas
11:58 ACCESS EXCLUSIVE lock Atesz
12:06 Re: Index on two columns not used Arnaud Lesauvage
12:28 Re: ACCESS EXCLUSIVE lock Scott Marlowe
13:56 Re: ACCESS EXCLUSIVE lock Tom Lane
14:01 Re: Hints proposal Robert Treat
14:32 Re: Index on two columns not used Tom Lane
14:51 Re: Index on two columns not used Arnaud Lesauvage
16:01 Re: Performance Optimization for Dummies 2 - the SQL Jim C. Nasby
16:10 Re: [ADMIN] autovacuum on a -mostly- r/o table Jim C. Nasby
16:17 Re: Optimization of this SQL sentence Jim C. Nasby
16:19 Re: Optimization of this SQL sentence (SOLVED) Jim C. Nasby
16:37 Re: Optimization of this SQL sentence Merlin Moncure
16:58 Postgresql 8.1.4 - performance issues for select on view using max Ioana Danes
17:13 Re: Postgresql 8.1.4 - performance issues for select on view using max Dimitri Fontaine
17:21 Re: Postgresql 8.1.4 - performance issues for select on view using max Joshua Marsh
17:34 Re: Postgresql 8.1.4 - performance issues for select on view using max Ioana Danes
17:59 Re: [ADMIN] autovacuum on a -mostly- r/o table Larry Rosenman
18:02 Re: Postgresql 8.1.4 - performance issues for select on view using max Ioana Danes
18:07 Re: Postgresql 8.1.4 - performance issues for select on Jeff Davis
18:15 UDF and cache jungmin shin
18:17 Re: [HACKERS] UDF and cache Jim C. Nasby
18:19 Re: [GENERAL] UDF and cache Jim C. Nasby
18:19 Re: Postgresql 8.1.4 - performance issues for select on view using max Dimitri Fontaine
18:34 Re: Postgresql 8.1.4 - performance issues for select on Jeff Davis
19:11 Re: Postgresql 8.1.4 - performance issues for select on Jim C. Nasby
19:22 index growth problem Graham Davis
19:32 Re: Postgresql 8.1.4 - performance issues for select on Jeff Davis
19:33 Re: index growth problem Jim C. Nasby
19:36 Re: Postgresql 8.1.4 - performance issues for select on Jim C. Nasby
19:41 Re: index growth problem Graham Davis
19:52 Re: index growth problem Jim C. Nasby
20:00 Re: index growth problem Tom Lane
20:05 Re: Postgresql 8.1.4 - performance issues for select on Tom Lane
20:06 Re: Postgresql 8.1.4 - performance issues for select on Jeff Davis

19 October 2006

02:55 Re: measuring shared memory usage on Windows Mark Kirkwood
08:24 Re: Postgresql 8.1.4 - performance issues for select on view using max Ioana Danes
08:33 Re: Postgresql 8.1.4 - performance issues for select on Ioana Danes
08:44 Re: Postgresql 8.1.4 - performance issues for select on Ioana Danes
09:39 Rohit_Behl
10:12 DB Performance decreases due to often written/accessed table Jens Schipkowski
10:37 VACUUM FULL ANALYZE on 8.1.4 is slower then on 8.0 Andrzej Zawadzki
10:44 Re: ACCESS EXCLUSIVE lock Atesz
10:56 Swappiness setting on a linux pg server Tobias Brox
11:26 Re: VACUUM FULL ANALYZE on 8.1.4 is slower then on 8.0 Michael Fuhr
11:38 Re: VACUUM FULL ANALYZE on 8.1.4 is slower then on 8.0 Tom Lane
12:00 Re: DB Performance decreases due to often written/accessed Richard Huxton
12:29 Re: Swappiness setting on a linux pg server Jim C. Nasby
13:01 Re: Swappiness setting on a linux pg server Tobias Brox
13:31 Re: Swappiness setting on a linux pg server Jim C. Nasby
13:36 Re: Swappiness setting on a linux pg server Tobias Brox
13:39 Re: Swappiness setting on a linux pg server Tobias Brox
13:45 Re: Swappiness setting on a linux pg server Jim C. Nasby
13:53 Re: Swappiness setting on a linux pg server Tobias Brox
14:00 Re: Swappiness setting on a linux pg server Jim C. Nasby
14:06 Re: DB Performance decreases due to often written/accessed table Jens Schipkowski
14:10 Re: Swappiness setting on a linux pg server Tobias Brox
14:13 Re: Swappiness setting on a linux pg server Tobias Brox
14:19 Re: DB Performance decreases due to often written/accessed Richard Huxton
14:23 Re: DB Performance decreases due to often written/accessed Jim C. Nasby
14:32 Re: DB Performance decreases due to often written/accessed table Merlin Moncure
15:00 Re: DB Performance decreases due to often written/accessed Richard Huxton
15:34 Re: DB Performance decreases due to often written/accessed table Jens Schipkowski
15:59 Re: DB Performance decreases due to often written/accessed table Merlin Moncure
16:11 Re: Swappiness setting on a linux pg server Ron
16:44 Re: Swappiness setting on a linux pg server Merlin Moncure
16:57 Re: Swappiness setting on a linux pg server Tobias Brox
17:57 Re: Swappiness setting on a linux pg server Kevin

20 October 2006

04:49 New hardware thoughts Ben Suffolk
05:01 Re: measuring shared memory usage on Windows Harald Armin Massa
05:12 Re: measuring shared memory usage on Windows Harald Armin Massa
05:14 pgBench on Windows Harald Armin Massa
08:46 Re: VACUUM FULL ANALYZE on 8.1.4 is slower then on 8.0 Markus Schaber
09:19 Re: Swappiness setting on a linux pg server Tobias Brox
11:33 Re: measuring shared memory usage on Windows David Boreham
11:43 Re: New hardware thoughts Shane Ambler
11:58 Re: New hardware thoughts Dave Cramer
15:22 Re: New hardware thoughts Ben Suffolk
15:39 Re: New hardware thoughts Ben Suffolk
15:51 Re: New hardware thoughts Joshua D. Drake
17:33 Best COPY Performance Worky Workerson
17:34 Re: New hardware thoughts Ben Suffolk
17:51 Re: New hardware thoughts alvis
19:14 VACUUM Performance Steve Oualline
19:19 Is ODBC that slow? Carlo Stonebanks
21:44 Re: [HACKERS] Hints proposal Zeugswetter Andreas ADI SD
21:44 Re: [HACKERS] Hints proposal Gregory Stark
21:44 Re: [HACKERS] Hints proposal Mischa Sandberg
21:45 Jdbc/postgres performance Behl, Rohit \(Infosys\)
21:46 Slow functional indexes? Stuart Bishop
21:47 Vacuum and Memory Loss Mike
22:04 Re: Is ODBC that slow? Merlin Moncure
22:11 Re: Best COPY Performance Merlin Moncure
23:32 Re: Is ODBC that slow? Alvaro Herrera
23:39 Re: Slow functional indexes? Merlin Moncure

21 October 2006

00:15 Re: Is ODBC that slow? Merlin Moncure
00:43 Re: Slow functional indexes? Tom Lane
00:44 Re: Is ODBC that slow? Joshua D. Drake
00:45 Re: Is ODBC that slow? Joshua D. Drake
02:02 Re: VACUUM Performance Tom Lane
07:44 Re: Index on two columns not used Péter Kovács
09:40 Re: pgBench on Windows Magnus Hagander
12:40 Re: Is ODBC that slow? Carlo Stonebanks
13:22 Optimizing disk throughput on quad Opteron John Philips
13:49 Re: Is ODBC that slow? Alvaro Herrera
13:52 Re: Is ODBC that slow? Joshua D. Drake
16:02 Re: Optimizing disk throughput on quad Opteron Joshua D. Drake
16:32 Re: Optimizing disk throughput on quad Opteron Ben Suffolk

22 October 2006

12:11 Re: Jdbc/postgres performance Dave Cramer
16:31 Re: New hardware thoughts Bucky Jordan
18:32 Re: Vacuum and Memory Loss Dave Dutcher
18:56 Re: pgBench on Windows Harald Armin Massa
19:12 Re: New hardware thoughts Arjen van der Meijden

23 October 2006

00:02 Re: New hardware thoughts Joshua D. Drake
04:33 Re: New hardware thoughts Arjen van der Meijden
05:45 Re: Vacuum and Memory Loss Richard Huxton
06:27 Re: Best COPY Performance Markus Schaber
09:17 Re: Optimizing disk throughput on quad Opteron John Philips
10:26 Re: Index on two columns not used Markus Schaber
10:51 Re: Index on two columns not used Alvaro Herrera
12:11 Re: Best COPY Performance Luke Lonergan
12:17 Re: Index on two columns not used Markus Schaber
12:38 Re: Best COPY Performance Worky Workerson
13:01 Re: Index on two columns not used Tom Lane
17:29 Re: New hardware thoughts Bucky Jordan
17:56 Re: Optimizing disk throughput on quad Opteron Vivek Khera
17:58 Re: Optimizing disk throughput on quad Opteron Joshua D. Drake
18:03 Re: New hardware thoughts Vivek Khera
18:08 Re: New hardware thoughts Joshua D. Drake
18:09 Re: Optimizing disk throughput on quad Opteron Vivek Khera
18:11 Re: Optimizing disk throughput on quad Opteron Joshua D. Drake
18:31 Re: New hardware thoughts Vivek Khera
18:33 Re: New hardware thoughts Joshua D. Drake
18:36 Re: Vacuum and Memory Loss Jim C. Nasby
18:47 Re: New hardware thoughts Jim C. Nasby
18:59 Re: Best COPY Performance Jim C. Nasby
19:08 Re: Optimizing disk throughput on quad Opteron Jim C. Nasby
19:10 Re: Best COPY Performance Joshua D. Drake
19:13 Copy database performance issue Steve
19:30 Problems using a function in a where clause Mara Dalponte
19:38 Re: Best COPY Performance Craig A. James
20:07 Re: Index on two columns not used Péter Kovács

24 October 2006

04:01 Re: Slow functional indexes? Stuart Bishop
06:29 Re: Index on two columns not used Markus Schaber
10:31 Re: Copy database performance issue Jignesh Shah
10:57 Re: Optimizing disk throughput on quad Opteron Bucky Jordan
17:11 Re: Best COPY Performance Worky Workerson
18:49 Re: Is ODBC that slow? Carlo Stonebanks
21:15 Re: Best COPY Performance Jim C. Nasby
21:17 Re: Best COPY Performance Jim C. Nasby
21:21 Re: Problems using a function in a where clause Jim C. Nasby
21:25 Re: Copy database performance issue Jim C. Nasby
21:33 Re: Best COPY Performance Worky Workerson

25 October 2006

02:37 Re: Best COPY Performance Craig A. James
08:16 Re: Best COPY Performance Alex Stapleton
09:10 Re: Best COPY Performance Worky Workerson
09:22 Re: Best COPY Performance Markus Schaber
10:20 Re: Best COPY Performance Merlin Moncure
12:07 Re: Best COPY Performance Luke Lonergan
12:22 Re: Best COPY Performance Jim C. Nasby
12:28 Re: Best COPY Performance Jim C. Nasby
12:32 Re: Problems using a function in a where clause Jim C. Nasby
12:38 Re: Best COPY Performance Merlin Moncure
12:46 commit so slow program looks frozen Carlo Stonebanks
13:26 Re: Best COPY Performance Worky Workerson
13:34 Re: Best COPY Performance Luke Lonergan
13:53 Re: Best COPY Performance Craig A. James
14:26 Re: Best COPY Performance Spiegelberg, Greg
14:29 Re: Best COPY Performance Craig A. James
14:41 Re: ACCESS EXCLUSIVE lock Atesz
15:23 Re: commit so slow program looks frozen Alvaro Herrera
15:27 Re: Best COPY Performance Worky Workerson
15:59 Re: Best COPY Performance Markus Schaber
17:08 Re: commit so slow program looks frozen Carlo Stonebanks
17:13 Re: Best COPY Performance Luke Lonergan
17:32 Re: commit so slow program looks frozen Carlo Stonebanks
17:48 Configuration Issue ? Mark Lonsdale
17:51 Re: Configuration Issue ? Joshua D. Drake
17:52 Re: commit so slow program looks frozen Brian Hurt
17:57 Re: Configuration Issue ? Mark Lonsdale
18:12 Re: Configuration Issue ? Richard Huxton
18:17 Re: Configuration Issue ? Joshua D. Drake
18:31 Re: Configuration Issue ? Mark Lonsdale
18:42 Re: Configuration Issue ? Joshua D. Drake
19:05 Re: commit so slow program looks frozen Scott Marlowe
19:11 Re: commit so slow program looks frozen Joshua D. Drake

26 October 2006

00:35 Re: Best COPY Performance Jim C. Nasby
01:22 Re: commit so slow program looks frozen Jim C. Nasby
06:22 VACUUMs take twice as long across all nodes Gavin Hamill
08:49 Re: commit so slow program looks frozen Magnus Hagander
09:00 Re: commit so slow program looks frozen Rocco Altier
11:43 Re: commit so slow program looks frozen Carlo Stonebanks
11:47 Re: VACUUMs take twice as long across all nodes Tom Lane
11:48 Re: commit so slow program looks frozen Carlo Stonebanks
12:06 Re: commit so slow program looks frozen Merlin Moncure
12:07 Re: VACUUMs take twice as long across all nodes Gavin Hamill
12:49 Stored procedure slower than sql? Matthew Peters
13:46 Re: Stored procedure slower than sql? Tom Lane
13:53 Re: Stored procedure slower than sql? Matthew Peters
14:21 Re: commit so slow program looks frozen Richard Troy
14:46 Re: commit so slow program looks frozen Richard Troy
14:49 Re: commit so slow program looks frozen Carlo Stonebanks
15:07 OT: TCL vs Perl Re: commit so slow program looks frozen mark@mark.mielke.cc
15:31 Re: OT: TCL vs Perl Re: commit so slow program looks frozen Joshua D. Drake
16:08 Re: Configuration Issue ? Jim C. Nasby
16:17 Re: VACUUMs take twice as long across all nodes Jim C. Nasby
16:20 Re: Stored procedure slower than sql? Jim C. Nasby
17:55 Re: VACUUMs take twice as long across all nodes Gavin Hamill
18:39 query slows down drastically with increased number of fields Tom Darci
18:53 Re: query slows down drastically with increased number of fields Tom Lane
19:00 Re: VACUUMs take twice as long across all nodes Jim C. Nasby
19:04 Re: query slows down drastically with increased number of fields George Pavlov
19:09 Re: VACUUMs take twice as long across all nodes Andrew Sullivan
19:37 Re: query slows down drastically with increased number of fields Jim C. Nasby
19:50 Re: query slows down drastically with increased number of fields Tom Lane
21:01 Re: query slows down drastically with increased number of Tom Darci
23:20 Index ignored with "is not distinct from", 8.2 beta2 JEAN-PIERRE PELLETIER

27 October 2006

06:20 Re: VACUUMs take twice as long across all nodes Gavin Hamill
08:46 query produces 1 GB temp file Dirk Lutzebaeck
10:09 client crashes in PQfinish soni de
10:12 Re: Regarding Bitmap Scan soni de
10:52 Re: query produces 1 GB temp file Merlin Moncure
11:34 Re: query produces 1 GB temp file Bricklen Anderson
11:48 Re: query produces 1 GB temp file Alexander Staubo
11:53 Re: query produces 1 GB temp file Dirk Lutzebäck
12:09 Re: query produces 1 GB temp file Thomas Burdairon
12:49 Re: query produces 1 GB temp file Scott Marlowe
15:08 Re: VACUUMs take twice as long across all nodes Tom Lane
15:40 Re: Best COPY Performance Worky Workerson
16:02 Re: Best COPY Performance Merlin Moncure
16:37 Re: Best COPY Performance Worky Workerson
19:19 Re: VACUUMs take twice as long across all nodes Gavin Hamill
22:01 Re: Best COPY Performance Luke Lonergan

28 October 2006

00:12 Re: Best COPY Performance Merlin Moncure
00:43 Re: Best COPY Performance Worky Workerson
00:47 Re: Best COPY Performance Worky Workerson
01:08 Re: Best COPY Performance Luke Lonergan
07:08 Re: commit so slow program looks frozen Simon Riggs
09:03 Re: Best COPY Performance Michael Artz
12:42 Re: Best COPY Performance Luke Lonergan
12:45 Re: commit so slow program looks frozen Carlo Stonebanks
12:51 Re: commit so slow program looks frozen Carlo Stonebanks
14:40 Re: commit so slow program looks frozen Merlin Moncure
19:26 partitioned table performance Andreas Kostyrka

29 October 2006

10:58 Re: VACUUMs take twice as long across all nodes Andrew Sullivan
11:10 Re: VACUUMs take twice as long across all nodes Gavin Hamill
11:34 Re: VACUUMs take twice as long across all nodes Andrew Sullivan
12:23 Re: VACUUMs take twice as long across all nodes Andreas Kostyrka
12:43 Re: VACUUMs take twice as long across all nodes Andrew Sullivan
13:14 Re: VACUUMs take twice as long across all nodes Andreas Kostyrka

30 October 2006

04:19 Re: partitioned table performance Simon Riggs
07:56 Strange plan in pg 8.1.0 Mattias Kregert
08:28 Re: Strange plan in pg 8.1.0 Steinar H. Gunderson
10:09 Re: Best COPY Performance Spiegelberg, Greg
10:28 Re: Strange plan in pg 8.1.0 Mattias Kregert
11:09 Re: Strange plan in pg 8.1.0 Tom Lane
11:23 Re: Best COPY Performance Luke Lonergan
11:40 Re: Strange plan in pg 8.1.0 Mattias Kregert
11:51 Re: Strange plan in pg 8.1.0 Steinar H. Gunderson
11:56 Re: Best COPY Performance Stefan Kaltenbrunner
12:07 Re: Best COPY Performance Luke Lonergan
12:22 Re: Best COPY Performance Stefan Kaltenbrunner
12:39 Re: commit so slow program looks frozen Bucky Jordan
17:57 Re: partitioned table performance Andreas Kostyrka
18:47 Re: partitioned table performance Simon Riggs

31 October 2006

00:21 Index ignored on column containing mostly 0 values Leif Mortenson
00:31 Re: Index ignored on column containing mostly 0 values Michael Glaesemann
00:40 Re: Index ignored on column containing mostly 0 values Tom Lane
01:59 Re: client crashes in PQfinish soni de
07:48 Re: client crashes in PQfinish Richard Huxton
11:02 Re: Index ignored on column containing mostly 0 values Andreas Kostyrka
16:11 Re: Best COPY Performance Worky Workerson
16:16 Re: Best COPY Performance Luke Lonergan
16:23 Re: Best COPY Performance Worky Workerson
16:45 Re: Best COPY Performance Worky Workerson
16:56 Re: Best COPY Performance Luke Lonergan
17:14 Re: Best COPY Performance Worky Workerson
17:17 Re: commit so slow program looks frozen Rob Lemley
17:43 Re: Best COPY Performance Teemu Torma
18:24 MVCC & indexes? Ivan Voras
18:36 Re: MVCC & indexes? Alvaro Herrera
19:47 Help w/speeding up range queries? John Major
19:55 Re: Help w/speeding up range queries? Luke Lonergan
19:57 Re: Help w/speeding up range queries? Weslee Bilodeau
20:11 Re: Help w/speeding up range queries? Luke Lonergan
20:20 Re: MVCC & indexes? mark@mark.mielke.cc