On Thu, Jan 6, 2011 at 2:41 PM, Scott Marlowe wrote:
> On Thu, Jan 6, 2011 at 2:31 PM, Robert Haas wrote:
>> On Mon, Dec 20, 2010 at 12:49 PM, Greg Smith wrote:
>>> Scott Marlowe wrote:
I can sustain about 5,000 transactions per second on a machine with 8
cores (2 years old) and 14 15k
On Thu, Jan 6, 2011 at 2:31 PM, Robert Haas wrote:
> On Mon, Dec 20, 2010 at 12:49 PM, Greg Smith wrote:
>> Scott Marlowe wrote:
>>> I can sustain about 5,000 transactions per second on a machine with 8
>>> cores (2 years old) and 14 15k seagate hard drives.
>>
>> Right. You can hit 2 to 3000/se
On Mon, Dec 20, 2010 at 12:49 PM, Greg Smith wrote:
> Scott Marlowe wrote:
>> I can sustain about 5,000 transactions per second on a machine with 8
>> cores (2 years old) and 14 15k seagate hard drives.
>
> Right. You can hit 2 to 3000/second with a relatively inexpensive system,
> so long as you
On Mon, Dec 20, 2010 at 10:49 AM, Greg Smith wrote:
> Scott Marlowe wrote:
>>
>> I can sustain about 5,000 transactions per second on a machine with 8
>> cores (2 years old) and 14 15k seagate hard drives.
>>
>
> Right. You can hit 2 to 3000/second with a relatively inexpensive system,
> so long
Scott Marlowe wrote:
I can sustain about 5,000 transactions per second on a machine with 8
cores (2 years old) and 14 15k seagate hard drives.
Right. You can hit 2 to 3000/second with a relatively inexpensive
system, so long as you have a battery-backed RAID controller and a few
hard driv
On Sat, Dec 18, 2010 at 2:34 AM, selvi88 wrote:
>
>
> Thanks for ur suggestion, already I have gone through that url, with that
> help I was able to make my configuration to work for 5K queries/second.
> The parameters I changed was shared_buffer, work_mem, maintenance_work_mem
> and effective_cac
On Fri, Dec 17, 2010 at 07:48, selvi88 wrote:
>
> My requirement is more than 15 thousand queries will run,
> It will be 5000 updates and 5000 insert and rest will be select.
>
>
What IO system are you running Postgres on? With that kind of writes you
should be really focusing on your storage sol
Thanks for ur suggestion, already I have gone through that url, with that
help I was able to make my configuration to work for 5K queries/second.
The parameters I changed was shared_buffer, work_mem, maintenance_work_mem
and effective_cache.
Still I was not able to reach my target.
Can u kindly
My requirement is more than 15 thousand queries will run,
It will be 5000 updates and 5000 insert and rest will be select.
Each query will be executed in each psql client, (let say for 15000 queries
15000 thousand psql connections will be made).
Since the connections are more for me the performa
On Thu, Dec 16, 2010 at 7:33 AM, selvi88 wrote:
>
> 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
On Thu, Dec 16, 2010 at 14:33, selvi88 wrote:
> 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.
You have not told us anything about what sort of queries they are or
you're
selvi88 wrote:
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.
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 operati
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.
-
14 matches
Mail list logo
