Skip site navigation (1)
Skip section navigation (2)
pgsql-performance 2006-01 Chronological Index (1/3)
Last updated: Wed Jan 18 04:19:18 2012
510 messages
01 February 2006
Re: Sequential scan being used despite indexes Joshua D. Drake (03:29)
Sequential scan being used despite indexes James Russell (03:14)
Re: Huge Data sets, simple queries Jim C. Nasby (02:47)
Re: Huge Data sets, simple queries Luke Lonergan (01:35)
Re: Huge Data sets, simple queries Steinar H. Gunderson (01:26)
Re: Storing Digital Video Matt Davies | Postgresql List (00:57)
Storing Digital Video Rodrigo Madera (00:32)
31 January 2006
Re: Huge Data sets, simple queries Luke Lonergan (23:20)
Re: Huge Data sets, simple queries Luke Lonergan (23:13)
Re: Huge Data sets, simple queries Jim C. Nasby (23:12)
Re: Huge Data sets, simple queries PFC (23:10)
Re: Huge Data sets, simple queries Luke Lonergan (22:53)
Re: Huge Data sets, simple queries Luke Lonergan (20:47)
Re: Huge Data sets, simple queries Jeffrey W. Baker (20:04)
Re: Delete me Jim C. Nasby (19:23)
Re: Huge Data sets, simple queries Jim C. Nasby (19:21)
Re: Delete me Richard Huxton (18:33)
Re: Huge Data sets, simple queries Kevin (17:39)
Re: Huge Data sets, simple queries Luke Lonergan (17:01)
Delete me 2386429 (16:24)
Re: Query planner issue Tom Lane (01:55)
Re: Where is my bottleneck? Richard Huxton (00:36)
Re: Query planner issue Emmanuel Lacour (00:27)
30 January 2006
Re: Query planner issue Mark Lewis (23:26)
Query planner issue Emmanuel Lacour (22:57)
Re: Huge Data sets, simple queries Jim C. Nasby (20:25)
Re: Where is my bottleneck? Jim C. Nasby (20:10)
Re: Huge Data sets, simple queries Luke Lonergan (19:49)
Re: Huge Data sets, simple queries hubert depesz lubaczewski (17:53)
Re: Where is my bottleneck? Luke Lonergan (16:58)
Re: Where is my bottleneck? Michael Stone (11:00)
Re: Huge Data sets, simple queries Luke Lonergan (07:25)
Re: Huge Data sets, simple queries Charles Sprickman (05:35)
Re: Desperate: View not using indexes (very slow) Tom Lane (03:50)
Re: Huge Data sets, simple queries Craig A. James (03:24)
Re: Huge Data sets, simple queries Michael Adler (00:32)
29 January 2006
Re: Huge Data sets, simple queries Luke Lonergan (18:46)
Re: Huge Data sets, simple queries Michael Stone (15:43)
Re: Huge Data sets, simple queries hubert depesz lubaczewski (11:25)
28 January 2006
Re: Huge Data sets, simple queries Luke Lonergan (17:54)
Re: Huge Data sets, simple queries Tom Lane (17:37)
Re: Huge Data sets, simple queries Jeffrey W. Baker (17:08)
Re: Huge Data sets, simple queries Tom Lane (15:55)
Re: Huge Data sets, simple queries Jeffrey W. Baker (06:56)
Huge Data sets, simple queries Mike Biamonte (01:27)
27 January 2006
Re: [GENERAL] Creation of tsearch2 index is very Ron (03:33)
Re: [GENERAL] Creation of tsearch2 index is very Craig A. James (02:33)
Re: [GENERAL] Creation of tsearch2 index is very Ron (01:55)
Re: [GENERAL] Creation of tsearch2 index is very Alvaro Herrera (00:57)
Re: [GENERAL] Creation of tsearch2 index is very Ron (00:18)
26 January 2006
Re: Incorrect Total runtime Reported by Explain Analyze!? Scott Marlowe (17:59)
Re: Incorrect Total runtime Reported by Explain Analyze!? Michael Fuhr (17:57)
Re: Incorrect Total runtime Reported by Explain Analyze!? Jozsef Szalay (17:35)
Re: Query optimization with X Y JOIN J (17:13)
Re: Incorrect Total runtime Reported by Explain Analyze!? Richard Huxton (16:50)
Re: Query optimization with X Y JOIN Richard Huxton (16:47)
Re: Incorrect Total runtime Reported by Explain Analyze!? Scott Marlowe (16:35)
Re: Query optimization with X Y JOIN Joshua D. Drake (16:33)
Re: Query optimization with X Y JOIN J (16:25)
Re: Query optimization with X Y JOIN Craig A. James (16:17)
Incorrect Total runtime Reported by Explain Analyze!? Jozsef Szalay (15:50)
Query optimization with X Y JOIN J (15:43)
Re: PostgreSQL Solaris packages now in beta Jignesh K. Shah (14:56)
Re: Physical column size Mario Weilguni (10:22)
Physical column size Paul Mackay (10:06)
PostgreSQL Solaris packages now in beta Robert Lor (01:46)
25 January 2006
Re: DB responce during DB dump Evgeny Gridasov (16:43)
Re: DB responce during DB dump Tom Lane (16:24)
Desperate: View not using indexes (very slow) Jen Sale (16:09)
Re: DB responce during DB dump Richard Huxton (12:44)
DB responce during DB dump Evgeny Gridasov (12:01)
Re: Inconsistant query plan Alessandro Baretta (09:05)
Re: Inconsistant query plan Daniel Gish (01:02)
24 January 2006
Re: Inconsistant query plan Scott Marlowe (23:30)
Inconsistant query plan Daniel Gish (23:19)
Re: Investigating IO Saturation Andrew Sullivan (21:00)
Re: Investigating IO Saturation Chris Browne (20:04)
Where is my bottleneck? Arnau Rebassa Villalonga (18:40)
Re: Investigating IO Saturation Joshua D. Drake (17:08)
Re: Investigating IO Saturation Tom Lane (17:07)
Re: Investigating IO Saturation Brad Nicholson (17:03)
Re: Investigating IO Saturation Joshua D. Drake (16:41)
Investigating IO Saturation Brad Nicholson (16:35)
23 January 2006
Re: Slow queries consisting inner selects and order bys & hack to speed up Tom Lane (19:19)
Re: [PERFORMANCE] Stored Procedures Frank Wiles (17:24)
Re: [PERFORMANCE] Stored Procedures Dave Dutcher (16:23)
Re: [PERFORMANCE] Stored Procedures Marcos (15:32)
Re: [PERFORMANCE] Stored Procedures Markus Schaber (12:30)
Re: Suspending SELECTs Alessandro Baretta (10:31)
Re: [PERFORMANCE] Stored Procedures Marcos (10:19)
ENC: RES: pg_dump slow - Solution Franklin Haut (09:46)
22 January 2006
Re: Suspending SELECTs August Zajonc (16:04)
Re: tsearch2 headline and postgresql.conf Oleg Bartunov (08:25)
tsearch2 headline and postgresql.conf pgsql-performance (07:53)
Re: libpq vs. unixODBC performance Tom Lane (00:40)
21 January 2006
Re: [PERFORMANCE] Stored Procedures Rikard Pavelic (21:06)
Re: [GENERAL] Creation of tsearch2 index is very Tom Lane (20:56)
Slow queries consisting inner selects and order bys & hack to speed up Ümit Öztosun (20:55)
Re: [GENERAL] Creation of tsearch2 index is very David Lang (20:48)
Re: [GENERAL] Creation of tsearch2 index is very slow Martijn van Oosterhout (20:36)
Re: [GENERAL] Creation of tsearch2 index is very Tom Lane (18:27)
Re: [GENERAL] Creation of tsearch2 index is very slow Oleg Bartunov (17:29)
Re: [GENERAL] Creation of tsearch2 index is very slow Oleg Bartunov (17:29)
Re: [GENERAL] Creation of tsearch2 index is very Ron (16:39)
Re: [GENERAL] Creation of tsearch2 index is very Oleg Bartunov (16:33)
Re: [GENERAL] Creation of tsearch2 index is very slow Martijn van Oosterhout (16:25)
Re: SELECT MIN, MAX took longer time than SELECT K C Lau (13:39)
Re: [GENERAL] Creation of tsearch2 index is very Oleg Bartunov (13:34)
Re: [GENERAL] Creation of tsearch2 index is very slow Oleg Bartunov (13:29)
Re: SELECT MIN, MAX took longer time than SELECT K C Lau (13:27)
Re: [GENERAL] Creation of tsearch2 index is very slow Martijn van Oosterhout (13:08)
Re: [GENERAL] Creation of tsearch2 index is very Ron (12:22)
Re: [PERFORMANCE] Stored Procedures Rikard Pavelic (08:00)
Re: [GENERAL] Creation of tsearch2 index is very slow Craig A. James (01:34)
Re: [GENERAL] Creation of tsearch2 index is very slow Steinar H. Gunderson (00:36)
Re: [GENERAL] Creation of tsearch2 index is very slow Tom Lane (00:23)
Re: [GENERAL] Creation of tsearch2 index is very slow Steinar H. Gunderson (00:05)
20 January 2006
Re: [GENERAL] Creation of tsearch2 index is very slow Steinar H. Gunderson (23:28)
Re: [GENERAL] Creation of tsearch2 index is very slow Steinar H. Gunderson (23:17)
Re: [GENERAL] Creation of tsearch2 index is very slow Steinar H. Gunderson (22:59)
Re: [GENERAL] Creation of tsearch2 index is very slow Martijn van Oosterhout (22:57)
Re: [GENERAL] Creation of tsearch2 index is very slow Tom Lane (22:50)
Re: [GENERAL] Creation of tsearch2 index is very slow Steinar H. Gunderson (22:49)
Re: [GENERAL] Creation of tsearch2 index is very slow Ron (22:46)
Re: [GENERAL] Creation of tsearch2 index is very slow Martijn van Oosterhout (22:33)
Re: [GENERAL] Creation of tsearch2 index is very slow Ron (22:29)
Re: [GENERAL] Creation of tsearch2 index is very slow Steinar H. Gunderson (22:16)
Re: Sudden slowdown of Pg server Jignesh K. Shah (22:14)
Sudden slowdown of Pg server Jerry Sievers (21:57)
Re: [GENERAL] Creation of tsearch2 index is very slow Tom Lane (21:50)
Re: [GENERAL] Creation of tsearch2 index is very slow Steinar H. Gunderson (21:44)
Re: [GENERAL] Creation of tsearch2 index is very slow Martijn van Oosterhout (21:38)
Re: [PERFORMANCE] Stored Procedures Jim C. Nasby (21:35)
Re: [GENERAL] Creation of tsearch2 index is very slow Tom Lane (21:19)
Re: [GENERAL] Creation of tsearch2 index is very slow Martijn van Oosterhout (20:51)
Re: [GENERAL] Creation of tsearch2 index is very slow Tom Lane (20:21)
Re: [GENERAL] Creation of tsearch2 index is very slow Martijn van Oosterhout (20:10)
Re: [PERFORMANCE] Stored Procedures Rikard Pavelic (19:39)
Re: [GENERAL] Creation of tsearch2 index is very slow Tom Lane (19:14)
Re: [PERFORMANCE] Stored Procedures Jim C. Nasby (19:10)
Re: query stopped working after tables > 50000 records Jim C. Nasby (19:04)
Re: Autovacuum / full vacuum (off-topic?) Jim C. Nasby (19:02)
Re: Stored procedures Rikard Pavelic (18:56)
Re: SELECT MIN, MAX took longer time than SELECT COUNT, MIN, MAX Tom Lane (18:51)
Re: [PERFORMANCE] Stored Procedures Rikard Pavelic (18:51)
query stopped working after tables > 50000 records Antoine (18:32)
Re: Autovacuum / full vacuum (off-topic?) me (17:47)
Re: Autovacuum / full vacuum (off-topic?) Jim C. Nasby (17:44)
Re: Autovacuum / full vacuum (off-topic?) Joshua D. Drake (17:35)
Re: Autovacuum / full vacuum (off-topic?) Jim C. Nasby (17:34)
Re: Autovacuum / full vacuum (off-topic?) Joshua D. Drake (17:29)
Re: SELECT MIN, MAX took longer time than SELECT COUNT, MIN, MAX Jim C. Nasby (17:20)
Re: Autovacuum / full vacuum (off-topic?) Jim C. Nasby (17:12)
Re: Extremely irregular query performance Bruce Momjian (16:42)
Re: Extremely irregular query performance Tom Lane (16:35)
Re: Extremely irregular query performance Bruce Momjian (16:19)
Re: Retaining execution plans between connections? Neil Conway (15:14)
Re: Retaining execution plans between connections? Pandurangan R S (09:35)
Retaining execution plans between connections? James Russell (09:14)
SELECT MIN, MAX took longer time than SELECT COUNT, MIN, MAX K C Lau (04:39)
19 January 2006
Re: Autovacuum / full vacuum (off-topic?) Mark Kirkwood (23:10)
Re: 3WARE Card performance boost? Alex Turner (22:54)
Re: Stable function being evaluated more than once in a single Bruce Momjian (22:52)
Re: query plans different for 8.1 on windows and aix Tom Lane (22:27)