Обсуждение: Possibly stupid questions re: large tables/files, port 5432 access

Hi, folks....

There is a file located at

  /usr/local/pgsql/data/base/26920/

named 35987 that is roughly 750mb. Is there any way to find out what
table or database this file belongs to? I really shouldn't have that
much data in any of my tables, so I'm fairly certain that this is a bug
in my code.

Things are running very sloooowly, and I think that the size of this
file/table/whatever is partly to blame. It used to run really quickly
but performance has deteriorated over time.

Also, I'd like to use the EMS front end for managing my database, but
it seems that port 5432 isn't enabled, or my server isn't accepting
connections on that port. My server is in a data center and there is no
firewall between m Is there a FAQ or HOWTO for configuring this?

Many thanks,

Michael

On Thu, Oct 14, 2004 at 02:00:51PM -0700, Michael Holden wrote:

> There is a file located at
>
>  /usr/local/pgsql/data/base/26920/
>
> named 35987 that is roughly 750mb. Is there any way to find out what
> table or database this file belongs to?

Sure, use contrib/oid2name.

> I really shouldn't have that much data in any of my tables, so I'm
> fairly certain that this is a bug in my code.

Do you run VACUUM regularly?

> Also, I'd like to use the EMS front end for managing my database, but
> it seems that port 5432 isn't enabled, or my server isn't accepting
> connections on that port.

Look for the tcpip_socket option in postgresql.conf.

--
Alvaro Herrera (<alvherre[a]dcc.uchile.cl>)
"The West won the world not by the superiority of its ideas or values
or religion but rather by its superiority in applying organized violence.
Westerners often forget this fact, non-Westerners never do."
(Samuel P. Huntington)