Home > mailing lists

Mailing lists [pgsql-performance]

1 February 2006

00:26 Re: Huge Data sets, simple queries Steinar H. Gunderson
00:35 Re: Huge Data sets, simple queries Luke Lonergan
01:47 Re: Huge Data sets, simple queries Jim C. Nasby
02:14 Sequential scan being used despite indexes James Russell
02:29 Re: Sequential scan being used despite indexes Joshua D. Drake
02:58 Re: Sequential scan being used despite indexes Michael Fuhr
03:09 Re: Huge Data sets, simple queries Jeffrey W. Baker
03:33 Re: Sequential scan being used despite indexes James Russell
03:42 Re: Sequential scan being used despite indexes Christopher Kings-Lynne
04:08 Re: Sequential scan being used despite indexes Michael Fuhr
04:49 Re: partitioning and locking problems Tom Lane
04:53 Re: Huge Data sets, simple queries Luke Lonergan
07:25 Re: Huge Data sets, simple queries Jeffrey W. Baker
08:00 Re: Huge Data sets, simple queries PFC
08:39 Re: partitioning and locking problems Richard Huxton
09:15 execution plan : Oracle vs PostgreSQL FERREIRA, William (VALTECH)
11:15 Re: Huge Data sets, simple queries Michael Stone
13:26 Re: partitioning and locking problems Marc Morin
14:20 Re: partitioning and locking problems Tom Lane
15:04 Re: execution plan : Oracle vs PostgreSQL Tom Lane
15:33 Re: execution plan : Oracle vs PostgreSQL FERREIRA, William (VALTECH)
16:42 Re: Huge Data sets, simple queries Luke Lonergan
16:55 Re: Huge Data sets, simple queries Steinar H. Gunderson
16:57 Re: Huge Data sets, simple queries Mike Rylander
17:33 Planner reluctant to start from subquery Kevin Grittner
18:34 Re: Planner reluctant to start from subquery Tom Lane
19:00 Re: Planner reluctant to start from subquery Kevin Grittner
19:14 Re: Planner reluctant to start from subquery Tom Lane
19:18 Index Usage using IN Ralph Mason
19:22 Re: Index Usage using IN Jeffrey W. Baker
19:24 Re: Planner reluctant to start from subquery Kevin Grittner
19:28 Re: Index Usage using IN Jeffrey W. Baker
19:36 Re: Planner reluctant to start from subquery Tom Lane
19:41 Re: Index Usage using IN Tom Lane
19:43 Re: Planner reluctant to start from subquery Kevin Grittner
19:51 Re: Planner reluctant to start from subquery Kevin Grittner
19:53 Re: Planner reluctant to start from subquery Tom Lane
20:15 Re: Index Usage using IN Bruno Wolff III
20:16 Default autovacuum settings too conservative Jim C. Nasby
20:37 Re: Default autovacuum settings too conservative Matthew T. O'Connor
21:13 Re: Index Usage using IN Hari Warrier

2 February 2006

03:47 Re: Huge Data sets, simple queries Luke Lonergan
06:10 pgbench output Pradeep Parmar
11:14 Re: Where is my bottleneck? Markus Schaber
11:44 Re: partitioning and locking problems Markus Schaber
15:29 Re: partitioning and locking problems Marc Morin
15:58 Re: Planner reluctant to start from subquery Tom Lane
18:41 Re: Huge Data sets, simple queries Alan Stange

4 February 2006

19:48 Re: Storing Digital Video Jeffrey W. Baker
19:48 Index occupancy tschak
23:49 Re: Index occupancy Tom Lane

6 February 2006

07:37 Re: Storing Digital Video Albert Cervera Areny
19:00 Re: Default autovacuum settings too conservative Vivek Khera
19:21 Re: execution plan : Oracle vs PostgreSQL Andrew Lazarus
22:04 Re: Default autovacuum settings too conservative Chris Browne

7 February 2006

