Home > mailing lists

Mailing lists [pgsql-performance]

2 October 2006

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

3 October 2006

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

4 October 2006

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

5 October 2006

01:35 pg_trgm indexes giving bad estimations? Ben
01:55 Re: pg_trgm indexes giving bad estimations? Tom Lane
04:56 Re: UPDATE becomes mired / win32 Steve Peterson
05:07 Re: UPDATE becomes mired / win32 Steve Peterson
06:26 Re: Performance Optimization for Dummies 2 - the SQL Merlin Moncure
07:32 Re: Performance Optimization for Dummies 2 - the SQL Carlo Stonebanks
13:20 Re: UPDATE becomes mired / win32 Tom Lane
13:24 Re: Performance Optimization for Dummies 2 - the SQL Tom Lane
13:30 Re: Performance Optimization for Dummies 2 - the SQL Merlin Moncure
16:28 Re: Performance Optimization for Dummies 2 - the SQL Carlo Stonebanks
16:35 Re: Performance Optimization for Dummies 2 - the SQL Tom Lane
17:45 Re: Performance Optimization for Dummies 2 - the SQL Carlo Stonebanks

6 October 2006

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

7 October 2006

06:36 Simple join optimized badly? Craig A. James
15:51 Re: Simple join optimized badly? Tom Lane

8 October 2006

01:50 Re: Simple join optimized badly? Denis Lussier
17:17 Re: Simple join optimized badly? Jim Nasby

9 October 2006

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

10 October 2006

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

11 October 2006

00:35 Re: Simple join optimized badly? Mark Kirkwood
00:37 Re: Simple join optimized badly? Mark Kirkwood
01:03 Re: Scrub one large table against another Jim C. Nasby
01:22 Re: Simple join optimized badly? Brian Herlihy
02:38 Re: Simple join optimized badly? Tom Lane
02:50 Re: Scrub one large table against another Tom Lane
03:58 Re: Simple join optimized badly? Brian Herlihy
14:27 Re: Simple join optimized badly? Bucky Jordan
14:51 Re: Simple join optimized badly? Heikki Linnakangas
14:53 Re: Simple join optimized badly? Bruce Momjian
15:07 Re: Simple join optimized badly? Mark Lewis
16:54 Re: Scrub one large table against another Brendan Curran
17:25 Re: Scrub one large table against another (vmstat output) Brendan Curran
20:28 Collect stats during seqscan (was: Simple join optimized badly?) Jim C. Nasby
20:53 Re: Scrub one large table against another Jim C. Nasby

12 October 2006

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

13 October 2006

02:55 Re: Hints proposal Christopher Browne
16:16 Re: [HACKERS] Hints proposal Jim C. Nasby
16:36 Re: [HACKERS] Hints proposal Tom Lane
17:33 Re: [HACKERS] Hints proposal Bucky Jordan
22:56 Re: [HACKERS] Hints proposal Josh Berkus
22:58 Re: [HACKERS] Hints proposal Josh Berkus
23:36 Re: [HACKERS] Hints proposal Jim C. Nasby

14 October 2006

01:29 Re: [HACKERS] Hints proposal Alvaro Herrera
04:20 Re: [HACKERS] Hints proposal Tom Lane

15 October 2006

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

16 October 2006

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

17 October 2006

06:39 Re: Performance Optimization for Dummies 2 - the SQL Carlo Stonebanks
06:44 Re: Performance Optimization for Dummies 2 - the SQL Carlo Stonebanks
09:12 Optimization of this SQL sentence Ruben Rubio
09:21 Re: Optimization of this SQL sentence Gregory S. Williamson
09:33 Re: Optimization of this SQL sentence Ruben Rubio
09:40 Re: Optimization of this SQL sentence Ruben Rubio
09:48 Re: Optimization of this SQL sentence A. Kretschmer
09:53 Re: Optimization of this SQL sentence Alexander Staubo
10:00 Re: Optimization of this SQL sentence Heikki Linnakangas
10:25 Re: Optimization of this SQL sentence (SOLVED) Ruben Rubio
11:39 Regarding Bitmap Scan soni de
11:45 Re: Regarding Bitmap Scan A. Kretschmer
12:27 Re: Regarding Bitmap Scan Dawid Kuroczko
15:18 Re: Optimization of this SQL sentence Craig A. James
16:04 Re: Optimization of this SQL sentence Alexander Staubo
16:26 Re: Optimization of this SQL sentence Alexander Staubo
16:30 Re: Optimization of this SQL sentence Mario Weilguni
16:51 Re: Optimization of this SQL sentence Merlin Moncure
19:04 Re: Optimization of this SQL sentence Chris Browne
19:04 Re: Optimization of this SQL sentence Chris Browne
19:11 Re: Optimization of this SQL sentence Shane Ambler
19:38 Re: Optimization of this SQL sentence Christopher Browne
19:41 Re: Optimization of this SQL sentence Shane Ambler
20:01 Jdbc/postgres performance Rohit_Behl
20:28 Re: Jdbc/postgres performance Merlin Moncure

18 October 2006

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

19 October 2006

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

20 October 2006

