Re: [GENERAL] ERROR: xlog flush request 17/4D6C2720 is not satisfied

2010-11-28 Thread Sofer, Yuval
No, many free GBs on drive... More info: The problem occurred in customer site DB - Postgres version 8.2.4 OS - windows Server 2008 R2 He reported about storage problems which triggered node switch (it is postgres installation on windows 2008 cluster) But now although postgres.exe is running,

Re: [GENERAL] ERROR: xlog flush request 17/4D6C2720 is not satisfied

2010-11-28 Thread Sofer, Yuval
Hi The problem occurred in customer site DB - Postgres version 8.2.4 OS - windows Server 2008 R2 He reported about storage problems which triggered node switch (it is postgres installation on windows 2008 cluster) But now although postgres.exe is running, it is not really functioning… Yuval

[GENERAL] between SIMPLE and ENGLISH FULL TEXT Configuration in Postgresql 9.0.1.?

2010-11-28 Thread AI Rumman
What is the difference between SIMPLE and ENGLISH FULL TEXT Configuration in Postgresql 9.0.1.

Re: [GENERAL] Postgres forums ... take 2

2010-11-28 Thread Elliot Chance
Discussion will continue on the wiki page: http://wiki.postgresql.org/wiki/Forums_at_postgresql.com.au Even though the discussion has moved I still intent to keep pushing the issues to a resolution. The wiki is not shelving the idea for another time. On 23/11/2010, at 8:42 PM, Thom Brown wrote:

Re: [GENERAL] ERROR: xlog flush request 17/4D6C2720 is not satisfied

2010-11-28 Thread Scott Marlowe
On Sun, Nov 28, 2010 at 4:37 AM, Sofer, Yuval wrote: > hi > > My Postgres Server reports the next error message in log files. > > “ERROR:  xlog flush request 17/4D6C2720 is not satisfied --- flushed only to > 17/4CE03418” > > Although Server up, Postgres does not function as expected - simple comm

Re: [GENERAL] ERROR: xlog flush request 17/4D6C2720 is not satisfied

2010-11-28 Thread Vick Khera
On Sun, Nov 28, 2010 at 6:37 AM, Sofer, Yuval wrote: > Although Server up, Postgres does not function as expected - simple commands > like “select * from ” or “drop database”  fails with this error > What happened to your postgres server recently? Did it crash? Did you have a hardware failure?

[GENERAL] ERROR: xlog flush request 17/4D6C2720 is not satisfied

2010-11-28 Thread Sofer, Yuval
hi My Postgres Server reports the next error message in log files. "ERROR: xlog flush request 17/4D6C2720 is not satisfied --- flushed only to 17/4CE03418" Although Server up, Postgres does not function as expected - simple commands like "select * from " or "drop database" fails with this er

Re: [GENERAL] Question about OID and TCID

2010-11-28 Thread Matthew Walden
> So the in-place update is a vital part of the program, because a range of values > of column col should be stored together on the disk. Is there any way to do such > a in-place update without generating much extra overhead? > Although in-place update is not possible, can he not use partitioning

Re: [GENERAL] Question about OID and TCID

2010-11-28 Thread Guillaume Lelarge
Please send your answer (also) to the list. Le 28/11/2010 10:23, zhipan Wang a écrit : > [...] > Thanks a lot for your detailed reply. I am trying to implement the idea > proposed > in the paper Database Cracking. The basic idea is like this: > > When a query with a range predicate like "a col

Re: [GENERAL] Question about OID and TCID

2010-11-28 Thread Guillaume Lelarge
Le 27/11/2010 09:52, Zhipan Wang a écrit : > Hi, > > I want to access part of a table on the disk sequentially, i,e., when I get > to a tuple in the table, I need to read several pages of data in the table > starting from this tuple. You shouldn't rely on the order on disk. It will change as so

Re: [GENERAL] Question about OID and TCID

2010-11-28 Thread Dmitriy Igrishin
Hey Zhipan, 2010/11/27 Zhipan Wang > Hi, > > I want to access part of a table on the disk sequentially, i,e., when I get > to a tuple in the table, I need to read several pages of data in the table > starting from this tuple. I guess CTID could be translated to physical > address on the disk to