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
I concur with most of what was already posted. Some additions below.
>>> "Scott Marlowe" <[EMAIL PROTECTED]> wrote:
> On Fri, Jun 6, 2008 at 12:30 AM, Greg Smith <[EMAIL PROTECTED]>
wrote:
>
>> vacuum_cost_delay = 750
>> autovacuum = true
>> autovacuum_naptime = 3600
>> autovacuum_vacuum_thres
> System Specification:
> OS :- CentOs 5
> Postgresql 8.1.8
> RAM :- 1 GB
> SWAP 2 GB
[Greg says]
How much memory is actually free, can you include the output from the command
"free" in your reply? What else runs on this server? What is the system load
before and during your query?
While it'
Hi,
> Hello to list,
>
> We have a CentOS-5 server with postgresql-8.1.8 installed. I am struggling
> with postgresql performance. Any query say select * from tablename takes
> 10-15 mins to give the output, and while executing the query system loads
> goes up like anything. After the query output
bijayant kumar wrote:
select * from tablename takes 10-15 mins to give the output
There are better ways to dump data than using a database; that's
not a useful query.
Any query select,insert,update simple or complex behaves in the same way
Have you set up suitable indexes for your operat
On Monday 23 June 2008 07:06:54 bijayant kumar wrote:
> Hello to list,
>
> We have a CentOS-5 server with postgresql-8.1.8 installed. I am struggling
> with postgresql performance. Any query say select * from tablename takes
> 10-15 mins to give the output, and while executing the query system load
Hello to list,
We have a CentOS-5 server with postgresql-8.1.8 installed. I am struggling with
postgresql performance. Any query say select * from tablename takes 10-15 mins
to give the output, and while executing the query system loads goes up like
anything. After the query output, system load
