pg.ddx.io pgsql-admin@postgresql.org mailing list archive
help / color / mirror / Atom feedPostgreSQL 8.1.3/Windows
4+ messages / 3 participants
[nested] [flat]
* PostgreSQL 8.1.3/Windows
@ 2006-05-08 20:42 Benjamin Krajmalnik <kraj@illumen.com>
2006-05-08 20:54 ` Re: PostgreSQL 8.1.3/Windows Tom Lane <tgl@sss.pgh.pa.us>
0 siblings, 1 reply; 4+ messages in thread
From: Benjamin Krajmalnik @ 2006-05-08 20:42 UTC (permalink / raw)
To: pgsql-admin
I was looking at the files inside my database and came across files
which have the same OID number as the filename but some had extensions
(in my case .1 and .2).
What are these files? Can they be safely deleted?
In my case, they are quite large (over 1GB each).
Regards,
Benjamin
^ permalink raw reply [nested|flat] 4+ messages in thread
* Re: PostgreSQL 8.1.3/Windows
2006-05-08 20:42 PostgreSQL 8.1.3/Windows Benjamin Krajmalnik <kraj@illumen.com>
@ 2006-05-08 20:54 ` Tom Lane <tgl@sss.pgh.pa.us>
0 siblings, 0 replies; 4+ messages in thread
From: Tom Lane @ 2006-05-08 20:54 UTC (permalink / raw)
To: Benjamin Krajmalnik <kraj@illumen.com>; +Cc: pgsql-admin
"Benjamin Krajmalnik" <kraj@illumen.com> writes:
> I was looking at the files inside my database and came across files
> which have the same OID number as the filename but some had extensions
> (in my case .1 and .2).
You might care to read
http://www.postgresql.org/docs/8.1/static/storage.html
which explains all this.
regards, tom lane
^ permalink raw reply [nested|flat] 4+ messages in thread
* Re: PostgreSQL 8.1.3/Windows
@ 2006-05-08 20:44 Larry Rosenman <lrosenman@pervasive.com>
0 siblings, 0 replies; 4+ messages in thread
From: Larry Rosenman @ 2006-05-08 20:44 UTC (permalink / raw)
To: Benjamin Krajmalnik <kraj@illumen.com>; pgsql-admin
They are the 1GB segments of your tables. You should NOT delete them.
LER
--
Larry Rosenman
Database Support Engineer
PERVASIVE SOFTWARE. INC.
12365B RIATA TRACE PKWY
3015
AUSTIN TX 78727-6531
Tel: 512.231.6173
Fax: 512.231.6597
Email: Larry.Rosenman@pervasive.com
Web: www.pervasive.com
________________________________
From: pgsql-admin-owner@postgresql.org
[mailto:pgsql-admin-owner@postgresql.org] On Behalf Of Benjamin
Krajmalnik
Sent: Monday, May 08, 2006 3:42 PM
To: pgsql-admin@postgresql.org
Subject: [ADMIN] PostgreSQL 8.1.3/Windows
I was looking at the files inside my database and came across files
which have the same OID number as the filename but some had extensions
(in my case .1 and .2).
What are these files? Can they be safely deleted?
In my case, they are quite large (over 1GB each).
Regards,
Benjamin
^ permalink raw reply [nested|flat] 4+ messages in thread
* Re: PostgreSQL 8.1.3/Windows
@ 2006-05-08 20:46 Benjamin Krajmalnik <kraj@illumen.com>
0 siblings, 0 replies; 4+ messages in thread
From: Benjamin Krajmalnik @ 2006-05-08 20:46 UTC (permalink / raw)
To: Larry Rosenman <lrosenman@pervasive.com>; pgsql-admin
Thanks.
That definitely would not have been pretty :-)
________________________________
From: Larry Rosenman [mailto:lrosenman@pervasive.com]
Sent: Monday, May 08, 2006 2:45 PM
To: Benjamin Krajmalnik; pgsql-admin@postgresql.org
Subject: RE: [ADMIN] PostgreSQL 8.1.3/Windows
They are the 1GB segments of your tables. You should NOT delete them.
LER
--
Larry Rosenman
Database Support Engineer
PERVASIVE SOFTWARE. INC.
12365B RIATA TRACE PKWY
3015
AUSTIN TX 78727-6531
Tel: 512.231.6173
Fax: 512.231.6597
Email: Larry.Rosenman@pervasive.com
Web: www.pervasive.com
________________________________
From: pgsql-admin-owner@postgresql.org
[mailto:pgsql-admin-owner@postgresql.org] On Behalf Of Benjamin
Krajmalnik
Sent: Monday, May 08, 2006 3:42 PM
To: pgsql-admin@postgresql.org
Subject: [ADMIN] PostgreSQL 8.1.3/Windows
I was looking at the files inside my database and came across files
which have the same OID number as the filename but some had extensions
(in my case .1 and .2).
What are these files? Can they be safely deleted?
In my case, they are quite large (over 1GB each).
Regards,
Benjamin
^ permalink raw reply [nested|flat] 4+ messages in thread
end of thread, other threads:[~2006-05-08 20:54 UTC | newest]
Thread overview: 4+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2006-05-08 20:42 PostgreSQL 8.1.3/Windows Benjamin Krajmalnik <kraj@illumen.com>
2006-05-08 20:54 ` Tom Lane <tgl@sss.pgh.pa.us>
2006-05-08 20:44 Re: PostgreSQL 8.1.3/Windows Larry Rosenman <lrosenman@pervasive.com>
2006-05-08 20:46 Re: PostgreSQL 8.1.3/Windows Benjamin Krajmalnik <kraj@illumen.com>
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox