| From: | Mario Weilguni <roadrunner6(at)gmx(dot)at> |
|---|---|
| To: | pgsql-performance(at)postgresql(dot)org |
| Subject: | Re: Performance Problem with postgresql 9.03, 8GB RAM,Quadcore Processor Server--Need help!!!!!!! |
| Date: | 2011-11-03 20:07:59 |
| Message-ID: | 4EB2F49F.3080903@gmx.at |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general pgsql-performance |
Am 03.11.2011 17:08, schrieb Tomas Vondra:
> On 3 Listopad 2011, 16:02, Mario Weilguni wrote:
> <snip>
> No doubt about that, querying tables using conditions on array columns is
> not the best direction in most cases, especially when those tables are
> huge.
>
> Still, the interesting part here is that the OP claims this worked just
> fine in the older version and after an upgrade the performance suddenly
> dropped. This could be caused by many things, and we're just guessing
> because we don't have any plans from the old version.
>
> Tomas
>
>
Not really, Mohamed always said he has 9.0.3, Marcus Engene wrote about
problems after the migration from 8.x to 9.x. Or did I miss something here?
Regards,
Mario
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Tony Capobianco | 2011-11-03 20:13:05 | Re: pg_dump schma while excluding specific table |
| Previous Message | Adrian Klaver | 2011-11-03 20:04:07 | Re: pg_dump schma while excluding specific table |
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Tom Lane | 2011-11-03 20:35:16 | Re: Predicates not getting pushed into SQL function? |
| Previous Message | Claudio Freire | 2011-11-03 19:53:41 | Re: Blocking excessively in FOR UPDATE |