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 rea
Tom Lane wrote:
Lists 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=52848.785..5284
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 pl
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'
Heikki Linnakangas wrote:
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 c
best 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 post
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
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 li
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
al
---(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 configuration.
11 matches
Mail list logo
