Nico Sabbi <nicola.sabbi@xxxxxxxx> wrote: > Queries get executed very very slowly, say 20 minutes. > I'd like to know if someone has already succeeded in running > postgres with 200-300M records with queries running much faster > than this. If you go to the http://wcca.wicourts.gov/ web site, bring up any case, and click the "Court Record Events" button, it will search a table with hundreds of millions of rows. The table is not partitioned, but has several indexes on it which are useful for queries such as the one that is used when you click the button. -- Kevin Grittner EDB: http://www.enterprisedb.com The Enterprise PostgreSQL Company -- Sent via pgsql-performance mailing list (pgsql-performance@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-performance