07:49 New hardware thoughts Ben Suffolk
08:01 Re: measuring shared memory usage on Windows Harald Armin Massa
08:12 Re: measuring shared memory usage on Windows Harald Armin Massa
08:14 pgBench on Windows Harald Armin Massa
11:46 Re: VACUUM FULL ANALYZE on 8.1.4 is slower then on 8.0 Markus Schaber
12:19 Re: Swappiness setting on a linux pg server Tobias Brox
14:33 Re: measuring shared memory usage on Windows David Boreham
14:43 Re: New hardware thoughts Shane Ambler
14:58 Re: New hardware thoughts Dave Cramer
18:22 Re: New hardware thoughts Ben Suffolk
18:39 Re: New hardware thoughts Ben Suffolk
18:51 Re: New hardware thoughts Joshua D. Drake
20:33 Best COPY Performance Worky Workerson
20:34 Re: New hardware thoughts Ben Suffolk
20:51 Re: New hardware thoughts alvis
22:14 VACUUM Performance Steve Oualline
22:19 Is ODBC that slow? Carlo Stonebanks

21 October 2006

00:44 Re: [HACKERS] Hints proposal Zeugswetter Andreas ADI SD
00:44 Re: [HACKERS] Hints proposal Gregory Stark
00:44 Re: [HACKERS] Hints proposal Mischa Sandberg
00:45 Jdbc/postgres performance Behl, Rohit \(Infosys\)
00:46 Slow functional indexes? Stuart Bishop
00:47 Vacuum and Memory Loss Mike
01:04 Re: Is ODBC that slow? Merlin Moncure
01:11 Re: Best COPY Performance Merlin Moncure
02:32 Re: Is ODBC that slow? Alvaro Herrera
02:39 Re: Slow functional indexes? Merlin Moncure
03:15 Re: Is ODBC that slow? Merlin Moncure
03:43 Re: Slow functional indexes? Tom Lane
03:44 Re: Is ODBC that slow? Joshua D. Drake
03:45 Re: Is ODBC that slow? Joshua D. Drake
05:02 Re: VACUUM Performance Tom Lane
10:44 Re: Index on two columns not used Péter Kovács
12:40 Re: pgBench on Windows Magnus Hagander
15:40 Re: Is ODBC that slow? Carlo Stonebanks
16:22 Optimizing disk throughput on quad Opteron John Philips
16:49 Re: Is ODBC that slow? Alvaro Herrera
16:52 Re: Is ODBC that slow? Joshua D. Drake
19:02 Re: Optimizing disk throughput on quad Opteron Joshua D. Drake
19:32 Re: Optimizing disk throughput on quad Opteron Ben Suffolk

22 October 2006

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

23 October 2006

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

24 October 2006

07:01 Re: Slow functional indexes? Stuart Bishop
09:29 Re: Index on two columns not used Markus Schaber
13:31 Re: Copy database performance issue Jignesh Shah
13:57 Re: Optimizing disk throughput on quad Opteron Bucky Jordan
20:11 Re: Best COPY Performance Worky Workerson
21:49 Re: Is ODBC that slow? Carlo Stonebanks

25 October 2006

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

26 October 2006

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

27 October 2006

00:01 Re: query slows down drastically with increased number of Tom Darci
02:20 Index ignored with "is not distinct from", 8.2 beta2 JEAN-PIERRE PELLETIER
09:20 Re: VACUUMs take twice as long across all nodes Gavin Hamill
11:46 query produces 1 GB temp file Dirk Lutzebaeck
13:09 client crashes in PQfinish soni de
13:12 Re: Regarding Bitmap Scan soni de
13:52 Re: query produces 1 GB temp file Merlin Moncure
14:34 Re: query produces 1 GB temp file Bricklen Anderson
14:48 Re: query produces 1 GB temp file Alexander Staubo
14:53 Re: query produces 1 GB temp file Dirk Lutzebäck
15:09 Re: query produces 1 GB temp file Thomas Burdairon
15:49 Re: query produces 1 GB temp file Scott Marlowe
18:08 Re: VACUUMs take twice as long across all nodes Tom Lane
18:40 Re: Best COPY Performance Worky Workerson
19:02 Re: Best COPY Performance Merlin Moncure
19:37 Re: Best COPY Performance Worky Workerson
22:19 Re: VACUUMs take twice as long across all nodes Gavin Hamill

28 October 2006

01:01 Re: Best COPY Performance Luke Lonergan
03:12 Re: Best COPY Performance Merlin Moncure
03:43 Re: Best COPY Performance Worky Workerson
03:47 Re: Best COPY Performance Worky Workerson
04:08 Re: Best COPY Performance Luke Lonergan
10:08 Re: commit so slow program looks frozen Simon Riggs
12:03 Re: Best COPY Performance Michael Artz
15:42 Re: Best COPY Performance Luke Lonergan
15:45 Re: commit so slow program looks frozen Carlo Stonebanks
15:51 Re: commit so slow program looks frozen Carlo Stonebanks
17:40 Re: commit so slow program looks frozen Merlin Moncure
22:26 partitioned table performance Andreas Kostyrka

29 October 2006

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

30 October 2006

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

31 October 2006

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