03:11 Re: partitioning and locking problems Jim C. Nasby
04:05 Re: Default autovacuum settings too conservative Jim C. Nasby
04:06 Re: pgbench output Jim C. Nasby
05:38 Re: Default autovacuum settings too conservative Christopher Browne
06:26 Re: Default autovacuum settings too conservative Jim C. Nasby
11:39 Re: Default autovacuum settings too conservative Markus Schaber
13:20 Re: Default autovacuum settings too conservative Michael Stone
21:09 Re: partitioning and locking problems Simon Riggs
21:21 Re: partitioning and locking problems Ron
21:58 Re: partitioning and locking problems Marc Morin
23:59 Re: partitioning and locking problems Jim C. Nasby

8 February 2006

00:03 Re: Default autovacuum settings too conservative Jim C. Nasby
00:56 Re: Default autovacuum settings too conservative Russell Smith
03:39 Re: Default autovacuum settings too conservative Christopher Browne
07:30 Re: partitioning and locking problems Simon Riggs
10:05 Re: Default autovacuum settings too conservative Markus Schaber
12:54 optimizing away join when querying view Jacob Costello
13:09 Size and performance hit from using UTF8 vs. ASCII? Ron
14:37 Re: optimizing away join when querying view Tom Lane
14:46 Re: optimizing away join when querying view Stephan Szabo
14:54 Re: Size and performance hit from using UTF8 vs. ASCII? Jeffrey W. Baker
16:46 Re: Default autovacuum settings too conservative Markus Schaber
21:03 Sane configuration options for a WinXP laptop 8.1 install? Ron
22:31 Re: Default autovacuum settings too conservative Tim Allen
23:21 Re: Default autovacuum settings too conservative Markus Schaber

9 February 2006

05:32 Re: Sane configuration options for a WinXP laptop 8.1 install? Jim C. Nasby
13:02 Re: Storing Digital Video Nate Byrnes
14:10 Help with optimizing a sql statement Rafael Martinez Guerrero
14:23 Re: Storing Digital Video Craig A. James
14:58 Re: Storing Digital Video Nate Byrnes
18:07 Large Database Design Help Orion Henry
18:26 Re: Storing Digital Video Jim C. Nasby
18:33 Re: Help with optimizing a sql statement Jim C. Nasby
18:44 Re: Help with optimizing a sql statement Dave Dutcher
18:45 Re: Large Database Design Help Jim C. Nasby
18:45 Re: Large Database Design Help Greg Stark
18:46 Re: Help with optimizing a sql statement Jim C. Nasby
20:50 Re: Large Database Design Help Matthew Nuzum
21:43 Re: Help with optimizing a sql statement Rafael Martinez
22:14 Re: Storing Digital Video Jan Peterson
22:22 Re: Help with optimizing a sql statement Tom Lane
22:35 Re: Help with optimizing a sql statement Rafael Martinez

10 February 2006

01:28 Re: Help with optimizing a sql statement Vivek Khera
05:05 Re: Help with optimizing a sql statement Greg Stark
07:16 10+hrs vs 15min because of just one index Aaron Turner
07:22 Basic Database Performance James Dey
08:00 Re: 10+hrs vs 15min because of just one index hubert depesz lubaczewski
08:36 Re: Basic Database Performance Richard Huxton
08:50 Re: Basic Database Performance Richard Huxton
08:55 Re: Basic Database Performance James Dey
09:04 Re: Large Database Design Help Markus Schaber
09:24 Re: Large Database Design Help Markus Schaber
09:37 Re: Basic Database Performance Markus Schaber
14:40 Re: pgbench output Gourish Singbal
15:53 Re: 10+hrs vs 15min because of just one index Aaron Turner
16:13 Re: 10+hrs vs 15min because of just one index Matthew T. O'Connor
16:24 Re: 10+hrs vs 15min because of just one index Aaron Turner
18:20 What do the Windows pg hackers out there like for dev tools? Ron
19:13 Re: Basic Database Performance PFC
19:18 Re: Large Database Design Help PFC
19:20 help required in design of database david drummard
20:03 Re: help required in design of database Steinar H. Gunderson
21:06 joining two tables slow due to sequential scan Tim Jones
21:14 Re: joining two tables slow due to sequential scan Dave Dutcher
21:22 Re: joining two tables slow due to sequential scan Scott Marlowe
21:35 Re: joining two tables slow due to sequential scan Tim Jones
21:36 Re: joining two tables slow due to sequential scan Scott Marlowe
21:37 Re: joining two tables slow due to sequential scan Tim Jones
21:38 Re: Large Database Design Help Ragnar
21:39 Re: joining two tables slow due to sequential scan Scott Marlowe
21:42 Re: Large Database Design Help Scott Marlowe
21:43 Re: joining two tables slow due to sequential scan Tim Jones
21:44 Re: joining two tables slow due to sequential scan Tom Lane
21:46 Re: joining two tables slow due to sequential scan Scott Marlowe
21:51 Re: joining two tables slow due to sequential scan Tom Lane
21:59 Re: joining two tables slow due to sequential scan Tim Jones
22:25 Re: joining two tables slow due to sequential scan Dave Dutcher

