On Wed, Aug 02, 2006 at 12:37:47AM -0400, Tom Lane wrote:
> adey <[EMAIL PROTECTED]> writes:
> > Please could someone tell me how to discover what is using all of my RAM?
> > I am trying to run a vacuum against Postgres, but it fails immediately
> > with:-
>
> > "ERROR: out of memory
> > DETAIL:
adey <[EMAIL PROTECTED]> writes:
> Please could someone tell me how to discover what is using all of my RAM?
> I am trying to run a vacuum against Postgres, but it fails immediately
> with:-
> "ERROR: out of memory
> DETAIL: Failed on request of size 1073741820."
I'd bet lunch that this is a co
Please could someone tell me how to discover what is using all of my RAM?
I am trying to run a vacuum against Postgres, but it fails immediately with:-
"ERROR: out of memoryDETAIL: Failed on request of size 1073741820."
TOP shows the following:-
Mem: 4077544k total, 3897868k used, 179676
On Tue, 2006-08-01 at 14:22 -0500, Scott Marlowe wrote:
> On Tue, 2006-08-01 at 13:59, Aaron Bono wrote:
> > On 7/31/06, Thomas Pundt <[EMAIL PROTECTED]> wrote:
> > On Monday 31 July 2006 10:06, Aaron Bono wrote:
> > | Is there a way I can tell PostgreSQL to give session a low
> >
On 8/1/06, Scott Marlowe <[EMAIL PROTECTED]> wrote:
On Tue, 2006-08-01 at 13:59, Aaron Bono wrote:> On 7/31/06, Thomas Pundt <[EMAIL PROTECTED]> wrote:> On Monday 31 July 2006 10:06, Aaron Bono wrote:
> | Is there a way I can tell PostgreSQL to give session a low> priority s
Bottom line, I am skeptical if this will really achieve my goal - to
have the functions run with low priority.
Is there a way to tell PostgreSQL to change the nice value of a
particular connection? I guess I could use renice but that means a lot
of shell scripting to determine what PID to c
On Tue, 2006-08-01 at 13:59, Aaron Bono wrote:
> On 7/31/06, Thomas Pundt <[EMAIL PROTECTED]> wrote:
> On Monday 31 July 2006 10:06, Aaron Bono wrote:
> | Is there a way I can tell PostgreSQL to give session a low
> priority so even
> | if it does take the full CPU,
On 7/31/06, Thomas Pundt <[EMAIL PROTECTED]> wrote:
On Monday 31 July 2006 10:06, Aaron Bono wrote:| Is there a way I can tell PostgreSQL to give session a low priority so even| if it does take the full CPU, it only does so if it would otherwise be| idle?
the "nice" command might do what you want..
hi mr d,
yes i would say you have a problem with the 8.1.4's archive-command -
sorry most of my keyboard keys have stopped working so i can't use
capitals or punctuation lol.
check your latest logs on the 8.1.4 server for errors in archiving that
file. when you've done a backup, that .backu
Hey Andy,
Sorry for the confusion. That file and the one in archive_status
(*.backup.done) are from v810. I'm wondering why my PITR backup in v814
doesn't leave me with similiear files. Neither *.backup in pg_xlog or
*.backup.done in archive_status shows up. I was wondering if that was by
I would like to get unsubscribed
I getting to much junk.
Is it possible just to look for particular question/answer in "pgsql-admin"
instead of getting a millions junk mail.
Thank you very much.
---(end of broadcast)---
TIP 2: Don't 'kill -9' the
That looks to be a file hanging around from a previous PITR backup.
That file should be in your xlog archive.
cat the contents and you'll see which backup it belongs to.
Andy.
Mr. Dan wrote:
Hi,
I do an online backup with v814 and v810. I've noticed that there is
a file showing up in the
Hi,
I do an online backup with v814 and v810. I've noticed that there is a file
showing up in the PGDATA
directory/pg_xlog/0125100C2.0021CDDE.backup owned by
postgres 284 bytes in size that shows up in v810. That file isn't showing
up in v814. Is that by design?
~DjK
p
On Tue, 2006-08-01 at 01:44, Javanesevn wrote:
> Hi all,
>
> My project ( web application) is using Postgre 8.1 and PHP 4.x (ADO
> library to access database). And I would like to increase perfomance, so
> I changed configuration follow this:
> shared_buffers = 16000（Default = 1000）
> wal_buffer
On Tue, 2006-08-01 at 09:22 +0200, Thomas Günther wrote:
> Hello,
>
>
>
> my configuration exists of 2 db-nodes, 2 replication nodes and 1
> loadbalancer.
>
>
>
> Is it able to replicate only some tables (not all) to a third db
> node.
>
> Has someone experiences with cascaded reolication
You might be better off asking this on the pgsql-interfaces list -
that's geared more towards programming with libpq and other interfaces.
Andy.
LiveShell wrote:
Hi all,
I am using libpqxx to connct to Pgsql database.
Following is my code in a connect method of a class
Hi all,
I am using libpqxx to connct to Pgsql database. Following is my code in a connect method of a class
try { conninfo = "host=127.0.0.1 dbname = DatabaseName user=uname"; conn = new connection(conninfo);
} catch (const sql_error &roSqlQueryError) { printf(
Have a look at http://www.powerpostgresql.com/PerfList/ and change your settings accordingly.Thanks,-- Shoaib MirEnterpriseDB (
www.enterprisedb.com)On 8/1/06, Javanesevn <[EMAIL PROTECTED]> wrote:
Hi all,My project ( web application) is using Postgre 8.1 and PHP 4.x (ADOlibrary to access database)
Hello,
my configuration exists of 2 db-nodes, 2 replication
nodes and 1 loadbalancer.
Is it able to replicate only some tables (not all) to
a third db node.
Has someone experiences with cascaded reolication.
Can anyone post a sample conf for cascading?
Best regards
Tom :)
Hi all,
My project ( web application) is using Postgre 8.1 and PHP 4.x (ADO
library to access database). And I would like to increase perfomance, so
I changed configuration follow this:
shared_buffers = 16000（Default = 1000）
wal_buffers = 64（Default = 8）
But this setting is not strong effect.
20 matches
Mail list logo
