> I'm new in PostgreSQL Business, therefore please forgive me a "newbie" > Question. I have a table with ca. 1.250.000 Records. When I execute > a "select count (*) from table" (with pgAdmin III) it takes about 40 > secs. > I think that takes much to long. Can you please give me hints, where > I can search for Improvements? > TIA, Det maybe try change shared_buffers and test it, or you can create trigger on this table after insert and delete if insert then increse value in another table "counts" if delete then decrese and now you dont must execute select count(*) ... but execute select my_count from counts where tablename='your_table' sj ---------------------------(end of broadcast)--------------------------- TIP 2: Don't 'kill -9' the postmaster
