Re: [PERFORM] selecting data from information_schema.columns

2006-10-02 Thread Steve Martin
uld like to try to be a bit more intelligent about when the update statements are executed. Regards Steve Martin Jim C. Nasby wrote: On Sun, Oct 01, 2006 at 11:01:19PM -0400, Tom Lane wrote: Steve Martin <[EMAIL PROTECTED]> writes: I am trying to determine if there is a way

[PERFORM] selecting data from information_schema.columns performance.

2006-10-01 Thread Steve Martin
)::text = 't_fph_tdrdw'::text) -> Bitmap Index Scan on my_information_schema_columns_index (cost=0.00..2.42 rows=119 width=0) (actual time=0.149..0.149 rows=47 loops=1) Index Cond: ((table_name)::text = 't_fph_tdrdw'::text) Total runtime: 0.691 ms