Laszlo Nagy wrote:
Hello,
I'm about to buy SSD drive(s) for a database. For decision making, I
used this tech report:
http://techreport.com/articles.x/16255/9
http://techreport.com/articles.x/16255/10
Here are my concerns:
* I need at least 32GB disk space. So DRAM based SSD is not a
Josh Berkus wrote:
Tom,
Right, because they do. If you think otherwise, demonstrate it.
(bonnie tests approximating a reverse seqscan are not relevant
to the performance of indexscans.)
Working on it. I *think* I've seen this issue in the field, which is
why I brought it up in the first
Tom Lane wrote:
Lists li...@on-track.ca writes:
The query
select comment_date
from user_comments
where user_comments.uid=1
order by comment_date desc limit 1
Explain:
Limit (cost=0.00..2699.07 rows=1 width=8) (actual
time
:
Lists wrote:
Server is a dual core xeon 3GB ram and 2 mirrors of 15k SAS drives (1
for most data, 1 for wal and a few tables and indexes)
In total all databases on the server are about 10G on disk (about 2GB
in pgdump format).
I'd suggest buying as much RAM as you can fit into the server. RAM
Andrew Sullivan wrote:
On Sun, Apr 05, 2009 at 11:36:33AM -0700, Lists wrote:
*Slony-I* - I've used this in the past, but it's a huge pain to work
with, caused serious performance issues under heavy load due to long
running transactions (may not be the case anymore, it's been a while
I am looking to setup replication of my postgresql database, primarily
for performance reasons.
The searching I've done shows a lot of different options, can anyone
give suggestions about which one(s) are best? I've read the archives,
but there seems to be more replication solutions since the
depends on your requirements.
May be you can tell a bit more what your situation is?
Since you didn't gave us to much information about your requirements
it's hard to give you any advice.
Ries
On Apr 5, 2009, at 1:36 PM, Lists wrote:
I am looking to setup replication of my postgresql database
I am planning to add a tags (as in the web 2.0 thing) feature to my web
based application. I would like some feedback from the experts here on
what the best database design for that would be.
The possibilities I have come up with are:
* A tags table containing the tag and id number of what it
I have a busy postgresql server running running on a raid1 of 2 15k rpm
scsi drives.
I have been running into the problem of maxed out IO bandwidth. I would
like to convert my raid1 into a raid10 but that would require a full
rebuild which is more downtime than I want so I am looking into other
---(end of broadcast)---
TIP 6: Have you searched our list archives?
http://archives.postgresql.org
This must be a linux'ism because to my knowledge FreeBSD does not keep the
os-cache mapped into the kernel address space unless it have active objects
associated with the data.
And FreeBSD also have a default split of 3GB userspace and 1GB. kernelspace
when running with a default
11 matches
Mail list logo