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


---------------------------(end of broadcast)---------------------------
TIP 5: Have you checked our extensive FAQ?

http://www.postgresql.org/docs/faqs/FAQ.html

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

Sure, use contrib/oid2name.

Do you run VACUUM regularly?

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)


---------------------------(end of broadcast)---------------------------
TIP 5: Have you checked our extensive FAQ?

http://www.postgresql.org/docs/faqs/FAQ.html