Re: Howto Setup a good PostgreSQL Server

Поиск
Список
Период
Сортировка
Искать

Re: Howto Setup a good PostgreSQL Server

От:
"Kuhn, Dylan K (4520500D)" <Dylan.Kuhn@navy.mil>
Дата:
I've found this page helpful: http://www.lyris.com/lm_help/6.0/tuning_postgresql.html

Does anyone know if there is a more "official" source of information like that?

Dylan Kuhn

> -----Original Message-----
> From: Stefan Sturm [mailto:mailling@anrath.info]
> Sent: Monday, May 19, 2003 8:16
> To: pgsql-admin@postgresql.org
> Subject: [ADMIN] Howto Setup a good PostgreSQL Server
> 
> 
> Hello,
> 
> where can I find a tutorial about 'HowTo setup a PostgreSQL Server'.
> I don't mean howto install. I want to know what can I do to 
> maximize the
> Performance of the whole system.
> 
> I found some posting here, but this can't be all I can do...
> 
> Thanks for your Help,
> 
> Stefan Sturm
> 
> 
> ---------------------------(end of 
> broadcast)---------------------------
> TIP 4: Don't 'kill -9' the postmaster
> 

Table size on disk

От:
Kris Kiger <kris@musicrebellion.com>
Дата:
Is there a good way to tell how much physical space a table takes on 
disk?  Thanks

Kris

Re: Table size on disk

От:
"Cristina Surroca" <cris@dmcid.net>
Дата:
select relname, relpages from pg_class;
relname is the table name.
relpages is number of pages of 8 K that needs the table to be stored.

(sorry for my English)

yours

Cris..
----- Original Message ----- 
From: "Kris Kiger" 
Cc: 
Sent: Tuesday, May 20, 2003 4:58 PM
Subject: [ADMIN] Table size on disk


> Is there a good way to tell how much physical space a table takes on 
> disk?  Thanks
> 
> Kris
> 
> 
> ---------------------------(end of broadcast)---------------------------
> TIP 5: Have you checked our extensive FAQ?
> 
> http://www.postgresql.org/docs/faqs/FAQ.html

Re: Table size on disk

От:
Bruce Momjian <pgman@candle.pha.pa.us>
Дата:

See monitoring disk space chapter in the docs.

---------------------------------------------------------------------------

Cristina Surroca wrote:
> select relname, relpages from pg_class;
> relname is the table name.
> relpages is number of pages of 8 K that needs the table to be stored.
> 
> (sorry for my English)
> 
> yours
> 
> Cris..
> ----- Original Message ----- 
> From: "Kris Kiger" 
> Cc: 
> Sent: Tuesday, May 20, 2003 4:58 PM
> Subject: [ADMIN] Table size on disk
> 
> 
> > Is there a good way to tell how much physical space a table takes on 
> > disk?  Thanks
> > 
> > Kris
> > 
> > 
> > ---------------------------(end of broadcast)---------------------------
> > TIP 5: Have you checked our extensive FAQ?
> > 
> > http://www.postgresql.org/docs/faqs/FAQ.html
> 
> 
> ---------------------------(end of broadcast)---------------------------
> TIP 3: if posting/reading through Usenet, please send an appropriate
> subscribe-nomail command to majordomo@postgresql.org so that your
> message can get through to the mailing list cleanly
> 

-- 
  Bruce Momjian                        |  http://candle.pha.pa.us
  pgman@candle.pha.pa.us               |  (610) 359-1001
  +  If your life is a hard drive,     |  13 Roberts Road
  +  Christ can be your backup.        |  Newtown Square, Pennsylvania 19073
FAQ