from:"petchimuthu lingam"

[PERFORM] increasing shared buffer slow downs query performance.

2008-03-24 Thread petchimuthu lingam

Hi friends, I am using postgresql 8.1, I have shared_buffers = 5, now i execute the query, it takes 18 seconds to do sequential scan, when i reduced to 5000, it takes one 10 seconds, Why. Can anyone explain what is the reason, ( any other configuration is needed in postgresql.conf) -- With

[PERFORM] waiting for harddisk

2008-03-24 Thread petchimuthu lingam

i am using postgresql 8.1.8, Following configurations: shared_buffers = 5000 work_mem = 65536 maintenance_work_mem = 65536 effective_cache_size = 16000 random_page_cost = 0.1 The cpu is waiting percentage goes upto 50%, and query result

[PERFORM] partial index + select query performance

2008-03-13 Thread petchimuthu lingam

I have created partial index on a field with conditions, if field _a 200 and field_a 300. I using the select query with condition as field_a in ( 100, 250, 289, ), Will it use the index. -- With Best Regards, Petchimuthulingam S

[PERFORM] how many index can have????

2008-03-11 Thread petchimuthu lingam

I have one table with 30 fields, i have more then 60 million records, if i use more no of indexes will it affect the insertion performance? and select performance? Shall i have more then one partial index for same field, -- With Best Regards, Petchimuthulingam S

[PERFORM] join query performance

2008-03-07 Thread petchimuthu lingam

In a select query i have used the join conditions, will it affect query performance. Explicitly I didn't used the join command, Will it make any difference. My Query is: SELECT test_log.test_id, test_log.test_id, test_log.test_id, user_details.first_name, group_details.group_name,

[PERFORM] Confirmação de envio / Sending confirmation (captchaid:13266b402bd3)

2008-03-07 Thread petchimuthu lingam

VE4TQQBN -- With Best Regards, Petchimuthulingam S

[PERFORM] Re: Confirmação de envio / Sending confirmation (captchaid:13266b402f09)

2008-03-07 Thread petchimuthu lingam

VQQ7HE18 On Sat, Mar 8, 2008 at 9:50 AM, [EMAIL PROTECTED] wrote: A mensagem de email enviada para [EMAIL PROTECTED] confirmação para ser entregue. Por favor, responda este e-mail informando os caracteres que você vê na imagem abaixo. The email message sent to