Home > mailing lists

Mailing lists [pgsql-performance]

1 October 2005

06:02 Re: [HACKERS] A Better External Sort? Tom Lane
08:21 Re: [HACKERS] A Better External Sort? Simon Riggs
09:29 Re: [HACKERS] A Better External Sort? Simon Riggs
10:01 Re: [GENERAL] database bloat, but vacuums are done, and fsm seems to be setup ok hubert depesz lubaczewski
14:22 Re: [HACKERS] A Better External Sort? Ron Peacetree
15:48 Re: [HACKERS] A Better External Sort? Tom Lane
16:17 Re: [HACKERS] A Better External Sort? Greg Stark
16:39 Re: [HACKERS] A Better External Sort? Ron Peacetree
17:42 Re: [HACKERS] A Better External Sort? Ron Peacetree
19:51 Re: [HACKERS] Query in SQL statement Roger Hand
21:15 Re: [HACKERS] Query in SQL statement Tom Lane

3 October 2005

11:02 Ultra-cheap NVRAM device Steinar H. Gunderson
12:27 URGENT: pg_statistic_relid_att_index has gone Harald Lau
14:00 Re: URGENT: pg_statistic_relid_att_index has gone Harald Lau
14:08 Re: URGENT: pg_statistic_relid_att_index has gone Tom Lane
15:48 Alternative to a temporary table Steven Rosenstein
16:23 Re: Alternative to a temporary table Steve Atkins
17:15 Re: Ultra-cheap NVRAM device Dan Harris
17:21 Re: Ultra-cheap NVRAM device Dan Harris
17:36 Re: Ultra-cheap NVRAM device Jeffrey W. Baker
18:01 Re: Ultra-cheap NVRAM device Ron Peacetree
19:06 Re: Ultra-cheap NVRAM device Vivek Khera
20:05 Re: Query seem to slow if table have more than 200 million rows Qingqing Zhou
20:31 Re: [HACKERS] A Better External Sort? Josh Berkus
20:39 Re: [HACKERS] A Better External Sort? Josh Berkus
20:43 Re: [HACKERS] A Better External Sort? Jeffrey W. Baker
21:14 Re: [HACKERS] A Better External Sort? Josh Berkus
21:19 Re: [HACKERS] A Better External Sort? Ron Peacetree
21:28 Re: [HACKERS] A Better External Sort? Luke Lonergan
21:32 Re: [HACKERS] A Better External Sort? Jeffrey W. Baker
21:46 Re: database bloat, but vacuums are done, and fsm seems Simon Riggs
21:57 Re: [HACKERS] A Better External Sort? Josh Berkus
21:58 Re: [HACKERS] A Better External Sort? Luke Lonergan
22:03 Re: [HACKERS] A Better External Sort? Michael Stone
22:10 Re: [HACKERS] A Better External Sort? Josh Berkus

4 October 2005

00:07 Re: [HACKERS] A Better External Sort? Ron Peacetree
00:32 Re: [HACKERS] A Better External Sort? Ron Peacetree
02:04 Re: Comparative performance Joe
08:45 Re: Comparative performance PFC
10:33 Re: Is There Any Way .... Stefan Weiss
15:01 Re: Is There Any Way .... Lane Van Ingen
18:55 Re: Slow concurrent update of same row in a given table Jim C. Nasby
20:19 Re: Logarithmic change (decrease) in performance Jim C. Nasby
20:31 Re: Comparative performance Jim C. Nasby
20:45 Re: [HACKERS] Query in SQL statement Jim C. Nasby
21:05 Re: Comparative performance Jim C. Nasby
21:12 Re: Ultra-cheap NVRAM device Jim C. Nasby
21:14 Re: Lists or external TABLE? Jim C. Nasby
21:16 Re: Comparative performance Joe
21:23 Re: Is There Any Way .... Jim C. Nasby
21:23 Re: Comparative performance Joe
21:28 Re: SQL Function performance Jim C. Nasby
21:32 Re: SELECT LIMIT 1 VIEW Performance Issue Jim C. Nasby
21:35 Re: SELECT LIMIT 1 VIEW Performance Issue Jim C. Nasby
21:37 Re: Comparative performance Joe
22:16 Re: Comparative performance Jim C. Nasby
22:19 Re: SELECT LIMIT 1 VIEW Performance Issue Jim C. Nasby
22:24 Re: Is There Any Way .... Mark Lewis
23:20 Re: Comparative performance Dario
23:38 Re: Is There Any Way .... Ron Peacetree

