Re: [PERFORM] Improving performance on system catalog

2007-03-28 Thread Daniel Cristian Cruz
2007/3/28, Tom Lane <[EMAIL PROTECTED]>: "Daniel Cristian Cruz" <[EMAIL PROTECTED]> writes: > 2007/3/28, chris smith <[EMAIL PROTECTED]>: >>> Total runtime: 13.844 ms >> >> Why bother? > Because faster could be better in a very busy system. If you are concerned about global performance improve

Re: [PERFORM] Improving performance on system catalog

2007-03-28 Thread Tom Lane
"Daniel Cristian Cruz" <[EMAIL PROTECTED]> writes: > 2007/3/28, chris smith <[EMAIL PROTECTED]>: >>> Total runtime: 13.844 ms >> >> Why bother? > Because faster could be better in a very busy system. If you are concerned about global performance improvement, quit worrying about this micro-detail

Re: [PERFORM] Improving performance on system catalog

2007-03-28 Thread Joshua D. Drake
Daniel Cristian Cruz wrote: Hi all. I would like to speed up this query: EXPLAIN ANALYZE SELECT relid,schemaname,relname,seq_scan,seq_tup_read,idx_scan,idx_tup_fetch,n_tup_ins,n_tup_upd,n_tup_del FROM pg_stat_user_tables; Although optimizing for 13ms is a little silly imo, you could prob

Re: [PERFORM] Improving performance on system catalog

2007-03-28 Thread Daniel Cristian Cruz
2007/3/28, chris smith <[EMAIL PROTECTED]>: > Total runtime: 13.844 ms Why bother? Because faster could be better in a very busy system. -- Daniel Cristian Cruz Analista de Sistemas

Re: [PERFORM] Improving performance on system catalog

2007-03-28 Thread chris smith
I would like to speed up this query: Total runtime: 13.844 ms Why bother? It's running in less than 14 milliseconds. -- Postgresql & php tutorials http://www.designmagick.com/ ---(end of broadcast)--- TIP 7: You can help support the Postgr

[PERFORM] Improving performance on system catalog

2007-03-28 Thread Daniel Cristian Cruz
Hi all. I would like to speed up this query: EXPLAIN ANALYZE SELECT relid,schemaname,relname,seq_scan,seq_tup_read,idx_scan,idx_tup_fetch,n_tup_ins,n_tup_upd,n_tup_del FROM pg_stat_user_tables; QUERY PLAN