pg.ddx.io pgsql-performance@postgresql.org mailing list archive
help / color / mirror / Atom feedTablespace files deleted automatically.
3+ messages / 3 participants
[nested] [flat]
* Tablespace files deleted automatically.
@ 2011-10-13 12:52 Vishnu S. <vishnu.s@nestgroup.net>
2011-10-14 18:19 ` Re: Tablespace files deleted automatically. Josh Berkus <josh@agliodbs.com>
0 siblings, 1 reply; 3+ messages in thread
From: Vishnu S. @ 2011-10-13 12:52 UTC (permalink / raw)
To: pgsql-performance
HI,
I am using PostgreSQL 8.4 in windows. I have created a database and
some tables on it. Also created a table space and some tables in it. My
application inserts data into these tables in every second. The
application is a continuous running application. My issue is that after
a 20-30 days continuous run ( Machine logged off 2 times), some of the
files in the \16384 folder of newly created table space are dropped
automatically. Can you tell me the reason for this.? How can we
recover from this?
I have a task that delete the data(only data stored in table) from the
tables in the tablespace in certain interval. Is there any problem
related to this?
Can you tell me the reason for this?
Thanks & Regards,
Vishnu S
***** Confidentiality Statement/Disclaimer *****
This message and any attachments is intended for the sole use of the intended recipient. It may contain confidential information. Any unauthorized use, dissemination or modification is strictly prohibited. If you are not the intended recipient, please notify the sender immediately then delete it from all your systems, and do not copy, use or print. Internet communications are not secure and it is the responsibility of the recipient to make sure that it is virus/malicious code exempt.
The company/sender cannot be responsible for any unauthorized alterations or modifications made to the contents. If you require any form of confirmation of the contents, please contact the company/sender. The company/sender is not liable for any errors or omissions in the content of this message.
^ permalink raw reply [nested|flat] 3+ messages in thread
* Re: Tablespace files deleted automatically.
2011-10-13 12:52 Tablespace files deleted automatically. Vishnu S. <vishnu.s@nestgroup.net>
@ 2011-10-14 18:19 ` Josh Berkus <josh@agliodbs.com>
2011-10-17 12:04 ` Re: Tablespace files deleted automatically. Robert Klemme <shortcutter@googlemail.com>
0 siblings, 1 reply; 3+ messages in thread
From: Josh Berkus @ 2011-10-14 18:19 UTC (permalink / raw)
To: pgsql-performance
Vishnu,
> I am using PostgreSQL 8.4 in windows. I have created a database and
> some tables on it. Also created a table space and some tables in it. My
> application inserts data into these tables in every second. The
> application is a continuous running application. My issue is that after
> a 20-30 days continuous run ( Machine logged off 2 times), some of the
> files in the \16384 folder of newly created table space are dropped
> automatically. Can you tell me the reason for this.? How can we
> recover from this?
PostgreSQL creates and deletes files all the time. I don't understand
why this is a problem.
--
Josh Berkus
PostgreSQL Experts Inc.
http://pgexperts.com
^ permalink raw reply [nested|flat] 3+ messages in thread
* Re: Tablespace files deleted automatically.
2011-10-13 12:52 Tablespace files deleted automatically. Vishnu S. <vishnu.s@nestgroup.net>
2011-10-14 18:19 ` Re: Tablespace files deleted automatically. Josh Berkus <josh@agliodbs.com>
@ 2011-10-17 12:04 ` Robert Klemme <shortcutter@googlemail.com>
0 siblings, 0 replies; 3+ messages in thread
From: Robert Klemme @ 2011-10-17 12:04 UTC (permalink / raw)
To: Josh Berkus <josh@agliodbs.com>; +Cc: pgsql-performance
On Fri, Oct 14, 2011 at 8:19 PM, Josh Berkus <josh@agliodbs.com> wrote:
> Vishnu,
>
>> I am using PostgreSQL 8.4 in windows. I have created a database and
>> some tables on it. Also created a table space and some tables in it. My
>> application inserts data into these tables in every second. The
>> application is a continuous running application. My issue is that after
>> a 20-30 days continuous run ( Machine logged off 2 times), some of the
>> files in the \16384 folder of newly created table space are dropped
>> automatically. Can you tell me the reason for this.? How can we
>> recover from this?
>
> PostgreSQL creates and deletes files all the time. I don't understand
> why this is a problem.
Also it does not seem clear whether we are talking about a performance
issue (what this ML is about) or a bug (lost data).
Kind regards
robert
--
remember.guy do |as, often| as.you_can - without end
http://blog.rubybestpractices.com/
^ permalink raw reply [nested|flat] 3+ messages in thread
end of thread, other threads:[~2011-10-17 12:04 UTC | newest]
Thread overview: 3+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2011-10-13 12:52 Tablespace files deleted automatically. Vishnu S. <vishnu.s@nestgroup.net>
2011-10-14 18:19 ` Josh Berkus <josh@agliodbs.com>
2011-10-17 12:04 ` Robert Klemme <shortcutter@googlemail.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