On 01/21/2011 09:34 AM, Julia Jacobson wrote:
> Two further problems are the fact that the names of columns are not
> allowed to begin with a number and every entry in the table definition
> list must not only contain the name of the column but of course also a
> data type (always the same - int).
Thank you so much for the script.
~deepak
On Jan 22, 2011, at 10:18 AM, Greg Smith wrote:
> DM wrote:
>> RAM = 16GB, what value should i set for shmall?
>
> Given that PostgreSQL rarely sees increasing improvement as shared_buffers
> goes over 50% of RAM, I just use that figure for the shmal
I know you're running windows, but if you can get bash working on it,
here's a simple bash script I wrote that when it detects too many
people connected creates a table called pg_stat_bk_20110120140634
(i.e. date and time) so I can then look over what was in
pg_stat_activity when things were acting
Andy,
Then answer these questions:
Does ram using increase over the week?
Server was re-started yesterday and there was little use after restart.
server is idle. Task Manager shows now
PF Usage 1.22 GB
Physical Memory (K)
Total 4191872
Avail 348 (last 4 vary)
System cache 35676xx (last
DM wrote:
RAM = 16GB, what value should i set for shmall?
Given that PostgreSQL rarely sees increasing improvement as
shared_buffers goes over 50% of RAM, I just use that figure for the
shmall and then compute shmmax based on the page size to match it. I
use the attached script to do all th
* Harald Armin Massa wrote:
Should PostgreSQL maybe provide its own file-copy utility for
Windows that meets the requirements for safe WAL archiving?
Microsoft does provide an enterprise-ready webscale copy program ... it
is called robocopy and part of the Windows Server Resource Kit T
On 01/22/2011 03:00 AM, Andrus Moor wrote:
Andy,
How to automatically re-start postgres service in every night ? Or is it
better to switch to 32bit server?
Neither. You need to fix the problem.
How to configure postgres so that freeze issue can addressed ?
E.q. if query runs more that 60 se
Christian,
> Should PostgreSQL maybe provide its own file-copy utility for Windows that
> meets the requirements for safe WAL archiving?
>
> Microsoft does provide an enterprise-ready webscale copy program ... it is
called robocopy and part of the Windows Server Resource Kit Tools. Would you
min
Francisco Figueiredo Jr
Sent from my Android phone.
Em 21/01/2011 13:50, "orgilhp" escreveu:
>
> Hello,
Hello!
> I have postgresql 8.3.9 database. Now I am working on reading file
> from bytea data and save to filesystem.
> I am using Npgsql.dll on c#.net.
>
Which version of Npgsql are you us
Andy,
How to automatically re-start postgres service in every night ? Or is it
better to switch to 32bit server?
Neither. You need to fix the problem.
How to configure postgres so that freeze issue can addressed ?
E.q. if query runs more that 60 seconds, postgres dumps its status and long
10 matches
Mail list logo