Re: [PERFORM] Sun Fire T2000 and PostgreSQL 8.1.3

2006-04-05 Thread August Zajonc
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

Re: [PERFORM] Suspending SELECTs

2006-01-22 Thread August Zajonc
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

Re: [PERFORM] LVM and Postgres

2005-12-06 Thread August Zajonc
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 /