| From: | John Wiencek <jwiencek3(at)comcast(dot)net> |
|---|---|
| To: | Ebin Jozer <ebinjozer(at)gmail(dot)com> |
| Cc: | pgsql-admin <pgsql-admin(at)lists(dot)postgresql(dot)org> |
| Subject: | Re: need suggestion on querying big tables |
| Date: | 2022-12-05 14:50:17 |
| Message-ID: | 74322C20-BFDD-484A-9566-1644480F8253@comcast.net |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-admin |
Verify that your statistics are current.
John
> On Dec 5, 2022, at 12:29 AM, Ebin Jozer <ebinjozer(at)gmail(dot)com> wrote:
>
> Hi Team,
> in postgresql 11 version we have two tables of size 435 GB and 347 GB.
> if we query on single table or if we are doing inner join on both the big tables, it is not displacing any output, it keeps running
>
> We can see the wait event is IO and directDatafile .
>
> Server Spec : 8 cores and 64GB RAM
> PG config : 53 GB(effective_cache), 12 GB(shared buffer)
>
> can you please suggest some ideas , how we can query on big tables and fasten them to get the output??
>
> Thanks & Regards,
> Ebin
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Mladen Gogala | 2022-12-06 02:08:39 | Re: need suggestion on querying big tables |
| Previous Message | Ron | 2022-12-05 14:45:08 | Re: need suggestion on querying big tables |