11 February 2006

00:46 postgresql geqo optimization uwcssa
00:54 Re: postgresql geqo optimization Steinar H. Gunderson
00:58 Re: [HACKERS] What do the Windows pg hackers out there like for dev Mark Kirkwood
19:32 Re: Storing Digital Video Jim C. Nasby
20:25 Re: 10+hrs vs 15min because of just one index Jim C. Nasby

12 February 2006

06:58 Re: 10+hrs vs 15min because of just one index Aaron Turner
14:54 Re: 10+hrs vs 15min because of just one index Tom Lane
16:38 Re: 10+hrs vs 15min because of just one index Marc Morin
18:04 Re: 10+hrs vs 15min because of just one index Aaron Turner
18:34 Re: 10+hrs vs 15min because of just one index Aaron Turner
19:25 SQL Function Performance Adnan DURSUN

13 February 2006

00:30 Re: SQL Function Performance andrew@pillette.com
01:28 Re: 10+hrs vs 15min because of just one index Markus Schaber
04:46 Re: SQL Function Performance Michael Fuhr
07:55 Re: 10+hrs vs 15min because of just one index PFC
10:49 Re: help required in design of database Markus Schaber
15:22 Re: joining two tables slow due to sequential scan Tim Jones
18:44 Re: SQL Function Performance Adnan DURSUN
19:24 Re: SQL Function Performance Adnan DURSUN
20:59 Re: SQL Function Performance Adnan DURSUN
23:17 Re: SQL Function Performance Adnan DURSUN
23:57 Re: SQL Function Performance Tom Lane

14 February 2006

