| From: | Patrick(dot)FICHE(at)AQSACOM(dot)COM |
|---|---|
| To: | pgsql-general(at)postgresql(dot)org |
| Subject: | Use of temporary tables in functions |
| Date: | 2005-04-21 13:33:19 |
| Message-ID: | 1DC6C8C88D09D51181A40002A5286929B22DCA@intranet |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
Hi,
I had some issues with previous versions of Postgresql using temporary
tables in functions.
The main issue was that the both indexes pg_attribute_relid_attnam_index and
pg_attribute_relid_attnum_index were always growing and I had to restart
postgresql in single mode and run a REINDEX command to free some space on
the disk.
Does the problem still exist in version 8 ?
Thanks for your answers.
Patrick
----------------------------------------------------------------------------
---------------
Patrick Fiche
email : patrick(dot)fiche(at)aqsacom(dot)com
tél : 01 69 29 36 18
----------------------------------------------------------------------------
---------------
| From | Date | Subject | |
|---|---|---|---|
| Next Message | syed magthum | 2005-04-21 13:42:46 | Suggestions |
| Previous Message | Dinesh Pandey | 2005-04-21 13:25:31 | Re: List of Functions |