Re: [GENERAL] Problems with memory

2008-05-08 Thread Shane Ambler
Richard Huxton wrote: Pau Marc Munoz Torres wrote: Hi To your initial question all configurable options can be found and adjusted in the postgresql.conf which can be found in the top of your data dir. You can find more detail on what the options are for at http://www.postgresql.org/docs/8.

Re: [GENERAL] Problems with memory

2008-05-08 Thread Richard Huxton
Pau Marc Munoz Torres wrote: Hi maybe i should give you some more explanations of my problem. The reason for which i think that postgresql run out of memory is that: I have a relation with 6 fields, 29 indexes and 32000 registers, the registers where made up using a pgsql language to save disk

Re: [GENERAL] Problems with memory

2008-05-08 Thread Pau Marc Munoz Torres
Hi maybe i should give you some more explanations of my problem. The reason for which i think that postgresql run out of memory is that: I have a relation with 6 fields, 29 indexes and 32000 registers, the registers where made up using a pgsql language to save disk space, and they "work" (see the

[GENERAL] Problems with memory

2008-05-07 Thread Pau Marc Munoz Torres
Hi I'm setting up a big database , and when i say big, i mean BIG, the problem with this is that some times, when a do a query the database run out of memory, so I really need to increase the amount of memory reserved to postgress almost 10x, could anyone tell me how can i do that? i mean, what c

Re: [GENERAL] Problems with memory

2008-05-07 Thread Merlin Moncure
On Wed, May 7, 2008 at 11:55 AM, Pau Marc Munoz Torres <[EMAIL PROTECTED]> wrote: > Hi > > I'm setting up a big database , and when i say big, i mean BIG, the problem > with this is that some times, when a do a query the database run out of > memory, so I really need to increase the amount of memo

Re: [GENERAL] Problems with memory

2008-05-07 Thread Richard Huxton
Pau Marc Munoz Torres wrote: Hi I'm setting up a big database , and when i say big, i mean BIG, I have to say, I've seen more accurate stats given. How many Terabytes are we talking about? > the problem with this is that some times, when a do a query the database run out of memory, Wha

[GENERAL] Problems with memory

2008-05-07 Thread Pau Marc Munoz Torres
Hi I'm setting up a big database , and when i say big, i mean BIG, the problem with this is that some times, when a do a query the database run out of memory, so I really need to increase the amount of memory reserved to postgress almost 10x, could anyone tell me how can i do that? i mean, what c

Re: [GENERAL] problems with memory

2000-02-18 Thread selkovjr
> * Dean Browett <[EMAIL PROTECTED]> [000218 15:55] wrote: > > Hi, > > > > We are running postgres-6.5.3 on a dual pentium 300 machine, 0.5Gb RAM under > > Linux Redhat 6.0 (kernel 2.2.14). The machine we are using sits on a 100Mb > > network and the nics are 3com3c590's. We are also using a DPT

Re: [GENERAL] problems with memory

2000-02-18 Thread Alfred Perlstein
* Dean Browett <[EMAIL PROTECTED]> [000218 15:55] wrote: > Hi, > > We are running postgres-6.5.3 on a dual pentium 300 machine, 0.5Gb RAM under > Linux Redhat 6.0 (kernel 2.2.14). The machine we are using sits on a 100Mb > network and the nics are 3com3c590's. We are also using a DPT Raid > contr

[GENERAL] problems with memory

2000-02-18 Thread Dean Browett
Hi, We are running postgres-6.5.3 on a dual pentium 300 machine, 0.5Gb RAM under Linux Redhat 6.0 (kernel 2.2.14). The machine we are using sits on a 100Mb network and the nics are 3com3c590's. We are also using a DPT Raid controller in a raid5 configuration set up as 1 logical drive. We are try