Hi again!
I have finally got my Ubuntu VirtualBox VM running PostgreSQL with PL/Python
and am now looking at performance.
So here's the scenario:
We have a great big table:
cse=# \d nlpg.match_data
Table "nlpg.match_data"
Column | Type |
On 17/06/2010 22:41, Greg Smith wrote:
Tom Wilcox wrote:
Any suggestions for good monitoring software for linux?
By monitoring, do you mean for alerting purposes or for graphing
purposes? Nagios is the only reasonable choice for the former, while
doing at best a mediocre job at the latter
Thanks. I will try with a more sensible value of wal_buffers.. I was
hoping to keep more in memory and therefore reduce the frequency of disk
IOs..
Any suggestions for good monitoring software for linux?
On 15/06/2010 00:08, Robert Haas wrote:
On Mon, Jun 14, 2010 at 2:53 PM, Tom Wilcox
l and
manage.
On Mon, Jun 14, 2010 at 7:41 PM, Tom Wilcox <mailto:hungry...@gmail.com>> wrote:
Hi Dave,
I am definitely able to switch OS if it will get the most out of
Postgres. So it is definitely a case of choosing the OS on the
needs if the app providing it is
r less overhead loss than
either Hyper-V (which I presume you are using) or VMWare Workstation
for NT (kernels).
If it's a Windows-only policy, then perhaps you can run those traps in
reverse, and switch to a Windows database, i.e. Microsoft SQL Server.
Cheers
Dave
On Mon, Jun 1
Can WAL files have
their own disk? Is the workload OLTP or OLAP, or a mixture of both? There is
more that goes into tuning a PG server for good performance than simply
installing the software, setting a couple of GUCs and running it.
Bob
--- On Thu, 6/10/10, Tom Wilcox wrote:
From: Tom
Hi,
Sorry to revive an old thread but I have had this error whilst trying to
configure my 32-bit build of postgres to run on a 64-bit Windows Server
2008 machine with 96GB of RAM (that I would very much like to use with
postgres).
I am getting:
2010-06-02 11:34:09 BSTFATAL: requested share