00:31 Re: SQL Function Performance Michael Fuhr
08:34 Re: SQL Function Performance Adnan DURSUN
08:47 copy and postgresql.conf FERREIRA, William (VALTECH)
10:38 Re: copy and postgresql.conf Albert Cervera Areny
12:27 Re: copy and postgresql.conf FERREIRA, William (VALTECH)
14:25 out of memory martial.bizel@free.fr
14:32 Re: out of memory Tom Lane
14:51 Postgres slower than MS ACCESS Jay Greenfield
15:03 Re: out of memory martial.bizel@free.fr
15:04 Re: Postgres slower than MS ACCESS Scott Marlowe
15:06 Re: out of memory Scott Marlowe
15:13 Re: copy and postgresql.conf Albert Cervera Areny
15:15 Re: out of memory martial.bizel@free.fr
15:17 Re: Postgres slower than MS ACCESS Jay Greenfield
15:21 Re: out of memory Scott Marlowe
15:23 Re: Postgres slower than MS ACCESS Scott Marlowe
15:32 Re: out of memory martial.bizel@free.fr
15:45 0ut of Memory Error during Vacuum Analyze Tomeh, Husam
15:50 Re: out of memory Scott Marlowe
16:05 Re: copy and postgresql.conf FERREIRA, William (VALTECH)
16:19 Re: Postgres slower than MS ACCESS Stephen Frost
16:36 Re: out of memory Tom Lane
16:47 Re: out of memory Scott Marlowe
16:50 Re: 0ut of Memory Error during Vacuum Analyze Tom Lane
19:42 Re: Postgres slower than MS ACCESS Tom Lane
19:54 Re: Postgres slower than MS ACCESS Stephen Frost
19:56 Re: Postgres slower than MS ACCESS Jay Greenfield
20:02 Re: Postgres slower than MS ACCESS Tom Lane
20:05 Re: SQL Function Performance Michael Fuhr
20:25 Re: Postgres slower than MS ACCESS Jay Greenfield
20:33 8.2.1 on FreeBSD 5.4-RELEASE Paul Khavkine
20:47 Re: copy and postgresql.conf Jignesh K. Shah
21:01 Re: 0ut of Memory Error during Vacuum Analyze and Tomeh, Husam
21:15 Re: 0ut of Memory Error during Vacuum Analyze and Create Index Tom Lane
21:36 Re: SQL Function Performance Adnan DURSUN
22:14 Re: 10+hrs vs 15min because of just one index Aaron Turner
22:40 Re: 0ut of Memory Error during Vacuum Analyze and Tomeh, Husam
22:49 Re: 0ut of Memory Error during Vacuum Analyze and Create Index Tom Lane

15 February 2006

