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 sta
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 i
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 cache
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 n
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
> thi
"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 tr
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
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 searc
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
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 th
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 ti
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 e
"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. (Whic
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 thi
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.
thats
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 co
Hi all,
i have a Tomcat application with PostgreSQL 8.1.4 running which
performs about 1 inserts/deletes every 2-4 minutes and updates on
a database and after some hours of loadtesting the top output says
0.0% idle, 6-7% system load, load average 32, 31, 28 and there are
many exceptions at st
25 matches
Mail list logo
