Re: [PERFORM] SELECT AND AGG huge tables

2012-10-17 Thread houmanb
Hi all, Thanks for your advice and the link about posting my question in an appropriate form. Here are the info. I thank all of you in advance. Best regards Houman Postgres version: 9.1.4 = Postgres.conf max_connections = 100 shared_buffers = 8192

[PERFORM] SELECT AND AGG huge tables

2012-10-15 Thread houmanb
Dear all, We have a DB containing transactional data. There are about *50* to *100 x 10^6* rows in one *huge* table. We are using postgres 9.1.6 on linux with a *SSD card on PCIex* providing us a constant seeking time. A typical select (see below) takes about 200 secs. As the database is the back