Re: Tablespace files deleted automatically.
| От | Robert Klemme |
|---|---|
| Тема | Re: Tablespace files deleted automatically. |
| Дата | |
| Msg-id | CAM9pMnO2pf+wxV1hzLBAQP6ttW+fNMK1rWeSE9ZOWnYN7q6VAQ@mail.gmail.com обсуждение исходный текст |
| Ответ на | Re: Tablespace files deleted automatically. (Josh Berkus <josh@agliodbs.com>) |
| Список | 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/
В списке pgsql-performance по дате отправления: