Re: [PERFORM] need help with a query

2007-10-23 Thread Pavel Velikhov
On 10/20/07, Pavel Velikhov <[EMAIL PROTECTED]> wrote: > Left the query running for 10+ hours and had to kill it. I guess there > really was no need to have lots of > shared buffers (the hope was that postgresql will cache the whole table). I > ended up doing this step inside > the application a

Re: [PERFORM] need help with a query

2007-10-21 Thread Jonah H. Harris
On 10/20/07, Pavel Velikhov <[EMAIL PROTECTED]> wrote: > Left the query running for 10+ hours and had to kill it. I guess there > really was no need to have lots of > shared buffers (the hope was that postgresql will cache the whole table). I > ended up doing this step inside > the application as a

Re: [PERFORM] need help with a query

2007-10-20 Thread Pavel Velikhov
PROTECTED]> Cc: Jonah H. Harris <[EMAIL PROTECTED]>; pgsql-performance@postgresql.org Sent: Friday, October 19, 2007 8:17:48 PM Subject: Re: [PERFORM] need help with a query On Fri, Oct 19, 2007 at 09:11:36AM -0700, Pavel Velikhov wrote: > Thanks for you help! > > Got a very d

Re: [PERFORM] need help with a query

2007-10-19 Thread Tom Lane
Pavel Velikhov <[EMAIL PROTECTED]> writes: > Got a very different query plan this time, with a hash join between links and > articles. At least now postgres is using both shared memory buffers and > working mem, but its still completely IO bound, only getting in 5-6% CPU once > in a while. I gue

Re: [PERFORM] need help with a query

2007-10-19 Thread Pavel Velikhov
MAIL PROTECTED]> Cc: pgsql-performance@postgresql.org Sent: Friday, October 19, 2007 7:52:58 PM Subject: Re: [PERFORM] need help with a query On 10/19/07, Pavel Velikhov <[EMAIL PROTECTED]> wrote: > > Hi, > > I am updating a big table (90M records) with data from another rathe

Re: [PERFORM] need help with a query

2007-10-19 Thread Jonah H. Harris
On 10/19/07, Pavel Velikhov <[EMAIL PROTECTED]> wrote: > > Hi, > > I am updating a big table (90M records) with data from another rather > large table (4M entries). Here is my update query: > > update links set target_size = > ( select size from articles where articles.article_id = > link

[PERFORM] need help with a query

2007-10-19 Thread Pavel Velikhov
Hi, I am updating a big table (90M records) with data from another rather large table (4M entries). Here is my update query: update links set target_size = ( select size from articles where articles.article_id = links.article_to) I have built all the indexes one might need, increase