06:29 could not send data to client: Broken pipe Pradeep Parmar
08:40 Re: could not send data to client: Broken pipe Richard Huxton
09:28 Re: copy and postgresql.conf FERREIRA, William (VALTECH)
12:47 Re: copy and postgresql.conf Markus Schaber
13:08 Re: copy and postgresql.conf FERREIRA, William (VALTECH)
13:14 Re: copy and postgresql.conf Jignesh K. Shah
13:23 Re: Postgres slower than MS ACCESS Jeff Trout
13:27 Re: copy and postgresql.conf FERREIRA, William (VALTECH)
14:07 Re: copy and postgresql.conf Jignesh K. Shah
14:18 Re: copy and postgresql.conf Tom Lane
14:51 Stored proc and optimizer question Antal Attila
14:55 out of memory martial.bizel@free.fr
14:56 Re: explain hashAggregate martial.bizel@free.fr
15:21 Reliability recommendations Jeremy Haile
15:45 Re: out of memory martial.bizel@free.fr
15:51 Re: out of memory Scott Marlowe
16:18 Re: out of memory martial.bizel@free.fr
16:24 Re: Reliability recommendations Craig A. James
16:32 Re: Reliability recommendations Mark Lewis
16:38 Re: out of memory Scott Marlowe
17:01 Re: Reliability recommendations Joshua D. Drake
17:17 Re: Reliability recommendations Greg Stark
18:03 Re: Reliability recommendations Christopher Browne
18:11 Re: Reliability recommendations Scott Marlowe
18:53 Re: Reliability recommendations Ron
19:02 Strange Create Index behaviour Gary Doades
19:56 Re: Strange Create Index behaviour Tom Lane
19:58 Re: Reliability recommendations Jeremy Haile
20:08 Re: Strange Create Index behaviour Gary Doades
20:13 Re: Strange Create Index behaviour Gary Doades
20:27 Re: Strange Create Index behaviour Simon Riggs
20:27 Re: Strange Create Index behaviour Tom Lane
20:29 Re: Postgres slower than MS ACCESS Jay Greenfield
20:36 Re: Strange Create Index behaviour Gary Doades
20:36 Re: Postgres slower than MS ACCESS Tom Lane
20:49 Re: Strange Create Index behaviour Tom Lane
20:50 Re: Reliability recommendations Josh Rovero
20:51 Re: Strange Create Index behaviour Tom Lane
21:08 Re: Strange Create Index behaviour Gary Doades
22:28 qsort again (was Re: Strange Create Index behaviour) Tom Lane
22:51 Re: Strange Create Index behaviour Simon Riggs
22:57 Re: qsort again (was Re: Strange Create Index behaviour) Gary Doades
23:04 Re: qsort again (was Re: Strange Create Index behaviour) Tom Lane
23:17 Re: [HACKERS] qsort again (was Re: Strange Create Index behaviour) Tom Lane
23:57 Re: qsort again (was Re: Strange Create Index Ron
23:59 Re: [HACKERS] qsort again (was Re: Strange Create Index behaviour) Tom Lane

16 February 2006

00:21 Re: qsort again (was Re: Strange Create Index behaviour) Tom Lane
00:50 Re: qsort again (was Re: Strange Create Index behaviour) Christopher Kings-Lynne
00:53 Re: Strange Create Index behaviour Simon Riggs
00:57 Re: [HACKERS] qsort again (was Re: Strange Create Index Simon Riggs
01:12 Re: [HACKERS] qsort again (was Re: Strange Create Index Neil Conway
03:31 Re: qsort again (was Re: Strange Create Index Ron
09:55 Re: [HACKERS] qsort again (was Re: Strange Create Index Gary Doades
10:35 Re: qsort again (was Re: Strange Create Index Steinar H. Gunderson
11:11 Re: [HACKERS] qsort again Florian Weimer
11:49 Re: [HACKERS] qsort again Martijn van Oosterhout
12:08 Re: [HACKERS] qsort again Sven Geisler
12:23 Re: qsort again (was Re: Strange Create Index Ron
12:32 Re: Postgres slower than MS ACCESS Peter Childs
12:38 Re: [HACKERS] qsort again Ron
12:44 Re: qsort again (was Re: Strange Create Index Markus Schaber
13:42 Re: [HACKERS] qsort again (was Re: Strange Create Index behaviour) Tom Lane
13:48 Re: [HACKERS] qsort again (was Re: Strange Create Index Martijn van Oosterhout
14:31 Re: [HACKERS] qsort again (was Re: Strange Create Index Gary Doades
14:53 Re: [HACKERS] qsort again (was Re: Strange Create Ron
15:20 Re: [HACKERS] qsort again (was Re: Strange Create Tom Lane
15:32 Re: qsort again (was Re: Strange Create Index Craig A. James
15:33 Re: [HACKERS] qsort again (was Re: Strange Create Ron
16:00 Re: [HACKERS] qsort again (was Re: Strange Create Martijn van Oosterhout
16:01 Why does not perform index combination Adnan DURSUN
16:15 Re: [HACKERS] qsort again (was Re: Strange Create Index Tom Lane
16:28 Re: Why does not perform index combination Tom Lane
16:49 Re: [HACKERS] qsort again (was Re: Strange Create Scott Lamb
17:47 Re: [HACKERS] qsort again (was Re: Strange Create Ron
18:13 Re: qsort again (was Re: Strange Create Index Neil Conway
21:16 Re: Why does not perform index combination Adnan DURSUN
21:17 Re: [HACKERS] qsort again (was Re: Strange Create Index Mark Lewis
21:33 Re: [HACKERS] qsort again (was Re: Strange Create Index Markus Schaber
21:40 Re: [HACKERS] qsort again (was Re: Strange Create Index Martijn van Oosterhout
21:51 Re: [HACKERS] qsort again (was Re: Strange Create Index Greg Stark
22:05 Re: [HACKERS] qsort again (was Re: Strange Create Index PFC
22:23 Re: [HACKERS] qsort again (was Re: Strange Create Index Mark Lewis
23:18 Re: [HACKERS] qsort again (was Re: Strange Create Index Markus Schaber

17 February 2006

01:02 Re: [HACKERS] qsort again (was Re: Strange Create Index Steinar H. Gunderson
04:41 Re: [HACKERS] qsort again (was Re: Strange Create Index David Lang
05:21 Re: [HACKERS] qsort again (was Re: Strange Create Ron
07:12 split partitioned table across several postgres servers martial.bizel@free.fr
08:23 Re: [HACKERS] qsort again (was Re: Strange Create Ragnar
09:13 Re: [HACKERS] qsort again (was Re: Strange Create Index Markus Schaber
09:19 Re: [HACKERS] qsort again (was Re: Strange Create Markus Schaber
09:55 Re: [HACKERS] qsort again (was Re: Strange Create PFC
12:01 Re: [HACKERS] qsort again (was Re: Strange Create Ron
12:23 Re: [HACKERS] qsort again (was Re: Strange Create Ron
13:49 Re: split partitioned table across several postgres servers Tom Lane
14:18 Re: split partitioned table across several postgres servers martial.bizel@free.fr
14:54 Re: [HACKERS] qsort again (was Re: Strange Create Martijn van Oosterhout
15:18 Re: [HACKERS] qsort again (was Re: Strange Create Index Scott Lamb
15:31 Re: [HACKERS] qsort again (was Re: Strange Create Index Martijn van Oosterhout
15:45 Re: [HACKERS] qsort again (was Re: Strange Create Ron
15:51 Need pointers to "standard" pg database(s) for testing Ron
15:56 Re: Need pointers to "standard" pg database(s) for Scott Marlowe
16:10 Re: [HACKERS] Need pointers to "standard" pg database(s) for testing Michael Paesold
16:30 Re: [HACKERS] qsort again (was Re: Strange Create Index Mark Lewis
18:22 Re: [HACKERS] qsort again (was Re: Strange Create Ragnar
18:43 Re: [HACKERS] qsort again (was Re: Strange Create Index Tom Lane

18 February 2006

03:09 Re: SQL Function Performance Mark Liberman
03:09 Re: SQL Function Performance Mark Liberman
03:09 Re: Optimizing performance of a like '%...%' condition Chris
03:10 Re: out of memory martial.bizel@free.fr
03:10 Re: [HACKERS] qsort again (was Re: Strange Create Index behaviour) Dann Corbit
03:10 Re: [HACKERS] qsort again (was Re: Strange Create Index Jonah H. Harris
03:10 Future of Table Partitioning Patrick Carriere
03:10 Index Choice Problem Adam Alkins
03:10 Re: [HACKERS] qsort again (was Re: Strange Create Index Dann Corbit
03:10 Measuring Lock Performance Lane Van Ingen
03:10 Re: [HACKERS] qsort again (was Re: Strange Create Gregory Maxwell
03:11 Stored proc and optimizer question Antal Attila
04:53 Re: Index Choice Problem Tom Lane
06:29 Re: Index Choice Problem Adam Alkins
06:39 Re: Index Choice Problem Adam Alkins
15:04 Force another plan. Fredrik Olsson
16:01 Re: [HACKERS] qsort again (was Re: Strange Create Ron
17:36 Re: Force another plan. Tom Lane

19 February 2006

11:39 Re: Force another plan. Fredrik Olsson
13:05 Question about query planner Emil Briggs
16:31 Re: Force another plan. Tom Lane
17:15 Re: Question about query planner Tom Lane

20 February 2006

01:02 Re: Need pointers to "standard" pg database(s) for testing Christopher Kings-Lynne
03:06 How to optimize a JOIN with BETWEEN? andrew@pillette.com
03:47 Re: Need pointers to "standard" pg database(s) for Christopher Kings-Lynne
05:42 Re: Avoiding cartesian product Virag Saksena
08:58 Re: Force another plan. Fredrik Olsson
11:57 Creating a correct and real benchmark Marcos
14:01 Re: Force another plan. Tom Lane
23:13 Re: Creating a correct and real benchmark PFC
23:21 Re: Creating a correct and real benchmark Chris

21 February 2006

04:13 Cost Issue - How do I force a Hash Join Virag Saksena
04:36 Re: Cost Issue - How do I force a Hash Join Tom Lane
04:59 Re: Cost Issue - How do I force a Hash Join Craig A. James
05:34 Re: Cost Issue - How do I force a Hash Join Virag Saksena
14:57 LIKE query on indexes Ibrahim Tekin
15:18 Re: LIKE query on indexes Scott Marlowe
15:34 Re: LIKE query on indexes Alvaro Herrera
15:42 Re: LIKE query on indexes Scott Marlowe
16:40 Re: LIKE query on indexes mark@mark.mielke.cc
19:12 Re: LIKE query on indexes Ibrahim Tekin
19:12 Help with nested loop left join performance George Woodring
19:28 Re: LIKE query on indexes Ibrahim Tekin
23:15 Re: How to optimize a JOIN with BETWEEN? Jim C. Nasby

22 February 2006

08:43 Re: Help with nested loop left join performance Richard Huxton
09:39 Chethana, Rao (IE10)
09:47 Re: Richard Huxton
09:51 Re: Gourish Singbal
13:24 Re: --pls reply ASAP Richard Huxton
14:04 Re: Help with nested loop left join performance Tom Lane
14:48 Re: LIKE query on indexes Brendan Duddridge
15:32 Re: Vivek Khera
15:57 Good News re count(*) in 8.1 Kevin Grittner
16:13 Re: Good News re count(*) in 8.1 Luke Lonergan
16:16 Re: --pls reply ASAP Theodore LoScalzo
16:27 Joins and full index scans...mysql vs postgres? ryan groth
16:42 Re: Good News re count(*) in 8.1 Tom Lane
16:52 Re: Joins and full index scans...mysql vs postgres? Steinar H. Gunderson
17:11 Re: Joins and full index scans...mysql vs postgres? ryan groth
17:21 Re: Joins and full index scans...mysql vs postgres? ryan groth
17:31 Re: Joins and full index scans...mysql vs postgres? Stephan Szabo
17:53 Re: Joins and full index scans...mysql vs postgres? ryan groth
18:13 Re: Joins and full index scans...mysql vs postgres? Scott Marlowe
18:16 Slow query Jeremy Haile
21:07 Re: Large Database Design Help Orion
22:39 Re: Joins and full index scans...mysql vs postgres? PFC
22:58 Re: Joins and full index scans...mysql vs postgres? Chris

23 February 2006

01:48 Re: Joins and full index scans...mysql vs postgres? Christopher Kings-Lynne
02:52 Re: Good News re count(*) in 8.1 Greg Stark
09:21 Re: Joins and full index scans...mysql vs postgres? Andreas Pflug
11:35 Created Index is not used Kjeld Peters
11:52 Re: LIKE query on indexes Ibrahim Tekin
12:01 Re: Created Index is not used Ragnar
12:07 Re: Created Index is not used Markus Schaber
13:09 Re: Created Index is not used Kjeld Peters
13:38 Re: Vivek Khera
15:29 how to interpret/improve bad row estimates Robert Treat
15:38 Looking for a tool to "*" pg tables as ERDs Ron Peacetree
15:48 Re: Looking for a tool to "*" pg tables as ERDs Markus Schaber
16:06 Re: Looking for a tool to "*" pg tables as ERDs Vivek Khera
16:25 Re: Slow query Tom Lane
17:55 Re: Good News re count(*) in 8.1 Kevin Grittner
18:57 Re: 0ut of Memory Error during Vacuum Analyze and Tomeh, Husam
19:28 Re: Jim C. Nasby
19:45 Re: Good News re count(*) in 8.1 Jim C. Nasby
21:42 Re: 0ut of Memory Error during Vacuum Analyze and Tomeh, Husam
21:47 Re: 0ut of Memory Error during Vacuum Analyze and Tom Lane

24 February 2006

05:54 Really really slow query. What's a better way? Brendan Duddridge
06:01 Re: Really really slow query. What's a better way? Christopher Kings-Lynne
06:24 Re: Really really slow query. What's a better way? Brendan Duddridge
13:30 Re: Reliability recommendations Bruce Momjian
14:10 Re: Reliability recommendations Craig A. James
14:14 Re: Reliability recommendations Luke Lonergan
14:41 Re: Reliability recommendations Luke Lonergan
15:27 Re: Reliability recommendations Vivek Khera
15:32 Re: Reliability recommendations Scott Marlowe
15:40 Re: Reliability recommendations Vivek Khera
15:51 Re: Reliability recommendations Scott Marlowe
16:14 Re: Reliability recommendations Joshua D. Drake
19:03 Schema vs Independant Databases, ACLS,Overhead,pg_hba.conf Eric Lauzon
19:06 Re: Creating a correct and real benchmark Marcos
22:18 Re: Reliability recommendations Craig A. James
22:59 Re: Reliability recommendations Scott Marlowe
23:07 Re: Reliability recommendations Luke Lonergan
23:18 Re: Reliability recommendations Philippe Marzin
23:33 Re: Reliability recommendations Mark Kirkwood
23:49 Re: Reliability recommendations Dan Gorman

25 February 2006

00:18 Re: Reliability recommendations Mark Kirkwood
02:42 Re: Bruce Momjian
03:42 Re: Reliability recommendations Luke Lonergan
05:11 Re: Reliability recommendations Mark Kirkwood
05:23 Re: Reliability recommendations Luke Lonergan
05:28 Re: Reliability recommendations Mark Kirkwood
10:25 Re: Reliability recommendations Ron
10:56 Re: Reliability recommendations Ron
14:50 Re: Reliability recommendations Luke Lonergan
15:03 Re: Schema vs Independant Databases, ACLS,Overhead,pg_hba.conf Alvaro Herrera

27 February 2006

09:03 fsync and battery-backed caches Javier Somoza
09:13 Re: fsync and battery-backed caches Tino Wildenhain
11:08 wal sync method Evgeny Gridasov
11:28 Re: wal sync method Javier Somoza
11:42 Setting the shared buffers Javier Somoza
12:17 Re: Setting the shared buffers Claus Guttesen
12:31 neverending vacuum Csaba Nagy
13:31 Re: neverending vacuum Alvaro Herrera
14:03 Re: neverending vacuum Csaba Nagy
16:06 The trigger can be specified to fire on time condition? Jamal Ghaffour
16:10 Re: The trigger can be specified to fire on time condition? Alvaro Herrera
16:26 Re: Large Table With Only a Few Rows Chris Browne
17:04 Re: The trigger can be specified to fire on time condition? Chris Browne
17:34 Re: Large Table With Only a Few Rows Peter Childs
23:22 Re: fsync and battery-backed caches Jim C. Nasby

28 February 2006

00:06 Re: fsync and battery-backed caches Bruce Momjian
00:14 Re: wal sync method Bruce Momjian
03:58 Re: rotate records Bruno Wolff III
07:18 Re: fsync and battery-backed caches Javier Somoza
08:45 Different disks for xlogs and data Javier Somoza
11:10 vacuum, analyze and reindex Javier Somoza
12:38 Re: vacuum, analyze and reindex Christopher Browne
12:41 Re: Different disks for xlogs and data Ron
14:44 temporary indexes Kevin Grittner
15:45 Re: [HACKERS] temporary indexes Jim C. Nasby
15:52 Re: temporary indexes Tom Lane
16:05 Re: [HACKERS] temporary indexes Tom Lane
16:23 Re: fsync and battery-backed caches Jim C. Nasby
16:36 Re: [HACKERS] temporary indexes Kevin Grittner
16:54 Re: fsync and battery-backed caches Javier Somoza
16:55 Re: [HACKERS] temporary indexes Kevin Grittner
17:07 Re: [HACKERS] temporary indexes Tom Lane
17:08 Re: [HACKERS] temporary indexes Steinar H. Gunderson
17:17 Re: [HACKERS] temporary indexes Kevin Grittner
20:02 Re: [HACKERS] temporary indexes Jim C. Nasby
20:09 Re: fsync and battery-backed caches Jim C. Nasby
20:15 Re: [HACKERS] temporary indexes Kevin Grittner
22:31 Re: wal sync method PFC
22:45 Re: wal sync method Tom Lane