| From: | G u i d o B a r o s i o <gbarosio(at)uolsinectis(dot)com(dot)ar> |
|---|---|
| To: | pgsql-performance(at)postgresql(dot)org |
| Cc: | pgsql-admin(at)postgresql(dot)org |
| Subject: | Temporary tables |
| Date: | 2004-08-05 14:33:20 |
| Message-ID: | 20040805143320.70E4A6C695@tino.sinectis.com.ar |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-admin pgsql-performance |
The box:
Linux 2.4.24-ck1
8 Intel(R) Xeon(TM) MP CPU 2.80GHz
4 gb RAM.
Postgresql 7.4.2
The problem:
Short in disk space. (waiting new hard)
The real problem:
Developers usually write queries involving the creation of temporary tables.
The BF question:
Is a good idea to link this tmp tables to another partition?
If so, how can I link this tmp tables to another partition?
Suggestions?
Thanks in advance!
Guido
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Gaetano Mendola | 2004-08-05 15:37:50 | Re: Temporary tables |
| Previous Message | Tom Lane | 2004-08-05 14:03:43 | Re: pg_dump: schema with OID 1 does not exist |
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Steinar H. Gunderson | 2004-08-05 15:04:03 | Re: Performance Bottleneck |
| Previous Message | Merlin Moncure | 2004-08-05 13:26:29 | Re: [GENERAL] Tuning queries on large database |