> We have a GUI that let user browser through the record page by page at
> about 25 records a time. (Don't ask me why but we have to have this
> GUI). This translates to something like
> select count(*) from table <-- to give feedback about the DB size
> select * from table order by date limit 25 offset 0
Heh, sounds like phpPgAdmin...I really should do something about that.
> Tables seems properly indexed, with vacuum and analyze ran regularly.
> Still this very basic SQLs takes up to a minute run.
Yes, COUNT(*) on a large table is always slow in PostgreSQL. Search the
mailing lists for countless discussions about it.
In response to
pgsql-performance by date
|Next:||From: Christopher Kings-Lynne||Date: 2005-10-27 01:46:14|
|Subject: Re: browsing table with 2 million records|
|Previous:||From: Steinar H. Gunderson||Date: 2005-10-27 00:57:15|
|Subject: Re: Materializing a sequential scan|