Lukas Fittl lfittl
lfittl
/ gist:180403
Created
September 3, 2009 17:17
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| Table "public.posts" | |
| Column | Type | Modifiers | |
| ---------------------+--------------------------+---------------------------------------------------- | |
| id | bigint | not null default nextval('posts_id_seq'::regclass) | |
| created_at | timestamp with time zone | not null default now() | |
| updated_at | timestamp with time zone | | |
| type | post_type | | |
| deleted | boolean | not null default false | |
| blog_id | bigint | | |
| author_id | integer | |
lfittl
/ EXPLAIN ANALYZE
Created
September 3, 2009 10:16
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| Limit (cost=14447.11..14447.21 rows=40 width=16) (actual time=3.157..3.173 rows=40 loops=1) | |
| -> Sort (cost=14447.11..14456.04 rows=3573 width=16) (actual time=3.155..3.163 rows=40 loops=1) | |
| Sort Key: created_at, id | |
| Sort Method: top-N heapsort Memory: 26kB | |
| -> Bitmap Heap Scan on posts (cost=619.31..14334.17 rows=3573 width=16) (actual time=1.325..2.573 rows=776 loops=1) | |
| Recheck Cond: (blog_id = ANY ('{134368,136333,136043,134837,144282,142198,134939,140991,134222,134158,142307,142012,142154,140746,140586,137319,138615,140870,138400,140353,134166,140437,138984,139962,139804,136704,134196,138305,135312,137821,136401,138154,135297,138358,135028,137449,134756,135892,138312,134105,135529,137476,137521,136381,136005,134700,134288,134263,136394,135117,134938,137192,134630,136807,136787,135505,136589,134209,135420,135010,134165,134541,135575,135987,134243,136687,134220,134225,134219,134267,134283,135877,134951,134955,135315,134163,134237,134320,134890,134119,136390,13 |
lfittl
/ gist:179620
Created
September 2, 2009 09:14
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| Limit (cost=0.00..177216.77 rows=40 width=16) | |
| -> Index Scan Backward using posts_for_friendposts on posts (cost=0.00..418196124.71 rows=94392 width=16) | |
| Filter: ((NOT deleted) AND (blog_id = ANY ('{134368,136333,136043,134837,144282,142198,134939,140991,134222,134158,142307,142012,142154,140746,140586,137319,138615,140870,138400,140353,134166,140437,138984,139962,139804,136704,134196,138305,135312,137821,136401,138154,135297,138358,135028,137449,134756,135892,138312,134105,135529,137476,137521,136381,136005,134700,134288,134263,136394,135117,134938,137192,134630,136807,136787,135505,136589,134209,135420,135010,134165,134541,135575,135987,134243,136687,134220,134225,134219,134267,134283,135877,134951,134955,135315,134163,134237,134320,134890,134119,136390,136406,134128,136332,135851,134162,134112,134124,136379,136359,134109,134156,135989,134239,136229,135278,136393,134327,136403,136342,134136,136395,134968,134134,136405,136188,134922,134101,135030,134104,134576,134121,134157,135216,123374,136106, |
lfittl
/ 0. BIOS Settings
Created
August 31, 2009 10:14
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| Go to "Advanced => IDE Configuration" | |
| Set "Configure SATA as:" to "AHCI" (was "IDE") | |
| (This is for DL160 G5, it's named differently with the G6. But just remember: We want AHCI, nothing else.) |
lfittl
/ gist:177918
Created
August 30, 2009 10:09
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| soup_production=# EXPLAIN ANALYZE SELECT posts.id, created_at FROM posts WHERE posts.blog_id = 2 AND LANGUAGE IS NOT NULL AND NOT posts.deleted AND feed_id IS NULL AND TRUE ORDER BY posts.created_at DESC, posts.id DESC LIMIT 40; | |
| QUERY PLAN | |
| ------------------------------------------------------------------------------------------------------------------------------------------------ | |
| Limit (cost=155.67..155.69 rows=37 width=16) (actual time=3747.996..3748.007 rows=40 loops=1) | |
| -> Sort (cost=155.67..155.69 rows=37 width=16) (actual time=3747.994..3747.999 rows=40 loops=1) | |
| Sort Key: created_at, id | |
| Sort Method: top-N heapsort Memory: 26kB | |
| -> Index Scan using posts_lastfm_check on posts (cost=0.00..155.48 rows=37 width=16) (actual time=18.383..3747.373 rows=496 loops=1) | |
| Index Cond: ((feed_id IS NULL) AND (blog_id = 2)) | |
lfittl
/ gist:177893
Created
August 30, 2009 06:43
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| 02:57:15 automatic analyze of table "soup_production.public.feeds" system usage: CPU 0.02s/2.69u sec | |
| 02:59:13 automatic analyze of table "soup_production.public.feeds" system usage: CPU 0.10s/2.68u sec | |
| 03:00:11 automatic vacuum of table "soup_production.public.feeds": index scans: 0 | |
| pages: 0 removed, 20532 remain | |
| tuples: 0 removed, 62810 remain | |
| system usage: CPU 0.01s/0.00u sec elapsed 3.72 sec | |
| 03:00:11 automatic vacuum of table "soup_production.pg_toast.pg_toast_3170179": index scans: 0 | |
| pages: 0 removed, 0 remain | |
| tuples: 0 removed, 0 remain | |
| system usage: CPU 0.00s/0.00u sec elapsed 0.00 sec |
lfittl
/ gist:177302
Created
August 28, 2009 22:35
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| soup_production=> \d posts | |
| Table "public.posts" | |
| Column | Type | Modifiers | |
| ---------------------+--------------------------+---------------------------------------------------- | |
| id | bigint | not null default nextval('posts_id_seq'::regclass) | |
| created_at | timestamp with time zone | not null default now() | |
| updated_at | timestamp with time zone | | |
| type | post_type | | |
| deleted | boolean | not null default false | |
| blog_id | bigint | |
lfittl
/ gist:177291
Created
August 28, 2009 22:07
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| attributes | 14 GB | pg_toast_168091 | 168091 | r | 48634464 | 1781955 | |
| posts | 6718 MB | pg_toast_168177 | 168177 | r | 24378582 | 859850 | |
| posts_for_friendposts | 2676 MB | | 319845 | i | 24378582 | 342577 | |
| posts_lastfm_check | 2663 MB | | 319848 | i | 23622196 | 340821 | |
| index_attributes_on_post_id_and_type | 2630 MB | | 319833 | i | 48634464 | 336678 | |
| posts_for_one_soup | 2608 MB | | 319846 | i | 24378582 | 333769 | |
| posts_source | 2478 MB | | 3163105 | i | 24378582 | 317176 | |
| posts_guid | 2175 |
lfittl
/ gist:177281
Created
August 28, 2009 21:39
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| Table "public.feeds" | |
| Column | Type | Modifiers | |
| -------------------------+--------------------------+---------------------------------------------------- | |
| id | bigint | not null default nextval('feeds_id_seq'::regclass) | |
| url | character varying(2048) | default NULL::character varying | |
| name | character varying(255) | default NULL::character varying | |
| imported_at | timestamp with time zone | | |
| blog_id | bigint | | |
| humane_url | character varying(2048) | default NULL::character varying | |
| type | character varying(255) | default NULL::character varying |
lfittl
/ gist:177265
Created
August 28, 2009 21:29
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| Aug 28 20:00:29 192.168.96.40 postgres-master[30672]: [3-1] 2009-08-28 20:00:29 UTC LOG: automatic vacuum of table "soup_production.public.feeds": index scans: 1 | |
| Aug 28 20:00:29 192.168.96.40 postgres-master[30672]: [3-2] pages: 0 removed, 132742 remain | |
| Aug 28 20:00:29 192.168.96.40 postgres-master[30672]: [3-3] tuples: 701 removed, 64714 remain | |
| Aug 28 20:00:29 192.168.96.40 postgres-master[30672]: [3-4] system usage: CPU 0.76s/0.42u sec elapsed 456.48 sec | |
| Aug 28 20:00:29 192.168.96.40 postgres-master[30672]: [4-1] 2009-08-28 20:00:29 UTC LOG: automatic vacuum of table "soup_production.pg_toast.pg_toast_168147": index scans: 0 | |
| Aug 28 20:00:29 192.168.96.40 postgres-master[30672]: [4-2] pages: 0 removed, 0 remain | |
| Aug 28 20:00:29 192.168.96.40 postgres-master[30672]: [4-3] tuples: 0 removed, 0 remain | |
| Aug 28 20:00:29 192.168.96.40 postgres-master[30672]: [4-4] system usage: CPU 0.00s/0.00u sec elapsed 0.00 sec | |
| Aug 28 20:01:38 192.168.96.40 postgres-master[30672]: [5-1] 2009-08-28 20:01: |