Re: postgres performance tunning - Mailing list pgsql-performance

From Pierre C
Subject Re: postgres performance tunning
Date
Msg-id op.vnurqppteorkce@apollo13
Whole thread Raw
In response to postgres performance tunning  (selvi88 <selvi.dct@gmail.com>)
Responses Re: postgres performance tunning  (selvi88 <selvi.dct@gmail.com>)
List pgsql-performance
> Dear Friends,
>         I have a requirement for running more that 15000 queries per
> second.
> Can you please tell what all are the postgres parameters needs to be
> changed
> to achieve this.
>         Already I have 17GB RAM and dual core processor and this machine
> is dedicated for database operation.

That depends on your queries : for simple things like "SELECT * FROM table
WHERE primary_key = constant", no problem, a desktop dual core will do
it...
So, please provide more details...

pgsql-performance by date:

Previous
From: Marti Raudsepp
Date:
Subject: Re: Auto-clustering?
Next
From: Filip Rembiałkowski
Date:
Subject: Re: Auto-clustering?