[GENERAL] statistics buffer is full on heavily loaded 8.1.4 db.

2006-09-19 Thread Eci Souji
We have a 4x 2.4ghz Opteron box w/ 8 gigs of ram running a very busy pg 8.1.4 server. Upon startup we see around 15-20 statistics buffer is full messages and they repeat at random times throughout the day. During peak times the box sometimes seems to grind to a halt. Any thoughts? - E

Re: [GENERAL] statistics buffer is full on heavily loaded 8.1.4 db.

2006-09-19 Thread Eci Souji
= on #stats_reset_on_server_start = off - E Joshua D. Drake wrote: Eci Souji wrote: We have a 4x 2.4ghz Opteron box w/ 8 gigs of ram running a very busy pg 8.1.4 server. Upon startup we see around 15-20 statistics buffer is full messages and they repeat at random times throughout the day. During peak times

[GENERAL] Scaleable DB structure for counters...

2006-07-16 Thread Eci Souji
So we've got a table called books and we want to build records of how often each book is accessed and when. How would you store such information so that it wouldn't become a huge unmanageable table? Before I go out trying to plan something like this I figured I'd ask and see if anyone had any

Re: [GENERAL] Scaleable DB structure for counters...

2006-07-16 Thread Eci Souji
/ the postgresql documentation. Harald On 7/16/06, *Eci Souji* [EMAIL PROTECTED] mailto:[EMAIL PROTECTED] wrote: So we've got a table called books and we want to build records of how often each book is accessed and when. How would you store such information so that it wouldn't

Re: [GENERAL] Scaleable DB structure for counters...

2006-07-16 Thread Eci Souji
. Time of day, days of week, etc. This is why I was looking into how to construct some form of counter system that would allow us to keep track of accesses. Although I would love to see a robot librarian at work. :-) - E Ron Johnson wrote: -BEGIN PGP SIGNED MESSAGE- Hash: SHA1 Eci

Re: [GENERAL] DB structure for logically similar objects in different

2006-05-30 Thread Eci Souji
Roman Neuhauser wrote: # [EMAIL PROTECTED] / 2006-05-29 08:10:43 -0400: Roman Neuhauser wrote: # [EMAIL PROTECTED] / 2006-05-28 16:13:20 -0400: Basically we've got several different states that an item can be in. From what I've seen the way many places seem to deal with them is

Re: [GENERAL] DB structure for logically similar objects in different

2006-05-29 Thread Eci Souji
Roman Neuhauser wrote: # [EMAIL PROTECTED] / 2006-05-28 16:13:20 -0400: Basically we've got several different states that an item can be in. From what I've seen the way many places seem to deal with them is something along the lines of making bool values that act as switches... Ex: table

Re: [GENERAL] DB structure for logically similar objects in different

2006-05-29 Thread Eci Souji
Chris wrote: Eci Souji wrote: Hi, I was wondering if anyone had any experience with this type of setup and could share what they've learned. Basically we've got several different states that an item can be in. From what I've seen the way many places seem to deal with them is something along

Re: [GENERAL] Free 1000 Rupee bank note

2006-05-29 Thread Eci Souji
Perhaps it was in reference to Hyrule Rupees? :) http://en.wikipedia.org/wiki/Rupee_(Legend_of_Zelda) Ben wrote: ...and as I learned the last time I returned from India, no bank outside of India will exchange rupees, because it's technically illegal to take rupees outside the country. So

[GENERAL] DB structure for logically similar objects in different states...

2006-05-28 Thread Eci Souji
Hi, I was wondering if anyone had any experience with this type of setup and could share what they've learned. Basically we've got several different states that an item can be in. From what I've seen the way many places seem to deal with them is something along the lines of making bool values