they don't get in
the way, they do the right thing in the minimal case, and they give the
advanced user a lot more choices about multiple DB instances on the same
machine.
Cheers,
Andrew McMillan
On Tue, 2007-04-10 at 15:28 -0400, Steve wrote:
I'm trying to tune the memory usage of a new machine that has a -lot- of
memory in it (32 gigs).
...
shared_buffers = 16GB
Really?
Wow!
Common wisdom in the past has been that values above a couple of hundred
MB will degrade performance.
...
This makes the SQL quite nicely readable.
Regards,
Andrew McMillan.
-
Andrew @ Catalyst .Net .NZ Ltd, PO Box 11-053, Manners St, Wellington
WEB: http://catalyst.net.nz/PHYS: Level
.
Regards,
Andrew McMillan.
-
Andrew @ Catalyst .Net .NZ Ltd, PO Box 11-053, Manners St, Wellington
WEB: http://catalyst.net.nz/PHYS: Level 2, 150-154 Willis St
DDI: +64(4
On Thu, 2005-07-28 at 16:13 -0800, Matthew Schumacher wrote:
Ok, I finally got some test data together so that others can test
without installing SA.
The schema and test dataset is over at
http://www.aptalaska.net/~matt.s/bayes/bayesBenchmark.tar.gz
I have a pretty fast machine with a
On Fri, 2005-06-03 at 11:45 -0700, Steve Poe wrote:
I have a small business client that cannot afford high-end/high quality
RAID cards for their next server. That's a seperate argument/issue right
there for me, but what the client wants is what the client wants.
Has anyone ran Postgres with
On Wed, 2005-06-01 at 20:42 -0700, Stacy White wrote:
We're in the process of buying another Opteron server to run Postgres, and
based on the suggestions in this list I've asked our IT director to get an
LSI MegaRaid controller rather than one of the Adaptecs.
But when we tried to place our
On Thu, 2005-06-02 at 14:02 -0700, [EMAIL PROTECTED] wrote:
I have a similar question about what to choose (either LSI or Adaptec U320),
but
plan to use them just for JBOD drivers. I expect to be using either net or
freebsd. The system CPU will be Opteron. My impression is that both the
,
Andrew McMillan.
-
Andrew @ Catalyst .Net .NZ Ltd, PO Box 11-053, Manners St, Wellington
WEB: http://catalyst.net.nz/PHYS: Level 2, 150-154 Willis St
DDI: +64(4)803-2201 MOB: +64(272
, and removing it will only
make a small difference.
Regards,
Andrew McMillan.
-
Andrew @ Catalyst .Net .NZ Ltd, PO Box 11-053, Manners St, Wellington
WEB: http://catalyst.net.nz
detailed output though.
As a quick hack, it's possible that you could improve things by
increasing the samples on relevant columns with some judicious ALTER
TABLE ... ALTER COLUMN ... SET STATISTICS ... commands.
Cheers,
Andrew McMillan
On Wed, 2004-12-01 at 09:16 -0200, Rodrigo Carvalhaes wrote:
I am using PostgreSQL with a proprietary ERP software in Brazil. The
database have around 1.600 tables (each one with +/- 50 columns).
...
max_fsm_pages = 2
max_fsm_relations = 1000
Hi,
I doubt that this will improve your
On Wed, 2004-11-24 at 14:14 +0100, Evilio del Rio wrote:
Hi,
I have installed the dspam filter
(http://www.nuclearelephant.com/projects/dspam) on our mail server
(RedHat 7.3 Linux with sendmail 8.13 and procmail). I have ~300 users
with a quite low traffic of 4000 messages/day. So it's a
On Fri, 2004-11-05 at 12:46 +0530, Antony Paul wrote:
Hi all,
I have a table which have more than 20 records. I need to get
the records which matches like this
where today::date = '2004-11-05';
This is the only condition in the query. There is a btree index on the
column today.
On Wed, 2004-10-20 at 11:53 +1000, Brock Henry wrote:
Test 1, For each import, I'm dropping all indexes and pkeys/fkeys,
then importing, then adding keys and indexes. Then I've got successive
runs. I figure the reindexing will get more expensive as the database
grows?
Sounds like the right
.
Regards,
Andrew McMillan
-
Andrew @ Catalyst .Net .NZ Ltd, PO Box 11-053, Manners St, Wellington
WEB: http://catalyst.net.nz/PHYS: Level 2, 150-154 Willis St
DDI: +64(4)803
,
Andrew McMillan
shared_buffers = 2000 # min 16, at least max_connections*2, 8KB
each
sort_mem = 12288# min 64, size in KB
# - Free Space Map -
max_fsm_pages = 10 # min max_fsm_relations*16, 6 bytes each
#max_fsm_relations = 1000 # min 100, ~50
On Wed, 2004-05-19 at 15:37 +0800, Michael Ryan S. Puncia wrote:
Hi Guys,
My question is .. which is better design
1. Single Table with 50 million records or
2. Multiple Table using inheritance to the parents table
It's not that simple.
Given your e-mail
On Tue, 2004-05-11 at 15:46 -0700, Paul Tuckfield wrote:
- the cache column shows that linux is using 2.3G for cache. (way too
much) you generally want to give memory to postgres to keep it close to
the user, not leave it unused to be claimed by linux cache (need to leave
*some* for linux
would usually be considered against security procedures, and
would get a black mark when the auditors came through.
Regards,
Andrew McMillan
-
Andrew @ Catalyst .Net .NZ Ltd, PO Box 11
sure most of the people on this
list have systems that regularly do way more than 50 inserts / second on
server hardware.
Regards,
Andrew McMillan
-
Andrew @ Catalyst .Net .NZ Ltd, PO
potentially make things
worse (depending on implementation) through double-handling of the data.
As others have said too: 100 is just a configuration setting in
postgresql.conf - not an implemented limit.
Cheers,
Andrew McMillan
On Wed, 2003-07-23 at 00:53, Alexander Priem wrote:
Wow, I never figured how many different RAID configurations one could think
of :)
After reading lots of material, forums and of course, this mailing-list, I
think I am going for a RAID5 configuration of 6 disks (18Gb, 15.000 rpm
each),
23 matches
Mail list logo