| From: | Simon Riggs <simon(at)2ndquadrant(dot)com> |
|---|---|
| To: | Christopher Petrilli <petrilli(at)gmail(dot)com> |
| Cc: | jd(at)commandprompt(dot)com, Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>, "Marc G(dot) Fournier" <scrappy(at)postgresql(dot)org>, pgsql-performance(at)postgresql(dot)org |
| Subject: | Re: Sustained inserts per sec ... ? |
| Date: | 2005-04-04 22:44:00 |
| Message-ID: | 1112654640.16721.859.camel@localhost.localdomain |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-performance |
On Mon, 2005-04-04 at 17:03 -0400, Christopher Petrilli wrote:
> On Apr 4, 2005 4:58 PM, Simon Riggs <simon(at)2ndquadrant(dot)com> wrote:
> > Can you do:
> > select relname from pg_class where relfilenode = 26488271
> > and confirm that the name is the table you've been loading...
>
> It is.
>
> > Couldn't see all your indexes... are they still there?
>
> Nope, I'm running a second run without the auxilary indices. I only
> have the primary key index. So far, a quick scan with the eye says
> that it's behaving "better", but beginning to have issues again. I'll
> post results as soon as they are done.
Hmmm....
Before I start to tunnel-vision on a particular coincidence...
How much memory have you got on the system?
How much of that have you allocated to various tasks?
What else is happening on your system?
Tell us more about disk set-up and other hardware related things.
Disk cache...disk speed...seek times....etc
Best Regards, Simon Riggs
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Mike Rylander | 2005-04-04 23:28:25 | Re: Sustained inserts per sec ... ? |
| Previous Message | Christopher Petrilli | 2005-04-04 21:03:56 | Re: Sustained inserts per sec ... ? |