bristol@mailman.lug.org.uk
To subscribe or unsubscribe via the World Wide Web, visit
https://mailman.lug.org.uk/mailman/listinfo/bristol
or, via email, send a message with subject or body 'help' to
bristol-request@mailman.lug.org.uk
You can reach the person managing the list at
bristol-owner@mailman.lug.org.uk
When replying, please edit your Subject line so it is more specific
than "Re: Contents of Bristol digest..."
Today's Topics:
1. Re: Postgres optimised h/w (Martin Moore)
----------------------------------------------------------------------
Message: 1
Date: Fri, 16 Dec 2016 11:55:27 +0000
From: Martin Moore <martinm@it-helps.co.uk>
To: mark chard <machard.1984@gmail.com>, Bristol and Bath Linux User
Group <bristol@mailman.lug.org.uk>
Subject: Re: [bristol] Postgres optimised h/w
Message-ID: <90E5BDF5-4091-4845-BD63-19DFEC0EF931@it-helps.co.uk>
Content-Type: text/plain; charset="utf-8"
I was advised to use 32bit for compatibility reasons IIRC. No problem to go 64bit if it's advantageous and won't give me any grief with my s/w though.
From: mark chard <machard.1984@gmail.com>
Date: Friday, 16 December 2016 at 11:45
To: Bristol and Bath Linux User Group <bristol@mailman.lug.org.uk>, Martin Moore <martinm@it-helps.co.uk>
Subject: Re: [bristol] Postgres optimised h/w
Why are you using a 686-pae kernel?
On 16 Dec 2016 11:03 am, "Martin Moore via Bristol" <bristol@mailman.lug.org.uk> wrote:
Morning all.
I have a potential requirement for a Debian/Postgres 9.3 server that will handle a relatively high number of unindexable queries (co-ord based, I'll look at GIS but not sure it'll help) that take some time – currently about 6 secs with one query (although that is with a lot of redundant data which I'm currently removing). There could be 50k queries/day. Writes will be minimum. I'll look at further tuning the query, but as it's a function I can't seem to get any plan details for it ☹
So, 1st question – will the 4Gb per process limit of the 32bit pae kernel limit the caching of the database which will be in the 10's of Gb.
Are SSD's now at a stage where they're suitable/reliable for this use – am I safer using RAID 1 mdadm with 1 ssd and 1 hdd (how will it know use the ssd for reads?)
And I presume as much RAM as will fit in the box!
Any other thoughts welcome.
Martin.
_______________________________________________
Bristol mailing list
Bristol@mailman.lug.org.uk
https://mailman.lug.org.uk/mailman/listinfo/bristol
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <https://mailman.lug.org.uk/mailman/private/bristol/attachments/20161216/ffd99475/attachment-0001.html>
------------------------------
Subject: Digest Footer
_______________________________________________
Bristol mailing list
Bristol@mailman.lug.org.uk
https://mailman.lug.org.uk/mailman/listinfo/bristol
------------------------------
End of Bristol Digest, Vol 673, Issue 5
***************************************
Tidak ada komentar:
Posting Komentar