| From: | Grzegorz Jaśkiewicz <gryzman(at)gmail(dot)com> |
|---|---|
| To: | Grant Masan <grant(dot)massan(at)gmail(dot)com> |
| Cc: | pgsql-general(at)postgresql(dot)org |
| Subject: | Re: [PERFORM] Problem with database performance, Debian 4gb ram ? |
| Date: | 2009-11-02 14:33:52 |
| Message-ID: | 2f4958ff0911020633o3be6d49dy9c22da9c322b0e9f@mail.gmail.com |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general pgsql-performance |
2009/11/2 Grant Masan <grant(dot)massan(at)gmail(dot)com>
> Size is "6154 MB". I have checked all queries, and those are as good as
> they can be in this situation. You think that this confs doesn't make really
> no difference at all ?
>
> you gotta hit 'reply all' next time ;)
configuration makes difference, but you need to know what is your issue
before you start changing stuff randomly.
try using pg_tune , that should give you good config for your hardware.
--
GJ
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Tom Lane | 2009-11-02 14:38:00 | Re: Cancelling Requests Frontend/Backend Protocol TCP/IP |
| Previous Message | Merlin Moncure | 2009-11-02 14:33:16 | Re: array_reverse() |
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Anj Adu | 2009-11-02 16:14:44 | Re: database size growing continously |
| Previous Message | Ivan Voras | 2009-11-02 14:22:03 | Re: Problem with database performance, Debian 4gb ram ? |