> This table currently has 224 rows of data in it.
>
> The following queries *ALL* take approx. .433 seconds to run.
>
> select * from status s where s.site_id = 18 and s.host_id = 49 and
> s.product = 'BETA' and s.class = 'APPS' and s.subclass = 'MONITOR' ;
> select * from status s where s.site_id = 18 and s.host_id = 49 and
> s.product = 'BETA';
> select * from status s where s.site_id = 18 and s.host_id = 49;
> select * from status s where s.site_id = 18;
> select * from status;
>
> Nothing gets triggered on a select off of this table. This table did
> have a view attached, but I dropped the view with the same results.
>
> So, I'm totally baffled as to how a simple select * on a 224-row table
> could take almost half a second to execute! Please help the neophyte.
> =)
Have you VACUUMed the table (with or without ANALYZE)? Beyond that, we
really need the results of the EXPLAIN to see what the database is doing and
how to improve on that.
Greg
---------------------------(end of broadcast)---------------------------
TIP 3: if posting/reading through Usenet, please send an appropriate
subscribe-nomail command to [EMAIL PROTECTED] so that your
message can get through to the mailing list cleanly
