In addition to the previous post,
My postgres version is 8.3.7
>Hi there,
>
>Just to let you know, I'm not a database expert by any means.
>I have configured dbt-2 with postgres and created a database with 4000
>warehouses,
>150 customers etc. The database size is over 8G. I am aware that lo
Hi there,
Just to let you know, I'm not a database expert by any means.
I have configured dbt-2 with postgres and created a database with 4000
warehouses,
150 customers etc. The database size is over 8G. I am aware that lock contention
can be checked with lockstat (and with pg_locks ? ) but I
Thanks alot for all the replies. Very helpful, really appreciate it.
- Original Message -
From: "Jeff Janes"
To: "Hamza Bin Sohail"
Cc:
Sent: Friday, December 10, 2010 7:18 PM
Subject: Re: [HACKERS] would hw acceleration help postgres (databases in
general)
Hello hackers,
I think i'm at the right place to ask this question.
Based on your experience and the fact that you have written the Postgres code,
can you tell what a rough break-down - in your opinion - is for the time the
database spends time just "fetching and writing " stuff to memory and
Hi,
I posted this email on the other postgres lists but did not get a reply. So as
a last resort, I came here. I hope somebody can help.
I am looking into the impact of large page sizes on the performance of
commercial workloads e.g databases,webserver,virtual machines etc. I was
wondering if