Re: [PERFORM][SOLVED] Postgresql is very slow

2008-06-24 Thread bijayant kumar
Thank you all very very much. After running CLUSTER on the "USERS" table, now the speed is very very good. Now i have also understood the importance of VACUUM and ANALYZE. Once again thank you all very very much. You guys rock. --- On Tue, 24/6/08, [EMAIL PROTECTED] <[EMAIL PROTECTED]> wrote:

Re: [PERFORM] Postgresql is very slow

2008-06-24 Thread bijayant kumar
Thank you and all very much for your support. Now i have understood the problem related to my server. I will try the suggested thing like CLUSTER and then let you all know what happens after that. Once again Thanking you all. Bijayant Kumar --- On Tue, 24/6/08, [EMAIL PROTECTED] <[EM

Re: [PERFORM] Postgresql is very slow

2008-06-24 Thread bijayant kumar
--- On Tue, 24/6/08, [EMAIL PROTECTED] <[EMAIL PROTECTED]> wrote: > From: [EMAIL PROTECTED] <[EMAIL PROTECTED]> > Subject: Re: [PERFORM] Postgresql is very slow > To: "Scott Marlowe" <[EMAIL PROTECTED]> > Cc: [EMAIL PROTECTED], [EMAIL PROTECTED], pgsql-performance@postgresql.org > Date: Tuesday, 2

Re: [PERFORM] Postgresql is very slow

2008-06-23 Thread bijayant kumar
Hi, Thanks for the reply. Many gentlemans have replied to my question, thanks to all of them. I have tried to answer all questions in one mail. --- On Mon, 23/6/08, [EMAIL PROTECTED] <[EMAIL PROTECTED]> wrote: > From: [EMAIL PROTECTED] <[EMAIL PROTECTED]> > Subject: Re: [PERFORM] Postgresql is

[PERFORM] Postgresql is very slow

2008-06-23 Thread bijayant kumar
& Regards, Bijayant Kumar Send instant messages to your online friends http://uk.messenger.yahoo.com -- Sent via pgsql-performance mailing list (pgsql-performance@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-performance