Re: [PERFORM] How much work_mem to configure...

2008-07-05 Thread Scott Marlowe
On Sat, Jul 5, 2008 at 5:24 AM, Jessica Richard <[EMAIL PROTECTED]> wrote: > How can I tell if my work_mem configuration is enough to support all > Postgres user activities on the server I am managing? > > Where do I find the indication if the number is lower than needed. You kinda have to do some

[PERFORM] filesystem options for WAL

2008-07-05 Thread Jaime Casanova
Hi, Here http://www.westnet.com/~gsmith/content/postgresql/TuningPGWAL.htm I read: """ Combining these two, an optimal fstab for the WAL might look like this: /dev/hda2 /var ext3 defaults,writeback,noatime 1 2 """ Is this info accurate? I also read on other document from the "technical document

Re: [PERFORM] Subquery WHERE IN or WHERE EXISTS faster?

2008-07-05 Thread Sergio Gabriel Rodriguez
Hi Ulrich, do you try with SELECT p.speed FROM processor p INNER JOIN users_processors up ON p.id=up.processorid AND up.userid=1 ? Or your question is only about IN and EXIST? regards, Sergio Gabriel Rodriguez Corrientes - Argentina http://www.3trex.com.ar On Sat, Jun 28,

Re: [PERFORM] Subquery WHERE IN or WHERE EXISTS faster?

2008-07-05 Thread Sergio Gabriel Rodriguez
Hi Ulrich, do you try with SELECT p.speed FROM processor p INNER JOIN users_processors up ON p.id=up.processorid AND up.userid=1 ? Or your question is only about IN and EXIST? regards, Sergio Gabriel Rodriguez Corrientes - Argentina http://www.3trex.com.ar On Mon, Jun 30,

[PERFORM] How much work_mem to configure...

2008-07-05 Thread Jessica Richard
How can I tell if my work_mem configuration is enough to support all Postgres user activities on the server I am managing? Where do I find the indication if the number is lower than needed. Thanks, Jessica

Re: [PERFORM] [QUESTION]Concurrent Access

2008-07-05 Thread Chris Browne
[EMAIL PROTECTED] ("LevĂ­ Teodoro da Silva") writes: > Hi guys, How are you ? > I am from Brazil and i work for a little company and it company is working is > medium-big project and we want to use PostGree like the DataBase > system, but i got some questions. > I want to know if the PostGree has l