Skip site navigation (1)
Skip section navigation (2)
pgsql-performance 2003-11 Chronological Index (1/2)
Last updated: Wed Jan 18 04:22:30 2012
300 messages
30 November 2003
28 November 2003
Re: simple left join slows query more than expected Tom Lane (17:56)
simple left join slows query more than expected Jonathan Knopp (05:58)
Re: For full text indexing, which is better, tsearch2 or Christopher Kings-Lynne (05:22)
Re: For full text indexing, which is better, tsearch2 or Christopher Kings-Lynne (05:14)
Re: For full text indexing, which is better, tsearch2 or Steve Atkins (05:09)
27 November 2003
Re: very large db performance question Thierry Missimilly (08:41)
Re: For full text indexing, which is better, tsearch2 or Steve Atkins (05:17)
Re: For full text indexing, which is better, tsearch2 or Christopher Kings-Lynne (04:38)
Re: For full text indexing, which is better, tsearch2 or Steve Atkins (03:33)
Re: For full text indexing, which is better, tsearch2 or Dror Matalon (01:04)
Re: very large db performance question Christopher Kings-Lynne (00:59)
Re: For full text indexing, which is better, tsearch2 or Christopher Kings-Lynne (00:47)
Re: Followup - expression (functional) index use in joins Tom Lane (00:09)
26 November 2003
Re: cross table indexes or something? Hannu Krosing (22:33)
Re: cross table indexes or something? Marc A. Leith (22:24)
Re: very large db performance question Neil Conway (22:03)
Re: Followup - expression (functional) index use in joins Roger Ging (21:29)
very large db performance question LIANHE SHAO (20:19)
cross table indexes or something? Jeremiah Jahn (20:14)
For full text indexing, which is better, tsearch2 or fulltextindex LIANHE SHAO (20:03)
Re: Followup - expression (functional) index use in joins Richard Huxton (19:13)
Re: Maximum Possible Insert Performance? Dror Matalon (18:54)
Followup - expression (functional) index use in joins Roger Ging (18:39)
Re: Maximum Possible Insert Performance? William Yu (18:22)
Re: expression (functional) index use in joins Richard Huxton (18:00)
Re: Maximum Possible Insert Performance? Tom Lane (17:56)
Re: why index scan not working when using 'like'? Hannu Krosing (17:33)
Re: Impossibly slow DELETEs Greg Stark (17:12)
Re: Maximum Possible Insert Performance? William Yu (16:52)
expression (functional) index use in joins Roger Ging (16:38)
Re: Optimize Shridhar Daithankar (06:07)
Re: Impossibly slow DELETEs Tom Lane (00:37)
25 November 2003
Re: Wierd context-switching issue on Xeon Josh Berkus (23:48)
Re: Impossibly slow DELETEs Bill Moran (23:45)
Re: Wierd context-switching issue on Xeon Tom Lane (23:41)
Wierd context-switching issue on Xeon Josh Berkus (22:30)
Re: [Fwd: Re: Optimize] Russell Garrett (22:27)
Re: Optimize Torsten Schulz (22:07)
Re: [Fwd: Re: Optimize] Torsten Schulz (22:06)
Impossibly slow DELETEs Stefan Champailler (21:58)
Re: why index scan not working when using 'like'? Tom Lane (21:29)
Re: [Fwd: Re: Optimize] Gaetano Mendola (20:20)
Re: why index scan not working when using 'like'? Josh Berkus (20:02)
Re: why index scan not working when using 'like'? Dror Matalon (19:57)
why index scan not working when using 'like'? LIANHE SHAO (19:47)
[Fwd: Re: Optimize] Torsten Schulz (19:39)
Re: design question: general db performance Richard Huxton (19:28)
Re: design question: general db performance Jeff (19:24)
Re: design question: general db performance Josh Berkus (19:23)
Re: Maximum Possible Insert Performance? Suchandra Thapa (19:05)
Re: design question: general db performance Jord Tanner (18:59)
design question: general db performance shane hill (18:28)
Re: Where to start for performance problem? Tom Lane (17:08)
Re: Where to start for performance problem? Bruno Wolff III (16:54)
Re: Maximum Possible Insert Performance? Tom Lane (15:48)
Re: Where to start for performance problem? Rob Fielding (14:05)
Re: Maximum Possible Insert Performance? Shridhar Daithankar (06:07)
Re: [HACKERS] More detail on settings for pgavd? Christopher Browne (04:21)
Re: Where to start for performance problem? Christopher Kings-Lynne (03:16)
Re: Where to start for performance problem? Nid (03:05)
Re: VACUUM problems with 7.4 Neil Conway (02:28)
Re: Optimize Neil Conway (02:25)
Re: Maximum Possible Insert Performance? Greg Stark (01:17)
Re: Where to start for performance problem? Christopher Kings-Lynne (01:12)
24 November 2003
Where to start for performance problem? MK Spam (22:03)
Re: Optimize Gaetano Mendola (21:56)
Re: Optimize Dennis Bjorklund (21:46)
Re: Optimize Torsten Schulz (21:33)
Re: Optimize Gaetano Mendola (21:20)
Optimize Torsten Schulz (20:48)
Re: Problem with insert into select... Richard Huxton (19:30)
Re: Maximum Possible Insert Performance? William Yu (18:52)
Re: Maximum Possible Insert Performance? Josh Berkus (18:06)
Re: VACUUM problems with 7.4 mallah (18:02)
Re: Maximum Possible Insert Performance? William Yu (17:51)
Re: VACUUM problems with 7.4 Tom Lane (17:45)
Re: Maximum Possible Insert Performance? Josh Berkus (17:27)
Re: Maximum Possible Insert Performance? William Yu (17:21)
VACUUM problems with 7.4 Rajesh Kumar Mallah (17:14)
Re: Maximum Possible Insert Performance? Bill Moran (13:39)
Re: pg_autoconfig.pl Nick Barr (11:26)
Re: Maximum Possible Insert Performance? Shridhar Daithankar (05:51)
Re: Maximum Possible Insert Performance? Joe Conway (04:42)
Re: Maximum Possible Insert Performance? Josh Berkus (04:30)
Re: Maximum Possible Insert Performance? Tom Lane (04:22)
Maximum Possible Insert Performance? William Yu (03:51)
22 November 2003
Re: pg_autoconfig.pl Josh Berkus (17:20)
pg_autoconfig.pl Nick Barr (11:57)
21 November 2003
Re: [HACKERS] More detail on settings for pgavd? Tom Lane (23:05)
Re: [HACKERS] More detail on settings for pgavd? Matthew T. O'Connor (22:41)
Re: [HACKERS] More detail on settings for pgavd? Josh Berkus (22:00)
Re: [HACKERS] More detail on settings for pgavd? Matthew T. O'Connor (21:53)
Re: [HACKERS] More detail on settings for pgavd? Josh Berkus (21:34)
Re: [HACKERS] More detail on settings for pgavd? Matthew T. O'Connor (21:25)
Re: [HACKERS] More detail on settings for pgavd? Josh Berkus (17:10)
Re: [HACKERS] More detail on settings for pgavd? Matthew T. O'Connor (15:18)
Re: [HACKERS] More detail on settings for pgavd? Shridhar Daithankar (15:07)
Re: [HACKERS] More detail on settings for pgavd? Matthew T. O'Connor (14:56)
Re: duration logging setting in 7.4 Tom Lane (14:55)
Re: [HACKERS] More detail on settings for pgavd? Matthew T. O'Connor (14:32)
Re: [HACKERS] More detail on settings for pgavd? Robert Treat (14:14)
Re: duration logging setting in 7.4 Ryszard Lach (10:19)
Re: Hardware advice Adam Witney (10:10)
Re: duration logging setting in 7.4 Ryszard Lach (08:53)
Re: [HACKERS] More detail on settings for pgavd? Josh Berkus (06:25)
Re: Problem with insert into select... stephen farrell (02:05)
Re: [HACKERS] More detail on settings for pgavd? Matthew T. O'Connor (00:41)
Re: duration logging setting in 7.4 Tom Lane (00:17)
20 November 2003
Re: Problem with insert into select... Tom Lane (22:59)
Problem with insert into select... stephen farrell (21:10)
Problem with insert into select... stephen farrell (21:05)
Re: [HACKERS] More detail on settings for pgavd? Chester Kustarz (20:55)
Re: [HACKERS] More detail on settings for pgavd? Tom Lane (19:21)
Re: [HACKERS] More detail on settings for pgavd? Chester Kustarz (18:49)
Re: More detail on settings for pgavd? Josh Berkus (18:01)
Re: [HACKERS] More detail on settings for pgavd? Josh Berkus (17:19)
Re: [HACKERS] More detail on settings for pgavd? Shridhar Daithankar (15:08)
Re: [HACKERS] More detail on settings for pgavd? Shridhar Daithankar (15:00)
Re: More detail on settings for pgavd? Shridhar Daithankar (07:24)
Re: High Processor consumption Shridhar Daithankar (05:58)
Re: Backup/restore of pg_statistics Tom Lane (04:40)
19 November 2003
Re: duration logging setting in 7.4 Ryszard Lach (19:29)
Re: TEXT column and indexing Ian Barwick (19:17)
Re: TEXT column and indexing Ian Barwick (19:15)
Re: duration logging setting in 7.4 Bruce Momjian (18:59)
Re: duration logging setting in 7.4 Ryszard Lach (18:39)
Re: More detail on settings for pgavd? Josh Berkus (17:08)
Re: TEXT column and indexing Stephan Szabo (16:35)
Re: TEXT column and indexing Manfred Koizar (16:28)
Re: constant vs function param differs in performance SZŰCS Gábor (16:07)
Re: More detail on settings for pgavd? Josh Berkus (16:01)
Re: problem with select count(*) .. Bruno Wolff III (15:51)
Re: More detail on settings for pgavd? Shridhar Daithankar (14:11)
Re: Join on incompatible types Shridhar Daithankar (12:32)
Re: Join on incompatible types Laurent Martelli (12:24)
Re: Join on incompatible types Shridhar Daithankar (10:20)
Re: Join on incompatible types Laurent Martelli (10:01)
TEXT column and indexing Ian Barwick (09:18)
Re: Join on incompatible types Shridhar Daithankar (06:54)
Re: High Processor consumption Shridhar Daithankar (06:34)
Re: More detail on settings for pgavd? Shridhar Daithankar (06:33)
problem with select count(*) .. Rajesh Kumar Mallah (01:37)
High Processor consumption Benjamin Bostow (01:20)
More detail on settings for pgavd? Josh Berkus (00:01)
18 November 2003
Re: duration logging setting in 7.4 Bruce Momjian (15:08)
Re: Join on incompatible types Laurent Martelli (13:33)
Re: Join on incompatible types Shridhar Daithankar (10:46)
Join on incompatible types Laurent Martelli (10:10)
Re: duration logging setting in 7.4 Ryszard Lach (09:18)
Re: duration logging setting in 7.4 Bruce Momjian (02:38)
17 November 2003
Re: Top n queries and GROUP BY Rich Cullingford (17:56)
Top n queries and GROUP BY Rich Cullingford (16:39)
Backup/restore of pg_statistics Joel Jacobson (14:51)
Re: INSERT extremely slow with large data sets (fwd) Andrew Sullivan (14:43)
16 November 2003
Re: n_distinct way off, but following a pattern. Nick Fankhauser (13:53)
15 November 2003
Re: Error in transaction processing radha.manohar (14:53)
Re: INSERT extremely slow with large data sets (fwd) George Essig (13:14)
Re: Help with count(*) Dennis Bjorklund (10:21)
Re: Query question Christopher Kings-Lynne (03:37)
Re: INSERT extremely slow with large data sets (fwd) Slavisa Garic (01:21)
14 November 2003
Re: Error in transaction processing radha.manohar (22:07)
Re: INSERT extremely slow with large data sets (fwd) George Essig (22:03)
Re: Help with count(*) Andrew Sullivan (21:30)
n_distinct way off, but following a pattern. Nick Fankhauser (21:27)