Обсуждение: Re: Howto Setup a good PostgreSQL Server

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
>

Is there a good way to tell how much physical space a table takes on
disk?  Thanks

Kris

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" <kris@musicrebellion.com>
Cc: <pgsql-admin@postgresql.org>
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

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" <kris@musicrebellion.com>
> Cc: <pgsql-admin@postgresql.org>
> 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