We have a process that we successfully ran on virtually identical
databases. The process completed fine on a machine with 8 gig of
memory. The process fails when run on another machine that has 16 gig
of memory with the following error:
out of memory for query result
How is this possible?
On 07/03/2011 01:00 PM, Geoffrey Myers wrote:
We have a process that we successfully ran on virtually identical
databases. The process completed fine on a machine with 8 gig of
memory. The process fails when run on another machine that has 16 gig
of memory with the following error:
out of
On 3/07/2011 6:00 PM, Geoffrey Myers wrote:
out of memory for query result
How is this possible?
Resource limits?
Do you have a ulimit in place that applies to postgresql? You can check
by examining the resource limits of a running postgresql backend as
shown in /proc/$PG_PID where $PG_PID
Le vendredi 01 juillet 2011 à 12:28 +0400, Dmitriy Igrishin a écrit :
> Then I don't clearly understand the existence of locks (the LOCK
> command, SELECT FOR UPDATE clause and so on) if the usage
> of them gives only problems...
>
Chris already explained why twice :
"you MUST lock on insert t
Hey Vincent,
2011/7/3 Vincent Veyron
> Le vendredi 01 juillet 2011 à 12:28 +0400, Dmitriy Igrishin a écrit :
>
>
> > Then I don't clearly understand the existence of locks (the LOCK
> > command, SELECT FOR UPDATE clause and so on) if the usage
> > of them gives only problems...
> >
>
> Chris alr
W dniu 2011-06-30 20:20, Dmitry Koterov pisze:
And I need as compact uniq_id generation (with minimum "holes") as it possible - this is a VERY
important requirement (to export these values into external systems which accepts only IDs limited
from 1 to 10).
So I cannot use sequences: sequen
On Sun, Jul 3, 2011 at 7:25 AM, Ireneusz Pluta wrote:
> You may use dense_rank() (or even rank()) window function to map your
> sequence-with-gaps to a no-gap-id which will be used for exports.
>
The typical case where gapless numbering comes up is something like this:
In Greece, you go get inv
I have strings from
java and need to check which ones are not present in the db. Can
I use a select statement to do this by making it search my
strings as though they are a table?
Le dimanche 03 juillet 2011 à 18:10 +0400, Dmitriy Igrishin a écrit :
>
> Not me :-). The OP must do it.
Duh! sorry about that. Indeed, I confused you with Dmitry.
--
Vincent Veyron
http://marica.fr/
Logiciel de gestion des sinistres et des contentieux pour le service juridique
--
On Jul 3, 2011, at 11:13, Daron Ryan wrote:
> I have strings from
> java and need to check which ones are not present in the db. Can
> I use a select statement to do this by making it search my
> strings as though they are a table?
There are multiple ways to accomplish
On 3 Jul 2011, at 12:00, Geoffrey Myers wrote:
> We have a process that we successfully ran on virtually identical databases.
> The process completed fine on a machine with 8 gig of memory. The process
> fails when run on another machine that has 16 gig of memory with the
> following error:
>
On 3 Jul 2011, at 16:10, Dmitriy Igrishin wrote:
> "you MUST lock on insert to get gapless sequences"
> Not me :-). The OP must do it. So, what problem here? Deadlocks?
> Again, if deadlocks are so dangerous, why the LOCK command exists?
It's not deadlocks, it's concurrent updates that are the tr
Hey Alban,
2011/7/3 Alban Hertroys
> On 3 Jul 2011, at 16:10, Dmitriy Igrishin wrote:
>
> > "you MUST lock on insert to get gapless sequences"
> > Not me :-). The OP must do it. So, what problem here? Deadlocks?
> > Again, if deadlocks are so dangerous, why the LOCK command exists?
>
> It's not
Hiroshi,
I've what I believe your saying is the one that is in the contrib directory
now should work fine on Window 64
"Hiroshi Saito" wrote:
> Hi Grace-san.
>
> It is the same as windows.
> http://winpg.jp/~saito/pg_work/OSSP_win32/
>
> 1. Deployment of tar.gz
> 2. apply the patch
> 3. config
Thanks a lot for the details. Hopefully, I'll be able to pull it off.
--Mona
--- On Fri, 7/1/11, Craig Ringer wrote:
From: Craig Ringer
Subject: Re: [GENERAL] statically compiling postgres and problem with initdb
To: "Tom Lane"
Cc: "mona attariyan" , pgsql-general@postgresql.org
Date: Friday,
Hi,
> But is there any similar kind of application for Windows Postgresql
Backup?
>
I don't know any similar kind applications for windows PostgreSQL backup,
although there may be some aplications in the world.
I've checked some tools listed below wiki, I couldn't find it out...
http://wiki.po
16 matches
Mail list logo
