Problem with large table not using indexes (I think)
[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
- Subject: Problem with large table not using indexes (I think)
- From: Benjamin Arai <benjamin@xxxxxxxxxxxx>
- Date: Sat, 23 Dec 2006 11:26:08 -0800
- User-agent: Thunderbird 1.5.0.8 (Windows/20061025)
Hi,
The largest table in my database (30GB) has mysteriously went from
taking milli-seconds to perform a query to minutes. This disks are fine
and I have a 4GB shared_memory. Could this slow down have to do with
the fsm_max_pages or something else like that? I made it larger but the
queries still taking a long time. I do daily vacuum's but I don't run
it with -z or --full. I would like to avoid doing a --full if possible
because it would literally take over a week to complete. Any help would
be greatly appreciated.
Benjamin
[Index of Archives]
[KVM ARM]
[KVM ia64]
[KVM ppc]
[Virtualization Tools]
[Spice Development]
[Libvirt]
[Libvirt Users]
[Linux USB Devel]
[Linux Audio Users]
[Yosemite Questions]
[Linux Kernel]
[Linux SCSI]
[XFree86]