5 October 2005

00:01 Re: Is There Any Way .... Jim C. Nasby
00:44 Re: Is There Any Way .... Douglas J. Trainor
01:09 Indexes on ramdisk Emil Briggs
01:30 Re: Is There Any Way .... Joshua D. Drake
03:07 Re: Is There Any Way .... Ron Peacetree
03:23 Re: Indexes on ramdisk Alex Turner
03:41 Re: Indexes on ramdisk Emil Briggs
03:52 Re: Is There Any Way .... Steve Atkins
04:05 Re: Is There Any Way .... mark@mark.mielke.cc
05:28 Re: [HACKERS] A Better External Sort? Hannu Krosing
06:20 Re: [HACKERS] A Better External Sort? Gregory Maxwell
06:26 Re: index on custom function; explain Jan Aerts
06:29 Re: [HACKERS] A Better External Sort? Dann Corbit
06:35 index on custom function; explain jan.aerts@bbsrc.ac.uk
06:36 Re: Is There Any Way .... Kevin Grittner
06:37 Re: [HACKERS] A Better External Sort? Dann Corbit
06:43 Re: [HACKERS] A Better External Sort? Dann Corbit
06:46 Re: [HACKERS] A Better External Sort? Dann Corbit
06:48 Re: [HACKERS] A Better External Sort? Dann Corbit
06:50 Re: [HACKERS] A Better External Sort? Martijn van Oosterhout
06:50 Re: [HACKERS] A Better External Sort? Hannu Krosing
06:53 Re: [HACKERS] A Better External Sort? Gregory Maxwell
06:55 Which one FreeBSD or Linux ALÝ ÇELÝK
06:55 Re: [HACKERS] A Better External Sort? Gregory Maxwell
06:57 Re: [HACKERS] A Better External Sort? Andrew Dunstan
06:57 Re: [HACKERS] Query in SQL statement Obe, Regina DND\\MIS
07:00 Re: [HACKERS] A Better External Sort? David Fetter
07:02 Query in SQL statement R, Rajesh (STSD)
07:05 Re: [HACKERS] A Better External Sort? Zeugswetter Andreas DAZ SD
08:57 Re: Which one FreeBSD or Linux Richard Huxton
08:57 Re: Query in SQL statement Richard Huxton
09:19 Re: Query in SQL statement Richard Huxton
09:41 Re: [HACKERS] A Better External Sort? Michael Stone
09:43 Re: [HACKERS] A Better External Sort? Michael Stone
11:04 Re: Is There Any Way .... Douglas J. Trainor
11:16 Re: Is There Any Way .... Dario
13:23 Re: SELECT LIMIT 1 VIEW Performance Issue Merlin Moncure
13:24 wal_buffers Ian Westmacott
13:51 Re: Is There Any Way .... Kevin Grittner
14:57 Re: Indexes on ramdisk Merlin Moncure
15:03 Re: Indexes on ramdisk Alex Turner
15:34 Re: [HACKERS] A Better External Sort? Luke Lonergan
15:35 Re: Is There Any Way .... Frank Wiles
15:59 Re: [HACKERS] A Better External Sort? Michael Stone
16:40 Re: [HACKERS] A Better External Sort? Ron Peacetree
17:07 Re: [HACKERS] A Better External Sort? Joshua D. Drake
17:12 Re: Is There Any Way .... Ron Peacetree
17:16 Re: Ultra-cheap NVRAM device Chris Browne
17:41 Re: [HACKERS] A Better External Sort? Ron Peacetree
18:24 Text/Varchar performance... Cristian Prieto
18:30 Re: [HACKERS] A Better External Sort? Jeffrey W. Baker
18:35 Re: Text/Varchar performance... Steinar H. Gunderson
18:35 Re: Ultra-cheap NVRAM device Merlin Moncure
18:57 Re: Text/Varchar performance... Josh Berkus
20:01 Re: Is There Any Way .... Douglas J. Trainor
23:46 Re: Indexes on ramdisk Emil Briggs
23:54 Re: [HACKERS] A Better External Sort? Ron Peacetree
23:58 Re: [HACKERS] A Better External Sort? Luke Lonergan

