* solAris: > Also, average time to search for a query in a table is taking about 15 > seconds. I have done indexing but the time is not reducing..... > Is there any way to reduce the time to less than 1 sec ???
How are your queries structured? Do you just compare values? Do you perform range queries? Or something like "WHERE col LIKE '%string%')? -- Florian Weimer <fwei...@bfk.de> BFK edv-consulting GmbH http://www.bfk.de/ Kriegsstraße 100 tel: +49-721-96201-1 D-76133 Karlsruhe fax: +49-721-96201-99 -- Sent via pgsql-performance mailing list (pgsql-performance@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-performance
