Re: Inserting 8MB bytea: just 25% of disk perf used?

From:	Pierre Frédéric Caillaud <lists(at)peufeu(dot)com>
To:	"Magnus Hagander" <magnus(at)hagander(dot)net>
Cc:	"fkater(at)googlemail(dot)com" <fkater(at)googlemail(dot)com>, pgsql-performance <pgsql-performance(at)postgresql(dot)org>
Subject:	Re: Inserting 8MB bytea: just 25% of disk perf used?
Date:	2010-01-15 09:50:42
Message-ID:	op.u6kiysq3cke6l8@soyouz
Views:	Raw Message | Whole Thread | Download mbox | Resend email
Thread:	2010-01-14 14:29:03 from "fkater(at)googlemail(dot)com" <fkater(at)googlemail(dot)com>  2010-01-14 14:49:16 from Ivan Voras <ivoras(at)freebsd(dot)org>   2010-01-14 20:09:57 from "fkater(at)googlemail(dot)com" <fkater(at)googlemail(dot)com>  2010-01-14 15:04:02 from Matthew Wakeling <matthew(at)flymine(dot)org>   2010-01-14 20:18:54 from "fkater(at)googlemail(dot)com" <fkater(at)googlemail(dot)com>    2010-01-15 11:09:13 from Matthew Wakeling <matthew(at)flymine(dot)org>   2010-01-18 16:13:15 from "fkater(at)googlemail(dot)com" <fkater(at)googlemail(dot)com>   2010-01-21 16:24:12 from Florian Weimer <fweimer(at)bfk(dot)de>  2010-01-14 15:07:35 from Aidan Van Dyk <aidan(at)highrise(dot)ca>   2010-01-14 21:23:07 from "fkater(at)googlemail(dot)com" <fkater(at)googlemail(dot)com>    2010-01-14 21:33:11 from "Fernando Hevia" <fhevia(at)ip-tel(dot)com(dot)ar>    2010-01-15 11:25:51 from Matthew Wakeling <matthew(at)flymine(dot)org>     2010-01-15 20:34:03 from "fkater(at)googlemail(dot)com" <fkater(at)googlemail(dot)com>      2010-01-16 23:23:30 from Pierre Frédéric Caillaud <lists(at)peufeu(dot)com>       2010-01-18 11:20:59 from "fkater(at)googlemail(dot)com" <fkater(at)googlemail(dot)com>        2010-01-18 16:38:44 from "fkater(at)googlemail(dot)com" <fkater(at)googlemail(dot)com>        2010-01-18 23:37:12 from Scott Carey <scott(at)richrelevance(dot)com>         2010-01-19 10:50:07 from "fkater(at)googlemail(dot)com" <fkater(at)googlemail(dot)com>          2010-01-19 12:16:54 from Richard Huxton <dev(at)archonet(dot)com>          2010-01-19 15:13:51 from "Kevin Grittner" <Kevin(dot)Grittner(at)wicourts(dot)gov>          2010-01-19 20:31:04 from Scott Carey <scott(at)richrelevance(dot)com>           2010-01-21 08:25:41 from Scott Carey <scott(at)richrelevance(dot)com>            2010-01-21 08:35:09 from Greg Smith <greg(at)2ndquadrant(dot)com>             2010-01-21 12:13:19 from Matthew Wakeling <matthew(at)flymine(dot)org>             2010-01-23 02:51:24 from Scott Carey <scott(at)richrelevance(dot)com>             2010-01-23 02:52:49 from Scott Carey <scott(at)richrelevance(dot)com>            2010-01-22 20:42:03 from "fkater(at)googlemail(dot)com" <fkater(at)googlemail(dot)com>             2010-01-23 03:31:00 from Scott Carey <scott(at)richrelevance(dot)com>              2010-01-25 14:55:32 from "fkater(at)googlemail(dot)com" <fkater(at)googlemail(dot)com>               2010-01-26 21:27:24 from Scott Carey <scott(at)richrelevance(dot)com>              2010-01-26 22:02:15 from Greg Smith <greg(at)2ndquadrant(dot)com>        2010-01-19 10:16:07 from "fkater(at)googlemail(dot)com" <fkater(at)googlemail(dot)com>         2010-01-19 11:52:24 from Ivan Voras <ivoras(at)freebsd(dot)org>          2010-01-19 13:36:30 from "fkater(at)googlemail(dot)com" <fkater(at)googlemail(dot)com>           2010-01-19 15:36:59 from Ivan Voras <ivoras(at)freebsd(dot)org>  2010-01-14 15:14:46 from Florian Weimer <fweimer(at)bfk(dot)de>   2010-01-14 21:27:19 from "fkater(at)googlemail(dot)com" <fkater(at)googlemail(dot)com>    2010-01-15 08:02:49 from Florian Weimer <fweimer(at)bfk(dot)de>  2010-01-14 16:08:59 from Pierre Frédéric Caillaud <lists(at)peufeu(dot)com>   2010-01-14 21:28:07 from "fkater(at)googlemail(dot)com" <fkater(at)googlemail(dot)com>    2010-01-14 23:19:56 from Pierre Frédéric Caillaud <lists(at)peufeu(dot)com>     2010-01-15 05:38:48 from Magnus Hagander <magnus(at)hagander(dot)net>      2010-01-15 09:50:42 from Pierre Frédéric Caillaud <lists(at)peufeu(dot)com>     2010-01-15 20:35:46 from "fkater(at)googlemail(dot)com" <fkater(at)googlemail(dot)com>  2010-01-14 20:14:17 from "fkater(at)googlemail(dot)com" <fkater(at)googlemail(dot)com>   2010-01-18 13:08:38 from "fkater(at)googlemail(dot)com" <fkater(at)googlemail(dot)com>    2010-01-18 16:04:20 from "fkater(at)googlemail(dot)com" <fkater(at)googlemail(dot)com>  2010-01-15 21:15:47 from Merlin Moncure <mmoncure(at)gmail(dot)com>   2010-01-16 00:03:56 from Dave Crooke <dcrooke(at)gmail(dot)com>    2010-01-18 13:17:58 from "fkater(at)googlemail(dot)com" <fkater(at)googlemail(dot)com>     2010-01-19 10:55:26 from "fkater(at)googlemail(dot)com" <fkater(at)googlemail(dot)com>
Lists:	pgsql-performance

In response to

• Re: Inserting 8MB bytea: just 25% of disk perf used? at 2010-01-15 05:38:48 from Magnus Hagander

Browse pgsql-performance by date

	From	Date	Subject
Next Message	Matthew Wakeling	2010-01-15 10:55:00	Re: a heavy duty operation on an "unused" table kills my server
Previous Message	Ing. Marcos L. Ortiz Valmaseda	2010-01-15 09:19:10	Re: Re: New server to improve performance on our large and busy DB - advice? (v2)