6 October 2005

00:12 Re: [HACKERS] A Better External Sort? Steinar H. Gunderson
06:39 Re: wal_buffers Thomas F. O'Connell
08:19 Re: index on custom function; explain Yann Michel
09:49 Re: [HACKERS] A Better External Sort? Michael Stone
12:56 Re: wal_buffers Ian Westmacott
13:19 functions and execution plan caching Kelly Burkhart
13:23 Re: wal_buffers Alvaro Herrera
18:50 Re: index on custom function; explain Andrew McMillan
19:53 Re: functions and execution plan caching Michael Fuhr
20:09 Re: [HACKERS] A Better External Sort? Tom Lane
21:14 Re: [HACKERS] A Better External Sort? Tom Lane
21:23 Re: [HACKERS] A Better External Sort? Alvaro Herrera
21:46 Need Some Suggestions Lane Van Ingen
23:55 Status of Opteron vs Xeon Jeff Frost

7 October 2005

07:55 Re: Need Some Suggestions Richard Huxton
09:24 count(*) using index scan in "query often, update rarely" environment Cestmir Hybl
09:54 Re: count(*) using index scan in "query often, update rarely" environment hubert depesz lubaczewski
10:14 Re: count(*) using index scan in "query often, update rarely" environment Cestmir Hybl
10:48 Re: count(*) using index scan in "query often, update rarely" environment Steinar H. Gunderson
11:14 Re: count(*) using index scan in "query often, update rarely" environment Cestmir Hybl
12:27 Re: Status of Opteron vs Xeon Merlin Moncure
13:07 Re: count(*) using index scan in "query often, update rarely" environment Alvaro Herrera
13:37 Re: Need Some Suggestions Lane Van Ingen
13:42 Re: count(*) using index scan in "query often, update rarely" environment Tom Lane
13:50 Re: count(*) using index scan in "query often, update rarely" environment Merlin Moncure
14:32 Re: count(*) using index scan in "query often, update rarely" Richard Huxton
18:04 Re: Status of Opteron vs Xeon Chris Browne
18:44 Re: Status of Opteron vs Xeon Tom Lane
18:47 Re: wal_buffers Josh Berkus
19:05 Re: Status of Opteron vs Xeon Emil Briggs
23:55 Re: [HACKERS] A Better External Sort? Luke Lonergan

8 October 2005

00:32 Re: [HACKERS] A Better External Sort? mark@mark.mielke.cc
04:21 Re: [HACKERS] A Better External Sort? Luke Lonergan
10:44 Re: count(*) using index scan in "query often, update rarely" environment hubert depesz lubaczewski
13:44 Re: [HACKERS] A Better External Sort? mark@mark.mielke.cc
13:48 Re: count(*) using index scan in "query often, update rarely" environment mark@mark.mielke.cc
22:56 Re: [HACKERS] A Better External Sort? Jim C. Nasby

10 October 2005

04:41 What's the cost of a few extra columns? Announce
08:40 Server misconfiguration??? Andy
08:55 Re: Server misconfiguration??? Christopher Kings-Lynne
09:43 Re: Server misconfiguration??? Andy
11:24 Re: Text/Varchar performance... Ahmad Fajar
12:19 Compression of text columns Stef
12:27 Re: Compression of text columns Tino Wildenhain
12:54 Re: Text/Varchar performance... Steinar H. Gunderson
12:57 Re: Compression of text columns Stef
13:27 Query performance on ILIKE with AND operator... Federico Simonetti (Liveye)
14:19 Re: Server misconfiguration??? Tom Lane
14:31 Re: Server misconfiguration??? Andy
14:39 Re: Compression of text columns Tom Lane
14:56 Re: Server misconfiguration??? Christopher Kings-Lynne
14:58 Re: Query performance on ILIKE with AND operator... Tom Lane
15:17 Re: Query performance on ILIKE with AND operator... Federico Simonetti (Liveye)
21:29 Performance on SUSE w/ reiserfs Jon Brisbin
21:45 Re: Performance on SUSE w/ reiserfs Claus Guttesen
21:54 Re: Performance on SUSE w/ reiserfs Tom Lane
22:11 Re: Performance on SUSE w/ reiserfs Josh Berkus
22:14 Re: Performance on SUSE w/ reiserfs Jon Brisbin
22:15 Re: Performance on SUSE w/ reiserfs Jon Brisbin
22:28 XFS External Log on Pg 7.4.8 Pg_xlog drives? Steve Poe
22:29 Re: Performance on SUSE w/ reiserfs Alvaro Herrera
22:36 Re: Performance on SUSE w/ reiserfs Tom Lane
22:48 Re: XFS External Log on Pg 7.4.8 Pg_xlog drives? Michael Stone

