Juan Casero (FL FLC) wrote:
> When I hit
> this pgsql on this laptop with a large query I can see the load spike up
> really high on both of my virtual processors. Whatever, pgsql is doing
> it looks like both cpu's are being used indepently.
Intel HT was partly a marketing thing, you don't real
Alessandro Baretta wrote:
>
> What I could do relatively easily is instantiate a thread to iteratively
> scan a traditional cursor N rows at a time, retrieving only record keys,
> and finally send them to the query-cache-manager. The application thread
> would then scan through the cursor results
Rory Campbell-Lange wrote:
The server has a 250GB RAID10 (LSI 320-I + BBU) volume which I am
thinking of slicing up in the following way (Linux 2.6 kernel):
/ : ext3 : 47GB (root, home etc)
/boot : ext3 : 1GB
/tmp : ext2 : 2GB
/usr : ext3 : 4GB
/