| From: | Christian Schröder <cs(at)deriva(dot)de> |
|---|---|
| To: | Scott Marlowe <scott(dot)marlowe(at)gmail(dot)com> |
| Cc: | Grzegorz Jaśkiewicz <gryzman(at)gmail(dot)com>, Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>, pgsql-general(at)postgresql(dot)org |
| Subject: | Re: Performance of subselects |
| Date: | 2009-03-09 10:45:38 |
| Message-ID: | 49B4F352.40001@deriva.de |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
Scott Marlowe wrote:
>> you can run out of memory if too many connections try to use too much
>> of it at the same time, that's why it is advisable to set work_mem per
>> connection/query, should the connection/query require more.
>>
> Definitely.
>
I understand why this is advisable; however, something inside me hates
the idea to put this kind of database specific stuff inside an
application. How about portability? Why does the application developer
have to know about database internals? He knows sql, that should be
sufficient.
I have the (maybe naive) idea of a clear separation of database
administration (including performance tuning) and application
development. Is this idea completely wrong?
Regards,
Christian
--
Deriva GmbH Tel.: +49 551 489500-42
Financial IT and Consulting Fax: +49 551 489500-91
Hans-Böckler-Straße 2 http://www.deriva.de
D-37079 Göttingen
Deriva CA Certificate: http://www.deriva.de/deriva-ca.cer
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Grzegorz Jaśkiewicz | 2009-03-09 11:13:47 | Re: Performance of subselects |
| Previous Message | Ashish Karalkar | 2009-03-09 10:34:05 | Re: commit/rollback in postgre 8.2 |