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
> >
le with
> my applications has proven to be a "one hand tied behind my back"
> situation.
>
> Any ideas you guys have would be deeply appreciated.
I hate to say this, but maybe you should look into SQLite
http://www.sqlite.org/ ...
Bye,
Chris.
--
Chris Mair
http://www.1006.org
4 01:42:39
> 62 processes: 1 running, 61 sleeping
> CPU states: 22.9% user, 0.0% nice, 7.3% system, 5.4% interrupt, 64.4%
> idle
> Mem: 140M Active, 480M Inact, 132M Wired, 31M Cache, 110M Buf, 4608K
> Free
> Swap: 2005M Total, 188K Used, 2004M Free
Looks like you're not us
does not
> keep up with it it will stall.
Does it buffer at all?
> Worst case, I will virtualize the monitroing agent, but that will
> require quite a bit of work on our side.
Bye, Chris.
--
Chris Mair
http://www.1006.org
---(end of broadcast)---
TIP 5: don't forget to increase your free space map settings
e you're into real time
stuff and RDBMS' and real time stuff don't mix well.
Bye :)
Chris.
--
Chris Mair
http://www.1006.org
---(end of broadcast)---
TIP 6: explain analyze is your friend
> I also want to know how to find out that howmuch memory and CPU ,
> my postgres is taking .
Ask your operating system :)
top on unices or the tasklist on windows might be a start...
Bye, Chris.
--
Chris Mair
http://www.1006.org
---(e
table, r.conname as contraint,
pg_catalog.pg_get_constraintdef(r.oid, true) as constraint_definition
FROM pg_catalog.pg_constraint r, pg_catalog.pg_class c WHERE c.oid =
r.conrelid AND r.contype = 'f';
Bye,
Chris.
--
Chris Mair
http://www.1006.org
-
of available databases with psql -l.
>
> Any help is appreciated.
>
> Thanks
>
> John Vandervliet
Bye,
Chris.
--
Chris Mair
http://www.1006.org
---(end of broadcast)---
TIP 4: Have you searched our list archives?
http://archives.postgresql.org
look up the timestamps of the corresponding directories
in $PGDATA/base.
Bye, Chris.
--
Chris Mair
http://www.1006.org
---(end of broadcast)---
TIP 9: In versions below 8.0, the planner will ignore your desire to
choose an index scan if
> It didn't seem to work
>
> I just checked one $PGDATA/base directory, they all have today's time
> stamp (9/20/06) around 6:00 am this morning, that was when my daily
> database dump cron job was running...
You can check the PG_VERSION file under each database's directory as
Husam said..
> Thanks, but I still can't get the database creation date
>
>
> % cat PG_VERSION
> 8.1
>
> 16% ls -lt PG*
> -rw---1 postgres users 4 Jun 22 10:34 PG_VERSION
>
> This date was the date that the Postgres server was upgraded to 8.1
> and the timestamp of this file is same un
11 matches
Mail list logo
