Re: Very slow (2 tuples/second) sequential scan after bulk insert; speed returns to ~500 tuples/second after commit

From:	Simon Riggs <simon(at)2ndquadrant(dot)com>
To:	Heikki Linnakangas <heikki(at)enterprisedb(dot)com>
Cc:	Craig Ringer <craig(at)postnewspapers(dot)com(dot)au>, pgsql-performance(at)postgresql(dot)org
Subject:	Re: Very slow (2 tuples/second) sequential scan after bulk insert; speed returns to ~500 tuples/second after commit
Date:	2008-03-10 22:00:27
Message-ID:	1205186427.4269.179.camel@ebony.site
Views:	Raw Message | Whole Thread | Download mbox | Resend email
Thread:	2008-03-10 09:55:59 from Craig Ringer <craig(at)postnewspapers(dot)com(dot)au>  2008-03-10 11:01:32 from "Heikki Linnakangas" <heikki(at)enterprisedb(dot)com>   2008-03-10 11:29:01 from Craig Ringer <craig(at)postnewspapers(dot)com(dot)au>    2008-03-10 16:55:43 from Rainer Pruy <Rainer(dot)Pruy(at)Acrys(dot)COM>   2008-03-10 12:16:27 from Craig Ringer <craig(at)postnewspapers(dot)com(dot)au>   2008-03-10 14:33:58 from Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>    2008-03-10 14:48:39 from Craig Ringer <craig(at)postnewspapers(dot)com(dot)au>     2008-03-10 15:02:52 from Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>      2008-03-10 15:10:00 from Craig Ringer <craig(at)postnewspapers(dot)com(dot)au>     2008-03-10 15:03:14 from "Heikki Linnakangas" <heikki(at)enterprisedb(dot)com>      2008-03-10 15:20:40 from Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>       2008-03-11 12:34:07 from "Heikki Linnakangas" <heikki(at)enterprisedb(dot)com> 📎        2008-03-11 13:06:33 from "Pavan Deolasee" <pavan(dot)deolasee(at)gmail(dot)com>        2008-03-11 13:29:04 from Alvaro Herrera <alvherre(at)commandprompt(dot)com>         2008-03-11 14:03:08 from "Heikki Linnakangas" <heikki(at)enterprisedb(dot)com>        2008-03-11 21:06:37 from Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>         2008-03-12 13:43:46 from "Heikki Linnakangas" <heikki(at)enterprisedb(dot)com> 📎          2008-03-12 15:47:20 from "Pavan Deolasee" <pavan(dot)deolasee(at)gmail(dot)com>           2008-03-12 15:57:19 from Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>            2008-03-12 17:02:37 from "Pavan Deolasee" <pavan(dot)deolasee(at)gmail(dot)com>             2008-03-12 17:14:04 from "Heikki Linnakangas" <heikki(at)enterprisedb(dot)com>              2008-03-12 17:26:22 from "Pavan Deolasee" <pavan(dot)deolasee(at)gmail(dot)com>               2008-03-12 17:33:47 from "Heikki Linnakangas" <heikki(at)enterprisedb(dot)com>                2008-03-12 17:48:50 from "Pavan Deolasee" <pavan(dot)deolasee(at)gmail(dot)com>             2008-03-12 17:22:13 from Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>          2008-03-17 02:20:39 from Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>          2008-03-17 02:21:24 from Bruce Momjian <bruce(at)momjian(dot)us>    2008-03-10 14:53:32 from "Heikki Linnakangas" <heikki(at)enterprisedb(dot)com>   2008-03-10 22:00:27 from Simon Riggs <simon(at)2ndquadrant(dot)com>    2008-03-11 09:58:20 from "Heikki Linnakangas" <heikki(at)enterprisedb(dot)com>   2008-03-11 06:24:42 from "Pavan Deolasee" <pavan(dot)deolasee(at)gmail(dot)com>
Lists:	pgsql-patches pgsql-performance

In response to

• Re: Very slow (2 tuples/second) sequential scan after bulk insert; speed returns to ~500 tuples/second after commit at 2008-03-10 11:01:32 from Heikki Linnakangas

Responses

• Re: Very slow (2 tuples/second) sequential scan afterbulk insert; speed returns to ~500 tuples/second after commit at 2008-03-11 09:58:20 from Heikki Linnakangas

Browse pgsql-patches by date

	From	Date	Subject
Next Message	Peter Eisentraut	2008-03-10 23:11:43	Re: [PATCHES] Fix for large file support (nonsegment mode support)
Previous Message	Tom Lane	2008-03-10 20:16:12	Re: [PATCHES] Fix for large file support (nonsegment mode support)

Browse pgsql-performance by date

	From	Date	Subject
Next Message	Scott Marlowe	2008-03-10 22:21:42	Re: count * performance issue
Previous Message	Greg Smith	2008-03-10 21:52:40	Re: count * performance issue