Hosting Provided By

Mailing List Archive For pgsql-performance@postgresql.org By messages with attachments

[PERFORM] switchover between index and sequential scans Abhijit Menon-Sen (Thu Jul 03 2008 - 03:59:00 EDT)
1. pgSnapBack3.generic (10270 bytes)
Re: [PERFORM] [QUESTION]Concurrent Access Devrim GÜNDÜZ (Wed Jul 02 2008 - 14:42:16 EDT)
1. signature.asc (198 bytes)
[PERFORM] [QUESTION]Concurrent Access Leví Teodoro da Silva (Wed Jul 02 2008 - 14:31:10 EDT)
1. signature.asc (188 bytes)
Re: [PERFORM] Hot Issue Devrim GÜNDÜZ (Wed Jul 02 2008 - 09:40:10 EDT)
1. signature.asc (198 bytes)
Re: [PERFORM] Fusion-io ioDrive Cédric Villemain (Wed Jul 02 2008 - 09:36:06 EDT)
1. signature.asc_ (198 bytes)
Re: [PERFORM] Hot Issue Devrim GÜNDÜZ (Wed Jul 02 2008 - 09:08:04 EDT)
1. part (253 bytes)
2. signature.asc (198 bytes)
Re: [PERFORM] Fusion-io ioDrive Greg Smith (Tue Jul 01 2008 - 21:38:04 EDT)
1. archive.png (17689 bytes)
Re: [PERFORM] Fusion-io ioDrive Jeffrey Baker (Tue Jul 01 2008 - 21:36:02 EDT)
1. signature.asc (188 bytes)
Re: [PERFORM] VACUUM ANALYZE blocking both reads and writes to a table Peter Schuller (Tue Jul 01 2008 - 11:26:35 EDT)
1. part (196 bytes)
Re: [PERFORM] VACUUM ANALYZE blocking both reads and writes to a table Peter Schuller (Mon Jun 30 2008 - 11:43:18 EDT)
1. part (196 bytes)
Re: [PERFORM] VACUUM ANALYZE blocking both reads and writes to a table Peter Schuller (Mon Jun 30 2008 - 11:34:35 EDT)
1. part (196 bytes)
[PERFORM] VACUUM ANALYZE blocking both reads and writes to a table Peter Schuller (Mon Jun 30 2008 - 10:59:03 EDT)
1. part (196 bytes)
Re: [PERFORM] A guide/tutorial to performance monitoring and tuning Cédric Villemain (Mon Jun 30 2008 - 09:54:08 EDT)
1. signature.asc_ (198 bytes)
Re: [PERFORM] Planner should use index on a LIKE 'foo%' query Dimitri Fontaine (Mon Jun 30 2008 - 06:20:40 EDT)
1. signature.asc_ (198 bytes)
[PERFORM] Out of memory for Select query. Nimesh Satam (Mon Jun 30 2008 - 00:20:15 EDT)
1. explain.txt (3374 bytes)
Re: [PERFORM] Hardware vs Software Raid Peter T. Breuer (Thu Jun 26 2008 - 01:03:38 EDT)
1. signature.asc (188 bytes)
Re: [PERFORM] Hardware vs Software RAID Peter T. Breuer (Wed Jun 25 2008 - 09:11:23 EDT)
1. pg_autoconfig.pl (6789 bytes)
Re: [PERFORM] Tsearch2 Initial Search Speed Howard Cole (Tue Jun 17 2008 - 09:28:23 EDT)
1. Untitled1 (885 bytes)
[PERFORM] Migration Articles.. ??? sathiya psql (Tue Jun 17 2008 - 09:13:18 EDT)
1. part (190 bytes)
Re: [PERFORM] Tsearch2 Initial Search Speed Matthew Wakeling (Tue Jun 17 2008 - 09:13:27 EDT)
1. part (190 bytes)
Re: [PERFORM] query performance question PFC (Tue Jun 03 2008 - 20:10:45 EDT)
1. signature.asc (188 bytes)
Re: [PERFORM] query performance question Marcin Citowicki (Tue Jun 03 2008 - 04:55:22 EDT)
1. marcin_citowicki.vcf (142 bytes)
[PERFORM] query performance question Marcin Citowicki (Tue Jun 03 2008 - 03:57:15 EDT)
1. marcin_citowicki.vcf (135 bytes)
Re: [PERFORM] Outer joins and equivalence Simon Riggs (Mon Jun 02 2008 - 15:47:11 EDT)
1. 8 (1409 bytes)
Re: [PERFORM] 2GB or not 2GB Magnus Hagander (Thu May 29 2008 - 15:50:48 EDT)
1. part (190 bytes)
[PERFORM] Adding "LIMIT 1" kills performance. Chris Shoemaker (Thu May 29 2008 - 11:47:34 EDT)
1. part (188 bytes)
Re: [PERFORM] Outer joins and equivalence Simon Riggs (Wed May 28 2008 - 09:39:10 EDT)
1. part (190 bytes)
Re: [PERFORM] [GENERAL] select query takes 13 seconds to run with index PFC (Tue May 27 2008 - 04:19:37 EDT)
1. signature.asc (188 bytes)
Re: [PERFORM] Symbolic Links to Tablespaces Tino Wildenhain (Mon May 26 2008 - 15:19:03 EDT)
1. smime.p7s (3241 bytes)
Re: [PERFORM] I/O on select count(*) Decibel! (Sat May 24 2008 - 15:15:34 EDT)
1. smime.p7s (2563 bytes)
Re: [PERFORM] I/O on select count(*) Decibel! (Sat May 24 2008 - 15:06:56 EDT)
1. smime.p7s (2563 bytes)
Re: [PERFORM] Posible planner improvement? Decibel! (Sat May 24 2008 - 14:49:46 EDT)
1. smime.p7s (2563 bytes)
Re: [PERFORM] shared_buffers performance Decibel! (Sat May 24 2008 - 13:55:15 EDT)
1. smime.p7s (2563 bytes)
Re: [PERFORM] Creating large database of MD5 hash values Decibel! (Sat May 24 2008 - 13:43:51 EDT)
1. smime.p7s (2563 bytes)
Re: [PERFORM] "Big O" notation for postgres? Gregory Stark (Thu May 22 2008 - 16:59:46 EDT)
1. signature.asc (188 bytes)
Re: [PERFORM] Index creation time and distribution Matthew Wakeling (Thu May 22 2008 - 10:10:06 EDT)
1. signature.asc (188 bytes)
Re: [PERFORM] "Big O" notation for postgres? PFC (Wed May 21 2008 - 12:27:14 EDT)
1. signature.asc (188 bytes)
Re: [PERFORM] Posible planner improvement? Richard Huxton (Wed May 21 2008 - 09:09:49 EDT)
1. signature.asc (188 bytes)
Re: [PERFORM] Posible planner improvement? Albert Cervera Areny (Wed May 21 2008 - 07:30:16 EDT)
1. queries.txt (3433 bytes)
Re: [PERFORM] Posible planner improvement? Albert Cervera Areny (Wed May 21 2008 - 07:11:24 EDT)
1. queries.txt (2507 bytes)
[PERFORM] Varchar pkey instead of integer Robins Tharakan (Wed May 21 2008 - 01:40:43 EDT)
1. part (190 bytes)
Re: [PERFORM] Author Wanted Bill Moran (Tue May 20 2008 - 08:32:25 EDT)
1. part (190 bytes)
Re: [PERFORM] I/O on select count(*) Greg Smith (Mon May 19 2008 - 11:47:38 EDT)
1. 00000009.mimetmp (190 bytes)
2. part (190 bytes)
Re: [PERFORM] Strange behavior: pgbench and new Linux kernels Greg Smith (Sun May 18 2008 - 12:25:39 EDT)
1. Untitled1 (1261 bytes)
Re: [PERFORM] which ext3 fs type should I use for postgresql Joshua D. Drake (Fri May 16 2008 - 13:15:05 EDT)
1. signature.asc (190 bytes)
Re: [PERFORM] which ext3 fs type should I use for postgresql david(at)lang.hm (Fri May 16 2008 - 05:58:08 EDT)
1. new_plan_explained.txt (3449 bytes)
Re: [PERFORM] Join runs for > 10 hours and then fills up >1.3TB of disk space kevin kempter (Fri May 16 2008 - 04:00:41 EDT)
1. signature.asc (188 bytes)
Re: [PERFORM] Join runs for > 10 hours and then fills up >1.3TB of disk space kevin kempter (Fri May 16 2008 - 03:08:37 EDT)
1. new_plan_explained.txt (3694 bytes)
Re: [PERFORM] I/O on select count(*) Robert Lor (Thu May 15 2008 - 17:23:10 EDT)
1. bits-test.patch (4683 bytes)
Re: [PERFORM] I/O on select count(*) Tom Lane (Thu May 15 2008 - 13:42:09 EDT)
1. part (253 bytes)
Re: [PERFORM] I/O on select count(*) Alvaro Herrera (Thu May 15 2008 - 11:49:32 EDT)
1. plan_explained.txt (3498 bytes)
Re: [PERFORM] I/O on select count(*) Heikki Linnakangas (Thu May 15 2008 - 11:15:50 EDT)
1. plan.txt (2644 bytes)
Re: [PERFORM] Update performance degrades over time Jeffrey Baker (Thu May 15 2008 - 09:56:24 EDT)
1. signature.asc (188 bytes)
Re: [PERFORM] I/O on select count(*) Tino Wildenhain (Thu May 15 2008 - 01:20:11 EDT)
1. smime.p7s (3241 bytes)
Re: [PERFORM] I/O on select count(*) Joshua D. Drake (Wed May 14 2008 - 23:13:30 EDT)
1. signature.asc (190 bytes)
[PERFORM] poor row estimates with multi-column joins Robert Treat (Wed May 14 2008 - 18:34:54 EDT)
1. plan.txt (2998 bytes)
Re: [PERFORM] Problem with 11 M records table Craig James (Tue May 13 2008 - 13:57:08 EDT)
1. signature.asc (190 bytes)
Re: [PERFORM] RAID controllers for Postgresql on large setups Scott Marlowe (Tue May 13 2008 - 04:17:41 EDT)
1. signature.asc (184 bytes)
Re: [PERFORM] RAID controllers for Postgresql on large setups Joshua D. Drake (Mon May 12 2008 - 22:11:18 EDT)
1. signature.asc (190 bytes)
[PERFORM] Partitioning: INSERT 0 0 but want INSERT 0 1 Nikolas Everett (Mon May 12 2008 - 12:18:57 EDT)
1. testdump.sql (11237 bytes)
Re: [PERFORM] Creating indexes Alan Hodgson (Thu May 08 2008 - 15:52:30 EDT)
1. signature.asc_ (190 bytes)
Re: [PERFORM] Creating a foreign key Shaun Thomas (Thu May 08 2008 - 13:18:59 EDT)
1. signature.asc (188 bytes)
Re: [PERFORM] Creating a foreign key Joshua D. Drake (Thu May 08 2008 - 13:00:14 EDT)
1. signature.asc (190 bytes)
Re: [PERFORM] Possible Redundancy/Performance Solution Scott Marlowe (Tue May 06 2008 - 21:57:53 EDT)
1. signature.asc (188 bytes)
Re: [PERFORM] multiple joins + Order by + LIMIT query performance issue Shaun Thomas (Tue May 06 2008 - 14:24:33 EDT)
1. signature.asc (188 bytes)
Re: [PERFORM] Pros and Cons of 8.3.1 Joshua D. Drake (Fri May 02 2008 - 12:30:47 EDT)
1. signature.asc (190 bytes)
Re: [PERFORM] Please ignore ... Alvaro Herrera (Fri May 02 2008 - 10:29:34 EDT)
1. signature.asc (188 bytes)
Re: [PERFORM] Postgres replication Fujii Masao (Thu May 01 2008 - 05:33:54 EDT)
1. signature.asc (190 bytes)
Re: [PERFORM] Please ignore ... Tino Wildenhain (Thu May 01 2008 - 03:35:31 EDT)
1. smime.p7s (3241 bytes)
Re: [PERFORM] Replication Syatem Gauri Kanekar (Tue Apr 29 2008 - 07:05:40 EDT)
1. big_update_test.pl (1292 bytes)
Re: [PERFORM] Replication Syatem Gauri Kanekar (Tue Apr 29 2008 - 01:46:57 EDT)
1. signature.asc (188 bytes)
Re: [PERFORM] Benchmarks WAS: Sun Talks about MySQL Joshua D. Drake (Mon Apr 28 2008 - 16:55:27 EDT)
1. signature.asc (190 bytes)
Re: [PERFORM] Replication Syatem Greg Smith (Mon Apr 28 2008 - 13:39:39 EDT)
1. signature.asc (190 bytes)
Re: [PERFORM] Best practice to load a huge table from ORACLE to PG Dimitri Fontaine (Mon Apr 28 2008 - 03:49:37 EDT)
1. signature.asc_ (190 bytes)
Re: [PERFORM] Performance of the Materialize operator in a query plan Viktor Rosenfeld (Thu Apr 24 2008 - 10:31:58 EDT)
1. signature.asc (188 bytes)
Re: [PERFORM] mysterious difference in speed when combining two queries with OR Hans Ekbrand (Wed Apr 23 2008 - 05:22:09 EDT)
1. signature.asc (190 bytes)
Re: [PERFORM] mysterious difference in speed when combining two queries with OR hans (Wed Apr 23 2008 - 05:06:08 EDT)
1. signature.asc (190 bytes)
Re: [PERFORM] mysterious difference in speed when combining two queries with OR A. Kretschmer (Wed Apr 23 2008 - 04:57:04 EDT)
1. signature.asc (188 bytes)
[PERFORM] mysterious difference in speed when combining two queries with OR Hans Ekbrand (Wed Apr 23 2008 - 03:23:07 EDT)
1. signature.asc (190 bytes)
Re: [PERFORM] CPU bound at 99% Rodrigo Gonzalez (Tue Apr 22 2008 - 12:21:03 EDT)
1. smime.p7s (3245 bytes)
Re: [PERFORM] CPU bound at 99% Bryan Buecking (Tue Apr 22 2008 - 12:16:43 EDT)
1. signature.asc (188 bytes)
Re: [PERFORM] Group by more efficient than distinct? Mark Mielke (Tue Apr 22 2008 - 09:04:30 EDT)
1. signature.asc (188 bytes)
Re: [PERFORM] Group by more efficient than distinct? Mark Mielke (Mon Apr 21 2008 - 21:39:15 EDT)
1. signature.asc (188 bytes)
Re: [PERFORM] Re: [HACKERS] [COMMITTERS] pgsql: Fix TransactionIdIsCurrentTransactionId() to use binary search Alvaro Herrera (Mon Apr 21 2008 - 12:54:24 EDT)
1. postgresql.conf (5202 bytes)
Re: [PERFORM] Message queue table.. Craig Ringer (Fri Apr 18 2008 - 14:18:40 EDT)
1. signature.asc (190 bytes)
Re: [PERFORM] 3-days-long vacuum of 20GB table Jeffrey Baker (Fri Apr 18 2008 - 13:34:57 EDT)
1. signature.asc (190 bytes)
Re: [PERFORM] seq scan issue... PFC (Thu Apr 17 2008 - 19:53:19 EDT)
1. signature.asc (188 bytes)
Re: [PERFORM] SQL Function Slowness, 8.3.0 Tom Lane (Thu Apr 17 2008 - 19:38:54 EDT)
1. signature.asc (188 bytes)
Re: [PERFORM] seq scan issue... Rodrigo Gonzalez (Thu Apr 17 2008 - 14:31:10 EDT)
1. smime.p7s (3245 bytes)
Re: [PERFORM] Strange behavior: pgbench and new Linux kernels Matthew (Thu Apr 17 2008 - 11:52:06 EDT)
1. postgresql.conf (5202 bytes)
2. explain2.sql (13862 bytes)
Re: [PERFORM] db size Adrian Moisey (Thu Apr 17 2008 - 04:43:47 EDT)
1. test4 (2473 bytes)
2. test4.deadline (1359 bytes)
3. pgbench.7.4CVSHEAD.24.20 (2476 bytes)
Re: Fwd: [PERFORM] wal_sync_methods for AIX JP Fletcher (Tue Feb 19 2008 - 15:21:16 EST)
1. patch (548 bytes)
Re: [PERFORM] 7 hrs for a pg_restore? Jeff Davis (Tue Feb 19 2008 - 14:51:19 EST)
1. signature.asc (188 bytes)
Re: [PERFORM] 7 hrs for a pg_restore? Douglas J Hunley (Tue Feb 19 2008 - 14:20:11 EST)
1. signature.asc (188 bytes)
Re: [PERFORM] 7 hrs for a pg_restore? Douglas J Hunley (Tue Feb 19 2008 - 14:08:23 EST)
1. signature.asc (188 bytes)
Re: [PERFORM] 7 hrs for a pg_restore? Douglas J Hunley (Tue Feb 19 2008 - 13:58:38 EST)
1. postgresql.conf (16563 bytes)
Re: [PERFORM] Controling where temporary files are created Albert Cervera Areny (Mon Feb 18 2008 - 10:50:41 EST)
1. signature.asc (188 bytes)
Re: [PERFORM] shared_buffers in 8.3 w/ lots of RAM on dedicated PG machine Peter Schuller (Mon Feb 18 2008 - 02:39:46 EST)
1. signature.asc (188 bytes)
2. signature.asc_ (188 bytes)
Re: [PERFORM] shared_buffers in 8.3 w/ lots of RAM on dedicated PG machine Peter Schuller (Fri Feb 15 2008 - 08:58:46 EST)
1. part (188 bytes)
[PERFORM] shared_buffers in 8.3 w/ lots of RAM on dedicated PG machine Peter Schuller (Fri Feb 15 2008 - 07:35:29 EST)
1. part (188 bytes)
Re: [PERFORM] Anyone using a SAN? Alex Deucher (Wed Feb 13 2008 - 12:58:03 EST)
1. signature.asc (188 bytes)
Re: [PERFORM] Dell Perc/6 Merlin Moncure (Wed Feb 13 2008 - 10:56:22 EST)
1. test4 (2473 bytes)
2. pgbench.7.4CVSHEAD.24.20 (2476 bytes)
Re: [PERFORM] Questions about enabling SSL fabrix peñuelas (Tue Feb 12 2008 - 12:46:52 EST)
1. part (253 bytes)
Re: [PERFORM] Questions about enabling SSL Michael Fuhr (Mon Feb 11 2008 - 19:37:51 EST)
1. explain.sql (12948 bytes)
Re: [PERFORM] Benchmark Data requested --- pgloader CE design ideas Mark Lewis (Thu Feb 07 2008 - 12:14:49 EST)
1. prob_query.sql (1206 bytes)
2. query-plan-without-sorting.sql (5123 bytes)
3. query-plan-with-sorting.sql (5637 bytes)
4. plan-without-sorting.sql (5100 bytes)
5. plan-with-sorting.sql (5614 bytes)
6. query.sql (291 bytes)
7. view.sql (1286 bytes)
Re: [PERFORM] Benchmark Data requested --- pgloader CE design ideas Dimitri Fontaine (Thu Feb 07 2008 - 04:31:47 EST)
1. signature.asc_ (190 bytes)
Re: [PERFORM] Benchmark Data requested --- pgloader CE design ideas Dimitri Fontaine (Wed Feb 06 2008 - 15:04:09 EST)
1. signature.asc_ (190 bytes)
Re: [PERFORM] Benchmark Data requested --- pgloader CE design ideas Dimitri Fontaine (Wed Feb 06 2008 - 14:59:04 EST)
1. signature.asc_ (190 bytes)
Re: [PERFORM] Benchmark Data requested --- pgloader CE design ideas Dimitri Fontaine (Wed Feb 06 2008 - 12:37:41 EST)
1. signature.asc_ (190 bytes)
Re: [PERFORM] Benchmark Data requested Dimitri Fontaine (Wed Feb 06 2008 - 12:31:48 EST)
1. signature.asc_ (190 bytes)
Re: [PERFORM] Benchmark Data requested --- pgloader CE design ideas Dimitri Fontaine (Wed Feb 06 2008 - 07:36:51 EST)
1. signature.asc_ (190 bytes)
Re: [PERFORM] Optimizer : query rewrite and execution plan ? Simon Riggs (Wed Feb 06 2008 - 06:53:46 EST)
1. insert.c (1450 bytes)
2. Results.zip (1069 bytes)
3. pgbenchmark.zip (20773 bytes)
Re: [PERFORM] Benchmark Data requested --- pgloader CE design ideas Dimitri Fontaine (Wed Feb 06 2008 - 06:27:56 EST)
1. signature.asc_ (190 bytes)
Re: [PERFORM] Benchmark Data requested Dimitri Fontaine (Wed Feb 06 2008 - 05:29:42 EST)
1. signature.asc_ (190 bytes)
Re: [PERFORM] Benchmark Data requested Heikki Linnakangas (Tue Feb 05 2008 - 15:06:17 EST)
1. signature.asc (188 bytes)
Re: [PERFORM] Benchmark Data requested Dimitri Fontaine (Tue Feb 05 2008 - 12:15:25 EST)
1. signature.asc_ (190 bytes)
Re: [PERFORM] Benchmark Data requested Dimitri Fontaine (Tue Feb 05 2008 - 12:01:50 EST)
1. signature.asc_ (190 bytes)
Re: [PERFORM] Benchmark Data requested Dimitri Fontaine (Tue Feb 05 2008 - 09:06:48 EST)
1. signature.asc_ (190 bytes)
Re: [PERFORM] Performance issue using Tsearch2 Ansgar -59cobalt- Wiechers (Tue Feb 05 2008 - 08:36:02 EST)
1. signature.asc (188 bytes)
Re: [PERFORM] Benchmark Data requested Claus Guttesen (Mon Feb 04 2008 - 13:50:46 EST)
1. signature.asc (188 bytes)
Re: [PERFORM] Storage space usage Decibel! (Sat Feb 02 2008 - 01:37:09 EST)
1. part (188 bytes)
Re: [PERFORM] planner chooses unoptimal plan on joins with complex key Tom Lane (Tue Jan 29 2008 - 16:59:44 EST)
1. expl_anlyze_nomergejoin_7.3.1.txt (4907 bytes)
2. expl_anlyze_nomergejoin_7.3.4.txt (5315 bytes)
Re: [PERFORM] Vacuum and FSM page size Decibel! (Wed Jan 23 2008 - 14:02:21 EST)
1. part (188 bytes)
Re: [PERFORM] Performance issues migrating from 743 to 826 Gregory Stark (Mon Jan 28 2008 - 07:41:03 EST)
1. perf_prob_live.txt (11361 bytes)
2. perf_prob_test.txt (11707 bytes)
Re: [PERFORM] Performance problems inside a stored procedure. Heikki Linnakangas (Mon Jan 28 2008 - 07:06:48 EST)
1. explain_analyze.txt (4221 bytes)
2. pg_stats.csv (11278 bytes)
Re: [PERFORM] Postgres 8.2 memory weirdness Tory M Blue (Mon Jan 28 2008 - 01:09:12 EST)
1. explain_after.txt (3505 bytes)
2. explain_before.txt (3488 bytes)
3. forex.sql (1707 bytes)
4. master_branch_descr.sql (5507 bytes)
5. master_fpp_values.sql (4164 bytes)
6. master_sku_descr.sql (3775 bytes)
7. number_of_rows.txt (480 bytes)
8. price_tmpl_det.sql (583 bytes)
9. sku_price.sql (2876 bytes)
10. sql_statement.sql (2079 bytes)
11. supplier_price.sql (1329 bytes)
Re: [PERFORM] 8.3rc1 Out of memory when performing update Stephen Denne (Sun Jan 27 2008 - 16:55:10 EST)
1. signature.asc (188 bytes)
Re: [PERFORM] Slow set-returning functions Dean Rasheed (Sun Jan 27 2008 - 12:29:34 EST)
1. signature.asc (188 bytes)
Re: [PERFORM] Making the most of memory? Scott Marlowe (Wed Jan 23 2008 - 00:20:43 EST)
1. smime.p7s (2310 bytes)
[PERFORM] Workaround for cross column stats dependency Guillaume Smet (Tue Jan 22 2008 - 19:57:07 EST)
1. model.gif (27819 bytes)
2. smime.p7s (2310 bytes)
Re: [PERFORM] strange pauses Decibel! (Mon Jan 21 2008 - 14:29:52 EST)
1. smime.p7s (2563 bytes)
Re: [PERFORM] not exists clause Guy Rouillier (Thu Jan 10 2008 - 23:00:23 EST)
1. signature.asc (188 bytes)
Re: [PERFORM] Performance of aggregates over set-returning functions Tom Lane (Tue Jan 08 2008 - 22:51:04 EST)
1. signature.asc (190 bytes)
Re: [PERFORM] Commit takes a long time. Simon Riggs (Fri Jan 04 2008 - 05:17:17 EST)
1. signature.asc (186 bytes)
[PERFORM] Commit takes a long time. Peter Childs (Thu Jan 03 2008 - 09:35:37 EST)
1. signature.asc (184 bytes)
Re: [PERFORM] More shared buffers causes lower performances Merlin Moncure (Sat Dec 29 2007 - 12:22:00 EST)
1. signature.asc (188 bytes)
Re: [PERFORM] More shared buffers causes lower performances Greg Smith (Thu Dec 27 2007 - 10:53:43 EST)
1. signature.asc (186 bytes)
Re: [PERFORM] With 4 disks should I go for RAID 5 or RAID 10 Bill Moran (Thu Dec 27 2007 - 08:50:09 EST)
1. signature.asc (184 bytes)
Re: [PERFORM] More shared buffers causes lower performances Devrim GÜNDÜZ (Wed Dec 26 2007 - 18:40:53 EST)
1. signature.asc (190 bytes)
Re: [PERFORM] pg_dump performance Heikki Linnakangas (Wed Dec 26 2007 - 16:35:59 EST)
1. signature.asc (188 bytes)
Re: [PERFORM] pg_dump performance Jared Mauch (Wed Dec 26 2007 - 15:58:44 EST)
1. signature.asc (188 bytes)
[PERFORM] pg_dump performance Jared Mauch (Wed Dec 26 2007 - 15:22:30 EST)
1. signature.asc (188 bytes)
Re: [PERFORM] More shared buffers causes lower performances Cédric Villemain (Wed Dec 26 2007 - 06:06:47 EST)
1. cedric.villemain.vcf (267 bytes)
Re: [PERFORM] viewing source code Joshua D. Drake (Thu Dec 20 2007 - 14:40:11 EST)
1. part (253 bytes)
Re: [PERFORM] viewing source code Alvaro Herrera (Thu Dec 20 2007 - 13:29:52 EST)
1. part (253 bytes)
Re: [PERFORM] Minimizing dead tuples caused by update triggers Dimitri Fontaine (Thu Dec 20 2007 - 06:14:34 EST)
1. signature.asc_ (190 bytes)
Re: [PERFORM] Minimizing dead tuples caused by update triggers Decibel! (Wed Dec 19 2007 - 20:54:12 EST)
1. smime.p7s (2563 bytes)
Re: [PERFORM] Dual core Opterons beating quad core Xeons? Decibel! (Wed Dec 19 2007 - 20:51:13 EST)
1. smime.p7s (2563 bytes)
Re: [PERFORM] Measuring table and index bloat Decibel! (Wed Dec 19 2007 - 20:45:25 EST)
1. smime.p7s (2563 bytes)
Re: [PERFORM] Dual core Opterons beating quad core Xeons? Gregory Stark (Wed Dec 19 2007 - 17:54:13 EST)
1. signature.asc (188 bytes)
Re: [PERFORM] Dual core Opterons beating quad core Xeons? CÃ©dric Villemain (Wed Dec 19 2007 - 07:41:56 EST)
1. cedric.villemain.vcf (278 bytes)
[PERFORM] Dual core Opterons beating quad core Xeons? Stuart Bishop (Wed Dec 19 2007 - 07:04:11 EST)
1. signature.asc (190 bytes)
Re: [PERFORM] Optimising a query Paul Lambert (Wed Dec 19 2007 - 01:46:35 EST)
1. part (253 bytes)
Re: [PERFORM] viewing source code Alvaro Herrera (Tue Dec 18 2007 - 13:26:49 EST)
1. part (198 bytes)
Re: [PERFORM] Limited performance on multi core server Matthew Lunnon (Wed Dec 12 2007 - 07:29:05 EST)
1. signature.asc (188 bytes)
Re: [PERFORM] Limited performance on multi core server Matthew Lunnon (Wed Dec 12 2007 - 06:12:42 EST)
1. signature.asc (188 bytes)
Re: [PERFORM] Limited performance on multi core server Matthew Lunnon (Wed Dec 12 2007 - 06:08:03 EST)
1. signature.asc (188 bytes)
Re: [PERFORM] Limited performance on multi core server Matthew Lunnon (Wed Dec 12 2007 - 06:06:19 EST)
1. signature.asc (188 bytes)
Re: [PERFORM] Limited performance on multi core server Claus Guttesen (Wed Dec 12 2007 - 05:48:31 EST)
1. signature.asc (188 bytes)
Re: [PERFORM] Limited performance on multi core server Claus Guttesen (Wed Dec 12 2007 - 05:45:24 EST)
1. signature.asc (188 bytes)
Re: [PERFORM] libgcc double-free, backend won't die Tom Lane (Tue Dec 11 2007 - 11:10:21 EST)
1. signature.asc (188 bytes)
[PERFORM] Is it spam or not? Manolo _ (Tue Dec 11 2007 - 08:23:31 EST)
1. captcha.gif (8224 bytes)
2. fundo.jpg (10233 bytes)
[PERFORM] Is it spam or not? Manolo _ (Tue Dec 11 2007 - 06:57:24 EST)
1. captcha.gif (8513 bytes)
2. fundo.jpg (10233 bytes)
Re: [PERFORM] TB-sized databases Robert Treat (Fri Dec 07 2007 - 12:45:08 EST)
1. postgresql.conf.sample.patch (1083 bytes)
2. initdb.patch (4481 bytes)
Re: [PERFORM] TB-sized databases Matthew (Thu Dec 06 2007 - 12:46:35 EST)
1. signature.asc (188 bytes)
Re: [PERFORM] TB-sized databases Decibel! (Wed Dec 05 2007 - 19:07:58 EST)
1. smime.p7s (2563 bytes)
Re: [PERFORM] autovacuum: recommended? Decibel! (Wed Dec 05 2007 - 18:55:12 EST)
1. signature.asc (188 bytes)
2. smime.p7s (2563 bytes)
Re: [PERFORM] Bad query plans for queries on partitioned table Julian Mehnle (Wed Dec 05 2007 - 06:26:56 EST)
1. signature.asc_ (190 bytes)
Re: [PERFORM] Bad query plans for queries on partitioned table Julian Mehnle (Tue Dec 04 2007 - 20:57:25 EST)
1. signature.asc_ (190 bytes)
Re: [PERFORM] RAID arrays and performance Mark Mielke (Tue Dec 04 2007 - 17:14:55 EST)
1. signature.asc (188 bytes)
Re: [PERFORM] Bad query plans for queries on partitioned table Julian Mehnle (Tue Dec 04 2007 - 15:27:01 EST)
1. signature.asc_ (190 bytes)
[PERFORM] Bad query plans for queries on partitioned table Julian Mehnle (Tue Dec 04 2007 - 14:44:08 EST)
1. signature.asc_ (190 bytes)
Re: [PERFORM] Bad query plans for queries on partitioned table Julian Mehnle (Tue Dec 04 2007 - 15:03:14 EST)
1. signature.asc (188 bytes)
2. signature.asc_ (190 bytes)
Re: [PERFORM] RAID arrays and performance Mark Mielke (Tue Dec 04 2007 - 11:11:28 EST)
1. signature.asc (188 bytes)
Re: [PERFORM] RAID arrays and performance Matthew (Tue Dec 04 2007 - 11:00:37 EST)
1. signature.asc (188 bytes)
Re: [PERFORM] RAID arrays and performance Matthew (Tue Dec 04 2007 - 10:21:45 EST)
1. signature.asc (188 bytes)
Re: [PERFORM] Training Recommendations Joshua D. Drake (Mon Dec 03 2007 - 18:50:27 EST)
1. part (203 bytes)
2. signature.asc (190 bytes)
Re: [PERFORM] Training Recommendations Paul Lindner (Mon Dec 03 2007 - 11:12:22 EST)
1. part (190 bytes)
[PERFORM] EXPLAIN ANALYZE time calculations Michael Glaesemann (Sun Dec 02 2007 - 19:28:15 EST)
1. signature.asc (188 bytes)
Re: [PERFORM] Dealing with big tables Mark Kirkwood (Sun Dec 02 2007 - 18:13:07 EST)
1. signature.asc (188 bytes)
Re: [PERFORM] PostgreSQL 8.2.5 slow performance on INSERT on Linux Pavel Stehule (Sun Dec 02 2007 - 16:46:25 EST)
1. vacuum.txt (14313 bytes)
[PERFORM] PostgreSQL 8.2.5 slow performance on INSERT on Linux Beyers Cronje (Sun Dec 02 2007 - 16:34:00 EST)
1. signature.asc (188 bytes)
Re: [PERFORM] Training Recommendations Usama Munir Dar (Sun Dec 02 2007 - 15:26:58 EST)
1. signature.asc (188 bytes)
Re: [PERFORM] Training Recommendations Guido Neitzer (Sun Dec 02 2007 - 12:32:19 EST)
1. postgresql.conf (5199 bytes)
Re: [PERFORM] TB-sized databases Russell Smith (Fri Nov 30 2007 - 01:41:53 EST)
1. part (190 bytes)
Re: [PERFORM] TB-sized databases Stephen Frost (Thu Nov 29 2007 - 11:42:53 EST)
1. signature.asc (190 bytes)
Re: [PERFORM] TB-sized databases Csaba Nagy (Wed Nov 28 2007 - 09:03:44 EST)
1. signature.asc (188 bytes)
Re: [PERFORM] TB-sized databases Gregory Stark (Wed Nov 28 2007 - 08:55:02 EST)
1. signature.asc (188 bytes)
Re: [PERFORM] GiST indexing tuples Gregory Stark (Wed Nov 28 2007 - 08:36:48 EST)
1. signature.asc (188 bytes)
Re: [PERFORM] GiST indexing tuples Matthew (Wed Nov 28 2007 - 08:08:04 EST)
1. signature.asc (188 bytes)
[PERFORM] Windows XP selects are very slow Shadkam Islam (Wed Nov 28 2007 - 04:30:55 EST)
1. signature.asc (188 bytes)
Re: [PERFORM] Query only slow on first run Steinar H. Gunderson (Tue Nov 27 2007 - 19:28:18 EST)
1. signature.asc (188 bytes)
Re: [PERFORM] TB-sized databases Peter Koczan (Tue Nov 27 2007 - 15:18:51 EST)
1. signature.asc (188 bytes)
Re: [PERFORM] Query only slow on first run Bill Moran (Tue Nov 27 2007 - 13:55:50 EST)
1. postgresql.conf (5208 bytes)
Re: [PERFORM] 8.1 planner problem ? Heikki Linnakangas (Tue Nov 27 2007 - 05:12:38 EST)
1. vacuum.txt (13895 bytes)
Re: [PERFORM] PostgreSQL performance on various distribution stock kernels Greg Smith (Mon Nov 26 2007 - 19:57:20 EST)
1. signature.asc (188 bytes)
Re: [PERFORM] PostgreSQL performance on various distribution stock kernels Scott Marlowe (Mon Nov 26 2007 - 18:06:39 EST)
1. signature.asc (188 bytes)
Re: [PERFORM] autovacuum: recommended? Decibel! (Sun Nov 18 2007 - 23:14:09 EST)
1. smime.p7s (2563 bytes)
Re: [PERFORM] autovacuum: recommended? Decibel! (Sun Nov 18 2007 - 23:11:15 EST)
1. smime.p7s (2563 bytes)
Re: [PERFORM] autovacuum: recommended? Decibel! (Sun Nov 18 2007 - 23:08:40 EST)
1. smime.p7s (2563 bytes)
Re: [PERFORM] PostgreSQL vs MySQL, and FreeBSD Ivan Voras (Wed Nov 14 2007 - 14:47:16 EST)
1. signature.asc (251 bytes)
Re: [PERFORM] autovacuum: recommended? hubert depesz lubaczewski (Fri Nov 16 2007 - 04:45:41 EST)
1. part (198 bytes)
[PERFORM] autovacuum: recommended? Gábor Farkas (Fri Nov 16 2007 - 04:40:43 EST)
1. signature.asc (190 bytes)
Re: [PERFORM] dell versus hp Jeff Trout (Thu Nov 15 2007 - 09:41:59 EST)
1. nestloop (8689 bytes)
Re: [PERFORM] dell versus hp Merlin Moncure (Wed Nov 14 2007 - 20:56:32 EST)
1. re_order_conf (2680 bytes)
Re: [PERFORM] Curious about dead rows. Andrew Sullivan (Wed Nov 14 2007 - 11:58:23 EST)
1. re_order_conf (2517 bytes)
Re: [PERFORM] Curious about dead rows. Trevor Talbot (Tue Nov 13 2007 - 18:59:19 EST)
1. signature.asc (188 bytes)
Re: [PERFORM] difference between a unique constraint and a unique index ??? Dave Cramer (Mon Nov 12 2007 - 13:32:34 EST)
1. signature.asc (188 bytes)
Re: [PERFORM] Need to run CLUSTER to keep performance Scott Marlowe (Mon Nov 12 2007 - 12:04:44 EST)
1. signature.asc (188 bytes)
Re: [PERFORM] Need to run CLUSTER to keep performance Heikki Linnakangas (Mon Nov 12 2007 - 12:01:19 EST)
1. signature.asc (188 bytes)
Re: [PERFORM] Need to run CLUSTER to keep performance Bill Moran (Mon Nov 12 2007 - 11:37:40 EST)
1. signature.asc (188 bytes)
Re: [PERFORM] Need to run CLUSTER to keep performance Scott Marlowe (Mon Nov 12 2007 - 11:35:52 EST)
1. signature.asc (188 bytes)
Re: [PERFORM] PostgreSQL vs MySQL, and FreeBSD Erik Jones (Mon Nov 12 2007 - 10:22:04 EST)
1. signature.asc (188 bytes)
Re: [PERFORM] PostgreSQL vs MySQL, and FreeBSD Joshua D. Drake (Sun Nov 11 2007 - 15:17:22 EST)
1. part (198 bytes)
Re: [PERFORM] Curious about dead rows. Tom Lane (Sat Nov 10 2007 - 12:08:11 EST)
1. signature.asc (190 bytes)
Re: [PERFORM] Estimation problem with a LIKE clause containing a / Guillaume Smet (Thu Nov 08 2007 - 10:29:34 EST)
1. signature.asc (188 bytes)
Re: [PERFORM] partitioned table and ORDER BY indexed_field DESC LIMIT 1 Mark Kirkwood (Wed Nov 07 2007 - 21:46:34 EST)
1. order-by-wip.patch.gz (11309 bytes)
Re: [PERFORM] Estimation problem with a LIKE clause containing a / Tom Lane (Wed Nov 07 2007 - 18:14:08 EST)
1. slow_and_ugly.zip (11633 bytes)
Re: [PERFORM] dell versus hp Dimitri Fontaine (Tue Nov 06 2007 - 10:18:51 EST)
1. signature.asc_ (190 bytes)
Re: [PERFORM] dell versus hp Stephen Frost (Tue Nov 06 2007 - 08:48:31 EST)
1. signature.asc (190 bytes)
Re: [PERFORM] dell versus hp Dimitri Fontaine (Tue Nov 06 2007 - 06:53:44 EST)
1. signature.asc_ (190 bytes)
[PERFORM] Is ANALYZE transactional? Craig James (Tue Nov 06 2007 - 00:12:37 EST)
1. signature.asc (188 bytes)
Re: [PERFORM] hardware and For PostgreSQL Joshua D. Drake (Wed Oct 31 2007 - 18:30:40 EDT)
1. signature.asc (190 bytes)
Re: [PERFORM] Outer joins and Seq scans Dimitri Fontaine (Mon Oct 29 2007 - 05:48:14 EDT)
1. signature.asc_ (190 bytes)
Re: [PERFORM] Suggestions on an update query Joshua D. Drake (Fri Oct 26 2007 - 22:31:11 EDT)
1. signature.asc (190 bytes)
Re: [PERFORM] [HACKERS] 8.3beta1 testing on Solaris Jignesh K. Shah (Fri Oct 26 2007 - 17:45:19 EDT)
1. mktestdb (1150 bytes)
Re: [PERFORM] Suggestions on an update query Joshua D. Drake (Fri Oct 26 2007 - 17:15:47 EDT)
1. signature.asc (190 bytes)
Re: [PERFORM] [HACKERS] 8.3beta1 testing on Solaris Jignesh K. Shah (Fri Oct 26 2007 - 12:46:14 EDT)
1. signature.asc (188 bytes)
Re: [PERFORM] 12 hour table vacuums Joshua D. Drake (Tue Oct 23 2007 - 13:41:13 EDT)
1. signature.asc (190 bytes)
Re: [PERFORM] 12 hour table vacuums Csaba Nagy (Tue Oct 23 2007 - 12:21:16 EDT)
1. NewQuery.txt (1860 bytes)
2. OldQuery.txt (1737 bytes)
Re: [PERFORM] need help with a query Pavel Velikhov (Tue Oct 23 2007 - 05:54:04 EDT)
1. szkb (10500 bytes)
Re: [PERFORM] [SQL] two queryes in a single tablescan Markus Schaber (Sat Oct 20 2007 - 06:58:24 EDT)
1. signature.asc (188 bytes)
Re: [PERFORM] Vacuum goes worse Joshua D. Drake (Tue Oct 16 2007 - 23:19:51 EDT)
1. signature.asc (190 bytes)
Re: [PERFORM] Autovacuum running out of memory Tom Lane (Tue Oct 16 2007 - 11:38:56 EDT)
1. signature.asc (190 bytes)
Re: [PERFORM] Autovacuum running out of memory Rodrigo Gonzalez (Tue Oct 16 2007 - 11:00:36 EDT)
1. smime.p7s (3245 bytes)
[PERFORM] Huge amount of memory consumed during transaction henk de wit (Thu Oct 11 2007 - 10:04:38 EDT)
1. signature.asc (190 bytes)
Re: [PERFORM] building a performance test suite Dimitri Fontaine (Thu Oct 11 2007 - 04:52:05 EDT)
1. signature.asc_ (190 bytes)
Re: [PERFORM] Apache2 PostgreSQL http authentication Jeffrey Brower (Sun Oct 07 2007 - 20:29:27 EDT)
1. part (233 bytes)
Re: [PERFORM] query plan worse after analyze Richard Broersma Jr (Sun Oct 07 2007 - 12:06:37 EDT)
1. part (233 bytes)
Re: [PERFORM] query plan worse after analyze Stephen Frost (Fri Oct 05 2007 - 23:14:38 EDT)
1. signature.asc (190 bytes)
Re: [PERFORM] [GENERAL] Slow TSearch2 performance for table with 1 million documents. Oleg Bartunov (Fri Oct 05 2007 - 11:32:32 EDT)
1. signature.asc (190 bytes)
Re: [PERFORM] quickly getting the top N rows Scott Marlowe (Thu Oct 04 2007 - 16:32:55 EDT)
1. signature.asc (190 bytes)
Re: [PERFORM] quickly getting the top N rows Bill Moran (Thu Oct 04 2007 - 14:14:11 EDT)
1. signature.asc (190 bytes)
[PERFORM] Query taking too long. Problem reading explain output. Henrik (Wed Oct 03 2007 - 04:03:53 EDT)
1. PGP.sig (195 bytes)
[PERFORM] Difference between Vacuum and Vacuum full Radhika S (Tue Oct 02 2007 - 21:45:37 EDT)
1. signature.asc (190 bytes)
Re: [PERFORM] performance of like queries Chris Browne (Tue Oct 02 2007 - 17:55:08 EDT)
1. signature.asc (190 bytes)
Re: [PERFORM] Linux mis-reporting memory Decibel! (Tue Oct 02 2007 - 18:17:53 EDT)
1. signature.asc (190 bytes)
[PERFORM] Non-blocking vacuum full Peter Schuller (Fri Sep 28 2007 - 14:06:50 EDT)
1. part (188 bytes)
Re: [PERFORM] Searching for the cause of a bad plan Csaba Nagy (Thu Sep 27 2007 - 11:16:06 EDT)
1. signature.asc (190 bytes)
Re: [PERFORM] Difference in query plan when using = or > in where clause Heikki Linnakangas (Thu Sep 27 2007 - 08:39:07 EDT)
1. signature.asc (190 bytes)
Re: [PERFORM] Searching for the cause of a bad plan Csaba Nagy (Thu Sep 27 2007 - 07:53:24 EDT)
1. table_a_counts.png (2466 bytes)
2. table_a_counts_histogram.png (3069 bytes)
Re: [PERFORM] Incorrect row estimates in plan? pgdba (Wed Sep 26 2007 - 12:56:33 EDT)
1. signature.asc (190 bytes)
Re: [PERFORM] Acceptable level of over-estimation? Gregory Stark (Mon Sep 24 2007 - 16:18:25 EDT)
1. NEW_plan.txt (2304 bytes)
Re: [PERFORM] REPOST: Nested loops row estimates always too high Carlo Stonebanks (Mon Sep 24 2007 - 14:12:01 EDT)
1. TOMs_plan.txt (1860 bytes)
2. UNION_ALL_plan.txt (2198 bytes)
Re: [PERFORM] select count(*) performance (vacuum did not help) Csaba Nagy (Mon Sep 24 2007 - 11:34:16 EDT)
1. plan.txt (2078 bytes)
Re: [PERFORM] select count(*) performance (vacuum did not help) Gábor Farkas (Mon Sep 24 2007 - 11:14:27 EDT)
1. plan.txt (1377 bytes)
2. schemas.txt (5006 bytes)
Re: [PERFORM] Query planner unaware of possibly best plan Denes Daniel (Sat Sep 22 2007 - 08:33:21 EDT)
1. expana.txt (2619 bytes)
Re: [PERFORM] Low CPU Usage brauagustin-susc(at)yahoo.com.ar (Fri Sep 21 2007 - 17:45:27 EDT)
1. postgresql.conf (5409 bytes)
2. VACVERB (2083 bytes)
Re: [PERFORM] Query planner unaware of possibly best plan Denes Daniel (Fri Sep 21 2007 - 16:05:29 EDT)
1. expana.txt (1002 bytes)
Re: [PERFORM] Upgraded from 7.4 to 8.1.4 QUERIES NOW SLOW!!! db(at)zigo.dhs.org (Fri Sep 21 2007 - 01:58:27 EDT)
1. signature.asc (188 bytes)
Re: [PERFORM] Upgraded from 7.4 to 8.1.4 QUERIES NOW SLOW!!! Scott Marlowe (Thu Sep 20 2007 - 20:52:52 EDT)
1. signature.asc (188 bytes)
[PERFORM] Linux mis-reporting memory Decibel! (Thu Sep 20 2007 - 19:04:01 EDT)
1. part (188 bytes)
Re: [PERFORM] Low CPU Usage brauagustin-susc(at)yahoo.com.ar (Wed Sep 19 2007 - 15:52:43 EDT)
1. dmesg (14553 bytes)
Re: [PERFORM] Low CPU Usage Scott Marlowe (Wed Sep 19 2007 - 15:41:45 EDT)
1. part (203 bytes)
[PERFORM] Low CPU Usage brauagustin-susc(at)yahoo.com.ar (Wed Sep 19 2007 - 13:38:13 EDT)
1. part (203 bytes)
R: [PERFORM] R: DELETE queries slow down Galantucci Giovanni (Wed Sep 19 2007 - 05:46:48 EDT)
1. part (203 bytes)
[PERFORM] Nested loops row estimates always too high Carlo Stonebanks (Tue Sep 18 2007 - 16:07:33 EDT)
1. signature.asc (188 bytes)
Re: [PERFORM] [Again] Postgres performance problem Decibel! (Mon Sep 17 2007 - 08:27:39 EDT)
1. part (188 bytes)
Re: [PERFORM] [Again] Postgres performance problem Decibel! (Mon Sep 17 2007 - 08:24:14 EDT)
1. part (188 bytes)
Re: [PERFORM] [Again] Postgres performance problem Ruben Rubio (Mon Sep 17 2007 - 08:00:59 EDT)
1. signature.asc (188 bytes)
2. ruben.vcf (247 bytes)
Re: [PERFORM] random_page_costs - are defaults of 4.0 realistic for SCSI RAID 1 Decibel! (Tue Sep 11 2007 - 19:49:41 EDT)
1. part (188 bytes)
Re: [PERFORM] SAN vs Internal Disks Decibel! (Tue Sep 11 2007 - 19:07:44 EDT)
1. part (188 bytes)
Re: [PERFORM] More Vacuum questions... Decibel! (Tue Sep 11 2007 - 19:04:21 EDT)
1. part (188 bytes)
Re: [PERFORM] Barcelona vs Tigerton Decibel! (Tue Sep 11 2007 - 19:00:22 EDT)
1. part (188 bytes)
Re: [PERFORM] [Again] Postgres performance problem Decibel! (Tue Sep 11 2007 - 18:52:42 EDT)
1. part (188 bytes)
Re: [PERFORM] random_page_costs - are defaults of 4.0 realistic for SCSI RAID 1 Decibel! (Tue Sep 11 2007 - 17:31:05 EDT)
1. signature.asc (188 bytes)
2. part (188 bytes)
Re: [PERFORM] random_page_costs - are defaults of 4.0 realistic for SCSI RAID 1 Decibel! (Tue Sep 11 2007 - 17:26:34 EDT)
1. part (188 bytes)
Re: [PERFORM] DRBD and Postgres: how to improve the perfomance? Decibel! (Tue Sep 11 2007 - 17:22:02 EDT)
1. part (188 bytes)
Re: [PERFORM] DRBD and Postgres: how to improve the perfomance? Decibel! (Tue Sep 11 2007 - 17:20:15 EDT)
1. part (188 bytes)
Re: [PERFORM] DRBD and Postgres: how to improve the perfomance? Decibel! (Tue Sep 11 2007 - 17:12:33 EDT)
1. part (188 bytes)
Re: [PERFORM] SAN vs Internal Disks Decibel! (Tue Sep 11 2007 - 16:55:51 EDT)
1. part (188 bytes)
Re: [PERFORM] Hardware spec Decibel! (Tue Sep 11 2007 - 16:35:55 EDT)
1. part (188 bytes)
Re: [PERFORM] Performance on 8CPU's and 32GB of RAM Decibel! (Tue Sep 11 2007 - 16:32:42 EDT)
1. part (188 bytes)
Re: [PERFORM] DRBD and Postgres: how to improve the perfomance? Maila Fatticcioni (Tue Sep 11 2007 - 10:47:40 EDT)
1. signature.asc (253 bytes)
Re: [PERFORM] [Again] Postgres performance problem Ruben Rubio (Tue Sep 11 2007 - 03:49:37 EDT)
1. ruben.vcf (247 bytes)
[PERFORM] [Again] Postgres performance problem Ruben Rubio (Tue Sep 11 2007 - 02:33:47 EDT)
1. ruben.vcf (247 bytes)
[PERFORM] DRBD and Postgres: how to improve the perfomance? Maila Fatticcioni (Fri Sep 07 2007 - 05:37:40 EDT)
1. signature.asc (253 bytes)
Re: [PERFORM] SAN vs Internal Disks Scott Marlowe (Thu Sep 06 2007 - 14:42:41 EDT)
1. smime.p7m (4778 bytes)
Re: [PERFORM] utilising multi-cpu/core machines? Kevin Grittner (Thu Sep 06 2007 - 09:46:40 EDT)
1. smime.p7m (13091 bytes)
Re: [PERFORM] Hardware spec Jean-David Beyer (Thu Sep 06 2007 - 07:16:00 EDT)
1. PostgreSQL_Benchmarking.sxc (16981 bytes)
2. select.gif (6816 bytes)
3. tpcb.gif (8382 bytes)
Re: [PERFORM] Performance on 8CPU's and 32GB of RAM Scott Marlowe (Tue Sep 04 2007 - 19:03:11 EDT)
1. signature.asc (188 bytes)
Re: [PERFORM] [Solved] Postgres performance problem Decibel! (Thu Aug 30 2007 - 13:31:51 EDT)
1. part (188 bytes)
Re: [PERFORM] [Solved] Postgres performance problem Ruben Rubio (Thu Aug 30 2007 - 05:50:04 EDT)
1. ruben.vcf (247 bytes)
Re: [PERFORM] io storm on checkpoints, postgresql 8.2.4, linux Decibel! (Tue Aug 28 2007 - 17:34:04 EDT)
1. part (188 bytes)
Re: Fwd: [PERFORM] 8.2 Query 10 times slower than 8.1 (view-heavy) Mark Lewis (Tue Aug 28 2007 - 12:51:31 EDT)
1. signature.asc (188 bytes)
Re: [PERFORM] server performance issues - suggestions for tuning Andrew Sullivan (Tue Aug 28 2007 - 10:26:52 EDT)
1. signature.asc (188 bytes)
Re: [PERFORM] partitioned table and ORDER BY indexed_field DESC LIMIT 1 Heikki Linnakangas (Tue Aug 28 2007 - 06:20:16 EDT)
1. signature.asc (188 bytes)
Re: [PERFORM] significant vacuum issues - looking for suggestions Decibel! (Mon Aug 27 2007 - 18:04:39 EDT)
1. part (188 bytes)
Re: [PERFORM] significant vacuum issues - looking for suggestions Decibel! (Mon Aug 27 2007 - 17:00:41 EDT)
1. part (188 bytes)
Re: [PERFORM] asynchronous commit feature Decibel! (Mon Aug 27 2007 - 16:11:38 EDT)
1. part (188 bytes)
[PERFORM] Postgres performance problem Ruben Rubio (Mon Aug 27 2007 - 07:41:45 EDT)
1. ruben.vcf (247 bytes)
Re: [PERFORM] [GENERAL] Shared memory usage Martijn van Oosterhout (Sat Aug 25 2007 - 16:39:52 EDT)
1. signature.asc (190 bytes)
Re: [GENERAL] [PERFORM] Partioning tsearch2 a table into chunks and accessing via views Erik Jones (Sat Aug 25 2007 - 16:09:01 EDT)
1. signature.asc (188 bytes)
Re: [PERFORM] Installing PostgreSQL Campbell, Lance (Thu Aug 23 2007 - 13:37:51 EDT)
1. signature.asc (194 bytes)
Re: [PERFORM] io storm on checkpoints, postgresql 8.2.4, linux Dmitry Potapov (Thu Aug 23 2007 - 10:37:39 EDT)
1. signature.asc (188 bytes)
Re: [PERFORM] Optimising "in" queries Michael Glaesemann (Wed Aug 22 2007 - 20:21:05 EDT)
1. signature.asc (194 bytes)
Re: [PERFORM] Long running transaction in pg_activity_log Farhan Mughal (Wed Aug 22 2007 - 17:58:40 EDT)
1. signature.asc (188 bytes)
Re: [PERFORM] io storm on checkpoints, postgresql 8.2.4, linux Dmitry Potapov (Wed Aug 22 2007 - 12:28:00 EDT)
1. perftest.tar.gz (5052 bytes)
Re: [PERFORM] Integrated perc 5/i Luke Lonergan (Thu Aug 16 2007 - 21:12:49 EDT)
1. signature.asc (188 bytes)
Re: [PERFORM] Integrated perc 5/i Decibel! (Thu Aug 16 2007 - 18:41:00 EDT)
1. part (188 bytes)
Re: [PERFORM] Integrated perc 5/i Decibel! (Thu Aug 16 2007 - 15:51:10 EDT)
1. part (188 bytes)
Re: [PERFORM] RAID 10 or RAID 10 + RAID 1 Decibel! (Tue Aug 14 2007 - 17:31:50 EDT)
1. part (188 bytes)
Re: [PERFORM] [HACKERS] Proposal: Pluggable Optimizer Interface Tom Lane (Mon Aug 13 2007 - 19:18:41 EDT)
1. signature.asc (188 bytes)
Re: [PERFORM] [HACKERS] Proposal: Pluggable Optimizer Interface Stefan Kaltenbrunner (Mon Aug 13 2007 - 16:20:35 EDT)
1. signature.asc (188 bytes)
Re: [PERFORM] Dell Hardware Recommendations Decibel! (Fri Aug 10 2007 - 00:58:58 EDT)
1. part (188 bytes)
Re: [PERFORM] Dell Hardware Recommendations Decibel! (Thu Aug 09 2007 - 18:05:02 EDT)
1. part (188 bytes)
2. signature.asc_ (190 bytes)
3. indextest.sql (21264 bytes)
4. profiling-v2.patch.gz (2394 bytes)
5. clog_buffers.v1.test.patch (703 bytes)
6. remove_commit_delay.v1.test.patch (851 bytes)
Re: [PERFORM] Dell Hardware Recommendations Decibel! (Thu Aug 09 2007 - 17:15:53 EDT)
1. part (188 bytes)
Re: [PERFORM] Update table performance Decibel! (Thu Aug 09 2007 - 11:32:15 EDT)
1. part (188 bytes)
Re: [PERFORM] When/if to Reindex Decibel! (Wed Aug 08 2007 - 16:35:54 EDT)
1. part (188 bytes)
Re: [PERFORM] How to ENABLE SQL capturing??? Steinar H. Gunderson (Wed Aug 08 2007 - 16:36:12 EDT)
1. signature.asc (188 bytes)
Re: [PERFORM] Update table performance Decibel! (Wed Aug 08 2007 - 13:28:14 EDT)
1. part (188 bytes)
Re: [PERFORM] Update table performance Heikki Linnakangas (Wed Aug 08 2007 - 04:00:48 EDT)
1. querystats_on_7.2.3 (2139 bytes)
Re: [PERFORM] Update table performance Mark Makarowsky (Tue Aug 07 2007 - 19:13:00 EDT)
1. query_stats (2229 bytes)
Re: [PERFORM] Update table performance Decibel! (Tue Aug 07 2007 - 17:42:28 EDT)
1. part (188 bytes)
Re: [PERFORM] Update table performance Decibel! (Tue Aug 07 2007 - 13:59:14 EDT)
1. part (188 bytes)
Re: [PERFORM] TRUNCATE TABLE Decibel! (Mon Aug 06 2007 - 01:48:54 EDT)
1. part (188 bytes)
Re: [PERFORM] cpu throttling Decibel! (Fri Aug 03 2007 - 18:17:42 EDT)
1. part (188 bytes)
Re: [PERFORM] Questions on Tags table schema Jay Kang (Mon Jul 30 2007 - 06:13:19 EDT)
1. cpu.png (28807 bytes)
Re: [PERFORM] Questions on Tags table schema Richard Huxton (Mon Jul 30 2007 - 03:21:34 EDT)
1. cpu.png (28807 bytes)
Re: RES: RES: [PERFORM] select on 1milion register = 6s Decibel! (Mon Jul 30 2007 - 02:52:41 EDT)
1. part (188 bytes)
Re: RES: RES: [PERFORM] select on 1milion register = 6s Decibel! (Sun Jul 29 2007 - 21:29:26 EDT)
1. part (188 bytes)
Re: RES: [PERFORM] select on 1milion register = 6s Decibel! (Sun Jul 29 2007 - 12:35:37 EDT)
1. part (188 bytes)
Re: [PERFORM] Vacuum looping? Jim C. Nasby (Sat Jul 28 2007 - 12:36:24 EDT)
1. part (188 bytes)
Re: [PERFORM] User concurrency thresholding: where do I look? Simon Riggs (Fri Jul 27 2007 - 05:15:27 EDT)
1. remove_commit_delay.v1.test.patch (851 bytes)
Re: [PERFORM] User concurrency thresholding: where do I look? Simon Riggs (Thu Jul 26 2007 - 11:51:16 EDT)
1. clog_buffers.v1.test.patch (703 bytes)
Re: [PERFORM] Insert Statements Hanging Alan Hodgson (Wed Jul 25 2007 - 16:55:13 EDT)
1. signature.asc (188 bytes)
Re: [PERFORM] Simple select hangs while CPU close to 100% Jozsef Szalay (Wed Jul 25 2007 - 13:51:39 EDT)
1. part (190 bytes)
Re: [pgsql-advocacy] [PERFORM] 8.2 -> 8.3 performance numbers Gregory Stark (Wed Jul 25 2007 - 10:43:29 EDT)
1. profiling-v2.patch.gz (2394 bytes)
Re: [PERFORM] Performance issue with 8.2.3 - "C" application Tom Lane (Tue Jul 24 2007 - 22:45:58 EDT)
1. signature.asc (188 bytes)
[PERFORM] Performance issue with 8.2.3 - "C" application Karl Denninger (Tue Jul 24 2007 - 21:20:09 EDT)
1. signature.asc (321 bytes)
[PERFORM] Query performance issue Jonathan Gray (Tue Jul 24 2007 - 03:48:07 EDT)
1. indextest.sql (21264 bytes)
Re: [PERFORM] User concurrency thresholding: where do I look? Simon Riggs (Mon Jul 23 2007 - 13:50:53 EDT)
1. signature.asc (188 bytes)
Re: [PERFORM] disable archiving Arjen van der Meijden (Mon Jul 23 2007 - 13:39:10 EDT)
1. signature.asc (188 bytes)
Re: [PERFORM] User concurrency thresholding: where do I look? Simon Riggs (Mon Jul 23 2007 - 11:47:43 EDT)
1. signature.asc (188 bytes)
Re: [PERFORM] User concurrency thresholding: where do I look? Alvaro Herrera (Thu Jul 19 2007 - 13:37:04 EDT)
1. signature.asc (188 bytes)
Re: [GENERAL] [PERFORM] Parrallel query execution for UNION ALL Queries Dimitri Fontaine (Thu Jul 19 2007 - 06:14:29 EDT)
1. signature.asc_ (190 bytes)
Re: [PERFORM] When/if to Reindex Jim C. Nasby (Wed Jul 18 2007 - 14:52:51 EDT)
1. part (188 bytes)
Re: [PERFORM] Parrallel query execution for UNION ALL Queries Jim C. Nasby (Wed Jul 18 2007 - 14:50:07 EDT)
1. part (188 bytes)
Re: [PERFORM] ionice to make vacuum friendier? Jim C. Nasby (Wed Jul 18 2007 - 14:48:16 EDT)
1. part (188 bytes)
Re: [PERFORM] Postgres configuration for 64 CPUs, 128 GB RAM... Jim C. Nasby (Tue Jul 17 2007 - 11:48:00 EDT)
1. part (188 bytes)
Re: [PERFORM] TRUNCATE TABLE Jim C. Nasby (Mon Jul 16 2007 - 17:39:45 EDT)
1. part (188 bytes)
Re: [PERFORM] FORGOT TO CONFIGURE RAID! DELL POWEREDGE 2950 Jim C. Nasby (Mon Jul 16 2007 - 17:02:11 EDT)
1. part (188 bytes)
Re: [PERFORM] TRUNCATE TABLE Jim C. Nasby (Fri Jul 13 2007 - 13:12:47 EDT)
1. part (188 bytes)
Re: [PERFORM] one column from huge view Heikki Linnakangas (Thu Jul 12 2007 - 08:55:43 EDT)
1. 8859-15 (4357 bytes)
Re: [PERFORM] PostgreSQL publishes first real benchmark Jim C. Nasby (Mon Jul 09 2007 - 16:53:08 EDT)
1. part (188 bytes)
Re: [PERFORM] Filesystem Direct I/O and WAL sync option Jim C. Nasby (Mon Jul 09 2007 - 16:32:20 EDT)
1. part (188 bytes)
Re: [PERFORM] Stephen Frost (Mon Jun 25 2007 - 20:33:39 EDT)
1. signature.asc (190 bytes)
Re: [PERFORM] Stephen Frost (Mon Jun 25 2007 - 19:52:09 EDT)
1. signature.asc (190 bytes)
Re: [PERFORM] Stephen Frost (Mon Jun 25 2007 - 17:56:54 EDT)
1. signature.asc (190 bytes)
Re: [PERFORM] PITR Backups Dan Gorman (Mon Jun 25 2007 - 13:10:55 EDT)
1. postgresql.conf (13356 bytes)
Re: [PERFORM] PITR Backups Gregory Stark (Mon Jun 25 2007 - 12:02:53 EDT)
1. fixcharNN.sql.in (3432 bytes)
2. Makefile (491 bytes)
3. fixcharNN.c.in (1409 bytes)
4. README.fixchar (2743 bytes)
Re: [PERFORM] Very long SQL strings Chris Browne (Thu Jun 21 2007 - 15:52:24 EDT)
1. signature.asc (190 bytes)
Re: [PERFORM] Database-wide VACUUM ANALYZE Larry Rosenman (Thu Jun 21 2007 - 15:59:53 EDT)
1. signature.asc (190 bytes)
Re: [PERFORM] Performance query about large tables, lots of concurrent access Michael Stone (Wed Jun 20 2007 - 14:08:55 EDT)
1. part (1117 bytes)
2. image001.jpg (2373 bytes)
3. smime.p7s (5192 bytes)
4. plan_earthdistance_nestedloop.txt (2602 bytes)
5. plan_earthdistance_hash.txt (3001 bytes)
6. signature.asc (251 bytes)
7. vCard.VCF (378 bytes)
8. part (1199 bytes)
9. part (1761 bytes)
10. postgresql.conf (14035 bytes)
11. plan.txt (2393 bytes)
12. pg_vacuum.patch (2555 bytes)
13. postgresql.conf.v7 (8247 bytes)
14. postgresql.conf.v8 (15543 bytes)
15. tandrews.vcf (343 bytes)
16. explain1 (11049 bytes)
17. explain2 (6828 bytes)
Re: [PERFORM] Performance query about large tables, lots of concurrent access Karl Wright (Wed Jun 20 2007 - 14:03:28 EDT)
1. signature.asc (190 bytes)
2. part (188 bytes)
3. tandrews.vcf (343 bytes)
Re: [GENERAL] [pgsql-advocacy] [PERFORM] [ADMIN] Postgres VS Oracle Andrew Sullivan (Mon Jun 18 2007 - 14:09:28 EDT)
1. part (188 bytes)
2. check.py (490 bytes)
3. postgresql.conf (13859 bytes)
4. signature.asc_ (190 bytes)
5. james.vcf (393 bytes)
Re: [PERFORM] dbt2 NOTPM numbers Heikki Linnakangas (Mon Jun 04 2007 - 16:22:35 EDT)
1. part (188 bytes)

Last message date: Fri Jul 04 2008 - 11:48:55 EDT
Archived on: Thu Jul 31 2008 - 17:16:55 EDT

4239 messages sort by: [ thread ] [ author ] [ date ] [ subject ]

This archive was generated by hypermail 2.1.8 : Thu Jul 31 2008 - 17:16:55 EDT