11 October 2005

00:12 Re: What's the cost of a few extra columns? Jim C. Nasby
02:14 Re: What's the cost of a few extra columns? Announce
08:03 Re: Compression of text columns Simon Riggs
11:37 Massive delete performance Andy
11:39 Re: Performance on SUSE w/ reiserfs Claus Guttesen
11:54 Re: Massive delete performance Sean Davis
12:07 Re: Massive delete performance Andy
12:12 Re: Massive delete performance Sean Davis
12:19 Re: Massive delete performance Steinar H. Gunderson
13:28 Re: Massive delete performance Andy
13:49 Re: Performance on SUSE w/ reiserfs Sven Willenberger
14:18 Re: Massive delete performance Tom Lane
14:27 Re: Performance on SUSE w/ reiserfs Alex Turner
14:27 Re: Massive delete performance Andy
14:51 Re: Performance on SUSE w/ reiserfs Alan Stange
14:54 effective cache size on FreeBSD (WAS: Performance on SUSE w/ reiserfs) Claus Guttesen
14:57 Re: Performance on SUSE w/ reiserfs Alex Turner
15:03 Re: effective cache size on FreeBSD (WAS: Performance on SUSE w/ Sven Willenberger
15:28 Re: Performance on SUSE w/ reiserfs Alan Stange
17:24 Re: effective cache size on FreeBSD (WAS: Performance on SUSE w/ Claus Guttesen
18:11 Re: Performance on SUSE w/ reiserfs Alex Turner
20:10 Re: effective cache size on FreeBSD (WAS: Performance on SUSE w/ reiserfs) Vivek Khera
21:48 Re: Massive delete performance Enrico Weigelt

12 October 2005

12:14 Re: SELECT LIMIT 1 VIEW Performance Issue Merlin Moncure
13:00 Re: SELECT LIMIT 1 VIEW Performance Issue K C Lau
14:45 Help tuning postgres Csaba Nagy
15:12 Re: Help tuning postgres Emil Briggs
15:18 Re: Help tuning postgres Csaba Nagy
15:34 Re: Help tuning postgres Emil Briggs
15:54 Re: Help tuning postgres Merlin Moncure
16:41 Re: Help tuning postgres Matthew Nuzum
16:55 Re: Help tuning postgres Csaba Nagy
17:24 Re: Help tuning postgres Tom Lane
17:32 Re: Help tuning postgres Steve Poe
18:17 Re: Help tuning postgres Merlin Moncure
22:00 Re: Help tuning postgres Andrew Sullivan

13 October 2005

08:15 Re: Help tuning postgres Csaba Nagy
09:54 Optimizer misconfigured ? Nörder-Tuitje, Marcus
10:16 Re: Help tuning postgres Markus Wollny
10:24 Re: Help tuning postgres Markus Wollny
10:25 Re: Optimizer misconfigured ? Richard Huxton
12:40 Re: Help tuning postgres Andrew Sullivan
13:15 Re: Help tuning postgres Csaba Nagy
14:50 Re: Help tuning postgres Matthew Nuzum
15:01 Re: Server misconfiguration??? Andrew Sullivan
16:11 Re: Help tuning postgres Andrew Sullivan
16:37 slow update Patrick Hatcher
18:34 Re: slow update Tom Lane
18:39 Re: slow update Patrick Hatcher

14 October 2005

07:23 Re: Server misconfiguration??? Andy
07:31 Re: Optimizer misconfigured ? Nörder-Tuitje, Marcus
07:40 Re: Optimizer misconfigured ? Richard Huxton
16:06 Best way to get all different values in a column
16:53 Re: Best way to get all different values in a column mark@mark.mielke.cc
17:10 Re: Best way to get all different values in a column Steve Atkins
18:08 Sequential scan on FK join Martin Nickel

15 October 2005

13:20 Bytea poor performance NSO
13:40 Re: Bytea poor performance Sean Davis
14:00 Re: Bytea poor performance NSO
14:09 Re: Bytea poor performance Sean Davis
14:48 Re: Bytea poor performance NSO
15:54 Re: Bytea poor performance Tom Lane
16:16 Re: Bytea poor performance NSO
16:24 Re: Bytea poor performance Tom Lane

16 October 2005

04:53 Re: Bytea poor performance Mark Kirkwood
11:01 Re: Bytea poor performance NSO
21:12 Re: Bytea poor performance Andreas Pflug
22:02 Re: Bytea poor performance NSO

17 October 2005

11:06 Re: Sequential scan on FK join Richard Huxton
11:17 Re: Bytea poor performance Andreas Pflug
17:09 Re: Sequential scan on FK join Martin Nickel
17:09 tsearch2/GIST performance factors? Craig A. James
17:09 tsearch2/GIST performance factors? Craig A. James
17:58 Re: Sequential scan on FK join Richard Huxton
18:01 Re: tsearch2/GIST performance factors? Oleg Bartunov
20:02 Re: Sequential scan on FK join Martin Nickel

18 October 2005

01:58 Re: Bytea poor performance Mark Kirkwood
06:09 Re: tsearch2/GIST performance factors? Craig A. James
06:21 Re: tsearch2/GIST performance factors? Oleg Bartunov
07:55 Re: Sequential scan on FK join Richard Huxton
15:19 Re: Help tuning postgres Robert Treat
15:26 Re: Help tuning postgres Csaba Nagy
15:50 Re: Help tuning postgres Csaba Nagy
16:48 Re: Help tuning postgres Andrew Sullivan
18:07 Inefficient escape codes. Rodrigo Madera
19:03 Re: Inefficient escape codes. Michael Fuhr
21:11 Re: Inefficient escape codes. Michael Fuhr

19 October 2005

07:19 Re: Inefficient escape codes. Peter Childs
14:54 Re: Inefficient escape codes. Merlin Moncure
17:45 Materializing a sequential scan Steinar H. Gunderson

20 October 2005

04:37 Re: Materializing a sequential scan Tom Lane
04:58 Re: Materializing a sequential scan Tom Lane
07:15 Re: Inefficient escape codes. Nörder-Tuitje, Marcus
08:39 Deleting Records Christian Paul B. Cosinas
08:50 Re: Deleting Records Csaba Nagy
08:51 Re: Deleting Records Nörder-Tuitje, Marcus
08:52 Re: Deleting Records Christopher Kings-Lynne
08:52 Re: Deleting Records Matteo Beccati
08:54 Re: Deleting Records Christopher Kings-Lynne
10:16 Re: Materializing a sequential scan Steinar H. Gunderson
10:18 Re: Materializing a sequential scan Steinar H. Gunderson
14:07 cached plans in plpgsql Kuba Ouhrabka
14:15 Re: [HACKERS] tuning seqscan costs Tom Lane
15:04 Re: cached plans in plpgsql Merlin Moncure
16:25 Re: cached plans in plpgsql Kuba Ouhrabka
16:50 Re: cached plans in plpgsql Tom Lane

21 October 2005

03:36 Used Memory Christian Paul B. Cosinas
07:23 Re: Used Memory Jens-Wolfhard Schicke
07:33 Re: cached plans in plpgsql Kuba Ouhrabka
07:49 Re: Sequential scan on FK join Martin Nickel
07:58 Re: Used Memory Christian Paul B. Cosinas
08:04 Re: Used Memory Christian Paul B. Cosinas
08:41 Re: Sequential scan on FK join Martin Nickel
12:24 What gets cached? Martin Nickel
12:40 Re: What gets cached? Steinar H. Gunderson
15:19 Re: What gets cached? Alex Turner
15:30 Re: Used Memory Jon Brisbin
15:41 Re: Used Memory Alex Turner
15:59 Re: What gets cached? Michael Fuhr
16:59 Re: Inefficient escape codes. Rodrigo Madera
21:44 Re: What gets cached? Neil Conway

22 October 2005

04:55 Using LIMIT 1 in plpgsql PERFORM statements Karl O. Pinc
13:24 Re: Sequential scan on FK join Alvaro Herrera
21:15 Need help in setting optimal configuration for a huge database. Kishore B
21:43 Re: Need help in setting optimal configuration for a huge database. Steinar H. Gunderson
21:52 Re: Need help in setting optimal configuration for a huge Karl O. Pinc
21:57 Re: Need help in setting optimal configuration for a huge database. Steinar H. Gunderson
22:15 Re: Need help in setting optimal configuration for a huge database. Tom Lane

23 October 2005

02:05 Re: Need help in setting optimal configuration for a huge database. Kishore B
04:31 prepared transactions that persist across sessions? mark@mark.mielke.cc
06:50 Re: prepared transactions that persist across sessions? Bruno Wolff III
10:04 Re: Need help in setting optimal configuration for a huge Dennis Bjorklund
10:23 Re: Materializing a sequential scan Steinar H. Gunderson
16:33 Re: Need help in setting optimal configuration for a huge Craig A. James
16:55 Re: Need help in setting optimal configuration for a huge Steinar H. Gunderson
16:58 Re: Need help in setting optimal configuration for a huge Tomasz Rybak
17:06 Re: Need help in setting optimal configuration for a huge Tom Lane
21:01 Re: Using LIMIT 1 in plpgsql PERFORM statements Josh Berkus
21:35 Re: Need help in setting optimal configuration for a huge database. Kishore B
23:54 Problem analyzing explain analyze output Guillaume Smet

24 October 2005

00:08 Re: Problem analyzing explain analyze output Steinar H. Gunderson
00:14 Re: Using LIMIT 1 in plpgsql PERFORM statements Karl O. Pinc
00:29 Re: Using LIMIT 1 in plpgsql PERFORM statements Karl O. Pinc
01:42 Re: Used Memory Christian Paul B. Cosinas
03:58 performance of implicit join vs. explicit conditions on inet queries? Robert Edmonds
04:15 Re: Used Memory Mark Kirkwood
04:35 Re: Using LIMIT 1 in plpgsql PERFORM statements Josh Berkus
04:40 Re: Using LIMIT 1 in plpgsql PERFORM statements Neil Conway
05:03 Re: prepared transactions that persist across sessions? Christopher Kings-Lynne
06:33 Re: Problem analyzing explain analyze output Guillaume Smet
15:09 Re: What gets cached? Alex Turner
15:33 Re: What gets cached? Steinar H. Gunderson
15:51 Re: Used Memory Kevin Grittner
17:01 Re: Used Memory Craig A. James
19:11 Re: Inefficient escape codes. Rodrigo Madera
20:25 Re: Used Memory Scott Marlowe
21:50 Re: Used Memory Craig A. James
22:20 Re: Is There Any Way .... Craig A. James
23:11 Re: Is There Any Way .... Alex Turner

25 October 2005

00:50 Re: Is There Any Way .... Alan Stange
02:41 Re: Used Memory Christian Paul B. Cosinas
02:50 tuning seqscan costs Katherine Stoovs
02:50 impact of stats_command_string jnevans@gmail.com
02:50 Re: Inefficient escape codes. Rodrigo Madera
02:51 Need help in setting optimal configuration for a huge database. Kishore B
03:06 Re: Used Memory Mark Kirkwood
03:16 Re: Used Memory Christian Paul B. Cosinas
04:14 Re: Used Memory Mark Kirkwood
07:24 Temporary Table Christian Paul B. Cosinas
07:24 FW: Used Memory Christian Paul B. Cosinas
08:47 Why Index is not working on date columns. Kishore B
09:48 Strange planner decision on quite simple select Markus Wollny
10:10 Re: Strange planner decision on quite simple select Richard Huxton
11:35 Outer join query plans and performance Rich Doughty
13:38 Re: Why Index is not working on date columns. Tom Lane
13:44 Re: Strange planner decision on quite simple select Markus Wollny
13:49 insertion of bytea Chris Mair
13:56 Reindex - Is this necessary after a vacuum? Markus Benne
14:05 Re: insertion of bytea Michael Stone
14:12 Re: Outer join query plans and performance Tom Lane
14:20 Re: Reindex - Is this necessary after a vacuum? Richard Huxton
14:23 Re: insertion of bytea Tom Lane
14:27 Re: Reindex - Is this necessary after a vacuum? Tom Lane
15:04 Re: Why Index is not working on date columns. Kishore B
16:03 Re: Inefficient escape codes. Rodrigo Madera
16:05 Re: impact of stats_command_string Michael Fuhr
17:02 Re: impact of stats_command_string Merlin Moncure
18:01 Re: Why Index is not working on date columns. Tom Lane
18:28 Re: Outer join query plans and performance Rich Doughty
19:46 Why different execution times for different instances for the same query? Kishore B
20:24 Re: Why different execution times for different Scott Marlowe
21:40 Re: insertion of bytea Chris Mair
21:46 Re: insertion of bytea Chris Mair
22:03 Re: Outer join query plans and performance Tom Lane
22:25 Re: Outer join query plans and performance Kevin Grittner

26 October 2005

02:11 Re: Temporary Table Christian Paul B. Cosinas
04:24 blue prints please Sidar López Cruz
04:26 zero performance on query Sidar López Cruz
05:22 Re: zero performance on query Dmitri Bichko
06:01 Configuration Suggestion Christian Paul B. Cosinas
06:59 Re: blue prints please Jean-Max Reymond
08:33 Re: Outer join query plans and performance Rich Doughty
10:30 Re: zero performance on query Steinar H. Gunderson
12:05 Re: zero performance on query Merlin Moncure
15:22 Re: zero performance on query Steinar H. Gunderson
15:25 Perfomance of views Svenne Krap
18:07 Re: blue prints please Bruno Wolff III
20:33 Performance issues with custom functions Edward Di Geronimo Jr.
20:41 browsing table with 2 million records aurora
20:59 Re: browsing table with 2 million records Mark Lewis
21:06 Re: browsing table with 2 million records Scott Marlowe
21:09 Re: browsing table with 2 million records Joshua D. Drake
21:22 Re: browsing table with 2 million records aurora
21:28 Re: browsing table with 2 million records Alex Turner
21:32 Re: browsing table with 2 million records Tom Lane
21:37 Re: Materializing a sequential scan Steinar H. Gunderson
21:49 Re: browsing table with 2 million records PFC
22:48 Re: tuning seqscan costs Thomas F. O'Connell
23:06 Re: Materializing a sequential scan Tom Lane
23:18 Re: Performance issues with custom functions Tom Lane
23:22 Re: Materializing a sequential scan Steinar H. Gunderson
23:47 performance on query Sidar López Cruz
23:53 Re: Materializing a sequential scan Tom Lane

27 October 2005

00:13 Re: Materializing a sequential scan Steinar H. Gunderson
00:51 Re: Materializing a sequential scan Tom Lane
00:57 Re: Materializing a sequential scan Steinar H. Gunderson
01:41 Re: browsing table with 2 million records Christopher Kings-Lynne
01:44 Re: browsing table with 2 million records Christopher Kings-Lynne
03:00 Re: performance on query Jim C. Nasby
09:36 Re: Perfomance of views Richard Huxton
11:02 Re: Perfomance of views Svenne Krap
11:30 Re: Perfomance of views Richard Huxton
12:59 Re: browsing table with 2 million records Merlin Moncure
13:41 Re: Perfomance of views Jan Wieck
13:44 Re: insertion of bytea Chris Mair
14:27 how postgresql request the computer resources Sidar López Cruz
14:34 Re: browsing table with 2 million records PFC
14:35 Re: Performance issues with custom functions Edward Di Geronimo Jr.
14:38 Re: Perfomance of views Tom Lane
15:09 Re: Perfomance of views Svenne Krap
15:41 Update using primary key slow Denis
15:45 Re: Perfomance of views Richard Huxton
16:00 Re: how postgresql request the computer resources Richard Huxton
16:18 Re: Update using primary key slow Tom Lane
18:10 Re: Update using primary key slow Denis
19:31 How much memory? PostgreSQL
19:41 Re: Update using primary key slow Tom Lane
20:41 Re: What gets cached? PostgreSQL
21:02 Re: Reasons and drawbacks for unused item pointers (was: Update using primary key slow) Martin Lesser
21:36 Re: Reasons and drawbacks for unused item pointers (was: Update using primary key slow) Tom Lane
21:59 Re: how postgresql request the computer resources Michael Best
22:09 Re: Reasons and drawbacks for unused item pointers Martin Lesser
22:39 Re: How much memory? Ron Peacetree
22:48 Re: What gets cached? Jim C. Nasby
22:52 Re: how postgresql request the computer resources Jim C. Nasby
22:55 Re: How much memory? Jim C. Nasby

28 October 2005

13:34 UNSUBSCRIBE Nick Howden
14:02 Re: How much memory? Alex Turner
15:14 How long it takes to vacuum a big table Csaba Nagy
16:48 Re: How long it takes to vacuum a big table Jan Peterson
21:39 Best way to check for new data. Rodrigo Madera
21:53 Simple query: how to optimize Collin Peters
22:13 Re: Best way to check for new data. Havasvölgyi Ottó
22:40 Re: Simple query: how to optimize Roger Hand
23:56 Re: Simple query: how to optimize Collin Peters

29 October 2005

00:04 Re: Simple query: how to optimize Collin Peters
00:12 Re: Simple query: how to optimize Steinar H. Gunderson
00:37 Re: Simple query: how to optimize PostgreSQL
11:10 Effects of cascading references in foreign keys Martin Lesser
14:24 Re: Effects of cascading references in foreign keys Michael Fuhr
14:46 Re: Effects of cascading references in foreign keys Bruno Wolff III
14:47 Re: Effects of cascading references in foreign keys Bruno Wolff III
16:05 Re: Effects of cascading references in foreign keys Michael Fuhr
16:05 Re: Effects of cascading references in foreign keys Bruce Momjian
16:19 Re: Effects of cascading references in foreign keys Bruce Momjian
18:02 Re: Effects of cascading references in foreign keys Tom Lane
18:35 Re: Effects of cascading references in foreign keys Tom Lane

30 October 2005

04:32 Re: Effects of cascading references in foreign keys Thomas F. O'Connell
13:10 Re: Effects of cascading references in foreign keys Bruce Momjian
16:14 multi-layered view join performance oddities Svenne Krap
16:44 Re: multi-layered view join performance oddities Steinar H. Gunderson
17:27 Re: multi-layered view join performance oddities Tom Lane
17:32 Re: multi-layered view join performance oddities Svenne Krap
17:48 Re: multi-layered view join performance oddities Svenne Krap
19:16 Re: Effects of cascading references in foreign keys Martin Lesser

31 October 2005

08:49 Re: performance of implicit join vs. explicit conditions on inet queries? Qingqing Zhou
12:43 Re: Best way to check for new data. David Roussel
12:47 Re: Best way to check for new data. Merlin Moncure
13:24 Re: performance of implicit join vs. explicit conditions on inet queries? Tom Lane
13:29 Re: SOLVED: insertion of bytea Chris Mair
16:12 8.x index insert performance Kelly Burkhart
16:32 Re: 8.x index insert performance Merlin Moncure
16:51 Re: 8.x index insert performance Kelly Burkhart
18:02 Re: 8.x index insert performance Claus Guttesen
18:13 Re: 8.x index insert performance Merlin Moncure
18:52 Re: 8.x index insert performance mark@mark.mielke.cc
19:27 Re: 8.x index insert performance Merlin Moncure
19:30 Re: 8.x index insert performance Tom Lane
19:59 Re: 8.x index insert performance Kelly Burkhart
20:01 Re: 8.x index insert performance Merlin Moncure
20:03 Re: 8.x index insert performance Scott Marlowe
20:08 Re: 8.x index insert performance Tom Lane
20:10 Re: 8.x index insert performance Merlin Moncure
20:18 Re: 8.x index insert performance Tom Lane
22:16 8.1beta3 performance PostgreSQL
23:13 Re: 8.x index insert performance mark@mark.mielke.cc