Martijn,
Are you sure you're looking at the right numbers? Disk cache should be
counted as part of free memory, for example.
I am the guy who posted the problem to mod_perl, and yes, I am quite
sure that we are talking about the right numbers. The best argument is
that the machine in fact
Hello
I have a trigger procedure which I want to be called after insert or
update on different tables. In this procedure, I need to find the values
of key fields for the affected table in the NEW record, but I can't find
a way to access a field the name of which I only know at execution time.
Ken Johanson wrote:
You guys, and PG ROCK!! The standard_conforming_strings mode works
beautifully... it is (was) the last low-level barrier to using PG in a
really professional/interop environment. And as I become familiar,
again, with how PG and it's tools have come along, I am SUPER
Hello,
I install today the PG 8.2 beta1 on my Windows
Vista RC1 Workstation :
- No problem with the PGInstaller (The 8.1.4 have
bugs),
- No problem when reloading the data using command
line psql,
- First tests with my own application appear
Ok...
(but my production server stay on my LINUX
Andreas Rieke [EMAIL PROTECTED] writes:
I am the guy who posted the problem to mod_perl, and yes, I am quite
sure that we are talking about the right numbers. The best argument is
that the machine in fact starts swapping when memory is gone - and this
means there is neither free nor cached
Hi,
I'm running 8.1.4 on W2K3 R2. I occasionally get errors of the type:
ERROR: could not open relation 1663/856689/856777: Invalid argument
where the last two numbers change. This only seems to happen during
inserts into the largest table in the database (500,000 rows). What
does this error
Daniele Mazzini [EMAIL PROTECTED] writes:
I have a trigger procedure which I want to be called after insert or
update on different tables. In this procedure, I need to find the values
of key fields for the affected table in the NEW record, but I can't find
a way to access a field the name
Karen Hill wrote:
Gene Wirchenko wrote:
Yet what happens if there is a collision of the checksum for a row?
Then you get told that no change has occurred when one has. I
would call this an error.
That's exactly what I thought when I read that in his book. I was
thinking back to
Karen Hill [EMAIL PROTECTED] wrote:
I just finished reading one of Ralph Kimball's books. In it he
mentions something called a cyclical redundancy checksum (crc)
function. A crc function is a hash function that generates a checksum.
I am wondering a few things. A crc function would be
I have configured my postgresql fonfigure files,
postgresql.conf:
..
tcpip_socket = true
ssl = true
..
pg_hba.conf:
..
local all trust
host all trust
..
and i restart my computer, then i
Hi all
We use postgres 8.0.4 for our application on Linux ES3 kernel 2.4.21-4.
We wrote a small shell script for starting postgres, which does little
more than just calling postmaster. We trap interrupt signal in the
shell script to allow postgres to start even if interrupted by the
user. But the
Karen Hill [EMAIL PROTECTED] wrote in message
news:[EMAIL PROTECTED]
I just finished reading one of Ralph Kimball's books. In it he
mentions something called a cyclical redundancy checksum (crc)
function. A crc function is a hash function that generates a checksum.
I am wondering a few
I have an integer field of unique, consecutive numbers. Can I change
this to be a serial, primary key field using an ALTER TABLE ALTER
COLUMN command? I haven't been able to stumble over it.
thanks,
r
---(end of broadcast)---
TIP 4: Have you
Hi
I am new to Postgres. I am using PostgreSQL 8.1.4 on WinXP.
I tried using dropdb.exe to drop a database I created using pgAdminIII.
It seems to me that dropdb.exe expects arguments in an apparently weird
kind of way.
When I give the program the following arguments, it throws up an error:
Karen Hill wrote:
Tom Lane wrote:
Karen Hill [EMAIL PROTECTED] writes:
Ralph Kimball states that this is a way to check for changes. You just
have an extra column for the crc checksum. When you go to update data,
generate a crc checksum and compare it to the one in the crc column.
Karen Hill wrote:
Tom Lane wrote:
Karen Hill [EMAIL PROTECTED] writes:
Ralph Kimball states that this is a way to check for changes. You just
have an extra column for the crc checksum. When you go to update data,
generate a crc checksum and compare it to the one in the crc column.
Karen Hill wrote:
Tom Lane wrote:
Karen Hill [EMAIL PROTECTED] writes:
Ralph Kimball states that this is a way to check for changes. You just
have an extra column for the crc checksum. When you go to update data,
generate a crc checksum and compare it to the one in the crc column.
If they
Karen Hill schrieb:
I just finished reading one of Ralph Kimball's books. In it he
mentions something called a cyclical redundancy checksum (crc)
function. A crc function is a hash function that generates a checksum.
I am wondering a few things. A crc function would be extremely useful
and
On Friday 29 September 2006 09:51 am, [EMAIL PROTECTED] wrote:
I have an integer field of unique, consecutive numbers. Can I change
this to be a serial, primary key field using an ALTER TABLE ALTER
COLUMN command? I haven't been able to stumble over it.
thanks,
r
smartdude [EMAIL PROTECTED] writes:
We use postgres 8.0.4 for our application on Linux ES3 kernel 2.4.21-4.
We wrote a small shell script for starting postgres, which does little
more than just calling postmaster. We trap interrupt signal in the
shell script to allow postgres to start even if
sami [EMAIL PROTECTED] writes:
When I give the program the following arguments, it throws up an error:
dropdb -i -h localhost -p 5432 -U postgres - W password dataBaseToDrop
-W does not take the password as an argument on the command line, it
just forces a prompt for the password. (Which will
Wyatt --
We got a spate of similar errors recently; turned out to be a disk was not
mounted properly. Once it was reseated all was well. You might also do a RAM
check just to make sure that something isn't wonky there.
IIRC, I was told (see the archives of the postgres admin mail list) that
On Sep 30, 2006, at 12:28 PM, Tom Lane wrote:
If the shared segment is no longer present according to ipcs,
and there are no postgres processes still running, then it's
simply not possible for it to be postgres' fault if memory has
not been reclaimed. So you're looking at a kernel bug.
Hopefully your pg_hba.conf files look more like:local all all trusthost all all 192.168.10.0/24 trusthost pgbench all
192.168.3.0/24 trustOn 27 Sep 2006 21:02:47 -0700, blackjadelin
[EMAIL PROTECTED] wrote:I have configured my postgresql fonfigure files,
postgresql.conf:..tcpip_socket =
24 matches
Mail list logo