Is there an easy way to do file size estimates for the data storage for the
each table, each database and the whole system if the size of each row per
table is known (but of course includes text fields)?
Thanks,
--
Laurette Cisneros
The Database Group
(510) 420-3137
NextBus Information System
http://www.postgresql.org/idocs/index.php?wal.html
On Wed, 16 Oct 2002 14:51:00 -0700 (PDT)
Rusty Wright <[EMAIL PROTECTED]> wrote:
> Ok, I'll bite; where is it documented what postgresql does after an
> unplanned power outage or system shutdown? My question came about
> because I was searching
Ok, I'll bite; where is it documented what postgresql does after an
unplanned power outage or system shutdown? My question came about
because I was searching for documentation on some sort of db check
utility and didn't find anything.
Date: Wed, 16 Oct 2002 16:40:21 -0400
From: Vincent Jan
The rest of us read the documentation..
On Wed, 16 Oct 2002 13:12:07 -0700 (PDT)
Rusty Wright <[EMAIL PROTECTED]> wrote:
> Some of us are just paranoid and like to be prepared when there really
> is a fire.
>
>From: "ken" <[EMAIL PROTECTED]>
>To: "Bruce Momjian" <[EMAIL PROTECTED]>,
>
Some of us are just paranoid and like to be prepared when there really
is a fire.
From: "ken" <[EMAIL PROTECTED]>
To: "Bruce Momjian" <[EMAIL PROTECTED]>,
"Rusty Wright" <[EMAIL PROTECTED]>
Cc: <[EMAIL PROTECTED]>, <[EMAIL PROTECTED]>
Subject: RE: [ADMIN] newbie qs; fixing and c
On 2002.10.16 20:18 Bruce Momjian wrote:
> Morten Guldager wrote:
> >
> > My database cluster have one database with one table. (if we don't
> > count template0 and 1.
> >
> > My table has 3 collumns, 2 ints and a bytea. 2.5M rows and it
> consumes
> > 150G diskspace. I have a unique index on the
Did somebody just yell "fire" in a crowded theatre?
Ken
-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED]]On Behalf Of Bruce Momjian
Sent: Wednesday, October 16, 2002 12:54 PM
To: Rusty Wright
Cc: [EMAIL PROTECTED]; [EMAIL PROTECTED]
Subject: Re: [ADMIN] newbie qs; fix
Rusty Wright wrote:
> It seems to me that if the machine crashes in the middle of a
> transaction that there will be or is a very high chance of database
> corruption. I don't know if and how postgresql would detect and
> handle that after the system reboots. We are running mysql here and
> have
no problem. I myself am relatively new to postgres. The users on list
are very responsive whenever they can help. I'm doing the same and trying
to put in my 2 cents. Thanks guys!
Devinder Rajput
Stores Division Corporate Offices
Chicago, IL
(773) 442-6474
It seems to me that if the machine crashes in the middle of a
transaction that there will be or is a very high chance of database
corruption. I don't know if and how postgresql would detect and
handle that after the system reboots. We are running mysql here and
haven't had any data integrity pro
Morten Guldager wrote:
> Hi,
>
> My database cluster have one database with one table. (if we don't
> count template0 and 1.
>
> My table has 3 collumns, 2 ints and a bytea. 2.5M rows and it consumes
> 150G diskspace. I have a unique index on the 2 ints.
>
> I did a TRUNCATE on the table, and
that would be excellent if you were allowed to release your work...save some
of us from reinventing the wheel ;) What do you use from CPAN, anything
special beside Pg or DBI?
- Original Message -
From: "Jeff Boes" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Wednesday, October 16, 20
Hi,
My database cluster have one database with one table. (if we don't
count template0 and 1.
My table has 3 collumns, 2 ints and a bytea. 2.5M rows and it consumes
150G diskspace. I have a unique index on the 2 ints.
I did a TRUNCATE on the table, and a VACUUM FULL.
But PostgreSQL-7.2.3 did
On Sat, Oct 05, 2002 at 08:17:38PM -0700, Nikolaus Dilger wrote:
> Raymond,
>
> Partitioned tables would solve your issue since you
> could just truncate a partiotion in order to delete the
> unneeded data. Unfortunately they are not available in
> PostgreSQL. But maybe in a future release.
>
log into psql using: psql db_name (from the command line)
\d: Lists all tables in the current database (SHOW TABLES)
\d table_name: lists all columns of the given table ( DESCRIBE table_name)
\c new_db_name: switches connection to new database (USE db_name)
\?: will list available commands
\h: wi
On Wed, 16 Oct 2002 04:47:21 -0400, Denis Braekhus wrote:
> I know a lot of performance / monitoring data can be switched on and
> access= ed=20
> low level in postgresql, but have anyone else than Bruce (with his
> Pgmonito= r)=20
> done anything with regards to tools ?=20
Well, I've written a
Hi all,
I learned mysql has some sort of "top like" tool, to easily see what is going
on in the DB. AFAIK no such cmdline tool exists for Postgres (yet) ?
For my own monitoring, I have been using the ever simple "ps axfu" to show
processes and usage. I tried using the pgmonitor Tcl thingie, w
17 matches
Mail list logo
