13:58 < tieTYT> i'm using postgresql on windows xp. Windows XP is telling me it's paging 100 times per second but that it has 400,000K of
memory available. What does this mean?
14:04 < aydiosmio> tieTYT: this probably isn'tthe best place to ask
14:05 < gnari> tieTYT, does this only happen when you are using postgresql ?
14:06 < gnari> tieTYT, possibly you could get some advice on #postgresql
14:07 < tieTYT> gnari: i have no idea. I'm just looking now. I asked in #hardware and they said "windows likes to page"
14:08 < gnari> tieTYT, do you feel like there is a loss of performance?
14:08 < tieTYT> gnari: i'm importing 5gigs of data so any little loss of performance is significant
14:09 < tieTYT> gnari: plus it's difficult to compare since tweaks take 2 hours to see benefits from
14:09 < aydiosmio> you're running postgres on windows and you're concerned about performance?
14:09 < gnari> tieTYT, i can imagine
14:09 < tieTYT> aydiosmio: well this is just a test box. The real thing will be on a linux server with 16gb of ram
14:09 < aydiosmio> tieTYT: run it in vmware instead
14:10 < tieTYT> aydiosmio: i think that'll slow things down even more
14:10 < tieTYT> vmware without using postgresql is slow enough
14:10 < aydiosmio> I don't think so. postgres on windows is hardly mature
14:10 < aydiosmio> which is probably why you're paging so much
14:10 < aydiosmio> and using an entirely differentplatform and build tree for testing?
14:11 < aydiosmio> you've got to be kidding yourself
14:11 < tieTYT> aydiosmio: only because the server i'll be using isn't available to use yhet
14:11 < tieTYT> yet
14:11 < aydiosmio> which is why they invented virtualization software:)
14:11 < aydiosmio> if it's really not an option, ask in #postgresql, try to find some developers on the windows port
14:12 < tieTYT> aydiosmio: yeah but when I use the vmware without doing heavy stuff it's really slow
14:12 < aydiosmio> the linux version is entirely different when it comes to memory management
14:12 < tieTYT> i think it'll be ridiculous trying to import 5 gigs from it
14:12 < aydiosmio> I'm gonna have to put my hands up on this one
14:12 < tieTYT> aydiosmio: that's good to hear and makes me very happy :)
14:12 < tieTYT> aydiosmio: sorry, thanks a lot for the help
14:13 < tieTYT> aydiosmio: i think in 2-3 days i'll be able to work on the server
14:13 < aydiosmio> alright