Re: [GENERAL] select query takes 13 seconds to run with index

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 




The estimate is way off, when was the last time Vaccum was on the table?
about a week ago i ran this VACUUM VERBOSE ANALYZE;
this table is never updated or deleted, rows are just inserted...

You should analyze it more often, then... Postgres probably thinks the table has the same data distribution as last week !
	Analyze just takes a couple seconds...

Load on the database
how do i measure load on database?

	Just look at vmstat.

Also if you very often do SELECT .. WHERE x = ... ORDER BY id DESC you'll benefit from an index on (x,id) instead of just (x).




[Postgresql General]     [Postgresql PHP]     [PHP Users]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Books]     [PHP Databases]     [Yosemite]

  Powered by Linux