Postgres Pro
Downloads
Home   >   mailing lists

slow select in big table - Mailing list pgsql-general

From rafalak
Subject slow select in big table
Date
Msg-id 39582c42-c0ae-44ba-a34e-dc1a1d2d5bd3@g19g2000yql.googlegroups.com
Whole thread Raw
Responses Re: slow select in big table
Re: slow select in big table
List pgsql-general
Tree view 
Hello i have big table
80mln records, ~6GB data, 2columns (int, int)

if query
select count(col1) from tab where col2=1234;
return low records (1-10) time is good 30-40ms
but when records is >1000 time is >12s


How to increse performace ?


my postgresql.conf
shared_buffers = 810MB
temp_buffers = 128MB
work_mem = 512MB
maintenance_work_mem = 256MB
max_stack_depth = 7MB
effective_cache_size = 800MB


db 8.3.7
server, atlon dual-core 2,0Ghz, 2GB RAM, SATA

pgsql-general by date:

Previous
From: Ricardo Fuentes
Date:
Subject: Hello, i want to subscribe...
Next
From: Patrick Desjardins
Date:
Subject: Re: [GENERAL] Re: [GENERAL] ERROR: XX001: could not read block 2354 of relation…