I have a table that included only 472 rows and geometry of table is Multipolygon. I am sending query to database via PgAdmin III
select * from mytable // this query takes 99413 ms
This is a very long time.
What do you think about long queries on PostgreSQL? Server resource, disc, CPU etc.