[PERFORM] pg_autovacuum settings

  Hi,   My Secenario :   P4 with 1G of memory on Fedora Core about 100 inserts/update per hour about 100 query per minute 20 concurrent connections     1. What is the best parameter setting in the pg_autovacuum for my scenario ?   2. what will be my sleep setting if i want to

Re: [PERFORM] best practices with index on varchar column

I have an experience using LIKE in a VARCHAR column and select statement suffers a lot so I decided to go back in CHAR Note: my database has about 50 millions records a b tree index > Can I use an index on a varchar column to optimize the SELECT queries > that > use " column LIKE 'header%'

Re: [PERFORM] VACCUM FULL ANALYZE PROBLEM

would be after a vacuum full, though I expect that it wouldn't make much difference.   regards Iain - Original Message - From: Michael Ryan S. Puncia To: pgsql-performance@postgresql.org Sent: Tuesday, February 15, 2005 10:34 AM Su

[PERFORM] VACCUM FULL ANALYZE PROBLEM

Hi,   I have 3 tables in the database with 80G of data, one of them is almost 40G and the remaining 2 tables has 20G each. We use this database mainly for query and updating is done only quarterly and the database perform well. My problem is after updating and then run VACCUM FULL ANALY

[PERFORM] Changing the column length

Hi ,     I am sorry that my question is out of line with this group(performance) but I need an urgent help L …pls .. I need to know how  to change the length of the column.   Thanks and hoping that u will not ignore my question  

[PERFORM] memory allocation

Hi everyone .   How much memory should I give to the kernel and postgresql   I have 1G of memory and 120G of HD   Shared Buffers = ? Vacuum Mem = ? SHMAX = ?   Sorry I have so many question .I am a newbie L   I have 30G of data At least 30 simultaneus users But I will use it

[PERFORM] Server process

Hi,   How can I automatically kill a process in the database (ex a select or explain) if it exceeds my limit of 2 or 3 mins ..  For example : I have a query that already running for 3 or 4 mins I want to kill that process for a reason and return a Signal to the user.   Thanks Michael

[PERFORM] DB Design

Hi Guys,      My question is .. which is better design   Single Table with 50 million records or Multiple Table using inheritance to the parents table     I will use this only for query purpose ..   Thanks ..    

Re: [PERFORM] Using LIKE expression problem..

chael Ryan S. Puncia Cc: [EMAIL PROTECTED] Subject: Re: [PERFORM] Using LIKE expression problem.. Are you in a non-C locale? Chris Michael Ryan S. Puncia wrote: > Yes , I already do that but the same result .. LIKE uses seq scan > > -Original Message- > From: [EMAIL PROTECTED]

Re: [PERFORM] Using LIKE expression problem..

Yes , I already do that but the same result .. LIKE uses seq scan -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Christopher Kings-Lynne Sent: Wednesday, May 12, 2004 2:48 PM To: Michael Ryan S. Puncia Cc: [EMAIL PROTECTED] Subject: Re: [PERFORM] Using

[PERFORM] Using LIKE expression problem..

Hi everybody..     Before anything else I would like to thank all those person who answers my previous question… again thank you very much   This is my question …     In my query .. Select * from table1 where lastname LIKE  ‘PUNCIA%’..   In the query plan ..it uses seq s

[PERFORM] Help how to tune-up my Database

Hi,     I am a newbie here and just starting to use postgresql. My problems is how to tune up my server because it its too slow. We just ported from DBF to postgresql.   This is my PC specs: P4, 512Ram, Linux 9   Because I am working in a statistical organization we have a ver